Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3253

Expand allowed order by expressions

    Details

    • Type: Enhancement
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 8.10
    • Component/s: Query Engine
    • Labels:
      None

      Description

      with a non-simple query we won't allow derived expressions in the order by such as:

      select max(x), y from t group by y order by case when y is null then 0 else y end

      We treat this ordering as unrelated - however it is expressed in terms of expressions from the select clause. Mondrian will generate queries of this form, which requires a workaround of modifying the dialect to use ansi null ordering.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  shawkins Steven Hawkins
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: