diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-08-21 17:41:48 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-08-21 17:41:48 +0300 |
| commit | 787a4940cabef1416dbba1942ee3a07b987e9338 (patch) | |
| tree | e6c13b235af5125765f617afc9861d0273a62159 /mysql-test/r/view_grant.result | |
| parent | b011f1ea1c2cff73706f8b3ef8eacea2c433a9d9 (diff) | |
| parent | 8723e9d2269fec4d0a7dd4796deb53c0b2eab804 (diff) | |
| download | mariadb-git-787a4940cabef1416dbba1942ee3a07b987e9338.tar.gz | |
reverted the fix for bug #46019 from 5.1-bugteam
Diffstat (limited to 'mysql-test/r/view_grant.result')
| -rw-r--r-- | mysql-test/r/view_grant.result | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/mysql-test/r/view_grant.result b/mysql-test/r/view_grant.result index 6d1d872c3b7..7e280fa2fe5 100644 --- a/mysql-test/r/view_grant.result +++ b/mysql-test/r/view_grant.result @@ -947,30 +947,6 @@ DROP USER foo; DROP VIEW db1.v1; DROP TABLE db1.t1; DROP DATABASE db1; -# -# Bug #46019: ERROR 1356 When selecting from within another -# view that has Group By -# -CREATE DATABASE db1; -USE db1; -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 u1; -GRANT SELECT ON TABLE t1 TO u1; -GRANT SELECT, SHOW VIEW ON TABLE v1 TO u1; -GRANT SELECT, SHOW VIEW ON TABLE v2 TO u1; -SELECT a FROM v1; -a -SELECT a FROM v2; -a -DROP USER u1; -DROP VIEW v1,v2; -DROP TABLE t1; -USE test; -DROP DATABASE db1; End of 5.0 tests. DROP VIEW IF EXISTS v1; DROP TABLE IF EXISTS t1; |