diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/events_bugs.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/events_bugs.test | 6 |
2 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/r/events_bugs.result b/mysql-test/r/events_bugs.result index f51209db6f1..c90b3a458ff 100644 --- a/mysql-test/r/events_bugs.result +++ b/mysql-test/r/events_bugs.result @@ -585,8 +585,10 @@ SET AUTOCOMMIT = 0; SET @evname = 'ev_sched_1823'; SET @cnt = 0; SELECT COUNT(*) INTO @cnt FROM test.event_log WHERE ev_nm = @evname; +IF @cnt <= 6 THEN INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp()); COMMIT; +END IF; SELECT COUNT(*) INTO @cnt FROM test.event_log WHERE ev_nm = @evname; INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp()); ROLLBACK; diff --git a/mysql-test/t/events_bugs.test b/mysql-test/t/events_bugs.test index ebe4d83331d..5e326d28ab9 100644 --- a/mysql-test/t/events_bugs.test +++ b/mysql-test/t/events_bugs.test @@ -683,8 +683,10 @@ DO BEGIN SET @evname = 'ev_sched_1823'; SET @cnt = 0; SELECT COUNT(*) INTO @cnt FROM test.event_log WHERE ev_nm = @evname; - INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp()); - COMMIT; + IF @cnt <= 6 THEN + INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp()); + COMMIT; + END IF; SELECT COUNT(*) INTO @cnt FROM test.event_log WHERE ev_nm = @evname; INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp()); ROLLBACK; |