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

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 Attachments: postgresql-8.3-605.jdbc3.jar, QT_PostgreSQL83-ds.xml, 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.