[Libreoffice-bugs] [Bug 128514] New: Query-GUI doesn't show any row with HSQLDB 2.5.0 / UNION-query - Tools > SQL will show the output

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128514
           Summary: Query-GUI doesn't show any row with HSQLDB 2.5.0 /
                    UNION-query - Tools > SQL will show the output
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Created attachment 155430
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155430&action=edit
Database and hsqldb.jar of HSQLDB 2.5. Extract and change connection for test.

This special bug appears with the external HSQLDB since 2.4.0. Have tested it
also with 2.5.0 - same behaviour.

In the attached database is a query which only will work in direct SQL. It
links two queries with the same fields by UNION:
SELECT "Nachname", "Geburtstag" FROM "Teilnehmer" WHERE
YEAR("Geburtstag")<'1980'
UNION
SELECT "Nachname", "Geburtstag" FROM "Teilnehmer" WHERE
YEAR("Geburtstag")>'2000'

The query could be started in the GUI with direct SQL. No error appears, no
rows will be shown.
The query could be started in Tools > SQL. The rows will be shown when the
checkbox for showing the output will be pressed.

Expected behaviour: Query-GUI should show all output which will be shown as
output through Tools > SQL.

-- 
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/20191031/392af80d/attachment-0001.html>