They are listed as reserved words in MySQL documentation for any version from 5.0 and up (at least): https://dev.mysql.com/doc/refman/5.0/en/keywords.html. I think compablity with MySQL here is an even or a more valid/important concern here than standards' compliance. This is actually a minor issue with standards in MySQL ( + derivates ) as compared to lots of other non-compliances IMO. If standards should decide there would never have been MySQL! Anyway it is not a big deal whether ON or OFF, I think. But maybe the parser require them as reserved for some casesdue to imperfections in the parser itself? This could be why they were made reserved. That sould at least be checked carefully before changing anything. -- Peter -- Webyog On Sun, Apr 24, 2016 at 1:13 PM, Alexander Barkov <bar@mariadb.org> wrote:
Hello,
I noticed that UTC_TIME, UTC_DATE, UTC_DATETIME are reserved keywords:
MariaDB [test]> SELECT * FROM utc_time; 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 'utc_time' at line 1
I think they should not.
- These keywords are not mentioned in the SQL standard - They are not involved in any complex grammar that would prevent them from being non-reserved keywords
Looks like a bug...
Any objections to make them non-reserved keywords in 10.2?
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp