[MDEV-12918] Query error when column named "recursive" Created: 2017-05-25  Updated: 2017-05-25  Resolved: 2017-05-25

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.2.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jan Slusarczyk Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

ubuntu 16.04.2


 Description   

I have upgraded MariaDB 10.1 to 10.2 and since then ran into a problem with a specific application using a column named "recursive" in one of the tables. Queries like

 select uid,recursive from test

cause 

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 'recursive from test' at line 1

Is this something that may be configured? Am I missing something?



 Comments   
Comment by Sergei Golubchik [ 2017-05-25 ]

RECURSIVE is a reserved word in 10.2 (because of recursive CTEs. You need to quote it in backticks if you want to use it as an identifier.

Generated at Thu Feb 08 08:01:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.