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

[Warren Gibson (JIRA)]

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


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