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

regr_sxy() returns different results across different runs of the same query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 22.08.2
    • PrimProc
    • None

    Description

      Here is a sample query to demonstrate different values returned by regr_sxy across multiple runs:

      select avg(l_extendedprice), l_discount, l_tax, regr_sxy(3, round(l_discount * l_extendedprice * (1.0+l_tax), 2)) discount from lineitem group by l_discount, l_tax order by l_discount, l_tax;

      Attachments

        Issue Links

          is part of

          Sub-Task - The sub-task of the issue MCOL-3631 regr_ tests returns doubles with higher precision in 1.4 then in 1.2

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

          Task - A task that needs to be done. MCOL-5188 regr funtions have numeric error when numers are very small

          • Major - Major loss of function.
          • Closed

          Activity

            People

              David.Hall David Hall (Inactive)
              tntnatbry Gagan Goel (Inactive)
              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.