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 userenv (Oracle specific but deprecated in Oracle 9)
27 VARIANCES FROM COMMONSQL
30 Rather than simply reading the values for each
31 object, to meet CommonSQL spec need to generate a single
32 query to read values for all objects, up to max-len count.
34 COMMIT,ROLLBACK,START-TRANSACTION:
35 When COMMIT or ROLLBACK are called outside of WITH-TRANSACTION, an sql
36 transaction must be explicitly started first with START-TRANSACTION.
40 * Revisit result-type list creation,perhaps caching
44 * port Oracle backend to UFFI
45 * large object support
46 * add support for prepared statements
49 NOTES ABOUT THE BACKENDS
53 drop-index: requires a table to be specified with the :from keyword parameter
54 views: mysql does not support views
55 queries: nested subqueries are not supported
56 syntax: doesn't support the sql concatenation operator (||).
60 create-view: column-list parameter not supported
61 syntax: doesn't support the sql SUBSTRING operator.