• Sergei Petrunia's avatar
    MDEV-23634: Select query hanged the server and leads to OOM ... · c03841ec
    Sergei Petrunia authored
    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.
    c03841ec
index_merge_myisam.test 11.1 KB