That's no bug. That is what timestamp is, current date and current time no
matter whether you insert or update. Read the manual more carefully. What
I think you want is date column, not timestamp.
----- Original Message -----
From: "Marc Swanson" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 21:43
Subject: bug in 3.23.22-beta
> Hello list,
>
> I am wondering if this bug I found in 3.23.22-beta is a known bug that has
> been fixed in laater servers.
>
> How to replicate:
>
> create table test_bug (
> text_field varchar(20) NOT NULL,
> date_field timestamp(14)
> );
>
> insert into test_bug (text_field,date_field) values
> ('foo','20010107080000');
> update test_bug set text_field = 'bar' where text_field = 'foo';
>
> select * from test_bug;
>
> And the result:
>
> +-----------------------------+
> | text field | date_field |
> +-----------------------------+
> | bar | 20010119082332 |
> +------------+----------------+
>
>
> As you can see the date field has been updated to the current date/time
even
> though the update query was only supposed to modify the text field. For
> claarity the date field started out with 2001-01-07 08:00:00 and ended up
> with 2001-01-19 08:23:32 (the time I tested this bug).
>
> Can somebody let me know if this bug exists in the newer 3.23 servers?
>
>
> Thanks
>
> -Marc-
>
>
> #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
> #Marc Swanson | \|||/ #
> #MSwanson Consulting | /o o\ #
> #Phone: (603)868-1721 |-ooo----O----ooo-#
> #Fax: (603)868-1730 | Solutions in: #
> #[EMAIL PROTECTED] | 'PHP 'Perl #
> # | 'SQL 'C++ #
> # | 'HTML 'Sh/Csh#
> # http://www.mswanson.com | 'Javascript #
> #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php