https://bugs.documentfoundation.org/show_bug.cgi?id=162893
Bug ID: 162893
Summary: Group by missing when using Query Editor with example
DB
Product: LibreOffice
Version: 24.2.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 196348
--> https://bugs.documentfoundation.org/attachment.cgi?id=196348&action=edit
Example Firebird
This SQL-Code works well in HSQL with the QueryComposer
SELECT SUM( "dtPayBetrag" ) AS "Betrag", YEAR( "dtPayDatum" ) AS "Jahr" FROM
"tblmPay" GROUP BY YEAR( "dtPayDatum" )
The most similar SQL-Code gives Errors with FIREBIRD and the QueryComposer
SELECT SUM( "dtPayBetrag" ) AS "Betrag", EXTRACT( YEAR FROM "dtPayDatum" ) AS
"Jahr" FROM "tblmPay" GROUP BY EXTRACT( YEAR FROM "dtPayDatum" )
Both querys are working with enabled run SQL directly
Firebird:
1 Open Query to edit and run query
Result: query executed
3 Uncheck „run in SQL directly“
4 switch to QueryComposer
Result Editor seems to work with the code (See [] insted of ““)
Run query (F5)
Error: “Syntaxfehler im SQL-Ausdruck”
Open Aggregation 2 Column “Jahr”
1) There is no aggregate function Group by to select
Tested with
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c8eb95e8407ef24436e0e8e218dce535df6bb2e5
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render:
Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
