Red Hat Bugzilla – Bug 1254053
Incorrect results when querying a string type attribute when using the 'LTE' operator
Last modified: 2015-11-19 11:43:07 EST
This is using the hot rod client.
Steven Hawkins <firstname.lastname@example.org> updated the status of jira TEIID-3627 to Resolved
This cannot work if the types of the two operands are mismatched.
The correct behaviour would be to signal an error instead of failing silently.
I think the argument=-22 in incorrectly displayed thru debug.
The query being processed is:
SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.stringNum <= '-22'
The column stringNum is of type String and the string literal of '-22' is what is being set for value:
So I think the types being compared are similar types.
Steven Hawkins <email@example.com> updated the status of jira TEIID-3627 to Closed
So the two operands have the same type, string. In that case please note the comparison '-55' <= '-22' is false. This is probably not what you would expect.
How does your data look like? Does it really match the comparison?
Adrian Nistor <firstname.lastname@example.org> updated the status of jira ISPN-5923 to Coding In Progress
Patch was merged.