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

[Steven Hawkins (Resolved) (JIRA)]

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

Steven Hawkins resolved TEIID-1775.
-----------------------------------

    Resolution: Won't Fix


See the resolution of TEIID-1774.  Freshly created time values do not exhibit the same behavior as the bqt queries.  The workaround would be to model the column as timestamp and cast to time.  If this becomes a customer issue then a fix can be investigated based upon the actual native type.

As for the string form of the floating point values, there is already a KI covering that.
                
> 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: Steven Hawkins
>
> 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