3 * implement remaining functions for CLSQL AODBC backend;
4 * port Oracle backend to UFFI.
11 *CACHE-TABLE-QUERIES-DEFAULT*
12 *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
19 >> Initialisation and connection
21 INITIALIZE-DATABASE-TYPE
22 o should initialise appropriate backend
25 o what is the behaviour in CommonSQL (esp :full parameter)?
28 >> The functional sql interface
31 o keyword arg :refresh should function as advertised
32 o should return (values result-list field-names)
33 o should coerce values returned as strings to appropriate lisp type
36 o should coerce values returned as strings to appropriate lisp type
39 o should return list of (attribute datatype precision scale nullable)
42 >> The object-oriented sql interface
45 o get :target-slot working
46 o implement :retrieval :immediate
48 DO-QUERY,MAP-QUERY,LOOP
49 o should work with object queries as well as functional ones
52 >> Symbolic SQL syntax
54 o Complete sql expressions (see operations.lisp)
68 o variables (e.g., table identifiers) should be instantiated at runtime
72 NOTES ABOUT THE BACKENDS
76 drop-index: requires a table to be specified with the :from keyword parameter
77 views: mysql does not support views
78 queries: nested subqueries are not supported
82 create-view: column-list parameter not supported