diff options
| author | unknown <igor@rurik.mysql.com> | 2006-05-16 22:19:44 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-05-16 22:19:44 -0700 |
| commit | f1efd0883d4201b7fb8a60ee40f0024cafd01fd3 (patch) | |
| tree | d7fa05843a827dc02a5bbdd17483c49825b1b95f /mysql-test/r/having.result | |
| parent | a514a26cd0da0faa4c73be1698d897d065bca008 (diff) | |
| download | mariadb-git-f1efd0883d4201b7fb8a60ee40f0024cafd01fd3.tar.gz | |
Fixed bug #19573.
The select statement that specified a view could be
slightly changed when the view was saved in a frm file.
In particular references to an alias name in the HAVING
clause could be substituted for the expression named by
this alias.
This could result in an error message for a query of
the form SELECT * FROM <view>. Yet no such message
appeared when executing the query specifying the view.
mysql-test/r/having.result:
Adjusted results after fixing bug #19573.
mysql-test/r/view.result:
Added a test case for bug #19573.
mysql-test/t/view.test:
Added a test case for bug #19573.
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index a37f260ff31..68b13b5fc0a 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -12,7 +12,7 @@ explain extended select count(a) as b from t1 where a=0 having b >=0; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: -Note 1003 select count(`test`.`t1`.`a`) AS `b` from `test`.`t1` where 0 having (count(`test`.`t1`.`a`) >= 0) +Note 1003 select count(`test`.`t1`.`a`) AS `b` from `test`.`t1` where 0 having (`b` >= 0) drop table t1; CREATE TABLE t1 ( raw_id int(10) NOT NULL default '0', |