Skip to content

DruidSQL ignoring order by direction of inner query #4128

@vogievetsky

Description

@vogievetsky

This is an error as running against master (NOT 0.10.0-rc2) this is related to #4085 which is not part of 0.10.0-rc2 IIRC

These two queries return the same results:

Query asc:

SELECT * FROM (
  SELECT "channel"
  FROM "wikiticker-v2"
  GROUP BY "channel"
  ORDER BY "channel" asc
) LIMIT 5

Query desc

SELECT * FROM (
  SELECT "channel"
  FROM "wikiticker-v2"
  GROUP BY "channel"
  ORDER BY "channel" desc
) LIMIT 5

It always does ascending (desc is ignored)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions