--source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS mcol_4465;
--enable_warnings
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;
SELECT * FROM (SELECT c,regr_count(d,length(c)) f FROM cs1 GROUP BY 1 ORDER BY 1)a;
DROP DATABASE mcol_4465;