desktop-packages team mailing list archive

[Rolf Leggewie <1480978@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: trusty

-- 
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