X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=ChangeLog;h=edf6b8a21077ea7f9cb8a6fddb6b5ffa2388c894;hp=a952afee09e55a20a9819a6edd4f6a5af34f97b4;hb=46525a14e41672ba3daaf79c68fdc413e47c4fd0;hpb=04df7e672f08154fbc213236dfb2d2dd2023e802 diff --git a/ChangeLog b/ChangeLog index a952afe..edf6b8a 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,311 @@ +09 Nov 2004 Kevin Rosenberg + * sql/operations.lisp: Add lower and upper SQL + functions from Daniel Lowe. + +08 Nov 2004 Kevin Rosenberg + * sql/expressions.lisp: Fix slot name [thanks to + Daniel Lowe] + +31 Oct 2004 Kevin Rosenberg + * clsql-sqlite3, db-sqlite3/*: NEW BACKEND + contributed by Aurelio Bignoli + +23 Oct 2004 Kevin Rosenberg + * 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 + * uffi/uffi.c, uffi/clsql-uffi.lisp: Commit patch from + Aurelio Bignoli to fix negative 64-bit integers + +07 Oct 2004 Kevin Rosenberg + * db-mysql/mysql.c: Fix parameters in bind_param call + +07 Oct 2004 Kevin Rosenberg + * 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 + * 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 + * Version 3.0.8 released + * db-sqlite/sqlite-*.lisp: Apply patch from + Aurelio Bignoli with improvements + +01 Oct 2004 Kevin Rosenberg + * multiple: Apply patch from Joerg Hoehle with multiple + improvements. + +01 Oct 2004 Kevin Rosenberg + * 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 + * sql/metaclass.lisp: Support CLISP's attribute name + for the type field in direct class slots + +27 Sep 2004 Kevin Rosenberg + * 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 + * 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 + * 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 + * Version 3.0.4 Release + * multiple: Remove superfluous quotes in UFFI def-type + and def-foreign-type forms. + +07 Sep 2004 Kevin Rosenberg + * 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 + * db-odbc/odbc-api.lisp: More conversions to ODBC v3 + +02 Sep 2004 Kevin Rosenberg + * 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 + * 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 + * 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 + * db-mysql/Makefile, db-mysql/mysql-loader.lisp: accept patch + from Jon Buffington for file locations on Darwin. + +17 Aug 2004 Kevin Rosenberg + * 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 + * 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 + * 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 + * 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 + * NEWS: Initial 3.0 announcement draft + * README: Expand acknowledgements of incorporated projects + * CONTRIBUTORS: Further document Marcus Pearce contributions + +23 Jul 2004 Marcus Pearce + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * Version 2.11.15 + * db-oracle/oracle-sql.lisp: Apply patch for OpenMCL/OSX + from James Bielman + +14 Jul 2004 Marcus Pearce + * README, INSTALL: update URLs. Minor updates to descriptions. + * tests/README: remove stuff about editing contexts. + +12 Jul 2004 Kevin Rosenberg + * db-oracle/oracle-objects.lisp: Change *default-varchar-length* to + *default-string-length* + +12 Jul 2004 Marcus Pearce + * 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 + * db-sqlite/sqlite-sql.lisp: Fix condition as reported by Aurelio + Bignoli. + +11 Jul 2004 Kevin Rosenberg + * sql/oodml.lisp, sql/package.lisp, doc/ref-ooddl.lisp, db-mysql/mysql-objects.lisp: Add tinyint type + +10 Jul 2004 Kevin Rosenberg + * Version 2.11.14 + * doc/*.xml: documentation additionals and fixes so + that docbook passes xmllint. + +9 Jul 2004 Kevin Rosenberg + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 * doc/ref-transaction.xml: document transaction handling. * sql/transaction.lisp: ensure that COMMIT, ROLLBACK and @@ -9,11 +317,9 @@ 30 Jun 2004 Marcus Pearce * doc/ref-fdml.xml: document the FDML. * doc/ref-fddl.xml: move documentation for TRUNCATE-DATABASE here. - * sql/fdml.lisp: move TRUNCATE-DATABASE to sql/fddl.lisp. - * sql/fddl.lisp: move TRUNCATE-DATABASE here from sql/fdml.lisp - and add docstring. - * doc/TODO: removed items done. - + * sql/ooddl.lisp: moved *default-varchar-length* to here from + oodml.lisp and renamed to *default-string-length* + 23 Jun 2004 Kevin Rosenberg * sql/oodml.lisp: Add keyword :transactions to def-view-from-class to allow specifying transactionless table creation