Changeset: bc08e1020c02 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bc08e1020c02
Modified Files:
        sql/test/analytics/Tests/analytics01.stable.out
        sql/test/analytics/Tests/analytics02.stable.out
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.32bit
        sql/test/emptydb/Tests/check.stable.out.int128
        sql/test/subquery/Tests/subquery4.stable.err
        sql/test/subquery/Tests/subquery6.stable.out
        sql/test/sys-schema/Tests/systemfunctions.stable.out
        sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: default
Log Message:

approved output


diffs (truncated from 1256 to 300 lines):

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
@@ -28,8 +28,8 @@ stdout of test 'analytics01` in director
 [ 10   ]
 #start transaction;
 #select percent_rank() over (partition by aa) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -43,8 +43,8 @@ stdout of test 'analytics01` in director
 [ 0    ]
 [ 0    ]
 #select percent_rank() over (partition by aa order by aa asc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -58,8 +58,8 @@ stdout of test 'analytics01` in director
 [ 0    ]
 [ 0    ]
 #select percent_rank() over (partition by aa order by aa desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -73,8 +73,8 @@ stdout of test 'analytics01` in director
 [ 0    ]
 [ 0    ]
 #select percent_rank() over (order by aa) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -88,8 +88,8 @@ stdout of test 'analytics01` in director
 [ 0.8888888889 ]
 [ 1    ]
 #select percent_rank() over (order by aa desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -103,8 +103,8 @@ stdout of test 'analytics01` in director
 [ 0.8888888889 ]
 [ 0.8888888889 ]
 #select percent_rank() over (partition by bb) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -118,8 +118,8 @@ stdout of test 'analytics01` in director
 [ 0    ]
 [ 0    ]
 #select percent_rank() over (partition by bb order by bb asc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -133,8 +133,8 @@ stdout of test 'analytics01` in director
 [ 0    ]
 [ 0    ]
 #select percent_rank() over (partition by bb order by bb desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -148,8 +148,8 @@ stdout of test 'analytics01` in director
 [ 0    ]
 [ 0    ]
 #select percent_rank() over (order by bb) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -163,8 +163,8 @@ stdout of test 'analytics01` in director
 [ 0.6666666667 ]
 [ 1    ]
 #select percent_rank() over (order by bb desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0    ]
@@ -178,8 +178,8 @@ stdout of test 'analytics01` in director
 [ 0.7777777778 ]
 [ 0.7777777778 ]
 #select cume_dist() over (partition by aa) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 1    ]
@@ -193,8 +193,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (partition by aa order by aa asc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 1    ]
@@ -208,8 +208,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (partition by aa order by aa desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 1    ]
@@ -223,8 +223,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (order by aa) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0.2  ]
@@ -238,8 +238,8 @@ stdout of test 'analytics01` in director
 [ 0.9  ]
 [ 1    ]
 #select cume_dist() over (order by aa desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0.1  ]
@@ -253,8 +253,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (partition by bb) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 1    ]
@@ -268,8 +268,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (partition by bb order by bb asc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 1    ]
@@ -283,8 +283,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (partition by bb order by bb desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 1    ]
@@ -298,8 +298,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select cume_dist() over (order by bb) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0.3  ]
@@ -313,8 +313,8 @@ stdout of test 'analytics01` in director
 [ 0.9  ]
 [ 1    ]
 #select cume_dist() over (order by bb desc) from analytics;
-% sys.%4 # table_name
-% %4 # name
+% sys.%3 # table_name
+% %3 # name
 % double # type
 % 24 # length
 [ 0.1  ]
@@ -328,8 +328,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select ntile(1) over (partition by aa) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
@@ -343,8 +343,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select ntile(1) over (partition by aa order by aa asc) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
@@ -358,8 +358,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select ntile(1) over (partition by aa order by aa desc) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
@@ -373,8 +373,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select ntile(1) over (order by aa) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
@@ -388,8 +388,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select ntile(1) over (order by aa desc) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
@@ -403,8 +403,8 @@ stdout of test 'analytics01` in director
 [ 1    ]
 [ 1    ]
 #select ntile(3) over (partition by bb) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
@@ -418,8 +418,8 @@ stdout of test 'analytics01` in director
 [ 3    ]
 [ 1    ]
 #select ntile(3) over (partition by bb order by bb asc) from analytics;
-% sys.%5 # table_name
-% %5 # name
+% sys.%4 # table_name
+% %4 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to