Description of problem:
MariaDB TABLE CHECKSUM calculation sometimes ignore columns
The fix was implemented for MariaDB 5.5 in commit https://github.com/MariaDB/server/commit/1ecccb509c9dfa57976a2e2c3af07753a5356188. It was released in MariaDB 5.5.63 release.
Would it be possible to include this fix in RHEL 7.6?
Version-Release number of selected component (if applicable):
I have expanded the src.rpm package "mariadb-5.5.60-1.el7_5.src.rpm"
1) download mariadb-5.5.60-1.el7_5.src.rpm
2) install it with yum install mariadb-5.5.60-1.el7_5.src.rpm
3) cd ~/rpmbuild/SPECS
4) run rpmbuild -bp --nodeps mariadb.spec
5) go to ../BUILD
6) find the file "sql_table.cc" under the directory.
7) check if the patch of https://github.com/MariaDB/server/commit/1ecccb509c9dfa57976a2e2c3af07753a5356188 is applied into the function "mysql_checksum_table".
I have checked the line "uchar null_mask=256 - (1 << t->s->last_null_bit_pos);" exists in the file "sql_table.cc", so it's not applied.
so, filing a Bugzilla to request the backport.
Steps to Reproduce:
MariaDB TABLE CHECKSUM calculation sometimes ignore columns.
Filing a Bugzilla to request the backport.
The ticket https://jira.mariadb.org/browse/MDEV-17085 and https://jira.mariadb.org/browse/MDEV-17372 deal with a problem that the TABLE CHECKSUM command in MariaDB (server) sometimes ignores/skips columns. Thus the checksum calculation sometimes is wrong.
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.