** Changed in: libreoffice (Ubuntu)
Status: Incomplete => New
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1480978
Title:
view cannot be a UNION SELECT in trusty base
Status in libreoffice package in Ubuntu:
New
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://bugs.documentfoundation.org/show_bug.cgi?id=92987
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."
Verifactions whether this affects later versions than trusty
appreciated.
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
