Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||UNION & UNION ALL queries fail to produce visible results in BASE query design window.|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|Priority:||P5 (lowest)||CC:||droth124, oooforum, sliderule96|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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.