Issue 127465

Summary: UNION & UNION ALL queries fail to produce visible results in BASE query design window.
Product: Base Reporter: chrisb <chrissyboybrown>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: droth124, oooforum, sliderule96
Version: 4.1.3   
Target Milestone: ---   
Hardware: PC   
OS: Windows 10   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description chrisb 2017-07-03 13:20:05 UTC
when a 'UNION' or 'UNION ALL' query is executed within the BASE query design window using Open Office 4.1.3 in combination with a back end of HSQLDB 2.4.0. then no result set is displayed.
We get an empty window & title bar (no column headers).

Please see the link below:
https://forum.openoffice.org/en/forum/viewtopic.php?p=420136#p420136
Comment 1 sliderule 2017-07-03 17:02:59 UTC
I would like to confirm issue as described by user chrisb, and, vote that this be reviewed and solved.
Comment 2 UnklDonald 2017-07-04 04:36:15 UTC
I can confirm the issue noted by user chrisb.
My queries using UNION and UNION ALL that worked with earlier versions of HSQLDB display no results when using HSQLDB 2.4.0 and Open Office 4.1.3
Those queries work with HSQLDB 2.4.0 when using a front end other than Open Office.
Comment 3 oooforum (fr) 2017-07-06 16:10:00 UTC
For me, duplicate of issue 121837
This could be solve if inner HSQLDB is upgraded to 2.x