X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=ChangeLog;h=d274bf49daf41d7f7dbcf64dadeebb057b60ef0d;hb=refs%2Fheads%2F6.8.0;hp=2bc632f528122353b3038a0d31585aecd54e59b9;hpb=2ba41ebdcd4963728c8d5460e389a5381b8e2293;p=clsql.git diff --git a/ChangeLog b/ChangeLog index 2bc632f..d274bf4 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,7 +1,100 @@ +2018-04-08 Russ Tyndall + * sql/db-interface, expressions, fdml, generic-postgres + db-mysql/mysql-sql.lisp db-postgresql-socket3/sql.lisp + + - I created a new protocol function (database-escape-backslashes + database) + - I changed the the generic mysql and postgres databases + to return T + - I made the postgresql-socket3 backend check for + standards_conforming_string which is exposed in the underlying + cl-postgres connection + - It seems likely that postgresql-socket3 could always return NIL, as + cl-postgres would probably handle this escaping anyway + + This replaced some special case code in (database-output-sql (string + database)) + + +2018-02-04 Russ Tyndall + * sql/generic-postgres.lisp: + Wall times default to being timestamptz in postgresql now. + There was a TODO questioning why it was storing zoneless by + default - it was because of the bugs about tracking UTC + vs zoneless + + +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 + +2015-04-06 Russ Tyndall + * sql/operations, sql/expressions: add postgresql E-string + operator / expression. Needed for correct regex handling + EG: [E "some string"]=> E'some string' + 2015-03-30 Kevin Rosenberg * Version 6.6.2 release * db-oracle/oracle-sql.lisp: Remove extra hyphen, thanks to Thomas Vossen + +2015-03-24 Russ Tyndall + * sql/oodml.lisp: fixed call-next-method in the base of + read-sql-value and replaced with a continuable + sql-value-conversion-error + * default read-sql-value for list + * tests for sql-value-conversion-errors and list + +2015-03-18 Russ Tyndall + * {uffi,db-mysql}/Makefile: remove -pie build hardening for + which caused load issues for Linux Mint 2015-03-18 Kevin Rosenberg * Version 6.6.1 release @@ -13,14 +106,14 @@ * Version 6.6.0 release * {uffi,db-mysql}/Makefile: Add build hardening for Debian -2014-02-24 Russ Tyndall +2015-02-24 Russ Tyndall * mysql-sql.lisp an error in type declarations generating a compilation warning was being treated as an error in recent SBCLs, fixed the type warning by correcting the type (still a ton of compliation notes) -2014-02-23 Russ Tyndall +2015-02-23 Russ Tyndall * sql/metaclasses.lisp made reinitialize-instance return the instance passed to it as SBCL now expected (mentioned on the SBCL-devel mailing list by