[teiid-issues] [JBoss JIRA] Updated: (TEIID-1144) PostgreSQL (simple capabilities) returning an unexpected number of rows

[Steve Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins updated TEIID-1144:
---------------------------------

             Fix Version/s: 7.1
         Affects Version/s: 7.0
                                (was: 7.1)
    Workaround Description: Some combination of setting the timeslice limit to a value much higher than 2 seconds, or setting the processor batch to a value smaller than 512.  This will prevent the chance of a time slice expiration happening.
                Workaround: [Workaround Exists]


The driver jar is not necessary, and should be upgraded to the jdbc 4.0 version.  It would also probably be good to not include the database connection details with the issue.

> PostgreSQL (simple capabilities) returning an unexpected number of rows
> -----------------------------------------------------------------------
>
>                 Key: TEIID-1144
>                 URL: https://jira.jboss.org/browse/TEIID-1144
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.0
>         Environment: Teiid 7.1 
> BQT PostgreSQL 8.3 source
> postgresql-8.3-605.jdbc3.jar is used for driver
>            Reporter: Warren Gibson
>            Assignee: Steve Hawkins
>             Fix For: 7.1
>
>         Attachments: QT_PostgreSQL83.vdb
>
>
> Several BQT queries are failing in PostgreSQL (simple capabilities) with an unexpected number of rows returned.  
> An example query can be seen below.  This query is expecting 50 rows returned since there are 50 rows in smalla table but 
> only 44 rows are returned.
> SELECT * FROM BQT1.SmallA AS A WHERE EXISTS (SELECT INTKEY FROM BQT1.SmallA AS B WHERE B.INTKEY = A.INTKEY)
> vdb is attached. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira