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