@robocoder opened this Issue on September 15th 2009 Contributor

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 Owner

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

@mattab commented on March 30th 2010 Owner

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

@robocoder commented on March 30th 2010 Contributor

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