@robocoder opened this issue on September 15th 2009

OPTION is still a reserved keyword in MySQL (became non-reserved in SQL:2003 spec).

When the table prefix is empty "", the table name must be backticked (in MySQL). However, backticking is not portable SQL. Removing backticks in pre-processing adds overhead.

Proposals: - table prefix mandatory (require at least one character) - rename table (note: OPTIONS is a non-reserved keyword)

Note: in either proposal, an external update script would be needed to execute the ALTER statements needed to rename tables. Keywords: wishlist

@mattab commented on September 22nd 2009

vote for wontfix, and move the "table quoting" to the DB adapter

@mattab commented on March 30th 2010

marking as wontfix - if we need to change it, please reopen

@robocoder commented on March 30th 2010

At minimum, we should consider the first proposal (require at least one leading alpha character in $tables_prefix).

This issue was closed on March 30th 2010
Powered by GitHub Issue Mirror