Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

[Bug]: Erroneous execution of queries containing VACUUM #3723

Copy link
Copy link
@mgrojo

Description

@mgrojo
Issue body actions

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

  • I have searched for similar issues
justinclift and macruzq

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions

    Morty Proxy This is a proxified and sanitized view of the page, visit original site.