I've found a problem when you have different collects in the return clause. I't only groups by the last of them, instead of doing the automatic aggregation. It only performs the collect on one of the fields, only retrieving one value for the rest of colletcts (I haven't been able to find an exact order of the affected collects).
A possible workaround is to force the automatic grouping by using WITH clauses, but the current behaviour is not as expected.
Hi,
I've found a problem when you have different collects in the return clause. I't only groups by the last of them, instead of doing the automatic aggregation. It only performs the collect on one of the fields, only retrieving one value for the rest of colletcts (I haven't been able to find an exact order of the affected collects).
A possible workaround is to force the automatic grouping by using WITH clauses, but the current behaviour is not as expected.