From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/sysschema/include/sys_config_cleanup.inc | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 mysql-test/suite/sysschema/include/sys_config_cleanup.inc (limited to 'mysql-test/suite/sysschema/include/sys_config_cleanup.inc') diff --git a/mysql-test/suite/sysschema/include/sys_config_cleanup.inc b/mysql-test/suite/sysschema/include/sys_config_cleanup.inc new file mode 100644 index 00000000..af8d0362 --- /dev/null +++ b/mysql-test/suite/sysschema/include/sys_config_cleanup.inc @@ -0,0 +1,17 @@ +# Reset the sys.sys_config table + +# Note, we have to disable the triggers to reset the set_by column back to NULL +# as the sys.sys_config_update_set_user trigger will overwrite it to the current user +SET @sys.ignore_sys_config_triggers := true; + +DELETE FROM sys.sys_config; + +INSERT IGNORE INTO sys.sys_config (variable, value) VALUES + ('statement_truncate_len', 64), + ('statement_performance_analyzer.limit', 100), + ('statement_performance_analyzer.view', NULL), + ('diagnostics.allow_i_s_tables', 'OFF'), + ('diagnostics.include_raw', 'OFF'), + ('ps_thread_trx_info.max_length', 65535); + +SET @sys.ignore_sys_config_triggers := NULL; -- cgit v1.2.3