UNIQUE constraint error upon repeated type conversion #5
Labels
bug
Something isn't working
Comments
paulfitz
added a commit
to gristlabs/grist-core
that referenced
this issue
Jul 11, 2023
Grist by default uses node-sqlite3 to manipulate data in an SQLite database. If a single parameter is passed to `run` and it is a list, the list is unpacked and its contents treated as the actual parameters. In grist-static, we use other SQLite interfaces that don't have that automatic unpacking. Most calls like this have been removed from Grist, but at least one was missed, and was causing symptoms such as gristlabs/grist-static#5 This change should make no difference to regular Grist, but resolves the grist-static problems.
paulfitz
added a commit
to gristlabs/grist-core
that referenced
this issue
Jul 11, 2023
Grist by default uses node-sqlite3 to manipulate data in an SQLite database. If a single parameter is passed to `run` and it is a list, the list is unpacked and its contents treated as the actual parameters. In grist-static, we use other SQLite interfaces that don't have that automatic unpacking. Most calls like this have been removed from Grist, but at least one was missed, and was causing symptoms such as gristlabs/grist-static#5 This change should make no difference to regular Grist, but resolves the grist-static problems.
|
Should have been fixed by gristlabs/grist-core#566, will reach grist-static soon. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
When I change column type twice in a row, I get
UNIQUE constraint failed: _grist_Tables_column.id failedas it tries to add the helper columns that the logs say were cleaned up after the previous transform:The text was updated successfully, but these errors were encountered: