+16 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * version 3.4.6
+ * sql/metaclasses.lisp: Avoid calling change-class on
+ effective-slot-definitions on sbcl to conform to sbcl 0.9.6.38
+ changes.
+
+15 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.4.5
+ * sql/expressions.lisp: Patch from James Biel to add subselects
+
+14 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.4.4 [ Requires UFFI 1.5.7+]
+ * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
+ to fix lifetime of foreign strings for Oracle calls
+
+13 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.4.3
+ * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
+ to improve performance
+
+12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.4.2
+ * clsql-uffi.asd: Patch from James Biel improving loading
+ * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
+ to support 64-bit lisps
+
+12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.4.1
+ * sql/expressions.lisp: Escape numbers to SQL strings
+ at expression level.
+
+11 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.4: Add MySQL 5 support
+ * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
+ * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5
+ * doc/mysql-macosx-notes.txt: New document from Martin Brooks
+
+7 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL
+ function.
+ * BUGS: Added report for update-object-joins by Aleksandar Bakic
+
+4 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.3.4 [UFFI >= 1.5.5 needed]
+ * db-odbc/odbc-api.lisp: Apply patch from Yaroslav Kavenchuk
+ to add missing #\' character.
+ * clsql.asd: Add support for CLSQLINIT environmental variable,
+ based on patch from Yaroslav Kavenchcuk. New version of UFFI
+ required.
+
+30 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.3.3
+ * sql/oodml.lisp: Apply patch from Drew Crampsie to fix
+ update-objects-joins when using the :target-slot attribute
+
+26 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.3.2
+ * sql/expressions.lisp: Avoid parenthesis on multiple group-by fields
+ as noted by Harald Hanche-Olsen.
+ * tests/test-syntax.lisp: Add test for multiple field group-by
+
+25 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.3.1
+ * sql/time.lisp: Commit patch from Alan Shields to
+ display escape string on wall-time display only when *print-escape*
+ is true.
+
+11 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/metaclasses.lisp: Commit patch from Will to
+ properly set db-reader slot in effective-slot-definition
+ * sql/expressions.lisp: Commit patch from Alan Shields
+ adding make-load-form for sql-relational-exp
+ * sql/generic-postgresql.lisp: Commit patch from Aleksandar Bakic
+ adding support for new NUMBER type
+
+17 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.3.0
+ * sql/time.lisp: Apply patch from Alan Shields adding DATE type.
+ * doc/ref-ooddl.xml: Documentation of new type
+ * notes/add-type-hints.txt: New file from Alan Shields
+ * sql/fddl.lisp: Add owner keyword to drop-table as suggested
+ by Francis Leboutte
+ * db-postgresql-socket/postgresql-socket-sql.lisp: Fix database-probe
+ as noted by Francis Leboutte. Similar fix applied to db-mysql and
+ db-postgresql.
+ * sql/expressions.lisp: Allow string table names for output as
+ contributed by Francis Leboutte.
+ * examples/clsql-tutorial.lisp: Support :postgresql-socket as noted
+ by Francis Leboutte
+
+08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.2.4
+ * doc/into.xml: Change download from ftp to http protocol
+
+08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.2.3
+ * db-oracle/oracle-sql.lisp: Correction for v3.2.2 changes by
+ Edi Weitz
+
+08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.2.2
+ * db-oracle/oracle-sql.lisp: Add check for zero increment as
+ suggested by Edi Weitz. Add missing database-sequence-last function
+ as noted and tested by Edi Weitz. Ensure that UFFI buffer is freed
+ in handle-oci-error. Add unwind-protect to sql-stmt-exec. Free UFFI
+ stmthp object when query cursor is freed with OCI.
+
+22 Aug 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * uffi/clsql-uffi-loader.lisp: Commit patch from astor@pvv.ntnu.no to
+ display search path when error occurs loading foreign library.
+
+05 Jul 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.2.1
+ * doc/appendix.xml: Incorporate Edi Weitz's notes into documentation
+ with changes to support case-sensitive lisp implementations. Add
+ paragraph on using /etc/clsql-init.lisp site initialization file.
+ * clsql.asd: Load file /etc/clsql-init.lisp, if it
+ exists, after package is loaded to set site-specific configuration
+
+2005-06-24 Edi Weitz <edi@agharta.de>
+ * sql/db-interface.lisp: Added new special variable
+ *FOREIGN-LIBRARY-SEARCH-PATHS* and function PUSH-LIBRARY-PATH to
+ manipulate it.
+ * sql/package.lisp: Export these.
+ * uffi/clsql-uffi-loader.lisp: Used new variable; changed order of
+ libs.
+ * db-mysql/mysql-loader.lisp: Changed order of libs.
+
+09 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.2.0: REQUIRES UFFI VERSION 1.4.38 OR HIGHER
+ * clsql-mysql.asd: Renamed clsql/mysql interface library from
+ mysql to clsql_mysql
+ * clsql-uffi.asd: Renamed clsql/uffi interface library from
+ mysql to clsql_uffi
+ * uffi/clsql_uffi.c: Renamed from uffi.c
+ * db-mysql/clsql_mysql.c: Renamed from mysql.c
+ * db-mysql/Makefile, db-mysql/Makefile.msvc, db-mysql/mysql-loader.lisp: Rename shared library
+ * uffi/Makefile, uffi/Makefile.msvc, uffi/uffi-loader.lisp: Rename shared library
+ * db-*/*-loader.lisp: Commit big patch from Edi Weitz to remove
+ absolute pathnames when searching for foreign libraries.
+ foreign library loading.
+
+07 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.16
+ * db-mysql/mysql-api.lisp: Commit patch from Espen Wiborn
+ to support UTF-8 on sbcl unicode.
+
+18 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.15
+ * sql/time.lisp: Fix bug in roll that caused failure in test suite
+
+17 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.14
+ * sql/oodml.lisp: Properly handle when db-writer is NIL
+
+11 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/expressions.lisp: Avoid using simple-string declaration when
+ a non-simple string may be encountered. [issue noted by
+ will@cesmail.net] Add a simple-string declaration for a local
+ string generated.
+
+06 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Change db-writer and db-reader processing to accept
+ a symbol as well as function to serve as a function designator
+ [issue noted by will@cesmail.net]
+
+05 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.13
+ * sql/time.lisp: Fix error in submitted patch which caused error
+ in timestrings with 19 or less characters.
+
+27 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.12
+ * db-postgresql-socket/postgresql-api.lisp: Commit patch from Tim Howe
+ to fix read-socket-sequence on non-sb-unicode sbcl.
+
+26 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.12
+ * sql/time.lisp: Commit patch from Daniel Lowe which adds support
+ for fractional seconds which is required by PostgreSQL
+ * db-postgresql/postgresql-loader.lisp: Add library path for Windows
+
+25 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/csql.lisp: Update URL for "SQL for Web Dummies" [Sean Champ]
+
+24 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.11
+ * sql/syntax: Commit patch from Alan Shields to supress reader
+ macros when *read-supress* is T.
+
+13 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.10
+ * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
+ from Janis Dzerins to support unicode on SBCL
+ * sql/syntax: Commit patch from Alan Shields to improve reporting
+ of invalid syntax statements.
+
+06 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.9
+ * db-mysql/mysql-sql.lisp: Add port to connection specification
+ based on patch from Dave Watson
+ * doc/appendix.xml: Document MySQL port parameter to connection spec
+
+03 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.8
+ * sql/time.lisp: Patch from Keith James for parsing ISO-8601 timestamps
+
+18 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Add missing database argument [Patch from
+ Alan Caulkins]
+
+03 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Improve database priority in
+ update-records-from-instance [Patch from Walter C. Pelissero]
+
+17 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.7
+ * sql/package.lisp: Export database-reconnect from clsql-sys
+
+08 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Use explicit database in fault-join-target-slot
+ [Patch from Walter Pelissero]
+
+29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-postgresql/postgresql-loader.lisp: Add additional
+ directories to Fink on darwin [patch from Cyrus Harmon].
+
+29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.6
+ * sql/oodml.lisp: Clear view instance cache when delete-instance-records
+ is invoked [suggested by Alan Shutko].
+ * uffi/clsql-uffi-loader.lisp: Improvements for loading with SBCL X86-64
+ * sql/metaclasses.lisp: Don't change case of a :base-table string supplied
+ to def-view-class [fix suggested by Fred Gilham].
+
+25 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * tests/*.lisp: Change Vladamir to Vladimir per Cyrus Harmon's
+ suggestion.
+ * sql/utils.lisp: Fix unnecessary consing noted by Fred Gilham.
+ * doc/*.xml: Fix spelling of Vladimir
+
+24 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * doc/bookinfo.xml, doc/csql.xml, doc/intro.xml: Update links
+ now that LispWorks is an independant company [noted by
+ Martin Thornquist]
+
+22 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-sqlite/sqlite-sql.lisp, db-sqlite3/sqlite3-sql.lisp:
+ Better support for 64 bit environments
+
+05 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.5
+ * sql/metaclass.lisp: Make t the default value of :set
+ [noted by Cyrus Harmon]
+
+28 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.4
+ * uffi/clsql-uffi.lisp: Add support for unsigned integers
+ * db-mysql/mysql-sql.lisp: Add support for detecting/marking
+ unsigned integers. Apply patch from Yannick Gingras to
+ implement database-sequence-last.
+
+26 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * doc/ref-fdml.lisp: Fix variable tag name to varname
+ [noted by Eduardo Munoz]
+ * db-mysql/mysql-loader.lisp: Handle library paths for 64-bit systems
+
+06 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.2
+ * sql/ooddl.lisp: Accept patch from Klaus Harbo for
+ update-object-joins.
+ * sql/metaclass.lisp: Remove unnecssary (and runtime error
+ causing) change-class invocation when running on CLISP.
+ * db-mysql/mysql-api.lisp: Commit patch from Paul Werkowski
+ to fix structure name.
+ * sql/database.lisp: More specific error message with trying
+ to use a database value of NIL.
+ * sql/expressions.lisp: Accept a string for the table name
+ in (sql-output sql-delete database) [suggested by Ed Symanzik].
+
+11 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.1
+ * sql/generic-postgresql.lisp: Commit patch from Chris Capel to
+ ignore columns which have been dropped.
+ * clsql-postgresql-socket.asd, db-postgresql-socket/postgresql-socket-package.lisp:
+ Use sb-md5 package on SBCL, recommended by Chris Capel
+
+09 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.1.0 released: New SQLite3 backend by Aurelio Bignoli
+ * doc/appendix.xml: Document SQLITE3 backend, patch by Aurelio Bignoli
+ * sql/operations.lisp: Add lower and upper SQL functions [Daniel Lowe].
+
+08 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/expressions.lisp: Fix slot name [thanks to Daniel Lowe]
+
+31 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * clsql-sqlite3, db-sqlite3/*: NEW BACKEND
+ contributed by Aurelio Bignoli
+
+23 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/oodml.lisp: Commit patch from Walter Pelis
+ to use an object's database for a select on its slot.
+
+20 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * uffi/uffi.c, uffi/clsql-uffi.lisp: Commit patch from
+ Aurelio Bignoli to fix negative 64-bit integers
+
+07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-mysql/mysql.c: Fix parameters in bind_param call
+
+07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * uffi/clsql-uffi.lisp: Add support for :blob result-type
+ * db-mysql/mysql-sql.lisp: Add support for :blob
+ result-type
+
+04 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-mysql/mysql-sql.lisp, db-db2/db2-sql.lisp: Add
+ missing quotes for types in code that is still in development
+ (thanks to Joerg Hoehle)
+
+03 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.8 released
+ * db-sqlite/sqlite-*.lisp: Apply patch from
+ Aurelio Bignoli with improvements
+
+01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * multiple: Apply patch from Joerg Hoehle with multiple
+ improvements.
+
+01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.7 released
+ * sql/oodml.lisp, sql/package.lisp, db-mysql/mysql-objects.lisp:
+ Add support for mediumint.
+ * sql/metaclass.lisp: Rework CLISP MOP handling
+ * sql/ooddl.lisp: Work-around to have CLISP finalize standard-db-class
+
+28 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/metaclass.lisp: Support CLISP's attribute name
+ for the type field in direct class slots
+
+27 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.6 released
+ * BUGS: New file. Document suspected SIGPIPE
+ interaction between SBCL and libpq used in
+ postgresql backend.
+ * doc/ref-fdml.lisp: Document the :caching and :refresh
+ keywords of the SELECT function.
+ * doc/ref-ooddml.lisp: Document the new *default-caching*
+ variable.
+ * sql/package.lisp: Export *default-caching*
+ * sql/oodml.lisp: Use *default-caching* to
+ control default caching behavior.
+
+21 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.5 release
+ * doc/appendix.xml: Add note about loading Oracle8 version
+ * db-oracle/oracle-loader.lisp: Support Oracle8 based on
+ data from David Young.
+
+10 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * doc/Makefile, doc/catalog-darwin.xml: Apply
+ patch from Cyrus Harmon for building docs on Mac OS X
+ * sql/package.lisp: Add new (pre-release) clisp MOP package
+
+09 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.4 Release
+ * multiple: Remove superfluous quotes in UFFI def-type
+ and def-foreign-type forms.
+
+07 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.3 Release
+ * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
+ from Tagore Smith to call force-output after sending authentication
+ * db-odbc/odbc-api.lisp: Move ODBC v3 conversons
+ * db-odbc/odbc-sql.lisp: Load mysql or postgresql package when connecting
+ to a database of that type so that functions that indicate capabilities of
+ database are available.
+
+02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-odbc/odbc-api.lisp: More conversions to ODBC v3
+
+02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.2 Release
+ * TODO: Add note about ODBC on Windows
+ * db-odbc/odbc-loader.lisp: Add /winnt/system32/ to
+ search directories
+ * db-odbc/odbc-ff-interface.lisp: Change the return type
+ of SQLSetEnvAttr to :short
+
+02 Sep 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * examples/clsql-tutorial.lisp: added missing initarg for the COMPANYID
+ slot of the employee View Class definition [reported by Franz Deuzer].
+
+01 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.1 Release
+ * tests/test-init.lisp: Add second join class to employee-address
+ to test a class with two join slots.
+ * sql/oodml.lisp: Fix find-all function for a class with multiple
+ join slots
+ * TODO: Remove need to test/fix multiple join classes
+
+27 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-mysql/Makefile, db-mysql/mysql-loader.lisp: accept patch
+ from Jon Buffington for file locations on Darwin.
+
+17 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * sql/db-interface.lisp: Improve messages when functions
+ are passed a database object, but the method is not specialized
+ for that database type.
+ * sql/metaclasses.lisp: Fix inline declaration (reported by
+ Cyrus Harmon)
+
+14 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * TODO: Add bug report about SQL generation with a table
+ containing two join slots.
+ * sql/oodml.lisp: Add optional size to VARCHAR type
+
+3 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 3.0.0 Release
+ * sql/expressions.lisp: Change declaration that
+ caused error on openmcl
+ * db-aodbc/aodbc-sql.lisp: Fix storage location
+ of odbc connection. Specialize database-query since
+ dbi's :types keyword is different than generic-odbc's
+ :result-types keyword
+ * sql/db-interface.lisp: Add warnings for methods
+ not specialized by a db backends
+ * tests/test-fddl.lisp: Fix case of symbols to support
+ case-sensitive Allegro
+ * db-oracle/oracle-sql.lisp: Rework errbuf in handle-oci-error
+ * tests/test-init.lisp: Note that odbc driver for postgresql
+ doesn't properly handle table ownership
+ * LATEST-TEST-RESULTS: update with version 3.0.0
+
+1 Aug 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/expressions.lisp: conditionalise escaping of backslash in
+ generated SQL strings on backend.
+ * tests/test-fdml.lisp: test for escaping of backslash.
+ * sql/oodml.lisp: minor tidying in FIND-ALL.
+
+26 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * NEWS: Initial 3.0 announcement draft
+ * README: Expand acknowledgements of incorporated projects
+ * CONTRIBUTORS: Further document Marcus Pearce contributions
+
+23 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * sql/oodml.lisp: add DATABASE-OUTPUT-SQL-AS-TYPE method specialisation
+ to print floats with the exponent markers removed.
+ * tests/test-oodml.lisp: add tests for updating records with floats.
+
+22 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * db-oracle/oracle-sql.lisp: enable :OWNER :ALL in DATABASE-LIST-* for
+ CommonSQL compatibility.
+ * tests/test-init.lisp: skip test :FDDL/TABLE/6 on Oracle since
+ this column constraint syntax is not supported.
+ * tests/test-fddl.lisp: change column indexed in test :FDDL/INDEXES/2
+ from EMPLID to LAST_NAME since Oracle complains that EMPLID is already
+ indexed.
+
+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
+ Edi Weitz for WITH-TRANSACTION
+ * tests/README: Remove ptester package requirement (as noted
+ by Bill Clementson)
+
+03 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.5 released
+ * examples/clsql-tutorial.lisp: Remove obsolete :nulls-ok attribute,
+ Select connection-spec based on connection type. Bugs reported by
+ Bill Clementson.
+ * uffi/uffi.dll, uffi/uffi.lib: Recompile with Visual Studio 2003
+ * db-mysql/mysql-loader.lisp: Update check for zlibwapi library
+ name on Windows, add \bin\ directory to search path
+
+31 May 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
+ * db-odbc/odbc-sql.lisp: DB-TYPE replaced with DATABASE-TYPE in
+ DATABASE-CONNECT.
+ * sql/operations.lisp: substr now generates SUBSTR for use on
+ Oracle; added a new operator SUBSTRING for use elsewhere. minus
+ now generates MINUS for use on Oracle. Nvl signals an error if
+ not called with exactly 2 arguments. Add concat function for use
+ instead of the || operator on MySQL and Oracle.
+ * sql/syntax.lisp: changed internal symbol for the || operator to
+ CONCAT-OP.
+ * sql/expressions.lisp: removed redundant and unused functions
+ GENERATE-SQL (cf. SQL-OUTPUT) and DATABASE-CONSTRAINT-DESCRIPTION
+ (cf. MAKE-CONSTRAINTS-DESCRIPTION).
+ * sql/generics.lisp: removed generic function for
+ DATABASE-CONSTRAINT-DESCRIPTION (see above).
+ * tests/test-syntax.lisp: modified/added tests according to changes
+ in sql/operations.lisp.
+ * tests/test-fdml.lisp: changed SUBSTR to SUBSTRING in test
+ :fdml/select/21.
+ * sql/package.lisp: added the operators SQL-SUBSTRING, SQL-CONCAT-OP
+ and SQL-USERENV to the shared exports list. Removed
+ ROLLBACK-TRANSACTION, COMMIT-TRANSACTION, DATABASE-START-TRANSACTION,
+ DATABASE-ABORT-TRANSACTION, DATABASE-COMMIT-TRANSACTION,
+ TRANSACTION-LEVEL, TRANSACTION, RECORD-SQL-COMMAND and
+ RECORD-SQL-RESULT from shared exports list.
+
+30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * db-postgresql/postgresl-sql.lisp: Avoid computing
+ result-types lisp when nil result-types. Return only
+ one value when field-types nil.
+ * db-mysql/mysql-sql.lisp: Simple queries now
+ working with prepared statements.
+
+30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.4: MySQL 4.1 now passes all tests
+ * sql/package.lisp: Add API for prepared statments.
+ * sql/fdml.lisp: Change implicit flatp processing
+ for string map-query for greater CommonSQL conformance.
+ Add high-high API for prepared statements.
+ * tests/test-basic.lisp: Add test for map-query and
+ single argument.
+ * sql/transactions.lisp: Change name/semantics of
+ autocommit to set-autocommit.
+ * sql/generic-postgresql.lisp: Add support for
+ prepared statements.
+ * tests/test-internal.lisp: New file
+ * sql/odbc-api.lisp: Update to using ODBC V3 protocol
+ * clsql-mysql.asd, clsql-uffi.asd: Remove check and Common Lisp
+ Controller invocation.
+ * db-mysql/mysql-api.lisp: Add support for MySQL 4.1 field structure
+ * sql/expressions.lisp: Avoid emitting double parenthesis when a
+ function contains a subselect.
+
+27 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * Version 2.11.3
+ * sql/ooddl.lisp: Commit patch from Edi Weitz fixing return
+ type (setf slot-value-using-class)
+ * TODO: add not that need a test case for the above fix
+ * db-sqlite: Remove clisp support since clisp can not run CLSQL
+ with its MOP usage
+ * db-oracle/oracle-sql.lisp: By default, use OCIEnvCreate as
+ introduced in Oracle8. Leave older code selectable by a reader macro
+ for Oracle7 and prior. Avoid use of OCIServerAttach since CLSQL
+ uses OCILogon and does not the more complex session management.
+
26 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
* sql/oodml.lisp: Commit universal-time typo patch from Edi Weitz
* test/test-init.lisp: Add universal-time slot to person.
projects / clsql.git / blobdiff