Changeset: 7baf0b2f99cc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7baf0b2f99cc
Modified Files:
sql/test/analytics/Tests/analytics01.sql
sql/test/analytics/Tests/analytics01.stable.out
Branch: Nov2019
Log Message:
Approved output
diffs (82 lines):
diff --git a/sql/test/analytics/Tests/analytics01.sql
b/sql/test/analytics/Tests/analytics01.sql
--- a/sql/test/analytics/Tests/analytics01.sql
+++ b/sql/test/analytics/Tests/analytics01.sql
@@ -241,6 +241,31 @@ LAST_VALUE(t0.points) OVER (PARTITION BY
FROM test1 t0
WHERE (t0.start_time >= '2017/12/01 00:00:00' AND t0.start_time <= '2017/12/02
00:00:00');
+CREATE TABLE "sys"."test2" (
+ "name" VARCHAR(100),
+ "points" INT,
+ "start_time" TIMESTAMP
+);
+
+COPY 8 RECORDS INTO "sys"."test2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+"Ashish" 20 "2017-12-01 00:00:00.000000"
+"Ashish" 40 "2017-12-01 01:00:00.000000"
+"Ashish" 60 "2017-12-01 00:00:00.000000"
+"Prashant" 10 "2017-12-01 00:00:00.000000"
+"Prashant" 50 "2017-12-01 01:00:00.000000"
+"Prashant" 90 "2017-12-01 00:00:00.000000"
+"Prashant" 11 "2017-12-02 01:02:00.000000"
+"Prashant" 15 "2017-12-02 02:02:00.000000"
+
+SELECT distinct "name" ,
+first_value("points") over (partition by cast("start_time" as date) order by
cast("start_time" as date))
+FROM test2
+order by "name";
+
+SELECT distinct "name" ,
+first_value("points") over (partition by cast("start_time" as date), "name"
order by cast("start_time" as date))
+FROM test2
+order by "name";
rollback;
diff --git a/sql/test/analytics/Tests/analytics01.stable.out
b/sql/test/analytics/Tests/analytics01.stable.out
--- a/sql/test/analytics/Tests/analytics01.stable.out
+++ b/sql/test/analytics/Tests/analytics01.stable.out
@@ -2591,6 +2591,43 @@ stdout of test 'analytics01` in director
% 10, 24, 24 # length
[ 2017-12-01, 20, 90 ]
[ 2017-12-01, 20, 50 ]
+#CREATE TABLE "sys"."test2" (
+# "name" VARCHAR(100),
+# "points" INT,
+# "start_time" TIMESTAMP
+#);
+#COPY 8 RECORDS INTO "sys"."test2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#"Ashish" 20 "2017-12-01 00:00:00.000000"
+#"Ashish" 40 "2017-12-01 01:00:00.000000"
+#"Ashish" 60 "2017-12-01 00:00:00.000000"
+#"Prashant" 10 "2017-12-01 00:00:00.000000"
+#"Prashant" 50 "2017-12-01 01:00:00.000000"
+#"Prashant" 90 "2017-12-01 00:00:00.000000"
+#"Prashant" 11 "2017-12-02 01:02:00.000000"
+#"Prashant" 15 "2017-12-02 02:02:00.000000"
+[ 8 ]
+#SELECT distinct "name" ,
+#first_value("points") over (partition by cast("start_time" as date) order by
cast("start_time" as date))
+#FROM test2
+#order by "name";
+% sys.test2, sys.L4 # table_name
+% name, L4 # name
+% varchar, int # type
+% 8, 2 # length
+[ "Ashish", 20 ]
+[ "Prashant", 20 ]
+[ "Prashant", 11 ]
+#SELECT distinct "name" ,
+#first_value("points") over (partition by cast("start_time" as date), "name"
order by cast("start_time" as date))
+#FROM test2
+#order by "name";
+% sys.test2, sys.L4 # table_name
+% name, L4 # name
+% varchar, int # type
+% 8, 2 # length
+[ "Ashish", 20 ]
+[ "Prashant", 10 ]
+[ "Prashant", 11 ]
#rollback;
#drop table analytics;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
