IN operator not working on Short type fields

[mehdizarepour]

OrientDB Version: 2.2.24

Java Version: 1.8

OS: Linux, MacOS

I want to use IN operator to filter records.

Steps to reproduce

/* schema */
create class User extends V;
create property User.state Short;

/* data*/
create vertex User set state = 1;
create vertex User set state = 1;
create vertex User set state = 2;

queries:

select from User where state in [1]

select from User where state in 1

Expected/Actual behavior

These queries should return two records, but instead, it returns nothing.
It should be noted that when I use Integer instead of Short, the queries are work as expected.

Thanks

[luigidellaquila]

Hi @mehdizarepour

Thank you for reporting, I'll check it asap

Thanks

Luigi

[mehdizarepour]

Hi @luigidellaquila

The CONTAINS operator has the same problem.

[luigidellaquila]

Hi @mehdizarepour

I just pushed a fix on 2.2.x, the fix will be released with 2.2.25

Thanks

Luigi