3 * test on mcl. SCL no longer affordable to individuals;
4 * implement remaining functions for CLSQL AODBC backend;
5 * port Oracle backend to UFFI.
12 *CACHE-TABLE-QUERIES-DEFAULT*
13 *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
20 >> Initialisation and connection
22 INITIALIZE-DATABASE-TYPE
23 o should initialise appropriate backend
26 o what is the behaviour in CommonSQL (esp :full parameter)?
29 >> The functional sql interface
32 o keyword arg :refresh should function as advertised
33 o should return (values result-list field-names)
34 o should coerce values returned as strings to appropriate lisp type
37 o should return (values result-list field-names)
38 o should coerce values returned as strings to appropriate lisp type
41 o should return list of (attribute datatype precision scale nullable)
44 >> The object-oriented sql interface
47 o get :target-slot working
48 o implement :retrieval :immediate
50 DO-QUERY,MAP-QUERY,LOOP
51 o should work with object queries as well as functional ones
54 >> Symbolic SQL syntax
56 o Complete sql expressions (see operations.lisp)
70 o variables (e.g., table identifiers) should be instantiated at runtime
74 NOTES ABOUT THE BACKENDS
78 drop-index: requires a table to be specified with the :from keyword parameter
79 transactions: don't seem to work
80 views: mysql does not support views
81 queries: nested subqueries do not seem to work
85 create-view: column-list parameter not supported