From e5a6fadf80e923a4fa08fbb8af16652d7970983e Mon Sep 17 00:00:00 2001 From: Marcus Pearce Date: Tue, 18 May 2004 09:51:00 +0000 Subject: [PATCH] r9389: Additions to doc/TODO. --- ChangeLog | 6 ++++++ TODO | 14 -------------- doc/TODO | 31 ++++++++++++++++++++++++++----- sql/base-classes.lisp | 1 - 4 files changed, 32 insertions(+), 20 deletions(-) diff --git a/ChangeLog b/ChangeLog index dbba786..530aa69 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,9 @@ +18 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk) + * TODO: moved notes about backends to doc/TODO. + * doc/TODO: added notes about backends and select extensions. + * sql/base-classes.lisp: remove obsolete schema slot in database + class. + 16 May 2004 Kevin Rosenberg (kevin@rosenberg.net) * db-oracle/oracle-api: Add OCIServerVersion * db-oracle/oracle-sql: Query and store server version on connect diff --git a/TODO b/TODO index 24477fd..58e6660 100644 --- a/TODO +++ b/TODO @@ -30,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. diff --git a/doc/TODO b/doc/TODO index c55c54b..b288ef0 100644 --- a/doc/TODO +++ b/doc/TODO @@ -7,7 +7,7 @@ DOCUMENTATION TO DO LIST 2. Underdocumented CommonSQL features: - Retrieval immediate - - SQL operators: ||, SUBSTR, EXCEPT, INTERSECT, UNION ... + - SQL operators: ||, SUBSTR, MINUS, INTERSECT, UNION, NVL 2. CLSQL extensions to CommonSQL @@ -16,7 +16,8 @@ DOCUMENTATION TO DO LIST - New types such as wall-time, boolean, and bigint - SQL operators: group-by, limit, not-null, ==, is, having, the, uplike, - sql-view-class (just from a quick scan of operations.lisp) + sql-view-class, coalesce, except (just from a quick scan of + operations.lisp) - FDDL: list-views, view-exists-p, list-indexes, list-table-indexes, index-exists-p, create-sequence, drop-sequence, list-sequences, @@ -24,9 +25,29 @@ DOCUMENTATION TO DO LIST - OODML: *db-auto-sync* -4. Documenting lower level, non-CommonSQL functions like connection - pools and database-query-result-set. Some of this is already done. + - SELECT: additional keyword arguments accepted include :LIMIT, :OFFSET, + :INNER-JOIN and :ON. -5. Notes on any features unsupported by each of the backends. +4. Documenting lower level, non-CommonSQL functions (some of this is already + done). + - connection pools + - database-query-result-set + +5. Notes on any peculiarities of each of the backends (e.g., unsupported + features, notable extensions etc.). + + - MYSQL + + drop-index: requires a table to be specified with the :from parameter + views: mysql does not support views + queries: nested subqueries are not supported + syntax: doesn't support the sql concatenation operator (||). + doesn't support INTERSECT/EXCEPT set operations. + + - SQLITE + + connection: specifying ":memory:" gives you an SQLite database in RAM. + create-view: column-list parameter not supported + syntax: doesn't support the sql SUBSTRING operator. diff --git a/sql/base-classes.lisp b/sql/base-classes.lisp index 98980d4..7ebbc5c 100644 --- a/sql/base-classes.lisp +++ b/sql/base-classes.lisp @@ -33,7 +33,6 @@ (result-recording-stream :accessor result-recording-stream :initform nil) (record-caches :accessor record-caches :initform nil) (view-classes :accessor database-view-classes :initform nil) - (schema :accessor database-schema :initform nil) (transaction-level :initform 0 :accessor transaction-level) (transaction :initform nil :accessor transaction) (conn-pool :initform nil :initarg :conn-pool :accessor conn-pool) -- 2.34.1