Activity log for bug #1480978

Date Who What changed Old value New value Message
2015-08-03 15:37:21 Rolf Leggewie bug added bug
2019-08-13 12:02:49 Marcus Tomlinson libreoffice (Ubuntu): status New Incomplete
2019-08-24 06:36:52 Rolf Leggewie libreoffice (Ubuntu): status Incomplete New
2019-08-24 07:03:33 Marcus Tomlinson libreoffice (Ubuntu): status New Fix Released
2019-08-24 07:09:45 Marcus Tomlinson bug watch added https://bugs.documentfoundation.org/show_bug.cgi?id=92987
2019-08-24 07:09:45 Marcus Tomlinson bug task added df-libreoffice
2019-08-24 07:09:53 Marcus Tomlinson summary view cannot be a UNION SELECT in trusty base [upstream] view cannot be a UNION SELECT in trusty base
2019-08-24 07:44:38 Rolf Leggewie 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. 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.
2019-09-02 17:26:36 Bug Watch Updater df-libreoffice: status Unknown Invalid
2019-09-02 17:26:36 Bug Watch Updater df-libreoffice: importance Unknown Medium