DROP DATABASE IF EXISTS mcol_4465;
CREATE DATABASE mcol_4465;
USE mcol_4465;
CREATE TABLE cs1(c char(9), d decimal(9,2))ENGINE=columnstore;
INSERT INTO cs1 VALUES('i',0),('i',0),('ii',0);
SELECT c,regr_count(d,length(c)) f FROM cs1 GROUP BY 1 ORDER BY 1;
c	f
i	2
ii	1
SELECT * FROM (SELECT c,regr_count(d,length(c)) f FROM cs1 GROUP BY 1 ORDER BY 1)a;
c	f
i	2
ii	1
DROP DATABASE mcol_4465;