[teiid-issues] [JBoss JIRA] (TEIID-1775) Ingres as source - WHERE CLAUSE is not returning expected results in some cases

[Van Halbert (Moved) (JIRA)]

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

Van Halbert moved SOA-3458 to TEIID-1775:
-----------------------------------------

              Project: Teiid  (was: JBoss Enterprise SOA Platform)
                  Key: TEIID-1775  (was: SOA-3458)
    Affects Version/s: 7.4.1
                           (was: 5.2.0.ER4)
          Component/s: Misc. Connectors
                           (was: EDS)
             Security:     (was: Public)

    
> Ingres as source - WHERE CLAUSE is not returning expected results in some cases
> -------------------------------------------------------------------------------
>
>                 Key: TEIID-1775
>                 URL: https://issues.jboss.org/browse/TEIID-1775
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 7.4.1
>            Reporter: Warren Gibson
>            Assignee: Van Halbert
>
> EDS Query Testing is getting unexpected results on 24 queries involving WHERE CLAUSE.  A few examples queries are given below:
> SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue > '17:00:00' ORDER BY TimeValue  (Expected 11 records but received 23)
> SELECT INTKEY, FLOATNUM FROM BQT1.SmallA WHERE RIGHT(FLOATNUM, 1) <> 0 ORDER BY INTKEY (Expected 43 records but received only 0)
> SELECT BQT1.SmallA.StringKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.StringKey = convert(BQT2.SmallB.FloatNum, string) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.StringKey  (Expected 25 records but received only 0)
> SELECT IntKey, TimeValue FROM (SELECT IntKey, TimeValue FROM BQT2.SmallA WHERE IntKey > 5) AS x WHERE TimeValue >= '17:00:00'  ( Expected 13 records but received 20)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira