phpmyadmin
diff --git a/‎src/Statements/InsertStatement.php
Lines changed: 2 additions & 2 deletions b/‎src/Statements/InsertStatement.php
Lines changed: 2 additions & 2 deletions
diff --git a/‎src/Statements/ReplaceStatement.php
Lines changed: 2 additions & 1 deletion b/‎src/Statements/ReplaceStatement.php
Lines changed: 2 additions & 1 deletion
diff --git a/‎tests/Builder/InsertStatementTest.php
Lines changed: 11 additions & 0 deletions b/‎tests/Builder/InsertStatementTest.php
Lines changed: 11 additions & 0 deletions
diff --git a/‎tests/Builder/ReplaceStatementTest.php
Lines changed: 12 additions & 0 deletions b/‎tests/Builder/ReplaceStatementTest.php
Lines changed: 12 additions & 0 deletions
@@ -110,8 +110,8 @@ class InsertStatement extends Statement
      */
     public function build()
     {
-        $ret = 'INSERT ' . $this->options
-            . 'INTO ' . $this->into;
+        $ret = 'INSERT ' . $this->options;
+        $ret = trim($ret) . ' INTO ' . $this->into;
 
         if (! is_null($this->values) && count($this->values) > 0) {
             $ret .= ' VALUES ' . Array2d::build($this->values);
 
@@ -87,7 +87,8 @@ class ReplaceStatement extends Statement
      */
     public function build()
     {
-        $ret = 'REPLACE ' . $this->options . 'INTO ' . $this->into;
+        $ret = 'REPLACE ' . $this->options;
+        $ret = trim($ret) . ' INTO ' . $this->into;
 
         if (! is_null($this->values) && count($this->values) > 0) {
             $ret .= ' VALUES ' . Array2d::build($this->values);
 
@@ -63,5 +63,16 @@ public function testBuilder()
             'INSERT INTO tbl SELECT * FROM bar ON DUPLICATE KEY UPDATE baz = 1',
             $stmt->build()
         );
+
+        /* Assertion 6 */
+        /* INSERT [OPTIONS] INTO ... */
+        $parser = new Parser(
+            'INSERT DELAYED IGNORE INTO tbl SELECT * FROM bar'
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            'INSERT DELAYED IGNORE INTO tbl SELECT * FROM bar',
+            $stmt->build()
+        );
     }
 }
@@ -43,4 +43,16 @@ public function testBuilderSelect()
             $stmt->build()
         );
     }
+
+    public function testBuilderSelectDelayed()
+    {
+        $parser = new Parser(
+            'REPLACE DELAYED INTO tbl(col1, col2, col3) SELECT col1, col2, col3 FROM tbl2'
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            'REPLACE DELAYED INTO tbl(`col1`, `col2`, `col3`) SELECT col1, col2, col3 FROM tbl2',
+            $stmt->build()
+        );
+    }
 }
Original file line number	Diff line number	Diff line change
`@@ -87,7 +87,8 @@ class ReplaceStatement extends Statement`
`87`	`87`	`*/`
`88`	`88`	`public function build()`
`89`	`89`	`{`
`90`		`- $ret = 'REPLACE ' . $this->options . 'INTO ' . $this->into;`
	`90`	`+ $ret = 'REPLACE ' . $this->options;`
	`91`	`+ $ret = trim($ret) . ' INTO ' . $this->into;`
`91`	`92`
`92`	`93`	`if (! is_null($this->values) && count($this->values) > 0) {`
`93`	`94`	`$ret .= ' VALUES ' . Array2d::build($this->values);`