diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2020-12-25 09:13:28 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-12-25 09:13:28 +0100 |
| commit | 478b83032b170b2ae030fa77fe4bed60a7910472 (patch) | |
| tree | a3893bb725e227dc15c6997731cdeba622ae1744 /mysql-test/main/lock_view.test | |
| parent | 0aa02567dd62d96467f84ba96cc67b103f63c9e0 (diff) | |
| parent | 043bd85a574a88856ab9c6d497e682ed06fe45e9 (diff) | |
| download | mariadb-git-bb-10.4-MDEV-23468.tar.gz | |
Merge branch '10.3' into 10.4bb-10.4-MDEV-23468
Diffstat (limited to 'mysql-test/main/lock_view.test')
| -rw-r--r-- | mysql-test/main/lock_view.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/lock_view.test b/mysql-test/main/lock_view.test index 4b1adac5be1..abb8d317946 100644 --- a/mysql-test/main/lock_view.test +++ b/mysql-test/main/lock_view.test @@ -75,3 +75,20 @@ drop user definer@localhost; drop database mysqltest1; drop database mysqltest2; drop database mysqltest3; + +--echo # +--echo # MDEV-24331 mysqldump fails with "Got error: 1356" if the database contains a view with a subquery +--echo # +create user u1@localhost; +grant all privileges on test.* to u1@localhost; +connect con1,localhost,u1; +use test; +create table t1 (id int not null); +create view v1 as select * from (select * from t1) dt; +lock table v1 read; +disconnect con1; +connection default; +exec $MYSQL_DUMP test v1 -uu1 --compact; +drop view v1; +drop table t1; +drop user u1@localhost; |