← Back to team overview

maria-discuss team mailing list archive

Re: Question about mariadb 10.2 "rows" keyword



Checking this list <https://mariadb.com/kb/en/mariadb/reserved-words/> seems to confirm that it's not documented as a reserved word but it is in sql/lex.h which means it's a keyword. I'd suggest adding it to the list of documented keywords for 10.2.


On 14/06/17 09:39, Rod Bio wrote:
Hi everyone,

Apologies I am not a native english speaker so my english will be weird
and database is not my specialty, but I would just like to ask something
about mariadb specifically version 10.2

I just recently upgraded to 10.2 from 5.5 and somewhat we had problem
displaying our data. Anyway we've traced the issue, after trying to
replicate the database, to a specific table.
What we found is that when we create a table with a column named "rows"
it would return an error.

MariaDB [test]> create table test (rows 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 'rows int)' at line 1

Only by using `` as in `rows` to create the column would we be able to
do it successfully.
MariaDB [test]> create table test (`rows` int);
Query OK, 0 rows affected (0.02 sec)

I haven't had any other issue but just this specific keyword and we have
not successfully seen any documentation regarding this.

Thank you everyone in advance.

Markus Mäkelä, Software Engineer
MariaDB Corporation
t: +358 40 7740484 | Skype: markus.j.makela

Follow ups