Merge pull request #107 from devenbansod/fix_105

Fix #105: Fix  parsing of FIELDS and LINES options in Select..Into

1 files changed, 17 insertions, 0 deletions

diff --git a/tests/Builder/SelectStatementTest.php b/tests/Builder/SelectStatementTest.php
index a2dd5af..173ff92 100644
--- a/tests/Builder/SelectStatementTest.php
+++ b/tests/Builder/SelectStatementTest.php
@@ -76,4 +76,21 @@ class SelectStatementTest extends TestCase
             $stmt->build()
         );
     }
+
+
+    public function testBuilderIntoOptions()
+    {
+        /* Assertion 1 */
+        $query = 'SELECT  a, b, a+b INTO OUTFILE "/tmp/result.txt"'
+            . ' COLUMNS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'"\''
+            . ' LINES TERMINATED BY \'\n\''
+            . ' FROM test_table ';
+        $parser = new Parser($query);
+        $stmt = $parser->statements[0];
+
+        $this->assertEquals(
+            $query,
+            $stmt->build()
+        );
+    }
 }