Changeset: c3c3edecfaab for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c3c3edecfaab
Modified Files:
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
sql/test/analytics/Tests/analytics09.stable.err
sql/test/analytics/Tests/analytics09.stable.out
Branch: subquery
Log Message:
aproved output
diffs (58 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
@@ -115,14 +115,14 @@ project (
| | | | | | | | | | | | | ) [ "p"."inout" = tinyint "1" ]
| | | | | | | | | | | | ) [ "f"."id" = "p"."func_id" ]
| | | | | | | | | | | ) [ "f"."id", "p"."number" ]
-| | | | | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number"
ASC ]
+| | | | | | | | | | ) [ "f"."id", "p"."number" ASC ] [ "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", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
+| | | | | | ) [ "f"."id" ASC, "p"."number" ASC ] [ "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 "L43"."L43" ]
-| | | | ) [ "f"."id", "L43"."L43" ]
-| | | ) [ "f"."id" as "L6"."fid", "L43"."L43" as "L45"."line" ] [ "L45"."line"
ASC ]
+| | | | ) [ "f"."id" as "L6"."fid", "L43"."L43" as "L45"."line" ]
+| | | ) [ "L6"."fid", "L45"."line" ] [ "L45"."line" ASC ]
| | ) [ "L6"."fid" as "commented_function_signatures_6542"."fid" ]
| ) [ ] [ sys.count() NOT NULL as "L53"."L53" ]
) [ "L53"."L53" NOT NULL ]
diff --git a/sql/test/analytics/Tests/analytics09.stable.err
b/sql/test/analytics/Tests/analytics09.stable.err
--- a/sql/test/analytics/Tests/analytics09.stable.err
+++ b/sql/test/analytics/Tests/analytics09.stable.err
@@ -30,15 +30,15 @@ stderr of test 'analytics09` in director
MAPI = (monetdb) /var/tmp/mtest-17924/.s.monetdb.36475
QUERY = select cast(sum(aa) * 100 / sum(sum(aa)) over (partition by bb) as
bigint) from analytics; --error, nesting aggregation functions
-ERROR = !SELECT: identifier 'bb' unknown
+ERROR = !SELECT: cannot use non GROUP BY column 'L10' in query results without
an aggregate function
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-1389/.s.monetdb.37694
QUERY = select cast(prod(sum(aa)) * count(1 + aa) / avg(null) over () as
bigint) from analytics; --error, nesting aggregation functions
-ERROR = !SELECT: subquery result missing
+ERROR = !SELECT: identifier 'aa' unknown
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-17541/.s.monetdb.31437
QUERY = select rank() over (partition by sum(aa), bb) from analytics group by
aa; --error
-ERROR = !SELECT: identifier 'bb' unknown
+ERROR = !SELECT: cannot use non GROUP BY column 'L4' in query results without
an aggregate function
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-10156/.s.monetdb.31763
QUERY = select min(aa) over (partition by sum(bb)) from analytics; --error
diff --git a/sql/test/analytics/Tests/analytics09.stable.out
b/sql/test/analytics/Tests/analytics09.stable.out
--- a/sql/test/analytics/Tests/analytics09.stable.out
+++ b/sql/test/analytics/Tests/analytics09.stable.out
@@ -148,8 +148,8 @@ Ready.
# cast(sum(aa) * count(case when bb < 2 then bb - 1 else bb + 1 end) /
avg(1) over (rows between current row and current row) as bigint),
# avg(sum(aa)) over (rows unbounded preceding),
# avg(sum(aa)) over (range unbounded preceding) from analytics;
-% sys.L5, sys.L16, sys.L21, sys.L25 # table_name
-% L5, L16, L21, L25 # name
+% sys.L5, sys.L15, sys.L20, sys.L24 # table_name
+% L5, L15, L20, L24 # name
% double, bigint, double, double # type
% 24, 3, 24, 24 # length
[ 46, 460, 46, 46 ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
