projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9199: fold clsql-base and clsql-base-sys into clsql-base
[clsql.git]
/
TODO
diff --git
a/TODO
b/TODO
index e71c4bd5e01f5f1ca1b8a89b2520ffdf87ee8740..763403704ae9afebe2ba5d3e9d49d1397b37d6f0 100644
(file)
--- a/
TODO
+++ b/
TODO
@@
-1,31
+1,23
@@
GENERAL
GENERAL
-* test on mcl. SCL no longer affordable to individuals;
-* implement remaining functions for CLSQL AODBC backend;
* port Oracle backend to UFFI.
* port Oracle backend to UFFI.
+TESTS TO ADD
+
+* CACHE-TABLE-QUERIES
+* :VOID-VALUE
+* :db-kind :key adds an index for that key, complicated by different
+ backends show autogenerated primary key in different ways.
+* New universal and bigint types, add tests for other types
+
COMMONSQL SPEC
* Missing:
COMMONSQL SPEC
* Missing:
- CACHE-TABLE-QUERIES
- *CACHE-TABLE-QUERIES-DEFAULT*
- *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
UPDATE-OBJECT-JOINS
UPDATE-OBJECT-JOINS
-
* Incompatible
* Incompatible
-
- >> Initialisation and connection
-
- INITIALIZE-DATABASE-TYPE
- o should initialise appropriate backend
-
- STATUS
- o what is the behaviour in CommonSQL (esp :full parameter)?
-
-
>> The functional sql interface
SELECT
>> The functional sql interface
SELECT
@@
-34,12
+26,8
@@
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)
-
+ for SQLite backend
>> 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