[teiid-issues] [JBoss JIRA] Resolved: (TEIID-605) Push down query results different than MetaMatrix query results without push down - Oracle 11

Push down query results different than MetaMatrix query results without push down - Oracle 11 ---------------------------------------------------------------------------------------------- Key: TEIID-605 URL: https://jira.jboss.org/jira/browse/TEIID-605 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Environment: Running Teiid Server on Windows CTC Query testing client on Windows Reporter: Warren Gibson Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 Attachments: ERROR_sl_mm05_50301_ora9ds_bqt_RDBMS_Test_Queries_1000_TestQuery233_1_20090515_100436.xml This may not be a bug but may just be a decision point to determine if MetaMatrix should guarantee the same query results as if the query was pushed down to the source. In some cases different results can be expected from different DBMS sources. 1. Running Teiid Server with Console Extension Capability Class set to default (blank). 2. Run queries against Oracle 11 source. 3. Results show many examples where "nulls" are being handled differently in a push down ORDER BY situation than what our expected results reflect. 4. Basically in the Oracle 11 situation the "nulls" are showing up in the results just opposite from what MetaMatrix does. In other words in the following query "Select BQT1.SmallA.IntNum From BQT1.SmallA ORDER BY BQT1.SmallA.IntNum DESC" push down results shows "nulls" at the beginning of results whereas without push down MetaMatrix will show the "nulls" at the end of the results. 5. See attached results from this query.