table v_messages contains reserved sql words

Issue #576 wontfix
Uwe Kiewel created an issue

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)

  1. Janos SUTO repo owner

    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.

  2. Log in to comment