4 * Test that ":db-kind :key" adds an index for that key. This is complicated by different
5 backends showing autogenerated primary key in different ways.
18 >> The functional sql interface
21 o keyword arg :refresh should function as advertised
23 >> Symbolic SQL syntax
25 o Complete sql expressions (see operations.lisp)
28 userenv (Oracle specific)
29 minus (Oracle specific: does the same as EXCEPT)
31 o variables (e.g., table identifiers) should be instantiated at runtime
34 VARIANCES FROM COMMONSQL
37 Rather than simply reading the values for each
38 object, to meet CommonSQL spec need to generate a single
39 query to read values for all objects, up to max-len count.
41 COMMIT,ROLLBACK,START-TRANSACTION:
42 When COMMIT or ROLLBACK are called outside of WITH-TRANSACTION, an sql
43 transaction must be explicitly started first with START-TRANSACTION.
47 * Revisit result-type list creation,perhaps caching
51 * port Oracle backend to UFFI
52 * large object support
53 * add support for prepared statements
56 NOTES ABOUT THE BACKENDS
60 drop-index: requires a table to be specified with the :from keyword parameter
61 views: mysql does not support views
62 queries: nested subqueries are not supported
63 syntax: doesn't support the sql concatenation operator (||).
67 create-view: column-list parameter not supported
68 syntax: doesn't support the sql SUBSTRING operator.