Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0(EOL), 10.2(EOL)
-
None
-
GNU/Linux
Description
According to https://mariadb.com/kb/en/library/checksum-table/ only older MySQL servers would yield different results.
As it turns out, supported, widely used and deployed MariaDB instances will also return different results for the exact same table structure and data?!
Comparing 10.0 (Ubuntu LTS repo release) and 10.2 (MariaDB official stable repo release).
CHECKSUM TABLE badcs;
|
MariaDB 10.0: 1873571331
MariaDB 10.2: 3472699532
Even worse, MySQL is different on it's own:
MySQL 5.6.34: 260370412
But I'm interested here in MariaDB only.
It seems that MyISAM tables will produce same results across each server version/flavour, so all OK as expected with checksumming process done on exact same table/data.
Only InnoDB will (mis)behave like this, thus effectively breaking entire point of CHECKSUM-ming data across servers.
Isn't this suppose to be standard's compliant command?
In attachment there's my sample table with few rows. So it's easy to be reproduced.
Attachments
Issue Links
- relates to
-
MDEV-28020 CHECKSUM TABLE calculates different checksums
- Closed
-
MDEV-15377 10.2+ Integer DEFAULT values missing quotes
- Closed
-
MDEV-15407 DEFAULT NULL forced when no DEFAULT set on NULL-able column
- Closed
-
MDEV-30428 checksums on multiple servers are not computed equally
- Open