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