MySQL Bugs: #60988: table mysql.slave_master_info has typo in column name Ssl_verify_servert

Bug #60988	table mysql.slave_master_info has typo in column name Ssl_verify_servert_cert
Submitted:	27 Apr 2011 15:56	Modified:	6 May 2011 9:39
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	5.6.2	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
mysql> show columns from mysql.slave_master_info like '%servert%';
+-------------------------+------------+------+-----+---------+-------+
| Field                   | Type       | Null | Key | Default | Extra |
+-------------------------+------------+------+-----+---------+-------+
| Ssl_verify_servert_cert | tinyint(1) | NO   |     | NULL    |       |
+-------------------------+------------+------+-----+---------+-------+
1 row in set (0.01 sec)

How to repeat:
show columns from mysql.slave_master_info like '%servert%';

Suggested fix:
Ssl_verify_servert_cert should be Ssl_verify_server_cert

Then, as a favor to users, please add some descriptive comments for each
of the columns in the CREATE TABLE syntax.. It can be taken from the manual even.

Verified with current mysql-trunk:

macbook-pro:trunk openxs$ bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.3-m5-debug Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show columns from mysql.slave_master_info like '%servert%';
+-------------------------+------------+------+-----+---------+-------+
| Field                   | Type       | Null | Key | Default | Extra |
+-------------------------+------------+------+-----+---------+-------+
| Ssl_verify_servert_cert | tinyint(1) | NO   |     | NULL    |       |
+-------------------------+------------+------+-----+---------+-------+
1 row in set (0.01 sec)

Documented as follows in the 5.6.3 changelog:
 
      The name of the Ssl_verify_server_cert column in the
      mysql.slave_master_info table was misspelled as 
      Ssl_verify_servert_cert.

Also updated master_slave_info table description in docs.

Closed.