[KEXI] [Bug 332161] Add support for identifiers with special characters or equal to reserved words in queries

Jarosław Staniek bugzilla_noreply at kde.org
Wed Apr 29 16:39:30 BST 2020


https://bugs.kde.org/show_bug.cgi?id=332161

--- Comment #9 from Jarosław Staniek <staniek at kde.org> ---
Conclusion from https://bugs.kde.org/show_bug.cgi?id=332161#c3 is the solution
I'd propose. So we're using [] not the quotes in the KDBSQL.

> SELECT id, `integer` FROM `table` WHERE `integer` = [some criteria]

SELECT id, [integer] FROM [table] WHERE [integer] = [some criteria]


And I propose to call it "KDBSQL", not a "native KDbSQL" which would be
confusing.
Native is a term reserved for whatever dialect the driver's backend requires.

I am sorry that the description. Bugs.kde.org does not allow message editing so
it is hard to follow. More complex are proposed on phabricator or
https://community.kde.org/KDb / https://community.kde.org/Kexi.

I will not comment others just now, because my answer above probably solves
some of them as well. If you visit KEXI IRC or Telegram I can be there.

-- 
You are receiving this mail because:
You are the assignee for the bug.


More information about the Kexi-bugs mailing list