X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=4c28e01853502ae762c0fe8cff84c60efcb3b625;hb=2f185bf0167aa5a0be8e82a0c1ee961ca28f1426;hp=c373914cbb900e9cfedd4d16c7ac0dc6d423e956;hpb=75defa0ce7e93c50c87fe272632dcdd942e80d49;p=clsql.git diff --git a/TODO b/TODO index c373914..4c28e01 100644 --- a/TODO +++ b/TODO @@ -8,40 +8,14 @@ TESTS TO ADD * test *db-auto-sync* * for-each-row macro * universal-time +* owner phrases for postgresql and oracle backends COMMONSQL INCOMPATIBILITY -<<<<<<< .mine - o Complete sql expressions (see operations.lisp) - - nvl (Oracle specific) - userenv (Oracle specific) - minus (Oracle specific: does the same as EXCEPT) - || - -======= ->>>>>>> .r9364 - o variables (e.g., table identifiers) should be instantiated at runtime - -<<<<<<< .mine -======= - >> The functional sql interface - - SELECT - o keyword arg :refresh should function as advertised - - >> Symbolic SQL syntax - - o userenv (Oracle specific but deprecated in Oracle 9) + o userenv (Oracle specific but deprecated in Oracle 9) VARIANCES FROM COMMONSQL -UPDATE-OBJECT-JOINS: - Rather than simply reading the values for each - object, to meet CommonSQL spec need to generate a single - query to read values for all objects, up to max-len count. - ->>>>>>> .r9364 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. @@ -56,17 +30,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.