[teiid-issues] [JBoss JIRA] Closed: (TEIID-1221) Query Processing Uncorrelated subquery evaluation - Not saving state causing re-execution without closing prior connection

Fri Nov 5 11:25:03 EDT 2010

     [ https://jira.jboss.org/browse/TEIID-1221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-1221.
---------------------------------


> 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: Steven 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