MySQL Bugs: #73221: Extra row in column privileges

Bug #73221	Extra row in column privileges
Submitted:	7 Jul 2014 17:34	Modified:	28 Aug 2014 0:38
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.1.7	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The table inspector grants tab provides visibility into grants for a given table, including at the column level.  The column privileges listed, however, seem to include an extra row, suggesting a scope at the table level (see screenshot) - even when the privileges are granted only for specific columns.

How to repeat:
1.  CREATE USER colpriv@localhost;
2.  GRANT SELECT (user, host) ON mysql.user TO colpriv@localhost;
3.  Use WB table inspector to view grants for mysql.user table.
4.  Observe three rows in "column privileges" section.

Suggested fix:
Remove rows from "column privileges" which are not column-level privileges.

Fixed as of the upcoming MySQL Workbench 6.2.2 release, and here's the changelog entry:

The "column privileges" section in the Table Inspector contained an extra
third column.

Thank you for the bug report.