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

[Warren Gibson (JIRA)]

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


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira