[Libreoffice-bugs] [Bug 131448] Can Not Group in SQL on EXTRACT(YEAR FROM in Firebird Embedded

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131448

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |UNCONFIRMED
                 CC|                            |robert at familiegrosskopf.de
     Ever confirmed|1                           |0

--- Comment #3 from Robert Großkopf <robert at familiegrosskopf.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200327/8fd4b662/attachment.htm>