-
-
Notifications
You must be signed in to change notification settings - Fork 540
Open
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-sqliteSQLite specific issueSQLite specific issue
Description
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''  ' 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''  ' 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
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-sqliteSQLite specific issueSQLite specific issue