[v3.0.0] IN operator and UNIQUE_HASH_INDEX index cause an error

[mehdizarepour]

OrientDB Version: 3.0.0

Java Version: 1.8

OS: Linux

Using IN operator on a property that has UNIQUE_HASH_INDEX index cause an error

Expected/Actual behavior

The following queries should return a few records but first query throws java.lang.UnsupportedOperationException: Cannot evaluate id IN [1, 2] on index User.id error. (I think it's because the id property uses UNIQUE_HASH_INDEX index!) but second query works fine (the key property uses UNIQUE index).

Queries:

1. select from User where id in [1, 2]

2. select from User where key in [1, 2]

Steps to reproduce

Run these commands:

/* schema */

create class User extends V;

create property User.id Integer;

create property User.key Integer;



CREATE INDEX User.id ON User (id) UNIQUE_HASH_INDEX;

CREATE INDEX User.key ON User (key) UNIQUE;



/* data */

create vertex User set id = 1, key = 1;

create vertex User set id = 2, key = 2;

create vertex User set id = 3, key = 3;



select from User where id in [1, 2]    /* it cause an error */

[luigidellaquila]

Hi @mehdizarepour

This issue is already fixed in latest snapshot ( https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/3.0.1-SNAPSHOT/ )

Could you please double-check and confirm that is solves the problem?

Thanks

Luigi

[mehdizarepour]

Hi @luigidellaquila

The problem is solved!

Thanks