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

Internal sorting orientation regression

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.2.0
    • 1.2.0
    • ExeMgr
    • 2018-11

    Description

      Changes made for MCOL-1052[1] reverts the default orientation of a set internally sorted by CS.
      select d_yearmonthnum * 100 + 1 d_start , count from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1;

      ####before the change
      MariaDB [ssb]> select d_yearmonthnum * 100 + 1 d_start , count from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1;
      ------------------+

      d_start count

      ------------------+

      19980301 23

      ------------------+
      1 row in set (0.07 sec)

      after the change
      MariaDB [ssb]> select d_yearmonthnum * 100 + 1 d_start , count from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1;
      ------------------+

      d_start count

      ------------------+

      19980201 20

      ------------------+
      1 row in set (0.01 sec)

      1. https://github.com/mariadb-corporation/mariadb-columnstore-engine/commit/5d48ddb158d33f2ff903a7448315a0c12bc71c2f

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            drrtuy Roman
            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.