[rails] MySql Reserved Words

[Fletch]

I originally started developing a ruby in rails with mysql 4. One of the table in my is called 'reads'. The wasn't a problem.

Recently my host upgraded to mysql 5, so I installed mysql5 on my development environment. 'reads' has now been added to the reserved word list. I now get the following error:

Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads' at line 1: SHOW FIELDS FROM reads

If I was writing the sql myself I would just quote the table name, which would get round the problem but I don't have this control when abstracting the sql using rails.

Any way of getting round this without changing my table name?

Thanks.

[samsm]

Interesting problem, I'd have assumed that ActiveRecord would backtick everything.

Any chance set_table_name "`reads`" works?

[Mandibal]

Luckily changing the table name in RoR isn't too big of a deal. You can just use the "set_table_name" method in your Read model and you don't have to change anything in the rest of your Rails code. The model name stays the same but you just tell it to use a different table name. (Just in case you don't find another way around renaming it. )

[Fletch]

Thanks for your help!

set_table_name "`reads`"

Worked a treat (I'm surprised rails doesn't do this automatically)

Also good to know that renaming tables is simple.

[xmitchx]

Its good to know that you can set backticks in the set_table_name method. I am also suprised that Rails doesn't do this automatically...

[xmitchx]

Adding in here, I posted a new ticket on the Trac for Rails:
http://dev.rubyonrails.org/ticket/4905#preview