0

I'm blocking on this issue, i have a file .sqm to migrate my database from version 1 to version 2 as follow:

ALTER TABLE MyTable ADD COLUMN name TEXT DEFAULT "";
ALTER TABLE MyTable ADD COLUMN phoneNumber TEXT DEFAULT "";

This file is in the same directory of .db files, the migration is success in case I omit the "verifyMigration" in the sqldelight configuration (gradle.kts) as follow, when i put it give me the following error: Attempting to alter something that is not a table. ALTER TABLE MyTable ADD COLUMN driverName TEXT DEFAULT ""

My gradle config:

sqldelight {
    database("MyDataBase") {
        packageName = "com.xx"
        sourceFolders = listOf("sqldelight")
        schemaOutputDirectory = file("src/commonMain/sqldelight/com/xx")
         verifyMigrations = true
    }
}

It seems to be the same issue as this posted question:

I have reinstalled the plugin, updated gradle, did a clean rebuild, invalidated sources ... Nothing seems to solve this.

0 Answers0