diff --git a/sql/sql_delete.cc b/sql/sql_delete.cc index 90ce62fc1fe..73de610cafd 100644 --- a/sql/sql_delete.cc +++ b/sql/sql_delete.cc @@ -995,7 +995,6 @@ bool Query_result_delete::send_data(THD *thd, List &) { // Check if using outer join and no row found, or row is already deleted if (table->has_null_row() || table->has_deleted_row()) continue; - table->file->position(table->record[0]); found_rows++; if (immediate) { @@ -1034,6 +1033,7 @@ bool Query_result_delete::send_data(THD *thd, List &) { error = 0; } } else { + table->file->position(table->record[0]); // Save deletes in a Unique object, to be carried out later. error = tempfile->unique_add((char *)table->file->ref); if (error) {