mysql-test/suite/sysschema/t/fn_sys_get_config.test
raw| 1 | -- source include/not_embedded.inc |
| 2 | # Tests for sys schema |
| 3 | # Verify the sys.sys_get_config() function perfoms as expected |
| 4 | |
| 5 | # Check a known parameter |
| 6 | SET @sys.statement_truncate_len := IFNULL(@sys.statement_truncate_len, sys.sys_get_config('statement_truncate_len', 128)); |
| 7 | |
| 8 | SELECT @sys.statement_truncate_len; |
| 9 | |
| 10 | # Check an unknown parameter |
| 11 | SET @sys.foo := IFNULL(@sys.foo, sys.sys_get_config('foo', 'foobar')); |
| 12 | |
| 13 | SELECT @sys.foo; |