phpmyadmin
diff --git a/‎tests/Builder/CreateStatementTest.php‎
Lines changed: 14 additions & 0 deletions b/‎tests/Builder/CreateStatementTest.php‎
Lines changed: 14 additions & 0 deletions
diff --git a/‎tests/Parser/CreateStatementTest.php‎
Lines changed: 1 addition & 0 deletions b/‎tests/Parser/CreateStatementTest.php‎
Lines changed: 1 addition & 0 deletions
diff --git a/‎tests/Parser/SelectStatementTest.php‎
Lines changed: 1 addition & 0 deletions b/‎tests/Parser/SelectStatementTest.php‎
Lines changed: 1 addition & 0 deletions
diff --git a/‎tests/data/parser/parseCreateOrReplaceView1.in‎
Lines changed: 1 addition & 0 deletions b/‎tests/data/parser/parseCreateOrReplaceView1.in‎
Lines changed: 1 addition & 0 deletions
@@ -301,6 +301,20 @@ public function testBuilderPartitionsEngine(string $query): void
 
     public function testBuilderView(): void
     {
+        $parser = new Parser(
+            'CREATE OR REPLACE VIEW xviewmytable  AS SELECT mytable.id '
+            . 'AS id, mytable.personid AS personid FROM mytable '
+            . 'WHERE (mytable.birth > \'1990-01-19\') GROUP BY mytable.personid  ;'
+        );
+        $stmt = $parser->statements[0];
+
+        $this->assertEquals(
+            'CREATE OR REPLACE VIEW xviewmytable  AS SELECT mytable.id '
+            . 'AS `id`, mytable.personid AS `personid` FROM mytable '
+            . 'WHERE (mytable.birth > \'1990-01-19\') GROUP BY mytable.personid ',
+            $stmt->build()
+        );
+
         $parser = new Parser(
             'CREATE VIEW myView (vid, vfirstname) AS ' .
             'SELECT id, first_name FROM employee WHERE id = 1'
 
@@ -67,6 +67,7 @@ public static function createProvider(): array
             ['parser/parseCreateViewWithWrongSyntax'],
             ['parser/parseCreateViewWithUnion'],
             ['parser/parseCreateViewAsWithAs'],
+            ['parser/parseCreateOrReplaceView1'],
         ];
     }
 }
@@ -45,6 +45,7 @@ public static function selectProvider(): array
             ['parser/parseSelect13'],
             ['parser/parseSelect14'],
             ['parser/parseSelect15'],
+            ['parser/parseSelect16'],
             ['parser/parseSelectErr1'],
             ['parser/parseSelectErr2'],
             ['parser/parseSelectNested'],
 
@@ -0,0 +1 @@
+CREATE OR REPLACE VIEW xviewmytable  AS SELECT mytable.id AS id, mytable.personid AS personid FROM mytable WHERE (mytable.birth > '1990-01-19') GROUP BY mytable.personid  ;
Original file line number	Diff line number	Diff line change
`@@ -67,6 +67,7 @@ public static function createProvider(): array`
`67`	`67`	`['parser/parseCreateViewWithWrongSyntax'],`
`68`	`68`	`['parser/parseCreateViewWithUnion'],`
`69`	`69`	`['parser/parseCreateViewAsWithAs'],`
	`70`	`+ ['parser/parseCreateOrReplaceView1'],`
`70`	`71`	`];`
`71`	`72`	`}`
`72`	`73`	`}`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+CREATE OR REPLACE VIEW xviewmytable AS SELECT mytable.id AS id, mytable.personid AS personid FROM mytable WHERE (mytable.birth > '1990-01-19') GROUP BY mytable.personid ;`