X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=TODO;h=9a4acf7f3ae68350b7d1e3c2aaafc90a51baa8af;hp=24477fd48776d64faa13124b12c6923e13c67506;hb=31507a81fff1da3460625fbc07107de931907a8e;hpb=15d9bb598423a2098ffd07fcf578e01550cdadfe diff --git a/TODO b/TODO index 24477fd..9a4acf7 100644 --- a/TODO +++ b/TODO @@ -3,22 +3,17 @@ 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 - -COMMONSQL INCOMPATIBILITY - - o Condition names/accessors - o userenv (Oracle specific but deprecated in Oracle 9) - +* owner phrases for postgresql and oracle backends +* Number and Char field types +* Add test case for return type of (setf slot-value-using-class) + 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 @@ -30,17 +25,3 @@ POSSIBLE EXTENSIONS * add support for prepared statements * port Oracle backend to UFFI - -NOTES ABOUT THE BACKENDS - -MYSQL - -drop-index: requires a table to be specified with the :from keyword parameter -views: mysql does not support views -queries: nested subqueries are not supported -syntax: doesn't support the sql concatenation operator (||). - -SQLITE - -create-view: column-list parameter not supported -syntax: doesn't support the sql SUBSTRING operator.