Bug #1911
Errors in a schema upgrade script that contains multiple SQL statements are not detected
Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
06/28/2025
Due date:
% Done:
0%
Estimated time:
Version:
0.13.1
OS:
Any
Description
created a schema upgrade script with multiple statements in one file. When the upgrade started, one of the statements failed with an error visible in the PostgreSQL log, but quasselcore didn't show any errors and just finished the upgrade and increased the schemaversion number in the database anyway.which calls 'query.lastError().isValid()' just once, which may return the status of one of the successfully-executed statements inside the entire multi-statement query while it has not yet finished executing. https://www.dogsounds.net
I believe it is not written to work with multi-statement upgrade scripts, each statement must be broken out into a separate file.