diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2017-08-11 10:58:23 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2017-08-11 10:58:23 +0400 |
| commit | 1a9e13d622382285d979e75774bdd1dde1660e2d (patch) | |
| tree | b0da321b46551da1a75b2a6aa0c7b89afa5ce0d0 /mysql-test/t/view.test | |
| parent | 837aa57fb2dcb2f487494181c43dbcfeb61af64f (diff) | |
| parent | 79d28533549d15e848b342cf518ae4b409ba3e64 (diff) | |
| download | mariadb-git-1a9e13d622382285d979e75774bdd1dde1660e2d.tar.gz | |
Merge remote-tracking branch 'origin/10.2' into bb-10.2-ext
Conflicts:
sql/item_cmpfunc.cc
storage/innobase/buf/buf0flu.cc
storage/innobase/include/ut0stage.h
storage/innobase/row/row0upd.cc
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 00a040ccfdc..a9d6d9cec9c 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -6275,6 +6275,31 @@ SHOW CREATE VIEW v; DROP VIEW v; --echo # +--echo # MDEV-13439: Database permissions are not enough to run a subquery +--echo # with GROUP BY within a view +--echo # + +create database test_db; +use test_db; +create table t (i int); + +create user foo@localhost; +grant all on test_db.* to foo@localhost; + +--connect (con1,localhost,foo,,) + +use test_db; +create view v as select * from (select i from t group by i) sq; +select * from v; + +# Cleanup +--disconnect con1 +--connection default +use test; +drop database test_db; +drop user foo@localhost; + +--echo # --echo # End of 10.2 tests --echo # |