https://bugs.documentfoundation.org/show_bug.cgi?id=131448
Robert Großkopf <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |UNCONFIRMED
CC| |[email protected]
Ever confirmed|1 |0
--- Comment #3 from Robert Großkopf <[email protected]> ---
Can't see anybody, who has confirmed a buggy behavior here.
Have tested this:
SELECT "Car", SUM("Cost") , EXTRACT(YEAR FROM "ServiceDate") AS "Year"
FROM "tblService"
GROUP BY "Car", "Year"
ORDER BY "Year" DESC
No problem to execute this query. But you can't change from this query to the
query-GUI. It won't understand the code.
Then I tried
SELECT "Car", SUM("Cost") , EXTRACT(YEAR FROM "ServiceDate")
FROM "tblService"
GROUP BY "Car", EXTRACT(YEAR FROM "ServiceDate")
ORDER BY EXTRACT(YEAR FROM "ServiceDate") DESC
Without any alias and it throws an error, because Base couldn't understand this
code. So I switched to direct SQL executing and this code works, too.
Tested with LO 6.4.2.2 on OpenSUSE 15.1 64bit rpm Linux
So I couldn't find any buggy behavior here. I switch it back to unconfirmed,
because it must be confirmed by other person like the bug reporter.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
