[Libreoffice-bugs] [Bug 131448] New: 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

            Bug ID: 131448
           Summary: Can Not Group in SQL on EXTRACT(YEAR FROM in Firebird
                    Embedded
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: putmannFB at gmail.com

Description:
EXTRACT(YEAR From Date Time ) produces an error in a SQL GUI when grouping
exists in a database on EXTRACT(YEAR FROM below
SELECT "Car", SUM("Cost") , EXTRACT(YEAR FROM "ServiceDate")
FROM "tblService"
GROUP BY "Car", EXTRACT(YEAR FROM "ServiceDate")
ORDER BY EXTRACT(YEAR FROM "ServiceDate") DESC

Actual Results:
SQL Status: HY000
Error code: 1000

syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Expected Results:
Car     SUM     Year
2015    121     2020
2015    546     2019
2015    399     2018
2015    187     2017
2015    98      2016



Reproducible: Always


User Profile Reset: No



Additional Info:
It should have grouped on EXTRACT(YEAR From Date Time )

-- 
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/20200320/a4b8c00c/attachment.htm>