** Description changed: 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" + 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" + 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 + Verifications whether this affects later versions than trusty appreciated.
-- 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: [upstream] view cannot be a UNION SELECT in trusty base Status in LibreOffice: Unknown Status in libreoffice package in Ubuntu: Fix Released 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." Verifications whether this affects later versions than trusty appreciated. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1480978/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp