Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Cannot Reproduce
- 
    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
Issue Links
- relates to
- 
                    MCOL-6088 alias: ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2016: Non supported item on the GROUP BY list. -         
- Open
 
-