Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17790

order by desc (descending) parameter ignored if multiple expressions specified.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.2.18
    • N/A
    • Optimizer
    • None
    • CentOS Linux release 7.5.1804 (Core)

    Description

      Table (mysqldump of bug_table2 attached) with two columns, "group_name" and "priority".
      1. The command "select * from bug_table2 order by priority desc;" produces correct descending output.
      2. The command "select * from bug_table2 order by priority,group_name desc;" produces incorrect ascending output.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            crlb Colin Leavett-Brown
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.