diff options
author | unknown <tnurnberg@mysql.com> | 2006-06-12 02:46:26 +0200 |
---|---|---|
committer | unknown <tnurnberg@mysql.com> | 2006-06-12 02:46:26 +0200 |
commit | fbe342c003b4a7ccf4ff30497180929ccc8e0d3d (patch) | |
tree | d8b722c8ad526c1f18681f62dada8edae95b1d76 /mysql-test | |
parent | 726351f511622eae912bf553b46e82923a1651de (diff) | |
parent | 443de04577b6dd94941ea449d45b09f083de1164 (diff) | |
download | mariadb-git-fbe342c003b4a7ccf4ff30497180929ccc8e0d3d.tar.gz |
Merge bk-internal.mysql.com:/home/bk/mysql-5.0-maint
into mysql.com:/home/mysql-5.0-maint-17371
client/mysqldump.c:
Auto merged
mysql-test/r/mysqldump.result:
Auto merged
mysql-test/t/mysqldump.test:
Auto merged
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/mysqldump.result | 9 | ||||
-rw-r--r-- | mysql-test/t/mysqldump.test | 13 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index eff46ecc2d6..2e78de3e346 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -2770,3 +2770,12 @@ p CREATE DEFINER=`root`@`localhost` PROCEDURE `p`() select 42 drop function f; drop procedure p; +create table t1 ( id serial ); +create view v1 as select * from t1; +drop table t1; +mysqldump { + +-- failed on view `v1`: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `test`.`t1`.`id` AS `id` from `t1` + +} mysqldump +drop view v1; diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index d53022665a0..60c313861c1 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -1161,3 +1161,16 @@ show create procedure p; drop function f; drop procedure p; +# +# Bug #17371 Unable to dump a schema with invalid views +# +# +create table t1 ( id serial ); +create view v1 as select * from t1; +drop table t1; +# mysqldump gets 1356 from server, but gives us 2 +--echo mysqldump { +--error 2 +--exec $MYSQL_DUMP --force -N --compact --skip-comments test +--echo } mysqldump +drop view v1; |