Bug #1912 not releasing query thread
Submitted: 21 Nov 2003 13:46 Modified: 21 Nov 2003 16:30
Reporter: Alan Minner Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:mysql 4.1 alpha OS:Windows (windows xp)
Assigned to: CPU Architecture:Any

[21 Nov 2003 13:46] Alan Minner
Description:
any time that I run a query that writes to a text file the operation completes but the query thread is not released.  this problem did not exist in mysql 4.0.15
The operation works on 4.1 but the thread is not released at the end of the query. I get the message in the message box in the control center but the start button is not released and if I try to close the query window a message appears asking if I want to kill the query thread.

This problem happens on any query that I try that outputs to a text file.

How to repeat:
SELECT concat("@@@@",email,"@@",f_name,"@@",l_name) into outfile 'c:/mylists/mssfq.txt'
    LINES 
        TERMINATED BY '\n'
FROM mssfq
order by email asc
limit 25000

table length 25000 records
3 fields  email, f_name, l_name
[21 Nov 2003 16:30] MySQL Verification Team
I tried with table around 50000 rows without to repeat the behavior
reported.