Bug #23588 SHOW COLUMNS on a temporary table causes locking issues

Description:
If a temporary table was locked with a WRITE lock and a show column is then performed on that table the lock is changed to a READ lock so making it not possible to modify the temporary table.

How to repeat:
use test;
create temporary table t ( k int );
lock tables t write;
insert into t values (1);
show columns from t;
insert into t values(2);
ERROR 1099 (HY000): Table 't' was locked with a READ lock and can't be updated

Suggested fix:
Fix the bug?

Thank you for the report.

Verified as described on Linux using last BK sources.

Version 5.1 is affected too

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/40089

ChangeSet@1.2583, 2007-12-17 14:52:09+04:00, gluh@mysql.com +3 -0
  Bug#23588 SHOW COLUMNS on a temporary table causes locking issues
  skip lock_type update for temporary tables

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/42802

ChangeSet@1.2585, 2008-02-22 12:12:39+04:00, gluh@mysql.com +3 -0
  Bug#23588 SHOW COLUMNS on a temporary table causes locking issues
  skip lock_type update for temporary tables

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/42803

ChangeSet@1.2584, 2008-02-22 12:30:17+04:00, gluh@mysql.com +3 -0
  Bug#23588 SHOW COLUMNS on a temporary table causes locking issues
  skip lock_type update for temporary tables

Pushed into 6.0.5-alpha

Pushed into 5.1.24-rc

Pushed into 5.0.60

Noted in 5.0.56, 5.1.24, 6.0.5 changelogs.

SHOW COLUMNS on a TEMPOARY table caused locking issues.

Also documented fix in 5.1.23-ndb-6.3.11 changelog.