Changeset: 10828d5d7e85 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=10828d5d7e85 Modified Files: sql/test/subquery/Tests/subquery9.sql sql/test/subquery/Tests/subquery9.test Branch: mtest Log Message:
drop the tables at the end of the test diffs (36 lines): diff --git a/sql/test/subquery/Tests/subquery9.sql b/sql/test/subquery/Tests/subquery9.sql --- a/sql/test/subquery/Tests/subquery9.sql +++ b/sql/test/subquery/Tests/subquery9.sql @@ -108,3 +108,12 @@ SELECT bs.bid FROM branches_services AS SELECT bid, bdesc, bloc FROM branches WHERE bloc = (SELECT bloc FROM branches WHERE bid = 1101 AND cid = 110); SELECT table1.bid, table1.bdesc, table1.bloc FROM branches AS table1, branches AS table2 WHERE table2.bid = 1101 AND table2.cid = 110 AND table1.bloc = table2.bloc ; + + +DROP TABLE branches; + +DROP TABLE branches_services; + +DROP TABLE clients; + +DROP TABLE services; diff --git a/sql/test/subquery/Tests/subquery9.test b/sql/test/subquery/Tests/subquery9.test --- a/sql/test/subquery/Tests/subquery9.test +++ b/sql/test/subquery/Tests/subquery9.test @@ -228,4 +228,16 @@ 1101 Head Office CA +statement ok +DROP TABLE branches +statement ok +DROP TABLE branches_services + +statement ok +DROP TABLE clients + +statement ok +DROP TABLE services + + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
