Merge pull request #77 from devenbansod/fix_48

Fix parsing of REPLACE INTO ... Statements

11 files changed, 209 insertions, 18 deletions

diff --git a/src/Statements/ReplaceStatement.php b/src/Statements/ReplaceStatement.php
index 10c5e63..df00272 100644
--- a/src/Statements/ReplaceStatement.php
+++ b/src/Statements/ReplaceStatement.php
@@ -8,10 +8,15 @@
  */
 namespace SqlParser\Statements;
 
+use SqlParser\Parser;
+use SqlParser\Token;
+use SqlParser\TokensList;
 use SqlParser\Statement;
+use SqlParser\Statements\SelectStatement;
+use SqlParser\Components\Array2d;
 use SqlParser\Components\IntoKeyword;
+use SqlParser\Components\OptionsArray;
 use SqlParser\Components\SetOperation;
-use SqlParser\Components\Array2d;
 
 /**
  * `REPLACE` statement.
@@ -26,6 +31,14 @@ use SqlParser\Components\Array2d;
  *     [INTO] tbl_name
  *     SET col_name={expr | DEFAULT}, ...
  *
+ * or
+ *
+ * REPLACE [LOW_PRIORITY | DELAYED]
+ *   [INTO] tbl_name
+ *   [PARTITION (partition_name,...)]
+ *   [(col_name,...)]
+ *   SELECT ...
+ *
  * @category   Statements
  * @package    SqlParser
  * @subpackage Statements
@@ -46,22 +59,6 @@ class ReplaceStatement extends Statement
     );
 
     /**
-     * The clauses of this statement, in order.
-     *
-     * @see Statement::$CLAUSES
-     *
-     * @var array
-     */
-    public static $CLAUSES = array(
-        'REPLACE'                       => array('REPLACE',     2),
-        // Used for options.
-        '_OPTIONS'                      => array('_OPTIONS',    1),
-        'INTO'                          => array('FROM',        3),
-        'VALUES'                        => array('VALUES',      1),
-        'SET'                           => array('PARTITION',   3),
-    );
-
-    /**
      * Tables used as target for this statement.
      *
      * @var IntoKeyword
@@ -76,9 +73,136 @@ class ReplaceStatement extends Statement
     public $values;
 
     /**
-     * The replaced values.
+     * If SET clause is present
+     * holds the SetOperation
      *
      * @var SetOperation[]
      */
     public $set;
+
+    /**
+     * If SELECT clause is present
+     * holds the SelectStatement
+     *
+     * @var SelectStatement
+     */
+    public $select;
+
+    /**
+     * @return string
+     */
+    public function build()
+    {
+        $ret = 'REPLACE ' . $this->options
+            . ' INTO ' . $this->into;
+
+        if ($this->values != NULL && count($this->values) > 0) {
+            $ret .= ' VALUES ' . Array2d::build($this->values);
+        } elseif ($this->set != NULL && count($this->set) > 0) {
+            $ret .= ' SET ' . SetOperation::build($this->set);
+        } elseif ($this->select != NULL && count($this->select) > 0) {
+            $ret .= ' ' . $this->select->build();
+        }
+
+        return $ret;
+    }
+
+
+    /**
+     * @param Parser     $parser The instance that requests parsing.
+     * @param TokensList $list   The list of tokens to be parsed.
+     *
+     * @return void
+     */
+    public function parse(Parser $parser, TokensList $list)
+    {
+        ++$list->idx; // Skipping `REPLACE`.
+
+        // parse any options if provided
+        $this->options = OptionsArray::parse(
+            $parser,
+            $list,
+            static::$OPTIONS
+        );
+        ++$list->idx;
+
+        $token = $list->tokens[$list->idx];
+
+        /**
+         * The state of the parser.
+         *
+         * Below are the states of the parser.
+         *
+         *      0 ---------------------------------[ INTO ]----------------------------------> 1
+         *
+         *      1 -------------------------[ VALUES/VALUE/SET/SELECT ]-----------------------> 2
+         *
+         * @var int $state
+         */
+        $state = 0;
+
+        for (; $list->idx < $list->count; ++$list->idx) {
+            /**
+             * Token parsed at this moment.
+             *
+             * @var Token $token
+             */
+            $token = $list->tokens[$list->idx];
+
+            // End of statement.
+            if ($token->type === Token::TYPE_DELIMITER) {
+                break;
+            }
+
+            // Skipping whitespaces and comments.
+            if (($token->type === Token::TYPE_WHITESPACE) || ($token->type === Token::TYPE_COMMENT)) {
+                continue;
+            }
+
+            if ($state === 0) {
+                if ($token->type === Token::TYPE_KEYWORD
+                    && $token->value !== 'INTO'
+                ) {
+                    $parser->error(__('Unexpected keyword.'), $token);
+                    break;
+                } else {
+                    ++$list->idx;
+                    $this->into = IntoKeyword::parse($parser, $list);
+                }
+
+                $state = 1;
+            } elseif ($state === 1) {
+                if ($token->type === Token::TYPE_KEYWORD) {
+                    if ($token->value === 'VALUE'
+                        || $token->value === 'VALUES'
+                    ) {
+                        ++$list->idx; // skip VALUES
+
+                        $this->values = Array2d::parse($parser, $list);
+                    } elseif ($token->value === 'SET') {
+                        ++$list->idx; // skip SET
+
+                        $this->set = SetOperation::parse($parser, $list);
+                    } elseif ($token->value === 'SELECT') {
+                        $this->select = new SelectStatement($parser, $list);
+                    } else {
+                        $parser->error(
+                            __('Unexpected keyword.'),
+                            $token
+                        );
+                        break;
+                    }
+                    $state = 2;
+                } else {
+                    $parser->error(
+                        __('Unexpected token.'),
+                        $token
+                    );
+                    break;
+                }
+            }
+        }
+
+        --$list->idx;
+    }
 }
diff --git a/tests/Builder/ReplaceStatementTest.php b/tests/Builder/ReplaceStatementTest.php
new file mode 100644
index 0000000..f25a58a
--- /dev/null
+++ b/tests/Builder/ReplaceStatementTest.php
@@ -0,0 +1,47 @@
+<?php
+
+namespace SqlParser\Tests\Builder;
+
+use SqlParser\Parser;
+
+use SqlParser\Tests\TestCase;
+
+class ReplaceStatementTest extends TestCase
+{
+
+    public function testBuilder()
+    {
+        $parser = new Parser(
+            'REPLACE INTO tbl(col1, col2, col3) VALUES (1, "str", 3.14)'
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            'REPLACE  INTO tbl(`col1`, `col2`, `col3`) VALUES (1, "str", 3.14)',
+            $stmt->build()
+        );
+    }
+
+    public function testBuilderSet()
+    {
+        $parser = new Parser(
+            'REPLACE INTO tbl(col1, col2, col3) SET col1=1, col2="str", col3=3.14'
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            'REPLACE  INTO tbl(`col1`, `col2`, `col3`) SET col1 = 1, col2 = "str", col3 = 3.14',
+            $stmt->build()
+        );
+    }
+
+    public function testBuilderSelect()
+    {
+        $parser = new Parser(
+            'REPLACE INTO tbl(col1, col2, col3) SELECT col1, col2, col3 FROM tbl2'
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            'REPLACE  INTO tbl(`col1`, `col2`, `col3`) SELECT  col1, col2, col3 FROM tbl2 ',
+            $stmt->build()
+        );
+    }
+}
diff --git a/tests/Parser/ReplaceStatementTest.php b/tests/Parser/ReplaceStatementTest.php
index 8556a3c..915ee85 100644
--- a/tests/Parser/ReplaceStatementTest.php
+++ b/tests/Parser/ReplaceStatementTest.php
@@ -20,6 +20,10 @@ class ReplaceStatementTest extends TestCase
         return array(
             array('parser/parseReplace'),
             array('parser/parseReplace2'),
+            array('parser/parseReplaceValues'),
+            array('parser/parseReplaceSet'),
+            array('parser/parseReplaceSelect'),
+            array('parser/parseReplaceErr'),
         );
     }
 }
diff --git a/tests/data/parser/parseReplaceErr.in b/tests/data/parser/parseReplaceErr.in
new file mode 100644
index 0000000..02ddd04
--- /dev/null
+++ b/tests/data/parser/parseReplaceErr.in
@@ -0,0 +1,3 @@
+REPLACE LOW_PRIORITY
+INTO users(id, username)
+(1, 'Foo'), (2, 'Bar')
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceErr.out b/tests/data/parser/parseReplaceErr.out
new file mode 100644
index 0000000..4462584
--- /dev/null
+++ b/tests/data/parser/parseReplaceErr.out
@@ -0,0 +1,7 @@
+a:4:{s:5:"query";s:68:"REPLACE LOW_PRIORITY
+INTO users(id, username)
+(1, 'Foo'), (2, 'Bar')";s:5:"lexer";O:15:"SqlParser\Lexer":8:{s:6:"strict";b:0;s:3:"str";s:68:"REPLACE LOW_PRIORITY
+INTO users(id, username)
+(1, 'Foo'), (2, 'Bar')";s:3:"len";i:68;s:4:"last";i:68;s:4:"list";O:20:"SqlParser\TokensList":3:{s:6:"tokens";a:29:{i:0;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"REPLACE";s:5:"value";s:7:"REPLACE";s:4:"type";i:1;s:5:"flags";i:35;s:8:"position";i:0;}i:1;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:7;}i:2;O:15:"SqlParser\Token":5:{s:5:"token";s:12:"LOW_PRIORITY";s:5:"value";s:12:"LOW_PRIORITY";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:8;}i:3;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"
+";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:20;}i:4;O:15:"SqlParser\Token":5:{s:5:"token";s:4:"INTO";s:5:"value";s:4:"INTO";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:21;}i:5;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:25;}i:6;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"users";s:5:"value";s:5:"users";s:4:"type";i:0;s:5:"flags";i:0;s:8:"position";i:26;}i:7;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:31;}i:8;O:15:"SqlParser\Token":5:{s:5:"token";s:2:"id";s:5:"value";s:2:"id";s:4:"type";i:0;s:5:"flags";i:0;s:8:"position";i:32;}i:9;O:15:"SqlParser\Token":5:{s:5:"token";s:1:",";s:5:"value";s:1:",";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:34;}i:10;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:35;}i:11;O:15:"SqlParser\Token":5:{s:5:"token";s:8:"username";s:5:"value";s:8:"username";s:4:"type";i:0;s:5:"flags";i:0;s:8:"position";i:36;}i:12;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:44;}i:13;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"
+";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:45;}i:14;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:46;}i:15;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"1";s:5:"value";i:1;s:4:"type";i:6;s:5:"flags";i:0;s:8:"position";i:47;}i:16;O:15:"SqlParser\Token":5:{s:5:"token";s:1:",";s:5:"value";s:1:",";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:48;}i:17;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:49;}i:18;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"'Foo'";s:5:"value";s:3:"Foo";s:4:"type";i:7;s:5:"flags";i:1;s:8:"position";i:50;}i:19;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:55;}i:20;O:15:"SqlParser\Token":5:{s:5:"token";s:1:",";s:5:"value";s:1:",";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:56;}i:21;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:57;}i:22;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:58;}i:23;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"2";s:5:"value";i:2;s:4:"type";i:6;s:5:"flags";i:0;s:8:"position";i:59;}i:24;O:15:"SqlParser\Token":5:{s:5:"token";s:1:",";s:5:"value";s:1:",";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:60;}i:25;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:61;}i:26;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"'Bar'";s:5:"value";s:3:"Bar";s:4:"type";i:7;s:5:"flags";i:1;s:8:"position";i:62;}i:27;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:67;}i:28;O:15:"SqlParser\Token":5:{s:5:"token";N;s:5:"value";N;s:4:"type";i:9;s:5:"flags";i:0;s:8:"position";N;}}s:5:"count";i:29;s:3:"idx";i:29;}s:9:"delimiter";s:1:";";s:12:"delimiterLen";i:1;s:6:"errors";a:0:{}}s:6:"parser";O:16:"SqlParser\Parser":5:{s:4:"list";r:8;s:6:"strict";b:0;s:6:"errors";a:0:{}s:10:"statements";a:1:{i:0;O:37:"SqlParser\Statements\ReplaceStatement":7:{s:4:"into";O:32:"SqlParser\Components\IntoKeyword":3:{s:4:"type";N;s:4:"dest";O:31:"SqlParser\Components\Expression":7:{s:8:"database";N;s:5:"table";s:5:"users";s:6:"column";N;s:4:"expr";s:5:"users";s:5:"alias";N;s:8:"function";N;s:8:"subquery";N;}s:7:"columns";a:2:{i:0;s:2:"id";i:1;s:8:"username";}}s:6:"values";N;s:3:"set";N;s:6:"select";N;s:7:"options";O:33:"SqlParser\Components\OptionsArray":1:{s:7:"options";a:1:{i:1;s:12:"LOW_PRIORITY";}}s:5:"first";i:0;s:4:"last";i:13;}}s:8:"brackets";i:2;}s:6:"errors";a:2:{s:5:"lexer";a:0:{}s:6:"parser";a:5:{i:0;a:3:{i:0;s:17:"Unexpected token.";i:1;r:94;i:2;i:0;}i:1;a:3:{i:0;s:34:"Unexpected beginning of statement.";i:1;r:100;i:2;i:0;}i:2;a:3:{i:0;s:34:"Unexpected beginning of statement.";i:1;r:118;i:2;i:0;}i:3;a:3:{i:0;s:34:"Unexpected beginning of statement.";i:1;r:148;i:2;i:0;}i:4;a:3:{i:0;s:34:"Unexpected beginning of statement.";i:1;r:166;i:2;i:0;}}}}
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceSelect.in b/tests/data/parser/parseReplaceSelect.in
new file mode 100644
index 0000000..ed6f406
--- /dev/null
+++ b/tests/data/parser/parseReplaceSelect.in
@@ -0,0 +1 @@
+REPLACE INTO `a` (`value`) SELECT value  from `b`
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceSelect.out b/tests/data/parser/parseReplaceSelect.out
new file mode 100644
index 0000000..191b18b
--- /dev/null
+++ b/tests/data/parser/parseReplaceSelect.out
@@ -0,0 +1 @@
+a:4:{s:5:"query";s:49:"REPLACE INTO `a` (`value`) SELECT value  from `b`";s:5:"lexer";O:15:"SqlParser\Lexer":8:{s:6:"strict";b:0;s:3:"str";s:49:"REPLACE INTO `a` (`value`) SELECT value  from `b`";s:3:"len";i:49;s:4:"last";i:49;s:4:"list";O:20:"SqlParser\TokensList":3:{s:6:"tokens";a:18:{i:0;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"REPLACE";s:5:"value";s:7:"REPLACE";s:4:"type";i:1;s:5:"flags";i:35;s:8:"position";i:0;}i:1;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:7;}i:2;O:15:"SqlParser\Token":5:{s:5:"token";s:4:"INTO";s:5:"value";s:4:"INTO";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:8;}i:3;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:12;}i:4;O:15:"SqlParser\Token":5:{s:5:"token";s:3:"`a`";s:5:"value";s:1:"a";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:13;}i:5;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:16;}i:6;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:17;}i:7;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"`value`";s:5:"value";s:5:"value";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:18;}i:8;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:25;}i:9;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:26;}i:10;O:15:"SqlParser\Token":5:{s:5:"token";s:6:"SELECT";s:5:"value";s:6:"SELECT";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:27;}i:11;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:33;}i:12;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"value";s:5:"value";s:5:"value";s:4:"type";i:1;s:5:"flags";i:1;s:8:"position";i:34;}i:13;O:15:"SqlParser\Token":5:{s:5:"token";s:2:"  ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:39;}i:14;O:15:"SqlParser\Token":5:{s:5:"token";s:4:"from";s:5:"value";s:4:"FROM";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:41;}i:15;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:45;}i:16;O:15:"SqlParser\Token":5:{s:5:"token";s:3:"`b`";s:5:"value";s:1:"b";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:46;}i:17;O:15:"SqlParser\Token":5:{s:5:"token";N;s:5:"value";N;s:4:"type";i:9;s:5:"flags";i:0;s:8:"position";N;}}s:5:"count";i:18;s:3:"idx";i:18;}s:9:"delimiter";s:1:";";s:12:"delimiterLen";i:1;s:6:"errors";a:0:{}}s:6:"parser";O:16:"SqlParser\Parser":5:{s:4:"list";r:8;s:6:"strict";b:0;s:6:"errors";a:0:{}s:10:"statements";a:1:{i:0;O:37:"SqlParser\Statements\ReplaceStatement":7:{s:4:"into";O:32:"SqlParser\Components\IntoKeyword":3:{s:4:"type";N;s:4:"dest";O:31:"SqlParser\Components\Expression":7:{s:8:"database";N;s:5:"table";s:1:"a";s:6:"column";N;s:4:"expr";s:3:"`a`";s:5:"alias";N;s:8:"function";N;s:8:"subquery";N;}s:7:"columns";a:1:{i:0;s:5:"value";}}s:6:"values";N;s:3:"set";N;s:6:"select";O:36:"SqlParser\Statements\SelectStatement":15:{s:4:"expr";a:1:{i:0;O:31:"SqlParser\Components\Expression":7:{s:8:"database";N;s:5:"table";N;s:6:"column";s:5:"value";s:4:"expr";s:5:"value";s:5:"alias";N;s:8:"function";N;s:8:"subquery";N;}}s:4:"from";a:1:{i:0;O:31:"SqlParser\Components\Expression":7:{s:8:"database";N;s:5:"table";s:1:"b";s:6:"column";N;s:4:"expr";s:3:"`b`";s:5:"alias";N;s:8:"function";N;s:8:"subquery";N;}}s:9:"partition";N;s:5:"where";N;s:5:"group";N;s:6:"having";N;s:5:"order";N;s:5:"limit";N;s:9:"procedure";N;s:4:"into";N;s:4:"join";N;s:5:"union";a:0:{}s:7:"options";O:33:"SqlParser\Components\OptionsArray":1:{s:7:"options";a:0:{}}s:5:"first";i:10;s:4:"last";i:16;}s:7:"options";O:33:"SqlParser\Components\OptionsArray":1:{s:7:"options";a:0:{}}s:5:"first";i:0;s:4:"last";i:16;}}s:8:"brackets";i:0;}s:6:"errors";a:2:{s:5:"lexer";a:0:{}s:6:"parser";a:0:{}}}
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceSet.in b/tests/data/parser/parseReplaceSet.in
new file mode 100644
index 0000000..d425fa2
--- /dev/null
+++ b/tests/data/parser/parseReplaceSet.in
@@ -0,0 +1 @@
+REPLACE INTO `a` (`value`) SET value = '123'
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceSet.out b/tests/data/parser/parseReplaceSet.out
new file mode 100644
index 0000000..4c1c571
--- /dev/null
+++ b/tests/data/parser/parseReplaceSet.out
@@ -0,0 +1 @@
+a:4:{s:5:"query";s:44:"REPLACE INTO `a` (`value`) SET value = '123'";s:5:"lexer";O:15:"SqlParser\Lexer":8:{s:6:"strict";b:0;s:3:"str";s:44:"REPLACE INTO `a` (`value`) SET value = '123'";s:3:"len";i:44;s:4:"last";i:44;s:4:"list";O:20:"SqlParser\TokensList":3:{s:6:"tokens";a:18:{i:0;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"REPLACE";s:5:"value";s:7:"REPLACE";s:4:"type";i:1;s:5:"flags";i:35;s:8:"position";i:0;}i:1;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:7;}i:2;O:15:"SqlParser\Token":5:{s:5:"token";s:4:"INTO";s:5:"value";s:4:"INTO";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:8;}i:3;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:12;}i:4;O:15:"SqlParser\Token":5:{s:5:"token";s:3:"`a`";s:5:"value";s:1:"a";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:13;}i:5;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:16;}i:6;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:17;}i:7;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"`value`";s:5:"value";s:5:"value";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:18;}i:8;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:25;}i:9;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:26;}i:10;O:15:"SqlParser\Token":5:{s:5:"token";s:3:"SET";s:5:"value";s:3:"SET";s:4:"type";i:1;s:5:"flags";i:11;s:8:"position";i:27;}i:11;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:30;}i:12;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"value";s:5:"value";s:5:"value";s:4:"type";i:1;s:5:"flags";i:1;s:8:"position";i:31;}i:13;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:36;}i:14;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"=";s:5:"value";s:1:"=";s:4:"type";i:2;s:5:"flags";i:2;s:8:"position";i:37;}i:15;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:38;}i:16;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"'123'";s:5:"value";s:3:"123";s:4:"type";i:7;s:5:"flags";i:1;s:8:"position";i:39;}i:17;O:15:"SqlParser\Token":5:{s:5:"token";N;s:5:"value";N;s:4:"type";i:9;s:5:"flags";i:0;s:8:"position";N;}}s:5:"count";i:18;s:3:"idx";i:18;}s:9:"delimiter";s:1:";";s:12:"delimiterLen";i:1;s:6:"errors";a:0:{}}s:6:"parser";O:16:"SqlParser\Parser":5:{s:4:"list";r:8;s:6:"strict";b:0;s:6:"errors";a:0:{}s:10:"statements";a:1:{i:0;O:37:"SqlParser\Statements\ReplaceStatement":7:{s:4:"into";O:32:"SqlParser\Components\IntoKeyword":3:{s:4:"type";N;s:4:"dest";O:31:"SqlParser\Components\Expression":7:{s:8:"database";N;s:5:"table";s:1:"a";s:6:"column";N;s:4:"expr";s:3:"`a`";s:5:"alias";N;s:8:"function";N;s:8:"subquery";N;}s:7:"columns";a:1:{i:0;s:5:"value";}}s:6:"values";N;s:3:"set";a:1:{i:0;O:33:"SqlParser\Components\SetOperation":2:{s:6:"column";s:5:"value";s:5:"value";s:5:"'123'";}}s:6:"select";N;s:7:"options";O:33:"SqlParser\Components\OptionsArray":1:{s:7:"options";a:0:{}}s:5:"first";i:0;s:4:"last";i:16;}}s:8:"brackets";i:0;}s:6:"errors";a:2:{s:5:"lexer";a:0:{}s:6:"parser";a:0:{}}}
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceValues.in b/tests/data/parser/parseReplaceValues.in
new file mode 100644
index 0000000..24f6c7e
--- /dev/null
+++ b/tests/data/parser/parseReplaceValues.in
@@ -0,0 +1 @@
+REPLACE INTO `a` (`value`) VALUES ('123'), ('123')
\ No newline at end of file
diff --git a/tests/data/parser/parseReplaceValues.out b/tests/data/parser/parseReplaceValues.out
new file mode 100644
index 0000000..a4800e7
--- /dev/null
+++ b/tests/data/parser/parseReplaceValues.out
@@ -0,0 +1 @@
+a:4:{s:5:"query";s:50:"REPLACE INTO `a` (`value`) VALUES ('123'), ('123')";s:5:"lexer";O:15:"SqlParser\Lexer":8:{s:6:"strict";b:0;s:3:"str";s:50:"REPLACE INTO `a` (`value`) VALUES ('123'), ('123')";s:3:"len";i:50;s:4:"last";i:50;s:4:"list";O:20:"SqlParser\TokensList":3:{s:6:"tokens";a:21:{i:0;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"REPLACE";s:5:"value";s:7:"REPLACE";s:4:"type";i:1;s:5:"flags";i:35;s:8:"position";i:0;}i:1;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:7;}i:2;O:15:"SqlParser\Token":5:{s:5:"token";s:4:"INTO";s:5:"value";s:4:"INTO";s:4:"type";i:1;s:5:"flags";i:3;s:8:"position";i:8;}i:3;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:12;}i:4;O:15:"SqlParser\Token":5:{s:5:"token";s:3:"`a`";s:5:"value";s:1:"a";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:13;}i:5;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:16;}i:6;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:17;}i:7;O:15:"SqlParser\Token":5:{s:5:"token";s:7:"`value`";s:5:"value";s:5:"value";s:4:"type";i:8;s:5:"flags";i:2;s:8:"position";i:18;}i:8;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:25;}i:9;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:26;}i:10;O:15:"SqlParser\Token":5:{s:5:"token";s:6:"VALUES";s:5:"value";s:6:"VALUES";s:4:"type";i:1;s:5:"flags";i:35;s:8:"position";i:27;}i:11;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:33;}i:12;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:34;}i:13;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"'123'";s:5:"value";s:3:"123";s:4:"type";i:7;s:5:"flags";i:1;s:8:"position";i:35;}i:14;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:40;}i:15;O:15:"SqlParser\Token":5:{s:5:"token";s:1:",";s:5:"value";s:1:",";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:41;}i:16;O:15:"SqlParser\Token":5:{s:5:"token";s:1:" ";s:5:"value";s:1:" ";s:4:"type";i:3;s:5:"flags";i:0;s:8:"position";i:42;}i:17;O:15:"SqlParser\Token":5:{s:5:"token";s:1:"(";s:5:"value";s:1:"(";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:43;}i:18;O:15:"SqlParser\Token":5:{s:5:"token";s:5:"'123'";s:5:"value";s:3:"123";s:4:"type";i:7;s:5:"flags";i:1;s:8:"position";i:44;}i:19;O:15:"SqlParser\Token":5:{s:5:"token";s:1:")";s:5:"value";s:1:")";s:4:"type";i:2;s:5:"flags";i:16;s:8:"position";i:49;}i:20;O:15:"SqlParser\Token":5:{s:5:"token";N;s:5:"value";N;s:4:"type";i:9;s:5:"flags";i:0;s:8:"position";N;}}s:5:"count";i:21;s:3:"idx";i:21;}s:9:"delimiter";s:1:";";s:12:"delimiterLen";i:1;s:6:"errors";a:0:{}}s:6:"parser";O:16:"SqlParser\Parser":5:{s:4:"list";r:8;s:6:"strict";b:0;s:6:"errors";a:0:{}s:10:"statements";a:1:{i:0;O:37:"SqlParser\Statements\ReplaceStatement":7:{s:4:"into";O:32:"SqlParser\Components\IntoKeyword":3:{s:4:"type";N;s:4:"dest";O:31:"SqlParser\Components\Expression":7:{s:8:"database";N;s:5:"table";s:1:"a";s:6:"column";N;s:4:"expr";s:3:"`a`";s:5:"alias";N;s:8:"function";N;s:8:"subquery";N;}s:7:"columns";a:1:{i:0;s:5:"value";}}s:6:"values";a:2:{i:0;O:29:"SqlParser\Components\ArrayObj":2:{s:3:"raw";a:1:{i:0;s:5:"'123'";}s:6:"values";a:1:{i:0;s:3:"123";}}i:1;O:29:"SqlParser\Components\ArrayObj":2:{s:3:"raw";a:1:{i:0;s:5:"'123'";}s:6:"values";a:1:{i:0;s:3:"123";}}}s:3:"set";N;s:6:"select";N;s:7:"options";O:33:"SqlParser\Components\OptionsArray":1:{s:7:"options";a:0:{}}s:5:"first";i:0;s:4:"last";i:19;}}s:8:"brackets";i:0;}s:6:"errors";a:2:{s:5:"lexer";a:0:{}s:6:"parser";a:0:{}}}
\ No newline at end of file