--disable_warnings
DROP DATABASE IF EXISTS MCOL5755;
--enable_warnings
CREATE DATABASE MCOL5755;
USE MCOL5755;
CREATE TABLE t1 (t TEXT,c CHAR(10),b BLOB) ENGINE = columnstore;
INSERT INTO t1 VALUES (NULL,NULL,NULL);
INSERT INTO t1 VALUES ("","","");
INSERT INTO t1 VALUES ("hello","hello","hello");
INSERT INTO t1 VALUES ("HELLO","HELLO","HELLO");
INSERT INTO t1 VALUES ("HELLO MY","HELLO MY","HELLO MY");
INSERT INTO t1 VALUES ("a","a","a");
INSERT INTO t1 VALUES (1,1,1);
--sorted_result
SELECT b FROM t1 GROUP BY b;
--sorted_result
SELECT t FROM t1 GROUP BY t;
DROP DATABASE MCOL5755;