Properly parse CREATE TABLE [AS] SELECT

Fixes https://github.com/phpmyadmin/phpmyadmin/issues/12109

Signed-off-by: Michal Čihař <michal@cihar.com>

1 files changed, 11 insertions, 0 deletions

diff --git a/tests/Components/CreateDefinitionTest.php b/tests/Components/CreateDefinitionTest.php
index a7b7f86..4d0094d 100644
--- a/tests/Components/CreateDefinitionTest.php
+++ b/tests/Components/CreateDefinitionTest.php
@@ -64,4 +64,15 @@ class CreateDefinitionTest extends TestCase
             CreateDefinition::build($parser->statements[0]->fields[1])
         );
     }
+
+    public function testBuildSelect()
+    {
+        $parser = new Parser(
+            'CREATE TABLE new_tbl SELECT * FROM orig_tbl'
+        );
+        $this->assertEquals(
+            'CREATE TABLE new_tbl SELECT  * FROM orig_tbl ',
+            $parser->statements[0]->build()
+        );
+    }
 }