Bug #6067 non-numeric values inserted into year column results in value 2000

Submitted: 13 Oct 2004 16:22 Modified: 10 Feb 2005 19:14
Reporter: Reggie Burnett Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:All OS:
Assigned to: Jim Winstead CPU Architecture:Any

[13 Oct 2004 16:22] Reggie Burnett 
Description:
the following will result in the value 2000 being inserted into the table.

create table Test (yr YEAR);

insert into test values ('abc');

How to repeat:
follow the steps above
[13 Oct 2004 18:42] Matthew Lord 
I was able to repeat this on windows 2000 SMP and RH 9 Linux (Linux booty 2.4.21 #12 SMP Thu 
Aug 14 00:49:40 EDT 2003 i686 i686 i386 GNU/Linux).

The column's default is NULL so it should get NULL.
[1 Feb 2005 23:22] Jim Winstead 
Will default to '0000', as we do for similar cases setting a numeric field to a non-numeric string.
[4 Feb 2005 21:00] Jim Winstead 
Fixed in 4.1 tree.
[10 Feb 2005 19:14] Paul DuBois 
Mentioned in 4.1.10 change notes.

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

Page generated in 0.052 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.