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
