table v_messages contains reserved sql words
Issue #576
wontfix
column names "from" and "to" are not allowed. "from" and "to" are reserved words in SQL.
on cli, mysql do not execute a query like select * from v_messages where from="xxxxx;
please check https://dev.mysql.com/doc/refman/5.5/en/keywords.html
Comments (2)
-
repo owner -
repo owner - changed status to wontfix
- Log in to comment
This is a case when some email keywords conflict with sql reserved words. You are right that such naming could have been avoided, however I don't think it's a "major bug", since there's no problem if you properly quote your query, just as the gui does.