• Ramil Kalimullin's avatar
    Fix for bug#47963: Wrong results when index is used · 5a23617a
    Ramil Kalimullin authored
    Problem: using null microsecond part (e.g. "YYYY-MM-DD HH:MM:SS.0000") 
    in a WHERE condition may lead to wrong results due to improper
    DATETIMEs comparison in some cases.
    
    Fix: as we compare DATETIMEs as strings we must trim trailing 0's
    in such cases.
    5a23617a
innodb_mysql.test 13.4 KB