diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2021-04-08 17:25:02 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2021-04-08 17:25:02 +0300 |
commit | c03841ec0e2b7ac11711243d29821038b26e3edf (patch) | |
tree | 1761cc090dacff48aea0784644a693731c85f02d /mysql-test/main/func_group.test | |
parent | 4e2ca42225311f73745c9eec309bc941183aba30 (diff) | |
download | mariadb-git-c03841ec0e2b7ac11711243d29821038b26e3edf.tar.gz |
MDEV-23634: Select query hanged the server and leads to OOM ...bb-10.4-mdev23634
Handle "col<>const" in the same way that MDEV-21958 did for
"col NOT IN(const-list)": do not use the condition for range/index_merge
accesses if there is a unique UNIQUE KEY(col).
The testcase is in main/range.test. The rest of test updates are
due to widespread use of 'pk<>1' in the testsuite. Changed the test
to use different but equivalent forms of the conditions.
Diffstat (limited to 'mysql-test/main/func_group.test')
-rw-r--r-- | mysql-test/main/func_group.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/func_group.test b/mysql-test/main/func_group.test index 10b92cbadca..a28b39c28f6 100644 --- a/mysql-test/main/func_group.test +++ b/mysql-test/main/func_group.test @@ -359,7 +359,7 @@ select min(t1.a1), min(t2.a4) from t1,t2 where t1.a1 < 'KKK' and t2.a4 < 'KKK'; explain select min(a1) from t1 where a1 > 'KKK' or a1 < 'XXX'; explain -select min(a1) from t1 where a1 != 'KKK'; +select min(a1) from t1 where (a1 < 'KKK' or a1 > 'KKK'); explain select max(a3) from t1 where a2 < 2 and a3 < 'SEA'; explain |