X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=ChangeLog;h=37b7154f9eb032032f9ed42374c530b44e446302;hp=8e01d8a2c9e9a256857b9d42fe838db526674ee8;hb=6bace6a7bd18bb1c81aef9c3737b23c760593d58;hpb=ab372582e10ae92944dff87630255773cff33728 diff --git a/ChangeLog b/ChangeLog index 8e01d8a..37b7154 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,11 +1,17 @@ -2012-03-25 Ryan Davis - - * sql/expressions.lisp: - - Fixed bugs related to outputting where clauses in delete/updates - using sql syntax. Previously subselects and where clauses without - data (such as an empty or clause or and clause) would cause - failures. +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