[
https://jira.jboss.org/browse/TEIID-1221?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins resolved TEIID-1221.
----------------------------------
Fix Version/s: 7.1.1
Resolution: Done
Throwing a blockedexception during the rewrite was causing the command to be recreated and
the subquery reexecuted without the original command being closed.
Query Processing Uncorrelated subquery evaluation - Not saving state
causing re-execution without closing prior connection
--------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1221
URL:
https://jira.jboss.org/browse/TEIID-1221
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1 Final; PostgreSQL83 DB
Reporter: Warren Gibson
Assignee: Steve Hawkins
Fix For: 7.1.1
Attachments: postgres83query_log, QT_PostgreSQL83.vdb
Query Testing - The following query is causing an issue which stops further processing.
SELECT stringkey, (SELECT intkey from BQT1.SmallA as b where Intnum = 22) FROM BQT1.SmallA
order by stringkey.
Steve H stated this is related to uncorrelated subquery evaluation - Not saving state
from one execution to the next which is causing a re-execute without closing the prior
connection.
--
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