• unknown's avatar
    Fixed bug #18165. · b50c3c6e
    unknown authored
    Made [NOT]BETWEEN predicates SARGable in respect to the second and 
    the third arguments.
    
    
    mysql-test/r/range.result:
      Added a test case to bug #18165.
    mysql-test/t/range.test:
      Added a test case to bug #18165.
    sql/opt_range.cc:
      Fixed bug #18165.
      Made [NOT]BETWEEN predicates SARGable in respect to the second and 
      the third arguments.
      Put in a separate function called get_full_func_mm_tree the functionality
      that builds a conjunction of all SEL_TREEs for a simple predicate of the
      form (f op c), where f was a field and c was a constant, applying different
      equalities f=f' with f' being another field.
    b50c3c6e
sql_select.cc 455 KB