1set @save_session_track_system_variables=@@session_track_system_variables; 2SELECT @@session.character_set_connection; 3@@session.character_set_connection 4latin1 5SET @@session.session_track_system_variables='character_set_connection'; 6# tracking info on 7SET NAMES 'utf8'; 8-- Tracker : SESSION_TRACK_SYSTEM_VARIABLES 9-- character_set_connection 10-- utf8 11 12SET NAMES 'big5'; 13-- Tracker : SESSION_TRACK_SYSTEM_VARIABLES 14-- character_set_connection 15-- big5 16 17# tracking info on once 18SET NAMES 'utf8'; 19-- Tracker : SESSION_TRACK_SYSTEM_VARIABLES 20-- character_set_connection 21-- utf8 22 23SET NAMES 'big5'; 24# tracking info on 25SET NAMES 'utf8'; 26-- Tracker : SESSION_TRACK_SYSTEM_VARIABLES 27-- character_set_connection 28-- utf8 29 30# tracking info off once 31SET NAMES 'big5'; 32SET @@session.session_track_system_variables= @save_session_track_system_variables; 33# 34# MDEV-22504: session tracking return incorrectly long traking data 35# 36set @save_optimizer_switch=@@optimizer_switch; 37SET @@session.session_track_system_variables='optimizer_switch'; 38set optimizer_switch='index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_merge_sort_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=off,derived_merge=off,derived_with_keys=off,firstmatch=off,loosescan=off,materialization=on,in_to_exists=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=off,mrr=on,mrr_cost_based=on,mrr_sort_keys=on,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=off,join_cache_hashed=off,join_cache_bka=off,optimize_join_buffer_size=on,table_elimination=off,extended_keys=off,exists_to_in=off,orderby_uses_equalities=off,condition_pushdown_for_derived=off'; 39-- Tracker : SESSION_TRACK_SYSTEM_VARIABLES 40-- optimizer_switch 41-- index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_merge_sort_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=off,derived_merge=off,derived_with_keys=off,firstmatch=off,loosescan=off,materialization=on,in_to_exists=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=off,mrr=on,mrr_cost_based=on,mrr_sort_keys=on,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=off,join_cache_hashed=off,join_cache_bka=off,optimize_join_buffer_size=on,table_elimination=off,extended_keys=off,exists_to_in=off,orderby_uses_equalities=off,condition_pushdown_for_derived=off,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off 42 43Warnings: 44Warning 1681 'engine_condition_pushdown=on' is deprecated and will be removed in a future release 45set @@optimizer_switch=@save_optimizer_switch; 46SET @@session.session_track_system_variables= @save_session_track_system_variables; 47# End of 10.2 tests 48# 49# MDEV-22134 handle_fatal_signal (sig=11) in __strlen_avx2 on START 50# SLAVE | Assertion 51# `global_system_variables.session_track_system_variables' failed in 52# Session_sysvars_tracker::init | *** buffer overflow detected *** 53# (on optimized builds) 54# 55SET @@GLOBAL.session_track_system_variables=NULL; 56ERROR 42000: Variable 'session_track_system_variables' can't be set to the value of 'NULL' 57SET SESSION session_track_system_variables=NULL; 58ERROR 42000: Variable 'session_track_system_variables' can't be set to the value of 'NULL' 59# End of 10.3 tests 60# 61# MDEV-16470 - Session user variables tracker 62# 63# End of 10.5 tests 64