Kevin M. Rosenberg [Tue, 21 Dec 2004 07:43:10 +0000 (07:43 +0000)]
r10219: Automated commit for clsql debian-version-3.1.3-1
Kevin M. Rosenberg [Tue, 21 Dec 2004 07:32:17 +0000 (07:32 +0000)]
r10217: new debian package
Kevin M. Rosenberg [Tue, 7 Dec 2004 06:11:55 +0000 (06:11 +0000)]
r10191: ensure properties set
Kevin M. Rosenberg [Tue, 7 Dec 2004 06:10:37 +0000 (06:10 +0000)]
r10190: 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.
Kevin M. Rosenberg [Fri, 3 Dec 2004 23:41:00 +0000 (23:41 +0000)]
r10179: 03 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
* 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.
Kevin M. Rosenberg [Fri, 12 Nov 2004 15:11:39 +0000 (15:11 +0000)]
r10156: * Version 3.1.1
* sql/generic-postgresql.lisp: Commit patch from Chris Capel to
ignore columns which have been dropped.
Kevin M. Rosenberg [Fri, 12 Nov 2004 03:31:00 +0000 (03:31 +0000)]
r10155: 11 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
* clsql-postgresql-socket.asd, db-postgresql-socket/postgresql-socket-package.lisp:
Use sb-md5 package on SBCL, recommended by Chris capel
Kevin M. Rosenberg [Tue, 9 Nov 2004 18:06:04 +0000 (18:06 +0000)]
r10148: Automated commit for Debian build of clsql upstream-version-3.1.0
Kevin M. Rosenberg [Tue, 9 Nov 2004 18:04:31 +0000 (18:04 +0000)]
r10147: 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
Kevin M. Rosenberg [Tue, 9 Nov 2004 17:35:35 +0000 (17:35 +0000)]
r10146: 09 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
* sql/operations.lisp: Add lower and upper SQL
functions from Daniel Lowe.
Kevin M. Rosenberg [Tue, 9 Nov 2004 04:24:15 +0000 (04:24 +0000)]
r10145: add patch for collect-table-refs
Kevin M. Rosenberg [Sun, 31 Oct 2004 23:59:26 +0000 (23:59 +0000)]
r10128: Add SQLite3 backend
Kevin M. Rosenberg [Wed, 27 Oct 2004 18:50:07 +0000 (18:50 +0000)]
r10121: fix compilation on sbcl
Kevin M. Rosenberg [Sun, 24 Oct 2004 04:32:58 +0000 (04:32 +0000)]
r10115: improvments for loading on 64-bit systems
Kevin M. Rosenberg [Sat, 23 Oct 2004 15:48:18 +0000 (15:48 +0000)]
r10112: fix permissions
Kevin M. Rosenberg [Sat, 23 Oct 2004 15:35:10 +0000 (15:35 +0000)]
r10110: Automated commit for Debian build of clsql upstream-version-3.0.11
Kevin M. Rosenberg [Sat, 23 Oct 2004 15:16:15 +0000 (15:16 +0000)]
r10108: Automated commit for Debian build of clsql upstream-version-3.0.10
Kevin M. Rosenberg [Sat, 23 Oct 2004 03:56:54 +0000 (03:56 +0000)]
r10104: ignore errors when closing connections
Kevin M. Rosenberg [Sat, 23 Oct 2004 03:56:33 +0000 (03:56 +0000)]
r10103: allow foreign-arrays
Kevin M. Rosenberg [Thu, 21 Oct 2004 02:46:15 +0000 (02:46 +0000)]
r10095: Automated commit for Debian build of clsql upstream-version-3.0.9
Kevin M. Rosenberg [Tue, 19 Oct 2004 18:40:27 +0000 (18:40 +0000)]
r10094: removed obsolete clisp work-around
Kevin M. Rosenberg [Thu, 7 Oct 2004 18:38:35 +0000 (18:38 +0000)]
r10088: Add support for blob result type
Kevin M. Rosenberg [Mon, 4 Oct 2004 22:13:14 +0000 (22:13 +0000)]
r10086: document clisp requirements
Kevin M. Rosenberg [Mon, 4 Oct 2004 16:13:20 +0000 (16:13 +0000)]
r10085: 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)
Kevin M. Rosenberg [Sun, 3 Oct 2004 15:45:47 +0000 (15:45 +0000)]
r10083: Automated commit for Debian build of clsql upstream-version-3.0.8
Kevin M. Rosenberg [Fri, 1 Oct 2004 17:24:52 +0000 (17:24 +0000)]
r10078: fix typo from manual patch application
Kevin M. Rosenberg [Fri, 1 Oct 2004 17:02:20 +0000 (17:02 +0000)]
r10077: * multiple: Apply patch from Joerg Hoehle with multiple
improvements.
Kevin M. Rosenberg [Fri, 1 Oct 2004 14:39:42 +0000 (14:39 +0000)]
r10075: * sql/metaclass.lisp: Rework CLISP MOP handling
* sql/ooddl.lisp: Work-around to have CLISP finalize standard-db-class
Kevin M. Rosenberg [Fri, 1 Oct 2004 09:19:18 +0000 (09:19 +0000)]
r10074: Add mediumint
Kevin M. Rosenberg [Tue, 28 Sep 2004 11:16:28 +0000 (11:16 +0000)]
r10048: support clisp's attribute name for the type field in class direct slots
Kevin M. Rosenberg [Tue, 28 Sep 2004 06:20:21 +0000 (06:20 +0000)]
r10042: add umask to upload scripts
Kevin M. Rosenberg [Tue, 28 Sep 2004 05:30:19 +0000 (05:30 +0000)]
r10041: Automated commit for Debian build of clsql upstream-version-3.0.6
Kevin M. Rosenberg [Tue, 28 Sep 2004 05:29:01 +0000 (05:29 +0000)]
r10040: 28 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
* Version 3.0.6 released
* doc/ref-fdml.lisp: Document the :caching and :refresh
keywords of the SELECT function.
* doc/ref-ooddml.lisp: Document the new *default-caching*
variable.
Kevin M. Rosenberg [Tue, 28 Sep 2004 05:03:40 +0000 (05:03 +0000)]
r10039: * BUGS: New file. Document suspected SIGPIPE
interaction between SBCL and libpq used in
postgresql backend.
* sql/package.lisp: Export *default-caching*
* sql/oodml.lisp: Use *default-caching* to
control default caching behavior.
Kevin M. Rosenberg [Tue, 21 Sep 2004 23:15:31 +0000 (23:15 +0000)]
r10018: Automated commit for Debian build of clsql upstream-version-3.0.5
Kevin M. Rosenberg [Tue, 21 Sep 2004 23:14:45 +0000 (23:14 +0000)]
r10017: new deb package
Kevin M. Rosenberg [Tue, 21 Sep 2004 21:51:33 +0000 (21:51 +0000)]
r10015: 21 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
* doc/appendix.xml: Add note about loading Oracle8 version
* db-oracle/oracle-loader.lisp: Support Oracle8 based on
data from David Young.
Kevin M. Rosenberg [Fri, 10 Sep 2004 08:45:25 +0000 (08:45 +0000)]
r9991: * sql/package.lisp: Add new (pre-release) clisp MOP package
Kevin M. Rosenberg [Fri, 10 Sep 2004 08:44:24 +0000 (08:44 +0000)]
r9990: 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
Kevin M. Rosenberg [Fri, 10 Sep 2004 04:29:16 +0000 (04:29 +0000)]
r9989: Automated commit for Debian build of clsql upstream-version-3.0.4
Kevin M. Rosenberg [Fri, 10 Sep 2004 04:26:46 +0000 (04:26 +0000)]
r9988: Automated commit for Debian build of clsql upstream-version-3.0.4
Kevin M. Rosenberg [Tue, 7 Sep 2004 22:12:04 +0000 (22:12 +0000)]
r9978: Automated commit for Debian build of clsql upstream-version-3.0.3
Kevin M. Rosenberg [Tue, 7 Sep 2004 20:45:43 +0000 (20:45 +0000)]
r9977: 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.
Kevin M. Rosenberg [Mon, 6 Sep 2004 15:10:07 +0000 (15:10 +0000)]
r9969: update link
Kevin M. Rosenberg [Thu, 2 Sep 2004 22:09:43 +0000 (22:09 +0000)]
r9959: more odbc v3 conversions
Kevin M. Rosenberg [Thu, 2 Sep 2004 22:04:23 +0000 (22:04 +0000)]
r9958: Automated commit for Debian build of clsql upstream-version-3.0.2
Kevin M. Rosenberg [Thu, 2 Sep 2004 22:02:30 +0000 (22:02 +0000)]
r9957: 2 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
Kevin M. Rosenberg [Thu, 2 Sep 2004 21:33:23 +0000 (21:33 +0000)]
r9956: * db-odbc/odbc-loader.lisp: Add /winnt/system32/ to
search directories
Kevin M. Rosenberg [Thu, 2 Sep 2004 21:32:16 +0000 (21:32 +0000)]
r9955: 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
* TODO: Add note about ODBC on Windows
Marcus Pearce [Thu, 2 Sep 2004 15:31:04 +0000 (15:31 +0000)]
r9952: * examples/clsql-tutorial.lisp: added missing initarg for the COMPANYID
slot of the employee View Class definition [reported by Franz Deuzer].
Kevin M. Rosenberg [Wed, 1 Sep 2004 18:17:58 +0000 (18:17 +0000)]
r9951: Automated commit for Debian build of clsql upstream-version-3.0.1
Kevin M. Rosenberg [Fri, 27 Aug 2004 12:26:05 +0000 (12:26 +0000)]
r9928: * db-mysql/Makefile, db-mysql/mysql-loader.lisp: accept patch
from Jon Buffington for file locations on Darwin.
Kevin M. Rosenberg [Fri, 27 Aug 2004 12:25:03 +0000 (12:25 +0000)]
r9927: 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 FreeBSD.
Kevin M. Rosenberg [Thu, 19 Aug 2004 19:04:59 +0000 (19:04 +0000)]
r9902: * sql/metaclasses.lisp: Fix inline declaration (reported by
Cyrus Harmon)
Kevin M. Rosenberg [Wed, 18 Aug 2004 08:14:01 +0000 (08:14 +0000)]
r9890: 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.
Kevin M. Rosenberg [Sun, 15 Aug 2004 09:10:37 +0000 (09:10 +0000)]
r9882: Add optional size to VARCHAR type
Kevin M. Rosenberg [Sat, 14 Aug 2004 16:36:17 +0000 (16:36 +0000)]
r9874: 14 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
* TODO: Add bug report about SQL generation with a table
containing two join slots.
Kevin M. Rosenberg [Tue, 3 Aug 2004 07:59:16 +0000 (07:59 +0000)]
r9835: Automated commit for Debian build of clsql upstream-version-3.0.0
Kevin M. Rosenberg [Tue, 3 Aug 2004 07:58:50 +0000 (07:58 +0000)]
r9834: add tag
Kevin M. Rosenberg [Tue, 3 Aug 2004 07:57:36 +0000 (07:57 +0000)]
r9833: update for 3.0.0
Kevin M. Rosenberg [Tue, 3 Aug 2004 07:57:08 +0000 (07:57 +0000)]
r9832: * sql/expressions.lisp: Change declaration that
caused error on openmcl
Kevin M. Rosenberg [Tue, 3 Aug 2004 06:27:00 +0000 (06:27 +0000)]
r9831: * 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
Marcus Pearce [Sun, 1 Aug 2004 22:47:19 +0000 (22:47 +0000)]
r9826: * 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.
Kevin M. Rosenberg [Tue, 27 Jul 2004 02:56:04 +0000 (02:56 +0000)]
r9813: 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
Marcus Pearce [Fri, 23 Jul 2004 21:19:49 +0000 (21:19 +0000)]
r9812: * tests/test-oodml.lisp: update tests for updating records with floats.
Marcus Pearce [Fri, 23 Jul 2004 15:43:34 +0000 (15:43 +0000)]
r9811: * sql/oodml.lisp: add DATABASE-OUTPUT-SQL-AS-TYPE method specialisation
to print floats with the exponent markers removed.
* sql/test-oodml.lisp: add tests for updating records with floats.
Marcus Pearce [Wed, 21 Jul 2004 17:00:05 +0000 (17:00 +0000)]
r9809: Changelog entry for previous commit.
Marcus Pearce [Wed, 21 Jul 2004 16:29:03 +0000 (16:29 +0000)]
r9808: * 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.
Marcus Pearce [Sat, 17 Jul 2004 16:57:25 +0000 (16:57 +0000)]
r9804: * 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).
Marcus Pearce [Sat, 17 Jul 2004 16:52:52 +0000 (16:52 +0000)]
r9803: Remove items done from TODO files.
Marcus Pearce [Sat, 17 Jul 2004 16:51:05 +0000 (16:51 +0000)]
r9802: Add test for CACHE-TABLE-QUERIES.
Marcus Pearce [Sat, 17 Jul 2004 16:49:22 +0000 (16:49 +0000)]
r9801: Add documentation and tests for CACHE-TABLE-QUERIES.
Marcus Pearce [Fri, 16 Jul 2004 14:51:39 +0000 (14:51 +0000)]
r9797: * sql/oodml.lisp: on Lispworks, use weak valued hash tables for
object caching.
* sql/expressions.lisp: Fix SQL generation for the symbol NIL.
Marcus Pearce [Fri, 16 Jul 2004 12:00:15 +0000 (12:00 +0000)]
r9796: * 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.
Kevin M. Rosenberg [Thu, 15 Jul 2004 15:33:22 +0000 (15:33 +0000)]
r9777: 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
Kevin M. Rosenberg [Thu, 15 Jul 2004 03:42:50 +0000 (03:42 +0000)]
r9775: Automated commit for Debian build of clsql upstream-version-2.11.15
Kevin M. Rosenberg [Thu, 15 Jul 2004 03:42:13 +0000 (03:42 +0000)]
r9774: Automated commit for Debian build of clsql upstream-version-2.11.14
Kevin M. Rosenberg [Thu, 15 Jul 2004 03:38:51 +0000 (03:38 +0000)]
r9773: 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
Marcus Pearce [Wed, 14 Jul 2004 13:36:40 +0000 (13:36 +0000)]
r9771: Minor updates to READMEs.
Kevin M. Rosenberg [Tue, 13 Jul 2004 16:11:44 +0000 (16:11 +0000)]
r9769: 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
* db-oracle/oracle-objects.lisp: Change *default-varchar-length* to
*default-string-length*
Marcus Pearce [Mon, 12 Jul 2004 23:45:58 +0000 (23:45 +0000)]
r9758: Add tests for syntax and fddl.
Kevin M. Rosenberg [Mon, 12 Jul 2004 22:28:07 +0000 (22:28 +0000)]
r9757: Fix condition in sqlite-sql
Kevin M. Rosenberg [Mon, 12 Jul 2004 02:43:12 +0000 (02:43 +0000)]
r9756: add tinyint type
Kevin M. Rosenberg [Sun, 11 Jul 2004 01:26:47 +0000 (01:26 +0000)]
r9755: Automated commit for Debian build of clsql upstream-version-2.11.14
Kevin M. Rosenberg [Sun, 11 Jul 2004 00:50:24 +0000 (00:50 +0000)]
r9754: docbook files now pass xmllint verification
Kevin M. Rosenberg [Sat, 10 Jul 2004 20:33:33 +0000 (20:33 +0000)]
r9753: all docbook fixes done except for removing hovertext
Kevin M. Rosenberg [Sat, 10 Jul 2004 19:53:39 +0000 (19:53 +0000)]
r9752: 10 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
* doc/*.xml: Midway through docbook schema fixes
Kevin M. Rosenberg [Sat, 10 Jul 2004 12:22:24 +0000 (12:22 +0000)]
r9751: additional doc
Kevin M. Rosenberg [Sat, 10 Jul 2004 09:31:28 +0000 (09:31 +0000)]
r9750: Automated commit for Debian build of clsql upstream-version-2.11.13
Kevin M. Rosenberg [Sat, 10 Jul 2004 08:54:25 +0000 (08:54 +0000)]
r9749: more documentation
Kevin M. Rosenberg [Sat, 10 Jul 2004 07:12:45 +0000 (07:12 +0000)]
r9748: Automated commit for Debian build of clsql upstream-version-2.11.13
Kevin M. Rosenberg [Sat, 10 Jul 2004 07:11:16 +0000 (07:11 +0000)]
r9747: Version 2.11.13
* doc/ref-ooddl.lisp: documentation additions
* doc/ref-oodml.lisp: Add purpose to functions
Kevin M. Rosenberg [Thu, 8 Jul 2004 16:57:41 +0000 (16:57 +0000)]
r9742: add acknowledgement of other code sources
Kevin M. Rosenberg [Thu, 8 Jul 2004 16:32:52 +0000 (16:32 +0000)]
r9741: 8 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
* sql/fdml.lisp: Apply patch from Kim Minh Kaplan
to change escaping of single quotes. Mild optimizations
for escaped string output.
* TODO: Add need to test single quote escaping
Kevin M. Rosenberg [Wed, 7 Jul 2004 18:04:32 +0000 (18:04 +0000)]
r9740: documentation additions
Kevin M. Rosenberg [Wed, 7 Jul 2004 18:03:23 +0000 (18:03 +0000)]
r9739: 7 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
* 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
Marcus Pearce [Tue, 6 Jul 2004 12:20:29 +0000 (12:20 +0000)]
r9737: Add column/table contraints example to documentation for CREATE-TABLE.
Marcus Pearce [Tue, 6 Jul 2004 10:14:07 +0000 (10:14 +0000)]
r9736: fix bug preventing the :DB-CONSTRAINTS View Class slot option accepting a list of constraints [reported by Travis Cross].
Marcus Pearce [Sat, 3 Jul 2004 15:52:50 +0000 (15:52 +0000)]
r9734: Document idiosyncrasies of the individual backends and differences from CommonSQL.
Kevin M. Rosenberg [Sat, 3 Jul 2004 02:43:23 +0000 (02:43 +0000)]
r9733: new policy version