BUG: mysql2300 may fail when daylight saving time ends

mysql2300 may fail when daylight saving time ends. This is because the timstamp column is a unique key, and the value stored in it is local time. When DST ends, the system clock will go back. This may result in an attempt to insert a duplicate unique key value. In any case, the values stored in the columns 'timestamp' and 'rec_time' would probably be better as local standard time, or better still as UTC, for consistency.

Comment Lars Hinrichsen: The program does run properly. In case of dublicate keys MySQL? skips the insert. You just loose one hour of measurement.

Test case

Environment

Open2300 version:	1.10
Shared libraries:	mysql
Server OS:	Linux (debian sarge)

-- TWikiGuest - 29 Sep 2005

Follow up

Fix record