Bug #1281 Wrong timestamp value

• Submitted: 15 Sep 2003 12:39
• Modified: 15 Sep 2003 15:30
• Reporter: Per Mårtensson
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.14
• OS: Windows (Win, Linux)
• 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