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

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