• unknown's avatar
    Bug#19844: time_format in Union truncates values · 95617d18
    unknown authored
    time_format() claimed %H and %k would return at most two digits
    (hours 0-23), but this coincided neither with actual behaviour
    nor with docs.  this is not visible in simple queries; forcing
    a temp-table is probably the easiest way to see this.  adjusted
    the return-length appropriately; the alternative would be to
    adjust the docs to say that behaviour for > 99 hours is undefined.
    ---
    Bug#19844: time_format in Union truncates values
    
    time_format() claimed %H and %k would return at most two digits
    (hours 0-23), but this coincided neither with actual behaviour
    nor with docs.  this is not visible in simple queries; forcing
    a temp-table is probably the easiest way to see this.  adjusted
    the return-length appropriately; the alternative would be to
    adjust the docs to say that behaviour for > 99 hours is undefined.
    
    
    mysql-test/r/func_time.result:
      Bug#19844: time_format in Union truncates values
      
      show time_format() handles %H and %k correctly four > 99 hours
    m...
    95617d18
func_time.result 33.9 KB