Package: sqlitebrowser Version: 3.7.0-1 Severity: normal Dear Maintainer, I have a sqlitefile with timestamps and some data values. When I plot the data vs datetime with the builtin plot function, I get a weird outlier when the datetime is 2006-03-26 02:00
A minimal example is here: http://www.nmdb.eu/~steigies/debian/NEWK_2006_1h.sqlite This also happens when I change the minute to other values as long as the hour stays at two. I did not specify a timezone in the datetime, so if I understand http://sqlite.org/lang_datefunc.html correctly, this is taken as UTC. March 26 was the beginning of Daylight Saving Time in most of Europe, the hour between 2 and 3 does not exist on this day: http://www.timeanddate.com/time/dst/2006.html slitebrowser changes the datetime for this hour to ~ the year 2100 when plotting the data. When I change my timezone from Europe/Berlin to America/New_York, this glitch in the plot happens on April 2nd, the day DST began in the USA. I think sqlitebrowser should plot the data as given in the file, without shifting values during DST switch to the year 2100 if I give it data in UTC. If I specified a timezone, I do not expect the data to appear in 2100 either, mabye that data should be dropped from plotting, with a warning given to the user instead. thanks, Christian -- System Information: Debian Release: stretch/sid APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'testing'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.5.0-2-amd64 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages sqlitebrowser depends on: ii libc6 2.22-9 ii libgcc1 1:6.1.1-4 ii libqcustomplot1.3 1.3.2+dfsg1-1 ii libqt5core5a 5.5.1+dfsg-17 ii libqt5gui5 5.5.1+dfsg-17 ii libqt5network5 5.5.1+dfsg-17 ii libqt5printsupport5 5.5.1+dfsg-17 ii libqt5scintilla2-12v5 2.9.2+dfsg-1 ii libqt5test5 5.5.1+dfsg-17 ii libqt5widgets5 5.5.1+dfsg-17 ii libsqlite3-0 3.13.0-1 ii libstdc++6 6.1.1-4 sqlitebrowser recommends no packages. sqlitebrowser suggests no packages. -- no debconf information
