Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4547

Regression: Constant decimal math not working

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            David.Hall David Hall (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.