From: Ryan Davis Date: Tue, 27 Mar 2012 20:21:39 +0000 (-0400) Subject: merging changelog X-Git-Tag: v6.1.1~7 X-Git-Url: http://git.kpe.io/?p=clsql.git;a=commitdiff_plain;h=6bace6a7bd18bb1c81aef9c3737b23c760593d58 merging changelog --- 6bace6a7bd18bb1c81aef9c3737b23c760593d58 diff --cc ChangeLog index a61f47d,8e01d8a..37b7154 --- a/ChangeLog +++ b/ChangeLog @@@ -1,15 -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. ++ 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