1 files changed, 11 insertions, 0 deletions
diff --git a/tests/Builder/InsertStatementTest.php b/tests/Builder/InsertStatementTest.php
index 3fe6dd5..d27726a 100644
--- a/tests/Builder/InsertStatementTest.php
+++ b/tests/Builder/InsertStatementTest.php
@@ -53,5 +53,16 @@ class InsertStatementTest extends TestCase
             'INSERT  INTO tbl SELECT  * FROM bar ',
             $stmt->build()
         );
+
+        /* Assertion 5 */
+        /* INSERT ... ON DUPLICATE KEY UPDATE ... */
+        $parser = new Parser(
+            'INSERT INTO tbl SELECT * FROM bar ON DUPLICATE KEY UPDATE baz = 1'
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            'INSERT  INTO tbl SELECT  * FROM bar  ON DUPLICATE KEY UPDATE baz = 1',
+            $stmt->build()
+        );
     }
 }