mariadb/mysql-test/suite/sysschema/t/fn_sys_get_config.test
2021-03-18 08:02:48 +01:00

13 lines
427 B
Text

-- source include/not_embedded.inc
# Tests for sys schema
# Verify the sys.sys_get_config() function perfoms as expected
# Check a known parameter
SET @sys.statement_truncate_len := IFNULL(@sys.statement_truncate_len, sys.sys_get_config('statement_truncate_len', 128));
SELECT @sys.statement_truncate_len;
# Check an unknown parameter
SET @sys.foo := IFNULL(@sys.foo, sys.sys_get_config('foo', 'foobar'));
SELECT @sys.foo;