diff options
| author | Vladislav Vaintroub <wlad@mariadb.com> | 2021-12-16 19:16:04 +0100 |
|---|---|---|
| committer | Vladislav Vaintroub <wlad@mariadb.com> | 2021-12-16 19:16:04 +0100 |
| commit | 946dafb260fc5683e1ec1410a801f2235ba2313a (patch) | |
| tree | 991aebda6e6423e6f82d5c599411f92ac1ba8b85 | |
| parent | 30bf0bca8f16447ebd04e4743353b1cbf999c9cc (diff) | |
| download | mariadb-git-st-10.6-wlad.tar.gz | |
MDEV-26925 add test that there are no triggers in sys schema.st-10.6-wlad
| -rw-r--r-- | mysql-test/suite/sysschema/r/t_sys_config.result | 3 | ||||
| -rw-r--r-- | mysql-test/suite/sysschema/t/t_sys_config.test | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/suite/sysschema/r/t_sys_config.result b/mysql-test/suite/sysschema/r/t_sys_config.result index 1def6b1f52b..f13196c6503 100644 --- a/mysql-test/suite/sysschema/r/t_sys_config.result +++ b/mysql-test/suite/sysschema/r/t_sys_config.result @@ -1,3 +1,6 @@ +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 diff --git a/mysql-test/suite/sysschema/t/t_sys_config.test b/mysql-test/suite/sysschema/t/t_sys_config.test index 0c87d2eb95d..d78f8c9fd11 100644 --- a/mysql-test/suite/sysschema/t/t_sys_config.test +++ b/mysql-test/suite/sysschema/t/t_sys_config.test @@ -1,7 +1,7 @@ -- source include/not_embedded.inc # Tests for sys schema # Verify the sys.sys_config table is as expected - +SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA='sys'; DESC sys.sys_config; SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1; @@ -11,7 +11,6 @@ UPDATE sys.sys_config SET value = 128 WHERE variable = 'statement_truncate_len'; SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1; -# Ensure the sys.sys_config_insert_set_user trigger functions correctly INSERT INTO sys.sys_config (variable, value) VALUES ('foo', 'bar'); SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1; |