summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/temp_table_savepoint.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/t/temp_table_savepoint.test')
-rw-r--r--mysql-test/suite/innodb/t/temp_table_savepoint.test12
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/innodb/t/temp_table_savepoint.test b/mysql-test/suite/innodb/t/temp_table_savepoint.test
index 314ac148fca..c8a4bc870a7 100644
--- a/mysql-test/suite/innodb/t/temp_table_savepoint.test
+++ b/mysql-test/suite/innodb/t/temp_table_savepoint.test
@@ -97,11 +97,11 @@ create procedure populate_tables()
repeat(concat(' tc4_',n),8),repeat(concat(' tc_',n),8),
repeat(concat(' tc6_',n),8),repeat(concat(' tc7_',n),8),
now(),(100.55+n));
- insert into t4 values(n,n,repeat(concat(' tc3_',n),30),
+ insert ignore into t4 values(n,n,repeat(concat(' tc3_',n),30),
repeat(concat(' tc4_',n),800),repeat(concat(' tc_',n),800),
repeat(concat(' tc6_',n),800),repeat(concat(' tc7_',n),800),
now(),(100.55+n));
- insert into t5 values(n,n,repeat(concat(' tc3_',n),30),
+ insert ignore into t5 values(n,n,repeat(concat(' tc3_',n),30),
repeat(concat(' tc4_',n),800),repeat(concat(' tc_',n),800),
repeat(concat(' tc6_',n),800),repeat(concat(' tc7_',n),800),
now(),(100.55+n));
@@ -132,11 +132,11 @@ create procedure populate_tables()
repeat(concat(' tc4_',n+inner_loop),8),repeat(concat(' tc_',n+inner_loop),8),
repeat(concat(' tc6_',n+inner_loop),2),repeat(concat(' tc7_',n+inner_loop),2),
now(),(100.55+n+inner_loop));
- insert into t4 values(n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
+ insert ignore into t4 values(n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
repeat(concat(' tc4_',n+inner_loop),800),repeat(concat(' tc_',n+inner_loop),800),
repeat(concat(' tc6_',n+inner_loop),245),repeat(concat(' tc7_',n+inner_loop),245),
now(),(100.55+n+inner_loop));
- insert into t5 values(n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
+ insert ignore into t5 values(n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
repeat(concat(' tc4_',n+inner_loop),800),repeat(concat(' tc_',n+inner_loop),800),
repeat(concat(' tc6_',n+inner_loop),245),repeat(concat(' tc7_',n+inner_loop),245),
now(),(100.55+n+inner_loop));
@@ -161,11 +161,11 @@ create procedure populate_tables()
repeat(concat(' tc4_',n+inner_loop),8),repeat(concat(' tc_',n+inner_loop),8),
repeat(concat(' tc6_',n+inner_loop),2),repeat(concat(' tc7_',n+inner_loop),2),
now(),(100.55+n+inner_loop));
- insert into t4 values(300+n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
+ insert ignore into t4 values(300+n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
repeat(concat(' tc4_',n+inner_loop),800),repeat(concat(' tc_',n+inner_loop),800),
repeat(concat(' tc6_',n+inner_loop),245),repeat(concat(' tc7_',n+inner_loop),245),
now(),(100.55+n+inner_loop));
- insert into t5 values(300+n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
+ insert ignore into t5 values(300+n+inner_loop,n+inner_loop,repeat(concat(' tc3_',n+inner_loop),30),
repeat(concat(' tc4_',n+inner_loop),800),repeat(concat(' tc_',n+inner_loop),800),
repeat(concat(' tc6_',n+inner_loop),245),repeat(concat(' tc7_',n+inner_loop),245),
now(),(100.55+n+inner_loop));