Aggregate function bug on macOS version

[giovanniborga]

Bug description:
Note that it occurs ONLY WITH MACOS VERSION of QGIS.
For numeric fields, setting "first_value" on aggregate function inside AGGREGATE process dialogue doesn't take effect. Processing tool returns always SUM of numeric values.

How to Reproduce:

1. Open a new project on a QGIS MACOS System
2. Add a vector layer
3. Choose Vector Geometry -> Aggregate from Geoprocessing Tools panel
4. Set input layer and a numeric field as aggregate field
5. Set some aggregate functions for existing fields
6. Set "first_value" for the field used in step 4 to get references for results dataset rows
7. execute
8. check result: values in filed used in step 4 are summed instead of first_values

QGIS and OS versions:
All 3.x versions (until 3.10) for MAC OS.

[gioman]

it works as expected on other platforms?

[giovanniborga]

Yes. On Windows it works perfectly!

[gioman]

Yes. On Windows it works perfectly!

is data dependent?

[giovanniborga]

do you mean "data-type" dependant?

[gioman]

do you mean "data-type" dependant?

also, but also if it happens with specific datasets rather than any dataset.

[giovanniborga]

I teach GIS from several years ... having students with both Windows and MAC OSes. I think I saw this bug about almost 3 years ago and it has never been solved (I suppose few persons encountered it).
I used different datasets and everytime I encountered the bug so, yes, I think it happens with any dataset... I don't know if the bug occurs on string fields; I remember only that numeric fields were always summed instead of selected the first value … (I cannot reproduce the bug now because I'm a MS user)

[gioman]

so, yes, I think it happens with any dataset.

just to be sure an you attach a dataset where you observe this? thanks.

[giovanniborga]

buildings.zip
Today we worked with this tiny layer.
Just aggregate by "zones_id", compute count of "NUMERO", sum of "volume" and first of "zones_id".
MAC users just had zones_ids summed instead of first_selected.

… But I really suppose it occurs with any other dataset ...

[gioman]

@giovanniborga for what is worth, I get expected results on Linux/QGIS 3.4. I can't test on macOS.

[DelazJ]

I'm afraid the issue is worse. Here's the settings in the aggregates dialog, using Mojave

Here's the call when it's executed

Everything is about SUM though I asked none

[giovanniborga]

I supposed it was so ...

[gioman]

I also see this now that I can test on macOS...

[gioman]

For a quick check compare to results given by the "group stats" plugin.

[PeterPetrik]

Cannot replicate with the latest master anymore https://qgis.org/downloads/macos/nightly/qgis_nightly_master_20201005_122844.dmg

[gioman]

Closing for lack of further feedback.