Debian Codegraph @

mysql-test/suite/sysschema/r/t_sys_config.result

raw
1 DESC sys.sys_config;
2 Field Type Null Key Default Extra
3 variable varchar(128) NO PRI NULL
4 value varchar(128) YES NULL
5 set_time timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
6 set_by varchar(128) YES NULL
7 SELECT variable, value, set_by FROM sys.sys_config;
8 variable value set_by
9 diagnostics.allow_i_s_tables OFF NULL
10 diagnostics.include_raw OFF NULL
11 ps_thread_trx_info.max_length 65535 NULL
12 statement_performance_analyzer.limit 100 NULL
13 statement_performance_analyzer.view NULL NULL
14 statement_truncate_len 64 NULL
15 UPDATE sys.sys_config SET value = 128 WHERE variable = 'statement_truncate_len';
16 SELECT variable, value, set_by FROM sys.sys_config;
17 variable value set_by
18 diagnostics.allow_i_s_tables OFF NULL
19 diagnostics.include_raw OFF NULL
20 ps_thread_trx_info.max_length 65535 NULL
21 statement_performance_analyzer.limit 100 NULL
22 statement_performance_analyzer.view NULL NULL
23 statement_truncate_len 128 NULL
24 INSERT INTO sys.sys_config (variable, value) VALUES ('foo', 'bar');
25 SELECT variable, value, set_by FROM sys.sys_config;
26 variable value set_by
27 diagnostics.allow_i_s_tables OFF NULL
28 diagnostics.include_raw OFF NULL
29 foo bar NULL
30 ps_thread_trx_info.max_length 65535 NULL
31 statement_performance_analyzer.limit 100 NULL
32 statement_performance_analyzer.view NULL NULL
33 statement_truncate_len 128 NULL
34 SET @sys.ignore_sys_config_triggers := true;
35 DELETE FROM sys.sys_config;
36 INSERT IGNORE INTO sys.sys_config (variable, value) VALUES
37 ('statement_truncate_len', 64),
38 ('statement_performance_analyzer.limit', 100),
39 ('statement_performance_analyzer.view', NULL),
40 ('diagnostics.allow_i_s_tables', 'OFF'),
41 ('diagnostics.include_raw', 'OFF'),
42 ('ps_thread_trx_info.max_length', 65535);
43 SET @sys.ignore_sys_config_triggers := NULL;