hi all,
I've just upgraded one of the replicate servers from 4.0.22 to 4.1.7,
just as a test before upgrading all the others.
Apparently I had just this problem: datetime data inserted in ISO format
is not accepted -- strings like '20041210T104201' when inserted get
silently translated to "0000-00-00 00:00". One of my tables uses this as
a primary key, so I only got the error when it complained about
duplicate keys.
For instance:
mysql> INSERT INTO core (timestamp, version, value) VALUES
("20041210T104201", 10, 6.542966 );
ERROR 1062 (23000): Duplicate entry '10-0000-00-00 00:00:00' for key 1
where "timestamp" is of DATETIME type.
This only happens in the 4.1.7 mysql, in 4.0.22 it is correctly
interpreted.
I find this strange, I thought these iso date/time strings where pretty
standard. I generated them with the c++/posix_time "to_iso_string()"
function.
Any ideas how to overcome this problem ? Is this a bug ? (I'd be happy
to report if that's the case).
Many thanks,
jan
ps.: sorry if this topic have already been discussed under a different
subject -- I couldn't find anything about this.
--
Jan Pfeifer <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
