DROP DATABASE IF EXISTS mcol_4611;
CREATE DATABASE mcol_4611;
USE mcol_4611;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a DECIMAL(18,0)) ENGINE=ColumnStore;
INSERT INTO t1 VALUES (999999999999999999);
SELECT a MOD 10000 FROM t1;
a MOD 10000
9999
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a DECIMAL(18,0)) ENGINE=ColumnStore;
INSERT INTO t1 VALUES (999999999999999999);
SELECT RAND(9999), RAND(a MOD 10000) FROM t1;
RAND(9999)	RAND(a MOD 10000)
0.7361292641015065	0.7361292641015065
DROP TABLE IF EXISTS t1;
DROP DATABASE mcol_4611;