MySQL Bugs: #2008: LOCKED STATE during ALTER TABLE

Bug #2008	LOCKED STATE during ALTER TABLE
Submitted:	4 Dec 2003 0:36	Modified:	4 Dec 2003 8:48
Reporter:	Harry Big	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	3.23.58	OS:	Windows (WinNT)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
When I trying to change non empty table via comand:
ALTER TABLE `test` ADD `Flg` TINYINT(1)  UNSIGNED DEFAULT "2"
mysqld-nt.exe put thread in "LOCKED STATE" and not change table structure.
When im downgrading mysqld-nt.exe to 3.23.56 version - all works succesfully...
Config C:\my.cnf here:
=========================================
[mysqld]
port=3366
#socket=MySQL
local-infile=1
skip-locking
skip-name-resolve
tmpdir=D:\\mysql\\tmp
default-character-set=win1251
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=1800
set-variable = wait_timeout=300
skip-innodb
skip-grant-tables
log
bind-address=192.168.0.1
basedir = d:/mysql/
=========================================

How to repeat:
Hmm...

I cannot repeat this with 3.23.58.

Please send a repeatable test case with the SQL statements to create (and populate with data, if that is necessary to cause the issue) the table and perform the ALTER.

Otherwise, make sure you don't have the table locked by some other connection.

Thank you

I fix this bug. Simply table contains field VARCHAR with PRIMARY KEY on this field. I change filed type on CHAR - an bug is disapear...