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.
43 * Revisit result-type list creation,perhaps caching
47 * port Oracle backend to UFFI
48 * large object support
49 * add support for prepared statements
52 NOTES ABOUT THE BACKENDS
56 drop-index: requires a table to be specified with the :from keyword parameter
57 views: mysql does not support views
58 queries: nested subqueries are not supported
59 syntax: doesn't support the sql concatenation operator (||).
63 create-view: column-list parameter not supported
64 syntax: doesn't support the sql SUBSTRING operator.