X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=ChangeLog;h=29ac560c8302fc0f5b8fdf1aeeeb9880f468de14;hb=67a4ab3576b630b8d34a6476ec8c1e9dfa913800;hp=ccc8afcf33a6ca829802594f80b17fab9bb2e79e;hpb=eeb36233c9881cd2bb141f7a3241afbe82feda8d;p=clsql.git diff --git a/ChangeLog b/ChangeLog index ccc8afc..29ac560 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,9 +1,50 @@ +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