• Georgi Kodinov's avatar
    Bug #55565: debug assertion when ordering by expressions with user · 8b25c0e4
    Georgi Kodinov authored
    variable assignments
    
    The assert() that is firing is checking if expressions that can't be
    null return a NULL when evaluated.
    MAKEDATE() function can return NULL if the second argument is 
    less then or equal to 0. Thus its nullability depends not only on 
    the nullability of its arguments but also on their values.
    Fixed by (overoptimistically) setting MAKEDATE() to be nullable 
    despite the nullability of its arguments.
    Test added.
    Had to update one test result to reflect the metadata change.
    8b25c0e4
func_time.result 55.7 KB