Skip to content

ORDER BY / GROUP BY Column-Number with COLLATE Ignored #6410

@Pavan-Nambi

Description

@Pavan-Nambi
CREATE TABLE t(x TEXT);
INSERT INTO t VALUES('b'),('A'),('c'),('a');
SELECT x FROM t ORDER BY 1 COLLATE NOCASE;
-- SQLite: A, a, b, c  (case-insensitive sort)
-- Turso:  b, A, c, a  (insertion order)
SELECT x, sum(v) FROM t GROUP BY 1 COLLATE NOCASE;
-- SQLite: a|4, b|2  (a and A grouped)
-- Turso:  a|6       (all grouped as one — GROUP BY constant 1)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions