Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
6.1.1
Description
See working_tpch1_compareLogOnly/misc/bug571.sql
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, 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 | 0.0 |
|
result_3 should be 10520989143843837.6, not 0.0
This is a regression since 5.5
result_3 is a bunch of constants with math. In 5.5, because it's a constant, the math is done in the Server and the answer inserted somehow into the result. I assume this is still how it is supposed to work, but it doesn't anymore. I guess something to do with decimal(38) is confusing it.