You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
143 lines
4.8 KiB
143 lines
4.8 KiB
5 months ago
|
/* Copyright (c) 2006, 2018, Oracle and/or its affiliates. All rights reserved.
|
||
|
|
|
||
|
|
This program is free software; you can redistribute it and/or modify
|
||
|
|
it under the terms of the GNU General Public License, version 2.0,
|
||
|
|
as published by the Free Software Foundation.
|
||
|
|
|
||
|
|
This program is also distributed with certain software (including
|
||
|
|
but not limited to OpenSSL) that is licensed under separate terms,
|
||
|
|
as designated in a particular file or component or in included license
|
||
|
|
documentation. The authors of MySQL hereby grant you an additional
|
||
|
|
permission to link the program and your derivative works with the
|
||
|
|
separately licensed software that they have included with MySQL.
|
||
|
|
|
||
|
|
This program is distributed in the hope that it will be useful,
|
||
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
|
|
GNU General Public License, version 2.0, for more details.
|
||
|
|
|
||
|
|
You should have received a copy of the GNU General Public License
|
||
|
|
along with this program; if not, write to the Free Software
|
||
|
|
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
|
||
|
|
|
||
|
|
#ifndef SQL_DELETE_INCLUDED
|
||
|
|
#define SQL_DELETE_INCLUDED
|
||
|
|
|
||
|
|
#include <stddef.h>
|
||
|
|
#include <sys/types.h>
|
||
|
|
|
||
|
|
#include "my_base.h" // ha_rows
|
||
|
|
#include "my_sqlcommand.h"
|
||
|
|
#include "my_table_map.h"
|
||
|
|
#include "sql/query_result.h" // Query_result_interceptor
|
||
|
|
#include "sql/sql_cmd_dml.h" // Sql_cmd_dml
|
||
|
|
|
||
|
|
class Item;
|
||
|
|
class SELECT_LEX_UNIT;
|
||
|
|
class THD;
|
||
|
|
class Unique;
|
||
|
|
struct TABLE;
|
||
|
|
struct TABLE_LIST;
|
||
|
|
template <class T>
|
||
|
|
class List;
|
||
|
|
template <typename T>
|
||
|
|
class SQL_I_List;
|
||
|
|
|
||
|
|
class Query_result_delete final : public Query_result_interceptor {
|
||
|
|
/// Pointers to temporary files used for delayed deletion of rows
|
||
|
|
Unique **tempfiles;
|
||
|
|
/// Pointers to table objects matching tempfiles
|
||
|
|
TABLE **tables;
|
||
|
|
/// Number of tables being deleted from
|
||
|
|
uint delete_table_count;
|
||
|
|
/// Number of rows produced by the join
|
||
|
|
ha_rows found_rows;
|
||
|
|
/// Number of rows deleted
|
||
|
|
ha_rows deleted_rows;
|
||
|
|
/// Handler error status for the operation.
|
||
|
|
int error;
|
||
|
|
/// Map of all tables to delete rows from
|
||
|
|
table_map delete_table_map;
|
||
|
|
/// Map of tables to delete from immediately
|
||
|
|
table_map delete_immediate;
|
||
|
|
// Map of transactional tables to be deleted from
|
||
|
|
table_map transactional_table_map;
|
||
|
|
/// Map of non-transactional tables to be deleted from
|
||
|
|
table_map non_transactional_table_map;
|
||
|
|
/// True if the full delete operation is complete
|
||
|
|
bool delete_completed;
|
||
|
|
/// True if some actual delete operation against non-transactional table done
|
||
|
|
bool non_transactional_deleted;
|
||
|
|
/*
|
||
|
|
error handling (rollback and binlogging) can happen in send_eof()
|
||
|
|
so that afterward send_error() needs to find out that.
|
||
|
|
*/
|
||
|
|
bool error_handled;
|
||
|
|
|
||
|
|
public:
|
||
|
|
Query_result_delete()
|
||
|
|
: Query_result_interceptor(),
|
||
|
|
tempfiles(NULL),
|
||
|
|
tables(NULL),
|
||
|
|
delete_table_count(0),
|
||
|
|
found_rows(0),
|
||
|
|
deleted_rows(0),
|
||
|
|
error(0),
|
||
|
|
delete_table_map(0),
|
||
|
|
delete_immediate(0),
|
||
|
|
transactional_table_map(0),
|
||
|
|
non_transactional_table_map(0),
|
||
|
|
delete_completed(false),
|
||
|
|
non_transactional_deleted(false),
|
||
|
|
error_handled(false) {}
|
||
|
|
bool need_explain_interceptor() const override { return true; }
|
||
|
|
bool prepare(THD *thd, List<Item> &list, SELECT_LEX_UNIT *u) override;
|
||
|
|
bool send_data(THD *thd, List<Item> &items) override;
|
||
|
|
void send_error(THD *thd, uint errcode, const char *err) override;
|
||
|
|
bool optimize() override;
|
||
|
|
bool start_execution(THD *) override {
|
||
|
|
delete_completed = false;
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
int do_deletes(THD *thd);
|
||
|
|
int do_table_deletes(THD *thd, TABLE *table);
|
||
|
|
bool send_eof(THD *thd) override;
|
||
|
|
inline ha_rows num_deleted() { return deleted_rows; }
|
||
|
|
void abort_result_set(THD *thd) override;
|
||
|
|
void cleanup(THD *thd) override;
|
||
|
|
};
|
||
|
|
|
||
|
|
class Sql_cmd_delete final : public Sql_cmd_dml {
|
||
|
|
public:
|
||
|
|
Sql_cmd_delete(bool multitable_arg, SQL_I_List<TABLE_LIST> *delete_tables_arg)
|
||
|
|
: multitable(multitable_arg), delete_tables(delete_tables_arg) {}
|
||
|
|
|
||
|
|
enum_sql_command sql_command_code() const override {
|
||
|
|
return multitable ? SQLCOM_DELETE_MULTI : SQLCOM_DELETE;
|
||
|
|
}
|
||
|
|
|
||
|
|
bool is_single_table_plan() const override { return !multitable; }
|
||
|
|
|
||
|
|
virtual bool accept(THD *thd, Select_lex_visitor *visitor) override;
|
||
|
|
|
||
|
|
protected:
|
||
|
|
bool precheck(THD *thd) override;
|
||
|
|
|
||
|
|
bool prepare_inner(THD *thd) override;
|
||
|
|
|
||
|
|
bool execute_inner(THD *thd) override;
|
||
|
|
|
||
|
|
private:
|
||
|
|
bool delete_from_single_table(THD *thd);
|
||
|
|
|
||
|
|
bool multitable;
|
||
|
|
/**
|
||
|
|
References to tables that are deleted from in a multitable delete statement.
|
||
|
|
Only used to track such tables from the parser. In preparation and
|
||
|
|
optimization, use the TABLE_LIST::updating property instead.
|
||
|
|
*/
|
||
|
|
SQL_I_List<TABLE_LIST> *delete_tables;
|
||
|
|
};
|
||
|
|
|
||
|
|
#endif /* SQL_DELETE_INCLUDED */
|