• Gleb Shchepa's avatar
    Bug #55779: select does not work properly in mysql server · daa6d1f4
    Gleb Shchepa authored
                Version "5.1.42 SUSE MySQL RPM"
    
    When a query was using a DATE or DATETIME value formatted
    using different formatting than "yyyy-mm-dd HH:MM:SS", a
    query with a greater-or-equal '>=' condition matched only
    greater values in an indexed TIMESTAMP column.
    
    The problem was introduced by the fix for the bug 46362
    and partially solved (for DATE and DATETIME columns only)
    by the fix for the bug 47925.
    
    The stored_field_cmp_to_item function has been modified
    to take into account TIMESTAMP columns like we do for
    DATE and DATETIME columns.
    
    
    mysql-test/r/type_timestamp.result:
      Test case for bug #55779.
    mysql-test/t/type_timestamp.test:
      Test case for bug #55779.
    sql/item.cc:
      Bug #55779: select does not work properly in mysql server
                  Version "5.1.42 SUSE MySQL RPM"
      
      The stored_field_cmp_to_item function has been modified
      to take into account TIMESTAMP columns like we do for
      DATE and DATETIME.
    daa6d1f4
item.cc 212 KB