database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-26 11:48:52 +03:00
Code
mariadb-columnstore-engine/mysql-test/columnstore/devregression/r/mcs7187_regression_bug5777.result
root 2ed151fa59 Recorded reference results
2022-12-09 02:24:40 +00:00

112 lines
5.5 KiB
Plaintext
Raw Permalink Blame History

USE tpch1;
DROP TABLE IF EXISTS query_class_metrics_float;
CREATE TABLE `query_class_metrics_float` (
`agent_id` bigint(20) DEFAULT NULL,
`start_ts` datetime DEFAULT NULL,
`query_class` int(11) DEFAULT NULL,
`query_time_sum` float DEFAULT NULL)
ENGINE=Columnstore;
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 22:55:00', 1563, 0.281992);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:00:00', 1563, 0.292305);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:05:00', 1563, 0.215658);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:10:00', 1563, 0.243597);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:15:00', 1563, 0.35189);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:20:00', 1563, 0.543079);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:25:00', 1563, 0.495779);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:30:00', 1563, 0.589326);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:35:00', 1563, 0.210907);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:40:00', 1563, 0.167944);
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:45:00', 1563, 0.202401);
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
SELECT start_ts, Query_time_sum,LEAD(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 0.292305
2013-06-18 23:00:00 0.292305 0.215658
2013-06-18 23:05:00 0.215658 0.243597
2013-06-18 23:10:00 0.243597 0.35189
2013-06-18 23:15:00 0.35189 0.543079
2013-06-18 23:20:00 0.543079 0.495779
2013-06-18 23:25:00 0.495779 0.589326
2013-06-18 23:30:00 0.589326 0.210907
2013-06-18 23:35:00 0.210907 0.167944
2013-06-18 23:40:00 0.167944 0.202401
2013-06-18 23:45:00 0.202401 NULL
SELECT start_ts, Query_time_sum,MAX(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 0.281992
2013-06-18 23:00:00 0.292305 0.292305
2013-06-18 23:05:00 0.215658 0.292305
2013-06-18 23:10:00 0.243597 0.292305
2013-06-18 23:15:00 0.35189 0.35189
2013-06-18 23:20:00 0.543079 0.543079
2013-06-18 23:25:00 0.495779 0.543079
2013-06-18 23:30:00 0.589326 0.589326
2013-06-18 23:35:00 0.210907 0.589326
2013-06-18 23:40:00 0.167944 0.589326
2013-06-18 23:45:00 0.202401 0.589326
SELECT start_ts, Query_time_sum,MIN(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 0.281992
2013-06-18 23:00:00 0.292305 0.281992
2013-06-18 23:05:00 0.215658 0.215658
2013-06-18 23:10:00 0.243597 0.215658
2013-06-18 23:15:00 0.35189 0.215658
2013-06-18 23:20:00 0.543079 0.215658
2013-06-18 23:25:00 0.495779 0.215658
2013-06-18 23:30:00 0.589326 0.215658
2013-06-18 23:35:00 0.210907 0.210907
2013-06-18 23:40:00 0.167944 0.167944
2013-06-18 23:45:00 0.202401 0.167944
SELECT start_ts, Query_time_sum,FIRST_VALUE(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 0.281992
2013-06-18 23:00:00 0.292305 0.281992
2013-06-18 23:05:00 0.215658 0.281992
2013-06-18 23:10:00 0.243597 0.281992
2013-06-18 23:15:00 0.35189 0.281992
2013-06-18 23:20:00 0.543079 0.281992
2013-06-18 23:25:00 0.495779 0.281992
2013-06-18 23:30:00 0.589326 0.281992
2013-06-18 23:35:00 0.210907 0.281992
2013-06-18 23:40:00 0.167944 0.281992
2013-06-18 23:45:00 0.202401 0.281992
SELECT start_ts, Query_time_sum,LAST_VALUE(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 0.281992
2013-06-18 23:00:00 0.292305 0.292305
2013-06-18 23:05:00 0.215658 0.215658
2013-06-18 23:10:00 0.243597 0.243597
2013-06-18 23:15:00 0.35189 0.35189
2013-06-18 23:20:00 0.543079 0.543079
2013-06-18 23:25:00 0.495779 0.495779
2013-06-18 23:30:00 0.589326 0.589326
2013-06-18 23:35:00 0.210907 0.210907
2013-06-18 23:40:00 0.167944 0.167944
2013-06-18 23:45:00 0.202401 0.202401
SELECT start_ts, Query_time_sum,NTH_VALUE(Query_time_sum, 3) 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 NULL
2013-06-18 23:05:00 0.215658 0.215658
2013-06-18 23:10:00 0.243597 0.215658
2013-06-18 23:15:00 0.35189 0.215658
2013-06-18 23:20:00 0.543079 0.215658
2013-06-18 23:25:00 0.495779 0.215658
2013-06-18 23:30:00 0.589326 0.215658
2013-06-18 23:35:00 0.210907 0.215658
2013-06-18 23:40:00 0.167944 0.215658
2013-06-18 23:45:00 0.202401 0.215658
DROP TABLE query_class_metrics_float;
View Git Blame Copy Permalink