+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
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 <kevin@rosenberg.net>