You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
8671f55784
* Add MTR_SUITE_LIST * Typo * Add data download * Install tar and lz4 * Change the way MTR_SUITE_LIST is set up * Use bash for MTR_SUITE_LIST * Another one * Fix reference results for full MTR develop, disable broken JSON test and tests with 10GB database * Fix timestamps and truncate cos * Fix some more references * Fix dokcerhub step for custom build * One more fix for dockerhub step on custom build * Fix tests for regr functions with truncate * Full mtr set on nghtly + MTR_FULL_SET flag * One more fix for dockerhub * Fix MTR_FULL_SET * Testing MTR_FULL_SET * sorted_result in tests + fix typo * Truncate even more * Typo * truncate 2 more tests * Disable regr_* functions tests * fix setup mtr step * correct settings for table creation * Put setup for tests into drone * Fix for debian based distros * More truncates * Disable the rest --------- Co-authored-by: Leonid Fedorov <leonid.fedorov@mariadb.com>
88 lines
9.7 KiB
Plaintext
88 lines
9.7 KiB
Plaintext
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;
|