[teiid-issues] [JBoss JIRA] Updated: (TEIID-1144) PostgreSQL (simple capabilities) returning an unexpected number of rows
[
https://jira.jboss.org/browse/TEIID-1144?page=com.atlassian.jira.plugin.s...
]
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