Debian Codegraph @

mysql-test/suite/sys_vars/t/tmpdir_basic_debug.test

raw
1 # *********************************************
2 # Bug#28598943 TEMPTABLE STORAGE ENGINE DOES NOT HONOUR THE TMPDIR OPTION
3 # *********************************************
4 # Different "enter" trace on Solaris, so skip it.
5 --source include/not_solaris.inc
6 --source include/not_windows.inc
7 --source include/have_debug.inc
8
9 --echo # Restart server with --tmpdir
10
11 let $restart_parameters = "restart: --tmpdir=$MYSQLTEST_VARDIR/tmp --temptable_max_ram=1M --log_error_verbosity=3 --log-error=$MYSQLTEST_VARDIR/log/tmpdir_basic.err";
12 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
13 --source include/restart_mysqld.inc
14
15 --echo # Test with --tmpdir
16 SET DEBUG='+d,enter';
17
18 SET SESSION cte_max_recursion_depth = 20000;
19 WITH RECURSIVE cte (n, val1, val2, val3, val4, val5) AS
20 (SELECT 1, UUID(), UUID(), UUID(), UUID(), UUID()
21 UNION ALL
22 SELECT n + 1 + IF(n > 18000, SLEEP(0.01), 0),
23 UUID(), UUID(), UUID(), UUID(), UUID()
24 FROM cte WHERE n < 20000
25 )
26 SELECT COUNT(*) FROM cte;
27
28 --let tmp_dir = `SELECT @@tmpdir`
29 --let SEARCH_FILE = $MYSQLTEST_VARDIR/log/tmpdir_basic.err
30 --let SEARCH_PATTERN = create_temp_file: enter: dir: $tmp_dir
31 --source include/search_pattern_multiline.inc
32
33 SET DEBUG='-d,enter';
34
35 let $restart_parameters = "restart: --temptable_max_ram=1M --log_error_verbosity=3 --log-error=$MYSQLTEST_VARDIR/log/tmpdir_basic_default.err";
36 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
37 --source include/restart_mysqld.inc
38
39 --echo # Test with default tmpdir
40
41 SET DEBUG='+d,enter';
42
43 SET SESSION cte_max_recursion_depth = 20000;
44 WITH RECURSIVE cte (n, val1, val2, val3, val4, val5) AS
45 (SELECT 1, UUID(), UUID(), UUID(), UUID(), UUID()
46 UNION ALL
47 SELECT n + 1 + IF(n > 18000, SLEEP(0.01), 0),
48 UUID(), UUID(), UUID(), UUID(), UUID()
49 FROM cte WHERE n < 20000
50 )
51 SELECT COUNT(*) FROM cte;
52
53 --let default_tmp_dir = `SELECT @@tmpdir`
54
55 --let SEARCH_FILE = $MYSQLTEST_VARDIR/log/tmpdir_basic_default.err
56 --let SEARCH_PATTERN = create_temp_file: enter: dir: $default_tmp_dir
57 --source include/search_pattern_multiline.inc
58
59 SET DEBUG='-d,enter';
60
61 let $restart_parameters=;
62 --source include/restart_mysqld.inc