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
14 o variables (e.g., table identifiers) should be instantiated at runtime
15 o userenv (Oracle specific but deprecated in Oracle 9)
17 VARIANCES FROM COMMONSQL
19 COMMIT,ROLLBACK,START-TRANSACTION:
20 When COMMIT or ROLLBACK are called outside of WITH-TRANSACTION, an sql
21 transaction must be explicitly started first with START-TRANSACTION.
25 * Revisit result-type list creation, perhaps caching
29 * extend large object support to databases beyond postgresql, improve large object api
30 * add support for prepared statements
31 * port Oracle backend to UFFI
34 NOTES ABOUT THE BACKENDS
38 drop-index: requires a table to be specified with the :from keyword parameter
39 views: mysql does not support views
40 queries: nested subqueries are not supported
41 syntax: doesn't support the sql concatenation operator (||).
45 create-view: column-list parameter not supported
46 syntax: doesn't support the sql SUBSTRING operator.