Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
In MySQL, JSON is not a reserved word, but in MariaDB it is.
MySQL 5.7 |
MariaDB [test]> CREATE TABLE json (j INT); |
Query OK, 0 rows affected (0.54 sec) |
 |
MariaDB [test]> CREATE TABLE j (json INT); |
Query OK, 0 rows affected (0.37 sec) |
MariaDB 10.2 |
MariaDB [test]> CREATE TABLE json (j INT); |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json (j INT)' at line 1 |
MariaDB [test]> CREATE TABLE j (json INT); |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json INT)' at line 1 |
Attachments
Issue Links
- relates to
-
MDEV-9143 JSON_xxx functions
- Closed