• Ramil Kalimullin's avatar
    Fix for bug#49199: Optimizer handles incorrectly: · 7888c983
    Ramil Kalimullin authored
    field='const1' AND field='const2' in some cases
    
    Building multiple equality predicates containing
    a constant which is compared as a datetime (with a field)
    we should take this fact into account and compare the 
    constant with another possible constatns as datetimes 
    as well.
    
    E.g. for the
    SELECT ... WHERE a='2001-01-01' AND a='2001-01-01 00:00:00'
    we should compare '2001-01-01' with '2001-01-01 00:00:00' as
    datetimes but not as strings.
    7888c983
sql_select.cc 507 KB