[Bug]: Erroneous execution of queries containing VACUUM · Issue #3723 · sqlitebrowser/sqlitebrowser (original) (raw)

What did you do?

  1. Open northwind.db database file (as reproducer example, not related)
  2. Execute the following query:

DELETE FROM "Order Details"; VACUUM;

What did you expect to see?

After answering Yes to:

Setting PRAGMA values or vacuuming will commit your current transaction.
Are you sure?

the table data is deleted and VACUUM executed on the database.

What did you see instead?

This was working on 3.12. On v3.13, after answering Yes to the prompt:

Execution finished with errors.
Result: Execution aborted by user
At line 2:
VACUU

The system believes the user aborted (No to the prompt).

After that, many bad things may happen, including freezing.

DB4S Version

3.13.0

What OS are you seeing the problem on?

Other

OS version

Any OS (tested on Windows and Linux)

Relevant log output

-- EXECUTING ALL IN 'SQL 1'

-- At line 1: DELETE FROM "Order Details"; -- Result: query executed successfully. Took 0ms, 0 rows affected -- At line 2: VACUU -- Result: Execution aborted by user

Prevention against duplicate issues