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

          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.