How is this possible: distinct(property) does not return all the values contained in the property

24 views

distinctfilterinconsistencypropertywhere

Skip to first unread message

retrography

unread,

Apr 14, 2015, 1:25:30 PM4/14/15

to orient-...@googlegroups.com

Here is the dilemma, without any introduction:

orientdb {db=test}> select distinct(type) from User

----+------+--------
# |@CLASS|distinct
----+------+--------
0 |null |person
----+------+--------

orientdb {db=test}> select distinct(type) from User where type<>'person'

----+------+------------
# |@CLASS|distinct
----+------+------------
0 |null |organization
----+------+------------

orientdb {db=test}> select name,email from User where type<>'person' limit 10

----+------+------------------------------------------
# |@CLASS|name
----+------+------------------------------------------
0 |null |PerfectLine
1 |null |Sappho OSS
2 |null |The 88
3 |null |null
4 |null |simplabs
5 |null |Everyday Hero
6 |null |Sorenson Media
7 |null |3scale
8 |null |null
9 |null |Rubymotion community
----+------+------------------------------------------