Skip to content

bug: SELECT DISTINCT returns incomplete results #26

@mjm918

Description

@mjm918

Bug Description

The DISTINCT keyword does not correctly deduplicate results. It returns fewer rows than expected.

Severity

Critical

Failing Tests

  • select_distinct

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

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions