diff options
| author | unknown <igor@olga.mysql.com> | 2007-07-01 01:59:05 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-07-01 01:59:05 -0700 |
| commit | e63f6f3223ff51318d5a6609df74039609564100 (patch) | |
| tree | cf0a8494a5355c64783980e5c6ce21a95515db42 /mysql-test | |
| parent | f9d36194a065c2d58c19a8348811957450b7a996 (diff) | |
| download | mariadb-git-e63f6f3223ff51318d5a6609df74039609564100.tar.gz | |
Made test case platform independent.
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; |