summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/update_time_wl6658.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/t/update_time_wl6658.test')
-rw-r--r--mysql-test/suite/innodb/t/update_time_wl6658.test5
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/suite/innodb/t/update_time_wl6658.test b/mysql-test/suite/innodb/t/update_time_wl6658.test
index 0b2b94ae2a9..0adc6a867fe 100644
--- a/mysql-test/suite/innodb/t/update_time_wl6658.test
+++ b/mysql-test/suite/innodb/t/update_time_wl6658.test
@@ -187,8 +187,9 @@ SELECT update_time
FROM information_schema.tables WHERE table_name='tab1i';
BEGIN WORK;
-INSERT INTO tab2 VALUES(1,'Oracle','NUTT',10);
+DELETE FROM tab1i;
SAVEPOINT A;
+INSERT INTO tab2 VALUES(1,'Oracle','NUTT',10);
INSERT INTO tab2 VALUES(2,'HUAWEI','BOLT',40);
SAVEPOINT B;
INSERT INTO tab2 VALUES(3,'IBM','NAIL',70);
@@ -203,7 +204,7 @@ FROM information_schema.tables WHERE table_name='tab2';
--echo #execute DDL instead of commit
create table tab6(c1 int);
-SELECT COUNT(update_time)
+SELECT update_time
FROM information_schema.tables WHERE table_name='tab2';
START TRANSACTION;