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
10 lines
341 B
Plaintext
10 lines
341 B
Plaintext
DROP DATABASE IF EXISTS `mcol-5438`;
|
|
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;
|
|
(COUNT(CASE WHEN d IN(42,4) THEN 1 ELSE 0 END) * 100/SUM(1))*0
|
|
0.0000
|
|
DROP DATABASE `mcol-5438`;
|