Bug #38458 Queries causing 8 or more warnings hang the connections within the Proxy
Submitted: 30 Jul 2008 12:59 Modified: 10 Dec 2008 21:38
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Core Severity:S1 (Critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Jul 2008 12:59] Mark Leith
Description:
Queries that cause more than 8 warnings to be returned hang within the proxy:

mysql> select cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal);
^CAborted

How to repeat:
* connect to the proxy
* select cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal), cast('foo' as decimal);
[30 Jul 2008 13:48] Jan Kneschke
the problem occurred for 8-15 warnings (all kinds of queries matching "warnings & 0x08 == 0x08") 

revno: 929
revision-id: jan@mysql.com-20080730132545-fd13qfq1n6b9mn31
committer: jan@mysql.com
timestamp: Wed 2008-07-30 15:25:45 +0200
message:
  decoding the EOF packet had server-status and warnings flipped (fixes #38458)