Drops the duplicated items of a list, as a SELECT DISTINCT would: the
first occurrence of every item is kept, in its order, the next ones are
dropped. Two items are duplicates when they hold the same fields with the
same values, whatever the order of the fields, compared through their
JSON representation (Dates by their ISO string, nested objects by their
content); a primitive or null item is a duplicate of an equal one.
Meant to run after projectItems: the duplicates are then found on
the projected fields only.
The list and its items are never mutated; the result is always a new array.
Drops the duplicated items of a list, as a
SELECT DISTINCTwould: the first occurrence of every item is kept, in its order, the next ones are dropped. Two items are duplicates when they hold the same fields with the same values, whatever the order of the fields, compared through their JSON representation (Dates by their ISO string, nested objects by their content); a primitive ornullitem is a duplicate of an equal one. Meant to run after projectItems: the duplicates are then found on the projected fields only. The list and its items are never mutated; the result is always a new array.