Changeset: cd98d2f1b008 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cd98d2f1b008
Modified Files:
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.stable.out
Branch: default
Log Message:
approved output
diffs (83 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
---
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
+++
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
@@ -114,11 +114,11 @@ project (
| | | | | | | | | | | | | ) [ "p"."inout" = tinyint "1" ]
| | | | | | | | | | | | ) [ "f"."id" = "p"."func_id" ]
| | | | | | | | | | | ) [ "f"."id", "p"."number" ]
-| | | | | | | | | | ) [ "f"."id", "p"."number" ASC ] [ "f"."id" ASC,
"p"."number" ASC ]
+| | | | | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number"
ASC ]
| | | | | | | | | ) [ "f"."id", "p"."number" ]
| | | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ]
| | | | | | | ) [ "f"."id", "p"."number" ]
-| | | | | | ) [ "f"."id" ASC, "p"."number" ASC ] [ "f"."id" ASC, "p"."number"
ASC ]
+| | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
| | | | | ) [ "f"."id", "p"."number", sys.row_number("f"."id", boolean
"false", sys.diff(sys.diff("f"."id" ASC), "p"."number" ASC)) as "L32"."L32" ]
| | | | ) [ "f"."id" as "L14"."fid", "L32"."L32" as "L34"."line" ]
| | | ) [ "L14"."fid", "L34"."line" ] [ "L34"."line" ASC ]
diff --git
a/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
b/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
---
a/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
+++
b/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
@@ -27,13 +27,13 @@ stdout of test 'sqlitelogictest-groupby-
#INSERT INTO tab1 VALUES(22,6,8), (28,57,45), (82,44,71);
[ 3 ]
#SELECT + - col2 FROM tab1 AS cor0 GROUP BY col0, col2 HAVING ( col2 / + 15 +
+ 88 ) IN ( AVG ( col2 ) );
-% sys.L2 # table_name
-% L2 # name
+% sys.L1 # table_name
+% L1 # name
% int # type
% 1 # length
#SELECT DISTINCT - NULLIF ( - 85, 24 ) * tab1.col1 FROM tab1 GROUP BY
tab1.col1;
-% sys.L2 # table_name
-% L2 # name
+% .L1 # table_name
+% L1 # name
% bigint # type
% 4 # length
[ 510 ]
diff --git
a/sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.stable.out
b/sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.stable.out
---
a/sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.stable.out
+++
b/sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.stable.out
@@ -20,11 +20,9 @@ stdout of test 'select_window_function_a
# MonetDB/Python2 module loaded
# MonetDB/R module loaded
-Ready.
-
-# 13:01:42 >
-# 13:01:42 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-13851" "--port=31714"
-# 13:01:42 >
+# 10:42:58 >
+# 10:42:58 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-27248" "--port=33326"
+# 10:42:58 >
#create table test_6722 (part string, qty double);
#insert into test_6722 values ('a', 18), ('a', 13),('a', 16),('b', 15),('b',
16),('c', 17),('c', 18),('c', 12),('d', 12),('d', 12);
@@ -35,7 +33,7 @@ Ready.
# *
#from test_6722
#order by part, qty;
-% sys.L5, sys.L12, sys.test_6722, sys.test_6722 # table_name
+% sys.L4, sys.L10, sys.test_6722, sys.test_6722 # table_name
% rank_id, row_id, part, qty # name
% int, int, clob, double # type
% 1, 2, 1, 24 # length
@@ -55,7 +53,7 @@ Ready.
# (row_number() over (order by part, qty)) as row_id
#from test_6722
#order by part, qty;
-% sys.L5, sys.test_6722, sys.test_6722, sys.L14 # table_name
+% sys.L4, sys.test_6722, sys.test_6722, sys.L11 # table_name
% rank_id, part, qty, row_id # name
% int, clob, double, int # type
% 1, 1, 24, 2 # length
@@ -75,7 +73,7 @@ Ready.
# (row_number() over (order by part, qty)) as row_id
#from test_6722
#order by part, qty;
-% sys.test_6722, sys.test_6722, sys.L10, sys.L15 # table_name
+% sys.test_6722, sys.test_6722, sys.L6, sys.L12 # table_name
% part, qty, rank_id, row_id # name
% clob, double, int, int # type
% 1, 24, 1, 2 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
