Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Distinct only works on single fields #401

Open
torpedro opened this issue Dec 18, 2014 · 0 comments
Open

Distinct only works on single fields #401

torpedro opened this issue Dec 18, 2014 · 0 comments
Labels

Comments

@torpedro
Copy link
Contributor

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.

@torpedro torpedro added the bug label Dec 18, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant