diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-08-21 17:10:55 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-08-21 17:10:55 +0300 |
| commit | 66ce3dee92858acb6f67f8d1751144f7a468a545 (patch) | |
| tree | d9cb6f1114d4934bbc3a7c8adc313f974b717039 /mysql-test/r/view_grant.result | |
| parent | 0665536995fa1afe4ac71e13451dd8258063ff36 (diff) | |
| download | mariadb-git-66ce3dee92858acb6f67f8d1751144f7a468a545.tar.gz | |
Revert of the fix for bug #46019.
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 c9b31b00f69..e7a50451cec 100644 --- a/mysql-test/r/view_grant.result +++ b/mysql-test/r/view_grant.result @@ -945,28 +945,4 @@ 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. |