+17 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * doc/ref-fdml.xml: document CACHE-TABLE-QUERIES.
+ * tests/test-fdml.xml: add test for CACHE-TABLE-QUERIES.
+ * doc/ref-ooddl.xml: minor changes to syntax and examples entries
+ for uniformity.
+ * doc/ref-oodml.xml: add examples for OODML.
+ * sql/oodml.lisp: ensure SELECT passes on its REFRESH argument
+ to FIND-ALL.
+ * sql/metaclasses.lisp: update docstrings.
+ * tests/test-init.lisp: change :db-constraints for emplid to
+ (:not-null :unique) as a temporary test for multiple column constraints
+ in DEF-VIEW-CLASS.
+ * tests/test-oodml.lisp: add tests for *DB-AUTO-SYNC* and
+ return type of (SETF SLOT-VALUE-USING-CLASS).
+ * TODO, doc/TODO: remove items done.
+ * README: fix typo.
+
+16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/oodml.lisp: on Lispworks, use weak valued hash tables for
+ object caching.
+ * sql/expressions.lisp: Fix SQL generation for the symbol NIL.
+
+16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/expressions.lisp: reactivate caching of generated SQL strings.
+ Move methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY
+ here from sql/fdml.lisp. Rationalise behaviour of SQL-OUTPUT,
+ OUTPUT-SQL and DATABASE-OUTPUT-SQL.
+ * sql/fdml.lisp: remove disabled method ADD-STORAGE-CLASS. Move
+ methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY to
+ sql/expressions.lisp.
+ * sql/ooddl.lisp: replace call to DATABASE-OUTPUT-SQL in
+ DATABASE-PKEY-CONSTRAINT with call to SQL-OUTPUT.
+ * sql/generics.lisp: add docstrings.
+
+15 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.16
+ * db-oracle/oracle-sql.lisp: Remove OpenMCL specific
+ code in favor of fixing UFFI with James Bielman's patch
+
+14 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.15
+ * db-oracle/oracle-sql.lisp: Apply patch for OpenMCL/OSX
+ from James Bielman
+
+14 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * README, INSTALL: update URLs. Minor updates to descriptions.
+ * tests/README: remove stuff about editing contexts.
+
+12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-oracle/oracle-objects.lisp: Change *default-varchar-length* to
+ *default-string-length*
+
+12 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * tests/test-syntax.lisp, tests/test-fdml.lisp: add tests for escaping
+ of single quotes.
+ * tests/test-fddl.lisp: add tests for column and table constraints
+ in CREATE-TABLE. Add test for OWNER keyword parameter to
+ LIST-TABLES (assuming same underlying machinery in other FDDL
+ functions).
+ * tests/test-init.lisp: restrict above test to postgresql and oracle.
+
+12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-sqlite/sqlite-sql.lisp: Fix condition as reported by Aurelio
+ Bignoli.
+
+11 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp, sql/package.lisp, doc/ref-ooddl.lisp, db-mysql/mysql-objects.lisp: Add tinyint type
+
+10 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.14
+ * doc/*.xml: documentation additionals and fixes so
+ that docbook passes xmllint.
+
+9 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.13
+ * sql/fdml.lisp: Apply patch from Kim Minh Kaplan
+ to change escaping of single quotes. Mild optimizations
+ for escaped string output.
+ * doc/ref-ooddl.lisp: documentation additions
+ * doc/ref-oodml.lisp: Add purpose to functions
+ * TODO: Add need to test single quote escaping
+
+7 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * doc/ref-ooddl.xml, doc-ref-oodml.xml: documentation additions
+ * sql/ooddl.lisp: Added SMALLINT type
+ * sql/generic-postgresql.lisp: Added INT2 as SMALLINT type
+ * db-mysql/mysql-objects.lisp: Added SMALLINT type
+ * sql/package.lisp: Export SMALLINT
+ * sql/expressions.lisp: Add MYSQL's UNSIGNED and ZEROFILL as
+ db-constraints
+
+6 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/expressions.lisp: add AUTO-INCREMENT and UNIQUE to the
+ recognised column constraints for CREATE-TABLE and the :DB-CONSTRAINTS
+ View Class slot option.
+ * sql/ooddl.lisp: fix bug preventing the :DB-CONSTRAINTS View Class
+ slot option accepting a list of constraints [reported by Travis Cross].
+ * doc/ref-fddl.xml: add some examples of specifying column and
+ table constraints to the documentation for CREATE-TABLE.
+ * TODO: add note about adding tests for table/column constraints. Add
+ optimisation note about using cached attribute types in insert/update
+ operations.
+
+3 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * doc/appendix.xml: add notes about idiosyncrasies/unsupported
+ features and so on the documentation for each backend.
+ * doc/TODO: remove items done.
+ * doc/ref-transaction.xml: add note in introduction about
+ autocommit mode as a difference from CommonSQL.
+ * doc/ref-syntax.xml: add notes about SQL syntax state functions
+ being macros in CLSQL. Add note about SQL operators which are
+ CLSQL extensions.
+
+2 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * Version 2.11.12 released
+ * doc/ref-recording.xml: document SQL I/O recording.
+ * doc/ref-prepared.xml: new file for documenting prepared statements.
+ * doc/clsql.xml: comment out include for large object and CLSQL-SYS
+ documentation.
+ * doc/ref-conditions.xml: complete documentation of condition system.
+ * doc/global-index.xml: add symbols from condition system and remove
+ those from LOB and prepared statement APIs.
+ * doc/ref-fdml.xml: complete documentation of FDML.
+ * doc/glossary.xml: add View Class.
+ * doc/TODO: remove items done.
+ * sql/conditions.lisp: make SQL-CONDITION a parent of SQL-ERROR.
+ * sql/package.lisp: remove FOR-EACH-ROW from exports list. Export
+ additional slot accessors for condition classes.
+
+1 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * doc/ref-ooddl.lisp: Add documentation
+ * doc/ooddl.lisp: Move *DEFAULT-VARCHAR-LENGTH* from oodml.lisp
+ and rename to *DEFAULT-STRING-LENGTH*. Add docstring.
+ * doc/oodml.lisp: Rename references to new name of
+ *DEFAULT-STRING-LENGTH*
+
+1 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * doc/ref-transaction.xml: document transaction handling.
+ * sql/transaction.lisp: ensure that COMMIT, ROLLBACK and
+ START-TRANSACTION return NIL as per the CommonSQL spec. Modify
+ ADD-TRANSACTION-{ROLLBACK|COMMIT}-HOOK such that a database is
+ passed as a keyword argument defaulting to *DEFAULT-DATABASE*.
+ Added docstrings.
+
+30 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * doc/ref-fdml.xml: document the FDML.
+ * doc/ref-fddl.xml: move documentation for TRUNCATE-DATABASE here.
+ * sql/ooddl.lisp: moved *default-varchar-length* to here from
+ oodml.lisp and renamed to *default-string-length*
+
+23 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Add keyword :transactions to def-view-from-class
+ to allow specifying transactionless table creation
+ * doc/ref-oodml.lisp: Add new keyword to signature of
+ DEF-VIEW-FROM-CLASS
+
+18 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * Version 2.11.11
+ * sql/expressions.lisp: when removing duplicate table identifiers
+ in the FROM clause of a query, check both table name and alias
+ are equivalent.
+ * sql/fdml.lisp: remove DESCRIBE-TABLE.
+ * sql/db-interface.lisp: remove generics DESCRIBE-TABLE and
+ DATABASE-DESCRIBE-TABLE.
+ * sql/package.lisp: remove DESCRIBE-TABLE, DATABASE-DESCRIBE-TABLE
+ and LIST-TABLE-INDEXES.
+ * sql/generic-postgresql.lisp: add reader conditional #+nil for
+ DATABASE-DESCRIBE-TABLE and comment about its uses for
+ re-implementing LIST-ATTRIBUTE-TYPES with a single SQL query
+ returning type info for all attributes.
+ Fix DATABASE-SEQUENCE-LAST.
+ * sql/fddl.lisp: remove LIST-TABLE-INDEXES and redefine
+ LIST-INDEXES with additional keyword parameter :ON.
+ * tests/test-fddl.lisp: replace LIST-TABLE-INDEXES in :fddl/index/3
+ with LIST-INDEXES (with :ON parameter).
+ * doc/global-index.xml: remove DESCRIBE-TABLE and LIST-TABLE-INDEXES.
+ * doc/ref-connect.xml: minor tidying.
+ * doc/ref-fddl.xml: document the FDDL.
+ * doc/TODO: removed items done. Moved note about transaction handling
+ from TODO to here.
+ * TODO: move note about transaction handling to doc/TODO. Added
+ optimization note about LIST-ATTRIBUTE-TYPES and LIST-INDEXES.
+
+13 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * Version 2.11.10
+ * sql/syntax.lisp: updated docstrings.
+ * sql/package.lisp: exported DATABASE-NAME-FROM-SPEC from CLSQL
+ package.
+ * sql/database.lisp: add docstrings for CREATE-DATABASE,
+ DESTROY-DATABASE, TRUNCATE-DATABASE and LIST-DATABASES. Replace
+ CLSQL-GENERIC-ERROR signalled in RECONNECT with SQL-CONNECTION-ERROR.
+ * doc/ref-syntax.xml, doc/global-index.xml: minor tidying.
+ * doc/ref-connect.xml: document connection/initialisation.
+ * doc/ref-fdml.xml: move TRUNCATE-DATABASE reference entry here.
+ * doc/TODO: remove items done.
+ * Makefile: add db-oracle to to SUBDIRS.
+
+13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Add new serialization functions:
+ WRITE-INSTANCE-TO-STREAM and READ-INSTANCE-FROM-STREAM
+ * sql/expressions.lisp: Avoid duplicate FROM names when selecting
+ from a table that has more than one primary index.
+ * sql/conditions.lisp: Fix printing of closed-database error
+
+13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.9
+ * sql/conditions.lisp: Set initial slot value for message in SQL-WARNING
+ * sql/transactions.lisp: Correctly set slots of SQL-WARNING
+
+12 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/package.lisp: export DATABASE-TYPE from CLSQL and subclasses
+ of SQL-EXPRESSION from CLSQL-SYS.
+ * sql/syntax.lisp: make error signalled in SQL-OPERATION an
+ SQL-USER-ERROR. Make SQL-OPERATOR return just one value.
+ * doc/Makefile: added Mandrake linux.
+ * doc/catalog-redhat.xml, doc/catalog-mandrake.xml: new files.
+ * doc/appendix.xml: fixed little typo (adsf).
+ * doc/glossary.xml: removed closed-database and note about
+ sql-expression, added some entries.
+ * doc/ref-syntax.xml: documented the symbolic SQL syntax.
+
+10 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.8
+ * db-mysql/mysql-loader.lisp: Remove load of unnecessary zlib library
+ * multiple: Add generalized-boolean type as requested by
+ Edi Weitz
+ * TODO: Added need for test of generalized-boolean
+
+9 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.7 released
+ * uffi/clsql-uffi-loader.lisp: Apply patch from Edi Weitz
+ for loading with clc-register-user-package. Remove personal
+ directory from path lisp.
+ * db-mysql/mysql-loader.lisp: Similar changes
+
+8 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.6 released
+ * sql/oodml.lisp: Commit patch from Edi Weitz
+ to fix symbol writing/reading
+ * TODO: Add need for symbol slot test
+
+7 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/package.lisp: remove duplicate export of
+ *CACHE-TABLE-QUERIES-DEFAULT*.
+ * doc/ref-*.xml, doc/global-index.xml: new files documenting
+ the CommonSQL compatible api.
+ * tests/test-fdml.lisp: modified the test :fdml/transaction/3 to
+ reflect changes in return values of WITH-TRANSACTION.
+
04 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
* tests/README: Fix filename [reported by Bill Clementson]
* sql/transactions.lisp: Apply return value patch from
projects / clsql.git / blobdiff