Debian Codegraph @

mysql-test/suite/sys_vars/r/tmpdir_basic_debug.result

raw
1 # Restart server with --tmpdir
2 # restart: --tmpdir=MYSQLTEST_VARDIR/tmp --temptable_max_ram=1M --log_error_verbosity=3 --log-error=MYSQLTEST_VARDIR/log/tmpdir_basic.err
3 # Test with --tmpdir
4 SET DEBUG='+d,enter';
5 SET SESSION cte_max_recursion_depth = 20000;
6 WITH RECURSIVE cte (n, val1, val2, val3, val4, val5) AS
7 (SELECT 1, UUID(), UUID(), UUID(), UUID(), UUID()
8 UNION ALL
9 SELECT n + 1 + IF(n > 18000, SLEEP(0.01), 0),
10 UUID(), UUID(), UUID(), UUID(), UUID()
11 FROM cte WHERE n < 20000
12 )
13 SELECT COUNT(*) FROM cte;
14 COUNT(*)
15 20000
16 SET DEBUG='-d,enter';
17 # restart: --temptable_max_ram=1M --log_error_verbosity=3 --log-error=MYSQLTEST_VARDIR/log/tmpdir_basic_default.err
18 # Test with default tmpdir
19 SET DEBUG='+d,enter';
20 SET SESSION cte_max_recursion_depth = 20000;
21 WITH RECURSIVE cte (n, val1, val2, val3, val4, val5) AS
22 (SELECT 1, UUID(), UUID(), UUID(), UUID(), UUID()
23 UNION ALL
24 SELECT n + 1 + IF(n > 18000, SLEEP(0.01), 0),
25 UUID(), UUID(), UUID(), UUID(), UUID()
26 FROM cte WHERE n < 20000
27 )
28 SELECT COUNT(*) FROM cte;
29 COUNT(*)
30 20000
31 SET DEBUG='-d,enter';
32 # restart