293 lines
10 KiB
Plaintext
293 lines
10 KiB
Plaintext
# TestMaxDeltaSchemaCount
|
|
set @@global.tidb_max_delta_schema_count= -1;
|
|
show warnings;
|
|
select @@global.tidb_max_delta_schema_count;
|
|
set @@global.tidb_max_delta_schema_count= 9223372036854775807;
|
|
show warnings;
|
|
select @@global.tidb_max_delta_schema_count;
|
|
-- error 1232
|
|
set @@global.tidb_max_delta_schema_count= invalid_val;
|
|
set @@global.tidb_max_delta_schema_count= 2048;
|
|
select @@global.tidb_max_delta_schema_count;
|
|
set @@global.tidb_max_delta_schema_count= default;
|
|
|
|
# TestGetSetNoopVars
|
|
SELECT @@innodb_buffer_pool_size;
|
|
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
|
|
SET GLOBAL innodb_buffer_pool_size=134217728;
|
|
SELECT @@innodb_buffer_pool_size;
|
|
SET GLOBAL tidb_enable_noop_variables = OFF;
|
|
SELECT @@global.tidb_enable_noop_variables;
|
|
SELECT @@innodb_buffer_pool_size;
|
|
SHOW WARNINGS;
|
|
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
|
|
SET GLOBAL innodb_buffer_pool_size = 805306368;
|
|
SHOW WARNINGS;
|
|
SELECT @@innodb_buffer_pool_size;
|
|
-- error 1231
|
|
SET GLOBAL tidb_enable_noop_variables = 2;
|
|
-- error 1231
|
|
SET GLOBAL tidb_enable_noop_variables = 'warn';
|
|
SET GLOBAL tidb_enable_noop_variables = ON;
|
|
|
|
SET GLOBAL tidb_enable_noop_variables = default;
|
|
SET GLOBAL innodb_buffer_pool_size = default;
|
|
|
|
# TestSetCharset
|
|
show VARIABLES like 'character_set_%';
|
|
SET NAMES latin1;
|
|
show VARIABLES like 'character_set_%';
|
|
SET NAMES default;
|
|
show VARIABLES like 'character_set_%';
|
|
SET NAMES binary;
|
|
show VARIABLES like 'character_set_%';
|
|
SET NAMES utf8;
|
|
show VARIABLES like 'character_set_%';
|
|
SET CHARACTER SET latin1;
|
|
show VARIABLES like 'character_set_%';
|
|
SET CHARACTER SET default;
|
|
show VARIABLES like 'character_set_%';
|
|
|
|
set names default;
|
|
|
|
# TestSelectGlobalVar
|
|
select @@global.max_connections;
|
|
select @@max_connections;
|
|
set @@global.max_connections=100;
|
|
select @@global.max_connections;
|
|
select @@max_connections;
|
|
set @@global.max_connections=0;
|
|
-- error 1193
|
|
select @@invalid;
|
|
-- error 1193
|
|
select @@global.invalid;
|
|
|
|
set @@global.max_connections=default;
|
|
|
|
# TestDefaultBehavior
|
|
# https://github.com/pingcap/tidb/issues/29670
|
|
SELECT @@default_storage_engine;
|
|
SET GLOBAL default_storage_engine = 'somethingweird';
|
|
SET default_storage_engine = 'MyISAM';
|
|
SELECT @@default_storage_engine;
|
|
SET default_storage_engine = DEFAULT;
|
|
SELECT @@default_storage_engine;
|
|
SET @@SESSION.default_storage_engine = @@GLOBAL.default_storage_engine;
|
|
SELECT @@default_storage_engine;
|
|
SET GLOBAL default_storage_engine = 'somethingweird2';
|
|
SET default_storage_engine = @@GLOBAL.default_storage_engine;
|
|
SELECT @@default_storage_engine;
|
|
SET default_storage_engine = DEFAULT;
|
|
SET GLOBAL default_storage_engine = DEFAULT;
|
|
SELECT @@SESSION.default_storage_engine, @@GLOBAL.default_storage_engine;
|
|
-- error 1105
|
|
SET GLOBAL sql_mode = 'DEFAULT';
|
|
SET GLOBAL sql_mode = DEFAULT;
|
|
|
|
set @@SESSION.default_storage_engine=default;
|
|
SET GLOBAL default_storage_engine=default;
|
|
|
|
# TestTiDBReadOnly
|
|
SET GLOBAL tidb_restricted_read_only = ON;
|
|
SELECT @@GLOBAL.tidb_super_read_only;
|
|
-- error 1105
|
|
SET GLOBAL tidb_super_read_only = OFF;
|
|
SET GLOBAL tidb_restricted_read_only = OFF;
|
|
SELECT @@GLOBAL.tidb_restricted_read_only;
|
|
SELECT @@GLOBAL.tidb_super_read_only;
|
|
SET GLOBAL tidb_super_read_only = OFF;
|
|
SELECT @@GLOBAL.tidb_super_read_only;
|
|
|
|
SET GLOBAL tidb_super_read_only = default;
|
|
SET GLOBAL tidb_restricted_read_only = default;
|
|
|
|
# TestRemovedSysVars
|
|
SET tidb_enable_global_temporary_table = 1;
|
|
SET tidb_slow_log_masking = 1;
|
|
SET GLOBAL tidb_enable_global_temporary_table = 1;
|
|
SET GLOBAL tidb_slow_log_masking = 1;
|
|
-- error 8136
|
|
SELECT @@tidb_slow_log_masking;
|
|
-- error 8136
|
|
SELECT @@tidb_enable_global_temporary_table;
|
|
|
|
SET tidb_enable_global_temporary_table = default;
|
|
SET tidb_slow_log_masking = default;
|
|
SET GLOBAL tidb_enable_global_temporary_table = default;
|
|
SET GLOBAL tidb_slow_log_masking = default;
|
|
|
|
# TestPreparePlanCacheValid
|
|
select @@global.tidb_session_plan_cache_size;
|
|
SET GLOBAL tidb_session_plan_cache_size = 0;
|
|
show warnings;
|
|
select @@global.tidb_session_plan_cache_size;
|
|
SET GLOBAL tidb_session_plan_cache_size = 2;
|
|
select @@global.tidb_session_plan_cache_size;
|
|
select @@session.tidb_session_plan_cache_size;
|
|
SET SESSION tidb_session_plan_cache_size = 0;
|
|
show warnings;
|
|
select @@session.tidb_session_plan_cache_size;
|
|
SET SESSION tidb_session_plan_cache_size = 2;
|
|
select @@session.tidb_session_plan_cache_size;
|
|
SET GLOBAL tidb_prepared_plan_cache_memory_guard_ratio = -0.1;
|
|
show warnings;
|
|
select @@global.tidb_prepared_plan_cache_memory_guard_ratio;
|
|
SET GLOBAL tidb_prepared_plan_cache_memory_guard_ratio = 2.2;
|
|
show warnings;
|
|
select @@global.tidb_prepared_plan_cache_memory_guard_ratio;
|
|
SET GLOBAL tidb_prepared_plan_cache_memory_guard_ratio = 0.5;
|
|
select @@global.tidb_prepared_plan_cache_memory_guard_ratio;
|
|
SET GLOBAL tidb_enable_prepared_plan_cache = 0;
|
|
select @@global.tidb_enable_prepared_plan_cache;
|
|
SET GLOBAL tidb_enable_prepared_plan_cache = 1;
|
|
select @@global.tidb_enable_prepared_plan_cache;
|
|
SET GLOBAL tidb_enable_prepared_plan_cache = 0;
|
|
select @@global.tidb_enable_prepared_plan_cache;
|
|
|
|
SET GLOBAL tidb_enable_prepared_plan_cache = default;
|
|
SET GLOBAL tidb_prepared_plan_cache_memory_guard_ratio = default;
|
|
SET SESSION tidb_session_plan_cache_size = default;
|
|
SET GLOBAL tidb_session_plan_cache_size = default;
|
|
|
|
# TestInstanceScopeSwitching
|
|
set tidb_enable_legacy_instance_scope = 1;
|
|
set tidb_general_log = 1;
|
|
show warnings;
|
|
set tidb_enable_legacy_instance_scope = 0;
|
|
-- error 1229
|
|
set tidb_general_log = 1;
|
|
|
|
set tidb_enable_legacy_instance_scope = default;
|
|
set tidb_general_log = default;
|
|
|
|
# TestGcMaxWaitTime
|
|
set global tidb_gc_max_wait_time = 1000;
|
|
set global tidb_gc_life_time = "72h";
|
|
set global tidb_gc_life_time = "24h";
|
|
set global tidb_gc_life_time = "10m";
|
|
set global tidb_gc_max_wait_time = 86400;
|
|
set global tidb_gc_life_time = "72h";
|
|
set global tidb_gc_max_wait_time = 1000;
|
|
|
|
set global tidb_gc_life_time = default;
|
|
set global tidb_gc_max_wait_time = default;
|
|
|
|
# TestTiFlashFineGrainedShuffle
|
|
select @@tiflash_fine_grained_shuffle_stream_count;
|
|
set @@tiflash_fine_grained_shuffle_stream_count = 0;
|
|
select @@tiflash_fine_grained_shuffle_stream_count;
|
|
set @@tiflash_fine_grained_shuffle_stream_count = -2;
|
|
select @@tiflash_fine_grained_shuffle_stream_count;
|
|
set @@tiflash_fine_grained_shuffle_stream_count = 0;
|
|
select @@tiflash_fine_grained_shuffle_stream_count;
|
|
set @@tiflash_fine_grained_shuffle_stream_count = 1024;
|
|
select @@tiflash_fine_grained_shuffle_stream_count;
|
|
set @@tiflash_fine_grained_shuffle_stream_count = 1025;
|
|
select @@tiflash_fine_grained_shuffle_stream_count;
|
|
select @@tiflash_fine_grained_shuffle_batch_size;
|
|
set @@tiflash_fine_grained_shuffle_batch_size = 0;
|
|
select @@tiflash_fine_grained_shuffle_batch_size;
|
|
set @@tiflash_fine_grained_shuffle_batch_size = -1;
|
|
select @@tiflash_fine_grained_shuffle_batch_size;
|
|
set @@tiflash_fine_grained_shuffle_batch_size = 18446744073709551615;
|
|
select @@tiflash_fine_grained_shuffle_batch_size;
|
|
set global tiflash_fine_grained_shuffle_stream_count = -1;
|
|
set global tiflash_fine_grained_shuffle_batch_size = 8192;
|
|
|
|
set @@tiflash_fine_grained_shuffle_batch_size = default;
|
|
set @@tiflash_fine_grained_shuffle_stream_count = default;
|
|
set global tiflash_fine_grained_shuffle_stream_count = default;
|
|
set global tiflash_fine_grained_shuffle_batch_size = default;
|
|
|
|
# TestSetTiFlashFastScanVariable
|
|
drop table if exists t;
|
|
create table t(a int);
|
|
insert into t values(1);
|
|
select @@session.tiflash_fastscan;
|
|
select @@global.tiflash_fastscan;
|
|
set @@tiflash_fastscan=ON;
|
|
select @@session.tiflash_fastscan;
|
|
set global tiflash_fastscan=OFF;
|
|
select @@global.tiflash_fastscan;
|
|
|
|
set global tiflash_fastscan=default;
|
|
set @@tiflash_fastscan=default;
|
|
|
|
# TestSetPlanCacheMemoryMonitor
|
|
select @@session.tidb_enable_prepared_plan_cache_memory_monitor;
|
|
select @@global.tidb_enable_prepared_plan_cache_memory_monitor;
|
|
set @@session.tidb_enable_prepared_plan_cache_memory_monitor=OFF;
|
|
select @@session.tidb_enable_prepared_plan_cache_memory_monitor;
|
|
set @@session.tidb_enable_prepared_plan_cache_memory_monitor=1;
|
|
select @@session.tidb_enable_prepared_plan_cache_memory_monitor;
|
|
set @@global.tidb_enable_prepared_plan_cache_memory_monitor=off;
|
|
select @@global.tidb_enable_prepared_plan_cache_memory_monitor;
|
|
|
|
set @@session.tidb_enable_prepared_plan_cache_memory_monitor=default;
|
|
set @@global.tidb_enable_prepared_plan_cache_memory_monitor=default;
|
|
|
|
# TestSetChunkReuseVariable
|
|
set @@tidb_enable_reuse_chunk=ON;
|
|
select @@session.tidb_enable_reuse_chunk;
|
|
set GLOBAL tidb_enable_reuse_chunk=ON;
|
|
select @@global.tidb_enable_reuse_chunk;
|
|
set @@tidb_enable_reuse_chunk=OFF;
|
|
select @@session.tidb_enable_reuse_chunk;
|
|
set GLOBAL tidb_enable_reuse_chunk=OFF;
|
|
select @@global.tidb_enable_reuse_chunk;
|
|
-- error 1231
|
|
set @@tidb_enable_reuse_chunk=s;
|
|
|
|
set @@tidb_enable_reuse_chunk=default;
|
|
set GLOBAL tidb_enable_reuse_chunk=default;
|
|
|
|
# TestSetMppVersionVariable
|
|
select @@session.mpp_version;
|
|
SET SESSION mpp_version = -1;
|
|
select @@session.mpp_version;
|
|
SET SESSION mpp_version = 0;
|
|
select @@session.mpp_version;
|
|
SET SESSION mpp_version = 1;
|
|
select @@session.mpp_version;
|
|
SET SESSION mpp_version = 2;
|
|
select @@session.mpp_version;
|
|
SET SESSION mpp_version = unspecified;
|
|
select @@session.mpp_version;
|
|
-- error 1105
|
|
SET SESSION mpp_version = 4;
|
|
SET GLOBAL mpp_version = 1;
|
|
select @@global.mpp_version;
|
|
SET GLOBAL mpp_version = -1;
|
|
select @@global.mpp_version;
|
|
|
|
SET SESSION mpp_version = default;
|
|
set global mpp_version = default;
|
|
|
|
# TestSetMppExchangeCompressionModeVariable
|
|
-- error 1105
|
|
SET SESSION mpp_exchange_compression_mode = 123;
|
|
select @@session.mpp_exchange_compression_mode;
|
|
SET SESSION mpp_exchange_compression_mode = none;
|
|
select @@session.mpp_exchange_compression_mode;
|
|
SET SESSION mpp_exchange_compression_mode = fast;
|
|
select @@session.mpp_exchange_compression_mode;
|
|
SET SESSION mpp_exchange_compression_mode = HIGH_COMPRESSION;
|
|
select @@session.mpp_exchange_compression_mode;
|
|
SET GLOBAL mpp_exchange_compression_mode = none;
|
|
select @@global.mpp_exchange_compression_mode;
|
|
SET mpp_version = 0;
|
|
SET mpp_exchange_compression_mode = unspecified;
|
|
SET mpp_version = 0;
|
|
SET mpp_exchange_compression_mode = HIGH_COMPRESSION;
|
|
|
|
SET mpp_version = default;
|
|
SET mpp_exchange_compression_mode = default;
|
|
set @@global.mpp_exchange_compression_mode = default;
|
|
|
|
# TestDeprecateEnableTiFlashPipelineModel
|
|
set @@global.tidb_enable_tiflash_pipeline_model = 1;
|
|
show warnings;
|
|
|
|
set @@global.tidb_enable_tiflash_pipeline_model = default;
|
|
|