MonetDB: statistics-analytics - Approved output

[Pedro Ferreira]

Changeset: 82b1fbdf0191 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=82b1fbdf0191
Modified Files:
        sql/test/analytics/Tests/analytics14.sql
        sql/test/analytics/Tests/analytics14.stable.out
Branch: statistics-analytics
Log Message:

Approved output


diffs (truncated from 326 to 300 lines):

diff --git a/sql/test/analytics/Tests/analytics14.sql 
b/sql/test/analytics/Tests/analytics14.sql
--- a/sql/test/analytics/Tests/analytics14.sql
+++ b/sql/test/analytics/Tests/analytics14.sql
@@ -68,12 +68,35 @@ select median_avg(cc) over (partition by
 select median_avg(cc) over (order by bb desc) from analytics;
 
 
+select quantile(aa, 0.2) over (partition by bb) from analytics;
+select quantile(aa, 0.2) over (partition by bb order by bb asc) from analytics;
+select quantile(aa, 0.2) over (partition by bb order by bb desc) from 
analytics;
+select quantile(aa, 0.2) over (order by bb desc) from analytics;
+
+select quantile(cc, 0.7) over (partition by bb) from analytics;
+select quantile(cc, 0.7) over (partition by bb order by bb asc) from analytics;
+select quantile(cc, 0.7) over (partition by bb order by bb desc) from 
analytics;
+select quantile(cc, 0.7) over (order by bb desc) from analytics;
+
+
 select stddev_samp(aa) over () from analytics;
 select stddev_pop(aa) over () from analytics;
 select var_samp(aa) over () from analytics;
 select var_pop(aa) over () from analytics;
 select median(aa) over () from analytics;
 select median_avg(aa) over () from analytics;
+select quantile(aa, 0.8) over () from analytics;
+
+
+select stddev_samp(NULL) over () from analytics;
+select stddev_pop(NULL) over () from analytics;
+select var_samp(NULL) over () from analytics;
+select var_pop(NULL) over () from analytics;
+select median(NULL) over () from analytics;
+select median_avg(NULL) over () from analytics;
+select quantile(NULL, 0.8) over () from analytics;
+select quantile(aa, NULL) over () from analytics;
+select quantile(NULL, NULL) over () from analytics;
 
 rollback;
 
diff --git a/sql/test/analytics/Tests/analytics14.stable.out 
b/sql/test/analytics/Tests/analytics14.stable.out
--- a/sql/test/analytics/Tests/analytics14.stable.out
+++ b/sql/test/analytics/Tests/analytics14.stable.out
@@ -787,6 +787,126 @@ stdout of test 'analytics14` in director
 [ NULL ]
 [ NULL ]
 [ NULL ]
+#select quantile(aa, 0.2) over (partition by bb) from analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 2 # length
+[ 3    ]
+[ 3    ]
+[ 3    ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ NULL ]
+#select quantile(aa, 0.2) over (partition by bb order by bb asc) from 
analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 2 # length
+[ 3    ]
+[ 3    ]
+[ 3    ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ NULL ]
+#select quantile(aa, 0.2) over (partition by bb order by bb desc) from 
analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 2 # length
+[ NULL ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ 3    ]
+[ 3    ]
+[ 3    ]
+#select quantile(aa, 0.2) over (order by bb desc) from analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 2 # length
+[ NULL ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ 15   ]
+[ 5    ]
+[ 5    ]
+[ 5    ]
+#select quantile(cc, 0.7) over (partition by bb) from analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ 2    ]
+[ 2    ]
+[ 2    ]
+[ 3    ]
+[ 3    ]
+[ 3    ]
+[ 5    ]
+[ 5    ]
+[ 5    ]
+[ NULL ]
+#select quantile(cc, 0.7) over (partition by bb order by bb asc) from 
analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ 2    ]
+[ 2    ]
+[ 2    ]
+[ 3    ]
+[ 3    ]
+[ 3    ]
+[ 5    ]
+[ 5    ]
+[ 5    ]
+[ NULL ]
+#select quantile(cc, 0.7) over (partition by bb order by bb desc) from 
analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ NULL ]
+[ 5    ]
+[ 5    ]
+[ 5    ]
+[ 3    ]
+[ 3    ]
+[ 3    ]
+[ 2    ]
+[ 2    ]
+[ 2    ]
+#select quantile(cc, 0.7) over (order by bb desc) from analytics;
+% sys.%3 # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ NULL ]
+[ 5    ]
+[ 5    ]
+[ 5    ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ 8    ]
+[ 8    ]
+[ 8    ]
 #select stddev_samp(aa) over () from analytics;
 % sys. # table_name
 % %1 # name
@@ -877,6 +997,156 @@ stdout of test 'analytics14` in director
 [ NULL ]
 [ NULL ]
 [ NULL ]
+#select quantile(aa, 0.8) over () from analytics;
+% sys. # table_name
+% %1 # name
+% tinyint # type
+% 1 # length
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+[ 6    ]
+#select stddev_samp(NULL) over () from analytics;
+% . # table_name
+% %3 # name
+% double # type
+% 24 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select stddev_pop(NULL) over () from analytics;
+% . # table_name
+% %3 # name
+% double # type
+% 24 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select var_samp(NULL) over () from analytics;
+% . # table_name
+% %3 # name
+% double # type
+% 24 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select var_pop(NULL) over () from analytics;
+% . # table_name
+% %3 # name
+% double # type
+% 24 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select median(NULL) over () from analytics;
+% . # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select median_avg(NULL) over () from analytics;
+% . # table_name
+% %3 # name
+% double # type
+% 24 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select quantile(NULL, 0.8) over () from analytics;
+% . # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+#select quantile(aa, NULL) over () from analytics;
+% sys. # table_name
+% %3 # name
+% tinyint # type
+% 1 # length
+[ NULL ]
+[ NULL ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list