Bug #1033 subqueries in UPDATE statement
Submitted: 11 Aug 2003 13:38 Modified: 11 Sep 2003 23:13
Reporter: Alexey Stroganov Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:latest 4.1.1(bk) OS:Linux (Linux)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[11 Aug 2003 13:38] Alexey Stroganov 
Description:
First attempt to exec update statement with subquery produces such output:

mysql> update t100 set a= (select 1);
ERROR:

All futher attempts to execute statement above were successfully finished. 

mysql> update t100 set a= (select 1);
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: test

Query OK, 0 rows affected (0.06 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> update t100 set a= (select 1);
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

How to repeat:
stop mysql 4.1.1pre server
start mysql 4.1.1pre server

create table t100 (a int);
update t100 set a= (select 1);
update t100 set a= (select 1);