Changeset: 9f0980f1fd15 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9f0980f1fd15
Added Files:
sql/test/rel-optimizers/Tests/local-replica.reqtests
sql/test/rel-optimizers/Tests/local-replica.test
Modified Files:
sql/test/rel-optimizers/Tests/All
Branch: default
Log Message:
Adds new tests with only local replica tables
diffs (61 lines):
diff --git a/sql/test/rel-optimizers/Tests/All
b/sql/test/rel-optimizers/Tests/All
--- a/sql/test/rel-optimizers/Tests/All
+++ b/sql/test/rel-optimizers/Tests/All
@@ -4,3 +4,4 @@ groupjoin
join-merge-remote-replica
replicas-base
replicas-join
+local-replica
diff --git a/sql/test/rel-optimizers/Tests/local-replica.reqtests
b/sql/test/rel-optimizers/Tests/local-replica.reqtests
new file mode 100644
--- /dev/null
+++ b/sql/test/rel-optimizers/Tests/local-replica.reqtests
@@ -0,0 +1,1 @@
+replicas-base
diff --git a/sql/test/rel-optimizers/Tests/local-replica.test
b/sql/test/rel-optimizers/Tests/local-replica.test
new file mode 100644
--- /dev/null
+++ b/sql/test/rel-optimizers/Tests/local-replica.test
@@ -0,0 +1,42 @@
+
+statement ok
+create replica table foo_rpl_loc (n int, m text)
+
+statement ok
+alter table foo_rpl_loc add table foo_local
+
+statement ok
+create replica table bar_rpl_loc (n int, m text)
+
+statement ok
+alter table bar_rpl_loc add table bar_local
+
+query T nosort
+plan select * from foo_rpl_loc
+----
+project (
+| table("sys"."foo_local") [ "foo_local"."n" as "foo_rpl_loc"."n",
"foo_local"."m" as "foo_rpl_loc"."m", "foo_local"."%TID%" NOT NULL UNIQUE as
"foo_rpl_loc"."%TID%" ]
+) [ "foo_rpl_loc"."n", "foo_rpl_loc"."m" ]
+
+query T nosort
+plan select * from foo_rpl_loc, bar_rpl_loc
+----
+project (
+| crossproduct (
+| | table("sys"."foo_local") [ "foo_local"."n" UNIQUE as "foo_rpl_loc"."n",
"foo_local"."m" as "foo_rpl_loc"."m", "foo_local"."%TID%" NOT NULL UNIQUE as
"foo_rpl_loc"."%TID%" ],
+| | table("sys"."bar_local") [ "bar_local"."n" as "bar_rpl_loc"."n",
"bar_local"."m" as "bar_rpl_loc"."m", "bar_local"."%TID%" NOT NULL UNIQUE as
"bar_rpl_loc"."%TID%" ]
+| ) [ ]
+) [ "foo_rpl_loc"."n", "foo_rpl_loc"."m", "bar_rpl_loc"."n", "bar_rpl_loc"."m"
]
+
+query T nosort
+plan select * from foo_rpl_loc, buz_rmt
+----
+project (
+| crossproduct (
+| | table("sys"."foo_local") [ "foo_local"."n" UNIQUE as "foo_rpl_loc"."n",
"foo_local"."m" as "foo_rpl_loc"."m", "foo_local"."%TID%" NOT NULL UNIQUE as
"foo_rpl_loc"."%TID%" ],
+| | table (
+| | | REMOTE("sys"."buz_rmt") [ "buz_rmt"."l" ] REMOTE
mapi:monetdb://localhost:50002/node2
+| | ) [ "buz_rmt"."l" ]
+| ) [ ]
+) [ "foo_rpl_loc"."n", "foo_rpl_loc"."m", "buz_rmt"."l" ]
+
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
