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( ), '-MM-' ) + "integer" )
AS "Zahltag"
FROM "company", "integer"
UNION SELECT ALL "company_name",
DATEDIFF( 'DD', '1899-12-30', TO_CHAR( CURDATE( ), '-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 -mm-dd
hh:mm:ss[.f] 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
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
