• kroki/tomash@moonlight.intranet's avatar
    BUG#17047: CHAR() and IN() can return NULL without signaling NULL result · b8d54515
    kroki/tomash@moonlight.intranet authored
    The problem was that some functions (namely IN() starting with 4.1, and
    CHAR() starting with 5.0) were returning NULL in certain conditions,
    while they didn't set their maybe_null flag.  Because of that there could
    be some problems with 'IS NULL' check, and statements that depend on the
    function value domain, like CREATE TABLE t1 SELECT 1 IN (2, NULL);.
    
    The fix is to set maybe_null correctly.
    b8d54515
item_cmpfunc.cc 70.2 KB