|
Re: erroneous repeating row values in SQL Results view [message #56829 is a reply to message #56748] |
Tue, 02 June 2009 17:47 |
Eclipse User |
|
|
|
Originally posted by: brianf.sybase.com
Hi Chris...
The people who would typically respond to your question are on holiday at
the moment. Please be patient and I'm sure they'll respond when they get
back next week.
--Fitz
"Chris Giblin" <cgi@zurich.ibm.com> wrote in message
news:h0372v$96d$1@build.eclipse.org...
> 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.02687 seconds