Skip to content

Issue with ORDER BY clause by original column name when GROUP BY used #2515

Description

@IMMSPgisgroup

As I see in the browser version of AlaSQL 4.17.2:

alasql("SELECT num As position, letter As note FROM ? GROUP BY num, letter ORDER BY num", [[{"num": 100, "letter": "one"}, {"num": 50, "letter": "two"}, {"num": 10, "letter": "two"}]]);

or

alasql("SELECT num As position, letter As note FROM ? GROUP BY num, letter ORDER BY num ASC", [[{"num": 100, "letter": "one"}, {"num": 50, "letter": "two"}, {"num": 10, "letter": "two"}]]);

or

alasql("SELECT num As position, letter As note FROM ? GROUP BY num, letter ORDER BY num DESC", [[{"num": 100, "letter": "one"}, {"num": 50, "letter": "two"}, {"num": 10, "letter": "two"}]]);
position note
100 one
50 two
10 two

In result I have non-sorted JSON-array.
Ordering by column doesn`t work in AlaSQL for this sample.

Is this wrong? Because in PostgreSQL 17, as I see:

SELECT num As position, letter As note FROM (VALUES (100, 'one'), (50, 'two'), (10, 'two')) As t (num, letter) GROUP BY num, letter ORDER BY num;
position note
10 two
50 two
100 one

(3 rows)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions