• unknown's avatar
    BUG#21282: Incorrect query results for "t.key NOT IN (<big const list>) · 9cf4750e
    unknown authored
    In fix for BUG#15872, a condition of type "t.key NOT IN (c1, .... cN)"
    where N>1000, was incorrectly converted to
      (-inf < X < c_min) OR (c_max < X)
    Now this conversion is removed, we dont produce any range lists for such
    conditions.
    
    
    mysql-test/r/range.result:
      BUG#21282: Testcase
    mysql-test/t/range.test:
      BUG#21282: Testcase
    sql/opt_range.cc:
      BUG#21282: Incorrect query results for "t.key NOT IN (<big const list>) 
      In fix for BUG#15872, a condition of type "t.key NOT IN (c1, .... cN)"
      where N>1000, was incorrectly converted to 
        (-inf < X < c_min) OR (c_max < X)
      Now this conversion is removed, we dont produce any range lists for such
      conditions.
    9cf4750e
opt_range.cc 286 KB