Changeset: 95c13b3dfd16 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/95c13b3dfd16 Added Files: sql/test/remote/Tests/create-remote-flavors.test Modified Files: sql/test/remote/Tests/All Branch: Dec2023 Log Message:
Adds tests for create remote table statements diffs (55 lines): diff --git a/sql/test/remote/Tests/All b/sql/test/remote/Tests/All --- a/sql/test/remote/Tests/All +++ b/sql/test/remote/Tests/All @@ -4,3 +4,4 @@ HAVE_DATA_PATH?invalid_creds HAVE_DATA_PATH?different_user THREADS>=2?partition_elim remote_info_missing +create-remote-flavors diff --git a/sql/test/remote/Tests/create-remote-flavors.test b/sql/test/remote/Tests/create-remote-flavors.test new file mode 100644 --- /dev/null +++ b/sql/test/remote/Tests/create-remote-flavors.test @@ -0,0 +1,42 @@ +statement ok +create table foo (n int, m text); + +statement ok +insert into foo values (1, 'alice'), (2, 'bob') + +statement ok +create table foo_empty (n int, m text); + +statement ok +create remote table rmt_1 (n int) on 'mapi:monetdb://localhost:50001/other' + +statement error 42000!CREATE TABLE: cannot create REMOTE TABLE 'with data' +create remote table rmt_2 as + select * from foo with data + on 'mapi:monetdb://localhost:50001/other' + +statement ok +create remote table rmt_2 as + select * from foo with no data + on 'mapi:monetdb://localhost:50001/other' + +statement ok +create remote table rmt_3 (n_rmt, l_rmt) as + select * from foo with no data + on 'mapi:monetdb://localhost:50001/other' + +statement error 42000!CREATE TABLE: cannot create REMOTE TABLE 'with data' +create remote table rmt_4 as + select * from foo_empty with data + on 'mapi:monetdb://localhost:50001/other' + +statement ok +create remote table rmt_4 as + select * from foo_empty with no data + on 'mapi:monetdb://localhost:50001/other' + +statement ok +create remote table rmt_5 (n_rmt, l_rmt) as + select * from foo_empty with no data + on 'mapi:monetdb://localhost:50001/other' + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
