diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ndb_database.result | 27 | ||||
| -rw-r--r-- | mysql-test/t/ndb_database.test | 50 |
2 files changed, 77 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_database.result b/mysql-test/r/ndb_database.result new file mode 100644 index 00000000000..566a3eaf3dd --- /dev/null +++ b/mysql-test/r/ndb_database.result @@ -0,0 +1,27 @@ +drop table if exists t1; +drop database if exists mysqltest; +drop table if exists t1; +drop database if exists mysqltest; +create database mysqltest; +create database mysqltest; +create table mysqltest.t1 (a int primary key, b int) engine=ndb; +use mysqltest; +show tables; +Tables_in_mysqltest +t1 +drop database mysqltest; +use mysqltest; +show tables; +Tables_in_mysqltest +create database mysqltest; +create table mysqltest.t1 (c int, d int primary key) engine=ndb; +use mysqltest; +show tables; +Tables_in_mysqltest +t1 +drop database mysqltest; +use mysqltest; +show tables; +Tables_in_mysqltest +drop table if exists t1; +drop database if exists mysqltest; diff --git a/mysql-test/t/ndb_database.test b/mysql-test/t/ndb_database.test new file mode 100644 index 00000000000..1264c3fa73b --- /dev/null +++ b/mysql-test/t/ndb_database.test @@ -0,0 +1,50 @@ +-- source include/have_ndb.inc +-- source include/have_multi_ndb.inc +-- source include/not_embedded.inc + +--disable_warnings +connection server1; +drop table if exists t1; +drop database if exists mysqltest; +connection server2; +drop table if exists t1; +drop database if exists mysqltest; +--enable_warnings + +# +# Check that all tables in a database are dropped when database is dropped +# + +connection server1; +create database mysqltest; + +connection server2; +create database mysqltest; +create table mysqltest.t1 (a int primary key, b int) engine=ndb; +use mysqltest; +show tables; + +connection server1; +drop database mysqltest; + +connection server2; +use mysqltest; +show tables; + +connection server1; +create database mysqltest; +create table mysqltest.t1 (c int, d int primary key) engine=ndb; +use mysqltest; +show tables; + +connection server2; +drop database mysqltest; + +connection server1; +use mysqltest; +show tables; + +--disable_warnings +drop table if exists t1; +drop database if exists mysqltest; +--enable_warnings |