diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-03-20 19:25:08 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-03-20 19:25:08 +0200 |
| commit | 613be24b7a53310ae6b250e5ca11fdd3673a531e (patch) | |
| tree | 75291533f09ca50fe026604f358c60180d510d10 /mysql-test/t/having.test | |
| parent | e0a0fe7d8124b9f395a6c97f538693e729a0b043 (diff) | |
| parent | 04921000594dcbdf23340850b9284fd30ccdb0fd (diff) | |
| download | mariadb-git-613be24b7a53310ae6b250e5ca11fdd3673a531e.tar.gz | |
Merge 10.0 into 10.1
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index 1bbde3e7c5e..dadeaca35b6 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -759,6 +759,24 @@ SELECT * FROM t1 JOIN t2 ON c1 = c2 HAVING c2 > 'a' ORDER BY c2 LIMIT 1; DROP TABLE t1,t2; +--echo # +--echo # MDEV-6736: Valgrind warnings 'Invalid read' in subselect_engine::calc_const_tables with SQ +--echo # in WHERE and HAVING, ORDER BY, materialization+semijoin +--echo # + +CREATE TABLE t1 (a INT) ENGINE=MyISAM; +INSERT INTO t1 VALUES (3),(8); + +CREATE TABLE t2 (b INT) ENGINE=MyISAM; +INSERT INTO t2 VALUES (2),(1); + +SELECT a FROM t1 +WHERE 9 IN ( SELECT MIN( a ) FROM t1 ) +HAVING a <> ( SELECT COUNT(*) FROM t2 ) +ORDER BY a; + +DROP TABLE t1,t2; + --echo End of 10.0 tests --echo # |