DROP DATABASE IF EXISTS MCOL5755;
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);
SELECT b FROM t1 GROUP BY b;
b

1
HELLO
HELLO MY
NULL
a
hello
SELECT t FROM t1 GROUP BY t;
t

1
HELLO MY
NULL
a
hello
DROP DATABASE MCOL5755;