Details
-
Type:
Improvement
-
Status: Done
-
Resolution: Done
-
Fix Version/s: None
-
Component/s: Qserv
-
Labels:None
-
Epic Link:
-
Sprint:DB_W16_12
-
Team:Data Access and Database
Description
"dec" is a reserved word in mysql, so queries like "SELECT dec FROM t" will never work, mysql will return syntax error, and not "unknown column"
mysql> select dec from t;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dec from t' at line 1
select decll from t;
ERROR 1054 (42S22): Unknown column 'decll' in 'field list'
Qserv is having troubles in parser, and the error is:
ERROR ccontrol.UserQueryFactory (build/ccontrol/UserQueryFactory.cc:109) - Invalid query: ParseException:Parse error(ANTLR):unexpected token: dec:
It'd be nice to improve the error message, and fix the problem because it currently crashes czar!
Attachments
Issue Links
- mentioned in
-
Page Loading...
The error message was improved, and behavior is now correct wrt. quoting and column name qualification