IssueTracker

Component

• Component used:
  • room-compiler
• Version used:
  • 2.4.0-alpha04
• Devices/Android versions reproduced on:
  • Runtime migration issue on every device / Emulator Android 12, Pixel 5

Description

Adding column name with SQL keyword makes the compiler fail to escape the keyword and thereafter fail to migrate the database.

I seem to be unable to escape this even with the RenameColumn and DeleteColumn as they seek the exact names and therefore will skip escaping with `.

Proposed Solution

Have the compiler escape SQL keywords in column and table names.

Code sample

Before:

@Entity(tableName = "foobar")
data class FooBar(
  // ...
  @ColumnInfo(name = "index") val position: Int
)

After:

@Entity(tableName = "foobar")
data class FooBar(
  // ...
  @ColumnInfo(name = "position") val position: Int
)

@RenameColumn.Entries(
  value = [
    RenameColumn(
      tableName = "foobar",
      fromColumnName = "index",
      toColumnName = "position"
    )
  ]
)
class MyMigrationSpec : AutoMigrationSpec