Debian Codegraph @

mysql-test/suite/sysschema/r/fn_format_path.result

raw
1 # restart: --datadir=CUSTOM_DATADIR --innodb_data_home_dir=MYSQLTEST_VARDIR/tmp/innodb --innodb_log_group_home_dir=MYSQLTEST_VARDIR/tmp/innodb_logs --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/innodb_undo
2 SELECT sys.format_path(NULL);
3 sys.format_path(NULL)
4 NULL
5 SET @mypath := CONCAT(@@global.basedir, 'logs/binlog.000001');
6 SELECT sys.format_path(@mypath);
7 sys.format_path(@mypath)
8 @@basedir/logs/binlog.000001
9 SET @mypath := CONCAT(@@global.datadir, 'foo/bar.foo');
10 SELECT sys.format_path(@mypath);
11 sys.format_path(@mypath)
12 @@datadir/foo/bar.foo
13 SET @mypath := CONCAT(@@global.tmpdir, '/foo/bar.foo');
14 SELECT sys.format_path(@mypath);
15 sys.format_path(@mypath)
16 @@tmpdir/foo/bar.foo
17 SET @mypath := CONCAT(@@global.innodb_data_home_dir, '/foo/bar.ibd');
18 SELECT sys.format_path(@mypath);
19 sys.format_path(@mypath)
20 @@innodb_data_home_dir/foo/bar.ibd
21 SET @mypath := CONCAT(@@global.innodb_log_group_home_dir, '/#innodb_redo/#ib_redo0');
22 SELECT sys.format_path(@mypath);
23 sys.format_path(@mypath)
24 @@innodb_log_group_home_dir/#innodb_redo/#ib_redo0
25 SET @mypath := CONCAT(@@global.innodb_undo_directory, '/undo0');
26 SELECT sys.format_path(@mypath);
27 sys.format_path(@mypath)
28 @@innodb_undo_directory/undo0
29 SELECT sys.format_path('/foo/bar/baz.foo');
30 sys.format_path('/foo/bar/baz.foo')
31 /foo/bar/baz.foo
32 # restart