Bug #1281 Wrong timestamp value
Submitted: 15 Sep 2003 12:39 Modified: 15 Sep 2003 15:30
Reporter: Per MÃ¥rtensson Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.14 OS:Windows (Win, Linux)
Assigned to: CPU Architecture:Any

[15 Sep 2003 12:39] Per MÃ¥rtensson
Description:
I don't know if this is a bug ?

create database test2;
connect test2;
create table test_table (c_in timestamp, c_out timestamp);
insert into test_table (c_in) values (null);
select * from test_table;

/*RESULT
+----------------+----------------+
| c_in           | c_out          |
+----------------+----------------+
| 20030915211420 | 00000000000000 |
+----------------+----------------+
1 row in set (0.01 sec)
*/

update test_table set c_out=null;
select * from test_table;

/*RESULT
+----------------+----------------+
| c_in           | c_out          |
+----------------+----------------+
| 20030915211528 | 20030915211528 |
+----------------+----------------+
1 row in set (0.01 sec)
*/

Why is c_in updated ???

/Per

How to repeat:
See above
[15 Sep 2003 15:30] Alexander Keremidarski
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php