MySQL 5.6.14 Source Code Document
|
Go to the source code of this file.
Macros | |
#define | WARN_DEPRECATED(Thd, Old, New) |
#define | SELECT_DISTINCT (1ULL << 0) |
#define | SELECT_STRAIGHT_JOIN (1ULL << 1) |
#define | SELECT_DESCRIBE (1ULL << 2) |
#define | SELECT_SMALL_RESULT (1ULL << 3) |
#define | SELECT_BIG_RESULT (1ULL << 4) |
#define | OPTION_FOUND_ROWS (1ULL << 5) |
#define | OPTION_TO_QUERY_CACHE (1ULL << 6) |
#define | SELECT_NO_JOIN_CACHE (1ULL << 7) |
#define | OPTION_AUTOCOMMIT (1ULL << 8) |
#define | OPTION_BIG_SELECTS (1ULL << 9) |
#define | OPTION_LOG_OFF (1ULL << 10) |
#define | OPTION_QUOTE_SHOW_CREATE (1ULL << 11) |
#define | TMP_TABLE_ALL_COLUMNS (1ULL << 12) |
#define | OPTION_WARNINGS (1ULL << 13) |
#define | OPTION_AUTO_IS_NULL (1ULL << 14) |
#define | OPTION_FOUND_COMMENT (1ULL << 15) |
#define | OPTION_SAFE_UPDATES (1ULL << 16) |
#define | OPTION_BUFFER_RESULT (1ULL << 17) |
#define | OPTION_BIN_LOG (1ULL << 18) |
#define | OPTION_NOT_AUTOCOMMIT (1ULL << 19) |
#define | OPTION_BEGIN (1ULL << 20) |
#define | OPTION_TABLE_LOCK (1ULL << 21) |
#define | OPTION_QUICK (1ULL << 22) |
#define | SELECT_ALL (1ULL << 24) |
#define | OPTION_NO_FOREIGN_KEY_CHECKS (1ULL << 26) |
#define | OPTION_RELAXED_UNIQUE_CHECKS (1ULL << 27) |
#define | SELECT_NO_UNLOCK (1ULL << 28) |
#define | OPTION_SCHEMA_TABLE (1ULL << 29) |
#define | OPTION_SETUP_TABLES_DONE (1ULL << 30) |
#define | OPTION_SQL_NOTES (1ULL << 31) |
#define | TMP_TABLE_FORCE_MYISAM (1ULL << 32) |
#define | OPTION_PROFILING (1ULL << 33) |
#define | SELECT_HIGH_PRIORITY (1ULL << 34) |
#define | OPTION_MASTER_SQL_ERROR (1ULL << 35) |
#define | OPTION_ALLOW_BATCH (ULL(1) << 36) |
#define | OPTIMIZER_SWITCH_INDEX_MERGE (1ULL << 0) |
#define | OPTIMIZER_SWITCH_INDEX_MERGE_UNION (1ULL << 1) |
#define | OPTIMIZER_SWITCH_INDEX_MERGE_SORT_UNION (1ULL << 2) |
#define | OPTIMIZER_SWITCH_INDEX_MERGE_INTERSECT (1ULL << 3) |
#define | OPTIMIZER_SWITCH_ENGINE_CONDITION_PUSHDOWN (1ULL << 4) |
#define | OPTIMIZER_SWITCH_INDEX_CONDITION_PUSHDOWN (1ULL << 5) |
#define | OPTIMIZER_SWITCH_MRR (1ULL << 6) |
#define | OPTIMIZER_SWITCH_MRR_COST_BASED (1ULL << 7) |
#define | OPTIMIZER_SWITCH_BNL (1ULL << 8) |
#define | OPTIMIZER_SWITCH_BKA (1ULL << 9) |
#define | OPTIMIZER_SWITCH_MATERIALIZATION (1ULL << 10) |
#define | OPTIMIZER_SWITCH_SEMIJOIN (1ULL << 11) |
#define | OPTIMIZER_SWITCH_LOOSE_SCAN (1ULL << 12) |
#define | OPTIMIZER_SWITCH_FIRSTMATCH (1ULL << 13) |
#define | OPTIMIZER_SWITCH_SUBQ_MAT_COST_BASED (1ULL << 14) |
#define | OPTIMIZER_SWITCH_USE_INDEX_EXTENSIONS (1ULL << 15) |
#define | OPTIMIZER_SWITCH_LAST (1ULL << 16) |
#define | OPTIMIZER_SWITCH_ALL 1 |
#define | OPTIMIZER_SWITCH_DEFAULT |
#define | CONTEXT_ANALYSIS_ONLY_PREPARE 1 |
#define | CONTEXT_ANALYSIS_ONLY_VIEW 2 |
#define | CONTEXT_ANALYSIS_ONLY_DERIVED 4 |
#define | UNCACHEABLE_DEPENDENT 1 |
#define | UNCACHEABLE_RAND 2 |
#define | UNCACHEABLE_SIDEEFFECT 4 |
#define | UNCACHEABLE_EXPLAIN 8 |
forcing to save JOIN for explain | |
#define | UNCACHEABLE_UNITED 16 |
#define | UNCACHEABLE_CHECKOPTION 32 |
#define | IS_EQUAL_NO 0 |
#define | IS_EQUAL_YES 1 |
#define | IS_EQUAL_PACK_LENGTH 2 |
Mostly this file is used in the server. But a little part of it is used in mysqlbinlog too (definition of SELECT_DISTINCT and others). The consequence is that 90% of the file is wrapped in #ifndef MYSQL_CLIENT, except the part which must be in the server and in the client.
Definition in file sql_priv.h.
#define OPTIMIZER_SWITCH_ALL 1 |
If OPTIMIZER_SWITCH_ALL is defined, optimizer_switch flags for newer optimizer features (semijoin) will be available.
Definition at line 218 of file sql_priv.h.
#define OPTIMIZER_SWITCH_DEFAULT |
Definition at line 225 of file sql_priv.h.
#define OPTIMIZER_SWITCH_MRR (1ULL << 6) |
If this is off, MRR is never used.
Definition at line 196 of file sql_priv.h.
#define OPTIMIZER_SWITCH_MRR_COST_BASED (1ULL << 7) |
If OPTIMIZER_SWITCH_MRR is on and this is on, MRR is used depending on a cost-based choice ("automatic"). If OPTIMIZER_SWITCH_MRR is on and this is off, MRR is "forced" (i.e. used as long as the storage engine is capable of doing it).
Definition at line 203 of file sql_priv.h.
#define OPTION_AUTOCOMMIT (1ULL << 8) |
always the opposite of OPTION_NOT_AUTOCOMMIT except when in fix_autocommit()
Definition at line 89 of file sql_priv.h.
#define OPTION_MASTER_SQL_ERROR (1ULL << 35) |
Is set in slave SQL thread when there was an error on master, which, when is not reproducible on slave (i.e. the query succeeds on slave), is not terminal to the state of repliation, and should be ignored. The slave SQL thread, however, needs to rollback the effects of the succeeded statement to keep replication consistent.
Definition at line 141 of file sql_priv.h.
#define OPTION_NO_FOREIGN_KEY_CHECKS (1ULL << 26) |
The following can be set when importing tables in a 'wrong order' to suppress foreign key checks
Definition at line 110 of file sql_priv.h.
#define OPTION_RELAXED_UNIQUE_CHECKS (1ULL << 27) |
The following speeds up inserts to InnoDB tables by suppressing unique key checks in some cases
Definition at line 113 of file sql_priv.h.
#define OPTION_SETUP_TABLES_DONE (1ULL << 30) |
Flag set if setup_tables already done
Definition at line 117 of file sql_priv.h.
#define OPTION_SQL_NOTES (1ULL << 31) |
If not set then the thread will ignore all warnings with level notes.
Definition at line 119 of file sql_priv.h.
#define SELECT_HIGH_PRIORITY (1ULL << 34) |
Indicates that this is a HIGH_PRIORITY SELECT. Currently used only for printing of such selects. Type of locks to be acquired is specified directly.
Definition at line 131 of file sql_priv.h.
#define TMP_TABLE_FORCE_MYISAM (1ULL << 32) |
Force the used temporary table to be a MyISAM table (because we will use fulltext functions when reading from it.
Definition at line 124 of file sql_priv.h.
#define WARN_DEPRECATED | ( | Thd, | |
Old, | |||
New | |||
) |
Definition at line 45 of file sql_priv.h.