DROP DATABASE IF EXISTS mcs94_db;
CREATE DATABASE mcs94_db;
USE mcs94_db;
CREATE TABLE t1 (a INT, b DECIMAL(5,2))ENGINE=Columnstore;
INSERT INTO t1 VALUES(NULL, NULL), (0, 0.0), (1, 11.11), (10, 82.12), (-15, -202.19), (-297, 0.41), (719, 359.9);
SELECT a, ABS(a), b, ABS(b) FROM t1;
a	ABS(a)	b	ABS(b)
NULL	NULL	NULL	NULL
0	0	0.00	0.00
1	1	11.11	11.11
10	10	82.12	82.12
-15	15	-202.19	202.19
-297	297	0.41	0.41
719	719	359.90	359.90
SELECT a, ACOS(a), b, ACOS(b) FROM t1;
a	ACOS(a)	b	ACOS(b)
NULL	NULL	NULL	NULL
0	1.5707963267948966	0.00	1.5707963267948966
1	0	11.11	NULL
10	NULL	82.12	NULL
-15	NULL	-202.19	NULL
-297	NULL	0.41	1.148342264608141
719	NULL	359.90	NULL
SELECT a, ASIN(a), b, ASIN(b) FROM t1;
a	ASIN(a)	b	ASIN(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1.5707963267948966	11.11	NULL
10	NULL	82.12	NULL
-15	NULL	-202.19	NULL
-297	NULL	0.41	0.42245406218675574
719	NULL	359.90	NULL
SELECT a, ATAN(a), b, ATAN(b) FROM t1;
a	ATAN(a)	b	ATAN(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	0.7853981633974483	11.11	1.4810292240335177
10	1.4711276743037347	82.12	1.5586196271418689
-15	-1.5042281630190728	-202.19	-1.5658505241027163
-297	-1.567429336151389	0.41	0.3890972310552784
719	1.5694055071075437	359.90	1.5680177843482004
SELECT a, CEIL(a), b, CEIL(b) FROM t1;
a	CEIL(a)	b	CEIL(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	12
10	10	82.12	83
-15	-15	-202.19	-202
-297	-297	0.41	1
719	719	359.90	360
SELECT a, CEILING(a), b, CEILING(b) FROM t1;
a	CEILING(a)	b	CEILING(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	12
10	10	82.12	83
-15	-15	-202.19	-202
-297	-297	0.41	1
719	719	359.90	360
SELECT a, CONV(a, 10, 2)  FROM t1;
a	CONV(a, 10, 2)
NULL	NULL
0	0
1	1
10	1010
-15	1111111111111111111111111111111111111111111111111111111111110001
-297	1111111111111111111111111111111111111111111111111111111011010111
719	1011001111
SELECT a, CONV(a, 10, 8)  FROM t1;
a	CONV(a, 10, 8)
NULL	NULL
0	0
1	1
10	12
-15	1777777777777777777761
-297	1777777777777777777327
719	1317
SELECT a, CONV(a, 10, 16)  FROM t1;
a	CONV(a, 10, 16)
NULL	NULL
0	0
1	1
10	A
-15	FFFFFFFFFFFFFFF1
-297	FFFFFFFFFFFFFED7
719	2CF
SELECT a, COS(a), b, COS(b) FROM t1;
a	COS(a)	b	COS(b)
NULL	NULL	NULL	NULL
0	1	0.00	1
1	0.5403023058681398	11.11	0.1141761752318889
10	-0.8390715290764524	82.12	0.9053509108041206
-15	-0.7596879128588213	-202.19	0.42840437390108005
-297	-0.11921006489861569	0.41	0.9171208228166051
719	-0.9111551063193005	359.90	-0.18654198473652675
SELECT a, COT(a), b, TRUNCATE(COT(b),16) FROM t1 WHERE a != 0;
a	COT(a)	b	TRUNCATE(COT(b),16)
1	0.6420926159343306	11.11	-0.1149277431287026
10	1.5423510453569202	82.12	2.1319216370997434
-15	1.1682333052318372	-202.19	-0.4741151816571655
-297	0.12006625072585818	0.41	2.3008012066703190
719	-2.211200428423707	359.90	-0.1898748600763736
SELECT a, CRC32(a), b, CRC32(b) FROM t1;
a	CRC32(a)	b	CRC32(b)
NULL	NULL	NULL	NULL
0	4108050209	0.00	438520328
1	2212294583	11.11	3081016717
10	2707236321	82.12	822610344
-15	1597689648	-202.19	708595064
-297	3804934580	0.41	155762586
719	1195222461	359.90	3443556993
SELECT a, DEGREES(a), b, DEGREES(b) FROM t1;
a	DEGREES(a)	b	DEGREES(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	57.29577951308232	11.11	636.5561103903445
10	572.9577951308232	82.12	4705.129413614321
-15	-859.4366926962349	-202.19	-11584.633659750114
-297	-17016.84651538545	0.41	23.49126960036375
719	41195.66546990619	359.90	20620.751046758327
SELECT a, EXP(1), b, EXP(b) FROM t1;
a	EXP(1)	b	EXP(b)
NULL	2.718281828459045	NULL	NULL
0	2.718281828459045	0.00	1
1	2.718281828459045	11.11	66836.191384222
10	2.718281828459045	82.12	4.615968685174254e35
-15	2.718281828459045	-202.19	1.5488119969519035e-88
-297	2.718281828459045	0.41	1.5068177851128535
719	2.718281828459045	359.90	2.0071694443435105e156
SELECT a, FLOOR(a), b, FLOOR(b) FROM t1;
a	FLOOR(a)	b	FLOOR(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	11
10	10	82.12	82
-15	-15	-202.19	-203
-297	-297	0.41	0
719	719	359.90	359
SELECT a, LN(a), b, LN(b) FROM t1;
a	LN(a)	b	LN(b)
NULL	NULL	NULL	NULL
0	NULL	0.00	NULL
1	0	11.11	2.4078456036515385
10	2.302585092994046	82.12	4.408181592150733
-15	NULL	-202.19	NULL
-297	NULL	0.41	-0.8915981192837836
719	6.577861357721047	359.90	5.885826215084985
SELECT a, LOG(a), b, LOG(b) FROM t1;
a	LOG(a)	b	LOG(b)
NULL	NULL	NULL	NULL
0	NULL	0.00	NULL
1	0	11.11	2.4078456036515385
10	2.302585092994046	82.12	4.408181592150733
-15	NULL	-202.19	NULL
-297	NULL	0.41	-0.8915981192837836
719	6.577861357721047	359.90	5.885826215084985
SELECT a, LOG2(a), b, LOG2(b) FROM t1;
a	LOG2(a)	b	LOG2(b)
NULL	NULL	NULL	NULL
0	NULL	0.00	NULL
1	0	11.11	3.473786911614367
10	3.321928094887362	82.12	6.359661722333877
-15	NULL	-202.19	NULL
-297	NULL	0.41	-1.286304185156641
719	9.489847960439297	359.90	8.491452292037366
SELECT a, LOG10(a), b, LOG10(b) FROM t1;
a	LOG10(a)	b	LOG10(b)
NULL	NULL	NULL	NULL
0	NULL	0.00	NULL
1	0	11.11	1.0457140589408676
10	1	82.12	1.9144489406985543
-15	NULL	-202.19	NULL
-297	NULL	0.41	-0.38721614328026455
719	2.8567288903828825	359.90	2.5561818466529114
SELECT a, MOD(a, 10), b, MOD(b, 10) FROM t1;
a	MOD(a, 10)	b	MOD(b, 10)
NULL	NULL	NULL	NULL
0	0	0.00	0.00
1	1	11.11	1.11
10	0	82.12	2.12
-15	-5	-202.19	-2.19
-297	-7	0.41	0.41
719	9	359.90	9.90
SELECT a, MOD(a, 2), b, MOD(b, 2) FROM t1;
a	MOD(a, 2)	b	MOD(b, 2)
NULL	NULL	NULL	NULL
0	0	0.00	0.00
1	1	11.11	1.11
10	0	82.12	0.12
-15	-1	-202.19	-0.19
-297	-1	0.41	0.41
719	1	359.90	1.90
SELECT a, POW(a, 2), b, POW(b, 2) FROM t1;
a	POW(a, 2)	b	POW(b, 2)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	123.43209999999999
10	100	82.12	6743.6944
-15	225	-202.19	40880.7961
-297	88209	0.41	0.16809999999999997
719	516961	359.90	129528.00999999998
SELECT a, RADIANS(a), b, RADIANS(b) FROM t1;
a	RADIANS(a)	b	RADIANS(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	0.017453292519943295	11.11	0.19390607989657
10	0.17453292519943295	82.12	1.4332643817377433
-15	-0.2617993877991494	-202.19	-3.5288812146073343
-297	-5.183627878423159	0.41	0.00715584993317675
719	12.54891732183923	359.90	6.281439977927592
SELECT a, RAND(a), b, RAND(b) FROM t1;
a	RAND(a)	b	RAND(b)
NULL	NULL	NULL	NULL
0	0.15522042769493574	0.00	0.15522042769493574
1	0.40540353712197724	11.11	0.907234631392392
10	0.6570515219653505	82.12	0.6702353820858853
-15	0.4024737900146039	-202.19	0.6182323718613315
-297	0.8508369986441331	0.41	0.15522042769493574
719	0.03687594182498375	359.90	0.22113973947348048
SELECT a, ROUND(a), b, ROUND(b) FROM t1;
a	ROUND(a)	b	ROUND(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	11
10	10	82.12	82
-15	-15	-202.19	-202
-297	-297	0.41	0
719	719	359.90	360
SELECT a, SIGN(a), b, SIGN(b) FROM t1;
a	SIGN(a)	b	SIGN(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	1
10	1	82.12	1
-15	-1	-202.19	-1
-297	-1	0.41	1
719	1	359.90	1
SELECT a, SQRT(a), b, SQRT(b) FROM t1;
a	SQRT(a)	b	SQRT(b)
NULL	NULL	NULL	NULL
0	0	0.00	0
1	1	11.11	3.3331666624997918
10	3.1622776601683795	82.12	9.062008607367353
-15	NULL	-202.19	NULL
-297	NULL	0.41	0.6403124237432849
719	26.814175355583846	359.90	18.971030546599202
SELECT a, TAN(a), b, TRUNCATE(TAN(b), 14) FROM t1;
a	TAN(a)	b	TRUNCATE(TAN(b), 14)
NULL	NULL	NULL	NULL
0	0	0.00	0.00000000000000
1	1.5574077246549023	11.11	-8.70111926656510
10	0.6483608274590866	82.12	0.46906039255757
-15	0.8559934009085187	-202.19	-2.10919210919321
-297	8.328735127102908	0.41	0.43463120459988
719	-0.4522430382816394	359.90	-5.26662665925214
SELECT a, TRUNCATE(a, 1) FROM t1;
a	TRUNCATE(a, 1)
NULL	NULL
0	0
1	1
10	10
-15	-15
-297	-297
719	719
SELECT b, TRUNCATE(b, 1), TRUNCATE(b, 4), TRUNCATE(b, -1), TRUNCATE(b, -2), TRUNCATE(b, -3) FROM t1;
b	TRUNCATE(b, 1)	TRUNCATE(b, 4)	TRUNCATE(b, -1)	TRUNCATE(b, -2)	TRUNCATE(b, -3)
NULL	NULL	NULL	NULL	NULL	NULL
0.00	0.0	0.0000	0	0	0
11.11	11.1	11.1100	10	0	0
82.12	82.1	82.1200	80	0	0
-202.19	-202.1	-202.1900	-200	-200	0
0.41	0.4	0.4100	0	0	0
359.90	359.9	359.9000	350	300	0
DROP DATABASE mcs94_db;