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 Email Updates:
Status: Duplicate Impact on me:
None 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.