Open2300 - Bug Report 2005x 09x 29x 102136

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

BugReportForm edit

TopicTitle mysql2300 may fail when daylight saving time ends
BugStatus Rejected
AssignedBugTo
SubmittedBy TWikiGuest
Topic revision: r3 - 10 Jun 2006, OschenLars
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
This website only use harmless session cookies. See Cookie Policy for details. By using this website you accept the use of these cookies.