| 1 |
--source include/have_nodebug.inc |
| 2 |
|
| 3 |
--echo # Scenario 1: Fixes bug 34736760 |
| 4 |
--echo # 1.1: Redundant |
| 5 |
--let $table_name = t1_redundant |
| 6 |
--let $pk_col = num |
| 7 |
--let $new_col = col |
| 8 |
|
| 9 |
eval CREATE TABLE $table_name ($pk_col INT PRIMARY KEY) ROW_FORMAT=REDUNDANT; |
| 10 |
|
| 11 |
--echo # Insert dummy data to increase time taken to complete ALTER rebuild |
| 12 |
--echo # Table is inserted with 1, 2, 3, .. , 1000000 |
| 13 |
SET SESSION cte_max_recursion_depth=10000000; |
| 14 |
eval INSERT INTO $table_name WITH RECURSIVE v AS (SELECT 1 AS n UNION ALL SELECT n + 1 FROM v WHERE n <= 1000000) SELECT n FROM v; |
| 15 |
|
| 16 |
--source suite/innodb/include/bug33788578_release.inc |