diff options
author | Matthias Leich <Matthias.Leich@sun.com> | 2009-05-15 11:59:31 +0200 |
---|---|---|
committer | Matthias Leich <Matthias.Leich@sun.com> | 2009-05-15 11:59:31 +0200 |
commit | f4eb0953b1367471e808263a699d6a20ea842b3e (patch) | |
tree | 2c070f00fbae12457d7c529bc467fdfdf4f04954 /mysql-test/r/information_schema_db.result | |
parent | d68ea7d5198bc73a5c9f19a09afa7c4dd691cd37 (diff) | |
download | mariadb-git-f4eb0953b1367471e808263a699d6a20ea842b3e.tar.gz |
Fix for Bug#44826 main.information_schema_db could harm succeeding tests
Details:
1. Add missing "disconnect <session>"
2. Take care that the disconnects are finished when the test terminates
3. Replace error names by error numbers
4. Minor beautifying of script code
Diffstat (limited to 'mysql-test/r/information_schema_db.result')
-rw-r--r-- | mysql-test/r/information_schema_db.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/information_schema_db.result b/mysql-test/r/information_schema_db.result index 67c9921e1ca..e7f16138aa4 100644 --- a/mysql-test/r/information_schema_db.result +++ b/mysql-test/r/information_schema_db.result @@ -49,7 +49,7 @@ begin select table_name from information_schema.key_column_usage order by table_name; end| -create table t1 +create table t1 (f1 int(10) unsigned not null, f2 varchar(100) not null, primary key (f1), unique key (f2)); @@ -191,15 +191,15 @@ View Create View v2 CREATE ALGORITHM=UNDEFINED DEFINER=`testdb_2`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select `v1`.`f1` AS `f1` from `testdb_1`.`v1` show create view testdb_1.v1; ERROR 42000: SHOW VIEW command denied to user 'testdb_2'@'localhost' for table 'v1' -select table_name from information_schema.columns a +select table_name from information_schema.columns a where a.table_name = 'v2'; table_name v2 -select view_definition from information_schema.views a +select view_definition from information_schema.views a where a.table_name = 'v2'; view_definition /* ALGORITHM=UNDEFINED */ select `v1`.`f1` AS `f1` from `testdb_1`.`v1` -select view_definition from information_schema.views a +select view_definition from information_schema.views a where a.table_name = 'testdb_1.v1'; view_definition select * from v2; |