diff options
| author | gkodinov/kgeorge@macbook.gmz <> | 2008-01-09 16:49:13 +0200 |
|---|---|---|
| committer | gkodinov/kgeorge@macbook.gmz <> | 2008-01-09 16:49:13 +0200 |
| commit | 2fc45f017d511ea2386a8c0417eadeab849f3de6 (patch) | |
| tree | 3cc97ab38bc2e07f0427ff5d412eab18772463e8 /mysql-test/t/func_group.test | |
| parent | 0e3e5cf40d310751eac8ff9109b9a768c2096a7a (diff) | |
| download | mariadb-git-2fc45f017d511ea2386a8c0417eadeab849f3de6.tar.gz | |
Bug #33133: Views are not transparent
When resolving references we need to take into consideration
the view "fields" and allow qualified access to them.
Fixed by extending the reference resolution to process view
fields correctly.
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 25cb13a2f75..75a380c733f 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -901,5 +901,20 @@ SELECT COUNT(*), a FROM t1; DROP TABLE t1; +# +# Bug #33133: Views are not transparent +# + +set SQL_MODE=ONLY_FULL_GROUP_BY; + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2),(3),(4); +CREATE VIEW v1 AS SELECT a,(a + 1) AS y FROM t1; +EXPLAIN EXTENDED SELECT y FROM v1 GROUP BY v1.y; + +DROP VIEW v1; +DROP TABLE t1; +SET SQL_MODE=DEFAULT; + ### --echo End of 5.0 tests |