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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: CI tests
    • Labels:
      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

              Assignee:
              David.Hall David Hall
              Reporter:
              tntnatbry Gagan Goel
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.