X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=87dd9391c64eed0820e90f640d9ab565374eeb3c;hb=bf2c17ae4cb07adab3bbff036228572287936d75;hp=2daf98af477aedaa73886e7f3cdce3d0f3f7d96e;hpb=dfddee2b4dcdd570ba35122076f35a1aa7516c89;p=clsql.git diff --git a/TODO b/TODO index 2daf98a..87dd939 100644 --- a/TODO +++ b/TODO @@ -3,27 +3,19 @@ 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 * :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 -* test mixed case table identifiers and column identifiers +* Number and Char field types +* Add test case for return type of (setf slot-value-using-class) +* symbol slot +* generalized-boolean slot -COMMONSQL INCOMPATIBILITY - - o doesn't support CHAR and NUMBER types as shown on CREATE-TABLE reference page - o (string n) => VARCHAR(n) rather than CHAR(n) - 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. +CLSQL starts with in transaction AUTOCOMMIT mode. To begin a transaction, +START-TRANSACTION has to be called. OPTIMIZATIONS @@ -31,7 +23,8 @@ OPTIMIZATIONS POSSIBLE EXTENSIONS -* extend large object support to databases beyond postgresql, improve large object api +* extend large object support to databases beyond postgresql +* improve large object api * add support for prepared statements -* port Oracle backend to UFFI +