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.result | |
| 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.result')
| -rw-r--r-- | mysql-test/main/func_group.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/func_group.result b/mysql-test/main/func_group.result index fc6f93a938a..071c155cd6b 100644 --- a/mysql-test/main/func_group.result +++ b/mysql-test/main/func_group.result @@ -606,7 +606,7 @@ select min(a1) from t1 where a1 > 'KKK' or a1 < 'XXX'; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index PRIMARY PRIMARY 3 NULL 15 Using where; Using index explain -select min(a1) from t1 where a1 != 'KKK'; +select min(a1) from t1 where (a1 < 'KKK' or a1 > 'KKK'); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index PRIMARY PRIMARY 3 NULL 15 Using where; Using index explain |