diff options
| author | unknown <magnus@neptunus.(none)> | 2004-10-08 13:37:13 +0200 |
|---|---|---|
| committer | unknown <magnus@neptunus.(none)> | 2004-10-08 13:37:13 +0200 |
| commit | 3d963659e4873423a948acb4dac94f8a8bfcf4e3 (patch) | |
| tree | 312b2fb7c11708d32ce870e2cebdcf25b2b22920 /mysql-test/r/ndb_autodiscover.result | |
| parent | 69b6adbd583fa669a2c52ed7d37e147d77fa40ee (diff) | |
| download | mariadb-git-3d963659e4873423a948acb4dac94f8a8bfcf4e3.tar.gz | |
BUG#5973 ndb table belonging to different database shows up in SHOW TABLES
mysql-test/r/ndb_autodiscover.result:
Added test cases to check that SHOW TABLES only show tables in the selected db.
mysql-test/t/ndb_autodiscover.test:
Added test cases to check that SHOW TABLES only show tables in the selected db.
sql/ha_ndbcluster.cc:
Only find files for the current db
Only add files to files list which can be created i.e has a valid frm blob. This prevents NDB$BLOB tables and tables created from NdbApi to show up.
Diffstat (limited to 'mysql-test/r/ndb_autodiscover.result')
| -rw-r--r-- | mysql-test/r/ndb_autodiscover.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_autodiscover.result b/mysql-test/r/ndb_autodiscover.result index 031be91fcb2..4a2bc6e9d90 100644 --- a/mysql-test/r/ndb_autodiscover.result +++ b/mysql-test/r/ndb_autodiscover.result @@ -330,6 +330,34 @@ show status like 'handler_discover%'; Variable_name Value Handler_discover 0 drop table t6; +show tables; +Tables_in_test +create table t1 (a int) engine=ndb; +show tables; +Tables_in_test +t1 +create database test2; +use test2; +show tables; +Tables_in_test2 +select * from t1; +ERROR 42S02: Table 'test2.t1' doesn't exist +create table t2 (b int) engine=ndb; +use test; +select * from t1; +a +show tables; +Tables_in_test +t1 +drop table t1; +use test2; +drop table t2; +drop database test2; +show databases; +Database +mysql +test +use test; CREATE TABLE t9 ( a int NOT NULL PRIMARY KEY, b int |