Bug #4280 server hangs, prepared "create table .. as select ? .."
Submitted: 24 Jun 2004 23:00 Modified: 25 Jun 2004 18:22
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Linux (Linux)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[24 Jun 2004 23:00] Matthias Leich 
Description:
The server will hang(no high cpu consumption) if I execute
0. set @arg00=1;
1. prepare stmt3 from ' create table t3 (m int) as select ? as m ' ;
2. execute stmt3 using @arg00;

Please have a look into my test case file. There are also some similar
but good working test cases.
BTW: The bug must be a result of the recent code changes, because the
     test case worked OK two weeks ago.

     I assume the problematic code was injected between  
     ChangeSet@1.1912.1.1, 2004-06-10 --> all is OK (I have such an old tree)
     ChangeSet@1.1956,     2004-06-22 --> the bug  

My environment: Intel PC with Linux(SuSE 9.0),
   MySQL 4.1 source distrib.(last bk pull 2004-06-22)

I do NOT think that this bug is important, because the probability that
somebody executes a prepared create table .. as select .. with parameter
is very low.

How to repeat:
Please use my test file, copy it to mysql-test/t
  ./mysql-test-run ml_err7
[24 Jun 2004 23:03] Matthias Leich 
the test case

Attachment: ml_err8.test (application/octet-stream, text), 566 bytes.
[25 Jun 2004 14:17] Oleksandr Byelkin 
ChangeSet 
  1.1996 04/06/25 15:16:00 bell@sanja.is.com.ua +4 -0 
  type of parameter assignment for parameters from variables added (BUG#4280)
[25 Jun 2004 18:22] Oleksandr Byelkin 
Thank you for bug report. Patch is pushed in source repository