• Kristofer Pettersson's avatar
    Bug#40127 Multiple table DELETE IGNORE hangs on foreign key constraint violation · 137f1e1e
    Kristofer Pettersson authored
              on 5.0            
    The server crashes on an assert in net_end_statement indicating that the
    Diagnostics area wasn't set properly during execution.
    This happened on a multi table DELETE operation using the IGNORE keyword.
    The keyword is suppose to allow for execution to continue on a best effort
    despite some non-fatal errors. Instead execution stopped and no client
    response was sent which would have led to a protocol error if it hadn't been
    for the assert.
    This patch corrects this issue by checking for the existence of an IGNORE
    option before setting an error state during row-by-row delete iteration.
    137f1e1e
innodb_mysql.test 8.37 KB