Bug #26631 | Access Violation when field name length >= 280 characters | ||
---|---|---|---|
Submitted: | 26 Feb 2007 11:44 | Modified: | 30 Apr 2007 9:55 |
Reporter: | Heinz Schweitzer (Gold Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Administrator | Severity: | S3 (Non-critical) |
Version: | 1.2.9 | OS: | Windows (XP) |
Assigned to: | Mike Lischke | CPU Architecture: | Any |
Tags: | qc |
[26 Feb 2007 11:44]
Heinz Schweitzer
[26 Feb 2007 11:45]
Heinz Schweitzer
f1
Attachment: ScreenHunter_002.jpg (image/jpeg, text), 220.64 KiB.
[26 Feb 2007 12:38]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[12 Mar 2007 15:24]
Mike Lischke
I cannot reproduce this problem. I get: Fehler, währen die Abfrage ausgeführt wurde. ALTER TABLE `mysql`.`db` MODIFY COLUMN `Host` CHAR(280) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, MODIFY COLUMN `Delete_priv` ENUM('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AUTO_INCREMENT; MySQL Fehlernummer1074 Column length too big for column 'Host' (max = 255); use BLOB or TEXT instead ... and nothing bad happens. Please try with the latest build and let me know.
[12 Mar 2007 15:53]
Heinz Schweitzer
I tried with 1.2.10 and have the same result with a field name length of 280 characters :-(
[12 Mar 2007 15:57]
Heinz Schweitzer
NOTE: I am talking about the length of the field name itself NOT the column length.
[30 Apr 2007 9:55]
Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html