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;hp=d10a3ac8045f8ed50756850d3d75f62dbc6f93cd merging changelog --- diff --git a/ChangeLog b/ChangeLog index a61f47d..37b7154 100644 --- a/ChangeLog +++ b/ChangeLog @@ -2,7 +2,9 @@ * 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