Changeset: c574220deeb8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c574220deeb8
Modified Files:
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.test
Branch: resource_management
Log Message:
approved test output
diffs (44 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
---
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
+++
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
@@ -45,10 +45,10 @@ project (
| | | | | | | | | | | | select (
| | | | | | | | | | | | | table("sys"."myfunctions") [ "myfunctions"."id" NOT
NULL UNIQUE as "f"."id", "myfunctions"."schema_id" NOT NULL UNIQUE as
"f"."schema_id", "myfunctions"."system" NOT NULL UNIQUE as "f"."system" ]
| | | | | | | | | | | | ) [ ("f"."system" NOT NULL UNIQUE) = (boolean(1)
"true") ],
-| | | | | | | | | | | | table("sys"."schemas") [ "schemas"."id" NOT NULL
UNIQUE as "s"."id" ]
-| | | | | | | | | | | ) [ ("f"."schema_id" NOT NULL UNIQUE) = ("s"."id" NOT
NULL UNIQUE) ],
-| | | | | | | | | | | table("sys"."comments") [ "comments"."id" NOT NULL
UNIQUE HASHCOL as "c"."id" ]
-| | | | | | | | | | ) [ ("f"."id" NOT NULL UNIQUE) = ("c"."id" NOT NULL UNIQUE
HASHCOL ) ],
+| | | | | | | | | | | | table("sys"."comments") [ "comments"."id" NOT NULL
UNIQUE HASHCOL as "c"."id" ]
+| | | | | | | | | | | ) [ ("f"."id" NOT NULL UNIQUE) = ("c"."id" NOT NULL
UNIQUE HASHCOL ) ],
+| | | | | | | | | | | table("sys"."schemas") [ "schemas"."id" NOT NULL UNIQUE
as "s"."id" ]
+| | | | | | | | | | ) [ ("f"."schema_id" NOT NULL UNIQUE) = ("s"."id" NOT NULL
UNIQUE) ],
| | | | | | | | | | select (
| | | | | | | | | | | table("sys"."args") [ "args"."func_id" NOT NULL as
"p"."func_id", "args"."inout" NOT NULL as "p"."inout", "args"."number" NOT NULL
as "p"."number" ]
| | | | | | | | | | ) [ ("p"."inout" NOT NULL) = (tinyint(1) "1") ]
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.test
@@ -35,7 +35,7 @@ plan select id from pk2 join (pk1 join f
project (
| select (
| | table("sys"."fk") [ "fk"."id" NOT NULL UNIQUE HASHCOL ,
"fk"."%fk_fk1_fkey" JOINIDX "sys"."fk"."fk_fk1_fkey", "fk"."%fk_fk2_fkey"
JOINIDX "sys"."fk"."fk_fk2_fkey" ]
-| ) [ ("fk"."%fk_fk2_fkey") ! * = (oid(63) NULL), ("fk"."%fk_fk1_fkey") ! * =
(oid(63) NULL) ]
+| ) [ ("fk"."%fk_fk1_fkey") ! * = (oid(63) NULL), ("fk"."%fk_fk2_fkey") ! * =
(oid(63) NULL) ]
) [ "fk"."id" NOT NULL UNIQUE HASHCOL ] [ "fk"."id" ASC NOT NULL UNIQUE
HASHCOL ]
query T python .plan.filter
@@ -56,10 +56,9 @@ plan select id, v2 from pk2 join (pk1 jo
----
project (
| join (
-| | semijoin (
-| | | table("sys"."fk") [ "fk"."id" NOT NULL UNIQUE HASHCOL ,
"fk"."%fk_fk1_fkey" JOINIDX "sys"."fk"."fk_fk1_fkey", "fk"."%fk_fk2_fkey"
JOINIDX "sys"."fk"."fk_fk2_fkey" ],
-| | | table("sys"."pk1") [ "pk1"."%TID%" NOT NULL UNIQUE ]
-| | ) [ ("fk"."%fk_fk1_fkey") = ("pk1"."%TID%" NOT NULL UNIQUE) JOINIDX
"sys"."fk"."fk_fk1_fkey" ],
+| | select (
+| | | table("sys"."fk") [ "fk"."id" NOT NULL UNIQUE HASHCOL ,
"fk"."%fk_fk1_fkey" JOINIDX "sys"."fk"."fk_fk1_fkey", "fk"."%fk_fk2_fkey"
JOINIDX "sys"."fk"."fk_fk2_fkey" ]
+| | ) [ ("fk"."%fk_fk1_fkey") ! * = (oid(63) NULL) ],
| | table("sys"."pk2") [ "pk2"."v2" NOT NULL UNIQUE, "pk2"."%TID%" NOT NULL
UNIQUE ]
| ) [ ("fk"."%fk_fk2_fkey") = ("pk2"."%TID%" NOT NULL UNIQUE) JOINIDX
"sys"."fk"."fk_fk2_fkey" ]
) [ "fk"."id" NOT NULL HASHCOL , "pk2"."v2" NOT NULL ] [ "fk"."id" ASC NOT
NULL HASHCOL ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
