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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
