dolt
dolt copied to clipboard
CREATE TABLE with RESERVED KEYWORD `status` breaks
CREATE TABLE status(pk int)
throws the following error:
Error parsing SQL
syntax error at position 20 near 'status'
These failing reserved keyword tests are skipped and documented here:
This works now.
mysql> CREATE TABLE status(pk int);
Query OK, 0 rows affected (0.01 sec)
mysql> show create table status;
+--------+-----------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+-----------------------------------------------------------------------------------------------------+
| status | CREATE TABLE `status` (
`pk` int
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin |
+--------+-----------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)