-GENERAL
+TESTS TO ADD
-* port Oracle backend to UFFI.
+* CACHE-TABLE-QUERIES
+* Test that ":db-kind :key" adds an index for that key. This is complicated by different
+ backends showing autogenerated primary key in different ways.
+* Large object testing
+* Test bigint type
+* :db-constraint tests
+
+POSSIBLE EXTENSIONS
+
+* port Oracle backend to UFFI
+* large object support
+* add support for prepared statements
COMMONSQL SPEC
SELECT
o keyword arg :refresh should function as advertised
- o should return (values result-list field-names)
- o should coerce values returned as strings to appropriate lisp type
-
- QUERY
- o should coerce values returned as strings to appropriate lisp type
- for SQLite backend
-
+
>> The object-oriented sql interface
DEF-VIEW-CLASS
o get :target-slot working
o implement :retrieval :immediate
- DO-QUERY,MAP-QUERY,LOOP
- o should work with object queries as well as functional ones
-
-
>> Symbolic SQL syntax
o Complete sql expressions (see operations.lisp)