Bug 128514 - Query-GUI doesn't show any row with HSQLDB 2.5.0 / UNION-query - Tools > SQL will show the output
Summary: Query-GUI doesn't show any row with HSQLDB 2.5.0 / UNION-query - Tools > SQL ...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
 
Reported: 2019-10-31 16:23 UTC by Robert Großkopf
Modified: 2021-10-14 14:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Database and hsqldb.jar of HSQLDB 2.5. Extract and change connection for test. (1.45 MB, application/zip)
2019-10-31 16:23 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2019-10-31 16:23:09 UTC
Created attachment 155430 [details]
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.
Comment 1 Alex Thurgood 2019-11-26 10:28:26 UTC
Unfortunately, can't test on macOS.
Comment 2 Robert Großkopf 2021-10-14 14:44:56 UTC
Two additional hints:
The path to the external hsqldb.jar is stored in the macro "Start", which is executed after database file has been opened.

Creating a view of the query will show the same content as executing through Tools → SQL. When trying to edit the view and running the view in the editor the content isn't shown.