IssueTracker

Component used: Room

Version used: 2.4.0-alpha02

I just added foreign keys on a couple of entities and got this error when trying to use AutoMigration.

Here's the generated code:

class AppDatabase_AutoMigration_1_2_Impl extends Migration {
  public AppDatabase_AutoMigration_1_2_Impl() {
    super(1, 2);
  }

  @Override
  public void migrate(@NonNull SupportSQLiteDatabase database) {
    database.execSQL("CREATE TABLE IF NOT EXISTS `_new_float_hsv` (`hue` REAL NOT NULL, `saturation` REAL NOT NULL, `value` REAL NOT NULL, `alpha` REAL NOT NULL, `palette_id` TEXT NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FOREIGN KEY(`palette_id`) REFERENCES `palette`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE )");
    database.execSQL("INSERT INTO `_new_float_hsv` (saturation,alpha,palette_id,hue,id,value) SELECT saturation,alpha,palette_id,hue,id,value FROM `float_hsv`");
    database.execSQL("DROP TABLE `float_hsv`");
    database.execSQL("ALTER TABLE `_new_float_hsv` RENAME TO `float_hsv`");
--> database.execSQL("PRAGMA foreign_key_check(`float_hsv`)");
    database.execSQL("CREATE TABLE IF NOT EXISTS `_new_saturation_value` (`saturation` REAL NOT NULL, `value` REAL NOT NULL, `palette_id` TEXT NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FOREIGN KEY(`palette_id`) REFERENCES `harmony_palette`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE )");
    database.execSQL("INSERT INTO `_new_saturation_value` (saturation,palette_id,id,value) SELECT saturation,palette_id,id,value FROM `saturation_value`");
    database.execSQL("DROP TABLE `saturation_value`");
    database.execSQL("ALTER TABLE `_new_saturation_value` RENAME TO `saturation_value`");
    database.execSQL("PRAGMA foreign_key_check(`saturation_value`)");
    database.execSQL("CREATE TABLE IF NOT EXISTS `_new_hue` (`hue` REAL NOT NULL, `palette_id` TEXT NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FOREIGN KEY(`palette_id`) REFERENCES `harmony_palette`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE )");
    database.execSQL("INSERT INTO `_new_hue` (palette_id,hue,id) SELECT palette_id,hue,id FROM `hue`");
    database.execSQL("DROP TABLE `hue`");
    database.execSQL("ALTER TABLE `_new_hue` RENAME TO `hue`");
    database.execSQL("PRAGMA foreign_key_check(`hue`)");
  }
}

Stack trace:

android.database.sqlite.SQLiteException: unknown error (code 0 SQLITE_OK): Queries can be performed using SQLiteDatabase query or rawQuery methods only.
        at android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
        at android.database.sqlite.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:890)
        at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:756)
        at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:66)
        at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1920)
        at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1841)
        at androidx.sqlite.db.framework.FrameworkSQLiteDatabase.execSQL(FrameworkSQLiteDatabase.java:242)
        at com.se7en.hue.data.room.AppDatabase_AutoMigration_1_2_Impl.migrate(AppDatabase_AutoMigration_1_2_Impl.java:21)
        at androidx.room.RoomOpenHelper.onUpgrade(RoomOpenHelper.java:99)
        at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper$OpenHelper.onUpgrade(FrameworkSQLiteOpenHelper.java:177)
        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:416)
        at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:316)
        at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper$OpenHelper.getWritableSupportDatabase(FrameworkSQLiteOpenHelper.java:145)
        at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper.getWritableDatabase(FrameworkSQLiteOpenHelper.java:106)
        at androidx.room.RoomDatabase.internalBeginTransaction(RoomDatabase.java:591)
        at androidx.room.RoomDatabase.beginTransaction(RoomDatabase.java:580)
        at com.se7en.hue.data.room.PaletteDao_Impl$21.call(PaletteDao_Impl.java:417)
        at com.se7en.hue.data.room.PaletteDao_Impl$21.call(PaletteDao_Impl.java:414)
        at androidx.room.CoroutinesRoom$Companion$createFlow$1$1$1.invokeSuspend(CoroutinesRoom.kt:125)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106)
        at androidx.room.TransactionExecutor$1.run(TransactionExecutor.java:47)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at java.lang.Thread.run(Thread.java:923)