[teiid-issues] [JBoss JIRA] (TEIID-3023) records lost when query by hiernate

[Lai Chao (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12983706#comment-12983706 ] 

Lai Chao commented on TEIID-3023:
---------------------------------

Hi, finnally I get access to the vdb by eclipse. But the situation is weird.

I tried to select from 3 tables, it also get 10800+ records with some data miss.
But I can get records if I add the lost data in condition.

for example the sql 1 can get 10800+records, with data miss "centre='10001'".
And I add the condition "centre='10001'" in the script as sql 2, I can get the data. 
Please advise.

sql 1: 
select distinct a.columns,b.columns,c.columns
from table_a a, table_b b,table_c c
where a.centre = b.code and b.code = c.division
and a.org='A00';
sql 2:
select distinct a.columns,b.columns,c.columns
from table_a a, table_b b,table_c c
where a.centre = b.code and b.code = c.division
and a.org='A00'
and centre = '10001';

> records lost when query by hiernate
> -----------------------------------
>
>                 Key: TEIID-3023
>                 URL: https://issues.jboss.org/browse/TEIID-3023
>             Project: Teiid
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: 7.3
>         Environment: window7,eclipse Helios Service Release 2, Teiid v7.3.0
>            Reporter: Lai Chao
>            Priority: Minor
>
> Recently, I get an issue when retrieve data from vdb that some records lost in the list. Fox example, from source table we can get 12100 records, but from vdb query(projects with hibernate) can only get 10800+ records. 
> Meanwhile, there's a set on maxSetSize = 1000, is there any affects?
> Please advise.



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)