diff options
| author | igor@rurik.mysql.com <> | 2005-09-26 23:29:02 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2005-09-26 23:29:02 -0700 |
| commit | 6e2fb27af65f20f4da2e8b8b8668f9f958ce54d2 (patch) | |
| tree | cc372feaa4c206f063fca31950c8e5422173550a /mysql-test/t/view.test | |
| parent | 75c43f9663eb134642400b0d2e0a25657e5fccc4 (diff) | |
| download | mariadb-git-6e2fb27af65f20f4da2e8b8b8668f9f958ce54d2.tar.gz | |
item.cc:
Fixed bug #13410.
Fixed name resolution for qualified reference to a view column
in the HAVING clause.
view.result, view.test:
Added a test case for bug #13410.
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 11a318549d4..8d3593162c7 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2153,4 +2153,15 @@ SELECT v1.a FROM v1 GROUP BY v1.a HAVING a > 1; DROP VIEW v1; DROP TABLE t1; +# +# Bug #13410: failed name resolution for qualified view column in HAVING +# + +CREATE TABLE t1 ( a int, b int ); +INSERT INTO t1 VALUES (1,1),(2,2),(3,3); +CREATE VIEW v1 AS SELECT a,b FROM t1; +SELECT t1.a FROM t1 GROUP BY t1.a HAVING t1.a > 1; +SELECT v1.a FROM v1 GROUP BY v1.a HAVING v1.a > 1; +DROP VIEW v1; +DROP TABLE t1; |