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

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-605.
----------------------------------

    Fix Version/s: 6.2.0
                       (was: 6.3.0)
       Resolution: Done


The JDBC connector code, and in particular the OracleSQLTranslator, was updated to allow for use of explicit null ordering.  The results should now match.

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

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