X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=ChangeLog;h=37b7154f9eb032032f9ed42374c530b44e446302;hp=a61f47d15fe32ee896b40b0c4d900fb36df09d38;hb=6bace6a7bd18bb1c81aef9c3737b23c760593d58;hpb=d10a3ac8045f8ed50756850d3d75f62dbc6f93cd 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