• Dmitry Shulga's avatar
    MDEV-33549: Incorrect handling of UPDATE in PS mode in case a table's colum declared as NOT NULL · 428a6731
    Dmitry Shulga authored
    UPDATE statement that is run in PS mode and uses positional parameter
    handles columns declared with the clause DEFAULT NULL incorrectly in
    case the clause DEFAULT is passed as actual value for the positional
    parameter of the prepared statement. Similar issue happens in case
    an expression specified in the DEFAULT clause of table's column definition.
    
    The reason for incorrect processing of columns declared as DEFAULT NULL
    is that setting of null flag for a field being updated was missed
    in implementation of the method Item_param::assign_default().
    The reason for incorrect handling of an expression in DEFAULT clause is
    also missed saving of a field inside implementation of the method
    Item_param::assign_default().
    428a6731
item.cc 301 KB