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:Microsoft Windows (WinNT)
Assigned to: Dean Ellis CPU Architecture:Any

[4 Dec 2003 0:36] Harry Big
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...
[4 Dec 2003 8:48] Dean Ellis
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
[5 Dec 2003 6:44] Harry Big
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...