orientdb icon indicating copy to clipboard operation
orientdb copied to clipboard

WHERE does not work with default values on vertices created with the Java graph API

Open danielkasza opened this issue 10 years ago • 2 comments

Hello,

I think I found a really unusual issue in orientdb-community-2.1-rc6.

I have a class with properties and default values for some of the properties. If I create a Vertex with the Java graph API, and I let OrientDB assign the default values, WHERE cannot filter for them. If I do SELECT FROM MyClass, the values are assigned properly. If I do SELECT FROM MyClass WHERE property_with_default_value_of_zero=0, then the vertices do not show up.

I have indexes on these properties. Rebuilding all indexes resolves the issue. I suspect that the index is not getting updated when the default value is assigned.

The issues is not reproducible from Studio.

(I can provide code for setting up the schema if you have trouble reproducing the issue.)

danielkasza avatar Aug 03 '15 03:08 danielkasza

@laa did you close this because the issue is fixed?

danielkasza avatar Aug 09 '21 02:08 danielkasza

Hi @danielkasza , I was closing all issues which were not active for a long time. Because this issue is important for you I reopen it.

andrii0lomakin avatar Aug 09 '21 04:08 andrii0lomakin