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:
- CACHE-TABLE-QUERIES
- *CACHE-TABLE-QUERIES-DEFAULT*
- *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
UPDATE-OBJECT-JOINS
-
* Incompatible
>> Initialisation and connection
- INITIALIZE-DATABASE-TYPE
- o should initialise appropriate backend
-
STATUS
o what is the behaviour in CommonSQL (esp :full parameter)?
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
-
- 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
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
-queries: nested subqueries do not seem to work
+queries: nested subqueries are not supported
SQLITE