diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/sysvars_star.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/sysvars_star.result | 113 |
1 files changed, 113 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/sysvars_star.result b/mysql-test/suite/sys_vars/r/sysvars_star.result new file mode 100644 index 00000000..eede5c17 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/sysvars_star.result @@ -0,0 +1,113 @@ +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 +drop user foo@localhost; +set global low_priority_updates=default; +uninstall soname 'sql_errlog'; |