X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=TODO;h=70d7e2043a8e5a4601715384eaf2894a9e44f7ee;hp=e9e23a9cb0c2cae173fdca9d7d30610355d6f095;hb=fdd069770e32d0cfa4b66d6e5cfd4540197660ba;hpb=38da4a41e87a8274f95c536c3086815b99ef4a61 diff --git a/TODO b/TODO index e9e23a9..70d7e20 100644 --- a/TODO +++ b/TODO @@ -1,34 +1,26 @@ TESTS TO ADD * CACHE-TABLE-QUERIES -* Test that ":db-kind :key" adds an index for that key. This is complicated by different - backends showing autogenerated primary key in different ways. -* Test bigint type +* Test that ":db-kind :key" adds an index for that key. This is complicated by + different backends showing autogenerated primary key in different ways. * :db-constraint tests * test *db-auto-sync* * for-each-row macro -* universal-time * owner phrases for postgresql and oracle backends -* test of large table with large numbers of rows, greater than 2x the number of - rows (200) returned by the oracle backend at a time - -COMMONSQL INCOMPATIBILITY - - o userenv (Oracle specific but deprecated in Oracle 9) - -VARIANCES FROM COMMONSQL - -COMMIT,ROLLBACK,START-TRANSACTION: - When COMMIT or ROLLBACK are called outside of WITH-TRANSACTION, an sql - transaction must be explicitly started first with START-TRANSACTION. +* Number and Char field types +* Add test case for return type of (setf slot-value-using-class) +* symbol slot +* generalized-boolean slot OPTIMIZATIONS * Revisit result-type list creation, perhaps caching +* Rework LIST-ATTRIBUTE-TYPES and LIST-INDEXES such that they exhibit their + current behaviours using single database queries. POSSIBLE EXTENSIONS -* extend large object support to databases beyond postgresql, improve large object api +* improve large object api and extend to databases beyond postgresql * add support for prepared statements -* port Oracle backend to UFFI +