https://bugs.documentfoundation.org/show_bug.cgi?id=172545
Robert Großkopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #1 from Robert Großkopf <[email protected]> --- It is this part of the query which produces the error: AND EXTRACT( YEAR FROM "b"."Datum" ) = COALESCE ( ( SELECT "Jahr" FROM "viw_Filter" ), EXTRACT( YEAR FROM "b"."Datum" ) ) AND EXTRACT( MONTH FROM "b"."Datum" ) = COALESCE ( ( SELECT "Monat" FROM "viw_Filter" ), EXTRACT( MONTH FROM "b"."Datum" ) ) AND CEILING(EXTRACT(MONTH FROM "b"."Datum")/3.0) = COALESCE ( ( SELECT "Quartal" FROM "viw_Filter" ), CEILING(EXTRACT(MONTH FROM "b"."Datum")/3.0) ) Might be some parts of the functions aren't well integrated. Database for XRechnung is Firebird… When switching to Design View and trying to execute the query I get: at /home/buildslave/source/libo-core/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:109 When trying to go back to SQL view I get /home/buildslave/source/libo-core/dbaccess/source/ui/querydesign/querycontroller.cxx:524 I have tested this with LO 7.4.7.2. So the errors might be different. IN LO 26.2.4.2 and error without any information appears. -- You are receiving this mail because: You are the assignee for the bug.
