Bug Description
The DISTINCT keyword does not correctly deduplicate results. It returns fewer rows than expected.
Severity
Critical
Failing Tests
Reproduction
CREATE TABLE items (id INTEGER PRIMARY KEY, category TEXT);
INSERT INTO items VALUES (1, 'A'), (2, 'A'), (3, 'B'), (4, 'B'), (5, 'C');
-- Should return 3 distinct categories
SELECT DISTINCT category FROM items;
Expected Behavior
Returns 3 rows: A, B, C
Actual Behavior
Returns only 1 row
Split from #13