"distinct" queries aren't unique

[harryjamesuk]

Hi there,

It seems when I try to create a distinct query with the SDK it doesn't behave as such, and results returned are not unique.

Example code

var query = new Parse.Query("Score");
query.distinct("user");
query.find({useMasterKey: true}).then(function(results) {
   // results does not return unique users :(
});

The REST API behaves as expected here when performing the same query.

Running SDK v2.0.1, parse-server v3.0.0, node v8.11.4, mongo v4.0.1.

[flovilmart]

this is covered by a unit test here: https://github.com/parse-community/parse-server/blob/5974c7d/spec/ParseQuery.Aggregate.spec.js#L891

can you provide the logs when running with VERBOSE=1?

[flovilmart]

Well, your query is asking for all the dictinct users for a particular party object, from what I can see, there is a single user returned.

[harryjamesuk]

Edit: Whoops!

This was right, just I didn't realise .distinct() was actually a Promise that performs the query!