Missing check for SELECT clause if GROUP BY or aggregation is used

IITDBGroup / gprom

GProM is a middleware that adds support for provenance to database backends.

http://www.cs.iit.edu/%7edbgroup/research/gprom.php

Apache License 2.0

9 stars 5 forks source link

Missing check for SELECT clause if GROUP BY or aggregation is used #11

Closed lordpretzel closed 4 years ago

lordpretzel commented 7 years ago

If we use group-by and/or aggregation, then the select clause cannot contain non-aggregated attributes in expressions unless these expression are in the group-by clause. We do not check this currently.

Example:

./src/command_line/gprom -backend sqlite -db examples/test.db -query  "SELECT a,b FROM r GROUP BY b;"