gluesql / gluesql / 17020393292

99%

push

github

Implement `DISTINCT` operations (#1710)

New features:
- Full SELECT DISTINCT support (single/multi-column and whole-row) and DISTINCT variants for aggregates including COUNT(DISTINCT *), SUM/AVG/MIN/MAX/VARIANCE/STDEV(DISTINCT ...).
- AST Builder: .distinct() and *_distinct helpers.

Changes:
- DISTINCT is propagated through translation and planning and enforced at execution (row deduplication).
- DISTINCT ON remains unsupported and now returns a clearer error.

Summary:
Adds end-to-end SQL DISTINCT support: parser records DISTINCT (rejects DISTINCT ON), planner preserves it, executor deduplicates rows or applies DISTINCT-aware aggregates, builder APIs expose .distinct(), and tests updated/added to exercise DISTINCT behavior.

632 of 633 new or added lines in 28 files covered. (99.84%)

40931 of 41763 relevant lines covered (98.01%)

64609.04 hits per line