diff options
| author | mskold@mysql.com <> | 2005-04-22 17:38:28 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2005-04-22 17:38:28 +0200 |
| commit | 5411f8a6e4969abb3400a851e93395b538c40a1f (patch) | |
| tree | 99493403c01d2b9aaafe81e6ee7e58c16d8a9445 /mysql-test | |
| parent | 564eb3dc98336663b6d414a347fe90dc6d2cb042 (diff) | |
| parent | 945755161658cf6ecae3290cf511d3ecee9aa96f (diff) | |
| download | mariadb-git-5411f8a6e4969abb3400a851e93395b538c40a1f.tar.gz | |
Merge
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 |