diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-11-05 23:48:01 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-11-05 23:48:01 +0300 |
| commit | eed607b829e68694ee996092c337ed13846e78ec (patch) | |
| tree | ffc897d29040b88cb4851e9cb6c5c87e7aebea31 /mysql-test/r/view_grant.result | |
| parent | cd14c47c99ddcc52d7b72832c4d8dad8852e0985 (diff) | |
| parent | a35e013144da7cd3f2b095f11ec91fffd58e2b3a (diff) | |
| download | mariadb-git-eed607b829e68694ee996092c337ed13846e78ec.tar.gz | |
Manual merge from mysql-trunk-merge.
Diffstat (limited to 'mysql-test/r/view_grant.result')
| -rw-r--r-- | mysql-test/r/view_grant.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/view_grant.result b/mysql-test/r/view_grant.result index 0c3539d1641..65fbf2d87b6 100644 --- a/mysql-test/r/view_grant.result +++ b/mysql-test/r/view_grant.result @@ -1218,3 +1218,22 @@ Warnings: Note 1449 The user specified as a definer ('no_such_user'@'no_such_host') does not exist DROP TABLE t1; DROP VIEW v1; +# +# Bug #46019: ERROR 1356 When selecting from within another +# view that has Group By +# +CREATE DATABASE mysqltest1; +USE mysqltest1; +CREATE TABLE t1 (a INT); +CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT a FROM t1 GROUP BY a; +CREATE SQL SECURITY INVOKER VIEW v2 AS SELECT a FROM v1; +CREATE USER mysqluser1; +GRANT SELECT ON TABLE t1 TO mysqluser1; +GRANT SELECT, SHOW VIEW ON TABLE v1 TO mysqluser1; +GRANT SELECT, SHOW VIEW ON TABLE v2 TO mysqluser1; +SELECT a FROM v1; +a +SELECT a FROM v2; +a +DROP USER mysqluser1; +DROP DATABASE mysqltest1; |