merging changelog

[clsql.git] / ChangeLog

diff --git a/ChangeLog b/ChangeLog
index 0dde7a48ba4241188c8aedce3b719103b97c9702..37b7154f9eb032032f9ed42374c530b44e446302 100644 (file)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,4 +1,60 @@
+2012-03-27  Ryan Davis  <ryan@acceleration.net>
+
+       * 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  <nathan@acceleration.net>
+
+       * 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  <nathan@acceleration.net>
+
+       * db-odbc/odbc-dbi.lisp: handle sql decimal type in the same way
+       as numeric type-- read into a double float.
+
+2011-01-04  Russ Tyndall  <russ@acceleration.net>
+       * sql/operations.lisp
+
+       Fixed bug reported by JTK related to the not-null sql-expression
+       especially as used in conjunction with the is operator.
+
+       Made null called with more than one argument throw an exception
+       instead of silently discarding all arguments past the first
+
+2012-01-04  Nathan Bird  <nathan@acceleration.net>
+
+       * db-odbc/odbc-api.lisp (%sql-driver-connect): in the call to
+       odbc's SQLDriverConnect default the WindowHandle argument to a null ptr so
+       that connecting with :connection-string will work in the default
+       case of SQL_DRIVER_NOPROMPT.
+
+       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)
+
+       I believe the DsnName and Username at that point are only used when
+       printing the connection information.
+
 2011-12-20  Kevin Rosenberg <kevin@rosenberg.net>
+       * Version 6.1.1
+       * db-oracle/oracle.lisp: Typo correction (Elias Martenson)
+
+2011-12-19  Kevin Rosenberg <kevin@rosenberg.net>
+       * Version 6.1.0
        * db-oracle/oracle.lisp: Change length function to
        uffi:foreign-string-length to handle foreign encodings.
        Thanks to Elias Martenson.