Merge pull request #209 from devenbansod/test/create-replace-view

Add tests for builder of CREATE or REPLACE VIEW statement

Signed-off-by: William Desportes <williamdes@wdes.fr>

1 files changed, 12 insertions, 0 deletions

diff --git a/tests/Builder/CreateStatementTest.php b/tests/Builder/CreateStatementTest.php
index 9a9900b..eee093d 100644
--- a/tests/Builder/CreateStatementTest.php
+++ b/tests/Builder/CreateStatementTest.php
@@ -271,6 +271,18 @@ EOT
             'SELECT id, first_name FROM employee WHERE id = 1 ',
             $stmt->build()
         );
+
+        $parser = new Parser(
+            'CREATE OR REPLACE VIEW myView (vid, vfirstname) AS ' .
+            'SELECT id, first_name FROM employee WHERE id = 1'
+        );
+        $stmt = $parser->statements[0];
+
+        $this->assertEquals(
+            'CREATE OR REPLACE VIEW myView (vid, vfirstname) AS  ' .
+            'SELECT id, first_name FROM employee WHERE id = 1 ',
+            $stmt->build()
+        );
     }
 
     public function testBuilderTrigger()