Fix Version/s: None
"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!
- mentioned in
The error message was improved, and behavior is now correct wrt. quoting and column name qualification