[Libreoffice-bugs] [Bug 133997] Base Editing Create Query in Design View generates incorrect SQL

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement
             Status|NEEDINFO                    |NEW
                 CC|                            |robert at familiegrosskopf.de

--- Comment #3 from Robert Großkopf <robert at familiegrosskopf.de> ---
I could confirm it isn't working like you expect.
Query-GUI works this way:
All you write in the same row will be linked with 'AND'.
All you write in different rows will be linked with 'OR'.
Create your query like you created the expected query, switch back to the GUI
and you see:
FieldA     FieldB
:AskA      :AskB
:AskA      IS EMPTY
IS EMPTY   :AskB
IS EMPTY   IS EMPTY

You get this query
SELECT * FROM "Table1" WHERE "FieldA" = :AskA  AND "FieldB" = :AskB  OR
"FieldA" = :AskA AND "FieldB" IS NULL OR "FieldA" IS NULL  AND "FieldB" = :AskB
OR "FieldA" IS NULL AND "FieldB" IS NULL

This will work and give the same result you wanted.

Don't know if you expect too much from the query-GUI. I have only used it at
the beginning of creating databases ...

We could set this as Enhancement: A possibility to set brackets so you can get
more than two Fields working this way in the GUI. The example above fills
nearly all fields ...

Tested all with OpenSUSE 15.1 64bit rpm Linux

-- 
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/20200615/7916d8a7/attachment-0001.htm>