[Libreoffice-bugs] [Bug 112801] Improve LO SQL parser to allow GUI Query editor usage with more SQL connection varieties

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112801

--- Comment #7 from robert at familiegrosskopf.de ---
Problem for more connections: The SQL-code will differ.

Internal databases have different functions. This functions should be the first
which will be provided by the GUI.
     CASE WHEN expr1 THEN v1[WHEN expr2 THEN v2] ... [ELSE v4] END
works with HSQLDB and Firebird and also with MySQL/MariaDB.
You could use AND or OR inside this code and it will work in GUI. No need to
change to direct SQL and to get a query, where you couldn't input any data.

Neither HSQLDB nor Firebird do use IF.

MySQL (and MariaDB) aren't the same as 'SQL', it's one kind of SQL. Many
functions will work in the internal and external databases the same way, but
there are also functions, which doesn't. The same you have found for logical OR
(||) in MySQL is used for concatenate in HSQLDB and Firebird - so it won't work
as expected with the GUI, only with direct SQL.

Don't know if there is any developer, who will provide an external special
SQL-code for a database where a direct connection isn't provided by LO at this
time without an extension. The only external SQL database with a direct
connection to LO, provided by LO by default, at this moment is PostgreSQL.

I'm also using MariaDB in production environment. But I won't expect Base will
provide all functions or special code for it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171004/03797075/attachment-0001.html>