Nathan Bird | 24 Apr 2012 18:15
Favicon

CLSQL bugfixes in GIT

Relevant bits from the ChangeLog:

+2012-04-24  Nathan Bird <nathan@...>
+
+       * sql/expressions.lisp (output-sql): on mysql CREATE TABLE
+       statements use 'ENGINE=innodb' instead of 'Type=InnoDB'. This has
+       apparently been preferred since mysql 4.1 and mysql 5.5 removed
+       type as a valid keyword.
+
+2012-03-28  Russ Tyndall <russ@...>
+
+        * sql/sequences.lisp: [A Patch FROM 2011-07-28 changed sequences.
+       They were previously prefixed with _CLSQL_SEQ_ but are now
+       suffixed with _CLSQL_SEQ. This is likely to break existing
+       implementations using the default sequence names
+
+       setting *old-sequence-names* to T, should force using the older
+       naming scheme
+
+2012-03-27  Ryan Davis <ryan@...>
+
+       * 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.
(Continue reading)


Gmane