|
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)
|