Debian Codegraph @

mysql-test/suite/sysschema/t/t_sys_config.test

raw
1 # Tests for sys schema
2 # Verify the sys.sys_config table is as expected
3
4 DESC sys.sys_config;
5
6 SELECT variable, value, set_by FROM sys.sys_config;
7
8 # Ensure the sys.sys_config_update_set_user trigger functions correctly
9 UPDATE sys.sys_config SET value = 128 WHERE variable = 'statement_truncate_len';
10
11 SELECT variable, value, set_by FROM sys.sys_config;
12
13 # Ensure the sys.sys_config_insert_set_user trigger functions correctly
14 INSERT INTO sys.sys_config (variable, value) VALUES ('foo', 'bar');
15
16 SELECT variable, value, set_by FROM sys.sys_config;
17
18 --source ../include/sys_config_cleanup.inc