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 | d5bda7c313fd0be1ca25ed85566505b73bb96b77 (patch) | |
| tree | e6c13b235af5125765f617afc9861d0273a62159 /mysql-test/t/view_grant.test | |
| parent | a1589a1061a72e6fd987c0bbda8ae7877d9efb5c (diff) | |
| parent | 9a856bd483b166524f94404e568410fce327f003 (diff) | |
| download | mariadb-git-d5bda7c313fd0be1ca25ed85566505b73bb96b77.tar.gz | |
reverted the fix for bug #46019 from 5.1-bugteam
Diffstat (limited to 'mysql-test/t/view_grant.test')
| -rw-r--r-- | mysql-test/t/view_grant.test | 35 |
1 files changed, 0 insertions, 35 deletions
diff --git a/mysql-test/t/view_grant.test b/mysql-test/t/view_grant.test index 78b4a078683..824c67d867e 100644 --- a/mysql-test/t/view_grant.test +++ b/mysql-test/t/view_grant.test @@ -1237,41 +1237,6 @@ DROP VIEW db1.v1; DROP TABLE db1.t1; DROP DATABASE db1; ---echo # ---echo # Bug #46019: ERROR 1356 When selecting from within another ---echo # view that has Group By ---echo # - -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; - -CONNECT (u1, localhost, u1,,db1); -CONNECTION u1; - -SELECT a FROM v1; -SELECT a FROM v2; - -CONNECTION default; -DISCONNECT u1; -DROP USER u1; -DROP VIEW v1,v2; -DROP TABLE t1; -USE test; -DROP DATABASE db1; --echo End of 5.0 tests. |