| 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 |