wo identical tables should always match to the same checksum value; however,
also for non-identical tables there is a very slight chance that they will
return the same value as the hashing algorithm is not completely
collision-free.

Identical Tables
----------------

Identical tables mean that the CREATE statement is identical and that the
following variable, which affects the storage formats, was the same when the
tables were created:

* mysql56-temporal-format

Differences Between MariaDB and MySQL
-------------------------------------

CHECKSUM TABLE may give a different result as MariaDB doesn't ignore NULLs in
the columns as MySQL 5.1 does (Later MySQL versions should calculate checksums
the same way as MariaDB). You can get the 'old style' checksum in MariaDB by
starting mysqld with the --old option. Note however that that the MyISAM and
Aria storage engines in MariaDB are using the new checksum internally, so if
you are using --old, the CHECKSUM command will be slower as it needs to
calculate the checksum row by row. Starting from MariaDB Server 10.9, --old is
deprecated and will be removed in a future release. Set --old-mode or OLD_MODE
to COMPAT_5_1_CHECKSUM to get 'old style' checksum.

URL: https://mariadb.com/kb/en/checksum-table/https://mariadb.com/kb/en/checksum-table/€