database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-26 11:48:52 +03:00
Code
mariadb-columnstore-engine/mysql-test/columnstore/basic/r/unsigned_least.result

1050 lines
34 KiB
Plaintext
Raw Permalink Blame History

DROP DATABASE IF EXISTS unsigned_least_db;
CREATE DATABASE unsigned_least_db;
USE unsigned_least_db;
Create table datatypetestm (
CIDX INTEGER,
CBIGINT BIGINT,
CDECIMAL1 DECIMAL(1),
CDECIMAL4 DECIMAL(4),
CDECIMAL4_2 DECIMAL(4,2),
CDECIMAL5 DECIMAL(5),
CDECIMAL9 DECIMAL(9),
CDECIMAL9_2 DECIMAL(9,2),
CDECIMAL10 DECIMAL(10),
CDECIMAL18 DECIMAL(18),
CDECIMAL18_2 DECIMAL(18,2),
CINTEGER INTEGER,
CSMALLINT SMALLINT,
CTINYINT TINYINT,
CDOUBLE DOUBLE,
CFLOAT FLOAT,
CDATE DATE,
CDATETIME DATETIME,
CCHAR1 CHAR(1),
CCHAR2 CHAR(2),
CCHAR3 CHAR(3),
CCHAR4 CHAR(4),
CCHAR5 CHAR(5),
CCHAR6 CHAR(6),
CCHAR7 CHAR(7),
CCHAR8 CHAR(8),
CCHAR9 CHAR(9),
CCHAR255 CHAR(255),
CVCHAR1 VARCHAR(1),
CVCHAR2 VARCHAR(2),
CVCHAR3 VARCHAR(3),
CVCHAR4 VARCHAR(4),
CVCHAR5 VARCHAR(5),
CVCHAR6 VARCHAR(6),
CVCHAR7 VARCHAR(7),
CVCHAR8 VARCHAR(8),
CVCHAR255 VARCHAR(255)
)engine=columnstore;
insert into datatypetestm values
(1,-72036854775806,-9,-999,-9.99,-999,-999999,-9999.99,-9999999,-9999999999999,-99999999999.99,-7483646,-766,-26,-1.797693231E+108,-3.402866E+18,'1997-01-01','1997-01-01 00:00:00','a','aa','aaa','aaaa','aaaaa','aaaaaa','aaaaaaa','aaaaaaaa','aaaaaaaaa','aaaaaaaaaa','a','aa','aaa','aaaa','aaaaa','aaaaaa','aaaaaaa','aaaaaaaa','aaaaaaaaaa'),
(2,-72036854775805,-8,-998,-9.98,-998,-999998,-9999.98,-9999998,-9999999999998,-99999999999.98,-7483645,-765,-25,-1.797693230E+108,-3.402865E+18,'1997-01-01','1997-01-01 00:00:01','a','b','c','d','e','f','g','h','i','j','a','b','c','d','e','f','g','h','j'),
(3,-72036854775804,-7,-997,-9.97,-997,-999997,-9999.97,-9999997,-9999999999997,-99999999999.97,-7483644,-764,-24,-1.797693229E+108,-3.402864E+18,'1997-01-02','1997-01-02 00:00:01','a','bb','cc','dd','ee','ff','gg','hh','ii','jj','a','bb','cc','dd','ee','ff','gg','hh','jj'),
(4,-72036854775803,-6,-996,-9.96,-996,-999996,-9999.96,-9999996,-9999999999996,-99999999999.96,-7483643,-763,-23,-1.797693228E+108,-3.402863E+18,'1997-01-03','1997-01-03 00:00:02','a','bb','ccc','ddd','eee','fff','ggg','hhh','iii','jjj','a','bb','ccc','ddd','eee','fff','ggg','hhh','jjj'),
(5,-72036854775802,-5,-995,-9.95,-995,-999995,-9999.95,-9999995,-9999999999995,-99999999999.95,-7483642,-762,-22,-1.797693227E+108,-3.402862E+18,'1997-01-04','1997-01-04 00:00:03','a','bb','ccc','dddd','eeee','ffff','gggg','hhhh','iiii','jjjj','a','bb','ccc','dddd','eeee','ffff','gggg','hhhh','jjjj'),
(6,72036854775803,5,995,9.95,995,999995,9999.95,9999995,9999999999995,99999999999.95,7483643,763,23,1.797693227E+108,3.402862E+18,'2009-12-28','2009-12-31 23:59:56','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','sssssss','rrrrrrr','qqqqqqq','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','sssssss','qqqqqqq'),
(7,72036854775804,6,996,9.96,996,999996,9999.96,9999996,9999999999996,99999999999.96,7483644,764,24,1.797693228E+108,3.402863E+18,'2009-12-29','2009-12-31 23:59:57','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','ssssssss','rrrrrrrr','qqqqqqqq','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','ssssssss','qqqqqqqq'),
(8,72036854775805,7,997,9.97,997,999997,9999.97,9999997,9999999999997,99999999999.97,7483645,765,25,1.797693229E+108,3.402864E+18,'2009-12-30','2009-12-31 23:59:58','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','ssssssss','rrrrrrrrr','qqqqqqqqq','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','ssssssss','qqqqqqqqq'),
(9,72036854775806,8,998,9.98,998,999998,9999.98,9999998,9999999999998,99999999999.98,7483646,766,26,1.797693230E+108,3.402865E+18,'2009-12-31','2009-12-31 23:59:59','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','ssssssss','rrrrrrrrr','qqqqqqqqqq','z','yy','xxx','wwww','vvvvv','uuuuuu','ttttttt','ssssssss','qqqqqqqqqq'),
(10,72036854775807,9,999,9.99,999,999999,9999.99,9999999,9999999999999,99999999999.99,7483647,767,27,1.797693231E+108,3.402866E+18,'2009-12-31','2009-12-31 23:59:59','z','zz','zzz','zzzz','zzzzz','zzzzzz','zzzzzzz','zzzzzzzz','zzzzzzzzz','zzzzzzzzzz','z','zz','zzz','zzzz','zzzzz','zzzzzz','zzzzzzz','zzzzzzzz','zzzzzzzzzz'),
(11,0,0,0,0.00,0,0,0.00,0,0,0.00,0,0,0,0.00,0.00,'2009-12-31','2009-12-31 23:59:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
ALTER TABLE datatypetestm ADD COLUMN CUTINYINT TINYINT UNSIGNED;
ALTER TABLE datatypetestm ADD COLUMN CUSMALLINT SMALLINT UNSIGNED;
ALTER TABLE datatypetestm ADD COLUMN CUINTEGER INT UNSIGNED;
ALTER TABLE datatypetestm ADD COLUMN CUBIGINT BIGINT UNSIGNED;
UPDATE datatypetestm SET CUTINYINT=CTINYINT + 120;
UPDATE datatypetestm SET CUSMALLINT=CSMALLINT + 20000;
UPDATE datatypetestm SET CUINTEGER=CINTEGER + 1140000000;
UPDATE datatypetestm SET CUBIGINT=CBIGINT + 5223000000000000000;
select cidx, CBIGINT, CUBIGINT, LEAST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx CBIGINT CUBIGINT LEAST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1 -72036854775806 5222927963145224194 -72036854775806
2 -72036854775805 5222927963145224195 -72036854775805
3 -72036854775804 5222927963145224196 -72036854775804
4 -72036854775803 5222927963145224197 -72036854775803
5 -72036854775802 5222927963145224198 -72036854775802
6 72036854775803 5223072036854775803 10
7 72036854775804 5223072036854775804 10
8 72036854775805 5223072036854775805 10
9 72036854775806 5223072036854775806 10
10 72036854775807 5223072036854775807 10
11 0 5223000000000000000 0
select cidx, CDECIMAL1, CUSMALLINT, LEAST(CDECIMAL1,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL1 CUSMALLINT LEAST(CDECIMAL1,CUSMALLINT,CUTINYINT,10)
1 -9 19234 -9
2 -8 19235 -8
3 -7 19236 -7
4 -6 19237 -6
5 -5 19238 -5
6 5 20763 5
7 6 20764 6
8 7 20765 7
9 8 20766 8
10 9 20767 9
11 0 20000 0
select cidx, CDECIMAL1, CUTINYINT, LEAST(CDECIMAL1,CUTINYINT) from datatypetestm;
cidx CDECIMAL1 CUTINYINT LEAST(CDECIMAL1,CUTINYINT)
1 -9 94 -9
2 -8 95 -8
3 -7 96 -7
4 -6 97 -6
5 -5 98 -5
6 5 143 5
7 6 144 6
8 7 145 7
9 8 146 8
10 9 147 9
11 0 120 0
select cidx, CDECIMAL1, CUBIGINT, LEAST(CDECIMAL1,CUBIGINT) from datatypetestm;
cidx CDECIMAL1 CUBIGINT LEAST(CDECIMAL1,CUBIGINT)
1 -9 5222927963145224194 -9
2 -8 5222927963145224195 -8
3 -7 5222927963145224196 -7
4 -6 5222927963145224197 -6
5 -5 5222927963145224198 -5
6 5 5223072036854775803 5
7 6 5223072036854775804 6
8 7 5223072036854775805 7
9 8 5223072036854775806 8
10 9 5223072036854775807 9
11 0 5223000000000000000 0
select cidx, CDECIMAL4, CUSMALLINT, LEAST(CDECIMAL4,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL4 CUSMALLINT LEAST(CDECIMAL4,CUSMALLINT,CUTINYINT,10)
1 -999 19234 -999
2 -998 19235 -998
3 -997 19236 -997
4 -996 19237 -996
5 -995 19238 -995
6 995 20763 10
7 996 20764 10
8 997 20765 10
9 998 20766 10
10 999 20767 10
11 0 20000 0
select cidx, CDECIMAL4, CUTINYINT, LEAST(CDECIMAL4,CUTINYINT) from datatypetestm;
cidx CDECIMAL4 CUTINYINT LEAST(CDECIMAL4,CUTINYINT)
1 -999 94 -999
2 -998 95 -998
3 -997 96 -997
4 -996 97 -996
5 -995 98 -995
6 995 143 143
7 996 144 144
8 997 145 145
9 998 146 146
10 999 147 147
11 0 120 0
select cidx, CDECIMAL4, CUBIGINT, LEAST(CDECIMAL4,CUBIGINT) from datatypetestm;
cidx CDECIMAL4 CUBIGINT LEAST(CDECIMAL4,CUBIGINT)
1 -999 5222927963145224194 -999
2 -998 5222927963145224195 -998
3 -997 5222927963145224196 -997
4 -996 5222927963145224197 -996
5 -995 5222927963145224198 -995
6 995 5223072036854775803 995
7 996 5223072036854775804 996
8 997 5223072036854775805 997
9 998 5223072036854775806 998
10 999 5223072036854775807 999
11 0 5223000000000000000 0
select cidx, CDECIMAL4_2, CUSMALLINT, LEAST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL4_2 CUSMALLINT LEAST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10)
1 -9.99 19234 -9.99
2 -9.98 19235 -9.98
3 -9.97 19236 -9.97
4 -9.96 19237 -9.96
5 -9.95 19238 -9.95
6 9.95 20763 9.95
7 9.96 20764 9.96
8 9.97 20765 9.97
9 9.98 20766 9.98
10 9.99 20767 9.99
11 0.00 20000 0.00
select cidx, CDECIMAL4_2, CUTINYINT, LEAST(CDECIMAL4_2,CUTINYINT) from datatypetestm;
cidx CDECIMAL4_2 CUTINYINT LEAST(CDECIMAL4_2,CUTINYINT)
1 -9.99 94 -9.99
2 -9.98 95 -9.98
3 -9.97 96 -9.97
4 -9.96 97 -9.96
5 -9.95 98 -9.95
6 9.95 143 9.95
7 9.96 144 9.96
8 9.97 145 9.97
9 9.98 146 9.98
10 9.99 147 9.99
11 0.00 120 0.00
select cidx, CDECIMAL4_2, CUBIGINT, LEAST(CDECIMAL4_2,CUBIGINT) from datatypetestm;
cidx CDECIMAL4_2 CUBIGINT LEAST(CDECIMAL4_2,CUBIGINT)
1 -9.99 5222927963145224194 -9.99
2 -9.98 5222927963145224195 -9.98
3 -9.97 5222927963145224196 -9.97
4 -9.96 5222927963145224197 -9.96
5 -9.95 5222927963145224198 -9.95
6 9.95 5223072036854775803 9.95
7 9.96 5223072036854775804 9.96
8 9.97 5223072036854775805 9.97
9 9.98 5223072036854775806 9.98
10 9.99 5223072036854775807 9.99
11 0.00 5223000000000000000 0.00
select cidx, CDECIMAL9, CUSMALLINT, LEAST(CDECIMAL9,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL9 CUSMALLINT LEAST(CDECIMAL9,CUSMALLINT,CUTINYINT,10)
1 -999999 19234 -999999
2 -999998 19235 -999998
3 -999997 19236 -999997
4 -999996 19237 -999996
5 -999995 19238 -999995
6 999995 20763 10
7 999996 20764 10
8 999997 20765 10
9 999998 20766 10
10 999999 20767 10
11 0 20000 0
select cidx, CDECIMAL9, CUTINYINT, LEAST(CDECIMAL9,CUTINYINT) from datatypetestm;
cidx CDECIMAL9 CUTINYINT LEAST(CDECIMAL9,CUTINYINT)
1 -999999 94 -999999
2 -999998 95 -999998
3 -999997 96 -999997
4 -999996 97 -999996
5 -999995 98 -999995
6 999995 143 143
7 999996 144 144
8 999997 145 145
9 999998 146 146
10 999999 147 147
11 0 120 0
select cidx, CDECIMAL9, CUBIGINT, LEAST(CDECIMAL9,CUBIGINT) from datatypetestm;
cidx CDECIMAL9 CUBIGINT LEAST(CDECIMAL9,CUBIGINT)
1 -999999 5222927963145224194 -999999
2 -999998 5222927963145224195 -999998
3 -999997 5222927963145224196 -999997
4 -999996 5222927963145224197 -999996
5 -999995 5222927963145224198 -999995
6 999995 5223072036854775803 999995
7 999996 5223072036854775804 999996
8 999997 5223072036854775805 999997
9 999998 5223072036854775806 999998
10 999999 5223072036854775807 999999
11 0 5223000000000000000 0
select cidx, CDECIMAL9_2, CUSMALLINT, LEAST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL9_2 CUSMALLINT LEAST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10)
1 -9999.99 19234 -9999.99
2 -9999.98 19235 -9999.98
3 -9999.97 19236 -9999.97
4 -9999.96 19237 -9999.96
5 -9999.95 19238 -9999.95
6 9999.95 20763 10.00
7 9999.96 20764 10.00
8 9999.97 20765 10.00
9 9999.98 20766 10.00
10 9999.99 20767 10.00
11 0.00 20000 0.00
select cidx, CDECIMAL9_2, CUTINYINT, LEAST(CDECIMAL9_2,CUTINYINT) from datatypetestm;
cidx CDECIMAL9_2 CUTINYINT LEAST(CDECIMAL9_2,CUTINYINT)
1 -9999.99 94 -9999.99
2 -9999.98 95 -9999.98
3 -9999.97 96 -9999.97
4 -9999.96 97 -9999.96
5 -9999.95 98 -9999.95
6 9999.95 143 143.00
7 9999.96 144 144.00
8 9999.97 145 145.00
9 9999.98 146 146.00
10 9999.99 147 147.00
11 0.00 120 0.00
select cidx, CDECIMAL9_2, CUBIGINT, LEAST(CDECIMAL9_2,CUBIGINT) from datatypetestm;
cidx CDECIMAL9_2 CUBIGINT LEAST(CDECIMAL9_2,CUBIGINT)
1 -9999.99 5222927963145224194 -9999.99
2 -9999.98 5222927963145224195 -9999.98
3 -9999.97 5222927963145224196 -9999.97
4 -9999.96 5222927963145224197 -9999.96
5 -9999.95 5222927963145224198 -9999.95
6 9999.95 5223072036854775803 9999.95
7 9999.96 5223072036854775804 9999.96
8 9999.97 5223072036854775805 9999.97
9 9999.98 5223072036854775806 9999.98
10 9999.99 5223072036854775807 9999.99
11 0.00 5223000000000000000 0.00
select cidx, CDECIMAL18, CUSMALLINT, LEAST(CDECIMAL18,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL18 CUSMALLINT LEAST(CDECIMAL18,CUSMALLINT,CUTINYINT,10)
1 -9999999999999 19234 -9999999999999
2 -9999999999998 19235 -9999999999998
3 -9999999999997 19236 -9999999999997
4 -9999999999996 19237 -9999999999996
5 -9999999999995 19238 -9999999999995
6 9999999999995 20763 10
7 9999999999996 20764 10
8 9999999999997 20765 10
9 9999999999998 20766 10
10 9999999999999 20767 10
11 0 20000 0
select cidx, CDECIMAL18, CUTINYINT, LEAST(CDECIMAL18,CUTINYINT) from datatypetestm;
cidx CDECIMAL18 CUTINYINT LEAST(CDECIMAL18,CUTINYINT)
1 -9999999999999 94 -9999999999999
2 -9999999999998 95 -9999999999998
3 -9999999999997 96 -9999999999997
4 -9999999999996 97 -9999999999996
5 -9999999999995 98 -9999999999995
6 9999999999995 143 143
7 9999999999996 144 144
8 9999999999997 145 145
9 9999999999998 146 146
10 9999999999999 147 147
11 0 120 0
select cidx, CDECIMAL18, CUBIGINT, LEAST(CDECIMAL18,CUBIGINT) from datatypetestm;
cidx CDECIMAL18 CUBIGINT LEAST(CDECIMAL18,CUBIGINT)
1 -9999999999999 5222927963145224194 -9999999999999
2 -9999999999998 5222927963145224195 -9999999999998
3 -9999999999997 5222927963145224196 -9999999999997
4 -9999999999996 5222927963145224197 -9999999999996
5 -9999999999995 5222927963145224198 -9999999999995
6 9999999999995 5223072036854775803 9999999999995
7 9999999999996 5223072036854775804 9999999999996
8 9999999999997 5223072036854775805 9999999999997
9 9999999999998 5223072036854775806 9999999999998
10 9999999999999 5223072036854775807 9999999999999
11 0 5223000000000000000 0
select cidx, CDECIMAL18_2, CUSMALLINT, LEAST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL18_2 CUSMALLINT LEAST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10)
1 -99999999999.99 19234 -99999999999.99
2 -99999999999.98 19235 -99999999999.98
3 -99999999999.97 19236 -99999999999.97
4 -99999999999.96 19237 -99999999999.96
5 -99999999999.95 19238 -99999999999.95
6 99999999999.95 20763 10.00
7 99999999999.96 20764 10.00
8 99999999999.97 20765 10.00
9 99999999999.98 20766 10.00
10 99999999999.99 20767 10.00
11 0.00 20000 0.00
select cidx, CDECIMAL18_2, CUTINYINT, LEAST(CDECIMAL18_2,CUTINYINT) from datatypetestm;
cidx CDECIMAL18_2 CUTINYINT LEAST(CDECIMAL18_2,CUTINYINT)
1 -99999999999.99 94 -99999999999.99
2 -99999999999.98 95 -99999999999.98
3 -99999999999.97 96 -99999999999.97
4 -99999999999.96 97 -99999999999.96
5 -99999999999.95 98 -99999999999.95
6 99999999999.95 143 143.00
7 99999999999.96 144 144.00
8 99999999999.97 145 145.00
9 99999999999.98 146 146.00
10 99999999999.99 147 147.00
11 0.00 120 0.00
select cidx, CDECIMAL18_2, CUBIGINT, LEAST(CDECIMAL18_2,CUBIGINT) from datatypetestm;
cidx CDECIMAL18_2 CUBIGINT LEAST(CDECIMAL18_2,CUBIGINT)
1 -99999999999.99 5222927963145224194 -99999999999.99
2 -99999999999.98 5222927963145224195 -99999999999.98
3 -99999999999.97 5222927963145224196 -99999999999.97
4 -99999999999.96 5222927963145224197 -99999999999.96
5 -99999999999.95 5222927963145224198 -99999999999.95
6 99999999999.95 5223072036854775803 99999999999.95
7 99999999999.96 5223072036854775804 99999999999.96
8 99999999999.97 5223072036854775805 99999999999.97
9 99999999999.98 5223072036854775806 99999999999.98
10 99999999999.99 5223072036854775807 99999999999.99
11 0.00 5223000000000000000 0.00
select cidx, CINTEGER, CUINTEGER, LEAST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx CINTEGER CUINTEGER LEAST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1 -7483646 1132516354 -7483646
2 -7483645 1132516355 -7483645
3 -7483644 1132516356 -7483644
4 -7483643 1132516357 -7483643
5 -7483642 1132516358 -7483642
6 7483643 1147483643 10
7 7483644 1147483644 10
8 7483645 1147483645 10
9 7483646 1147483646 10
10 7483647 1147483647 10
11 0 1140000000 0
select cidx, CINTEGER, CUSMALLINT, LEAST(CINTEGER,CUSMALLINT) from datatypetestm;
cidx CINTEGER CUSMALLINT LEAST(CINTEGER,CUSMALLINT)
1 -7483646 19234 -7483646
2 -7483645 19235 -7483645
3 -7483644 19236 -7483644
4 -7483643 19237 -7483643
5 -7483642 19238 -7483642
6 7483643 20763 20763
7 7483644 20764 20764
8 7483645 20765 20765
9 7483646 20766 20766
10 7483647 20767 20767
11 0 20000 0
select cidx, CINTEGER, CUTINYINT, LEAST(CINTEGER,CUTINYINT) from datatypetestm;
cidx CINTEGER CUTINYINT LEAST(CINTEGER,CUTINYINT)
1 -7483646 94 -7483646
2 -7483645 95 -7483645
3 -7483644 96 -7483644
4 -7483643 97 -7483643
5 -7483642 98 -7483642
6 7483643 143 143
7 7483644 144 144
8 7483645 145 145
9 7483646 146 146
10 7483647 147 147
11 0 120 0
select cidx, CSMALLINT, CUSMALLINT, LEAST(CSMALLINT,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CSMALLINT CUSMALLINT LEAST(CSMALLINT,CUSMALLINT,CUTINYINT,10)
1 -766 19234 -766
2 -765 19235 -765
3 -764 19236 -764
4 -763 19237 -763
5 -762 19238 -762
6 763 20763 10
7 764 20764 10
8 765 20765 10
9 766 20766 10
10 767 20767 10
11 0 20000 0
select cidx, CSMALLINT, CUSMALLINT, LEAST(CSMALLINT,CUSMALLINT) from datatypetestm;
cidx CSMALLINT CUSMALLINT LEAST(CSMALLINT,CUSMALLINT)
1 -766 19234 -766
2 -765 19235 -765
3 -764 19236 -764
4 -763 19237 -763
5 -762 19238 -762
6 763 20763 763
7 764 20764 764
8 765 20765 765
9 766 20766 766
10 767 20767 767
11 0 20000 0
select cidx, CSMALLINT, CUTINYINT, LEAST(CSMALLINT,CUTINYINT) from datatypetestm;
cidx CSMALLINT CUTINYINT LEAST(CSMALLINT,CUTINYINT)
1 -766 94 -766
2 -765 95 -765
3 -764 96 -764
4 -763 97 -763
5 -762 98 -762
6 763 143 143
7 764 144 144
8 765 145 145
9 766 146 146
10 767 147 147
11 0 120 0
select cidx, CUBIGINT from datatypetestm where LEAST(CUBIGINT,CSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx CUBIGINT
1 5222927963145224194
2 5222927963145224195
3 5222927963145224196
4 5222927963145224197
5 5222927963145224198
6 5223072036854775803
7 5223072036854775804
8 5223072036854775805
9 5223072036854775806
10 5223072036854775807
11 5223000000000000000
select cidx, CUSMALLINT from datatypetestm where LEAST(CUSMALLINT,CSMALLINT) <> CUSMALLINT;
cidx CUSMALLINT
1 19234
2 19235
3 19236
4 19237
5 19238
6 20763
7 20764
8 20765
9 20766
10 20767
11 20000
select cidx, CUBIGINT from datatypetestm where LEAST(CDECIMAL18,CUBIGINT,CUSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx CUBIGINT
1 5222927963145224194
2 5222927963145224195
3 5222927963145224196
4 5222927963145224197
5 5222927963145224198
6 5223072036854775803
7 5223072036854775804
8 5223072036854775805
9 5223072036854775806
10 5223072036854775807
11 5223000000000000000
select cidx, CDECIMAL18 from datatypetestm where LEAST(CDECIMAL18,CUSMALLINT) <> CDECIMAL18;
cidx CDECIMAL18
6 9999999999995
7 9999999999996
8 9999999999997
9 9999999999998
10 9999999999999
select cidx, CDECIMAL18 from datatypetestm where LEAST(CDECIMAL18,CUTINYINT) <> CDECIMAL18;
cidx CDECIMAL18
6 9999999999995
7 9999999999996
8 9999999999997
9 9999999999998
10 9999999999999
select cidx, CDECIMAL18_2 from datatypetestm where LEAST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx CDECIMAL18_2
1 -99999999999.99
2 -99999999999.98
3 -99999999999.97
4 -99999999999.96
5 -99999999999.95
6 99999999999.95
7 99999999999.96
8 99999999999.97
9 99999999999.98
10 99999999999.99
11 0.00
select cidx, CUSMALLINT from datatypetestm where LEAST(CINTEGER,CUSMALLINT,CUTINYINT,10) <> CINTEGER;
cidx CUSMALLINT
6 20763
7 20764
8 20765
9 20766
10 20767
select cidx, CINTEGER from datatypetestm where LEAST(CINTEGER,CUTINYINT) <> CINTEGER;
cidx CINTEGER
6 7483643
7 7483644
8 7483645
9 7483646
10 7483647
select cidx, CUSMALLINT from datatypetestm where LEAST(CSMALLINT,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx CUSMALLINT
1 19234
2 19235
3 19236
4 19237
5 19238
6 20763
7 20764
8 20765
9 20766
10 20767
11 20000
select cidx, CSMALLINT from datatypetestm where LEAST(CSMALLINT,CUTINYINT) <> CSMALLINT;
cidx CSMALLINT
6 763
7 764
8 765
9 766
10 767
select cidx, CUTINYINT from datatypetestm where LEAST(CTINYINT,CSMALLINT,CUTINYINT,10) <> CUTINYINT;
cidx CUTINYINT
1 94
2 95
3 96
4 97
5 98
6 143
7 144
8 145
9 146
10 147
11 120
select cidx, CUTINYINT from datatypetestm where LEAST(CTINYINT,CUTINYINT) <> CUTINYINT;
cidx CUTINYINT
1 94
2 95
3 96
4 97
5 98
6 143
7 144
8 145
9 146
10 147
11 120
UPDATE datatypetestm SET CUTINYINT=CTINYINT-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUTINYINT'
UPDATE datatypetestm SET CUSMALLINT=CSMALLINT-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUSMALLINT'
UPDATE datatypetestm SET CUINTEGER=CINTEGER-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUINTEGER'
UPDATE datatypetestm SET CUBIGINT=CBIGINT-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUBIGINT'
UPDATE datatypetestm SET CUTINYINT=CTINYINT-1 WHERE CTINYINT > 0;
UPDATE datatypetestm SET CUSMALLINT=CSMALLINT-1 WHERE CSMALLINT > 0;
UPDATE datatypetestm SET CUINTEGER=CINTEGER-1 WHERE CINTEGER > 0;
UPDATE datatypetestm SET CUBIGINT=CBIGINT-1 WHERE CBIGINT > 0;
select cidx, CBIGINT, CUBIGINT, LEAST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx CBIGINT CUBIGINT LEAST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1 -72036854775806 5222927963145224194 -72036854775806
2 -72036854775805 5222927963145224195 -72036854775805
3 -72036854775804 5222927963145224196 -72036854775804
4 -72036854775803 5222927963145224197 -72036854775803
5 -72036854775802 5222927963145224198 -72036854775802
6 72036854775803 72036854775802 10
7 72036854775804 72036854775803 10
8 72036854775805 72036854775804 10
9 72036854775806 72036854775805 10
10 72036854775807 72036854775806 10
11 0 5223000000000000000 0
select cidx, CDECIMAL1, CUSMALLINT, LEAST(CDECIMAL1,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL1 CUSMALLINT LEAST(CDECIMAL1,CUSMALLINT,CUTINYINT,10)
1 -9 19234 -9
2 -8 19235 -8
3 -7 19236 -7
4 -6 19237 -6
5 -5 19238 -5
6 5 762 5
7 6 763 6
8 7 764 7
9 8 765 8
10 9 766 9
11 0 20000 0
select cidx, CDECIMAL1, CUTINYINT, LEAST(CDECIMAL1,CUTINYINT) from datatypetestm;
cidx CDECIMAL1 CUTINYINT LEAST(CDECIMAL1,CUTINYINT)
1 -9 94 -9
2 -8 95 -8
3 -7 96 -7
4 -6 97 -6
5 -5 98 -5
6 5 22 5
7 6 23 6
8 7 24 7
9 8 25 8
10 9 26 9
11 0 120 0
select cidx, CDECIMAL1, CUBIGINT, LEAST(CDECIMAL1,CUBIGINT) from datatypetestm;
cidx CDECIMAL1 CUBIGINT LEAST(CDECIMAL1,CUBIGINT)
1 -9 5222927963145224194 -9
2 -8 5222927963145224195 -8
3 -7 5222927963145224196 -7
4 -6 5222927963145224197 -6
5 -5 5222927963145224198 -5
6 5 72036854775802 5
7 6 72036854775803 6
8 7 72036854775804 7
9 8 72036854775805 8
10 9 72036854775806 9
11 0 5223000000000000000 0
select cidx, CDECIMAL4, CUSMALLINT, LEAST(CDECIMAL4,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL4 CUSMALLINT LEAST(CDECIMAL4,CUSMALLINT,CUTINYINT,10)
1 -999 19234 -999
2 -998 19235 -998
3 -997 19236 -997
4 -996 19237 -996
5 -995 19238 -995
6 995 762 10
7 996 763 10
8 997 764 10
9 998 765 10
10 999 766 10
11 0 20000 0
select cidx, CDECIMAL4, CUTINYINT, LEAST(CDECIMAL4,CUTINYINT) from datatypetestm;
cidx CDECIMAL4 CUTINYINT LEAST(CDECIMAL4,CUTINYINT)
1 -999 94 -999
2 -998 95 -998
3 -997 96 -997
4 -996 97 -996
5 -995 98 -995
6 995 22 22
7 996 23 23
8 997 24 24
9 998 25 25
10 999 26 26
11 0 120 0
select cidx, CDECIMAL4, CUBIGINT, LEAST(CDECIMAL4,CUBIGINT) from datatypetestm;
cidx CDECIMAL4 CUBIGINT LEAST(CDECIMAL4,CUBIGINT)
1 -999 5222927963145224194 -999
2 -998 5222927963145224195 -998
3 -997 5222927963145224196 -997
4 -996 5222927963145224197 -996
5 -995 5222927963145224198 -995
6 995 72036854775802 995
7 996 72036854775803 996
8 997 72036854775804 997
9 998 72036854775805 998
10 999 72036854775806 999
11 0 5223000000000000000 0
select cidx, CDECIMAL4_2, CUSMALLINT, LEAST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL4_2 CUSMALLINT LEAST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10)
1 -9.99 19234 -9.99
2 -9.98 19235 -9.98
3 -9.97 19236 -9.97
4 -9.96 19237 -9.96
5 -9.95 19238 -9.95
6 9.95 762 9.95
7 9.96 763 9.96
8 9.97 764 9.97
9 9.98 765 9.98
10 9.99 766 9.99
11 0.00 20000 0.00
select cidx, CDECIMAL4_2, CUTINYINT, LEAST(CDECIMAL4_2,CUTINYINT) from datatypetestm;
cidx CDECIMAL4_2 CUTINYINT LEAST(CDECIMAL4_2,CUTINYINT)
1 -9.99 94 -9.99
2 -9.98 95 -9.98
3 -9.97 96 -9.97
4 -9.96 97 -9.96
5 -9.95 98 -9.95
6 9.95 22 9.95
7 9.96 23 9.96
8 9.97 24 9.97
9 9.98 25 9.98
10 9.99 26 9.99
11 0.00 120 0.00
select cidx, CDECIMAL4_2, CUBIGINT, LEAST(CDECIMAL4_2,CUBIGINT) from datatypetestm;
cidx CDECIMAL4_2 CUBIGINT LEAST(CDECIMAL4_2,CUBIGINT)
1 -9.99 5222927963145224194 -9.99
2 -9.98 5222927963145224195 -9.98
3 -9.97 5222927963145224196 -9.97
4 -9.96 5222927963145224197 -9.96
5 -9.95 5222927963145224198 -9.95
6 9.95 72036854775802 9.95
7 9.96 72036854775803 9.96
8 9.97 72036854775804 9.97
9 9.98 72036854775805 9.98
10 9.99 72036854775806 9.99
11 0.00 5223000000000000000 0.00
select cidx, CDECIMAL9, CUSMALLINT, LEAST(CDECIMAL9,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL9 CUSMALLINT LEAST(CDECIMAL9,CUSMALLINT,CUTINYINT,10)
1 -999999 19234 -999999
2 -999998 19235 -999998
3 -999997 19236 -999997
4 -999996 19237 -999996
5 -999995 19238 -999995
6 999995 762 10
7 999996 763 10
8 999997 764 10
9 999998 765 10
10 999999 766 10
11 0 20000 0
select cidx, CDECIMAL9, CUTINYINT, LEAST(CDECIMAL9,CUTINYINT) from datatypetestm;
cidx CDECIMAL9 CUTINYINT LEAST(CDECIMAL9,CUTINYINT)
1 -999999 94 -999999
2 -999998 95 -999998
3 -999997 96 -999997
4 -999996 97 -999996
5 -999995 98 -999995
6 999995 22 22
7 999996 23 23
8 999997 24 24
9 999998 25 25
10 999999 26 26
11 0 120 0
select cidx, CDECIMAL9, CUBIGINT, LEAST(CDECIMAL9,CUBIGINT) from datatypetestm;
cidx CDECIMAL9 CUBIGINT LEAST(CDECIMAL9,CUBIGINT)
1 -999999 5222927963145224194 -999999
2 -999998 5222927963145224195 -999998
3 -999997 5222927963145224196 -999997
4 -999996 5222927963145224197 -999996
5 -999995 5222927963145224198 -999995
6 999995 72036854775802 999995
7 999996 72036854775803 999996
8 999997 72036854775804 999997
9 999998 72036854775805 999998
10 999999 72036854775806 999999
11 0 5223000000000000000 0
select cidx, CDECIMAL9_2, CUSMALLINT, LEAST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL9_2 CUSMALLINT LEAST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10)
1 -9999.99 19234 -9999.99
2 -9999.98 19235 -9999.98
3 -9999.97 19236 -9999.97
4 -9999.96 19237 -9999.96
5 -9999.95 19238 -9999.95
6 9999.95 762 10.00
7 9999.96 763 10.00
8 9999.97 764 10.00
9 9999.98 765 10.00
10 9999.99 766 10.00
11 0.00 20000 0.00
select cidx, CDECIMAL9_2, CUTINYINT, LEAST(CDECIMAL9_2,CUTINYINT) from datatypetestm;
cidx CDECIMAL9_2 CUTINYINT LEAST(CDECIMAL9_2,CUTINYINT)
1 -9999.99 94 -9999.99
2 -9999.98 95 -9999.98
3 -9999.97 96 -9999.97
4 -9999.96 97 -9999.96
5 -9999.95 98 -9999.95
6 9999.95 22 22.00
7 9999.96 23 23.00
8 9999.97 24 24.00
9 9999.98 25 25.00
10 9999.99 26 26.00
11 0.00 120 0.00
select cidx, CDECIMAL9_2, CUBIGINT, LEAST(CDECIMAL9_2,CUBIGINT) from datatypetestm;
cidx CDECIMAL9_2 CUBIGINT LEAST(CDECIMAL9_2,CUBIGINT)
1 -9999.99 5222927963145224194 -9999.99
2 -9999.98 5222927963145224195 -9999.98
3 -9999.97 5222927963145224196 -9999.97
4 -9999.96 5222927963145224197 -9999.96
5 -9999.95 5222927963145224198 -9999.95
6 9999.95 72036854775802 9999.95
7 9999.96 72036854775803 9999.96
8 9999.97 72036854775804 9999.97
9 9999.98 72036854775805 9999.98
10 9999.99 72036854775806 9999.99
11 0.00 5223000000000000000 0.00
select cidx, CDECIMAL18, CUSMALLINT, LEAST(CDECIMAL18,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL18 CUSMALLINT LEAST(CDECIMAL18,CUSMALLINT,CUTINYINT,10)
1 -9999999999999 19234 -9999999999999
2 -9999999999998 19235 -9999999999998
3 -9999999999997 19236 -9999999999997
4 -9999999999996 19237 -9999999999996
5 -9999999999995 19238 -9999999999995
6 9999999999995 762 10
7 9999999999996 763 10
8 9999999999997 764 10
9 9999999999998 765 10
10 9999999999999 766 10
11 0 20000 0
select cidx, CDECIMAL18, CUTINYINT, LEAST(CDECIMAL18,CUTINYINT) from datatypetestm;
cidx CDECIMAL18 CUTINYINT LEAST(CDECIMAL18,CUTINYINT)
1 -9999999999999 94 -9999999999999
2 -9999999999998 95 -9999999999998
3 -9999999999997 96 -9999999999997
4 -9999999999996 97 -9999999999996
5 -9999999999995 98 -9999999999995
6 9999999999995 22 22
7 9999999999996 23 23
8 9999999999997 24 24
9 9999999999998 25 25
10 9999999999999 26 26
11 0 120 0
select cidx, CDECIMAL18, CUBIGINT, LEAST(CDECIMAL18,CUBIGINT) from datatypetestm;
cidx CDECIMAL18 CUBIGINT LEAST(CDECIMAL18,CUBIGINT)
1 -9999999999999 5222927963145224194 -9999999999999
2 -9999999999998 5222927963145224195 -9999999999998
3 -9999999999997 5222927963145224196 -9999999999997
4 -9999999999996 5222927963145224197 -9999999999996
5 -9999999999995 5222927963145224198 -9999999999995
6 9999999999995 72036854775802 9999999999995
7 9999999999996 72036854775803 9999999999996
8 9999999999997 72036854775804 9999999999997
9 9999999999998 72036854775805 9999999999998
10 9999999999999 72036854775806 9999999999999
11 0 5223000000000000000 0
select cidx, CDECIMAL18_2, CUSMALLINT, LEAST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CDECIMAL18_2 CUSMALLINT LEAST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10)
1 -99999999999.99 19234 -99999999999.99
2 -99999999999.98 19235 -99999999999.98
3 -99999999999.97 19236 -99999999999.97
4 -99999999999.96 19237 -99999999999.96
5 -99999999999.95 19238 -99999999999.95
6 99999999999.95 762 10.00
7 99999999999.96 763 10.00
8 99999999999.97 764 10.00
9 99999999999.98 765 10.00
10 99999999999.99 766 10.00
11 0.00 20000 0.00
select cidx, CDECIMAL18_2, CUTINYINT, LEAST(CDECIMAL18_2,CUTINYINT) from datatypetestm;
cidx CDECIMAL18_2 CUTINYINT LEAST(CDECIMAL18_2,CUTINYINT)
1 -99999999999.99 94 -99999999999.99
2 -99999999999.98 95 -99999999999.98
3 -99999999999.97 96 -99999999999.97
4 -99999999999.96 97 -99999999999.96
5 -99999999999.95 98 -99999999999.95
6 99999999999.95 22 22.00
7 99999999999.96 23 23.00
8 99999999999.97 24 24.00
9 99999999999.98 25 25.00
10 99999999999.99 26 26.00
11 0.00 120 0.00
select cidx, CDECIMAL18_2, CUBIGINT, LEAST(CDECIMAL18_2,CUBIGINT) from datatypetestm;
cidx CDECIMAL18_2 CUBIGINT LEAST(CDECIMAL18_2,CUBIGINT)
1 -99999999999.99 5222927963145224194 -99999999999.99
2 -99999999999.98 5222927963145224195 -99999999999.98
3 -99999999999.97 5222927963145224196 -99999999999.97
4 -99999999999.96 5222927963145224197 -99999999999.96
5 -99999999999.95 5222927963145224198 -99999999999.95
6 99999999999.95 72036854775802 99999999999.95
7 99999999999.96 72036854775803 99999999999.96
8 99999999999.97 72036854775804 99999999999.97
9 99999999999.98 72036854775805 99999999999.98
10 99999999999.99 72036854775806 99999999999.99
11 0.00 5223000000000000000 0.00
select cidx, CINTEGER, CUINTEGER, LEAST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx CINTEGER CUINTEGER LEAST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1 -7483646 1132516354 -7483646
2 -7483645 1132516355 -7483645
3 -7483644 1132516356 -7483644
4 -7483643 1132516357 -7483643
5 -7483642 1132516358 -7483642
6 7483643 7483642 10
7 7483644 7483643 10
8 7483645 7483644 10
9 7483646 7483645 10
10 7483647 7483646 10
11 0 1140000000 0
select cidx, CINTEGER, CUSMALLINT, LEAST(CINTEGER,CUSMALLINT) from datatypetestm;
cidx CINTEGER CUSMALLINT LEAST(CINTEGER,CUSMALLINT)
1 -7483646 19234 -7483646
2 -7483645 19235 -7483645
3 -7483644 19236 -7483644
4 -7483643 19237 -7483643
5 -7483642 19238 -7483642
6 7483643 762 762
7 7483644 763 763
8 7483645 764 764
9 7483646 765 765
10 7483647 766 766
11 0 20000 0
select cidx, CINTEGER, CUTINYINT, LEAST(CINTEGER,CUTINYINT) from datatypetestm;
cidx CINTEGER CUTINYINT LEAST(CINTEGER,CUTINYINT)
1 -7483646 94 -7483646
2 -7483645 95 -7483645
3 -7483644 96 -7483644
4 -7483643 97 -7483643
5 -7483642 98 -7483642
6 7483643 22 22
7 7483644 23 23
8 7483645 24 24
9 7483646 25 25
10 7483647 26 26
11 0 120 0
select cidx, CSMALLINT, CUSMALLINT, LEAST(CSMALLINT,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx CSMALLINT CUSMALLINT LEAST(CSMALLINT,CUSMALLINT,CUTINYINT,10)
1 -766 19234 -766
2 -765 19235 -765
3 -764 19236 -764
4 -763 19237 -763
5 -762 19238 -762
6 763 762 10
7 764 763 10
8 765 764 10
9 766 765 10
10 767 766 10
11 0 20000 0
select cidx, CSMALLINT, CUSMALLINT, LEAST(CSMALLINT,CUSMALLINT) from datatypetestm;
cidx CSMALLINT CUSMALLINT LEAST(CSMALLINT,CUSMALLINT)
1 -766 19234 -766
2 -765 19235 -765
3 -764 19236 -764
4 -763 19237 -763
5 -762 19238 -762
6 763 762 762
7 764 763 763
8 765 764 764
9 766 765 765
10 767 766 766
11 0 20000 0
select cidx, CSMALLINT, CUTINYINT, LEAST(CSMALLINT,CUTINYINT) from datatypetestm;
cidx CSMALLINT CUTINYINT LEAST(CSMALLINT,CUTINYINT)
1 -766 94 -766
2 -765 95 -765
3 -764 96 -764
4 -763 97 -763
5 -762 98 -762
6 763 22 22
7 764 23 23
8 765 24 24
9 766 25 25
10 767 26 26
11 0 120 0
select cidx, CUBIGINT from datatypetestm where LEAST(CUBIGINT,CSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx CUBIGINT
1 5222927963145224194
2 5222927963145224195
3 5222927963145224196
4 5222927963145224197
5 5222927963145224198
6 72036854775802
7 72036854775803
8 72036854775804
9 72036854775805
10 72036854775806
11 5223000000000000000
select cidx, CUSMALLINT from datatypetestm where LEAST(CUSMALLINT,CSMALLINT) <> CUSMALLINT;
cidx CUSMALLINT
1 19234
2 19235
3 19236
4 19237
5 19238
11 20000
select cidx, CUBIGINT from datatypetestm where LEAST(CDECIMAL18,CUBIGINT,CUSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx CUBIGINT
1 5222927963145224194
2 5222927963145224195
3 5222927963145224196
4 5222927963145224197
5 5222927963145224198
6 72036854775802
7 72036854775803
8 72036854775804
9 72036854775805
10 72036854775806
11 5223000000000000000
select cidx, CDECIMAL18 from datatypetestm where LEAST(CDECIMAL18,CUSMALLINT) <> CDECIMAL18;
cidx CDECIMAL18
6 9999999999995
7 9999999999996
8 9999999999997
9 9999999999998
10 9999999999999
select cidx, CDECIMAL18 from datatypetestm where LEAST(CDECIMAL18,CUTINYINT) <> CDECIMAL18;
cidx CDECIMAL18
6 9999999999995
7 9999999999996
8 9999999999997
9 9999999999998
10 9999999999999
select cidx, CDECIMAL18_2 from datatypetestm where LEAST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx CDECIMAL18_2
1 -99999999999.99
2 -99999999999.98
3 -99999999999.97
4 -99999999999.96
5 -99999999999.95
6 99999999999.95
7 99999999999.96
8 99999999999.97
9 99999999999.98
10 99999999999.99
11 0.00
select cidx, CUSMALLINT from datatypetestm where LEAST(CINTEGER,CUSMALLINT,CUTINYINT,10) <> CINTEGER;
cidx CUSMALLINT
6 762
7 763
8 764
9 765
10 766
select cidx, CINTEGER from datatypetestm where LEAST(CINTEGER,CUTINYINT) <> CINTEGER;
cidx CINTEGER
6 7483643
7 7483644
8 7483645
9 7483646
10 7483647
select cidx, CUSMALLINT from datatypetestm where LEAST(CSMALLINT,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx CUSMALLINT
1 19234
2 19235
3 19236
4 19237
5 19238
6 762
7 763
8 764
9 765
10 766
11 20000
select cidx, CSMALLINT from datatypetestm where LEAST(CSMALLINT,CUTINYINT) <> CSMALLINT;
cidx CSMALLINT
6 763
7 764
8 765
9 766
10 767
select cidx, CUTINYINT from datatypetestm where LEAST(CTINYINT,CSMALLINT,CUTINYINT,10) <> CUTINYINT;
cidx CUTINYINT
1 94
2 95
3 96
4 97
5 98
6 22
7 23
8 24
9 25
10 26
11 120
select cidx, CUTINYINT from datatypetestm where LEAST(CTINYINT,CUTINYINT) <> CUTINYINT;
cidx CUTINYINT
1 94
2 95
3 96
4 97
5 98
11 120
ALTER TABLE datatypetestm DROP COLUMN CUTINYINT;
ALTER TABLE datatypetestm DROP COLUMN CUSMALLINT;
ALTER TABLE datatypetestm DROP COLUMN CUINTEGER;
ALTER TABLE datatypetestm DROP COLUMN CUBIGINT;
DROP DATABASE unsigned_least_db;
View Git Blame Copy Permalink