• MySQL Build Team's avatar
    Backport into build-200911241145-5.1.40sp1 · 5fb71256
    MySQL Build Team authored
    > ------------------------------------------------------------
    > revno: 3182 [merge]
    > revision-id: ramil@mysql.com-20091018162655-z4dlolfx5s0zem8l
    > parent: alexey.kopytov@sun.com-20091016201951-fsht0wm8xn8vkzsx
    > parent: ramil@mysql.com-20091013044327-24km05wc060ied87
    > committer: Ramil Kalimullin <ramil@mysql.com>
    > branch nick: mysql-5.1-bugteam
    > timestamp: Sun 2009-10-18 21:26:55 +0500
    > message:
    >   Fix for bug#47963: Wrong results when index is used
    >   
    >   Problem: using null microsecond part in a WHERE condition 
    >   (e.g. WHERE date_time_field <= "YYYY-MM-DD HH:MM:SS.0000") 
    >   may lead to wrong results due to improper DATETIMEs 
    >   comparison in some cases.
    >   
    >   Fix: comparing DATETIMEs as strings we must trim trailing 0's
    >   in such cases.
    > ------------------------------------------------------------
    > Use --include-merges or -n0 to see merged revisions.
    5fb71256
innodb_mysql.test 13.4 KB