Manage "CHECK" keyword

Even if this keyword is ignored by MySQL, it should be parsed. Ref: #167 Signed-off-by: Hugues Peccatte <hugues.peccatte@aareon.fr>
phpmyadmin · Oct 28, 2019 · e517fbb · e517fbb
1 parent b35c21f
commit e517fbb
Show file tree

Hide file tree

Showing 2 changed files with 22 additions and 1 deletion.
diff --git a/src/Components/CreateDefinition.php b/src/Components/CreateDefinition.php
@@ -79,7 +79,12 @@ class CreateDefinition extends Component
         ),
         'VIRTUAL' => 10,
         'PERSISTENT' => 11,
-        'STORED' => 11
+        'STORED' => 11,
+        'CHECK' => array(
+            12,
+            'expr',
+            array('parenthesesDelimited' => true),
+        )
         // Common entries.
         //
         // NOTE: Some of the common options are not in the same order which

diff --git a/tests/Components/CreateDefinitionTest.php b/tests/Components/CreateDefinitionTest.php
@@ -63,4 +63,20 @@ public function testBuild()
             CreateDefinition::build($parser->statements[0]->fields[1])
         );
     }
+
+    public function testBuild2()
+    {
+        $parser = new Parser(
+            'CREATE TABLE `payment` (' .
+            '-- snippet' . "\n" .
+            '`customer_id` smallint(5) unsigned NOT NULL,' .
+            '`customer_data` longtext CHARACTER SET utf8mb4 CHARSET utf8mb4_bin NOT NULL CHECK (json_valid(customer_data)),' .
+            'CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE' .
+            ') ENGINE=InnoDB"'
+        );
+        $this->assertEquals(
+            'CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE',
+            CreateDefinition::build($parser->statements[0]->fields[2])
+        );
+    }
 }