Skip to content

Import from SQL-Dump files is broken since v3.11 #2323

@HarryDe

Description

@HarryDe

Details for the issue

What did you do?

I tried to import data from a SQL-Dump.

What did you expect to see?

Approx. 20,000 records imported into a table

What did you see instead?

A syntax error near "DELETE FROM table". Removing the DELETE statement resulted in a syntax error near "INSERT INTO ..."

The error was already present in v3.11, upgrading to 3.12 did not fix it.
However, after downgrading to 3.10 the import worked, as it did years before. Hence the bug was most likely introduced in 3.11

Useful extra information

DB4S v3.12.0 [built for x86_64-little_endian-llp64] on Windows 8.1 (6.3) (winnt/6.3.9600) [x86_64]
using SQLCipher Version 4.4.0 community (based on SQLite 3.31.0)
and Qt 5.12.8

Metadata

Metadata

Assignees

Labels

bugConfirmed bugs or reports that are very likely to be bugs.encoding

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions