[teiid-issues] [JBoss JIRA] Commented: (TEIID-1603) BQT Query not returning expected row count

BQT Query not returning expected row count ------------------------------------------ Key: TEIID-1603 URL: https://issues.jboss.org/browse/TEIID-1603 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Environment: Running BQT Query Suite against Teiid 7.4 Reporter: Warren Gibson Assignee: Steven Hawkins Attachments: RDBMS_Test_Queries_9600_TestQuery63.xml Teiid 7.4 - the following query is returning no rows but the expected row count is 47 rows. This was tested with MySql50 and Teradata12. I verified the query produced 47 rows with SOA-P 5.1 GA. See expected query results file attached. VDB can be made available if needed. SELECT INTKEY, DATEVALUE, BYTENUM FROM BQT1.SmallA WHERE DATEVALUE <> ANY (SELECT DATEVALUE FROM BQT1.SmallA WHERE BYTENUM >= '-108') The source query from the log file is: SELECT cast(g_0.INTKEY AS signed) AS c_0, g_0.DATEVALUE AS c_1, g_0.BYTENUM AS c_2 FROM smalla AS g_0 WHERE g_0.DATEVALUE NOT IN (SELECT g_1.DATEVALUE FROM smalla AS g_1 WHERE g_1.BYTENUM >= -108) LIMIT 100