Changeset: 3decb4cc9b8d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3decb4cc9b8d Modified Files: sql/test/BugTracker-2021/Tests/plan-not-optimal-view.Bug-7140.test Branch: balanced_union Log Message:
Fixes test expected values (aliases) diffs (26 lines): diff --git a/sql/test/BugTracker-2021/Tests/plan-not-optimal-view.Bug-7140.test b/sql/test/BugTracker-2021/Tests/plan-not-optimal-view.Bug-7140.test --- a/sql/test/BugTracker-2021/Tests/plan-not-optimal-view.Bug-7140.test +++ b/sql/test/BugTracker-2021/Tests/plan-not-optimal-view.Bug-7140.test @@ -65,17 +65,17 @@ project ( | | | | | | | table("sys"."plantest0") [ "plantest0"."id" ] | | | | | | ) [ ("plantest0"."id") >= (bigint(64) "150000000") ] | | | | | ) [ "sys"."sql_div"("plantest0"."id" NOT NULL, int(24) "10000000") NOT NULL as "t"."id_r" ] -| | | | ) [ "t"."id_r" NOT NULL ] [ "t"."id_r" NOT NULL, "sys"."count" no nil ("t"."id_r" NOT NULL) NOT NULL as "%6"."%6" ], +| | | | ) [ "t"."id_r" NOT NULL ] [ "t"."id_r" NOT NULL, "sys"."count" no nil ("t"."id_r" NOT NULL) NOT NULL as "%5"."%5" ], | | | | group by ( | | | | | project ( | | | | | | select ( | | | | | | | table("sys"."plantest1") [ "plantest1"."id" ] | | | | | | ) [ ("plantest1"."id") >= (bigint(64) "150000000") ] | | | | | ) [ "sys"."sql_div"("plantest1"."id" NOT NULL, int(24) "10000000") NOT NULL as "t"."id_r" ] -| | | | ) [ "t"."id_r" NOT NULL ] [ "t"."id_r" NOT NULL, "sys"."count" no nil ("t"."id_r" NOT NULL) NOT NULL as "%6"."%6" ] -| | | ) [ "t"."id_r" NOT NULL, "%6"."%6" NOT NULL ] -| | ) [ "t"."id_r" NOT NULL ] [ "t"."id_r" NOT NULL, "sys"."sum" no nil ("%6"."%6" NOT NULL) NOT NULL as "%6"."%6" ] -| ) [ "sys"."sql_mul"("t"."id_r" NOT NULL UNIQUE, int(24) "10000000") NOT NULL as "id_range_base", "%6"."%6" NOT NULL as "nrows", "t"."id_r" NOT NULL UNIQUE ] +| | | | ) [ "t"."id_r" NOT NULL ] [ "t"."id_r" NOT NULL, "sys"."count" no nil ("t"."id_r" NOT NULL) NOT NULL as "%5"."%5" ] +| | | ) [ "t"."id_r" NOT NULL, "%5"."%5" NOT NULL ] +| | ) [ "t"."id_r" NOT NULL ] [ "t"."id_r" NOT NULL, "sys"."sum" no nil ("%5"."%5" NOT NULL) NOT NULL as "%5"."%5" ] +| ) [ "sys"."sql_mul"("t"."id_r" NOT NULL UNIQUE, int(24) "10000000") NOT NULL as "id_range_base", "%5"."%5" NOT NULL as "nrows", "t"."id_r" NOT NULL UNIQUE ] ) [ "id_range_base" NOT NULL, "nrows" NOT NULL ] [ "t"."id_r" ASC NOT NULL UNIQUE ] query II rowsort _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org