[upstream] view cannot be a UNION SELECT in trusty base
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Invalid
|
Medium
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
This is either an upstream bug already fixed in the version in wily or a regression introduced in Ubuntu. I run trusty.
https:/
SELECT "company_name",
DATEDIFF( 'DD', '1899-12-30', TO_CHAR( CURDATE( ), 'YYYY-MM-' ) + "integer" ) AS "Zahltag"
FROM "company", "integer"
UNION SELECT ALL "company_name",
DATEDIFF( 'DD', '1899-12-30', TO_CHAR( CURDATE( ), 'YYYY-MM-' ) + "payday2" ) AS "Zahltag"
FROM "company"
The above works fine as a query in trusty base but only the first select will be accepted as a view. The UNION SELECT will trigger the error "The given command is not a select statement. Only queries are allowed."
Verifications whether this affects later versions than trusty appreciated.
Changed in libreoffice (Ubuntu): | |
status: | Incomplete → New |
summary: |
- view cannot be a UNION SELECT in trusty base + [upstream] view cannot be a UNION SELECT in trusty base |
description: | updated |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Invalid |
SELECT "company_name",
DATEDIFF( 'DD', '1899-12-30', TO_CHAR( CURDATE( ), 'YYYY-MM-' ) + "integer" ) AS "Zahltag"
FROM "company", "integer"
UNION SELECT ALL "company_name",
DATEDIFF( 'DD', '1899-12-30', TO_CHAR( CURDATE( ), 'YYYY-MM-' ) + "payday2" ) AS "Zahltag"
FROM "company"
The above works fine as a query but only the first select will be accepted as a view. The UNION SELECT will trigger the error "The given command is not a select statement. Only queries are allowed."