mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-20 09:07:44 +03:00
244 lines
8.1 KiB
Plaintext
244 lines
8.1 KiB
Plaintext
DROP DATABASE IF EXISTS unsigned_math_db;
|
|
CREATE DATABASE unsigned_math_db;
|
|
USE unsigned_math_db;
|
|
create table j1 (j1_key int)engine=columnstore;
|
|
insert into j1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(null);
|
|
ALTER TABLE j1 ADD COLUMN CUTINYINT TINYINT UNSIGNED;
|
|
ALTER TABLE j1 ADD COLUMN CUSMALLINT SMALLINT UNSIGNED;
|
|
ALTER TABLE j1 ADD COLUMN CUINTEGER INT UNSIGNED;
|
|
ALTER TABLE j1 ADD COLUMN CUBIGINT BIGINT UNSIGNED;
|
|
UPDATE j1 SET CUTINYINT=253;
|
|
UPDATE j1 SET CUSMALLINT=65533;
|
|
UPDATE j1 SET CUINTEGER=4294967293;
|
|
UPDATE j1 SET CUBIGINT=18446744073709551613;
|
|
SELECT 'ABS1', ABS(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
ABS1 ABS(CUTINYINT)
|
|
ABS1 253
|
|
SELECT 'ABS2', ABS(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
ABS2 ABS(CUSMALLINT)
|
|
ABS2 65533
|
|
SELECT 'ABS3', ABS(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
ABS3 ABS(CUINTEGER)
|
|
ABS3 4294967293
|
|
SELECT 'ABS4', ABS(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
ABS4 ABS(CUBIGINT)
|
|
ABS4 18446744073709551613
|
|
SELECT 'CEIL1', CEIL(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
CEIL1 CEIL(CUTINYINT)
|
|
CEIL1 253
|
|
SELECT 'CEIL2', CEIL(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
CEIL2 CEIL(CUSMALLINT)
|
|
CEIL2 65533
|
|
SELECT 'CEIL3', CEIL(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
CEIL3 CEIL(CUINTEGER)
|
|
CEIL3 4294967293
|
|
SELECT 'CEIL4', CEIL(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
CEIL4 CEIL(CUBIGINT)
|
|
CEIL4 18446744073709551613
|
|
SELECT 'FLOOR1', FLOOR(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
FLOOR1 FLOOR(CUTINYINT)
|
|
FLOOR1 253
|
|
SELECT 'FLOOR2', FLOOR(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
FLOOR2 FLOOR(CUSMALLINT)
|
|
FLOOR2 65533
|
|
SELECT 'FLOOR3', FLOOR(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
FLOOR3 FLOOR(CUINTEGER)
|
|
FLOOR3 4294967293
|
|
SELECT 'FLOOR4', FLOOR(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
FLOOR4 FLOOR(CUBIGINT)
|
|
FLOOR4 18446744073709551613
|
|
SELECT 'DIV1', CUINTEGER DIV CUTINYINT FROM j1 WHERE j1_key=1;
|
|
DIV1 CUINTEGER DIV CUTINYINT
|
|
DIV1 16976155
|
|
SELECT 'DIV2', CUINTEGER DIV CUSMALLINT FROM j1 WHERE j1_key=1;
|
|
DIV2 CUINTEGER DIV CUSMALLINT
|
|
DIV2 65539
|
|
SELECT 'DIV3', CUBIGINT DIV CUTINYINT FROM j1 WHERE j1_key=1;
|
|
DIV3 CUBIGINT DIV CUTINYINT
|
|
DIV3 72912031911895460
|
|
SELECT 'DIV4', CUBIGINT DIV CUSMALLINT FROM j1 WHERE j1_key=1;
|
|
DIV4 CUBIGINT DIV CUSMALLINT
|
|
DIV4 281487862202395
|
|
SELECT 'DIV5', CUBIGINT DIV CUINTEGER FROM j1 WHERE j1_key=1;
|
|
DIV5 CUBIGINT DIV CUINTEGER
|
|
DIV5 4294967299
|
|
SELECT 'DIV6', CUINTEGER DIV CUBIGINT FROM j1 WHERE j1_key=1;
|
|
DIV6 CUINTEGER DIV CUBIGINT
|
|
DIV6 0
|
|
SELECT 'EXP1', EXP(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
EXP1 EXP(CUTINYINT)
|
|
EXP1 7.524955249064026e109
|
|
SELECT 'LN1', LN(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
LN1 LN(CUTINYINT)
|
|
LN1 5.53338948872752
|
|
SELECT 'LN2', LN(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
LN2 LN(CUSMALLINT)
|
|
LN2 11.090309111544167
|
|
SELECT 'LN3', LN(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
LN3 LN(CUINTEGER)
|
|
LN3 22.180709777219757
|
|
SELECT 'LN4', LN(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
LN4 LN(CUBIGINT)
|
|
LN4 44.3614195558365
|
|
SELECT 'LOG1', LOG(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
LOG1 LOG(CUTINYINT)
|
|
LOG1 5.53338948872752
|
|
SELECT 'LOG2', LOG(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
LOG2 LOG(CUSMALLINT)
|
|
LOG2 11.090309111544167
|
|
SELECT 'LOG3', LOG(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
LOG3 LOG(CUINTEGER)
|
|
LOG3 22.180709777219757
|
|
SELECT 'LOG4', LOG(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
LOG4 LOG(CUBIGINT)
|
|
LOG4 44.3614195558365
|
|
SELECT 'LOG21', LOG2(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
LOG21 LOG2(CUTINYINT)
|
|
LOG21 7.98299357469431
|
|
SELECT 'LOG22', LOG2(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
LOG22 LOG2(CUSMALLINT)
|
|
LOG22 15.999933957150457
|
|
SELECT 'LOG23', LOG2(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
LOG23 LOG2(CUINTEGER)
|
|
LOG23 31.99999999899229
|
|
SELECT 'LOG24', LOG2(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
LOG24 LOG2(CUBIGINT)
|
|
LOG24 64
|
|
SELECT 'LOG101', LOG10(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
LOG101 LOG10(CUTINYINT)
|
|
LOG101 2.403120521175818
|
|
SELECT 'LOG102', LOG10(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
LOG102 LOG10(CUSMALLINT)
|
|
LOG102 4.816460049744987
|
|
SELECT 'LOG103', LOG10(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
LOG103 LOG10(CUINTEGER)
|
|
LOG103 9.632959860944046
|
|
SELECT 'LOG104', LOG10(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
LOG104 LOG10(CUBIGINT)
|
|
LOG104 19.265919722494797
|
|
SELECT 'MD51', MD5(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
MD51 MD5(CUTINYINT)
|
|
MD51 c24cd76e1ce41366a4bbe8a49b02a028
|
|
SELECT 'MD52', MD5(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
MD52 MD5(CUSMALLINT)
|
|
MD52 b43a5e5173829680413743204b70d55d
|
|
SELECT 'MD53', MD5(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
MD53 MD5(CUINTEGER)
|
|
MD53 f05431cd655e6b9ec50b9ddf24bacb21
|
|
SELECT 'MD54', MD5(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
MD54 MD5(CUBIGINT)
|
|
MD54 036ffb1c651d2838aa7b650edbf4df6a
|
|
SELECT 'MOD1', MOD(CUTINYINT,10) FROM j1 WHERE j1_key=1;
|
|
MOD1 MOD(CUTINYINT,10)
|
|
MOD1 3
|
|
SELECT 'MOD2', MOD(CUSMALLINT,9) FROM j1 WHERE j1_key=1;
|
|
MOD2 MOD(CUSMALLINT,9)
|
|
MOD2 4
|
|
SELECT 'MOD3', MOD(CUINTEGER,8) FROM j1 WHERE j1_key=1;
|
|
MOD3 MOD(CUINTEGER,8)
|
|
MOD3 5
|
|
SELECT 'MOD4', MOD(CUBIGINT,16) FROM j1 WHERE j1_key=1;
|
|
MOD4 MOD(CUBIGINT,16)
|
|
MOD4 13
|
|
SELECT 'NULLIF1', NULLIF(CUTINYINT,253) FROM j1 WHERE j1_key=1;
|
|
NULLIF1 NULLIF(CUTINYINT,253)
|
|
NULLIF1 NULL
|
|
SELECT 'NULLIF2', NULLIF(CUSMALLINT,65533) FROM j1 WHERE j1_key=1;
|
|
NULLIF2 NULLIF(CUSMALLINT,65533)
|
|
NULLIF2 NULL
|
|
SELECT 'NULLIF3', NULLIF(CUINTEGER,4294967293) FROM j1 WHERE j1_key=1;
|
|
NULLIF3 NULLIF(CUINTEGER,4294967293)
|
|
NULLIF3 NULL
|
|
SELECT 'NULLIF4', NULLIF(CUBIGINT,18446744073709551613) FROM j1 WHERE j1_key=1;
|
|
NULLIF4 NULLIF(CUBIGINT,18446744073709551613)
|
|
NULLIF4 NULL
|
|
SELECT 'NULLIF5', NULLIF(CUTINYINT,252) FROM j1 WHERE j1_key=1;
|
|
NULLIF5 NULLIF(CUTINYINT,252)
|
|
NULLIF5 253
|
|
SELECT 'NULLIF6', NULLIF(CUSMALLINT,65532) FROM j1 WHERE j1_key=1;
|
|
NULLIF6 NULLIF(CUSMALLINT,65532)
|
|
NULLIF6 65533
|
|
SELECT 'NULLIF7', NULLIF(CUINTEGER,4294967292) FROM j1 WHERE j1_key=1;
|
|
NULLIF7 NULLIF(CUINTEGER,4294967292)
|
|
NULLIF7 4294967293
|
|
SELECT 'NULLIF8', NULLIF(CUBIGINT,18446744073709551612) FROM j1 WHERE j1_key=1;
|
|
NULLIF8 NULLIF(CUBIGINT,18446744073709551612)
|
|
NULLIF8 18446744073709551613
|
|
SELECT 'POW1', POW(CUTINYINT,4) FROM j1 WHERE j1_key=1;
|
|
POW1 POW(CUTINYINT,4)
|
|
POW1 4097152081
|
|
SELECT 'POW2', POW(CUSMALLINT,4) FROM j1 WHERE j1_key=1;
|
|
POW2 POW(CUSMALLINT,4)
|
|
POW2 1.844336660591018e19
|
|
SELECT 'POW3', POW(CUINTEGER,4) FROM j1 WHERE j1_key=1;
|
|
POW3 POW(CUINTEGER,4)
|
|
POW3 3.402823659702005e38
|
|
SELECT 'POW4', POW(CUBIGINT,4) FROM j1 WHERE j1_key=1;
|
|
POW4 POW(CUBIGINT,4)
|
|
POW4 1.157920892373162e77
|
|
SELECT 'ROUND1', ROUND(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
ROUND1 ROUND(CUTINYINT)
|
|
ROUND1 253
|
|
SELECT 'ROUND2', ROUND(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
ROUND2 ROUND(CUSMALLINT)
|
|
ROUND2 65533
|
|
SELECT 'ROUND3', ROUND(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
ROUND3 ROUND(CUINTEGER)
|
|
ROUND3 4294967293
|
|
SELECT 'ROUND4', ROUND(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
ROUND4 ROUND(CUBIGINT)
|
|
ROUND4 18446744073709551613
|
|
SELECT 'SIGN1', SIGN(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
SIGN1 SIGN(CUTINYINT)
|
|
SIGN1 1
|
|
SELECT 'SIGN2', SIGN(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
SIGN2 SIGN(CUSMALLINT)
|
|
SIGN2 1
|
|
SELECT 'SIGN3', SIGN(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
SIGN3 SIGN(CUINTEGER)
|
|
SIGN3 1
|
|
SELECT 'SIGN4', SIGN(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
SIGN4 SIGN(CUBIGINT)
|
|
SIGN4 1
|
|
SELECT 'SIN1', SIN(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
SIN1 SIN(CUTINYINT)
|
|
SIN1 0.9948237286710673
|
|
SELECT 'SIN2', SIN(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
SIN2 SIN(CUSMALLINT)
|
|
SIN2 -0.5832742805741906
|
|
SELECT 'SIN3', SIN(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
SIN3 SIN(CUINTEGER)
|
|
SIN3 0.582520735869709
|
|
SELECT 'SIN4', SIN(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
SIN4 SIN(CUBIGINT)
|
|
SIN4 0.023598509904439558
|
|
SELECT 'SQRT1', SQRT(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
SQRT1 SQRT(CUTINYINT)
|
|
SQRT1 15.905973720586866
|
|
SELECT 'SQRT2', SQRT(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
SQRT2 SQRT(CUSMALLINT)
|
|
SQRT2 255.99414055794324
|
|
SELECT 'SQRT3', SQRT(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
SQRT3 SQRT(CUINTEGER)
|
|
SQRT3 65535.99997711182
|
|
SELECT 'SQRT4', SQRT(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
SQRT4 SQRT(CUBIGINT)
|
|
SQRT4 4294967296
|
|
SELECT 'TAN1', TAN(CUTINYINT) FROM j1 WHERE j1_key=1;
|
|
TAN1 TAN(CUTINYINT)
|
|
TAN1 -9.79006006351717
|
|
SELECT 'TAN2', TAN(CUSMALLINT) FROM j1 WHERE j1_key=1;
|
|
TAN2 TAN(CUSMALLINT)
|
|
TAN2 -0.718074650794117
|
|
SELECT 'TAN3', TAN(CUINTEGER) FROM j1 WHERE j1_key=1;
|
|
TAN3 TAN(CUINTEGER)
|
|
TAN3 0.7166700082465247
|
|
SELECT 'TAN4', TAN(CUBIGINT) FROM j1 WHERE j1_key=1;
|
|
TAN4 TAN(CUBIGINT)
|
|
TAN4 -0.0236050835333497
|
|
ALTER TABLE j1 DROP COLUMN CUTINYINT;
|
|
ALTER TABLE j1 DROP COLUMN CUSMALLINT;
|
|
ALTER TABLE j1 DROP COLUMN CUINTEGER;
|
|
ALTER TABLE j1 DROP COLUMN CUBIGINT;
|
|
DROP DATABASE unsigned_math_db;
|