Parse LOAD statement properly

Fix #131

Might help to fix phpmyadmin/phpmyadmin#12345

Signed-off-by: Deven Bansod <devenbansod.bits@gmail.com>

1 files changed, 45 insertions, 0 deletions

diff --git a/tests/Parser/LoadStatementTest.php b/tests/Parser/LoadStatementTest.php
new file mode 100644
index 0000000..32b5707
--- /dev/null
+++ b/tests/Parser/LoadStatementTest.php
@@ -0,0 +1,45 @@
+<?php
+
+namespace PhpMyAdmin\SqlParser\Tests\Parser;
+
+use PhpMyAdmin\SqlParser\Parser;
+use PhpMyAdmin\SqlParser\Tests\TestCase;
+
+class LoadStatementTest extends TestCase
+{
+    public function testLoadOptions()
+    {
+        $data = $this->getData('parser/parseLoad1');
+        $parser = new Parser($data['query']);
+        $stmt = $parser->statements[0];
+        $this->assertEquals(10, $stmt->options->has('CONCURRENT'));
+    }
+
+    /**
+     * @dataProvider testLoadProvider
+     *
+     * @param mixed $test
+     */
+    public function testLoad($test)
+    {
+        $this->runParserTest($test);
+    }
+
+    public function testLoadProvider()
+    {
+        return array(
+            array('parser/parseLoad1'),
+            array('parser/parseLoad2'),
+            array('parser/parseLoad3'),
+            array('parser/parseLoad4'),
+            array('parser/parseLoad5'),
+            array('parser/parseLoad6'),
+            array('parser/parseLoadErr1'),
+            array('parser/parseLoadErr2'),
+            array('parser/parseLoadErr3'),
+            array('parser/parseLoadErr4'),
+            array('parser/parseLoadErr5'),
+            array('parser/parseLoadErr6')
+        );
+    }
+}