count(<field>) function broken for empty SELECTs

[mmacfadden]

OrientDB Version: 3.0.9

This is similar to #8280, which seems to only partially have been solved. When using count(*) and there are no matching items a proper result set is returned with a count of 0. However if you use count(<field>) and there are no matching elements an empty result set is returned.

CREATE CLASS Person;
CREATE PROPERTY Person.name STRING;

SELECT count(*) as count from Person;
-- returns: [{@version: 0, count: 0}]

SELECT count(name) as count from Person;
-- returns: []

INSERT INTO Person SET name="bob";

SELECT count(*) as count from Person;
-- returns: [{@version: 0, count: 1}]

SELECT count(name) as count from Person;
-- returns: [{@version: 0, count: 1}]

SELECT count(*) as count from Person WHERE name = "susan";
-- returns: `[{@version: 0, count: 0}]`

SELECT count(name) as count from Person WHERE name = "susan";
-- returns: []

So it seems like count(*) works properly. count(<field>) works when results match, but not when there are not records that match the SELECT.

[luigidellaquila]

Hi @mmacfadden

Thank you for reporting, I'm working to a fix now

Thanks

Luigi

[luigidellaquila]

Hi @mmacfadden

I just pushed a fix, it will be released with v 3.0.11

Thanks

Luigi