SQLite / SQLite3 ActiveRecord Adapter should quote table names when renaming tables

OVERVIEW

ActiveRecord does not always quote table names when using SQLite3, which may cause migrations to break when using keywords as table names.

STEPS TO REPRODUCE

1. Create a new rails project.
2. Create the CreateReferences migration (see below).
3. Run the db:migrate task.
4. Create the RenameReferencesToItems migration (see below).
5. Run the db:migrate task.

The CreateReferences migration:

create_table :references, :force => true do |t|
  t.string :foo
  t.string :bar
  t.timestamps
end

The RenameReferencesToItems:

rename_table :references, :items

ACTUAL RESULTS

Step 3 runs correctly. The "references" table is created.

Step 5 fails to run correctly. This is the output of the rake task:

==  RenameReferencesToItems: migrating =====
-- rename_table(:references, :items)
rake aborted!
An error has occurred, this and all later migrations canceled:
SQLite3::SQLException: near "references": syntax error: ALTER TABLE references RENAME TO items

EXPECTED RESULTS

Step 5 should not fail. It should rename the "references" table to "items". The generated SQL should be

ALTER TABLE "references" RENAME TO items

instead of

ALTER TABLE references RENAME TO items

AFFECTED VERSIONS

• SQLite3: 3.6.11.
• ActiveRecord: 2.3.2
• Ruby: 1.8.7