• Igor Babaev's avatar
    Fixed mdev-14911: zero_date is considered as NULL, depending on · 6267be46
    Igor Babaev authored
    optimizer_switch
    
    For DATE and DATETIME columns defined as NOT NULL,
    "date_notnull IS NULL" has to be modified to:
    "date_notnull IS NULL OR date_notnull == 0"
    if date_notnull is from an inner table of outer join);
    "date_notnull == 0" - otherwise.
    
    This must hold for such columns of mergeable views and derived
    tables as well. So far the code did the above re-writing only
    for columns of base tables and temporary tables.
    6267be46
func_isnull.test 2.36 KB