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

Change the default to use double when overflow occurs in SUM() and AVG()

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2
    • 1.2.3
    • ExeMgr
    • None
    • 2018-20, 2018-21, 2019-01, 2019-02, 2019-03

    Description

      The SUM and AVG functions have logic to overflow from integer to double arithmetic when overflow occurs in int64. However, this logic is #defined out of the standard build.

      The default logic should be to overflow into double if necessary, rather than aborting the query.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-2233 SUBSTRING_INDEX() returns incorrect value when index value is negative

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MCOL-564 Aggregation overflow error

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MCOL-148 sum() and avg() return incorrect result for float when calculation overflows float range

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.