mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 05:12:17 +01:00
35e18c240b
this test loads sql_errlog plugin. then in a second connection it triggers an error, this locks the plugin in that thd. then the plugin is uninstalled in the default connection. but that doesn't unload the plugin, as it's still locked. it'll auto-unload after the foo connection is closed. without an explicit disconnect it is closed after mysqltest exits and the post-test check might still see sql_errlog not fully unoaded.
114 lines
3.4 KiB
Text
114 lines
3.4 KiB
Text
set completion_type=CHAIN;
|
|
set global low_priority_updates=1;
|
|
install soname 'sql_errlog';
|
|
select * from information_schema.system_variables
|
|
where variable_name in (
|
|
'completion_type', #session!=global, origin=compile-time
|
|
'low_priority_updates', #global!=default, origin=sql
|
|
'column_compression_threshold', #origin=command-line
|
|
'plugin_maturity', #origin=config
|
|
'sql_error_log_rate', #plugin, origin=command-line
|
|
'sql_error_log_rotations' #plugin, origin=config
|
|
)
|
|
order by variable_name;
|
|
VARIABLE_NAME COLUMN_COMPRESSION_THRESHOLD
|
|
SESSION_VALUE 120
|
|
GLOBAL_VALUE 120
|
|
GLOBAL_VALUE_ORIGIN COMMAND-LINE
|
|
DEFAULT_VALUE 100
|
|
VARIABLE_SCOPE SESSION
|
|
VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Minimum column data length eligible for compression
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 1
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
GLOBAL_VALUE_PATH NULL
|
|
VARIABLE_NAME COMPLETION_TYPE
|
|
SESSION_VALUE CHAIN
|
|
GLOBAL_VALUE NO_CHAIN
|
|
GLOBAL_VALUE_ORIGIN COMPILE-TIME
|
|
DEFAULT_VALUE NO_CHAIN
|
|
VARIABLE_SCOPE SESSION
|
|
VARIABLE_TYPE ENUM
|
|
VARIABLE_COMMENT The transaction completion type
|
|
NUMERIC_MIN_VALUE NULL
|
|
NUMERIC_MAX_VALUE NULL
|
|
NUMERIC_BLOCK_SIZE NULL
|
|
ENUM_VALUE_LIST NO_CHAIN,CHAIN,RELEASE
|
|
READ_ONLY NO
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
GLOBAL_VALUE_PATH NULL
|
|
VARIABLE_NAME LOW_PRIORITY_UPDATES
|
|
SESSION_VALUE OFF
|
|
GLOBAL_VALUE ON
|
|
GLOBAL_VALUE_ORIGIN SQL
|
|
DEFAULT_VALUE OFF
|
|
VARIABLE_SCOPE SESSION
|
|
VARIABLE_TYPE BOOLEAN
|
|
VARIABLE_COMMENT INSERTvar/UPDATE has lower priority than selects
|
|
NUMERIC_MIN_VALUE NULL
|
|
NUMERIC_MAX_VALUE NULL
|
|
NUMERIC_BLOCK_SIZE NULL
|
|
ENUM_VALUE_LIST OFF,ON
|
|
READ_ONLY NO
|
|
COMMAND_LINE_ARGUMENT OPTIONAL
|
|
GLOBAL_VALUE_PATH NULL
|
|
VARIABLE_NAME PLUGIN_MATURITY
|
|
SESSION_VALUE NULL
|
|
GLOBAL_VALUE alpha
|
|
GLOBAL_VALUE_ORIGIN CONFIG
|
|
DEFAULT_VALUE gamma
|
|
VARIABLE_SCOPE GLOBAL
|
|
VARIABLE_TYPE ENUM
|
|
VARIABLE_COMMENT The lowest desirable plugin maturity. Plugins less mature than that will not be installed or loaded
|
|
NUMERIC_MIN_VALUE NULL
|
|
NUMERIC_MAX_VALUE NULL
|
|
NUMERIC_BLOCK_SIZE NULL
|
|
ENUM_VALUE_LIST unknown,experimental,alpha,beta,gamma,stable
|
|
READ_ONLY YES
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
GLOBAL_VALUE_PATH var/my.cnf
|
|
VARIABLE_NAME SQL_ERROR_LOG_RATE
|
|
SESSION_VALUE NULL
|
|
GLOBAL_VALUE 100
|
|
GLOBAL_VALUE_ORIGIN COMMAND-LINE
|
|
DEFAULT_VALUE 1
|
|
VARIABLE_SCOPE GLOBAL
|
|
VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Sampling rate. If set to 0(zero), the logging is disabled.
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 1000000
|
|
NUMERIC_BLOCK_SIZE 1
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
GLOBAL_VALUE_PATH NULL
|
|
VARIABLE_NAME SQL_ERROR_LOG_ROTATIONS
|
|
SESSION_VALUE NULL
|
|
GLOBAL_VALUE 5
|
|
GLOBAL_VALUE_ORIGIN CONFIG
|
|
DEFAULT_VALUE 9
|
|
VARIABLE_SCOPE GLOBAL
|
|
VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of rotations before log is removed.
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 999
|
|
NUMERIC_BLOCK_SIZE 1
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY YES
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
GLOBAL_VALUE_PATH var/my.cnf
|
|
create user foo@localhost;
|
|
connect foo,localhost,foo;
|
|
select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
|
|
global_value_path NULL
|
|
connection default;
|
|
select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
|
|
global_value_path var/my.cnf
|
|
disconnect foo;
|
|
drop user foo@localhost;
|
|
set global low_priority_updates=default;
|
|
uninstall soname 'sql_errlog';
|