[teiid-issues] [JBoss JIRA] Updated: (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 updated TEIID-605:
---------------------------------

    Fix Version/s: 6.2.0
         Priority: Minor  (was: Major)


This is not a regression, it's something we've never considered before.  Since there is no standard sources are free to treat nulls as always first, always last, high, low, etc.  Our handling is to treat them as low.  The fix for this may be to have the capabilities indicate what null handling is support and to take remediation steps if it is not nulls low (or whatever our default may be).

> 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