diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2015-03-23 09:49:32 +0200 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2015-03-23 09:49:32 +0200 |
| commit | 86f46a3da4a6d82cb510dc4c270d46cfd6a8965b (patch) | |
| tree | fe65a98e454c721ff6dc0ac9b2fd79248911451f /mysql-test/r/having.result | |
| parent | 9253064c0547b16b867565a05f8305780c2ecc34 (diff) | |
| download | mariadb-git-86f46a3da4a6d82cb510dc4c270d46cfd6a8965b.tar.gz | |
MDEV-7301: Unknown column quoted with backticks in HAVING clause
when using function.
Merged upstream fix to Bug#16221433 MYSQL REJECTS QUERY DUE TO BAD
RESOLUTION OF NAMES IN HAVING; VIEW UNREADABLE
authored by Guilhem Bichot <guilhem.bichot@oracle.com>.
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index 7ead7e3f4ed..514abbf5522 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -666,3 +666,34 @@ SELECT * FROM t1 WHERE f = 2 HAVING ( pk IN ( SELECT 9 ) AND f != 0 ); pk f DROP TABLE t1; End of 5.3 tests +# +# Bug MDEV-7301: Unknown column quoted with backticks in HAVING clause when using function. +# Bug#16221433 MYSQL REJECTS QUERY DUE TO BAD RESOLUTION OF NAMES IN HAVING; VIEW UNREADABLE +# +CREATE TABLE `t1` ( +`id` int(11) NOT NULL, +`title` varchar(45) DEFAULT NULL, +PRIMARY KEY (`id`) +) DEFAULT CHARSET=utf8; +INSERT INTO `t1` VALUES ('1', 'Just for fun'); +INSERT INTO `t1` VALUES ('2', 'Wait until a sunhine'); +INSERT INTO `t1` VALUES ('3', 'Take a new turn'); +SELECT `id`, SHA1(`title`) AS `column_1` +FROM `t1` +HAVING `column_1` LIKE '8%'; +id column_1 +1 80a12660d24a72460e5e292fe33f870276d7f40a +expected 1 row(s) returned +SELECT `id`, SHA1(`title`) AS `column_1` +FROM `t1` +HAVING UPPER(column_1) LIKE '8%'; +id column_1 +1 80a12660d24a72460e5e292fe33f870276d7f40a +expected -- 1 row(s) returned +SELECT `id`, SHA1(`title`) AS `column_1` +FROM `t1` +HAVING UPPER(`column_1`) LIKE '8%'; +id column_1 +1 80a12660d24a72460e5e292fe33f870276d7f40a +expected -- 1 row(s) returned not ER_BAD_FIELD_ERROR +drop table t1; |