X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=TODO;h=37c182948972d187388ca2ef87fcd51fb9362e99;hp=4c28e01853502ae762c0fe8cff84c60efcb3b625;hb=333e8280f2f3438ffd379349bc9746c34cccc159;hpb=2f185bf0167aa5a0be8e82a0c1ee961ca28f1426 diff --git a/TODO b/TODO index 4c28e01..37c1829 100644 --- a/TODO +++ b/TODO @@ -9,16 +9,18 @@ TESTS TO ADD * 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 +* Number and Char field types 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. +CLSQL starts with in transaction AUTOCOMMIT mode. To begin a transaction, +START-TRANSACTION has to be called. OPTIMIZATIONS