summaryrefslogtreecommitdiff
path: root/mysql-test/r/information_schema_db.result
diff options
context:
space:
mode:
authorMatthias Leich <Matthias.Leich@sun.com>2009-05-15 11:59:31 +0200
committerMatthias Leich <Matthias.Leich@sun.com>2009-05-15 11:59:31 +0200
commitf4eb0953b1367471e808263a699d6a20ea842b3e (patch)
tree2c070f00fbae12457d7c529bc467fdfdf4f04954 /mysql-test/r/information_schema_db.result
parentd68ea7d5198bc73a5c9f19a09afa7c4dd691cd37 (diff)
downloadmariadb-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.result8
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;