Issue 59204 - Report Wizard: Columns using reserved words like table display wrong result
Summary: Report Wizard: Columns using reserved words like table display wrong result
Status: CLOSED DUPLICATE of issue 47269
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 3.0
Assignee: berend.cornelius
QA Contact: issues@dba
Keywords: crash, oooqa
Depends on:
Reported: 2005-12-11 16:56 UTC by intersol
Modified: 2008-05-20 11:55 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Base database with 1 table and two reports created with 2.0.0 and 2.0.1 (15.41 KB, application/vnd.sun.xml.base)
2005-12-13 05:11 UTC, bernhard
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description intersol 2005-12-11 16:56:32 UTC
If you have a column in a table of view that is named "table" the Report Wizard
will generate the report but it will change the field and as: "table_renamed_1"
- The problem is that the report is not going to work.

Steps to repoduce : Try the following: 3 columns of data, group by two columns,
one of them being named "table".

Bug found in 2.0.1 RC4. I don't know if the same is appling for other reserved
Comment 1 2005-12-12 20:05:21 UTC
This bug is reproducible on MySQL, PostgreSQL and HSQL Tables.
The pattern is "table_renamed_X" where X is an randomly generated integer.

In addition to this the report-output is not generated (i.e. shown) and the
field-name can not be altered afterwards to make the report work again.

Works in 2.0.0.
Comment 2 bernhard 2005-12-13 05:06:55 UTC
On Win98SE a Base database (HSQL) doesn't work properly in OOo2.0.0 [680m3
(build:8968)] German version: 
- create new database
- create table with 3 fields: "table" (Text), "test" (Text), "tabelle" (Text)
- close table and let OOo create an ID when saving the table
- double click on tale in table window and enter some values in two records 
(table: "what_else" / "text", test: "test" / "nothing", tabelle: "empty" / "aaa"
- close table window
- right click on table in table window and select report-wizard
- select all fields in step 1
- don't change anything in step 2 to 6

expected: report with all the entries

result: all fileds except tabelle are filled properly, but in tabelle there is 
the default text in line 1 "Ut wisi enim ad mimin veniam, quis nostrud exerci", 
line 2 is empty.

I don't have the english version, but I suppose, fieldname "tabelle" will work 
for you, "table" not.

In OOo2.0.1 [680m146[build8989)] German version the bug is reproducible, but 
with quite a strange behaviour:

- I opened the file created with OOo2.0.0 and started the report-wizard

expected: wizard works as in OOo2.0.0 (producing default string in 
filed "tabelle")

result: OOo shows crash window in front (Title "Soffice", text: "Diese 
Anwendung wird aufgrund eines ungültigen Vorgangs geschlossen. ...") but works 
fine behind of it. The "tabelle" field shows the default text and you may close 
the report window, rename the reports, close base and OOo without any problem. 
Afterwards you may close the crash window - if you do it before, OOo is killed 
and crash reporter starts with next opening.

The new report can be opened without any problem.

I confirm this issue, even if it seems to be more complex than thought before.

Added regression keyword because it worked (at least without crash) in OOo2.0.0.
Added crash keyword (even if it doesn't crash fully on Win98SE)

@intersol, @simonaw: could you please provide your OS?

Best regards 
Comment 3 bernhard 2005-12-13 05:11:18 UTC
Created attachment 32326 [details]
Base database with 1 table and two reports created with 2.0.0 and 2.0.1
Comment 4 marc.neumann 2006-01-24 10:45:05 UTC

I can reproduce this wrong behaviour with the tablefield "table" in the attached
database. However I have no crash and in 2.0.0, 2.0.1 and m151 I have the same

So I remove the keyword regression and send it to the right developer.

Bye Marc
Comment 5 berend.cornelius 2006-05-19 12:56:35 UTC
Comment 6 berend.cornelius 2006-07-03 15:07:59 UTC
Resetting target to OOo 2.x
Comment 7 berend.cornelius 2007-02-01 15:07:07 UTC
bc: setting target to OOo 2.3
Comment 8 berend.cornelius 2007-07-23 10:49:29 UTC
bc: Setting target to OOo.2.x
Comment 9 berend.cornelius 2007-12-31 15:02:13 UTC
I could still reproduce the problem in a SRC680/m237. I asked fs to decide for
which target this is to be fixed.

*** This issue has been marked as a duplicate of 47269 ***
Comment 10 berend.cornelius 2008-01-21 10:03:33 UTC
bc: changing target to OOo 3.0 because of lack of resources to take care of this
Comment 11 Mechtilde 2008-05-20 11:55:58 UTC
closed duplicate