hyrise / hyrise-v1

HYRISE In-Memory Hybrid Storage Engine (archived, now developed in hyrise/hyrise repo)
https://github.com/hyrise/hyrise
MIT License
89 stars 44 forks source link

Distinct only works on single fields #401

Open torpedro opened 9 years ago

torpedro commented 9 years ago

Distinct operator can only handle a single definition of field, but we specify a list of fields in the json. https://github.com/hyrise/hyrise/blob/master/src/lib/access/Distinct.cpp#L27

In the documentation it sounds like it could handle multiple fields. https://github.com/hyrise/hyrise/blob/master/docs/documentation/queryexecution/json_plan_operations.rst

Plus: The distinct operator returns all columns, not only those that have been specified in the distinct. This is not the behaviour that one would expect when doing a SELECT DISTINCT in SQL. I think it should be the same here.