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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
