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
14 lines
353 B
Plaintext
14 lines
353 B
Plaintext
-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS `mcol-5438`;
|
|
--enable_warnings
|
|
CREATE DATABASE `mcol-5438`;
|
|
USE `mcol-5438`;
|
|
|
|
CREATE TABLE cs1 (d DECIMAL(38))ENGINE=COLUMNSTORE;
|
|
INSERT INTO cs1 VALUES (42);
|
|
SELECT (COUNT(CASE WHEN d IN(42,4) THEN 1 ELSE 0 END) * 100/SUM(1))*0 from cs1;
|
|
|
|
DROP DATABASE `mcol-5438`;
|