Created attachment 56227 [details] test document The attached file is a Base document with embedded HSQLDB. It contains one table, with some city names from France for the test, and one report designed with Report Builder extension. In this report, the city field is grouped on prefix (1 character). What happens executing the report : - with OOo 3.3.x (Win7 dualboot) --> OK - with LibO 3.3.x (LMDE vBox) --> OK - with LibO 3.4.x (LMDE vBox) --> raises SQL error - with LibO 3.5.0 RC1 (LMDE dualboot) --> raises SQL error
Created attachment 56228 [details] SQL error message (french)
Checked w/ LibO 3.5 RC2, Ubuntu 11.04. Can confirm, not only with the test db but using the postgres-sdbc driver also. In the later case the error message is pretty much the same: pq_driver: [PGRES_FATAL_ERROR]ERROR: column "LEFT_birthCity" does not exist LINE 1: SELECT * FROM "public"."Master" ORDER BY "LEFT_birthCity" ^ (caused by statement 'SELECT * FROM "public"."Master" ORDER BY "LEFT_birthCity"') To reproduce: open any Report Builder report definition Open the Sort/Groupding dialog Select any text field to group on Under properties set "Group Interval" to 'Prefix Characters' Any value in Group Intervval Run the report - error
I have tested this with LO 4.1.0.4 - seems the error had been gone, but don't know why. Same test with LO 4.0.5.2 - the error appears. It's a regression, but don't know, if it would be fixed for LO 4.0.*
Can anybody verify this is fixed in 4.1? I think if so, we can set this to "WORKSFORME". People with this issue could switch to the 4.1.x branch.
Have looked for some other reports for the Report-Builder and found this: https://bugs.freedesktop.org/show_bug.cgi?id=62248#c0 The grouping on not each values was broken. Lionel fixed it, but I don't know, which bug it was. So let us close this bug as "Worksforme".