mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-01 08:44:47 +03:00
65cde8c894
* feature: Special dictionary, we can pass with session veriable to modify codepaths and behaviour for testing and debugging
37 lines
770 B
Plaintext
37 lines
770 B
Plaintext
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;
|