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