summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <tnurnberg@mysql.com>2006-06-12 02:46:26 +0200
committerunknown <tnurnberg@mysql.com>2006-06-12 02:46:26 +0200
commitfbe342c003b4a7ccf4ff30497180929ccc8e0d3d (patch)
treed8b722c8ad526c1f18681f62dada8edae95b1d76 /mysql-test
parent726351f511622eae912bf553b46e82923a1651de (diff)
parent443de04577b6dd94941ea449d45b09f083de1164 (diff)
downloadmariadb-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.result9
-rw-r--r--mysql-test/t/mysqldump.test13
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;