coalesce function should return value for $value.field

[grzegorz-aniol]

OrientDB Version: 3.0.9

Java Version: 1.8

OS: Windows 10

Expected behavior

coalesce function should properly identify not null value referenced as $profile.Name

Actual behavior

The function returns last argument(i.e. 'Unknown') even when first argument is not null

Steps to reproduce

Run following query on demo database:

select @rid, @class, Phone, OrderedId,
  $profile.Name,
  coalesce($profile.Name, 'Unknown')
from Customers
let $profile = out('HasProfile')[0]

[pedroteixeira]

I noticed that it gives expected result if using this syntax:

select @rid, @class, Phone, OrderedId, coalesce(out('HasProfile')[0].Name, 'Unknown') from Customers

[luigidellaquila]

Hi @grzegorz-aniol

I just pushed a fix for this problem, it will be released with v 3.0.12

Thanks

Luigi