This is using the hot rod client.

Steven Hawkins <shawkins@redhat.com> 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:

{code}
SELECT g_0.stringNum FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.stringNum <= '-22'
{code}

The column stringNum is of type String and the string literal of '-22' is what is being set for value:

{code}
return queryBuilder.having(columnName).lte(value);
{code}

So I think the types being compared are similar types.

Steven Hawkins <shawkins@redhat.com> updated the status of jira TEIID-3627 to Closed

Hi Van,

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

Adrian Nistor <anistor@redhat.com> updated the status of jira ISPN-5923 to Coding In Progress

Patch was merged.