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

sum(colname) is giving different values sometimes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • None
    • N/A
    • ExeMgr
    • None
    • CentOS

    Description

      I am trying to run a simple sum query as stated below but it is giving me different results sometimes. I googled this problem but wasn't able to find it so I am putting it here. Is this a common behaviour, if so then is there a way to avoid it since we are a financial institute and accuracy of metrics is key for us. After successive trails and putting the results in excel we noticed that the delta between any of the results is always multiple of 4 and 32.

      select sum(loanAmount), grade from loans group by grade;

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              smitthakkar96 Smit Thakkar
              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.