summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMichal Čihař <michal@cihar.com>2016-09-13 10:47:35 +0200
committerMichal Čihař <michal@cihar.com>2016-09-13 10:47:41 +0200
commit98c2a72dd19542d80dcee63eb50c199e5f9a2935 (patch)
tree8d97349d7ed9544aad8f448af08d10c437d72f8d
parentc7cc3edb3503d5210dad71e0f6fbf6e436b44f79 (diff)
downloadsql-parser-98c2a72dd19542d80dcee63eb50c199e5f9a2935.zip
sql-parser-98c2a72dd19542d80dcee63eb50c199e5f9a2935.tar.gz
sql-parser-98c2a72dd19542d80dcee63eb50c199e5f9a2935.tar.bz2
Add test for building INSERT ... SELECT ...v3.4.5
Issue #76 Signed-off-by: Michal Čihař <michal@cihar.com>
-rw-r--r--tests/Builder/InsertStatementTest.php11
1 files changed, 11 insertions, 0 deletions
diff --git a/tests/Builder/InsertStatementTest.php b/tests/Builder/InsertStatementTest.php
index 5dd6bc9..3fe6dd5 100644
--- a/tests/Builder/InsertStatementTest.php
+++ b/tests/Builder/InsertStatementTest.php
@@ -42,5 +42,16 @@ class InsertStatementTest extends TestCase
'INSERT INTO tbl SET FOO = 1',
$stmt->build()
);
+
+ /* Assertion 4 */
+ /* INSERT ... SELECT ... */
+ $parser = new Parser(
+ 'INSERT INTO tbl SELECT * FROM bar'
+ );
+ $stmt = $parser->statements[0];
+ $this->assertEquals(
+ 'INSERT INTO tbl SELECT * FROM bar ',
+ $stmt->build()
+ );
}
}