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)