Launchpad has imported 6 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=92987.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2015-07-28T17:12:58+00:00 Libreoffice-4 wrote: 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." Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/comments/0 ------------------------------------------------------------------------ On 2015-07-28T17:35:14+00:00 Iplaw67-h wrote: @Rolf : which db backend are you using ? Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/comments/1 ------------------------------------------------------------------------ On 2015-07-28T17:41:03+00:00 Libreoffice-4 wrote: HSQLDB embedded Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/comments/2 ------------------------------------------------------------------------ On 2015-07-28T18:18:51+00:00 Nv4y-robert wrote: Have tested this also. Build two tables for the content I guessed by the given example. Copied the query in a Base-query. Could only execute the query in direct SQL-Mode, not in GUI-Mode. Think this is what you mean with "query works fine ...". Now I took the query and created a view from this query. View works the same way the query works. So I could not confirm the described bug. My System: OpenSUSE 13.2, 64bit rpm Linux, different LO-versions Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/comments/3 ------------------------------------------------------------------------ On 2015-07-30T08:22:26+00:00 Iplaw67-h wrote: @Rolf : as with other bugs you have reported, you are using 4.2.8 provided by Ubuntu. TDF builds of the 4.2.8 line are EOL since Jan 2015. Please update your version of LO to a current TDF production release, test again and report back here, or else close this bug and file a report against the Ubuntu provided version Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/comments/4 ------------------------------------------------------------------------ On 2015-08-03T13:00:26+00:00 Libreoffice-4 wrote: I can actually save the view when I choose to run SQL directly even in 4.2.8.2. But open opening the view in 4.2.8.2 produces an error of "The content could not be loaded - Wrong datatype: java.lang.illegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] in statement [SELECT * FROM "VIEW1"] The UNION SELECT opens fine even as a view in 4.4.5, so this problem is indeed fixed in the latest release. Thanks. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1480978/comments/5 ** Changed in: df-libreoffice Status: Unknown => Invalid ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1480978 Title: [upstream] view cannot be a UNION SELECT in trusty base To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1480978/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
