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

Window functions have less significant digits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 1.2
    • Fix Version/s: Icebox
    • Component/s: ExeMgr
    • Labels:
      None
    • Sprint:
      2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21, 2019-01, 2019-02, 2019-03, 2019-04, 2019-05, 2019-06

      Description

      See queries/working_tpch1/windowFunctions/bug5777.sql

      For example:
      Columnstore 1.1

      MariaDB [tpch1]> SELECT start_ts, Query_time_sum,LAG(Query_time_sum) OVER(order by start_ts) prev_sum from query_class_metrics_float where agent_id=1 and query_class=1563 limit 50;
      ------------------------------------------------------

      start_ts Query_time_sum prev_sum

      ------------------------------------------------------

      2013-06-18 22:55:00 0.281992 NULL
      2013-06-18 23:00:00 0.292305 0.28199198842048645
      2013-06-18 23:05:00 0.215658 0.29230499267578125
      2013-06-18 23:10:00 0.243597 0.21565799415111542
      2013-06-18 23:15:00 0.35189 0.24359700083732605
      2013-06-18 23:20:00 0.543079 0.3518899977207184
      2013-06-18 23:25:00 0.495779 0.5430790185928345
      2013-06-18 23:30:00 0.589326 0.49577900767326355
      2013-06-18 23:35:00 0.210907 0.589326024055481
      2013-06-18 23:40:00 0.167944 0.2109069973230362
      2013-06-18 23:45:00 0.202401 0.16794399917125702

      ------------------------------------------------------
      11 rows in set (0.174 sec)

      Columnstore 1.2
      MariaDB [tpch1]> SELECT start_ts, Query_time_sum,LAG(Query_time_sum) OVER(order by start_ts) prev_sum from query_class_metrics_float where agent_id=1 and query_class=1563 limit 50;
      -------------------------------------------

      start_ts Query_time_sum prev_sum

      -------------------------------------------

      2013-06-18 22:55:00 0.281992 NULL
      2013-06-18 23:00:00 0.292305 0.281992
      2013-06-18 23:05:00 0.215658 0.292305
      2013-06-18 23:10:00 0.243597 0.215658
      2013-06-18 23:15:00 0.35189 0.243597
      2013-06-18 23:20:00 0.543079 0.35189
      2013-06-18 23:25:00 0.495779 0.543079
      2013-06-18 23:30:00 0.589326 0.495779
      2013-06-18 23:35:00 0.210907 0.589326
      2013-06-18 23:40:00 0.167944 0.210907
      2013-06-18 23:45:00 0.202401 0.167944

      -------------------------------------------
      11 rows in set (0.22 sec)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              David.Hall David Hall
              Reporter:
              David.Hall David Hall
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.