https://bugs.documentfoundation.org/show_bug.cgi?id=162893
Robert Großkopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Ever confirmed|0 |1 --- Comment #2 from Robert Großkopf <[email protected]> --- Tested this: Could execute queries in direct SQL. Couldn't execute query SELECT SUM( "dtPayBetrag" ) AS "Betrag", EXTRACT( YEAR FROM "dtPayDatum" ) FROM "tblmPay" GROUP BY EXTRACT( YEAR FROM "dtPayDatum" ) if it isn't set to direct SQL, but could execute SELECT SUM( "dtPayBetrag" ) AS "Betrag", EXTRACT( YEAR FROM "dtPayDatum" ) AS "Jahr" FROM "tblmPay" GROUP BY "Jahr" Changed the second query to GUI-mode and get the error "Syntax error …". In GUI will be shown EXTRACT( YEAR FROM [dtPayDatum] ) When switching from brackets to " EXTRACT( YEAR FROM "dtPayDatum" ) GUI doesn't offer 'Group by' any more. Could confirm the buggy behavior for Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0427231a1485d324519e94246ff702bc0cb18b89 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded and also with older versions like LO 24.2.5.2 -- You are receiving this mail because: You are the assignee for the bug.
