X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=TODO;h=e9e23a9cb0c2cae173fdca9d7d30610355d6f095;hp=2dcbf4cd4e91fb4912848018ab016aab88073291;hb=38da4a41e87a8274f95c536c3086815b99ef4a61;hpb=1bac7acdc0e57f7d430d7fa6f79478811db38b6f diff --git a/TODO b/TODO index 2dcbf4c..e9e23a9 100644 --- a/TODO +++ b/TODO @@ -8,10 +8,12 @@ TESTS TO ADD * 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 variables (e.g., table identifiers) should be instantiated at runtime o userenv (Oracle specific but deprecated in Oracle 9) VARIANCES FROM COMMONSQL @@ -30,17 +32,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.