• Daniel Black's avatar
    MDEV-29540 Incorrect sequence values in INSERT SELECT · 8c389393
    Daniel Black authored
    The population of default values in INSERT SELECT was being
    performed twice. With sequences, this resulted in every
    second sequence value being used.
    
    With SELECT INSERT we remove the second invokation of
    table->update_default_fields(). This was already performed
    in store_values() invoking fill_record_n_invoke_before_triggers()
    which invoked update_default_fields() previously.
    
    We do need to return an error on duplicate values, so the
    ::store_values is extended to take the ignore option.
    8c389393
sql_insert.cc 161 KB