X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=ChangeLog;h=e800941eae87dd8bcbd825b44457c19122bd6cb0;hb=0298f640eee047a87b675c6c55ca895017bf9a9f;hp=ada36bdd6d6c3a1dc58267c309bfb65a51e5c11e;hpb=21ffe5f820036726c6353a16dfb478fb41aa700c;p=clsql.git diff --git a/ChangeLog b/ChangeLog index ada36bd..e800941 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,11 +1,48 @@ +15 May 2004 Kevin Rosenberg (kevin@rosenberg.net) + * Version 2.10.18 + * sql/db-interface.lisp: Add new db-type-has-union? + since Mysql 3.23 does not support unions. + * sql/test-init.lisp: Don't try union tests on database + backends which do not support it. + * db-oracle/*.lisp: initial port to UFFI + * sql/objects.lisp: implement UPDATE-OBJECT-JOINS, + implement REFRESH for SELECT. + * tests/test-oodml.lisp: Add tests for deferred retrieval, + caching, refresh, and update-object-joins + * tests/test-init.lisp: Add deferred-employee-address class + 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk) - * sql/classes.lisp: SELECT now accepts table identifiers as strings - for CommonSQL compliance. Add support for qualified sql identifiers - with aliased table names. - * tests/test-fdml.lisp: added tests for table identifiers as strings - in SELECT and for aliased definitions. - * tests/test-syntax.lisp: added tests for alias definitions. - + * sql/operations.lisp: make MINUS operator a synonym for EXCEPT. Add + COALESCE operator and make NVL a synonym for this. Make ANY, SOME, + ALL and EXISTS generate function expressions so they output the + correct SQL. + * sql/classes.lisp: SELECT now generates appropriate SQL when + passed the SET-OPERATION and ALL keyword arguments. + * sql/classes.lisp: the ORDER-BY keyword argument to SELECT now + accepts ordering constraints as pairs of the form (column direction) + where direction may be :ASC or :DESC. + * tests/test-syntax.lisp: added tests for MINUS and COALESCE/NVL. + Correct tests for ANY, SOME, ALL and EXISTS. + * tests/test-fdml.lisp: added test for COALESCE. + * sql/sql.lisp: MAP-QUERY now applies FUNCTION to QUERY-EXPRESSION + using funcall unless QUERY-EXPRESSION returns one column and its + FLATP slot is not nil in which case apply is used. + * tests/test-basic.lisp: modified calls to MAP-QUERY to reflect the + changes. + * TODO: remove items done. + * db-postgresql/postgresql-sql.lisp: no need to reverse results in + DATABASE-LIST-ATTRIBUTES. + * db-postgresql-socket/postgresql-socket-sql.lisp: no need to reverse + results in DATABASE-LIST-ATTRIBUTES. + +15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk) + * sql/classes.lisp: SELECT now accepts table identifiers as strings + for CommonSQL compliance. Add support for qualified sql identifiers + with aliased table names. + * tests/test-fdml.lisp: added tests for table identifiers as strings + in SELECT and for aliased definitions. + * tests/test-syntax.lisp: added tests for alias definitions. + 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk) * sql/sql.lisp: PRINT-QUERY now calls QUERY with result-types and field-names set to nil.