MySQL Bugs: #46105: Inconsistent result with "show full fields from ;

Bug #46105	Inconsistent result with "show full fields from ;
Submitted:	10 Jul 2009 6:08	Modified:	21 Aug 2009 19:33
Reporter:	mahesh patil	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	5.1.30, 5.1, 6.0	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
Inconsistent result with "show full fields from `table`;

For 5.0.67 and 5.1.30

How to repeat:
1. Create a table mentioned below in both the server 5.0.67 and 5.1.30

create table `tbl1` (
  `col1` timestamp not null default current_timestamp on update current_timestamp
) engine=innodb default charset=utf8 collate=utf8_bin;

2. Execute below query against both the servers.

Show full fields from `tbl1`;

3. Result differs in both for "Extra" column,

in 5.1.30 shows "on update current_timestamp" for Extra column in the result where as in 5.0.67 it is blank.

Suggested fix:
Needs to document about this behaviour

Thank you for the report.

Verified as described: changelog should be updated.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

This change occurred for Bug#30081, and is documented in the 5.1.23/6.0.4 changelogs.

However, the SHOW COLUMNS section was not updated; I have done so.

By the way, FULL is not necessary for this information to be shown.