mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-20 09:07:44 +03:00
33 lines
778 B
Plaintext
33 lines
778 B
Plaintext
DROP DATABASE IF EXISTS mcs237_db;
|
|
CREATE DATABASE mcs237_db;
|
|
USE mcs237_db;
|
|
CREATE TABLE t1 (a INT, b DECIMAL(7,5))ENGINE=Columnstore;
|
|
INSERT INTO t1 VALUES (1, 2.1791), (2, -0.6493), (3, 0.17171);
|
|
SELECT EXP(0);
|
|
EXP(0)
|
|
1
|
|
SELECT EXP(-0.99);
|
|
EXP(-0.99)
|
|
0.3715766910220457
|
|
SELECT a, EXP(a) FROM t1 ORDER BY 1;
|
|
a EXP(a)
|
|
1 2.718281828459045
|
|
2 7.38905609893065
|
|
3 20.085536923187668
|
|
SELECT a, EXP(a*3) FROM t1 ORDER BY 1;
|
|
a EXP(a*3)
|
|
1 20.085536923187668
|
|
2 403.4287934927351
|
|
3 8103.083927575384
|
|
SELECT b, EXP(b) FROM t1 ORDER BY 1;
|
|
b EXP(b)
|
|
-0.64930 0.5224113367358129
|
|
0.17171 1.1873334565792995
|
|
2.17910 8.838348164767485
|
|
SELECT b, EXP(b*0.05) FROM t1 ORDER BY 1;
|
|
b EXP(b*0.05)
|
|
-0.64930 0.9680563312099708
|
|
0.17171 1.008622461105928
|
|
2.17910 1.1151121691647674
|
|
DROP DATABASE mcs237_db;
|