Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.3
-
None
Description
Described query with using alias named engine without using backticks (``) does not work:
select id as engine from users WHERE id = 1; |
But this one works:
select id as `engine` from users WHERE id = 1; |
Both of this queries successful work in MariaDB 10.2
Add. information:
Query:
mysql> select id as engine from users WHERE id = 1; |
ERROR 1141 (HY000): Access denied for user 'docker'@'172.18.0.1': Query could not be parsed completely and will hence be rejected. Please ensure that the SQL syntax is correct. |
MaxScale logs:
warning: (3) [dbfwfilter] Query could not be parsed completely and will hence be rejected. Please ensure that the SQL syntax is correct: select id as engine from users WHERE id = 1 |