X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=sidebyside;f=ChangeLog;h=37b7154f9eb032032f9ed42374c530b44e446302;hb=6bace6a7bd18bb1c81aef9c3737b23c760593d58;hp=8b7aecf3d251ff05f16983f99d48932d191da25c;hpb=ca0cd6368e2847f7852e68dd370b41fbf1ad076f;p=clsql.git diff --git a/ChangeLog b/ChangeLog index 8b7aecf..37b7154 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,25 @@ +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-02-22 Nathan Bird + + * 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-01-05 Nathan Bird * db-odbc/odbc-dbi.lisp: handle sql decimal type in the same way @@ -21,10 +43,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