Apache OpenOffice (AOO) Bugzilla – Issue 51380
UNION statement support
Last modified: 2013-02-07 22:32:22 UTC
Enter any SQL query with a UNION statement and an error is reported when saving: The given command is not a SELECT statement. Only queries are allowed. UNION statements should be supported.
I forgot to mention that I'm using ODBC connected to an SQL Server 2000 database. I haven't tried any other connect method so I don't know if it is an ODBC-specific limitation or not.
I reproduced that issue on build m113 using PostgreSQL with the Postgresql SDBC driver v. 0.62
... and GNU/Linux x86.
Hi, I reassign this enhancement to the User Experience team for evaluating. Bye Marc
Same issue with: * OO 2.4.1 * com.mysql.jdbc * MySQL 5.1 * Ubuntu 8.10 client * Ubuntu 8.04 server There is a workaround published somewhere in forums: View > Switch Design Off Edit > Run SQL command
Reported This workaround works is fine without any parameters, but it does not work with any variables in the WHERE clause of the query because the query is sent directly to the SQL Server. So it is not possible to make pre-defined queries with (=:paramater or =[parameter] )for our users containing any UNION command. This prevents us using Ooo as a reporting tool for our users. It would be very fine to have Ooo Base enhanced with the UNION feature.
Appendum to my perivious comment: This is reported for Ooo Base 3.1.