X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=ChangeLog;h=986022402eab31b2e1603f7577b9b310941a29a3;hp=69b816850a3c13911b1cf0da0a2711f8f07af0e2;hb=d894d2bf5884e0e10762f78f7cbbdc3725c6d4af;hpb=7127589ca079f4f4279be601ebd272b7488906b4 diff --git a/ChangeLog b/ChangeLog index 69b8168..9860224 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,9 +1,48 @@ -2012-02-22 Nathan Bird +2012-04-26 Kevin Rosenberg + * Version 6.2 released: thanks to all the contributors! - * db-mysql/mysql-loader.lisp (*mysql-library-candidate-names*): If - running on a threaded lisp try loading libmysqlclient_r (the - threaded build) first. from - http://dev.mysql.com/doc/refman/5.1/en/threaded-clients.html +2012-04-25 Nathan Bird + + * doc/threading-warnings.txt: Adding some notes from J.T.Klein + about the current state of thread-safety in clsql. This should be + incorporated into the main docs at some point. + +2012-04-25 Russ Tyndall + * sql/expressions.lisp (output-sql): on rendering update/insert + expression values, ensure that *in-subselect* is bound to T + so that the values will be correctly paren delimited + +2012-04-24 Nathan Bird + + * sql/expressions.lisp (output-sql): on mysql CREATE TABLE + statements use 'ENGINE=innodb' instead of 'Type=InnoDB'. This has + apparently been preferred since mysql 4.1 and mysql 5.5 removed + type as a valid keyword. + +2012-03-28 Russ Tyndall + + * sql/sequences.lisp: [A Patch FROM 2011-07-28 changed sequences. + They were previously prefixed with _CLSQL_SEQ_ but are now + suffixed with _CLSQL_SEQ. This is likely to break existing + implementations using the default sequence names + + setting *old-sequence-names* to T, should force using the older + naming scheme + +2012-03-27 Ryan Davis + + * sql/expressions.lisp: Fixed bug with subqueries in the where + clause of update-records and delete-records generating invalid + SQL. Previously subselects in where clauses would not have enough + parentheses, for example: "WHERE Id IN SELECT foo_id FROM bar" + vs. "WHERE Id IN (SELECT foo_id FROM bar)" + * tests/test-syntax.lisp: Added tests for using subqueries in the + where clause in update-records and delete-records. Moved asserts + in the test-output-sql/sql-ident-table function into the standard + test framework. + * doc/appendix.xml: added :connection-string to the information on + ODBC connection specs, and added example code connecting to ODBC + databases. 2012-01-05 Nathan Bird @@ -28,10 +67,10 @@ I.e. you can now do things like: (clsql:connect '("DsnName" "UserName" "" :connection-string - "DRIVER={FreeTDS};SERVER=...;DATABASE=...;UID=...;PWD=...;PORT=1433;TDS_Version=8.0;APP=clsql" - :database-type :odbc)) + "DRIVER={FreeTDS};SERVER=...;DATABASE=...;UID=...;PWD=...;PORT=1433;TDS_Version=8.0;APP=clsql") + :database-type :odbc) - I belibe the DsnName and Username at that point are only used when + I believe the DsnName and Username at that point are only used when printing the connection information. 2011-12-20 Kevin Rosenberg @@ -104,6 +143,14 @@ * test/: Better, more tests, better type coercion in tests and throughout (%get-int) + [edit 2012-03-28 - RT] + * sql/sequences.lisp: Sequences were previously prefixed with + _CLSQL_SEQ_ but are now suffixed with _CLSQL_SEQ. This is likely + to break existing implementations using the default sequence names + + setting *old-sequence-names* to T, should force using the older + naming scheme + 2011-07-16 Kevin Rosenberg * Version 5.4.0 release