• Sergei Petrunia's avatar
    MDEV-21958: Query having many NOT-IN clauses running forever · 4addd315
    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.
    4addd315
range.test 76.2 KB