Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-198

ORDER BY in subquery does not work as expected (wrong results)

    XMLWordPrintable

    Details

      Description

      From: https://groups.google.com/forum/#!topic/mariadb-columnstore/xEWtv_bWlwI

      Hi all,

      while testing I found that the following query type produces unexpected (I'd say wrong) results.

      SELECT .. FROM (SELECT .. FROM .. ORDER BY 1) LIMIT 10

      That is, if an inner query has an ORDER BY clause and the outer query a LIMIT clause then the ordering is not preserved. This behavior is different from say the InnoDB storage engine. Is that intentional?

      Regards,
      Arno

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jswanhart Justin Swanhart (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.