DROP DATABASE IF EXISTS pron;
CREATE DATABASE pron;
USE pron;
CREATE TABLE t
(
a double
) ENGINE=Columnstore;
INSERT INTO t VALUES(1.5707963267948966);
SHOW variables like 'columnstore_pron';
Variable_name	Value
columnstore_pron	
SELECT sin(a) from t;
sin(a)
1
SET columnstore_pron='{"megasinus": "123"}';
SHOW variables like 'columnstore_pron';
Variable_name	Value
columnstore_pron	{"megasinus": "123"}
SELECT sin(a) from t;
sin(a)
123
SET columnstore_pron='{"megasinus": "-200"}';
SHOW variables like 'columnstore_pron';
Variable_name	Value
columnstore_pron	{"megasinus": "-200"}
SELECT sin(a) from t;
sin(a)
-200
SET columnstore_pron='';
SHOW variables like 'columnstore_pron';
Variable_name	Value
columnstore_pron	
SELECT sin(a) from t;
sin(a)
1
DROP DATABASE pron;