MySQL 9.0.0
Source Code Documentation
query_options.h File Reference

Go to the source code of this file.

Macros

#define SELECT_DISTINCT   (1ULL << 0)
 
#define SELECT_STRAIGHT_JOIN   (1ULL << 1)
 
#define SELECT_SMALL_RESULT   (1ULL << 3)
 
#define SELECT_BIG_RESULT   (1ULL << 4)
 
#define OPTION_FOUND_ROWS    (1ULL << 5)
 
#define SELECT_NO_JOIN_CACHE   (1ULL << 7)
 
#define OPTION_AUTOCOMMIT   (1ULL << 8)
 always the opposite of OPTION_NOT_AUTOCOMMIT except when in fix_autocommit() More...
 
#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 OPTION_NO_CONST_TABLES   (1ULL << 23)
 
#define SELECT_ALL   (1ULL << 24)
 
#define SELECT_NO_SEMI_JOIN   (1ULL << 25)
 
#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. More...
 
#define OPTION_RELAXED_UNIQUE_CHECKS   (1ULL << 27)
 The following speeds up inserts to InnoDB tables by suppressing unique key checks in some cases. More...
 
#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)
 If not set then the thread will ignore all warnings with level notes. More...
 
#define OPTION_PROFILING   (1ULL << 33)
 (1ULL << 32) is not used after removing TMP_TABLE_FORCE_MYISAM option More...
 
#define SELECT_HIGH_PRIORITY   (1ULL << 34)
 Indicates that this is a HIGH_PRIORITY SELECT. More...
 
#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. More...
 
#define OPTION_ALLOW_BATCH   (1ULL << 36)
 
#define OPTION_SELECT_FOR_SHOW   (1ULL << 37)
 
#define OPTION_DD_UPDATE_CONTEXT   (1ULL << 38)
 
#define OPTION_NO_SUBQUERY_DURING_OPTIMIZATION   (1ULL << 39)
 If this option is set, subqueries should not be evaluated during optimization, even if they are known to produce a constant result. More...
 

Detailed Description

This file is used in the server, and the mysqlbinlog client.

Macro Definition Documentation

◆ OPTION_ALLOW_BATCH

#define OPTION_ALLOW_BATCH   (1ULL << 36)

◆ OPTION_AUTO_IS_NULL

#define OPTION_AUTO_IS_NULL   (1ULL << 14)

◆ OPTION_AUTOCOMMIT

#define OPTION_AUTOCOMMIT   (1ULL << 8)

always the opposite of OPTION_NOT_AUTOCOMMIT except when in fix_autocommit()

◆ OPTION_BEGIN

#define OPTION_BEGIN   (1ULL << 20)

◆ OPTION_BIG_SELECTS

#define OPTION_BIG_SELECTS   (1ULL << 9)

◆ OPTION_BIN_LOG

#define OPTION_BIN_LOG   (1ULL << 18)

◆ OPTION_BUFFER_RESULT

#define OPTION_BUFFER_RESULT   (1ULL << 17)

◆ OPTION_DD_UPDATE_CONTEXT

#define OPTION_DD_UPDATE_CONTEXT   (1ULL << 38)

◆ OPTION_FOUND_COMMENT

#define OPTION_FOUND_COMMENT   (1ULL << 15)

◆ OPTION_FOUND_ROWS

#define OPTION_FOUND_ROWS    (1ULL << 5)

◆ OPTION_LOG_OFF

#define OPTION_LOG_OFF   (1ULL << 10)

◆ OPTION_MASTER_SQL_ERROR

#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 replication, and should be ignored. The slave SQL thread, however, needs to rollback the effects of the succeeded statement to keep replication consistent.

◆ OPTION_NO_CONST_TABLES

#define OPTION_NO_CONST_TABLES   (1ULL << 23)

◆ OPTION_NO_FOREIGN_KEY_CHECKS

#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.

◆ OPTION_NO_SUBQUERY_DURING_OPTIMIZATION

#define OPTION_NO_SUBQUERY_DURING_OPTIMIZATION   (1ULL << 39)

If this option is set, subqueries should not be evaluated during optimization, even if they are known to produce a constant result.

◆ OPTION_NOT_AUTOCOMMIT

#define OPTION_NOT_AUTOCOMMIT   (1ULL << 19)

◆ OPTION_PROFILING

#define OPTION_PROFILING   (1ULL << 33)

(1ULL << 32) is not used after removing TMP_TABLE_FORCE_MYISAM option

◆ OPTION_QUICK

#define OPTION_QUICK   (1ULL << 22)

◆ OPTION_QUOTE_SHOW_CREATE

#define OPTION_QUOTE_SHOW_CREATE   (1ULL << 11)

◆ OPTION_RELAXED_UNIQUE_CHECKS

#define OPTION_RELAXED_UNIQUE_CHECKS   (1ULL << 27)

The following speeds up inserts to InnoDB tables by suppressing unique key checks in some cases.

◆ OPTION_SAFE_UPDATES

#define OPTION_SAFE_UPDATES   (1ULL << 16)

◆ OPTION_SCHEMA_TABLE

#define OPTION_SCHEMA_TABLE   (1ULL << 29)

◆ OPTION_SELECT_FOR_SHOW

#define OPTION_SELECT_FOR_SHOW   (1ULL << 37)

◆ OPTION_SETUP_TABLES_DONE

#define OPTION_SETUP_TABLES_DONE   (1ULL << 30)

◆ OPTION_SQL_NOTES

#define OPTION_SQL_NOTES   (1ULL << 31)

If not set then the thread will ignore all warnings with level notes.

◆ OPTION_TABLE_LOCK

#define OPTION_TABLE_LOCK   (1ULL << 21)

◆ OPTION_WARNINGS

#define OPTION_WARNINGS   (1ULL << 13)

◆ SELECT_ALL

#define SELECT_ALL   (1ULL << 24)

◆ SELECT_BIG_RESULT

#define SELECT_BIG_RESULT   (1ULL << 4)

◆ SELECT_DISTINCT

#define SELECT_DISTINCT   (1ULL << 0)

◆ SELECT_HIGH_PRIORITY

#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.

◆ SELECT_NO_JOIN_CACHE

#define SELECT_NO_JOIN_CACHE   (1ULL << 7)

◆ SELECT_NO_SEMI_JOIN

#define SELECT_NO_SEMI_JOIN   (1ULL << 25)

◆ SELECT_NO_UNLOCK

#define SELECT_NO_UNLOCK   (1ULL << 28)

◆ SELECT_SMALL_RESULT

#define SELECT_SMALL_RESULT   (1ULL << 3)

◆ SELECT_STRAIGHT_JOIN

#define SELECT_STRAIGHT_JOIN   (1ULL << 1)

◆ TMP_TABLE_ALL_COLUMNS

#define TMP_TABLE_ALL_COLUMNS   (1ULL << 12)