diff options
| author | Gleb Shchepa <gshchepa@mysql.com> | 2009-05-19 00:51:52 +0500 |
|---|---|---|
| committer | Gleb Shchepa <gshchepa@mysql.com> | 2009-05-19 00:51:52 +0500 |
| commit | d4be7dadb8085facb90de4e68444903ecdb23310 (patch) | |
| tree | 197dd2e2bdd4cbd7775f332cb827834ff7737492 /mysql-test/r/view.result | |
| parent | bb3f97f4bfa7946e83bf69bc962efff8131bd11a (diff) | |
| parent | a7294532b2f45342075d2a1bdac6cb8720a90ea3 (diff) | |
| download | mariadb-git-d4be7dadb8085facb90de4e68444903ecdb23310.tar.gz | |
manual merge 5.0-bugteam --> 5.1-bugteam (bug 40825)
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 0905fc0109b..a7af6a30f5c 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3700,6 +3700,25 @@ ERROR 42000: Key 'c2' doesn't exist in table 'v1' DROP VIEW v1; DROP TABLE t1; # ----------------------------------------------------------------- +# -- Bug#40825: Error 1356 while selecting from a view +# -- with a "HAVING" clause though query works +# ----------------------------------------------------------------- + +CREATE TABLE t1 (c INT); + +CREATE VIEW v1 (view_column) AS SELECT c AS alias FROM t1 HAVING alias; +SHOW CREATE VIEW v1; +View Create View character_set_client collation_connection +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`c` AS `view_column` from `t1` having `view_column` latin1 latin1_swedish_ci +SELECT * FROM v1; +view_column + +DROP VIEW v1; +DROP TABLE t1; + +# -- End of test case for Bug#40825 + +# ----------------------------------------------------------------- # -- End of 5.0 tests. # ----------------------------------------------------------------- DROP DATABASE IF EXISTS `d-1`; |