Orientdb: Problem in projection and filtering in EmbeddedMap property.

[saeedtabrizi]

OrientDB Version: 2.2.22

Java Version: 1.8

OS: linux

Expected behavior

I defined an embeded map in User class and i want to project some map values after query on values .

select LinkedAccounts.values() fromUserwhere LinkedAccounts.values() contains (Provider = "google") and LinkedAccounts.keys() contains "google::0923887327kjhdsf783kjhf7"

returns some values and its ok

but select LinkedAccounts.values()[IsDefault = true] fromUserwhere LinkedAccounts.values() contains (Provider = "google") and LinkedAccounts.keys() contains "google::0923887327kjhdsf783kjhf7" returns a bracket only.

I test it by embedded list and it's ok . (same as documentation)
I test it by embedded set and it's not ok .
I test it by embedded map and it's not ok .

Is it right or there is a problem here .

Actual behavior

Project and filter on LinkedAccounts.values() with LinkedAccounts.values()[IsDefault = true] syntax .

I attached some pictures to describe better .

and compare to

Thanks
Saeed Tabrizi

[luigidellaquila]

Hi @saeedtabrizi

The syntax seems to be correct, so I'd say it's a bug.
Let me do a couple of tests, I'll be back to you asap

Thanks

Luigi

[luigidellaquila]

Hi @saeedtabrizi

I just pushed a fix that should solve the problem.
The fix will be released with 2.2.23

Thanks

Luigi

[saeedtabrizi]

Hi @luigidellaquila
It's so really super fast reaction as i expected.
Thanks

Saeed Tabrizi