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

17 lines
496 B
Text

-- source include/not_embedded.inc
-- source include/not_windows.inc
# Passing NULL should return NULL
SELECT sys.format_path(NULL);
# Ensure datadir is recognized and stripped
SET @mypath := CONCAT(@@global.datadir, 'foo/bar.foo');
SELECT sys.format_path(@mypath);
# Ensure tmpdir is recognized and stripped
SET @mypath := CONCAT(@@global.tmpdir, '/foo/bar.foo');
SELECT sys.format_path(@mypath);
# Unrecognized paths should return the full path
SELECT sys.format_path('/foo/bar/baz.foo');