[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1221) Query Processing Uncorrelated subquery evaluation - Not saving state causing re-execution without closing prior connection
Steve Hawkins (JIRA)
jira-events at lists.jboss.org
Mon Aug 23 20:28:11 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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
More information about the teiid-issues
mailing list