Minor Description
select c1, c2, DISTINCT c3 from default USE KEYS ["1","2"];
Above statement gives syntax error. Not Below.
select c1, c2, (DISTINCT c3) from default USE KEYS ["1","2"];
DISTINCT on all projection is possible. Not sure what is meaning on DISTINCT on single column of multi column projection (It should return error too).
Attachments
| For Gerrit Dashboard: MB-38208 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 150971,3 | MB-38208 Disallow DISTINCT/ANY in select expression terms (allow only after SELECT itself) | master | query | Status: MERGED | +2 | +1 |