Issue Summary

IN operator is not working when there is a single text in the parentheses when the value is beyond 32 32-bit integer (2,147,483,647) in Re-Arch systems. However, when there are two texts, it works.

Steps to Reproduce

1. Attribute name: CustomerID
2. Attribute type: Text
3. AQL with IN operator:
   • "CustomerID" IN ("6000000010") - This AQL is not working
   • "CustomerID" IN ("6000000010","6000000011") - Working
4. AQL with equal sign:
   • "CustomerID" = "6000000010" - This AQL is working

Expected Results

AQL should return the value.

Actual Results

AQL is not returning anything.

...

Workaround

Use the equal sign instead of the IN operator.