erroneous repeating row values in SQL Results view [message #595886] |
Tue, 02 June 2009 12:48 |
No real name Messages: 121 Registered: July 2009 |
Senior Member |
|
|
Hi,
When I perform a join on two tables (each table has ~3400 rows), a
number of rows are copiously repeated towards the end of the displayed
result set. For example, there will be 12 "John Smith" rows followed by
7 "John Doe" rows. I know that these rows really do not occur in
duplicate in the tables, I suspect something is wrong in the result set
processing.
The join statement is nothing crazy:
select app.id.cn,app.hr.hrnum from app.id join app.hr on app.id.empnum =
app.hr.hrnum
In the Data Management Preferences, I have set max row count and max
display row count both to 4000. It is as if the result view fills up the
empty rows at the end with duplicates from the result set. That is,
fills up all 4000 rows even though result set was some 3000 rows.
I am using a ganymede birt build from eclipse.org with these versions:
BIRT 2.3.2
DTP 1.6.2
Eclipse 3.4.2
EMF 2.4.2
Has anyone else also seen this behavior?
Thanks, chris
|
|
|
Powered by
FUDForum. Page generated in 0.03910 seconds