Bug #13290 bug id=9535 seems to be still open in 4.1.14

• Submitted: 17 Sep 2005 6:33
• Modified: 17 Sep 2005 12:59
• Reporter: Gleb Paharenko
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.14/4.0 BK source
• OS: Linux (Linux)
• Assigned to: Assigned Account
• CPU Architecture: Any

[17 Sep 2005 6:33] Gleb Paharenko

Description:
http://bugs.mysql.com/bug.php?id=9535
tells that is was closed in 4.1.13, while in 5.0.12 has it fixed :)

How to repeat:
mysql> create table ui as select uuid();
Query OK, 1 row affected, 1 warning (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 1

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

mysql> show create table ui\G;
*************************** 1. row ***************************
       Table: ui
Create Table: CREATE TABLE `ui` (
  `uuid()` char(12) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8

+------------------+
| version()        |
+------------------+
| 4.1.14-debug-log |
+------------------+

Suggested fix:
fix it :)

[17 Sep 2005 12:59] MySQL Verification Team

changing status for original bug to verified for version 4.0..
Thank you for the bug report.