search

NLeSC / 3D_geospatial_risk_management

2 stars 0 forks source link

Incorrect error message for aggregates... #30

Closed romulogoncalves closed 8 years ago

romulogoncalves commented 8 years ago

Hi,

The following is correct: sql>select id, ST_Triangulate2DZ(ST_Collect(geom), 0) from basepoints id;MAPI = monetdb@localhost:55000 QUERY = select id, ST_Triangulate2DZ(ST_Collect(geom), 0) from basepoints id; ERROR = !cannot use non GROUP BY column 'id' in query results without an aggregate function sql>

This error message is incorrect: sql>select ST_Triangulate2DZ(ST_Collect(geom), 0), id from basepoints id; MAPI = monetdb@localhost:55000 QUERY = select ST_Triangulate2DZ(ST_Collect(geom), 0), id from basepoints id; ERROR = !SELECT: identifier 'id' unknown sql>

Or at least miss leading.

romulogoncalves commented 8 years ago

The columns to aggregate should show up as last in the Select statement.