USE tpch1;
drop table if exists bug3483;
create table bug3483 (c1 bigint, c2 decimal(18,2), c3 float, c4 double, c5 char(120), c6 varchar(120)) engine=columnstore;
insert into bug3483 values
(1, 1.1, 1.1, 1.1, '1.1', '1.1'),
(1234567890, 1234567890.1, 1234567890.1, 1234567890.1, '1234567890.1', '1234567890.1'),
(1234567890, 1234567890.8, 1234567890.8, 1234567890.8, '1234567890.8', '1234567890.8'),
(1.234567890e10, 1.2345678901e10, 1.2345678901e10, 1.2345678901e10, '1.2345678901e10', '1.2345678901e10'),
(1234567890, 1234567890123456.78, 1.2345678901e20, 1.2345678901e208, '12345678901234567890', '12345678901234567890'),
(1234567890, 1234567890987654.32, 1.2345678901e38, 1.2345678901e308, '12345678901234567890123456789012345678901234567890', '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'),
(-1, -1.1, -1.1, -1.1, '-1.1', '-1.1'),
(-1234567890, -1234567890.1, -1234567890.1, -1234567890.1, '-1234567890.1', '-1234567890.1'),
(-1234567890, -1234567890.8, -1234567890.8, -1234567890.8, '-1234567890.8', '-1234567890.8'),
(-1.234567890e10, -1.2345678901e10, -1.2345678901e10, -1.2345678901e10, '-1.2345678901e10', '-1.2345678901e10'),
(-1234567890, -1234567890123456.78, -1.2345678901e20, -1.2345678901e208, '-12345678901234567890', '-12345678901234567890'),
(-1234567890, -1234567890987654.32, -1.2345678901e38, -1.2345678901e308, '-12345678901234567890123456789012345678901234567890', '-1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
select c1, ceil(c1), ceiling(c1), floor(c1), truncate(c1, 2) from bug3483;
c1	ceil(c1)	ceiling(c1)	floor(c1)	truncate(c1, 2)
1	1	1	1	1
1234567890	1234567890	1234567890	1234567890	1234567890
1234567890	1234567890	1234567890	1234567890	1234567890
12345678900	12345678900	12345678900	12345678900	12345678900
1234567890	1234567890	1234567890	1234567890	1234567890
1234567890	1234567890	1234567890	1234567890	1234567890
-1	-1	-1	-1	-1
-1234567890	-1234567890	-1234567890	-1234567890	-1234567890
-1234567890	-1234567890	-1234567890	-1234567890	-1234567890
-12345678900	-12345678900	-12345678900	-12345678900	-12345678900
-1234567890	-1234567890	-1234567890	-1234567890	-1234567890
-1234567890	-1234567890	-1234567890	-1234567890	-1234567890
select c2, ceil(c2), ceiling(c2), floor(c2), truncate(c2, 2) from bug3483;
c2	ceil(c2)	ceiling(c2)	floor(c2)	truncate(c2, 2)
1.10	2	2	1	1.10
1234567890.10	1234567891	1234567891	1234567890	1234567890.10
1234567890.80	1234567891	1234567891	1234567890	1234567890.80
12345678901.00	12345678901	12345678901	12345678901	12345678901.00
1234567890123456.78	1234567890123457	1234567890123457	1234567890123456	1234567890123456.78
1234567890987654.32	1234567890987655	1234567890987655	1234567890987654	1234567890987654.32
-1.10	-1	-1	-2	-1.10
-1234567890.10	-1234567890	-1234567890	-1234567891	-1234567890.10
-1234567890.80	-1234567890	-1234567890	-1234567891	-1234567890.80
-12345678901.00	-12345678901	-12345678901	-12345678901	-12345678901.00
-1234567890123456.78	-1234567890123456	-1234567890123456	-1234567890123457	-1234567890123456.78
-1234567890987654.32	-1234567890987654	-1234567890987654	-1234567890987655	-1234567890987654.32
select c4, ceil(c4), ceiling(c4), floor(c4) from bug3483;
c4	ceil(c4)	ceiling(c4)	floor(c4)
1.1	2	2	1
1234567890.1	1234567891	1234567891	1234567890
1234567890.8	1234567891	1234567891	1234567890
12345678901	12345678901	12345678901	12345678901
1.2345678901e208	12345678901000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	12345678901000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	12345678901000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
1.2345678901e308	123456789010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	123456789010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	123456789010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
-1.1	-1	-1	-2
-1234567890.1	-1234567890	-1234567890	-1234567891
-1234567890.8	-1234567890	-1234567890	-1234567891
-12345678901	-12345678901	-12345678901	-12345678901
-1.2345678901e208	-12345678901000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	-12345678901000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	-12345678901000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
-1.2345678901e308	-123456789010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	-123456789010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	-123456789010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
select c5, ceil(c5), ceiling(c5), floor(c5), truncate(c5, 2) from bug3483;
c5	ceil(c5)	ceiling(c5)	floor(c5)	truncate(c5, 2)
1.1	2	2	1	1.10
1234567890.1	1234567891	1234567891	1234567890	1234567890.09
1234567890.8	1234567891	1234567891	1234567890	1234567890.80
1.2345678901e10	12345678901	12345678901	12345678901	12345678901.00
12345678901234567890	12345678901234567000	12345678901234567000	12345678901234567000	12345678901234567000.00
12345678901234567890123456789012345678901234567890	12345678901234567000000000000000000000000000000000	12345678901234567000000000000000000000000000000000	12345678901234567000000000000000000000000000000000	12345678901234567000000000000000000000000000000000.00
-1.1	-1	-1	-2	-1.10
-1234567890.1	-1234567890	-1234567890	-1234567891	-1234567890.09
-1234567890.8	-1234567890	-1234567890	-1234567891	-1234567890.80
-1.2345678901e10	-12345678901	-12345678901	-12345678901	-12345678901.00
-12345678901234567890	-12345678901234567000	-12345678901234567000	-12345678901234567000	-12345678901234567000.00
-12345678901234567890123456789012345678901234567890	-12345678901234567000000000000000000000000000000000	-12345678901234567000000000000000000000000000000000	-12345678901234567000000000000000000000000000000000	-12345678901234567000000000000000000000000000000000.00
select c6, ceil(c6), ceiling(c6), floor(c6), truncate(c6, 2) from bug3483;
c6	ceil(c6)	ceiling(c6)	floor(c6)	truncate(c6, 2)
1.1	2	2	1	1.10
1234567890.1	1234567891	1234567891	1234567890	1234567890.09
1234567890.8	1234567891	1234567891	1234567890	1234567890.80
1.2345678901e10	12345678901	12345678901	12345678901	12345678901.00
12345678901234567890	12345678901234567000	12345678901234567000	12345678901234567000	12345678901234567000.00
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890	1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000	1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000	1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000	1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000.00
-1.1	-1	-1	-2	-1.10
-1234567890.1	-1234567890	-1234567890	-1234567891	-1234567890.09
-1234567890.8	-1234567890	-1234567890	-1234567891	-1234567890.80
-1.2345678901e10	-12345678901	-12345678901	-12345678901	-12345678901.00
-12345678901234567890	-12345678901234567000	-12345678901234567000	-12345678901234567000	-12345678901234567000.00
-1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890	-1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000	-1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000	-1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000	-1234567890123456700000000000000000000000000000000000000000000000000000000000000000000000000000000000.00
drop table bug3483;