You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
15 lines
390 B
Plaintext
15 lines
390 B
Plaintext
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;
|