[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1283) Race condition results in bad resultset for query on union

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-1283.
-----------------------------------

    Fix Version/s: 7.1.1
       Resolution: Done


marking as resolved

> Race condition results in bad resultset for query on union
> ----------------------------------------------------------
>
>                 Key: TEIID-1283
>                 URL: https://jira.jboss.org/browse/TEIID-1283
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1
>         Environment: MaxOS 10.6.4, JBoss 5.1.0
>            Reporter: Howard Abrams
>            Assignee: Steven Hawkins
>             Fix For: 7.1.1
>
>
> Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS in this case)
> Take a view, call it 'B', backed by a file connector
> From JDBC, make the query:
> Select * from (select * from A union select * from B) where foo='bar'. 
> where 'bar' is only found in B, not A.
> Execute the query get back a resultset:
> ResultSet r = statement.executeQuery();
> but this code will fail with a "resultset cursor is after the last row"
> if ( r.next )
> String foo = r.getString(1);
> but this code will work correctly:
> Thread.sleep(1000);
> if ( r.next )
> String foo = r.getString(1);
> Putting the union in a materialized view also works.

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