| Bug #18152 | create index on xxx varchar(4096) crash server on windows XP 5.0.18 | ||
|---|---|---|---|
| Submitted: | 11 Mar 2006 12:42 | Modified: | 24 Mar 2006 11:28 |
| Reporter: | Ben Li | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.0.18 | OS: | Windows (Windows) |
| Assigned to: | CPU Architecture: | Any | |
[11 Mar 2006 17:29]
MySQL Verification Team
Thank you for the bug report.
I was unable to repeat with last release 5.0.19. Could you please
test with that version.
c:\mysql\bin>mysql -uroot db3
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.19-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create table ppp (
-> ID int unsigned NOT NULL auto_increment,
-> defines varchar(4096) NOT NULL default '',
-> key (defines),
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected, 1 warning (0.13 sec)
mysql> show warnings;
+---------+------+---------------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------------+
| Warning | 1071 | Specified key was too long; max key length is 767 bytes |
+---------+------+---------------------------------------------------------+
1 row in set (0.00 sec)
mysql> insert into ppp(defines) values ('mysqlmysqlmysqlmysqlmysql');
Query OK, 1 row affected (0.03 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.19-nt |
+-----------+
1 row in set (0.06 sec)
mysql>
[24 Mar 2006 11:28]
Ben Li
sloved in 5.0.19, just found this is in 5.0.19 release notes.
Description: I have install the windows version 5.0.18(mysql-essential-5.0.18-win32.msi), and try the new varchar limit in 5.0, and find this bug I use myisam stroage engine. running on a Windows XP SP2, with Norton 2005 anti-virus. I've test it on a linux server(CentOS 4) with mysql 5.0.18, which don't has this bug. How to repeat: run this sql language drop table if exists ppp; create table ppp ( ID int unsigned NOT NULL auto_increment, defines varchar(4096) NOT NULL default '', key (defines), PRIMARY KEY (id) ); insert into ppp(defines) values ('mysqlmysqlmysqlmysqlmysql');