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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3023:
---------------------------------------

Are you on Teiid 7.3?  The first thing you should do is attempt to use a later version.

> but from vdb query(projects with hibernate) can only get 10800+ records. 

Can you provide the query plan showing the hibernate query to Teiid and then relevant source queries from there?

> Meanwhile, there's a set on maxSetSize = 1000, is there any affects?

That would only come into play if you are using an IN predicate or a dependent join, and it should not affect the total number of results only how the source query is formed.

> 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)