Skip to content

Sqlite query not interpreted correctly #2336

@dawie-git

Description

@dawie-git

Description

The following is valid in sqlite:
update my_table set field1 = 'xxx don\''t \'' . Also don\''t parse OR''  ' where id = 1

But Heidi only runs the following:
update pef_docs set body = 'xxx don\''t \'' . Also don\''t parse OR''  

If I remove the ; then it works:
update my_table set field1 = 'xxx don\''t \'' . Also don\''t parse OR'' &nbsp' where id = 1

Or if I remove some of the backslashes it also works:
update my_table set field1 = 'xxx don\''t . Also don\''t parse OR'' &nbsp' where id = 1

HeidiSQL version

12.13.0.7147

Database server version

SQLite 3.50.4

Reproduction recipe

Create any table with a text field. Run the queries above.

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membernettype-sqliteSQLite specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions