Fixed parsing of table with DEFAULT and COMMENT.

Fixes #39

Signed-off-by: Michal Čihař <michal@cihar.com>

2 files changed, 22 insertions, 0 deletions

diff --git a/src/Components/Expression.php b/src/Components/Expression.php
index 0b9f215..8d6471c 100644
--- a/src/Components/Expression.php
+++ b/src/Components/Expression.php
@@ -254,6 +254,9 @@ class Expression extends Component
                         continue;
                     }
                     $isExpr = true;
+                } elseif ($brackets === 0 && count($ret->expr) > 0) {
+                    /* End of expression */
+                    break;
                 }
             }
 
diff --git a/tests/Builder/CreateStatementTest.php b/tests/Builder/CreateStatementTest.php
index 2318a46..6e41d5d 100644
--- a/tests/Builder/CreateStatementTest.php
+++ b/tests/Builder/CreateStatementTest.php
@@ -42,6 +42,25 @@ class CreateStatementTest extends TestCase
         );
     }
 
+    public function testBuilderDefaultComment()
+    {
+        $parser = new Parser(
+            "CREATE TABLE `wp_audio` (" .
+            " `somedata` int(11) DEFAULT NULL COMMENT 'ma data', " .
+            " `someinfo` int(11) DEFAULT NULL COMMENT 'ma info' ".
+            " )"
+        );
+        $stmt = $parser->statements[0];
+
+        $this->assertEquals(
+            "CREATE TABLE `wp_audio` (\n" .
+            "  `somedata` int(11) DEFAULT NULL COMMENT 'ma data',\n" .
+            "  `someinfo` int(11) DEFAULT NULL COMMENT 'ma info'\n".
+            ") ",
+            $stmt->build()
+        );
+    }
+
     public function testBuilderTable()
     {
         $stmt = new CreateStatement();