X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=ChangeLog;h=29ac560c8302fc0f5b8fdf1aeeeb9880f468de14;hb=868477640206e55887d5c017d1e47a58ef64dc47;hp=6cedb6c3742b5a88fcac5beed04e3f00f65eda3b;hpb=9fe9142259cca16202f35f66cbb35419752dd54d;p=clsql.git diff --git a/ChangeLog b/ChangeLog index 6cedb6c..29ac560 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,13 +1,50 @@ -2015-10-09 Russ Tyndall +2018-02-03 Russ Tyndall + * sql/time.lisp, tests/time.lisp: + Better distinguishing between zoneless timestamps and UTC times, + particularly as relates to postgresql-socket(3) backends. Without + this change, timestamptzs are read as localtimes and saved as + localtimes, when they should be read and printed as UTC times, + this bug will lead to dates changing every save as they are being + reconverted to UTC again. + + We followed a minimal approach (following postgresql' lead), we + simply add a is-utc? boolean. Before this, zoned times were + converted to UTC, but since we never tracked that it was a UTC + time vs a zoneless time, there was conflation between the two. In + order to preserver comparability between dates and times that are + local vs UTC. I wrote a `time-to-utc` utilizing decode-time's + implementation dependent timezone defaulting. + (I verified the math by comparing results to the local-time + library from quicklisp). + + Ultimately, adoption of a third party datetime library is my + strong preference (eg: local-time). While this project has, as a + whole refrained from outside requirements, I think that we should + consider moving to local-time as our date / time format, or + providing that as an option, both to support a semi standardized + eco system, and also to have a more robust timestamp implementation. + + +2016-01-26 Kevin Rosenberg + * Version 6.7.0 release + * sql/utils.lisp: Apply patch from Martin Simmons for + Lispworks 7 compatiblity + +2016-01-17 Russ Tyndall + * applied patches from Javeier Olaechea + * allows unix socket connections in clsql-postgressql-socket3 + * modernize asd slightly + +2015-10-09 Russ Tyndall * add decimals.lisp file https://github.com/tlikonen/cl-decimals * use this for safe parsing of numeric / decimal / rational types * Added because newer postgres print money types as currency strings - + 2015-08-12 Kevin Rosenberg * Version 6.6.3 release * db-oracle/oracle-sql.lisp: Patch for PostgreSQL socket interface for unicode characters. Thanks to Jason Melbye. - + 2015-06-02 Daniel Kochmański * clsql.asd, sql/package.lisp: Add ECL compatibility fixes * sql/db-interface.lisp: Fix declaration typo