From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/sysschema/r/t_sys_config.result | 46 ++++++++++++++++++++++++ 1 file changed, 46 insertions(+) create mode 100644 mysql-test/suite/sysschema/r/t_sys_config.result (limited to 'mysql-test/suite/sysschema/r/t_sys_config.result') diff --git a/mysql-test/suite/sysschema/r/t_sys_config.result b/mysql-test/suite/sysschema/r/t_sys_config.result new file mode 100644 index 00000000..f13196c6 --- /dev/null +++ b/mysql-test/suite/sysschema/r/t_sys_config.result @@ -0,0 +1,46 @@ +SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA='sys'; +COUNT(*) +0 +DESC sys.sys_config; +Field Type Null Key Default Extra +variable varchar(128) NO PRI NULL +value varchar(128) YES NULL +set_time timestamp NO current_timestamp() on update current_timestamp() +set_by varchar(128) YES NULL +SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1; +variable value set_by +diagnostics.allow_i_s_tables OFF NULL +diagnostics.include_raw OFF NULL +ps_thread_trx_info.max_length 65535 NULL +statement_performance_analyzer.limit 100 NULL +statement_performance_analyzer.view NULL NULL +statement_truncate_len 64 NULL +UPDATE sys.sys_config SET value = 128 WHERE variable = 'statement_truncate_len'; +SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1; +variable value set_by +diagnostics.allow_i_s_tables OFF NULL +diagnostics.include_raw OFF NULL +ps_thread_trx_info.max_length 65535 NULL +statement_performance_analyzer.limit 100 NULL +statement_performance_analyzer.view NULL NULL +statement_truncate_len 128 NULL +INSERT INTO sys.sys_config (variable, value) VALUES ('foo', 'bar'); +SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1; +variable value set_by +diagnostics.allow_i_s_tables OFF NULL +diagnostics.include_raw OFF NULL +foo bar NULL +ps_thread_trx_info.max_length 65535 NULL +statement_performance_analyzer.limit 100 NULL +statement_performance_analyzer.view NULL NULL +statement_truncate_len 128 NULL +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