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

[Warren Gibson (JIRA)]

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.1
         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


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