r9359: Fixes for PRINT-QUERY and sql concatenation operator (||).

[clsql.git] / TODO

diff --git a/TODO b/TODO
index 4042e643c0c1433e33d1b772f04d149709e62bb5..29e242cc601ae4802ed239c75656bfdf946c75d4 100644 (file)
--- a/TODO
+++ b/TODO
@@ -7,14 +7,12 @@ TESTS TO ADD
 * Test bigint type
 * :db-constraint tests
 * test *db-auto-sync* 
-* test :retrieval :deferred joins
+* test SELECT caching
+* for-each-row macro
+* universal-time 
 
 COMMONSQL SPEC
 
-* Missing: 
-
-  UPDATE-OBJECT-JOINS 
-
 * Incompatible 
 
  >> The functional sql interface 
@@ -29,12 +27,19 @@ COMMONSQL SPEC
          nvl (Oracle specific) 
          userenv (Oracle specific) 
         minus (Oracle specific: does the same as EXCEPT) 
-        || 
 
       o variables (e.g., table identifiers) should be instantiated at runtime 
 
-OPTIMIZATIONS
 
+VARIANCES FROM COMMONSQL
+
+UPDATE-OBJECT-JOINS:
+ Rather than simply reading the values for each
+ object, to meet CommonSQL spec need to generate a single
+ query to read values for all objects, up to max-len count.
+
+OPTIMIZATIONS
+ 
 * Revisit result-type list creation,perhaps caching
 
 POSSIBLE EXTENSIONS
@@ -51,7 +56,9 @@ MYSQL
 drop-index:   requires a table to be specified with the :from keyword parameter
 views:        mysql does not support views  
 queries:      nested subqueries are not supported
+syntax:       doesn't support the sql concatenation operator (||). 
 
 SQLITE 
 
-create-view: column-list parameter not supported 
+create-view:  column-list parameter not supported 
+syntax:       doesn't support the sql SUBSTRING operator.