Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.2
-
None
-
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
- is part of
-
MCOL-2161 Fix remaining errors in working_tpch1
-
- Closed
-