Bug #5836 inserting oversized string causes server to crash
Submitted: 1 Oct 2004 0:33 Modified: 1 Oct 2004 13:56
Reporter: Peter Pebler Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.5 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[1 Oct 2004 0:33] Peter Pebler
Description:
Inserting a string of more than N characters into a field of type char(N) or varchar(N) using the "mysql" command-line client causes the mysql server to crash.

How to repeat:
Execute the following statements:

create table testtable (a char(2));
insert into testtable values ("123");

Or the following:

create table testtable (a varchar(2));
insert into testtable values ("123");
[1 Oct 2004 3:31] Peter Pebler
This also happens when doing the insert using the c API.
[1 Oct 2004 13:56] MySQL Verification Team
I wasn't able to repeat:

E:\MySQL\MySQL Server 4.1>cd bin

E:\MySQL\MySQL Server 4.1\bin>mysql -uroot -p -P3307
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.5-gamma-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test;
Database changed
mysql> create table testtable (a varchar(2));
Query OK, 0 rows affected (0.18 sec)

mysql> insert into testtable values ("123");
Query OK, 1 row affected, 1 warning (0.07 sec)

mysql> show warnings;
+---------+------+----------------------------------------+
| Level   | Code | Message                                |
+---------+------+----------------------------------------+
| Warning | 1265 | Data truncated for column 'a' at row 1 |
+---------+------+----------------------------------------+
1 row in set (0.02 sec)

mysql>
[1 Oct 2004 21:21] Peter Pebler
Uninstalling all mysql versions on the system, then installing 4.1.5 again fixed this problem.