Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.2.14
-
None
-
CentOS Linux release 7.4.1708 (Core)
Linux version 2.6.32-042stab127.2 (root@kbuild-rh6-x64.eng.sw.ru) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Thu Jan 4 16:41:44 MSK 2018
Description
I just upgraded from MariaDB-server-10.1.32-1.el7.centos.x86_64 to MariaDB-server-10.2.14-1.el7.centos.x86_64 via http://yum.mariadb.org/10.2/centos7-amd64
I have a column named "over". I did not used to have to quote it. Now I do. The reserved word list at https://mariadb.com/kb/en/library/reserved-words/ shows RECURSIVE and ROWS, new in 10.2, but it does not show over.
MariaDB [test]> CREATE TABLE test_over (`id` BIT, `over` BIT);
|
Query OK, 0 rows affected (0.01 sec)
|
MariaDB [test]> SELECT * FROM test_over WHERE over IS NULL;
|
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 'over IS NULL' at line 1
|
MariaDB [test]> SELECT * FROM test_over WHERE id IS NULL;
|
Empty set (0.00 sec)
|
MariaDB [test]> SELECT * FROM test_over WHERE `over` IS NULL;
|
Empty set (0.00 sec)
|