X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=ChangeLog;h=ff355b2720c0357dc7011b245090639a3b551492;hp=6a7e1af7851ca23bb61471b236ccf0dca3eeb055;hb=39ee7191fd3087c2d7e149b33dd3e985db021721;hpb=5bfa219c5e3b387b9dd7c819441f0182ccb16dc8 diff --git a/ChangeLog b/ChangeLog index 6a7e1af..ff355b2 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,8 +1,157 @@ -29 May 2004 Kevin Rosenberg +23 Jun 2004 Kevin Rosenberg + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * 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 + * Version 2.11.4: MySQL 4.1 now passes all tests * sql/package.lisp: Add API for prepared statments. - * sql/fdml.lisp: Change implicity flatp processing + * sql/fdml.lisp: Change implicit flatp processing for string map-query for greater CommonSQL conformance. - Add high-high API for prepared statements. Not complete. + 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 @@ -11,6 +160,11 @@ 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 * Version 2.11.3