Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: Heitor Salazar Baldelli
Table name with sql reserved words [ reply ]  
2010-07-09 03:42

In mysql_adapter.rb this sql query will give problens when the table has name of a reserved sql word. Such as values.

sql = "SHOW FIELDS FROM #{table_name}"

To solve the bug please add the backtick character to the tables name:

sql = "SHOW FIELDS FROM `#{table_name}`"

Thanks for the great plugin.