[Commits] e777d8c: fix test suite (we cache views definitions now)

sanja at mariadb.com sanja at mariadb.com
Tue Mar 10 13:52:21 EET 2015


revision-id: e777d8c959a990682d0f0e829fabdb0099d7f8eb
parent(s): 84d4d3f44db6da8c072f21ca983b6fd4e8754022
committer: Oleksandr Byelkin
branch nick: server
timestamp: 2015-03-10 12:52:18 +0100
message:

fix test suite (we cache views definitions now)

---
 mysql-test/suite/roles/definer.result | 1 +
 mysql-test/suite/roles/definer.test   | 1 +
 2 files changed, 2 insertions(+)

diff --git a/mysql-test/suite/roles/definer.result b/mysql-test/suite/roles/definer.result
index 0010853..a2d8424 100644
--- a/mysql-test/suite/roles/definer.result
+++ b/mysql-test/suite/roles/definer.result
@@ -86,6 +86,7 @@ Warnings:
 Note	1449	The user specified as a definer ('role4'@'') does not exist
 select * from test.v5;
 ERROR HY000: The user specified as a definer ('role4'@'') does not exist
+flush tables;
 show create view test.v5;
 View	Create View	character_set_client	collation_connection
 v5	CREATE ALGORITHM=UNDEFINED DEFINER=`role4`@`%` SQL SECURITY DEFINER VIEW `test`.`v5` AS select (`mysqltest1`.`t1`.`a` + `mysqltest1`.`t1`.`b`) AS `a+b`,`mysqltest1`.`t1`.`c` AS `c` from `mysqltest1`.`t1`	latin1	latin1_swedish_ci
diff --git a/mysql-test/suite/roles/definer.test b/mysql-test/suite/roles/definer.test
index 3c06910..995c36a 100644
--- a/mysql-test/suite/roles/definer.test
+++ b/mysql-test/suite/roles/definer.test
@@ -115,6 +115,7 @@ open(F, '>', $f) or die "open(>$f): $!";
 syswrite F, $_ or die "syswrite($f): $!" 
 EOF
 
+flush tables;
 show create view test.v5;
 select * from test.v5;
 drop user role4;


More information about the commits mailing list