• Alexey Kopytov's avatar
    Bug #46607: Assertion failed: (cond_type == Item::FUNC_ITEM) · 9620aec7
    Alexey Kopytov authored
                results in server crash 
     
    check_group_min_max_predicates() assumed the input condition 
    item to be one of COND_ITEM, SUBSELECT_ITEM, or FUNC_ITEM. 
    Since a condition of the form "field" is also a valid condition 
    equivalent to "field <> 0", using such a condition in a query 
    where the loose index scan was chosen resulted in a debug 
    assertion failure. 
     
    Fixed by handling conditions of the FIELD_ITEM type in 
    check_group_min_max_predicates(). 
    
    mysql-test/r/group_min_max.result:
      Added a test case for bug #46607.
    mysql-test/t/group_min_max.test:
      Added a test case for bug #46607.
    sql/opt_range.cc:
      Handle conditions of the FUNC_ITEM type in 
      check_group_mix_max_predicates().
    9620aec7
group_min_max.test 49.5 KB