X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=ChangeLog;h=6148842220a673010325cb98a0995b24e19f2924;hp=6fe98ecbcacda12332dfa92b70bc9f39d4de5aa9;hb=15d9bb598423a2098ffd07fcf578e01550cdadfe;hpb=026988a3144e3ed7f48552b5567c34448fef51bc

diff --git a/ChangeLog b/ChangeLog
index 6fe98ec..6148842 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,9 +1,70 @@
+16 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
+	* doc/TODO: New file
+	* test/test-fdml.lisp: Added FDML/SELECT/34 to test
+	run-time instantiation of variables in reader macros.
+	* TODO: Remove item already complete. Add note about
+	condition variances
+	
+16 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk) 
+	* sql/syntax.lisp: added condition to the reader macro to treat [*] 
+	as a column identifier (rather than an operation) for CommonSQL 
+	compatibility. 
+	* tests/test-fdml.lisp: add tests for ORDER-BY and SET-OPERATION 
+	keword args to SELECT, [*] as column identifier, new MAP-QUERY 
+	behaviour and the ANY and ALL operators in subqueries. 
+	* tests/test-init.lisp: add set-operation and subquery tests to 
+	appropriate skip lists. 
+	* sql/objects.lisp: remove redundant and non CommonSQL compatible 
+	ORDER-BY-DESCENDING keyword argument for SELECT. 
+	* sql/classes.lisp: remove redundant and non CommonSQL compatible 
+	ORDER-BY-DESCENDING keyword argument for SELECT. 
+	* tests/test-oodml.lisp: add test for ORDER-BY keyword to SELECT 
+	with object queries. 
+
+15 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
+	* 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. 
-	* tests/test-fdml.lisp: added test for table identifiers as strings 
-	in SELECT. 
-
+	* 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.