Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.9.0
-
None
-
None
Description
Error is reported when running query "select distinct * from t".
It is a common feature that is better to be supported.
Did some investigation about this issue. In current implementation "select distinct a,b,c from t" is translated to "select a,b,c from t group by a,b,c". So select distinct * is translated literally to "select * from group by *". But * is not handled properly when processing groupby expressions.