DROP DATABASE IF EXISTS unsigned_greatest_db;
CREATE DATABASE unsigned_greatest_db;
USE unsigned_greatest_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, CUBIGINT, GREATEST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx	CUBIGINT	GREATEST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1	5222927963145224194	5222927963145224194
2	5222927963145224195	5222927963145224195
3	5222927963145224196	5222927963145224196
4	5222927963145224197	5222927963145224197
5	5222927963145224198	5222927963145224198
6	5223072036854775803	5223072036854775803
7	5223072036854775804	5223072036854775804
8	5223072036854775805	5223072036854775805
9	5223072036854775806	5223072036854775806
10	5223072036854775807	5223072036854775807
11	5223000000000000000	5223000000000000000
select cidx, CDECIMAL1, CUSMALLINT, GREATEST(CDECIMAL1,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL1	CUSMALLINT	GREATEST(CDECIMAL1,CUSMALLINT,CUTINYINT,10)
1	-9	19234	19234
2	-8	19235	19235
3	-7	19236	19236
4	-6	19237	19237
5	-5	19238	19238
6	5	20763	20763
7	6	20764	20764
8	7	20765	20765
9	8	20766	20766
10	9	20767	20767
11	0	20000	20000
select cidx, CDECIMAL1, CUTINYINT, GREATEST(CDECIMAL1,CUTINYINT) from datatypetestm;
cidx	CDECIMAL1	CUTINYINT	GREATEST(CDECIMAL1,CUTINYINT)
1	-9	94	94
2	-8	95	95
3	-7	96	96
4	-6	97	97
5	-5	98	98
6	5	143	143
7	6	144	144
8	7	145	145
9	8	146	146
10	9	147	147
11	0	120	120
select cidx, CDECIMAL1, CUBIGINT, GREATEST(CDECIMAL1,CUBIGINT) from datatypetestm;
cidx	CDECIMAL1	CUBIGINT	GREATEST(CDECIMAL1,CUBIGINT)
1	-9	5222927963145224194	5222927963145224194
2	-8	5222927963145224195	5222927963145224195
3	-7	5222927963145224196	5222927963145224196
4	-6	5222927963145224197	5222927963145224197
5	-5	5222927963145224198	5222927963145224198
6	5	5223072036854775803	5223072036854775803
7	6	5223072036854775804	5223072036854775804
8	7	5223072036854775805	5223072036854775805
9	8	5223072036854775806	5223072036854775806
10	9	5223072036854775807	5223072036854775807
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL4, CUSMALLINT, GREATEST(CDECIMAL4,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL4	CUSMALLINT	GREATEST(CDECIMAL4,CUSMALLINT,CUTINYINT,10)
1	-999	19234	19234
2	-998	19235	19235
3	-997	19236	19236
4	-996	19237	19237
5	-995	19238	19238
6	995	20763	20763
7	996	20764	20764
8	997	20765	20765
9	998	20766	20766
10	999	20767	20767
11	0	20000	20000
select cidx, CDECIMAL4, CUTINYINT, GREATEST(CDECIMAL4,CUTINYINT) from datatypetestm;
cidx	CDECIMAL4	CUTINYINT	GREATEST(CDECIMAL4,CUTINYINT)
1	-999	94	94
2	-998	95	95
3	-997	96	96
4	-996	97	97
5	-995	98	98
6	995	143	995
7	996	144	996
8	997	145	997
9	998	146	998
10	999	147	999
11	0	120	120
select cidx, CDECIMAL4, CUBIGINT, GREATEST(CDECIMAL4,CUBIGINT) from datatypetestm;
cidx	CDECIMAL4	CUBIGINT	GREATEST(CDECIMAL4,CUBIGINT)
1	-999	5222927963145224194	5222927963145224194
2	-998	5222927963145224195	5222927963145224195
3	-997	5222927963145224196	5222927963145224196
4	-996	5222927963145224197	5222927963145224197
5	-995	5222927963145224198	5222927963145224198
6	995	5223072036854775803	5223072036854775803
7	996	5223072036854775804	5223072036854775804
8	997	5223072036854775805	5223072036854775805
9	998	5223072036854775806	5223072036854775806
10	999	5223072036854775807	5223072036854775807
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL4_2, CUSMALLINT, GREATEST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL4_2	CUSMALLINT	GREATEST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10)
1	-9.99	19234	19234.00
2	-9.98	19235	19235.00
3	-9.97	19236	19236.00
4	-9.96	19237	19237.00
5	-9.95	19238	19238.00
6	9.95	20763	20763.00
7	9.96	20764	20764.00
8	9.97	20765	20765.00
9	9.98	20766	20766.00
10	9.99	20767	20767.00
11	0.00	20000	20000.00
select cidx, CDECIMAL4_2, CUTINYINT, GREATEST(CDECIMAL4_2,CUTINYINT) from datatypetestm;
cidx	CDECIMAL4_2	CUTINYINT	GREATEST(CDECIMAL4_2,CUTINYINT)
1	-9.99	94	94.00
2	-9.98	95	95.00
3	-9.97	96	96.00
4	-9.96	97	97.00
5	-9.95	98	98.00
6	9.95	143	143.00
7	9.96	144	144.00
8	9.97	145	145.00
9	9.98	146	146.00
10	9.99	147	147.00
11	0.00	120	120.00
select cidx, CDECIMAL4_2, CUBIGINT, GREATEST(CDECIMAL4_2,CUBIGINT) from datatypetestm;
cidx	CDECIMAL4_2	CUBIGINT	GREATEST(CDECIMAL4_2,CUBIGINT)
1	-9.99	5222927963145224194	5222927963145224194.00
2	-9.98	5222927963145224195	5222927963145224195.00
3	-9.97	5222927963145224196	5222927963145224196.00
4	-9.96	5222927963145224197	5222927963145224197.00
5	-9.95	5222927963145224198	5222927963145224198.00
6	9.95	5223072036854775803	5223072036854775803.00
7	9.96	5223072036854775804	5223072036854775804.00
8	9.97	5223072036854775805	5223072036854775805.00
9	9.98	5223072036854775806	5223072036854775806.00
10	9.99	5223072036854775807	5223072036854775807.00
11	0.00	5223000000000000000	5223000000000000000.00
select cidx, CDECIMAL9, CUSMALLINT, GREATEST(CDECIMAL9,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL9	CUSMALLINT	GREATEST(CDECIMAL9,CUSMALLINT,CUTINYINT,10)
1	-999999	19234	19234
2	-999998	19235	19235
3	-999997	19236	19236
4	-999996	19237	19237
5	-999995	19238	19238
6	999995	20763	999995
7	999996	20764	999996
8	999997	20765	999997
9	999998	20766	999998
10	999999	20767	999999
11	0	20000	20000
select cidx, CDECIMAL9, CUTINYINT, GREATEST(CDECIMAL9,CUTINYINT) from datatypetestm;
cidx	CDECIMAL9	CUTINYINT	GREATEST(CDECIMAL9,CUTINYINT)
1	-999999	94	94
2	-999998	95	95
3	-999997	96	96
4	-999996	97	97
5	-999995	98	98
6	999995	143	999995
7	999996	144	999996
8	999997	145	999997
9	999998	146	999998
10	999999	147	999999
11	0	120	120
select cidx, CDECIMAL9, CUBIGINT, GREATEST(CDECIMAL9,CUBIGINT) from datatypetestm;
cidx	CDECIMAL9	CUBIGINT	GREATEST(CDECIMAL9,CUBIGINT)
1	-999999	5222927963145224194	5222927963145224194
2	-999998	5222927963145224195	5222927963145224195
3	-999997	5222927963145224196	5222927963145224196
4	-999996	5222927963145224197	5222927963145224197
5	-999995	5222927963145224198	5222927963145224198
6	999995	5223072036854775803	5223072036854775803
7	999996	5223072036854775804	5223072036854775804
8	999997	5223072036854775805	5223072036854775805
9	999998	5223072036854775806	5223072036854775806
10	999999	5223072036854775807	5223072036854775807
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL9_2, CUSMALLINT, GREATEST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL9_2	CUSMALLINT	GREATEST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10)
1	-9999.99	19234	19234.00
2	-9999.98	19235	19235.00
3	-9999.97	19236	19236.00
4	-9999.96	19237	19237.00
5	-9999.95	19238	19238.00
6	9999.95	20763	20763.00
7	9999.96	20764	20764.00
8	9999.97	20765	20765.00
9	9999.98	20766	20766.00
10	9999.99	20767	20767.00
11	0.00	20000	20000.00
select cidx, CDECIMAL9_2, CUTINYINT, GREATEST(CDECIMAL9_2,CUTINYINT) from datatypetestm;
cidx	CDECIMAL9_2	CUTINYINT	GREATEST(CDECIMAL9_2,CUTINYINT)
1	-9999.99	94	94.00
2	-9999.98	95	95.00
3	-9999.97	96	96.00
4	-9999.96	97	97.00
5	-9999.95	98	98.00
6	9999.95	143	9999.95
7	9999.96	144	9999.96
8	9999.97	145	9999.97
9	9999.98	146	9999.98
10	9999.99	147	9999.99
11	0.00	120	120.00
select cidx, CDECIMAL9_2, CUBIGINT, GREATEST(CDECIMAL9_2,CUBIGINT) from datatypetestm;
cidx	CDECIMAL9_2	CUBIGINT	GREATEST(CDECIMAL9_2,CUBIGINT)
1	-9999.99	5222927963145224194	5222927963145224194.00
2	-9999.98	5222927963145224195	5222927963145224195.00
3	-9999.97	5222927963145224196	5222927963145224196.00
4	-9999.96	5222927963145224197	5222927963145224197.00
5	-9999.95	5222927963145224198	5222927963145224198.00
6	9999.95	5223072036854775803	5223072036854775803.00
7	9999.96	5223072036854775804	5223072036854775804.00
8	9999.97	5223072036854775805	5223072036854775805.00
9	9999.98	5223072036854775806	5223072036854775806.00
10	9999.99	5223072036854775807	5223072036854775807.00
11	0.00	5223000000000000000	5223000000000000000.00
select cidx, CDECIMAL18, CUSMALLINT, GREATEST(CDECIMAL18,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL18	CUSMALLINT	GREATEST(CDECIMAL18,CUSMALLINT,CUTINYINT,10)
1	-9999999999999	19234	19234
2	-9999999999998	19235	19235
3	-9999999999997	19236	19236
4	-9999999999996	19237	19237
5	-9999999999995	19238	19238
6	9999999999995	20763	9999999999995
7	9999999999996	20764	9999999999996
8	9999999999997	20765	9999999999997
9	9999999999998	20766	9999999999998
10	9999999999999	20767	9999999999999
11	0	20000	20000
select cidx, CDECIMAL18, CUTINYINT, GREATEST(CDECIMAL18,CUTINYINT) from datatypetestm;
cidx	CDECIMAL18	CUTINYINT	GREATEST(CDECIMAL18,CUTINYINT)
1	-9999999999999	94	94
2	-9999999999998	95	95
3	-9999999999997	96	96
4	-9999999999996	97	97
5	-9999999999995	98	98
6	9999999999995	143	9999999999995
7	9999999999996	144	9999999999996
8	9999999999997	145	9999999999997
9	9999999999998	146	9999999999998
10	9999999999999	147	9999999999999
11	0	120	120
select cidx, CDECIMAL18, CUBIGINT, GREATEST(CDECIMAL18,CUBIGINT) from datatypetestm;
cidx	CDECIMAL18	CUBIGINT	GREATEST(CDECIMAL18,CUBIGINT)
1	-9999999999999	5222927963145224194	5222927963145224194
2	-9999999999998	5222927963145224195	5222927963145224195
3	-9999999999997	5222927963145224196	5222927963145224196
4	-9999999999996	5222927963145224197	5222927963145224197
5	-9999999999995	5222927963145224198	5222927963145224198
6	9999999999995	5223072036854775803	5223072036854775803
7	9999999999996	5223072036854775804	5223072036854775804
8	9999999999997	5223072036854775805	5223072036854775805
9	9999999999998	5223072036854775806	5223072036854775806
10	9999999999999	5223072036854775807	5223072036854775807
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL18_2, CUSMALLINT, GREATEST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL18_2	CUSMALLINT	GREATEST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10)
1	-99999999999.99	19234	19234.00
2	-99999999999.98	19235	19235.00
3	-99999999999.97	19236	19236.00
4	-99999999999.96	19237	19237.00
5	-99999999999.95	19238	19238.00
6	99999999999.95	20763	99999999999.95
7	99999999999.96	20764	99999999999.96
8	99999999999.97	20765	99999999999.97
9	99999999999.98	20766	99999999999.98
10	99999999999.99	20767	99999999999.99
11	0.00	20000	20000.00
select cidx, CDECIMAL18_2, CUTINYINT, GREATEST(CDECIMAL18_2,CUTINYINT) from datatypetestm;
cidx	CDECIMAL18_2	CUTINYINT	GREATEST(CDECIMAL18_2,CUTINYINT)
1	-99999999999.99	94	94.00
2	-99999999999.98	95	95.00
3	-99999999999.97	96	96.00
4	-99999999999.96	97	97.00
5	-99999999999.95	98	98.00
6	99999999999.95	143	99999999999.95
7	99999999999.96	144	99999999999.96
8	99999999999.97	145	99999999999.97
9	99999999999.98	146	99999999999.98
10	99999999999.99	147	99999999999.99
11	0.00	120	120.00
select cidx, CDECIMAL18_2, CUBIGINT, GREATEST(CDECIMAL18_2,CUBIGINT) from datatypetestm;
cidx	CDECIMAL18_2	CUBIGINT	GREATEST(CDECIMAL18_2,CUBIGINT)
1	-99999999999.99	5222927963145224194	5222927963145224194.00
2	-99999999999.98	5222927963145224195	5222927963145224195.00
3	-99999999999.97	5222927963145224196	5222927963145224196.00
4	-99999999999.96	5222927963145224197	5222927963145224197.00
5	-99999999999.95	5222927963145224198	5222927963145224198.00
6	99999999999.95	5223072036854775803	5223072036854775803.00
7	99999999999.96	5223072036854775804	5223072036854775804.00
8	99999999999.97	5223072036854775805	5223072036854775805.00
9	99999999999.98	5223072036854775806	5223072036854775806.00
10	99999999999.99	5223072036854775807	5223072036854775807.00
11	0.00	5223000000000000000	5223000000000000000.00
select cidx, CINTEGER, CUINTEGER, GREATEST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx	CINTEGER	CUINTEGER	GREATEST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1	-7483646	1132516354	1132516354
2	-7483645	1132516355	1132516355
3	-7483644	1132516356	1132516356
4	-7483643	1132516357	1132516357
5	-7483642	1132516358	1132516358
6	7483643	1147483643	1147483643
7	7483644	1147483644	1147483644
8	7483645	1147483645	1147483645
9	7483646	1147483646	1147483646
10	7483647	1147483647	1147483647
11	0	1140000000	1140000000
select cidx, CINTEGER, CUSMALLINT, GREATEST(CINTEGER,CUSMALLINT) from datatypetestm;
cidx	CINTEGER	CUSMALLINT	GREATEST(CINTEGER,CUSMALLINT)
1	-7483646	19234	19234
2	-7483645	19235	19235
3	-7483644	19236	19236
4	-7483643	19237	19237
5	-7483642	19238	19238
6	7483643	20763	7483643
7	7483644	20764	7483644
8	7483645	20765	7483645
9	7483646	20766	7483646
10	7483647	20767	7483647
11	0	20000	20000
select cidx, CINTEGER, CUTINYINT, GREATEST(CINTEGER,CUTINYINT) from datatypetestm;
cidx	CINTEGER	CUTINYINT	GREATEST(CINTEGER,CUTINYINT)
1	-7483646	94	94
2	-7483645	95	95
3	-7483644	96	96
4	-7483643	97	97
5	-7483642	98	98
6	7483643	143	7483643
7	7483644	144	7483644
8	7483645	145	7483645
9	7483646	146	7483646
10	7483647	147	7483647
11	0	120	120
select cidx, CSMALLINT, CUSMALLINT, GREATEST(CSMALLINT,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CSMALLINT	CUSMALLINT	GREATEST(CSMALLINT,CUSMALLINT,CUTINYINT,10)
1	-766	19234	19234
2	-765	19235	19235
3	-764	19236	19236
4	-763	19237	19237
5	-762	19238	19238
6	763	20763	20763
7	764	20764	20764
8	765	20765	20765
9	766	20766	20766
10	767	20767	20767
11	0	20000	20000
select cidx, CSMALLINT, CUSMALLINT, GREATEST(CSMALLINT,CUSMALLINT) from datatypetestm;
cidx	CSMALLINT	CUSMALLINT	GREATEST(CSMALLINT,CUSMALLINT)
1	-766	19234	19234
2	-765	19235	19235
3	-764	19236	19236
4	-763	19237	19237
5	-762	19238	19238
6	763	20763	20763
7	764	20764	20764
8	765	20765	20765
9	766	20766	20766
10	767	20767	20767
11	0	20000	20000
select cidx, CSMALLINT, CUTINYINT, GREATEST(CSMALLINT,CUTINYINT) from datatypetestm;
cidx	CSMALLINT	CUTINYINT	GREATEST(CSMALLINT,CUTINYINT)
1	-766	94	94
2	-765	95	95
3	-764	96	96
4	-763	97	97
5	-762	98	98
6	763	143	763
7	764	144	764
8	765	145	765
9	766	146	766
10	767	147	767
11	0	120	120
select cidx, CUBIGINT from datatypetestm where GREATEST(CUBIGINT,CSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx	CUBIGINT
select cidx, CUSMALLINT from datatypetestm where GREATEST(CUSMALLINT,CSMALLINT) <> CUSMALLINT;
cidx	CUSMALLINT
select cidx, CUBIGINT from datatypetestm where GREATEST(CDECIMAL18,CUBIGINT,CUSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx	CUBIGINT
select cidx, CDECIMAL18 from datatypetestm where GREATEST(CDECIMAL18,CUSMALLINT) <> CDECIMAL18;
cidx	CDECIMAL18
1	-9999999999999
2	-9999999999998
3	-9999999999997
4	-9999999999996
5	-9999999999995
11	0
select cidx, CDECIMAL18 from datatypetestm where GREATEST(CDECIMAL18,CUTINYINT) <> CDECIMAL18;
cidx	CDECIMAL18
1	-9999999999999
2	-9999999999998
3	-9999999999997
4	-9999999999996
5	-9999999999995
11	0
select cidx, CDECIMAL18_2 from datatypetestm where GREATEST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx	CDECIMAL18_2
6	99999999999.95
7	99999999999.96
8	99999999999.97
9	99999999999.98
10	99999999999.99
select cidx, CUSMALLINT from datatypetestm where GREATEST(CINTEGER,CUSMALLINT,CUTINYINT,10) <> CINTEGER;
cidx	CUSMALLINT
1	19234
2	19235
3	19236
4	19237
5	19238
11	20000
select cidx, CINTEGER from datatypetestm where GREATEST(CINTEGER,CUTINYINT) <> CINTEGER;
cidx	CINTEGER
1	-7483646
2	-7483645
3	-7483644
4	-7483643
5	-7483642
11	0
select cidx, CUSMALLINT from datatypetestm where GREATEST(CSMALLINT,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx	CUSMALLINT
select cidx, CSMALLINT from datatypetestm where GREATEST(CSMALLINT,CUTINYINT) <> CSMALLINT;
cidx	CSMALLINT
1	-766
2	-765
3	-764
4	-763
5	-762
11	0
select cidx, CUTINYINT from datatypetestm where GREATEST(CTINYINT,CSMALLINT,CUTINYINT,10) <> CUTINYINT;
cidx	CUTINYINT
6	143
7	144
8	145
9	146
10	147
select cidx, CUTINYINT from datatypetestm where GREATEST(CTINYINT,CUTINYINT) <> CUTINYINT;
cidx	CUTINYINT
UPDATE datatypetestm SET CUTINYINT=CTINYINT-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUTINYINT' 
UPDATE datatypetestm SET CUTINYINT=CTINYINT-1 WHERE CTINYINT > 0;
UPDATE datatypetestm SET CUSMALLINT=CSMALLINT-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUSMALLINT' 
UPDATE datatypetestm SET CUSMALLINT=CSMALLINT-1 WHERE CSMALLINT > 0;
UPDATE datatypetestm SET CUINTEGER=CINTEGER-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUINTEGER' 
UPDATE datatypetestm SET CUINTEGER=CINTEGER-1 WHERE CINTEGER > 0;
UPDATE datatypetestm SET CUBIGINT=CBIGINT-1;
ERROR 22003: CAL0002: MCS-2025: Data truncated for column 'CUBIGINT' 
UPDATE datatypetestm SET CUBIGINT=CBIGINT-1 WHERE CBIGINT > 0;
select cidx, CUBIGINT, GREATEST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx	CUBIGINT	GREATEST(CUBIGINT,CBIGINT,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1	5222927963145224194	5222927963145224194
2	5222927963145224195	5222927963145224195
3	5222927963145224196	5222927963145224196
4	5222927963145224197	5222927963145224197
5	5222927963145224198	5222927963145224198
6	72036854775802	72036854775803
7	72036854775803	72036854775804
8	72036854775804	72036854775805
9	72036854775805	72036854775806
10	72036854775806	72036854775807
11	5223000000000000000	5223000000000000000
select cidx, CDECIMAL1, CUSMALLINT, GREATEST(CDECIMAL1,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL1	CUSMALLINT	GREATEST(CDECIMAL1,CUSMALLINT,CUTINYINT,10)
1	-9	19234	19234
2	-8	19235	19235
3	-7	19236	19236
4	-6	19237	19237
5	-5	19238	19238
6	5	762	762
7	6	763	763
8	7	764	764
9	8	765	765
10	9	766	766
11	0	20000	20000
select cidx, CDECIMAL1, CUTINYINT, GREATEST(CDECIMAL1,CUTINYINT) from datatypetestm;
cidx	CDECIMAL1	CUTINYINT	GREATEST(CDECIMAL1,CUTINYINT)
1	-9	94	94
2	-8	95	95
3	-7	96	96
4	-6	97	97
5	-5	98	98
6	5	22	22
7	6	23	23
8	7	24	24
9	8	25	25
10	9	26	26
11	0	120	120
select cidx, CDECIMAL1, CUBIGINT, GREATEST(CDECIMAL1,CUBIGINT) from datatypetestm;
cidx	CDECIMAL1	CUBIGINT	GREATEST(CDECIMAL1,CUBIGINT)
1	-9	5222927963145224194	5222927963145224194
2	-8	5222927963145224195	5222927963145224195
3	-7	5222927963145224196	5222927963145224196
4	-6	5222927963145224197	5222927963145224197
5	-5	5222927963145224198	5222927963145224198
6	5	72036854775802	72036854775802
7	6	72036854775803	72036854775803
8	7	72036854775804	72036854775804
9	8	72036854775805	72036854775805
10	9	72036854775806	72036854775806
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL4, CUSMALLINT, GREATEST(CDECIMAL4,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL4	CUSMALLINT	GREATEST(CDECIMAL4,CUSMALLINT,CUTINYINT,10)
1	-999	19234	19234
2	-998	19235	19235
3	-997	19236	19236
4	-996	19237	19237
5	-995	19238	19238
6	995	762	995
7	996	763	996
8	997	764	997
9	998	765	998
10	999	766	999
11	0	20000	20000
select cidx, CDECIMAL4, CUTINYINT, GREATEST(CDECIMAL4,CUTINYINT) from datatypetestm;
cidx	CDECIMAL4	CUTINYINT	GREATEST(CDECIMAL4,CUTINYINT)
1	-999	94	94
2	-998	95	95
3	-997	96	96
4	-996	97	97
5	-995	98	98
6	995	22	995
7	996	23	996
8	997	24	997
9	998	25	998
10	999	26	999
11	0	120	120
select cidx, CDECIMAL4, CUBIGINT, GREATEST(CDECIMAL4,CUBIGINT) from datatypetestm;
cidx	CDECIMAL4	CUBIGINT	GREATEST(CDECIMAL4,CUBIGINT)
1	-999	5222927963145224194	5222927963145224194
2	-998	5222927963145224195	5222927963145224195
3	-997	5222927963145224196	5222927963145224196
4	-996	5222927963145224197	5222927963145224197
5	-995	5222927963145224198	5222927963145224198
6	995	72036854775802	72036854775802
7	996	72036854775803	72036854775803
8	997	72036854775804	72036854775804
9	998	72036854775805	72036854775805
10	999	72036854775806	72036854775806
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL4_2, CUSMALLINT, GREATEST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL4_2	CUSMALLINT	GREATEST(CDECIMAL4_2,CUSMALLINT,CUTINYINT,10)
1	-9.99	19234	19234.00
2	-9.98	19235	19235.00
3	-9.97	19236	19236.00
4	-9.96	19237	19237.00
5	-9.95	19238	19238.00
6	9.95	762	762.00
7	9.96	763	763.00
8	9.97	764	764.00
9	9.98	765	765.00
10	9.99	766	766.00
11	0.00	20000	20000.00
select cidx, CDECIMAL4_2, CUTINYINT, GREATEST(CDECIMAL4_2,CUTINYINT) from datatypetestm;
cidx	CDECIMAL4_2	CUTINYINT	GREATEST(CDECIMAL4_2,CUTINYINT)
1	-9.99	94	94.00
2	-9.98	95	95.00
3	-9.97	96	96.00
4	-9.96	97	97.00
5	-9.95	98	98.00
6	9.95	22	22.00
7	9.96	23	23.00
8	9.97	24	24.00
9	9.98	25	25.00
10	9.99	26	26.00
11	0.00	120	120.00
select cidx, CDECIMAL4_2, CUBIGINT, GREATEST(CDECIMAL4_2,CUBIGINT) from datatypetestm;
cidx	CDECIMAL4_2	CUBIGINT	GREATEST(CDECIMAL4_2,CUBIGINT)
1	-9.99	5222927963145224194	5222927963145224194.00
2	-9.98	5222927963145224195	5222927963145224195.00
3	-9.97	5222927963145224196	5222927963145224196.00
4	-9.96	5222927963145224197	5222927963145224197.00
5	-9.95	5222927963145224198	5222927963145224198.00
6	9.95	72036854775802	72036854775802.00
7	9.96	72036854775803	72036854775803.00
8	9.97	72036854775804	72036854775804.00
9	9.98	72036854775805	72036854775805.00
10	9.99	72036854775806	72036854775806.00
11	0.00	5223000000000000000	5223000000000000000.00
select cidx, CDECIMAL9, CUSMALLINT, GREATEST(CDECIMAL9,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL9	CUSMALLINT	GREATEST(CDECIMAL9,CUSMALLINT,CUTINYINT,10)
1	-999999	19234	19234
2	-999998	19235	19235
3	-999997	19236	19236
4	-999996	19237	19237
5	-999995	19238	19238
6	999995	762	999995
7	999996	763	999996
8	999997	764	999997
9	999998	765	999998
10	999999	766	999999
11	0	20000	20000
select cidx, CDECIMAL9, CUTINYINT, GREATEST(CDECIMAL9,CUTINYINT) from datatypetestm;
cidx	CDECIMAL9	CUTINYINT	GREATEST(CDECIMAL9,CUTINYINT)
1	-999999	94	94
2	-999998	95	95
3	-999997	96	96
4	-999996	97	97
5	-999995	98	98
6	999995	22	999995
7	999996	23	999996
8	999997	24	999997
9	999998	25	999998
10	999999	26	999999
11	0	120	120
select cidx, CDECIMAL9, CUBIGINT, GREATEST(CDECIMAL9,CUBIGINT) from datatypetestm;
cidx	CDECIMAL9	CUBIGINT	GREATEST(CDECIMAL9,CUBIGINT)
1	-999999	5222927963145224194	5222927963145224194
2	-999998	5222927963145224195	5222927963145224195
3	-999997	5222927963145224196	5222927963145224196
4	-999996	5222927963145224197	5222927963145224197
5	-999995	5222927963145224198	5222927963145224198
6	999995	72036854775802	72036854775802
7	999996	72036854775803	72036854775803
8	999997	72036854775804	72036854775804
9	999998	72036854775805	72036854775805
10	999999	72036854775806	72036854775806
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL9_2, CUSMALLINT, GREATEST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL9_2	CUSMALLINT	GREATEST(CDECIMAL9_2,CUSMALLINT,CUTINYINT,10)
1	-9999.99	19234	19234.00
2	-9999.98	19235	19235.00
3	-9999.97	19236	19236.00
4	-9999.96	19237	19237.00
5	-9999.95	19238	19238.00
6	9999.95	762	9999.95
7	9999.96	763	9999.96
8	9999.97	764	9999.97
9	9999.98	765	9999.98
10	9999.99	766	9999.99
11	0.00	20000	20000.00
select cidx, CDECIMAL9_2, CUTINYINT, GREATEST(CDECIMAL9_2,CUTINYINT) from datatypetestm;
cidx	CDECIMAL9_2	CUTINYINT	GREATEST(CDECIMAL9_2,CUTINYINT)
1	-9999.99	94	94.00
2	-9999.98	95	95.00
3	-9999.97	96	96.00
4	-9999.96	97	97.00
5	-9999.95	98	98.00
6	9999.95	22	9999.95
7	9999.96	23	9999.96
8	9999.97	24	9999.97
9	9999.98	25	9999.98
10	9999.99	26	9999.99
11	0.00	120	120.00
select cidx, CDECIMAL9_2, CUBIGINT, GREATEST(CDECIMAL9_2,CUBIGINT) from datatypetestm;
cidx	CDECIMAL9_2	CUBIGINT	GREATEST(CDECIMAL9_2,CUBIGINT)
1	-9999.99	5222927963145224194	5222927963145224194.00
2	-9999.98	5222927963145224195	5222927963145224195.00
3	-9999.97	5222927963145224196	5222927963145224196.00
4	-9999.96	5222927963145224197	5222927963145224197.00
5	-9999.95	5222927963145224198	5222927963145224198.00
6	9999.95	72036854775802	72036854775802.00
7	9999.96	72036854775803	72036854775803.00
8	9999.97	72036854775804	72036854775804.00
9	9999.98	72036854775805	72036854775805.00
10	9999.99	72036854775806	72036854775806.00
11	0.00	5223000000000000000	5223000000000000000.00
select cidx, CDECIMAL18, CUSMALLINT, GREATEST(CDECIMAL18,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL18	CUSMALLINT	GREATEST(CDECIMAL18,CUSMALLINT,CUTINYINT,10)
1	-9999999999999	19234	19234
2	-9999999999998	19235	19235
3	-9999999999997	19236	19236
4	-9999999999996	19237	19237
5	-9999999999995	19238	19238
6	9999999999995	762	9999999999995
7	9999999999996	763	9999999999996
8	9999999999997	764	9999999999997
9	9999999999998	765	9999999999998
10	9999999999999	766	9999999999999
11	0	20000	20000
select cidx, CDECIMAL18, CUTINYINT, GREATEST(CDECIMAL18,CUTINYINT) from datatypetestm;
cidx	CDECIMAL18	CUTINYINT	GREATEST(CDECIMAL18,CUTINYINT)
1	-9999999999999	94	94
2	-9999999999998	95	95
3	-9999999999997	96	96
4	-9999999999996	97	97
5	-9999999999995	98	98
6	9999999999995	22	9999999999995
7	9999999999996	23	9999999999996
8	9999999999997	24	9999999999997
9	9999999999998	25	9999999999998
10	9999999999999	26	9999999999999
11	0	120	120
select cidx, CDECIMAL18, CUBIGINT, GREATEST(CDECIMAL18,CUBIGINT) from datatypetestm;
cidx	CDECIMAL18	CUBIGINT	GREATEST(CDECIMAL18,CUBIGINT)
1	-9999999999999	5222927963145224194	5222927963145224194
2	-9999999999998	5222927963145224195	5222927963145224195
3	-9999999999997	5222927963145224196	5222927963145224196
4	-9999999999996	5222927963145224197	5222927963145224197
5	-9999999999995	5222927963145224198	5222927963145224198
6	9999999999995	72036854775802	72036854775802
7	9999999999996	72036854775803	72036854775803
8	9999999999997	72036854775804	72036854775804
9	9999999999998	72036854775805	72036854775805
10	9999999999999	72036854775806	72036854775806
11	0	5223000000000000000	5223000000000000000
select cidx, CDECIMAL18_2, CUSMALLINT, GREATEST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CDECIMAL18_2	CUSMALLINT	GREATEST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10)
1	-99999999999.99	19234	19234.00
2	-99999999999.98	19235	19235.00
3	-99999999999.97	19236	19236.00
4	-99999999999.96	19237	19237.00
5	-99999999999.95	19238	19238.00
6	99999999999.95	762	99999999999.95
7	99999999999.96	763	99999999999.96
8	99999999999.97	764	99999999999.97
9	99999999999.98	765	99999999999.98
10	99999999999.99	766	99999999999.99
11	0.00	20000	20000.00
select cidx, CDECIMAL18_2, CUTINYINT, GREATEST(CDECIMAL18_2,CUTINYINT) from datatypetestm;
cidx	CDECIMAL18_2	CUTINYINT	GREATEST(CDECIMAL18_2,CUTINYINT)
1	-99999999999.99	94	94.00
2	-99999999999.98	95	95.00
3	-99999999999.97	96	96.00
4	-99999999999.96	97	97.00
5	-99999999999.95	98	98.00
6	99999999999.95	22	99999999999.95
7	99999999999.96	23	99999999999.96
8	99999999999.97	24	99999999999.97
9	99999999999.98	25	99999999999.98
10	99999999999.99	26	99999999999.99
11	0.00	120	120.00
select cidx, CDECIMAL18_2, CUBIGINT, GREATEST(CDECIMAL18_2,CUBIGINT) from datatypetestm;
cidx	CDECIMAL18_2	CUBIGINT	GREATEST(CDECIMAL18_2,CUBIGINT)
1	-99999999999.99	5222927963145224194	5222927963145224194.00
2	-99999999999.98	5222927963145224195	5222927963145224195.00
3	-99999999999.97	5222927963145224196	5222927963145224196.00
4	-99999999999.96	5222927963145224197	5222927963145224197.00
5	-99999999999.95	5222927963145224198	5222927963145224198.00
6	99999999999.95	72036854775802	72036854775802.00
7	99999999999.96	72036854775803	72036854775803.00
8	99999999999.97	72036854775804	72036854775804.00
9	99999999999.98	72036854775805	72036854775805.00
10	99999999999.99	72036854775806	72036854775806.00
11	0.00	5223000000000000000	5223000000000000000.00
select cidx, CINTEGER, CUINTEGER, GREATEST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10) from datatypetestm;
cidx	CINTEGER	CUINTEGER	GREATEST(CUINTEGER,CINTEGER,CUSMALLINT,CSMALLINT,CUTINYINT,CTINYINT,10)
1	-7483646	1132516354	1132516354
2	-7483645	1132516355	1132516355
3	-7483644	1132516356	1132516356
4	-7483643	1132516357	1132516357
5	-7483642	1132516358	1132516358
6	7483643	7483642	7483643
7	7483644	7483643	7483644
8	7483645	7483644	7483645
9	7483646	7483645	7483646
10	7483647	7483646	7483647
11	0	1140000000	1140000000
select cidx, CINTEGER, CUSMALLINT, GREATEST(CINTEGER,CUSMALLINT) from datatypetestm;
cidx	CINTEGER	CUSMALLINT	GREATEST(CINTEGER,CUSMALLINT)
1	-7483646	19234	19234
2	-7483645	19235	19235
3	-7483644	19236	19236
4	-7483643	19237	19237
5	-7483642	19238	19238
6	7483643	762	7483643
7	7483644	763	7483644
8	7483645	764	7483645
9	7483646	765	7483646
10	7483647	766	7483647
11	0	20000	20000
select cidx, CINTEGER, CUTINYINT, GREATEST(CINTEGER,CUTINYINT) from datatypetestm;
cidx	CINTEGER	CUTINYINT	GREATEST(CINTEGER,CUTINYINT)
1	-7483646	94	94
2	-7483645	95	95
3	-7483644	96	96
4	-7483643	97	97
5	-7483642	98	98
6	7483643	22	7483643
7	7483644	23	7483644
8	7483645	24	7483645
9	7483646	25	7483646
10	7483647	26	7483647
11	0	120	120
select cidx, CSMALLINT, CUSMALLINT, GREATEST(CSMALLINT,CUSMALLINT,CUTINYINT,10) from datatypetestm;
cidx	CSMALLINT	CUSMALLINT	GREATEST(CSMALLINT,CUSMALLINT,CUTINYINT,10)
1	-766	19234	19234
2	-765	19235	19235
3	-764	19236	19236
4	-763	19237	19237
5	-762	19238	19238
6	763	762	763
7	764	763	764
8	765	764	765
9	766	765	766
10	767	766	767
11	0	20000	20000
select cidx, CSMALLINT, CUSMALLINT, GREATEST(CSMALLINT,CUSMALLINT) from datatypetestm;
cidx	CSMALLINT	CUSMALLINT	GREATEST(CSMALLINT,CUSMALLINT)
1	-766	19234	19234
2	-765	19235	19235
3	-764	19236	19236
4	-763	19237	19237
5	-762	19238	19238
6	763	762	763
7	764	763	764
8	765	764	765
9	766	765	766
10	767	766	767
11	0	20000	20000
select cidx, CSMALLINT, CUTINYINT, GREATEST(CSMALLINT,CUTINYINT) from datatypetestm;
cidx	CSMALLINT	CUTINYINT	GREATEST(CSMALLINT,CUTINYINT)
1	-766	94	94
2	-765	95	95
3	-764	96	96
4	-763	97	97
5	-762	98	98
6	763	22	763
7	764	23	764
8	765	24	765
9	766	25	766
10	767	26	767
11	0	120	120
select cidx, CUBIGINT from datatypetestm where GREATEST(CUBIGINT,CSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx	CUBIGINT
select cidx, CUSMALLINT from datatypetestm where GREATEST(CUSMALLINT,CSMALLINT) <> CUSMALLINT;
cidx	CUSMALLINT
6	762
7	763
8	764
9	765
10	766
select cidx, CUBIGINT from datatypetestm where GREATEST(CDECIMAL18,CUBIGINT,CUSMALLINT,CUTINYINT,10) <> CUBIGINT;
cidx	CUBIGINT
select cidx, CDECIMAL18 from datatypetestm where GREATEST(CDECIMAL18,CUSMALLINT) <> CDECIMAL18;
cidx	CDECIMAL18
1	-9999999999999
2	-9999999999998
3	-9999999999997
4	-9999999999996
5	-9999999999995
11	0
select cidx, CDECIMAL18 from datatypetestm where GREATEST(CDECIMAL18,CUTINYINT) <> CDECIMAL18;
cidx	CDECIMAL18
1	-9999999999999
2	-9999999999998
3	-9999999999997
4	-9999999999996
5	-9999999999995
11	0
select cidx, CDECIMAL18_2 from datatypetestm where GREATEST(CDECIMAL18_2,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx	CDECIMAL18_2
6	99999999999.95
7	99999999999.96
8	99999999999.97
9	99999999999.98
10	99999999999.99
select cidx, CUSMALLINT from datatypetestm where GREATEST(CINTEGER,CUSMALLINT,CUTINYINT,10) <> CINTEGER;
cidx	CUSMALLINT
1	19234
2	19235
3	19236
4	19237
5	19238
11	20000
select cidx, CINTEGER from datatypetestm where GREATEST(CINTEGER,CUTINYINT) <> CINTEGER;
cidx	CINTEGER
1	-7483646
2	-7483645
3	-7483644
4	-7483643
5	-7483642
11	0
select cidx, CUSMALLINT from datatypetestm where GREATEST(CSMALLINT,CUSMALLINT,CUTINYINT,10) <> CUSMALLINT;
cidx	CUSMALLINT
6	762
7	763
8	764
9	765
10	766
select cidx, CSMALLINT from datatypetestm where GREATEST(CSMALLINT,CUTINYINT) <> CSMALLINT;
cidx	CSMALLINT
1	-766
2	-765
3	-764
4	-763
5	-762
11	0
select cidx, CUTINYINT from datatypetestm where GREATEST(CTINYINT,CSMALLINT,CUTINYINT,10) <> CUTINYINT;
cidx	CUTINYINT
6	22
7	23
8	24
9	25
10	26
select cidx, CUTINYINT from datatypetestm where GREATEST(CTINYINT,CUTINYINT) <> CUTINYINT;
cidx	CUTINYINT
6	22
7	23
8	24
9	25
10	26
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_greatest_db;