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

Replace long double with wide/narrow-decimal for avg() and sum() result type for all numerical datatypesdecimal result

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.1.1
    • 6.1.1
    • ExeMgr, PrimProc
    • None
    • 2021-5, 2021-6, 2021-8, 2021-9

    Description

      As of now MCS uses long double as an internal data for results of avg() and sum() for numerical data types columns except wide-decimal.
      This approach imposes a number of limitations, e.g. we can not safely join on the aggregates results being a float number. Presumably long double math operations are slower comparing to int128.
      This gets us to the point of replacing long double with wide-decimal as a result of avg() and sum() for all integer data types. This causes a wide consequences that covers lots of facilities of the code. The full list can be obtained by search for LONGDOUBLE in the repo.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.