[Commits] Rev 4484: MDEV-356 Certain VIEWs not restorable from mysqldump in lp:~maria-captains/maria/10.0

Sergei Golubchik serg at mariadb.org
Thu Nov 13 21:12:05 EET 2014


At lp:~maria-captains/maria/10.0

------------------------------------------------------------
revno: 4484
revision-id: sergii at pisem.net-20141113191204-qbv07cq1t3fwkjza
parent: sergii at pisem.net-20141113161325-mdz5ox7e86iyazss
fixes bug: https://mariadb.atlassian.net/browse/MDEV-356
committer: Sergei Golubchik <sergii at pisem.net>
branch nick: 10.0
timestamp: Thu 2014-11-13 20:12:04 +0100
message:
  MDEV-356 Certain VIEWs not restorable from mysqldump
  
  add a test case
=== modified file 'mysql-test/r/view.result'
--- a/mysql-test/r/view.result	2014-11-13 12:40:42 +0000
+++ b/mysql-test/r/view.result	2014-11-13 19:12:04 +0000
@@ -5514,6 +5514,26 @@ count(v3.i)
 0
 drop table t1, t2;
 drop view v3;
+create table t1 (id int not null);
+create view v1 as select '' from t1;
+show create view v1;
+View	Create View	character_set_client	collation_connection
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select '' AS `Name_exp_1` from `t1`	latin1	latin1_swedish_ci
+select * from v1;
+Name_exp_1
+drop view v1;
+create view v1 as select user from mysql.user union all select ' ';
+show create view v1;
+View	Create View	character_set_client	collation_connection
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `mysql`.`user`.`User` AS `user` from `mysql`.`user` union all select ' ' AS `Name_exp_1`	latin1	latin1_swedish_ci
+select * from v1;
+user
+root
+root
+root
+root
+ 
+drop view v1;
 # -----------------------------------------------------------------
 # -- End of 10.0 tests.
 # -----------------------------------------------------------------

=== modified file 'mysql-test/t/view.test'
--- a/mysql-test/t/view.test	2014-11-13 12:40:42 +0000
+++ b/mysql-test/t/view.test	2014-11-13 19:12:04 +0000
@@ -5379,6 +5379,20 @@ execute stmt;
 drop table t1, t2;
 drop view v3;
 
+#
+# MDEV-356 Certain VIEWs not restorable from mysqldump
+#
+create table t1 (id int not null);
+create view v1 as select '' from t1;
+show create view v1;
+select * from v1;
+drop view v1;
+
+create view v1 as select user from mysql.user union all select ' ';
+show create view v1;
+select * from v1;
+drop view v1;
+
 --echo # -----------------------------------------------------------------
 --echo # -- End of 10.0 tests.
 --echo # -----------------------------------------------------------------



More information about the commits mailing list