• unknown's avatar
    Bug#29739: Incorrect time comparison in BETWEEN. · e08e63b1
    unknown authored
    Time values were compared by the BETWEEN function as strings. This led to a
    wrong result in cases when some of arguments are less than 100 hours and other
    are greater.
    
    Now if all 3 arguments of the BETWEEN function are of the TIME type then
    they are compared as integers.
    
    
    mysql-test/t/type_time.test:
      Added a tes tcase for the bug#29739: Incorrect time comparison in BETWEEN.
    mysql-test/r/type_time.result:
      Added a tes tcase for the bug#29739: Incorrect time comparison in BETWEEN.
    sql/item_cmpfunc.cc:
      Bug#29739: Incorrect time comparison in BETWEEN.
      Now if all 3 arguments of the BETWEEN function are of the TIME type then
      they are compared as integers.
    e08e63b1
item_cmpfunc.cc 123 KB