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

Group By ... Order By NULL fails

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None
    • Server version: 10.5.5-MariaDB MariaDB Server
      Columnstore: 1.5.4-1

    Description

      Group By ... Order By NULL fails on Columnstore.

      Repro
      ------
      DROP TABLE IF EXISTS t1, t2;

      CREATE TABLE t1 (
      spID int(10) unsigned,
      userID int(10) unsigned,
      score smallint(5) unsigned,
      date date
      ) ENGINE=Columnstore;
      INSERT INTO t1 VALUES (1,1,1,'','0000-00-00');

      CREATE TABLE t2 (
      userID int(10) unsigned NOT NULL,
      niName char(15)
      ) ENGINE=Columnstore;
      INSERT INTO t2 VALUES (1,'name');

      SELECT t2.userid, MIN(t1.score)
      FROM t1, t2 WHERE t1.userID=t2.userID GROUP BY t2.userid ORDER BY NULL;
      ERROR 1815 (HY000): Internal error: IDB-2021: 'unknown db.unknown table.unknown field' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be included in the GROUP BY clause.

      On InnoDB
      ------------
      SELECT t2.userid, MIN(t1.score)
      -> FROM t1, t2 WHERE t1.userID=t2.userID GROUP BY t2.userid ORDER BY NULL;
      Empty set (0.002 sec)

      Attachments

        Activity

          People

            Unassigned Unassigned
            susil.behera susil.behera
            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.