• Sergei Petrunia's avatar
    MDEV-21958: Query having many NOT-IN clauses running forever · 066212d1
    Sergei Petrunia authored
    Basic variant of the fix: do not consider conditions in form
    
      unique_key NOT IN (c1,c2...)
    
    to be sargable. If there are only a few constants, the condition
    is not selective. If there are a lot constants, the overhead of
    processing such a huge range list is not worth it.
    
    (Backport to 10.2)
    066212d1
opt_range.cc 483 KB