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.
12 COMMONSQL INCOMPATIBILITY
15 o Complete sql expressions (see operations.lisp)
18 userenv (Oracle specific)
19 minus (Oracle specific: does the same as EXCEPT)
24 o variables (e.g., table identifiers) should be instantiated at runtime
28 >> The functional sql interface
31 o keyword arg :refresh should function as advertised
33 >> Symbolic SQL syntax
35 o userenv (Oracle specific but deprecated in Oracle 9)
37 VARIANCES FROM COMMONSQL
40 Rather than simply reading the values for each
41 object, to meet CommonSQL spec need to generate a single
42 query to read values for all objects, up to max-len count.
45 COMMIT,ROLLBACK,START-TRANSACTION:
46 When COMMIT or ROLLBACK are called outside of WITH-TRANSACTION, an sql
47 transaction must be explicitly started first with START-TRANSACTION.
51 * Revisit result-type list creation, perhaps caching
55 * extend large object support to databases beyond postgresql, improve large object api
56 * add support for prepared statements
57 * port Oracle backend to UFFI
60 NOTES ABOUT THE BACKENDS
64 drop-index: requires a table to be specified with the :from keyword parameter
65 views: mysql does not support views
66 queries: nested subqueries are not supported
67 syntax: doesn't support the sql concatenation operator (||).
71 create-view: column-list parameter not supported
72 syntax: doesn't support the sql SUBSTRING operator.