Bug #47001 | Incorrect check for length of primary key | ||
---|---|---|---|
Submitted: | 31 Aug 2009 5:29 | Modified: | 1 Sep 2009 6:58 |
Reporter: | Bogdan Dz | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S2 (Serious) |
Version: | 6.0.11-alpha | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[31 Aug 2009 5:29]
Bogdan Dz
[31 Aug 2009 6:08]
Valeriy Kravchuk
Thank you for the problem report. Please, send the results of: show create table mytable\G from your environment.
[31 Aug 2009 21:38]
Bogdan Dz
The table doesn't get created with help of the above queries. Therefore I can't provide you with output of your test. In the same time if I create table in the following way: CREATE TABLE mytable (ID DECIMAL(18,0), MYCOLUMN VARCHAR(255) NOT NULL); The output of your statement is: show create table mytable\G *************************** 1. row *************************** Table: mytable Create Table: CREATE TABLE `mytable` ( `ID` decimal(18,0) DEFAULT NULL, `MYCOLUMN` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec)
[1 Sep 2009 6:58]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior with current development sources while bug is repeatable with version 6.0.11. Please either wait next 5.4.x release which inherits 6.0 series or use current sources from https://code.launchpad.net/~mysql/mysql-server/mysql-next