diff options
| author | Igor Babaev <igor@askmonty.org> | 2018-06-11 08:52:26 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2018-06-11 08:52:49 -0700 |
| commit | 147744d455d57c753ca75fccca106d3326d251ab (patch) | |
| tree | 25e6a3cf7b9c33c60f8a9a41749b652686281df8 /mysql-test/t/having.test | |
| parent | ca733d03c82b02cd842ff2a226fee7b12eb86f8d (diff) | |
| download | mariadb-git-147744d455d57c753ca75fccca106d3326d251ab.tar.gz | |
MDEV-16235 Server crashes in my_utf8_uni or in my_strtod_int upon
SELECT .. LIMIT 0 (new variant)
This is another attempt to fix the problem of mdev-14515.
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index a470f462d6a..c8bd47940cc 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -744,3 +744,12 @@ SELECT a, COUNT(a) as ct FROM t1 GROUP BY a HAVING ct>0; set sql_mode=@save_sql_mode; drop table t1; + +--echo # +--echo # mdev-16235: impossible HAVING in query without aggregation +--echo # + +explain extended +select * from mysql.help_topic where example = 'foo' having description is null; + +select * from mysql.help_topic where example = 'foo' having description is null; |