You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When you use SQL mode in Manticore, single quotes are used to write string data, which are used when writing phrases "Isn't, Let's", etc. in such cases, backslash escaping is used. In classic SQL, there is a lifehack that consists in using double quotes to frame a string and it is often used in processing forum messages or something similar.
An example of how it works now in Manticore:
INSERT INTO demo (info) VALUES ('Isn't it.');
An example of how it works in SQL:
INSERT INTO demo (info) VALUES ("Isn't it.");
At the same time, the solution works in the opposite direction:
INSERT INTO demo (info) VALUES (' Hey, where is this "thing"?');
Checklist:
To be completed by the assignee. Check off tasks that have been completed or are not applicable.
Task estimated
Specification created, reviewed and approved
Implementation completed
Tests developed
Documentation updated
Documentation proofread
Changelog updated
OpenAPI YAML updated and issue created to rebuild clients
The text was updated successfully, but these errors were encountered:
Supporting double quotes for inserts is not a big deal (probably just a one-line change). Supporting it in other cases (e.g. where match and string comparison) requires more work and better thinking.
We need to decide whether we want to support double quotes only for INSERTs/REPLACEs (may make users confused.) or everywhere.
Proposal:
When you use SQL mode in Manticore, single quotes are used to write string data, which are used when writing phrases "Isn't, Let's", etc. in such cases, backslash escaping is used. In classic SQL, there is a lifehack that consists in using double quotes to frame a string and it is often used in processing forum messages or something similar.
An example of how it works now in Manticore:
INSERT INTO demo (info) VALUES ('Isn't it.');
An example of how it works in SQL:
INSERT INTO demo (info) VALUES ("Isn't it.");
At the same time, the solution works in the opposite direction:
INSERT INTO demo (info) VALUES (' Hey, where is this "thing"?');
Checklist:
To be completed by the assignee. Check off tasks that have been completed or are not applicable.
The text was updated successfully, but these errors were encountered: