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

Issue with query result sorting

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.0.0
    • Icebox
    • ExeMgr
    • None

    Description

      Build tested: 1.5.4-1 (drone #441)

      Some queries returned results in incorrect order. For example:

      SELECT
      `LOGICAL_TABLE_1`.`p_name` AS `COL0`,
      `LOGICAL_TABLE_1`.`p_size` AS `COL1`
      FROM
      (select * from part where p_partkey < 20 limit 10) `LOGICAL_TABLE_1`
      ORDER BY COL0, COL1;
      COL0 COL1
      goldenrod lavender spring chocolate lace 7
      blush thistle blue yellow saddle 1
      spring green yellow purple cornsilk 21
      cornflower chocolate smoke green pink 14
      forest brown coral puff cream 15
      bisque cornflower lawn forest magenta 4
      moccasin green thistle khaki floral 45
      misty lace thistle snow royal 41
      thistle dim navajo dark gainsboro 12
      linen pink saddle puff powder 44

      The columns are not sorted
      Another example. the view is a join of two tables

      select * from bug6134vv order by 1, 2, 3;
      a b c
      1 1 2
      1 1 3
      1 1 1
      2 2 1
      2 2 2

      the third column is not sorted correctly.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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