MySQL Bugs: #47758: MySQL Cluster : logging of all columns for delete rows event

Bug #47758	MySQL Cluster : logging of all columns for delete rows event
Submitted:	1 Oct 11:11
Reporter:	Frazer Clement
Status:	Open
Category:	Server: ClusterRep	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-6.2	OS:	Any
Assigned to:	Frazer Clement	Target Version:
Triage:	Triaged: D3 (Medium) / R6 (Needs Assessment) / E6 (Needs Assessment)

Description:
When testing the mysqlbinlog --verbose tool, I noticed a difference in the output for
DELETE ROW events between 6.2 and 6.3 +.

In 6.2, DELETE ROW events *always* include just the primary key, e.g.

DELETE FROM test.ba WHERE   @1=2

In 6.3+, DELETE ROW events include just the primary key when ndb_log_updated_only is ON.

When it's off, DELETE ROW events include all columns.  e.g. :

DELETE FROM test.ba WHERE   @1=2   @2=2   @3=2

This could be :
 1) A mysqlbinlog --verbose bug
 2) A real change in behaviour

It's not clear that ndb_log_updated_only is supposed to affect the columns logged for a
DELETE, but we should have consistency.

How to repeat:
See mysql-test/suite/ndb_binlog/t/ndb_binlog_variants.test

Suggested fix:
Align 6.2 behaviour with 6.3+.
Document?