polardbxengine/mysql-test/suite/xengine_sysschema/t/fn_sys_get_config.test

13 lines
392 B
Plaintext

# 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;