mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +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>
36 lines
2.7 KiB
Plaintext
36 lines
2.7 KiB
Plaintext
USE tpch1;
|
|
set columnstore_double_for_decimal_math = 1;
|
|
drop table if exists `p2_loaded_uh_p_xml_fsc_2x_for_agg_201310_valid_sess`;
|
|
create table `p2_loaded_uh_p_xml_fsc_2x_for_agg_201310_valid_sess` ( `session_duration` decimal(13,3) not null,`session_idle_down_duration` decimal(13,3) not null, `session_q5_down` int(11) not null ) engine=columnstore default charset=latin1;
|
|
insert into p2_loaded_uh_p_xml_fsc_2x_for_agg_201310_valid_sess values (1032632.1 , 86382, 1273564557);
|
|
select session_duration as session_duration, session_idle_down_duration as session_idle_down_duration, session_q5_down as session_q5_down, truncate(session_duration*session_q5_down, 2) as result_1, truncate((session_duration*session_q5_down)*8, 2) as result_2, (1032632.1*1273564557)*8 as result_3 from p2_loaded_uh_p_xml_fsc_2x_for_agg_201310_valid_sess t1;
|
|
session_duration session_idle_down_duration session_q5_down result_1 result_2 result_3
|
|
1032632.100 86382.000 1273564557 1315123642980479.70 10520989143843837.60 10520989143843837.6
|
|
drop table if exists bug2437;
|
|
create table bug2437 (col1 decimal(6,4)) engine=columnstore;
|
|
insert into bug2437 values (10.0001);
|
|
select truncate(col1*2.0002*2.0000002*0.999999999999, 9) from bug2437;
|
|
truncate(col1*2.0002*2.0000002*0.999999999999, 9)
|
|
40.004404040
|
|
select truncate(col1*4.00040040003599959959996, 9) from bug2437;
|
|
truncate(col1*4.00040040003599959959996, 9)
|
|
40.004404040
|
|
select (count(*)/72143371)*100,(6001215/72143371)*100,(count(*)*100)/72143371,(6001215*100)/72143371 from lineitem;
|
|
(count(*)/72143371)*100 (6001215/72143371)*100 (count(*)*100)/72143371 (6001215*100)/72143371
|
|
8.3185 8.3185 8.3185 8.3185
|
|
set columnstore_double_for_decimal_math = 0;
|
|
select session_duration as session_duration, session_idle_down_duration as session_idle_down_duration, session_q5_down as session_q5_down, session_duration*session_q5_down as result_1, (session_duration*session_q5_down)*8 as result_2, (1032632.1*1273564557)*8 as result_3 from p2_loaded_uh_p_xml_fsc_2x_for_agg_201310_valid_sess t1;
|
|
session_duration session_idle_down_duration session_q5_down result_1 result_2 result_3
|
|
1032632.100 86382.000 1273564557 1315123642980479.700 10520989143843837.600 10520989143843837.6
|
|
select col1*2.0002*2.0000002*0.999999999999 from bug2437;
|
|
col1*2.0002*2.0000002*0.999999999999
|
|
40.004404040399999595959559996
|
|
select col1*4.00040040003599959959996 from bug2437;
|
|
col1*4.00040040003599959959996
|
|
40.004404040399999595959559996
|
|
select (count(*)/72143371)*100,(6001215/72143371)*100,(count(*)*100)/72143371,(6001215*100)/72143371 from lineitem;
|
|
(count(*)/72143371)*100 (6001215/72143371)*100 (count(*)*100)/72143371 (6001215*100)/72143371
|
|
8.3200 8.3185 8.3185 8.3185
|
|
drop table `p2_loaded_uh_p_xml_fsc_2x_for_agg_201310_valid_sess`;
|
|
drop table bug2437;
|