| Subject: | Enhancement: ignore row_format in tolerant mode |
| Date: | Tue, 23 Dec 2014 10:17:40 +0100 |
| To: | bug-MySQL-Diff [...] rt.cpan.org |
| From: | Toth Istvan <toth.istvan [...] netfonetelecom.hu> |
Hello!
I'd like to propose the following change:
--- Diff.pm.orig 2014-12-23 10:10:02.284038847 +0100
+++ Diff.pm 2014-12-23 10:09:24.838735032 +0100
@@ -399,6 +399,7 @@ sub _diff_options {
for ($options1, $options2) {
s/ AUTO_INCREMENT=\d+//gi;
s/ COLLATE=[\w_]+//gi;
+ s/ ROW_FORMAT=[\w_]+//gi;
}
}
The rationale is that row_format is an implementation detail, that
should not have any bearing on the behaviour of the database.
(In our case, the production server uses uncompressed tables, while our
test/development mysql server has alll tables converted to COMPRESSED
format, so mysqldiff generates a noise change line for every table)
best regards
Istvan