summaryrefslogtreecommitdiff
path: root/mysql-test/r/binlog_row_binlog.result
diff options
context:
space:
mode:
authorunknown <aelkin/elkin@dsl-hkigw8-feb9fb00-191.dhcp.inet.fi>2006-09-23 15:24:45 +0300
committerunknown <aelkin/elkin@dsl-hkigw8-feb9fb00-191.dhcp.inet.fi>2006-09-23 15:24:45 +0300
commit99f8d0a4a82b6816345fabf5b9570435b80930a0 (patch)
treeec4d7ba3993c54353dc15be04eb441a4abf64a24 /mysql-test/r/binlog_row_binlog.result
parent73d0afd3d05bc301a0a90f0eca0f7aac350c787a (diff)
downloadmariadb-git-99f8d0a4a82b6816345fabf5b9570435b80930a0.tar.gz
binlog_row_binlog test gained some indeterministic checks with changes due to
ChangeSet@1.2309.1.12, 2006-09-12 15:42:13+02:00, guilhem@gbichot3.local +14 -0 Fixing problems I identified in my auto_increment work pushed in July (as part of the auto_increment cleanup of WL #3146; ... The problem is in that show binlog events in indeterministic, row events can be compressed, so that 2 seconds original delay does not guard from inconsistency. We syncronize test's current inserted rows counter with system insert delayed thread per each query. From another side there is no requirement for binlog to be event per row and then to verify if binlog has recorded what was recently inserted is better via reading from it instead of 'show binlog events'. mysql-test/extra/binlog_tests/binlog_insert_delayed.test: removing sleeps, syncronizing with system delayed thread per each statement, note that an insert statement is performed atomically including writing to binlog, so that concurrent selects are waiting. That's why the wait macro is safe. mysql-test/r/binlog_row_binlog.result: new result mysql-test/include/wait_until_rows_count.inc: macro implements waiting until a targeted table has a prescribed rows number.
Diffstat (limited to 'mysql-test/r/binlog_row_binlog.result')
-rw-r--r--mysql-test/r/binlog_row_binlog.result1
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/binlog_row_binlog.result b/mysql-test/r/binlog_row_binlog.result
index 8d5025f7602..5eef5d9cbf3 100644
--- a/mysql-test/r/binlog_row_binlog.result
+++ b/mysql-test/r/binlog_row_binlog.result
@@ -252,6 +252,7 @@ insert delayed into t1 values (null);
insert delayed into t1 values (300);
insert delayed into t1 values (null),(null),(null),(null);
insert delayed into t1 values (null),(null),(400),(null);
+11 == 11
select * from t1;
a
207