• unknown's avatar
    Fixed bug #26124: SELECT from a view wrapper over a table · 3a54e593
    unknown authored
    with a column of the DATETIME type could return a wrong 
    result set if the WHERE clause included a BETWEEN condition
    on the column.
    Fixed the method Item_func_between::fix_length_and_dec
    where the aggregation type for BETWEEN predicates calculated
    incorrectly if the first argument was a view column of the
    DATETIME type.
    
    
    mysql-test/r/view.result:
      Added a test case for bug #26124.
    mysql-test/t/view.test:
      Added a test case for bug #26124.
    3a54e593
view.test 76.3 KB