Hi, Keith, On Apr 02, Keith Edmunds wrote: > > I can't say I'm impressed with a "patch" which eliminates something > > like this from the list of reserved words. They are, after all, > > reserved for a reason. > > I'm not impressed that a point release introduces a reserved word that > will undoubtedly clash with existing apps, but hey, we are where we > are.
It was done in 10.7.1, part of the feature https://mariadb.com/kb/en/get-diagnostics/#row_number Every minor MariaDB release comes with new features, patch releases don't. In this case, in particular, ROW_NUMBER is a reserved keyword according to the SQL Standard (see the <reserved word> rule in the part 2). Using reserved words as identifiers is generally discouraged, even if a particular implementation allows that in a particular release. Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
