projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9186: add attribute caching, improve inititialize-database-type
[clsql.git]
/
TODO
diff --git
a/TODO
b/TODO
index e71c4bd5e01f5f1ca1b8a89b2520ffdf87ee8740..9d5e76d6e7b9800d7f32d665247bc9999e2fac27 100644
(file)
--- a/
TODO
+++ b/
TODO
@@
-1,27
+1,18
@@
GENERAL
GENERAL
-* test on mcl. SCL no longer affordable to individuals;
-* implement remaining functions for CLSQL AODBC backend;
* port Oracle backend to UFFI.
COMMONSQL SPEC
* Missing:
* port Oracle backend to UFFI.
COMMONSQL SPEC
* Missing:
- CACHE-TABLE-QUERIES
- *CACHE-TABLE-QUERIES-DEFAULT*
- *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
UPDATE-OBJECT-JOINS
UPDATE-OBJECT-JOINS
-
* Incompatible
>> Initialisation and connection
* Incompatible
>> Initialisation and connection
- INITIALIZE-DATABASE-TYPE
- o should initialise appropriate backend
-
STATUS
o what is the behaviour in CommonSQL (esp :full parameter)?
STATUS
o what is the behaviour in CommonSQL (esp :full parameter)?
@@
-34,12
+25,9
@@
COMMONSQL SPEC
o should coerce values returned as strings to appropriate lisp type
QUERY
o should coerce values returned as strings to appropriate lisp type
QUERY
- o should return (values result-list field-names)
o should coerce values returned as strings to appropriate lisp type
o should coerce values returned as strings to appropriate lisp type
-
- LIST-ATTRIBUTE-TYPES
- o should return list of (attribute datatype precision scale nullable)
-
+ (except for SQLite interface, this works when :result-types is :auto).
+ Perhaps that should be the default?
>> The object-oriented sql interface
>> The object-oriented sql interface
@@
-76,9
+64,8
@@
NOTES ABOUT THE BACKENDS
MYSQL
drop-index: requires a table to be specified with the :from keyword parameter
MYSQL
drop-index: requires a table to be specified with the :from keyword parameter
-transactions: don't seem to work
views: mysql does not support views
views: mysql does not support views
-queries: nested subqueries
do not seem to work
+queries: nested subqueries
are not supported
SQLITE
SQLITE