dolt icon indicating copy to clipboard operation
dolt copied to clipboard

CREATE TABLE with RESERVED KEYWORD `status` breaks

Open VinaiRachakonda opened this issue 2 years ago • 1 comments

CREATE TABLE status(pk int) throws the following error:

Error parsing SQL
syntax error at position 20 near 'status'

VinaiRachakonda avatar Mar 21 '22 19:03 VinaiRachakonda

These failing reserved keyword tests are skipped and documented here:

VinaiRachakonda avatar Aug 04 '22 18:08 VinaiRachakonda

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)

timsehn avatar Aug 30 '22 23:08 timsehn