1 2010-02-15 Kevin Rosenberg <kevin@rosenberg.net>
2 * db-mysql/mysql-{api,sql}.lisp: Support sending options
3 to MySQL using mysql_options, which occurs between the API calls
4 of mysql_init and mysql_real_connect.
6 2010-02-11 Kevin Rosenberg <kevin@rosenberg.net>
8 * multiple-files: Further internationalization. Change
9 UFFI:CONVERT-RAW-FIELD and UFFI:CONVERT-FROM-FOREIGN-STRINGS
10 invocations to use the foreign character set encoding of the
11 database object. Requires UFFI v.1.8.6
12 * Makefile.common: Fix OS_DARWIN64 setting
14 2010-02-11 Nathan Bird <nathan@acceleration.net>
15 * MSSQL: better support for fddl 'date type.
17 2010-02-11 Kevin Rosenberg <kevin@rosenberg.net>
18 * Makefile.common, uffi/Makefile, db-mysql/Makefile:
19 Better support OS X Snow Leopard by building universal
20 (x86_64,i386) dylib bundles
22 2010-02-08 Kevin Rosenberg <kevin@rosenberg.net>
24 * sql/database.lisp: Fix missing slot-accessor
25 (Thanks to Stelian Ionescu)
26 * sql/generics.lisp: Add missing keyword to defgeneric
27 (Thanks to Stelian Ionescu)
29 2010-02-07 Kevin Rosenberg <kevin@rosenberg.net>
31 * sql/{base-classes,database}.lisp: Add encoding slot for
33 * db-mysql/mysql-sql.lisp: Use UFFI:FOREIGN-ENCODED-OCTET-COUNT.
34 Requires UFFI version 1.8.2 or above.
36 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
37 * Version 5.0.0: First release of CLSQL to formally and
38 consistently support non-ASCII strings with encoding of external
39 formats for SQL strings. UFFI version 1.8.1 is higher is required.
41 This change may introduce some differences in string handling for
42 people who are using non-ASCII encoded characters. Thus, because
43 of the risk of BACKWARD INCOMPATIBILITY, the major version number
44 was incremented with this release.
46 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
47 * tests/test-i18n.lisp: Bind UFFI:*DEFAULT-EXTERNAL-FORMAT*
48 for testing multibyte encodings.
49 * uffi/clsql-uffi.lisp: Changes for UFFI 1.7.4's new support
50 for encoding foreign strings with a specified external format.
52 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
53 * sql/metaclasses.lisp: If no declared slot type in
54 compute-lisp-type-from-specified-type, then use t as lisp type.
55 Issue noted when testing Clozure CL 1.4.
57 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
58 * tests/test-init.lisp: Turn off the benign console notices for
61 2010-02-05 Kevin Rosenberg <kevin@rosenberg.net>
62 * clsql-test.asd, tests/{test-i18n,test-init}.lisp:
63 Load test-i18n.lisp and use its tests as long as 'uffi:no-i18n is
64 not present in cl:*features*. This requires UFFI 1.7.2 or above.
66 2010-02-05 Kevin Rosenberg <kevin@rosenberg.net>
67 * sql/utils.lisp: Reading #\no-break_space causes an
68 error for non-unicode SBCL. Conditionalize read of
69 #\no-break_space for non-unicode SBCL and 8-bit string
72 2010-02-03 Kevin Rosenberg <kevin@rosenberg.net>
73 * tests/test-init.lisp: Add *test-report-width* variable
74 and word-wrap skipped test reason field.
76 2010-01-29 Kevin Rosenberg <kevin@rosenberg.net>
78 * clsql-cffi.asd: New file that causes CLSQL to use
79 CFFI-UFFI-COMPAT library rather than UFFI. Perform 'asdf:load-op
80 on CLSQL-CFFI rather than CLSQL system to use CFFI-UFFI-COMPAT.
82 2010-01-29 Nathan Bird <nathan@acceleration.net>
83 * tests/*.lisp: A lot more tests and test setup tweaks.
84 * sql/expressions.lisp: output-sql on sql-relational-exp does
85 better arity checking now. (apply #'sql-and some-list) gives
88 29 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
89 * sql/oodml.lisp: Fix for UPDATE-RECORD-FROM-SLOTS for normalized
92 28 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
94 * Change "normalise" from British spelling for consistency with
95 other American spellings in CLSQL.
97 28 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
98 * db-mysql/Makefile: Add directory for Fedora 11/12 on 64-bit
99 platform (Thanks to Michael Pheasant) and remove a 32-bit directory
101 28 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
103 * sql/utils.lisp: Ensure Lispworks 6 lock is created in sharing mode
105 20 Jan 2009 Nathan Bird <nathan@acceleration.net>
107 * Rewrite tests to use datasets
109 07 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
110 * sql/utils.lisp: Changes to support Lispworks 6
112 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
114 * doc/ref-ooddl.lisp: Add needed CDATA escapes
115 * doc/clsql.pdf, doc/html.tar.gz: Build new manuals with
116 normalized view classes.
118 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
119 Large patch from Thijs Oppermann <thijso+clsql@gmail.com> to add
120 support for normalized view classes. When having view class that
121 inherit from others, CLSQL by default builds tab all the columns
122 from the parent in the child. This patch is meant to normali so
123 that a join is done on the primary keys of the concerned tables to
126 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
127 * sql/time.lisp: Patch from Oleg Tihonov to SYNTAX-PARSE-ISO-8601
128 to properly parse fractions of seconds.
130 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
131 * sql/time.lisp: Patch from Oleg Tihonov to roll function
132 to properly use USEC argument.
134 21 Nov 2009 Kevin Rosenberg <kevin@rosenberg.net>
136 * Makefiles: On 64-bit Linux systems, try to build both 32 and 64-bit
137 interface libraries. This requires the installation of multiarch build tools
138 as well as 32-bit support libraries (libc, libz and libmysqlclient).
140 04 Sep 2009 Kevin Rosenberg <kevin@rosenberg.net>
142 * sql/fdml.lisp: Rework do-query to use supplied database
143 parameter when passed a sql-object-query
144 (thanks to JTK <jetmonk@gmail.com>)
145 * sql/generic-postgresql.lisp: Allow optional connect
146 parameters for postgresql databases (thanks to Stephen Compall)
147 * doc/ref-{clsql,connect}.xml, sql/db-interfaces.lisp:
148 Fix transposed letters (thanks to Stephen Compall)
149 * db-mysql/Makefile: Add directory for MacPorts mysql5 port
150 (thanks to Stephen Compall)
151 * sql/database.lisp: Have database-type default be
152 *default-database-type* (thanks to Desmond O. Chang)
153 * sql/transactions.lisp: Improved handlining of nested
154 transactions (thanks to Eli Naeher)
155 * sql/time.lisp: Commit patch to fix parse-iso-8601-duration
156 (thanks to Stephen Compall)
157 * sql/database.lisp: Use :verbose nil for asdf:operate
158 invocation (Thanks to Mackram Raydan)
159 * sql/metaclasses.lisp: Rework initialize-instance for
160 view-class-direct-slot-definition (thanks to Stephen Compall)
162 31 Aug 2009 Kevin Rosenberg <kevin@rosenberg.net>
163 * sql/db-interface.lisp: Fix spelling error (thanks to
165 * clsql-mysql.asd/db-mysql/mysql-loader.lisp: Commit
166 patch from Andreas Franke to honor windows drive letter
167 when loading clsql_mysql C library.
169 31 Aug 2009 Kevin Rosenberg <kevin@rosenberg.net>
171 * db-mysql/mysql-{sql,api}.lisp,db-mysql/clsql_mysql.c:
172 Latest version of mysqlclient once again changed the C
173 structures from which the mysql backend reads data.
174 Rather than adding yet another structure definition which
175 is enabled by the client version as read by mysql-client-info.lisp,
176 the mysql backend has been re-written to ignore in the internal
177 C structures. Instead, C wrapper functions for slot access have
178 been added to clsql_mysql.c and are used by mysql-sql.lisp to
179 access the internals of C structures. This adds a bit of overhead,
180 but completely separates the lisp code from trying to keep up
181 with the continually changing internal C structure of mysql.
182 All tests in the test suite executed correctly with this change.
184 31 Aug 2009 Kevin Rosenberg <kevin@rosenberg.net>
186 * sql/database.lisp: Fix syntax on process-lock (thanks to
188 * db-mysql/mysql-sql.lisp: Allow use of database parameter
189 in database-list function (thanks to Michael Pheasant)
190 * sql/oodml.lisp: Allow NULL values for floating-point fields
191 (thanks to Jan Rychter)
193 02 Jun 2009 Kevin Rosenberg <kevin@rosenberg.net>
195 * sql/database.lisp: Add process-lock for deleting database from
196 a pool (thanks to Ralf Mattes).
198 25 Feb 2008 Kevin Rosenberg <kevin@rosenberg.net>
200 * sql/expressions.lisp: Remove stray form (thanks to Samuel Ward)
202 12 Dec 2007 Kevin Rosenberg <kevin@rosenberg.net>
203 * sql/expressions.lisp: Bind *in-subselect* when outputting
204 selections (patch from unknown source).
206 11 Dec 2007 Kevin Rosenberg <kevin@rosenberg.net>
208 * sql/metaclasses.lisp: Unify base-table processing by extracting
209 the correct code from initialize-instance :around into the helper
210 function set-view-table-slot. Call that function also in
211 reinitialize-instance :around replacing erroneous code discovered
214 17 Nov 2007 Kevin Rosenberg <kevin@rosenberg.net>
215 * BUGS: Add note about benefit of using configure file to create
216 Makefiles (suggestion from Joe Corneli)
218 22 Oct 2007 Kevin Rosenberg <kevin@rosenberg.net>
220 * db-postgresql/postgresql-sql.lisp: Patch from Gabriele Favalessa based on
221 Andrew Golding suggestion for more informative :error-id slot.
223 17 Sep 2007 Kevin Rosenberg <kevin@rosenberg.net>
225 * db-mysql/mysql-sql.lisp: Convert query to uffi cstring (thanks to
227 * doc/Makefile, doc/html.xsl: Change output encoding from ISO-8859-1 to UTF-8
229 14 Sep 2007 Kevin Rosenberg <kevin@rosenberg.net>
230 * Version 4.0.0: Major version increase to warn of potential
231 backwards incompatibility.
232 * NEWS: Document potentional backward incompatible changes
233 * db-mysql/mysql-sql.lisp: Changes session SQL mode to ANSI immediately
234 after connecting. This may break compatibility with some applications
235 who are using non-ANSI features with MySQL. This change is required to
236 properly support view-classes using a string as their :base-table
237 attribute. This allows users to specify the case of table names.
238 This is feature is even more essential for MySQL itself since MySQL
239 uses case-sensitive table names. Use connection-based database-create
240 and database-destroy rather than trying to invoke command-line mysql
241 utility. Remove automatic upcasing of strings from list-indices.
242 * db-postgresql/postgresql-sql.lisp: Use connection-based
243 database-create and database-destroy rather than trying to invoke
244 command-line utilities.
245 * db-postgresql-socket/postgresql-socket-sql.lisp: Use
246 database-execute-command rather than execute-command for
247 database-{create,destroy}. Connect to postgres database
248 rather than template1 for those database creation/deletion.
249 * sql/metaclasses.lisp: Store the string value of :base-table if a
250 string is provided. Perform sql-escape at time of view-table name
252 * tests/test-init.lisp: Use "ej_join" as a string, rather than a
253 symbol, since "ej_join" is specified as :base-table. Clear the
254 expression output-cache in case the code for generating sql output
256 * test/test-oodml.lisp: whitespace fix
257 * sql/ooddl.lisp: Use quoted string for primary key constraint if
258 table name is specified as a string.
259 * sql/oodml.lisp: Don't convert a string view-table name to database's
261 * sql/expressions.lisp: Properly handle table and attribute identifiers
262 when they are a string. Do not change case of symbols to match database
264 * sql/operations.lisp: Change multiword symbols to upper case.
265 * sql/fddl.lisp: Quote base-table if a string to preserve case
266 for drop-table and create-table.
267 * tests/test-syntax.lisp: Add tests of low-level string attribute
270 20 Jul 2007 Kevin Rosenberg <kevin@rosenberg.net>
272 * db-oracle/oracle-loader.lisp: Rework use of ORACLE_HOME directory
273 (problem noted on clsql-devel by icardo Boccato Alves)
274 * sql/pool.lisp: Remove incorrect keyword
275 * sql/database.lisp: Rework WITH-DATABASE to not make the database the
276 default database (reported by Saurabh Nanda and Chaitanya Gupta)
277 * doc/ref-connect.lisp: Update the documentation to WITH-DATABASE to
278 emphasis that make-default has a default value of nil.
279 * sql/transaction.lisp: Adjust commit/rollback messages for Microsoft
280 SQL Server. (patch from Nathan Bird)
281 * sql/metaclasses.lisp: Use finalize-inheritance hack on SBCL because
282 of trouble with def-view-class compilations (patch from Nathan Bird)
284 15 Jul 2007 Kevin Rosenberg <kevin@rosenberg.net>
286 * db-mysql/mysql-loader.lisp: Revert previous change since libmysql is
287 not dynamically loaded on Windows
289 22 Jun 2007 Kevin Rosenberg <kevin@rosenberg.net>
291 * db-mysql/mysql-loader.lisp: Do not bother loading libmysqlclient since
292 that library is dymically linked to clsql-mysql library. Thus, the mysql
293 library will be automatically loaded. This has only been tested on Linux,
296 29 May 2007 Kevin Rosenberg <kevin@rosenberg.net>
297 * tests/test-fddl.lisp: Add :order-by for :fddl/big/1 as
298 reported by Ricardo Boccato Alves
300 02 May 2007 Kevin Rosenberg <kevin@rosenberg.net>
301 * sql/database.lisp: Add ability of WITH-DATABASE to return
302 multiple values (patch from Liam Healy)
304 25 Apr 2007 Kevin Rosenberg <kevin@rosenberg.net>
306 * doc/connect.xml: variable description fix by Liam Healy
307 * db-sqlite3/sqlite3-api.lisp, uffi/clsql-uffi-loader.lisp:
308 Apply patches from Marcus Pierce to reduce load-time warnings
309 * sql/package.lisp: Export iso-timestring as requested by Kevin Blaisdell
311 23 Mar 2007 Kevin Rosenberg <kevin@rosenberg.net>
313 * sql/db-postgresql-socket-api.lisp: Change read-socket-sequence to
314 disable wide characters for crypt salt sequence on SBCL, based
315 on patch from Lars Nostdal.
317 26 Jan 2007 Kevin Rosenberg <kevin@rosenberg.net>
319 * sql/pool.lisp: Test pooled connection when popped from
320 the pool to ensure the connection still works. Currently, implemented
323 17 Jan 2007 Kevin Rosenberg <kevin@rosenberg.net>
324 * db-mysql/Makefile: Add potential mysql directories
326 31 Dec 2006 Kevin Rosenberg <kevin@rosenberg.net>
327 * sql/metaclasses.lisp: Remove usused saved-initargs
328 * clsql.asd: Also check ~/.clsql-init.lisp at load-time (usually used to
329 push search libraries)
331 30 Dec 2006 Kevin Rosenberg <kevin@rosenberg.net>
332 * Version 3.8.0: BACKWARD INCOMPATABLE CHANGE!
333 * db-postgresql/postgresql-{api,loader,sql,package}.lisp:
334 Apply patch from Edi Weitz to avoid conflict with new Lispworks 5
335 POSTGRESQL package name. CLSQL's new package will be PGSQL, however
336 on non-Lispworks platforms, the nickname POSTGRESQL will still be
337 available. Applications directly using low-level POSTGRESQL package
338 are recommended to use the new PGSQL name.
339 * db-oracle/oracle-{api,sql}.lisp, sql/{expressions,loop-extension}.lisp,
340 Apply patch from Edi Weitz to reduce compiler warnings.
342 28 Dec 2006 Kevin Rosenberg <kevin@rosenberg.net>
344 * sql/expressions.lisp: Commit patch from Edi Weitz to
345 use *default-database* for SQL-OUTPUT if no database is
346 explicitly passed to function.
347 * uffi/clsql-uffi-loader.lisp: Change load order to first try
348 plain name/type before attempting user-specified paths (patch
350 * uffi/ptrbits.c: New file to return number of bits in an pointer
351 * uffi/Makefile: use intbits to name .so file based on bit size.
352 Build both 32-bit and 64-bit libraries on 64-bit platform.
354 30 Nov 2006 Kevin Rosenberg <kevin@rosenberg.net>
356 * db-sqlite3/sqlite3-sql.lisp: Commit patch from Edi Weitz fixing
359 16 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
361 * db-postgresql/postgresql-sql.lisp: Remove
362 uffi:convert-foreign-to-native wrapper since using cstring for
365 16 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
367 * db-postgresql/postgresql-api.lisp: Fix UFFI return type for
368 PQresultErrorField foreign function.
370 16 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
372 * doc/intro.xml: Update supported platforms.
373 * db-postgresql/postgresql-{package,api,sql}.lisp: Apply
374 changes from Andew Golding to use a more-specific error code
375 from PostgreSQL than the generic fatal error code of the result set.
377 03 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
378 * sql/syntax.lisp: Commit patch from Marcus Pearce to improve
379 readtable modifications
381 02 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
382 * sql/syntax.lisp: Check that original reader syntax functions
383 stored before trying to restore them.
385 20 Sep 2006 Kevin Rosenberg <kevin@rosenberg.net>
386 * sql/syntax.lisp: Apply patch from Marcus Pearce to correctly
387 display sql reader syntax.
389 06 Sep 2006 Kevin Rosenberg <kevin@rosenberg.net>
390 * uffi/clsql-uffi-loader.lisp, db-mysql/mysql-loader.lisp: Change from using *features*
391 to decide on 64-bit platform and check size of most-positive-fixnum instead.
392 Needed to support clisp amd64.
394 03 Sep 2006 Kevin Rosenberg <kevin@rosenberg.net>
396 * sql/metaclasses.lisp: Rework slot type's to be more AMOP
397 compatibile. Add warning for a metaclass condition that should
399 * sql/time.lisp: Fixed symbol case inconsistency causing problem
400 in AllegroCL's modern lisp. First sign of bug noted by
401 Joel Reymond on clsql-devel.
402 * clsql.asd: Make time.lisp depend on utils.lisp
404 31 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
405 * db-mysql/mysql-loader.lisp: Apply patch from Marcus Pearce to push
406 *library-file-dir* to CLSQL's library path.
408 30 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
409 * Version 3.7.0: New platforms supported: SBCL/Win32, CLISP/Win32, CLISP/Cygwin,
410 CLISP/Linux x86, CLISP/Linux amd64, OpenMCL amd64. CLISP support requires the
411 latest development versions of CLISP, cffi, and cffi-uffi-compat packages.
412 * Makefile.common: Add OS detection
413 * uffi/make.sh, db-mysql/make.sh: Remove files
414 * uffi/Makefile, db-mysql/Makefile: Add support for cygwin compilation.
415 Refactor to remove need to make.sh shell scripts.
416 * clsql.asd: Add support for loop extensions for clisp. Support clisp via cffi.
417 * sql/loop-extension.lisp: Define loop-record-iteration-path in CLSQL-SYS
418 package rather than CL-USER. Add support for ansi-loop on clisp.
419 * sql/ansi-loop.lisp: New file to support iteration on clisp.
420 * db-mysql/mysql-api.lisp: Remove old mysql C API functions that no
421 longer exist in the mysql client library.
422 * doc/ref-fdml.lisp: Correct default field-type.
423 * sql/expressions.lisp: Use database-output-as-type if value exists for boolean output.
424 Fixed bug with noted with MySQL 5.0.24 and boolean values.
426 28 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
428 * sql/oodml.lisp: Remove high debugging level declaration
430 14 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
432 * sql/generic-postgresql.lisp: Fix assumption that postgres user id
433 is always 1. Fixes problem noted with PostgreSQL 8.1.
435 12 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
437 * sql/generic-postgresql.lisp: Add slot for has-table-pg_roles to
438 lazily cache if pg_roles tables exist. Selectively use SQL from
439 Joel's previous patch if pg_roles table exists. Should now work
440 with both postgresql 7.4 and 8.x.
442 12 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
444 * clsql.asd: Add support for c:\etc\clsql-init.lisp as possible
445 local initialization file
446 * db-mysql/mysql-loader.lisp: Remove former method of using pathnames
448 * db-odbc/odbc-api.lisp: Work-around Allegro/Windows FFI bug
449 that generates incorrect integer return type
450 * sql/generic-postgresql.lisp: Revert patch from Joel Reymont since
451 it fails on versions of postgresql that lack the pg_role table
453 07 Jul 2006 Kevin Rosenberg <kevin@rosenberg.net>
455 * sql/transactions.lisp: Important typo fix from Alexey Antipov
456 for database-start-transaction
458 04 Jul 2006 Kevin Rosenberg <kevin@rosenberg.net>
460 * db-postgresql/postgresql-sql.lisp: Apply patch from Vladimir Sekissov
461 to close connection when failing to connect to database.
462 * sql/generic-postgresql.lisp: Apply patch from Joel Reymont
463 to avoid dropping system views.
464 * sql/oodml.lisp: Apply patch from Joel Reymont to avoid listify
465 a nil value [patch sponsored by Flektor]
466 * clsql-uffi.asd, uffi/make.sh: Patch from Richard Kreuter
467 for netbsd compilation
469 15 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
470 * doc/ref-ooddl.xml: Add documentation for :db-reader and :db-writer
471 slots for def-view-class macro [as reported missing by Thomas Fischbacher].
473 09 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
474 * db-postgresql-socket/postgresql-socket-api.lisp:
475 Apply patch from Marko Kocic adding the socket creation
476 function needed for CLISP.
478 08 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
479 * Version: 3.6.0 (requires UFFI v1.5.11 or greater)
480 * db-oracle/metaclasses.lisp: Patch from James Bielman for
481 checking slot constraints.
482 * db-oracle/oracle-{api,sql}.lisp: Avoid dead pointers on loading
483 saved openmcl images (based on patch from James Bielman)
485 06 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
486 * doc/ref-fdml.xml: Documentation patch from Marcus Pearce for limit keyword
488 03 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
490 * sql/time.lisp: Apply patch from Aleksandar Bakic to extended
491 duration parsing and unparsing to include year and month.
492 * clsql-uffi.asd, uffi/clsql-uffi-loader.lisp: Apply patch from Nathan Bird
493 improving library search on Windows platform.
494 * doc/ref-fdml.xml, /doc/TODO, tests/test-fdml.lisp, tests/test-init.lisp:
495 Apply patch from Marcus Pearce documenting and testing :limit and :offset for SELECT
497 20 Mar 2006 Kevin Rosenberg <kevin@rosenberg.net>
499 * clsql-postgresql-socket.asd,
500 * db-postgresql-socket/postgresql-socket-package.lisp:
501 Use the cl-md5 package on all platforms. Based on report
504 09 Mar 2006 Kevin Rosenberg <kevin@rosenberg.net>
506 * uffi/make.sh, db-mysql/make.sh: Add GNU uname
508 28 Feb 2006 Kevin Rosenberg <kevin@rosenberg.net>
510 * sql/metaclasses.lisp: Apply patch from Friedrich Dominicus to
511 fix accessor for new versions of SBCL
512 * db-oracle/oracle-sql.lisp: Apply patch from James Bielman
513 to improving parsing of time.
514 * db-db2/db2-constants.lisp: Change NULL_HANDLE has suggested
516 * db-oracle/oracle-dbi.lisp: Add support for SQL BIT type
517 as noted by Russ Tyndall.
519 16 Jan 2006 Kevin Rosenberg <kevin@rosenberg.net>
521 * sql/time.lisp: Commit patch from Aleksandar Bakic
522 to properly handle destructive flag
523 * db-postgresql-socket/postgresql-socket-api.lisp: Apply patch
524 from Steven Harris for socket files with SBCL.
525 * sql/pool.lisp: Apply patch from Vladimir Sekissov so that
526 new connections added to the pool do not become the *default-database*
527 * sql/connect.lisp: Optionally set *default-database* for pooled
528 connection when make-default is generalized true.
530 23 Dec 2005 Kevin Rosenberg <kevin@rosenberg.net>
532 * sql/expressions.lisp: Ensure table names are properly escaped
533 before comparing -- fixes bug reported by Asbjørn Bjørnstad
536 02 Dec 2005 Kevin Rosenberg <kevin@rosenberg.net>
537 * sql/generic-postgresql.lisp: improved decoding of table attribute
538 parameters [from Vladimir Sekissov]
539 * sql/metaclasses.lisp: check that metaclass is standard-db-class or
540 it's subclass to prevent adding standard-db-object to supers if
541 somebody in the path has it already when metaclass inherited from
542 standard-db-class. [from Vladimir Sekissov]
544 26 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
546 * tests/test-init.lisp, tests/test-fddl.lisp, tests/test-fdml.lisp,
547 * db-odbc/odbc-api.lisp, db-odbc/odbc-ff-interface.lisp,
548 * db-odbc/odbc-package.lisp, db-odbc/odbc-constants.lisp
549 * db-odbc/odbc-dbi.lisp, db-odbc/odbc-sql.lisp
550 * sql/fddl.lisp, sql/generic-odbc.lisp, sql/db-interface.lisp
551 * sql/transaction.lisp, sql/package.lisp, sql/time.lisp
552 Commit patch from Dominic Robinson providing support for
554 * doc/csql.lisp: Fix typo in slot name
556 24 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
558 * sql/time.lisp: Commit patch from Aleksandar Bakic for
559 correct handling of decode-time usec value
560 * clsql-mysql.asd: Commit patch from Harald Hanche-Olsen to
561 correct the name of the shared library file.
563 16 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
565 * sql/metaclasses.lisp: Avoid calling change-class on
566 effective-slot-definitions on sbcl to conform to sbcl 0.9.6.38
569 15 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
571 * sql/expressions.lisp: Patch from James Biel to add subselects
573 14 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
574 * Version 3.4.4 [ Requires UFFI 1.5.7+]
575 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
576 to fix lifetime of foreign strings for Oracle calls
578 13 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
580 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
581 to improve performance
583 12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
585 * clsql-uffi.asd: Patch from James Biel improving loading
586 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
587 to support 64-bit lisps
589 12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
591 * sql/expressions.lisp: Escape numbers to SQL strings
594 11 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
595 * Version 3.4: Add MySQL 5 support
596 * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
597 * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5
598 * doc/mysql-macosx-notes.txt: New document from Martin Brooks
600 7 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
601 * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL
603 * BUGS: Added report for update-object-joins by Aleksandar Bakic
605 4 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
606 * Version 3.3.4 [UFFI >= 1.5.5 needed]
607 * db-odbc/odbc-api.lisp: Apply patch from Yaroslav Kavenchuk
608 to add missing #\' character.
609 * clsql.asd: Add support for CLSQLINIT environmental variable,
610 based on patch from Yaroslav Kavenchcuk. New version of UFFI
613 30 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
615 * sql/oodml.lisp: Apply patch from Drew Crampsie to fix
616 update-objects-joins when using the :target-slot attribute
618 26 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
620 * sql/expressions.lisp: Avoid parenthesis on multiple group-by fields
621 as noted by Harald Hanche-Olsen.
622 * tests/test-syntax.lisp: Add test for multiple field group-by
624 25 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
626 * sql/time.lisp: Commit patch from Alan Shields to
627 display escape string on wall-time display only when *print-escape*
630 11 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
631 * sql/metaclasses.lisp: Commit patch from Will to
632 properly set db-reader slot in effective-slot-definition
633 * sql/expressions.lisp: Commit patch from Alan Shields
634 adding make-load-form for sql-relational-exp
635 * sql/generic-postgresql.lisp: Commit patch from Aleksandar Bakic
636 adding support for new NUMBER type
638 17 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
640 * sql/time.lisp: Apply patch from Alan Shields adding DATE type.
641 * doc/ref-ooddl.xml: Documentation of new type
642 * notes/add-type-hints.txt: New file from Alan Shields
643 * sql/fddl.lisp: Add owner keyword to drop-table as suggested
645 * db-postgresql-socket/postgresql-socket-sql.lisp: Fix database-probe
646 as noted by Francis Leboutte. Similar fix applied to db-mysql and
648 * sql/expressions.lisp: Allow string table names for output as
649 contributed by Francis Leboutte.
650 * examples/clsql-tutorial.lisp: Support :postgresql-socket as noted
653 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
655 * doc/into.xml: Change download from ftp to http protocol
657 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
659 * db-oracle/oracle-sql.lisp: Correction for v3.2.2 changes by
662 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
664 * db-oracle/oracle-sql.lisp: Add check for zero increment as
665 suggested by Edi Weitz. Add missing database-sequence-last function
666 as noted and tested by Edi Weitz. Ensure that UFFI buffer is freed
667 in handle-oci-error. Add unwind-protect to sql-stmt-exec. Free UFFI
668 stmthp object when query cursor is freed with OCI.
670 22 Aug 2005 Kevin Rosenberg <kevin@rosenberg.net>
671 * uffi/clsql-uffi-loader.lisp: Commit patch from astor@pvv.ntnu.no to
672 display search path when error occurs loading foreign library.
674 05 Jul 2005 Kevin Rosenberg <kevin@rosenberg.net>
676 * doc/appendix.xml: Incorporate Edi Weitz's notes into documentation
677 with changes to support case-sensitive lisp implementations. Add
678 paragraph on using /etc/clsql-init.lisp site initialization file.
679 * clsql.asd: Load file /etc/clsql-init.lisp, if it
680 exists, after package is loaded to set site-specific configuration
682 2005-06-24 Edi Weitz <edi@agharta.de>
683 * sql/db-interface.lisp: Added new special variable
684 *FOREIGN-LIBRARY-SEARCH-PATHS* and function PUSH-LIBRARY-PATH to
686 * sql/package.lisp: Export these.
687 * uffi/clsql-uffi-loader.lisp: Used new variable; changed order of
689 * db-mysql/mysql-loader.lisp: Changed order of libs.
691 09 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
692 * Version 3.2.0: REQUIRES UFFI VERSION 1.4.38 OR HIGHER
693 * clsql-mysql.asd: Renamed clsql/mysql interface library from
695 * clsql-uffi.asd: Renamed clsql/uffi interface library from
697 * uffi/clsql_uffi.c: Renamed from uffi.c
698 * db-mysql/clsql_mysql.c: Renamed from mysql.c
699 * db-mysql/Makefile, db-mysql/Makefile.msvc, db-mysql/mysql-loader.lisp: Rename shared library
700 * uffi/Makefile, uffi/Makefile.msvc, uffi/uffi-loader.lisp: Rename shared library
701 * db-*/*-loader.lisp: Commit big patch from Edi Weitz to remove
702 absolute pathnames when searching for foreign libraries.
703 foreign library loading.
705 07 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
707 * db-mysql/mysql-api.lisp: Commit patch from Espen Wiborn
708 to support UTF-8 on sbcl unicode.
710 18 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
712 * sql/time.lisp: Fix bug in roll that caused failure in test suite
714 17 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
716 * sql/oodml.lisp: Properly handle when db-writer is NIL
718 11 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
719 * sql/expressions.lisp: Avoid using simple-string declaration when
720 a non-simple string may be encountered. [issue noted by
721 will@cesmail.net] Add a simple-string declaration for a local
724 06 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
725 * sql/oodml.lisp: Change db-writer and db-reader processing to accept
726 a symbol as well as function to serve as a function designator
727 [issue noted by will@cesmail.net]
729 05 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
731 * sql/time.lisp: Fix error in submitted patch which caused error
732 in timestrings with 19 or less characters.
734 27 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
736 * db-postgresql-socket/postgresql-api.lisp: Commit patch from Tim Howe
737 to fix read-socket-sequence on non-sb-unicode sbcl.
739 26 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
741 * sql/time.lisp: Commit patch from Daniel Lowe which adds support
742 for fractional seconds which is required by PostgreSQL
743 * db-postgresql/postgresql-loader.lisp: Add library path for Windows
745 25 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
746 * sql/csql.lisp: Update URL for "SQL for Web Dummies" [Sean Champ]
748 24 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
750 * sql/syntax: Commit patch from Alan Shields to supress reader
751 macros when *read-supress* is T.
753 13 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
755 * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
756 from Janis Dzerins to support unicode on SBCL
757 * sql/syntax: Commit patch from Alan Shields to improve reporting
758 of invalid syntax statements.
760 06 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
762 * db-mysql/mysql-sql.lisp: Add port to connection specification
763 based on patch from Dave Watson
764 * doc/appendix.xml: Document MySQL port parameter to connection spec
766 03 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
768 * sql/time.lisp: Patch from Keith James for parsing ISO-8601 timestamps
770 18 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
771 * sql/oodml.lisp: Add missing database argument [Patch from
774 03 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
775 * sql/oodml.lisp: Improve database priority in
776 update-records-from-instance [Patch from Walter C. Pelissero]
778 17 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
780 * sql/package.lisp: Export database-reconnect from clsql-sys
782 08 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
783 * sql/oodml.lisp: Use explicit database in fault-join-target-slot
784 [Patch from Walter Pelissero]
786 29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
787 * db-postgresql/postgresql-loader.lisp: Add additional
788 directories to Fink on darwin [patch from Cyrus Harmon].
790 29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
792 * sql/oodml.lisp: Clear view instance cache when delete-instance-records
793 is invoked [suggested by Alan Shutko].
794 * uffi/clsql-uffi-loader.lisp: Improvements for loading with SBCL X86-64
795 * sql/metaclasses.lisp: Don't change case of a :base-table string supplied
796 to def-view-class [fix suggested by Fred Gilham].
798 25 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
799 * tests/*.lisp: Change Vladamir to Vladimir per Cyrus Harmon's
801 * sql/utils.lisp: Fix unnecessary consing noted by Fred Gilham.
802 * doc/*.xml: Fix spelling of Vladimir
804 24 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
805 * doc/bookinfo.xml, doc/csql.xml, doc/intro.xml: Update links
806 now that LispWorks is an independant company [noted by
809 22 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
810 * db-sqlite/sqlite-sql.lisp, db-sqlite3/sqlite3-sql.lisp:
811 Better support for 64 bit environments
813 05 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
815 * sql/metaclass.lisp: Make t the default value of :set
816 [noted by Cyrus Harmon]
818 28 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
820 * uffi/clsql-uffi.lisp: Add support for unsigned integers
821 * db-mysql/mysql-sql.lisp: Add support for detecting/marking
822 unsigned integers. Apply patch from Yannick Gingras to
823 implement database-sequence-last.
825 26 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
826 * doc/ref-fdml.lisp: Fix variable tag name to varname
827 [noted by Eduardo Munoz]
828 * db-mysql/mysql-loader.lisp: Handle library paths for 64-bit systems
830 06 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
832 * sql/ooddl.lisp: Accept patch from Klaus Harbo for
834 * sql/metaclass.lisp: Remove unnecssary (and runtime error
835 causing) change-class invocation when running on CLISP.
836 * db-mysql/mysql-api.lisp: Commit patch from Paul Werkowski
837 to fix structure name.
838 * sql/database.lisp: More specific error message with trying
839 to use a database value of NIL.
840 * sql/expressions.lisp: Accept a string for the table name
841 in (sql-output sql-delete database) [suggested by Ed Symanzik].
843 11 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
845 * sql/generic-postgresql.lisp: Commit patch from Chris Capel to
846 ignore columns which have been dropped.
847 * clsql-postgresql-socket.asd, db-postgresql-socket/postgresql-socket-package.lisp:
848 Use sb-md5 package on SBCL, recommended by Chris Capel
850 09 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
851 * Version 3.1.0 released: New SQLite3 backend by Aurelio Bignoli
852 * doc/appendix.xml: Document SQLITE3 backend, patch by Aurelio Bignoli
853 * sql/operations.lisp: Add lower and upper SQL functions [Daniel Lowe].
855 08 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
856 * sql/expressions.lisp: Fix slot name [thanks to Daniel Lowe]
858 31 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
859 * clsql-sqlite3, db-sqlite3/*: NEW BACKEND
860 contributed by Aurelio Bignoli
862 23 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
863 * sql/oodml.lisp: Commit patch from Walter Pelis
864 to use an object's database for a select on its slot.
866 20 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
867 * uffi/uffi.c, uffi/clsql-uffi.lisp: Commit patch from
868 Aurelio Bignoli to fix negative 64-bit integers
870 07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
871 * db-mysql/mysql.c: Fix parameters in bind_param call
873 07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
874 * uffi/clsql-uffi.lisp: Add support for :blob result-type
875 * db-mysql/mysql-sql.lisp: Add support for :blob
878 04 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
879 * db-mysql/mysql-sql.lisp, db-db2/db2-sql.lisp: Add
880 missing quotes for types in code that is still in development
881 (thanks to Joerg Hoehle)
883 03 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
884 * Version 3.0.8 released
885 * db-sqlite/sqlite-*.lisp: Apply patch from
886 Aurelio Bignoli with improvements
888 01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
889 * multiple: Apply patch from Joerg Hoehle with multiple
892 01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
893 * Version 3.0.7 released
894 * sql/oodml.lisp, sql/package.lisp, db-mysql/mysql-objects.lisp:
895 Add support for mediumint.
896 * sql/metaclass.lisp: Rework CLISP MOP handling
897 * sql/ooddl.lisp: Work-around to have CLISP finalize standard-db-class
899 28 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
900 * sql/metaclass.lisp: Support CLISP's attribute name
901 for the type field in direct class slots
903 27 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
904 * Version 3.0.6 released
905 * BUGS: New file. Document suspected SIGPIPE
906 interaction between SBCL and libpq used in
908 * doc/ref-fdml.lisp: Document the :caching and :refresh
909 keywords of the SELECT function.
910 * doc/ref-ooddml.lisp: Document the new *default-caching*
912 * sql/package.lisp: Export *default-caching*
913 * sql/oodml.lisp: Use *default-caching* to
914 control default caching behavior.
916 21 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
917 * Version 3.0.5 release
918 * doc/appendix.xml: Add note about loading Oracle8 version
919 * db-oracle/oracle-loader.lisp: Support Oracle8 based on
920 data from David Young.
922 10 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
923 * doc/Makefile, doc/catalog-darwin.xml: Apply
924 patch from Cyrus Harmon for building docs on Mac OS X
925 * sql/package.lisp: Add new (pre-release) clisp MOP package
927 09 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
928 * Version 3.0.4 Release
929 * multiple: Remove superfluous quotes in UFFI def-type
930 and def-foreign-type forms.
932 07 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
933 * Version 3.0.3 Release
934 * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
935 from Tagore Smith to call force-output after sending authentication
936 * db-odbc/odbc-api.lisp: Move ODBC v3 conversons
937 * db-odbc/odbc-sql.lisp: Load mysql or postgresql package when connecting
938 to a database of that type so that functions that indicate capabilities of
939 database are available.
941 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
942 * db-odbc/odbc-api.lisp: More conversions to ODBC v3
944 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
945 * Version 3.0.2 Release
946 * TODO: Add note about ODBC on Windows
947 * db-odbc/odbc-loader.lisp: Add /winnt/system32/ to
949 * db-odbc/odbc-ff-interface.lisp: Change the return type
950 of SQLSetEnvAttr to :short
952 02 Sep 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
953 * examples/clsql-tutorial.lisp: added missing initarg for the COMPANYID
954 slot of the employee View Class definition [reported by Franz Deuzer].
956 01 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
957 * Version 3.0.1 Release
958 * tests/test-init.lisp: Add second join class to employee-address
959 to test a class with two join slots.
960 * sql/oodml.lisp: Fix find-all function for a class with multiple
962 * TODO: Remove need to test/fix multiple join classes
964 27 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
965 * db-mysql/Makefile, db-mysql/mysql-loader.lisp: accept patch
966 from Jon Buffington for file locations on Darwin.
968 17 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
969 * sql/db-interface.lisp: Improve messages when functions
970 are passed a database object, but the method is not specialized
971 for that database type.
972 * sql/metaclasses.lisp: Fix inline declaration (reported by
975 14 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
976 * TODO: Add bug report about SQL generation with a table
977 containing two join slots.
978 * sql/oodml.lisp: Add optional size to VARCHAR type
980 3 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
981 * Version 3.0.0 Release
982 * sql/expressions.lisp: Change declaration that
983 caused error on openmcl
984 * db-aodbc/aodbc-sql.lisp: Fix storage location
985 of odbc connection. Specialize database-query since
986 dbi's :types keyword is different than generic-odbc's
987 :result-types keyword
988 * sql/db-interface.lisp: Add warnings for methods
989 not specialized by a db backends
990 * tests/test-fddl.lisp: Fix case of symbols to support
991 case-sensitive Allegro
992 * db-oracle/oracle-sql.lisp: Rework errbuf in handle-oci-error
993 * tests/test-init.lisp: Note that odbc driver for postgresql
994 doesn't properly handle table ownership
995 * LATEST-TEST-RESULTS: update with version 3.0.0
997 1 Aug 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
998 * sql/expressions.lisp: conditionalise escaping of backslash in
999 generated SQL strings on backend.
1000 * tests/test-fdml.lisp: test for escaping of backslash.
1001 * sql/oodml.lisp: minor tidying in FIND-ALL.
1003 26 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1004 * NEWS: Initial 3.0 announcement draft
1005 * README: Expand acknowledgements of incorporated projects
1006 * CONTRIBUTORS: Further document Marcus Pearce contributions
1008 23 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1009 * sql/oodml.lisp: add DATABASE-OUTPUT-SQL-AS-TYPE method specialisation
1010 to print floats with the exponent markers removed.
1011 * tests/test-oodml.lisp: add tests for updating records with floats.
1013 22 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1014 * db-oracle/oracle-sql.lisp: enable :OWNER :ALL in DATABASE-LIST-* for
1015 CommonSQL compatibility.
1016 * tests/test-init.lisp: skip test :FDDL/TABLE/6 on Oracle since
1017 this column constraint syntax is not supported.
1018 * tests/test-fddl.lisp: change column indexed in test :FDDL/INDEXES/2
1019 from EMPLID to LAST_NAME since Oracle complains that EMPLID is already
1022 17 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1023 * doc/ref-fdml.xml: document CACHE-TABLE-QUERIES.
1024 * tests/test-fdml.xml: add test for CACHE-TABLE-QUERIES.
1025 * doc/ref-ooddl.xml: minor changes to syntax and examples entries
1027 * doc/ref-oodml.xml: add examples for OODML.
1028 * sql/oodml.lisp: ensure SELECT passes on its REFRESH argument
1030 * sql/metaclasses.lisp: update docstrings.
1031 * tests/test-init.lisp: change :db-constraints for emplid to
1032 (:not-null :unique) as a temporary test for multiple column constraints
1034 * tests/test-oodml.lisp: add tests for *DB-AUTO-SYNC* and
1035 return type of (SETF SLOT-VALUE-USING-CLASS).
1036 * TODO, doc/TODO: remove items done.
1039 16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1040 * sql/oodml.lisp: on Lispworks, use weak valued hash tables for
1042 * sql/expressions.lisp: Fix SQL generation for the symbol NIL.
1044 16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1045 * sql/expressions.lisp: reactivate caching of generated SQL strings.
1046 Move methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY
1047 here from sql/fdml.lisp. Rationalise behaviour of SQL-OUTPUT,
1048 OUTPUT-SQL and DATABASE-OUTPUT-SQL.
1049 * sql/fdml.lisp: remove disabled method ADD-STORAGE-CLASS. Move
1050 methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY to
1051 sql/expressions.lisp.
1052 * sql/ooddl.lisp: replace call to DATABASE-OUTPUT-SQL in
1053 DATABASE-PKEY-CONSTRAINT with call to SQL-OUTPUT.
1054 * sql/generics.lisp: add docstrings.
1056 15 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1058 * db-oracle/oracle-sql.lisp: Remove OpenMCL specific
1059 code in favor of fixing UFFI with James Bielman's patch
1061 14 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1063 * db-oracle/oracle-sql.lisp: Apply patch for OpenMCL/OSX
1066 14 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1067 * README, INSTALL: update URLs. Minor updates to descriptions.
1068 * tests/README: remove stuff about editing contexts.
1070 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1071 * db-oracle/oracle-objects.lisp: Change *default-varchar-length* to
1072 *default-string-length*
1074 12 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1075 * tests/test-syntax.lisp, tests/test-fdml.lisp: add tests for escaping
1077 * tests/test-fddl.lisp: add tests for column and table constraints
1078 in CREATE-TABLE. Add test for OWNER keyword parameter to
1079 LIST-TABLES (assuming same underlying machinery in other FDDL
1081 * tests/test-init.lisp: restrict above test to postgresql and oracle.
1083 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1084 * db-sqlite/sqlite-sql.lisp: Fix condition as reported by Aurelio
1087 11 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1088 * sql/oodml.lisp, sql/package.lisp, doc/ref-ooddl.lisp, db-mysql/mysql-objects.lisp: Add tinyint type
1090 10 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1092 * doc/*.xml: documentation additionals and fixes so
1093 that docbook passes xmllint.
1095 9 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1097 * sql/fdml.lisp: Apply patch from Kim Minh Kaplan
1098 to change escaping of single quotes. Mild optimizations
1099 for escaped string output.
1100 * doc/ref-ooddl.lisp: documentation additions
1101 * doc/ref-oodml.lisp: Add purpose to functions
1102 * TODO: Add need to test single quote escaping
1104 7 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1105 * doc/ref-ooddl.xml, doc-ref-oodml.xml: documentation additions
1106 * sql/ooddl.lisp: Added SMALLINT type
1107 * sql/generic-postgresql.lisp: Added INT2 as SMALLINT type
1108 * db-mysql/mysql-objects.lisp: Added SMALLINT type
1109 * sql/package.lisp: Export SMALLINT
1110 * sql/expressions.lisp: Add MYSQL's UNSIGNED and ZEROFILL as
1113 6 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1114 * sql/expressions.lisp: add AUTO-INCREMENT and UNIQUE to the
1115 recognised column constraints for CREATE-TABLE and the :DB-CONSTRAINTS
1116 View Class slot option.
1117 * sql/ooddl.lisp: fix bug preventing the :DB-CONSTRAINTS View Class
1118 slot option accepting a list of constraints [reported by Travis Cross].
1119 * doc/ref-fddl.xml: add some examples of specifying column and
1120 table constraints to the documentation for CREATE-TABLE.
1121 * TODO: add note about adding tests for table/column constraints. Add
1122 optimisation note about using cached attribute types in insert/update
1125 3 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1126 * doc/appendix.xml: add notes about idiosyncrasies/unsupported
1127 features and so on the documentation for each backend.
1128 * doc/TODO: remove items done.
1129 * doc/ref-transaction.xml: add note in introduction about
1130 autocommit mode as a difference from CommonSQL.
1131 * doc/ref-syntax.xml: add notes about SQL syntax state functions
1132 being macros in CLSQL. Add note about SQL operators which are
1135 2 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1136 * Version 2.11.12 released
1137 * doc/ref-recording.xml: document SQL I/O recording.
1138 * doc/ref-prepared.xml: new file for documenting prepared statements.
1139 * doc/clsql.xml: comment out include for large object and CLSQL-SYS
1141 * doc/ref-conditions.xml: complete documentation of condition system.
1142 * doc/global-index.xml: add symbols from condition system and remove
1143 those from LOB and prepared statement APIs.
1144 * doc/ref-fdml.xml: complete documentation of FDML.
1145 * doc/glossary.xml: add View Class.
1146 * doc/TODO: remove items done.
1147 * sql/conditions.lisp: make SQL-CONDITION a parent of SQL-ERROR.
1148 * sql/package.lisp: remove FOR-EACH-ROW from exports list. Export
1149 additional slot accessors for condition classes.
1151 1 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1152 * doc/ref-ooddl.lisp: Add documentation
1153 * doc/ooddl.lisp: Move *DEFAULT-VARCHAR-LENGTH* from oodml.lisp
1154 and rename to *DEFAULT-STRING-LENGTH*. Add docstring.
1155 * doc/oodml.lisp: Rename references to new name of
1156 *DEFAULT-STRING-LENGTH*
1158 1 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1159 * doc/ref-transaction.xml: document transaction handling.
1160 * sql/transaction.lisp: ensure that COMMIT, ROLLBACK and
1161 START-TRANSACTION return NIL as per the CommonSQL spec. Modify
1162 ADD-TRANSACTION-{ROLLBACK|COMMIT}-HOOK such that a database is
1163 passed as a keyword argument defaulting to *DEFAULT-DATABASE*.
1166 30 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1167 * doc/ref-fdml.xml: document the FDML.
1168 * doc/ref-fddl.xml: move documentation for TRUNCATE-DATABASE here.
1169 * sql/ooddl.lisp: moved *default-varchar-length* to here from
1170 oodml.lisp and renamed to *default-string-length*
1172 23 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1173 * sql/oodml.lisp: Add keyword :transactions to def-view-from-class
1174 to allow specifying transactionless table creation
1175 * doc/ref-oodml.lisp: Add new keyword to signature of
1178 18 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1180 * sql/expressions.lisp: when removing duplicate table identifiers
1181 in the FROM clause of a query, check both table name and alias
1183 * sql/fdml.lisp: remove DESCRIBE-TABLE.
1184 * sql/db-interface.lisp: remove generics DESCRIBE-TABLE and
1185 DATABASE-DESCRIBE-TABLE.
1186 * sql/package.lisp: remove DESCRIBE-TABLE, DATABASE-DESCRIBE-TABLE
1187 and LIST-TABLE-INDEXES.
1188 * sql/generic-postgresql.lisp: add reader conditional #+nil for
1189 DATABASE-DESCRIBE-TABLE and comment about its uses for
1190 re-implementing LIST-ATTRIBUTE-TYPES with a single SQL query
1191 returning type info for all attributes.
1192 Fix DATABASE-SEQUENCE-LAST.
1193 * sql/fddl.lisp: remove LIST-TABLE-INDEXES and redefine
1194 LIST-INDEXES with additional keyword parameter :ON.
1195 * tests/test-fddl.lisp: replace LIST-TABLE-INDEXES in :fddl/index/3
1196 with LIST-INDEXES (with :ON parameter).
1197 * doc/global-index.xml: remove DESCRIBE-TABLE and LIST-TABLE-INDEXES.
1198 * doc/ref-connect.xml: minor tidying.
1199 * doc/ref-fddl.xml: document the FDDL.
1200 * doc/TODO: removed items done. Moved note about transaction handling
1202 * TODO: move note about transaction handling to doc/TODO. Added
1203 optimization note about LIST-ATTRIBUTE-TYPES and LIST-INDEXES.
1205 13 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1207 * sql/syntax.lisp: updated docstrings.
1208 * sql/package.lisp: exported DATABASE-NAME-FROM-SPEC from CLSQL
1210 * sql/database.lisp: add docstrings for CREATE-DATABASE,
1211 DESTROY-DATABASE, TRUNCATE-DATABASE and LIST-DATABASES. Replace
1212 CLSQL-GENERIC-ERROR signalled in RECONNECT with SQL-CONNECTION-ERROR.
1213 * doc/ref-syntax.xml, doc/global-index.xml: minor tidying.
1214 * doc/ref-connect.xml: document connection/initialisation.
1215 * doc/ref-fdml.xml: move TRUNCATE-DATABASE reference entry here.
1216 * doc/TODO: remove items done.
1217 * Makefile: add db-oracle to to SUBDIRS.
1219 13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1220 * sql/oodml.lisp: Add new serialization functions:
1221 WRITE-INSTANCE-TO-STREAM and READ-INSTANCE-FROM-STREAM
1222 * sql/expressions.lisp: Avoid duplicate FROM names when selecting
1223 from a table that has more than one primary index.
1224 * sql/conditions.lisp: Fix printing of closed-database error
1226 13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1228 * sql/conditions.lisp: Set initial slot value for message in SQL-WARNING
1229 * sql/transactions.lisp: Correctly set slots of SQL-WARNING
1231 12 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1232 * sql/package.lisp: export DATABASE-TYPE from CLSQL and subclasses
1233 of SQL-EXPRESSION from CLSQL-SYS.
1234 * sql/syntax.lisp: make error signalled in SQL-OPERATION an
1235 SQL-USER-ERROR. Make SQL-OPERATOR return just one value.
1236 * doc/Makefile: added Mandrake linux.
1237 * doc/catalog-redhat.xml, doc/catalog-mandrake.xml: new files.
1238 * doc/appendix.xml: fixed little typo (adsf).
1239 * doc/glossary.xml: removed closed-database and note about
1240 sql-expression, added some entries.
1241 * doc/ref-syntax.xml: documented the symbolic SQL syntax.
1243 10 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1245 * db-mysql/mysql-loader.lisp: Remove load of unnecessary zlib library
1246 * multiple: Add generalized-boolean type as requested by
1248 * TODO: Added need for test of generalized-boolean
1250 9 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1251 * Version 2.11.7 released
1252 * uffi/clsql-uffi-loader.lisp: Apply patch from Edi Weitz
1253 for loading with clc-register-user-package. Remove personal
1254 directory from path lisp.
1255 * db-mysql/mysql-loader.lisp: Similar changes
1257 8 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1258 * Version 2.11.6 released
1259 * sql/oodml.lisp: Commit patch from Edi Weitz
1260 to fix symbol writing/reading
1261 * TODO: Add need for symbol slot test
1263 7 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1264 * sql/package.lisp: remove duplicate export of
1265 *CACHE-TABLE-QUERIES-DEFAULT*.
1266 * doc/ref-*.xml, doc/global-index.xml: new files documenting
1267 the CommonSQL compatible api.
1268 * tests/test-fdml.lisp: modified the test :fdml/transaction/3 to
1269 reflect changes in return values of WITH-TRANSACTION.
1271 04 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1272 * tests/README: Fix filename [reported by Bill Clementson]
1273 * sql/transactions.lisp: Apply return value patch from
1274 Edi Weitz for WITH-TRANSACTION
1275 * tests/README: Remove ptester package requirement (as noted
1278 03 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1279 * Version 2.11.5 released
1280 * examples/clsql-tutorial.lisp: Remove obsolete :nulls-ok attribute,
1281 Select connection-spec based on connection type. Bugs reported by
1283 * uffi/uffi.dll, uffi/uffi.lib: Recompile with Visual Studio 2003
1284 * db-mysql/mysql-loader.lisp: Update check for zlibwapi library
1285 name on Windows, add \bin\ directory to search path
1287 31 May 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1288 * db-odbc/odbc-sql.lisp: DB-TYPE replaced with DATABASE-TYPE in
1290 * sql/operations.lisp: substr now generates SUBSTR for use on
1291 Oracle; added a new operator SUBSTRING for use elsewhere. minus
1292 now generates MINUS for use on Oracle. Nvl signals an error if
1293 not called with exactly 2 arguments. Add concat function for use
1294 instead of the || operator on MySQL and Oracle.
1295 * sql/syntax.lisp: changed internal symbol for the || operator to
1297 * sql/expressions.lisp: removed redundant and unused functions
1298 GENERATE-SQL (cf. SQL-OUTPUT) and DATABASE-CONSTRAINT-DESCRIPTION
1299 (cf. MAKE-CONSTRAINTS-DESCRIPTION).
1300 * sql/generics.lisp: removed generic function for
1301 DATABASE-CONSTRAINT-DESCRIPTION (see above).
1302 * tests/test-syntax.lisp: modified/added tests according to changes
1303 in sql/operations.lisp.
1304 * tests/test-fdml.lisp: changed SUBSTR to SUBSTRING in test
1306 * sql/package.lisp: added the operators SQL-SUBSTRING, SQL-CONCAT-OP
1307 and SQL-USERENV to the shared exports list. Removed
1308 ROLLBACK-TRANSACTION, COMMIT-TRANSACTION, DATABASE-START-TRANSACTION,
1309 DATABASE-ABORT-TRANSACTION, DATABASE-COMMIT-TRANSACTION,
1310 TRANSACTION-LEVEL, TRANSACTION, RECORD-SQL-COMMAND and
1311 RECORD-SQL-RESULT from shared exports list.
1313 30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1314 * db-postgresql/postgresl-sql.lisp: Avoid computing
1315 result-types lisp when nil result-types. Return only
1316 one value when field-types nil.
1317 * db-mysql/mysql-sql.lisp: Simple queries now
1318 working with prepared statements.
1320 30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1321 * Version 2.11.4: MySQL 4.1 now passes all tests
1322 * sql/package.lisp: Add API for prepared statments.
1323 * sql/fdml.lisp: Change implicit flatp processing
1324 for string map-query for greater CommonSQL conformance.
1325 Add high-high API for prepared statements.
1326 * tests/test-basic.lisp: Add test for map-query and
1328 * sql/transactions.lisp: Change name/semantics of
1329 autocommit to set-autocommit.
1330 * sql/generic-postgresql.lisp: Add support for
1331 prepared statements.
1332 * tests/test-internal.lisp: New file
1333 * sql/odbc-api.lisp: Update to using ODBC V3 protocol
1334 * clsql-mysql.asd, clsql-uffi.asd: Remove check and Common Lisp
1335 Controller invocation.
1336 * db-mysql/mysql-api.lisp: Add support for MySQL 4.1 field structure
1337 * sql/expressions.lisp: Avoid emitting double parenthesis when a
1338 function contains a subselect.
1340 27 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1342 * sql/ooddl.lisp: Commit patch from Edi Weitz fixing return
1343 type (setf slot-value-using-class)
1344 * TODO: add not that need a test case for the above fix
1345 * db-sqlite: Remove clisp support since clisp can not run CLSQL
1347 * db-oracle/oracle-sql.lisp: By default, use OCIEnvCreate as
1348 introduced in Oracle8. Leave older code selectable by a reader macro
1349 for Oracle7 and prior. Avoid use of OCIServerAttach since CLSQL
1350 uses OCILogon and does not the more complex session management.
1352 26 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1353 * sql/oodml.lisp: Commit universal-time typo patch from Edi Weitz
1354 * test/test-init.lisp: Add universal-time slot to person.
1355 * test/test-fddl.lisp: Add tests of universal-time slot
1356 * test/test-ooddl.lisp: Test universal-time slot in an object
1357 * TODO: Remove need for universal-time test
1358 * debian/rules, debian/control: Add cl-sql-oracle binary package
1359 * doc/appendix.xml: Add Oracle backend information
1360 * db-oracle/oracle-objects.lisp: Add database-get-type-specifier for
1361 universal-time. Convert BIGINT CLSQL type to CHAR SQL type
1362 * db-mysql/mysql-sql.lisp: Fix condition name to sql-connection-error
1363 * doc/ref-clsql.xml: Renamed from ref_clsql.xml. Change the documentation
1364 for map-query to reflect changed in arguments to be CommonSQL compatible.
1365 Updated old clsql conditions to new CommonSQL compatible conditions.
1367 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1368 * sql/oodml.lisp: (string n) now produces a CHAR field. Add new VARCHAR
1369 type. Added *default-varchar-length* rather than previous hard-coded
1370 varchar length. Remove 'simple-string and 'simple-base-string since they
1371 are subtypes of 'string.
1372 * db-oracle/oracle-sql.lisp: Use *default-varchar-length* rather than
1373 local hard-coded value.
1374 * sql/metaclasses.lisp: Convert specified type VARCHAR and (VARCHAR n) to Lisp
1375 type string. Convert specified-type (CHAR n) to string. Convert specified-type
1376 CHAR to lisp type character.
1377 * sql/generic-postgresql.lisp: (string n) => (CHAR n)
1378 * sql/operations.lisp: Add userenv
1379 * doc/TODO: Add AUTOCOMMIT. Remove need for large table and bigint
1381 * sql/oracle-sql.lisp: Add 64-bit bigint direct conversion
1382 * uffi/clsql-uffi.lisp: Handle signed 64-bit integers
1383 * test/test-init.lisp: Add large table with bigint slot
1385 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1386 * Version 2.11.1 released: Much simpler Oracle client library loading.
1387 Now uses ORACLE_HOME environmental variable as well as tests default
1388 path for Oracle Instant Client.
1390 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1391 * Version 2.11.0 released: Full Oracle support. All tests pass
1392 * db-oracle/oracle-sql.lisp: Add declaration so that SBCL runs efficiently.
1393 * tests/test-init.lisp: capitalize odbc backend name in banner
1394 * CONTRIBUTORS: Add note about Marcus' excellent work
1395 * sql/oodml.lisp: Removed old stub function
1396 * clsql.asd: Use module names in current package rather than keyword package
1397 * db-oracle/oracle-sql.lisp: Don't trim trailing spaces. Prevent interrupts
1398 in setting sequence position. Make autocommits more efficient.
1399 * tests/test-init.lisp: Skip 2 tests on Oracle which have unsupported syntax
1400 * sql/oodml.lisp: Get rid of undocumented raw-string type. CommonSQL
1401 strings are raw (non-trimmed trailing whitespace). Add database-get-type-specifier
1402 and read-sql-value for NUMBER and CHAR.
1403 * sql/base-classes.lisp: Add autocommit slot
1404 * sql/transaction.lisp: Added autocommit processing, mild cleaning.
1405 * doc/intro.xml: Add Oracle
1407 24 May 2004: Marcus Pearce (m.t.pearce@city.ac.uk)
1408 * db-postgresql-socket/postgresql-socket-sql.lisp: replace
1409 CLSQL-SIMPLE-WARNING with SQL-WARNING.
1410 * db-sqlite/sqlite-sql.lisp: replace CLSQL-SIMPLE-WARNING with
1412 * db-aodbc/aodbc-sql.lisp: replace CLSQL-ERROR with SQL-ERROR.
1413 * clsql.asd: reworked module structure in package definition and
1414 file names to better reflect component functionality.
1415 * sql/package.lisp: added SQL-FATAL-ERROR and SQL-TIMEOUT-ERROR to
1416 exports list. Removed duplicate and obsolete exports. Exported
1417 remaining SQL operations: SQL-SOME, SQL-<>, SQL-BETWEEN, SQL-DISTINCT,
1418 SQL-NVL and SQL-FUNCTION. Organised exports by functionality/file and
1419 according to whether they are specified by CommonSQL or CLSQL
1421 * sql/transaction.lisp: replace CLSQL-SIMPLE-WARNING with
1423 * sql/generics.lisp: moved generics for QUERY and EXECUTE-COMMAND
1424 here from basic-sql.lisp.
1425 * sql/expressions.lisp: NEW FILE: renamed from classes.lisp (deleted).
1426 * sql/fddl.lisp: NEW FILE: renamed from table.lisp (deleted).
1427 * sql/fdml.lisp: NEW FILE: merger of basic-sql.lisp and sql.lisp
1429 * sql/ooddl.lisp: NEW FILE: ooddl from objects.lisp (deleted).
1430 * sql/oodml.lisp: NEW FILE: oodml from objects.lisp (deleted).
1432 23 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1433 * Version 2.10.22 released
1434 * sql/kmr-mop.lisp, sql/objects.lisp: Since SBCL is the only implementation that
1435 has reversed class slots, change the default for ordered-class-slots so that slots
1436 are now in the same order an in the def-view-class.
1437 * sql/sql.lisp: Honor case of string table identifier to INSERT-RECORDS
1438 * test/test-fddl.lisp: Add two tests for mixed case names
1439 * db-oracle/oracle-sql.lisp: Add missing database qualifier. Return NUMBER (double)
1440 for computed fields, this will require some adjustment to the test suite which
1441 in many cases expects integers.
1442 * test/test-fdml.lisp: Accomodate that Oracle returns doubles for computed columns
1444 22 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1445 * Version 2.10.21 released
1446 * sql/sequences.lisp: Move generic sequence functions here from db-sqlite,
1447 db-odbc, and db-aodbc.
1448 * sql/*.lisp: Add db-type parameter to generic functions READ-SQL-VALUE,
1449 DATABASE-GET-TYPE-SPECIFIER, and OUTPUT-SQL-VALUE-AS-TYPE. Update methods to use these.
1450 * sql/generic-postgresql.lisp, sql/generic-odbc.lisp: New files
1451 * db-odbc/odbc-sql.lisp, db-aodbc/aodbc-sql.lisp: Move common code to
1452 sql/generic-odbc.lisp
1453 * db-postgresql/postgresql-sql.lisp, db-postgresql-socket/postgresql-socket-sql.lisp:
1454 Move common code to sql/generic-postgresql.lisp
1455 * sql/classes.lisp: honor case of string tables when outputting queries
1456 * sql/objects.lisp: Add database type to default database-get-type-specifier method
1457 * sql/sql.lisp: Add database type to default database-abort-transaction method
1458 * db-mysql/mysql-objects.lisp: New file
1459 * sql/objects.lisp: Move MySQL specific code to mysql-objects.lisp
1460 * sql/utils.lisp: Add GETENV function which will be used to get ORACLE_HOME
1462 * test/test-fdml.lisp: String table names are now case sensitive, so convert to
1463 default db case for FDML/SELECT/25
1465 22 May 2004 Kevin Rosenberg
1466 * Version 2.10.20 released: Oracle backend now fails 6 out of 200 tests
1467 * TODO: Added 2 variances from CommonSQL. Add tests for owner phrases
1468 and string identifiers with non-default case
1469 * sql/table.lisp: Don't convert string table name to a symbol.
1470 * sql/classes.lisp: Honor case of string identifiers
1471 * sql/sql.lisp: Ensure recyclebin is purged for Oracle in
1473 * db-oracle/oracle-sql.lisp: Add sequence functions, fix use of
1474 of owner phrases. Obtain server and client versions.
1475 * db-oracle/oracle-objects.lisp: Fix type specifiers
1476 * tests/test-fddl.lisp: Allow :varchar2 and :number as data types
1477 * tests/test-init.lisp: Properly get username from Oracle connection-spec
1479 22 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1480 * sql/generics.lisp: reworked docstrings. Remove generics for
1481 ADD-TO-RELATION and REMOVE-FROM-RELATION.
1482 * sql/objects.lisp: reworked docstrings. Changed UPDATE-OBJECT-JOINS
1483 to UPDATE-OBJECTS-JOINS for CommonSQL compatibility.
1484 * sql/package.lisp: Changed UPDATE-OBJECT-JOINS to UPDATE-OBJECTS-JOINS
1485 for CommonSQL compatibility. Remove ADD-TO-RELATION and
1486 REMOVE-FROM-RELATION.
1487 * tests/test-oodml.lisp: Changed UPDATE-OBJECT-JOINS to
1488 UPDATE-OBJECTS-JOINS for CommonSQL compatibility.
1489 * doc/TODO: added notes about extra slot options to DEF-VIEW-CLASS.
1490 * sql/conditions.lisp: add documentation for conditions. Add
1491 SQL-TIMEOUT-ERROR and SQL-FATAL-ERROR for CommonSQL compatibility.
1493 21 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1494 * sql/basic-sql.lisp: reworked docstrings.
1495 * sql/transactions.lisp: reworked docstrings.
1496 * sql/sql.lisp: reworked docstrings.
1497 * sql/initialize.lisp: reworked docstrings. INITIALIZE-DATABASE-TYPE
1498 sets *DEFAULT-DATABASE-TYPE* for CommonSQL compatibility.
1499 * sql/database.lisp: reworked docstrings.
1500 * doc/TODO: added notes about START-TRANSACTION and IN-TRANSACTION-P
1501 and FDML extensions and database extensions.
1503 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1504 * db-oracle/oracle-sql: Use clsql-specific error conditions. Use owner keyword.
1505 * db-oracle/make9.sh: add makefile for building with Oracle 9 client
1507 * sql/table.lisp: Add logic for dealing with Oracle 10g vs. previous
1508 Oracle versions with the PURGE option required for drop table. This needs
1509 to be converted to a generic function and moved to db-oracle/oracle-sql.lisp
1511 20 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1512 * sql/classes.lisp: remove unused PARAMS slot in SQL-IDENT-ATTRIBUTE.
1513 * sql/syntax.lisp: remove unused PARAMS keyword arg to SQL-EXPRESSION.
1514 * sql/table.lisp: reworked docstrings.
1515 * sql/objects.lisp: moved *default-update-objects-max-len* here from
1517 * doc/TODO: notes about :if-does-not-exist arg to DROP-TABLE,
1518 DROP-VIEW and DROP-INDEX and the use of the :transactions and
1519 :constraints keyword args to CREATE-TABLE.
1520 * sql/classes.lisp: the DESCRIPTION argument to CREATE-TABLE is now
1521 CommonSQL compatible with respect to column constraints.
1523 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1524 * sql/oracle-sql.lisp: Now compiles and runs on SBCL.
1525 Requires UFFI 1.5.0 or higher
1527 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1529 * sql/conditions.lisp: Fix cerror
1531 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1532 * Version 2.10.18 released: New condition hierarchy to be compatible
1533 with CommonSQL -- not backward compatible with previous CLSQL.
1534 * sql/db-interface.lisp: Add more default methods
1535 * sql/objects.lisp: Add explicit table name to order-by parameters
1536 in find-all when only one table to avoid selecting a duplicate row.
1537 Fix error in FIND-ALL when using :order-by such as (([foo] :asc))
1538 as previous logic was adding two fields (foo asc) to SELECT query.
1539 Make :result-types :auto be the default for object selections.
1540 Properly handle caching key when using multiple order-by with asc/desc
1542 * db-oracle/*.lisp: Much improvements, now passes 90% of test suite
1544 19 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1545 * sql/recording.lisp: reworked docstrings.
1546 * sql/syntax.lisp: reworked docstrings.
1547 * doc/TODO: added notes about extensions to SQL-RECORDING-P and the
1548 SQL syntax state functions being macros.
1550 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1551 * sql/package.lisp: Export initialize-database-type and
1552 *initialize-database-types* from CLSQL package.
1553 * sql/conditions.lisp: Add new CommonSQL compatible conditions,
1554 remove old CLSQL conditions.
1555 * sql/loop-extensions.lisp: Make errors of type sql-user-error
1556 * */*.lisp: Convert to from old to new conditions
1558 18 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1559 * sql/table.lisp: Add PURGE to drop command for oracle 10g backend.
1560 To handle this difference, will need to add a new database-drop-table
1562 * db-oracle/oracle-sql.lisp: Move server-version and
1563 major-version-number to database object to allow multiple connections
1564 to Oracle servers of different versions.
1566 18 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1567 * TODO: moved notes about backends to doc/TODO.
1568 * doc/TODO: added notes about backends and select extensions.
1569 * sql/base-classes.lisp: remove obsolete schema slot in database
1572 16 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1573 * db-oracle/oracle-api: Add OCIServerVersion
1574 * db-oracle/oracle-sql: Query and store server version on connect
1575 * sql/db-interface.lisp: Add new db-type-has-bigint? generic
1576 function to handle OCI's lack of bigint support
1577 * test/test-basic.lisp: Separate bigint testing
1578 * test/test-utils.lisp: Add oracle to specs and list of backends
1579 * doc/TODO: New file
1580 * test/test-fdml.lisp: Added FDML/SELECT/34 to test
1581 run-time instantiation of variables in reader macros.
1582 * TODO: Remove item already complete. Add note about
1585 16 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1586 * sql/syntax.lisp: added condition to the reader macro to treat [*]
1587 as a column identifier (rather than an operation) for CommonSQL
1589 * tests/test-fdml.lisp: add tests for ORDER-BY and SET-OPERATION
1590 keword args to SELECT, [*] as column identifier, new MAP-QUERY
1591 behaviour and the ANY and ALL operators in subqueries.
1592 * tests/test-init.lisp: add set-operation and subquery tests to
1593 appropriate skip lists.
1594 * sql/objects.lisp: remove redundant and non CommonSQL compatible
1595 ORDER-BY-DESCENDING keyword argument for SELECT.
1596 * sql/classes.lisp: remove redundant and non CommonSQL compatible
1597 ORDER-BY-DESCENDING keyword argument for SELECT.
1598 * tests/test-oodml.lisp: add test for ORDER-BY keyword to SELECT
1599 with object queries.
1601 15 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1602 * sql/db-interface.lisp: Add new db-type-has-union?
1603 since Mysql 3.23 does not support unions.
1604 * sql/test-init.lisp: Don't try union tests on database
1605 backends which do not support it.
1606 * db-oracle/*.lisp: initial port to UFFI
1607 * sql/objects.lisp: implement UPDATE-OBJECT-JOINS,
1608 implement REFRESH for SELECT.
1609 * tests/test-oodml.lisp: Add tests for deferred retrieval,
1610 caching, refresh, and update-object-joins
1611 * tests/test-init.lisp: Add deferred-employee-address class
1613 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1614 * sql/operations.lisp: make MINUS operator a synonym for EXCEPT. Add
1615 COALESCE operator and make NVL a synonym for this. Make ANY, SOME,
1616 ALL and EXISTS generate function expressions so they output the
1618 * sql/classes.lisp: SELECT now generates appropriate SQL when
1619 passed the SET-OPERATION and ALL keyword arguments.
1620 * sql/classes.lisp: the ORDER-BY keyword argument to SELECT now
1621 accepts ordering constraints as pairs of the form (column direction)
1622 where direction may be :ASC or :DESC.
1623 * tests/test-syntax.lisp: added tests for MINUS and COALESCE/NVL.
1624 Correct tests for ANY, SOME, ALL and EXISTS.
1625 * tests/test-fdml.lisp: added test for COALESCE.
1626 * sql/sql.lisp: MAP-QUERY now applies FUNCTION to QUERY-EXPRESSION
1627 using funcall unless QUERY-EXPRESSION returns one column and its
1628 FLATP slot is not nil in which case apply is used.
1629 * tests/test-basic.lisp: modified calls to MAP-QUERY to reflect the
1631 * TODO: remove items done.
1632 * db-postgresql/postgresql-sql.lisp: no need to reverse results in
1633 DATABASE-LIST-ATTRIBUTES.
1634 * db-postgresql-socket/postgresql-socket-sql.lisp: no need to reverse
1635 results in DATABASE-LIST-ATTRIBUTES.
1637 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1638 * sql/classes.lisp: SELECT now accepts table identifiers as strings
1639 for CommonSQL compliance. Add support for qualified sql identifiers
1640 with aliased table names.
1641 * tests/test-fdml.lisp: added tests for table identifiers as strings
1642 in SELECT and for aliased definitions.
1643 * tests/test-syntax.lisp: added tests for alias definitions.
1645 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1646 * sql/sql.lisp: PRINT-QUERY now calls QUERY with result-types and
1647 field-names set to nil.
1648 * sql/sql.lisp: PRINT-QUERY now computes column sizes correctly
1649 with null attribute values.
1650 * sql/operations.lisp: modify SQL concatenation operator to accept
1651 unescaped || symbol.
1652 * sql/syntax.lisp: modify sql reader macro function to accept
1653 unescaped sql concatenation operator.
1654 * tests/test-fdml.lisp: unescape sql concatenation operator.
1655 * tests/test-syntax.lisp: unescape sql concatenation operator.
1656 * TODO: remove items done. Add notes about SQLITE/MYSQL backends.
1657 Note to add test for universal-time. Note about difference from
1658 CommonSQL in transaction handling.
1660 13 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1661 * tests/test-init.lisp: Add deferred-employee-address
1663 * tests/test-oodml.lisp: Add deferred retrieval testgs
1665 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1667 * LATEST-TEST-RESULTS: Run on all platforms, add AMD64
1668 * sql/sql.lisp: Add FOR-EACH-ROW macro from clsql-classic/sql.lisp
1669 * db-sqlite/sqlite-uffi-api.lisp: Fix row-pointer type
1670 * *: Fix minor style warnings
1671 * clsql-classic: Remove system and subdirectory
1672 * clsql-base: Remove system and subdirectory and
1673 fold into clsql system
1674 * doc/intro.xml: Remove reference to old clsql-base. Add x86_64
1675 as supported platform.
1677 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1678 * Version 2.10.16: CLSQL now fully supports AllegroCL AMD64
1679 * db-odbc/odbc-api.lisp: work around return-type bug [spr28889] in
1680 Allegro 7.0beta AMD64
1681 * db-odbc/*.lisp: Add a layer of indirection to foreign-type
1682 of ODBC longs since this type can vary on 64-bit platforms depending
1683 upon the compilation options of unixODBC.
1684 * db-mysql/mysql-api.lisp: Fix int vs. long slots in foreign
1685 structures found by testing with AllegroCL 7.0b AMD64.
1686 * db-*/*-loader.lisp: Load 64-bit libraries on 64-bit platorms
1687 * sql/objects.lisp: Simple implementation of UPDATE-OBJECT-JOINS.
1688 Initial caching support for SELECT
1689 * tests/test-oodml.lisp: Avoid using cache when testing select.
1690 * sql/kmr-mop.lisp: Explicitly check slot order and
1691 store as a cl:*feature*
1692 * sql/recording.lisp: Remove additional types to
1693 increase CommonSQL conformance.
1694 * tests/test-init.lisp: Change a :column attribute
1695 to test symbols as value
1696 * sql/relations.lisp: Remove functions since they don't support
1697 many to many relationships.
1698 * examples/clsql-tutorial.lisp, doc/csql.lisp: Remove use
1699 of add-to-relations function and replace with explicit field settings.
1700 * base/classes.lisp: Remove obsolute query-stream. Add record-caches slot.
1702 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1704 * LATEST-TEST-RESULTS: results with current version
1705 * sql/kmr-mop.lisp: Make CMUCL reader macros specific for cmu18
1706 since cmu19 has opposite order of class slots.
1707 * sql/objects.lisp: Fix (setf slot-value-using-class) for Lispworks
1708 * tests/test-fdml.lisp: Renumber SELECT tests to avoid overwriting
1710 * tests/test-init.lisp: Check test-database-underlying-type for
1713 8 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1714 * sql/operations.lisp: complete remaining operations for the sql
1715 syntax: SUBSTR, SOME, ORDER-BY, GROUP-BY, NULL, DISTINCT, EXCEPT,
1716 UNION, INTERSECT, BETWEEN.
1717 * sql/classes.lisp: add new classes: SQL-BETWEEN-EXPRESSION,
1718 SQL-QUERY-MODIFIER-EXPRESSION and SQL-SET-EXPRESSION.
1719 * tests/test-syntax.lisp: add tests for new operations.
1720 * tests/test-fdml.lisp: add tests for queries based on new operations.
1721 * tests/test-init.lisp: add select/20 to tests skipped for sqlite and
1722 select/20, query/5, query/7 and query/8 to tests skipped by mysql.
1723 * TODO: removed entries done.
1725 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1726 * tests/benchmarks.lisp: Add immediate vs. deferred
1729 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1730 * Version 2.10.13: Now works on openmcl 0.14.2
1731 * sql/objects.lisp: Add :retrieval :immediate for
1733 * tests/test-init.lisp: Add non-index fields for testing
1734 join class employee-addresss
1735 * test/test-oodml.lisp: Add tests for retrieval immediate
1736 * sql/metaclasses.lisp: Handle differences in direct-slot-definition
1737 values which are now listifed by openmcl 14.2.
1738 * sql/objects.lisp: more framework for supporing immediate retrieval
1740 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1741 * docs/intro.xml: Upload location of a README file
1742 * sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
1743 changing the type-specifier. Use a lisp type of (OR NULL FOO)
1744 for a specified-type of FOO unless :db-constraints :not-null.
1745 No need to specialize finalize-inheritance for openmcl.
1746 * tests/test-*.lisp: Rename fields so that joins occur on
1747 fields with different names. This ensures that join code is
1748 selecting the proper name.
1749 * test/test-init.lisp: Add :base-table for employee-address
1750 view class for testing.
1751 * sql/objects.lisp: Use view-table rather than name of table
1752 in a number of places to fix errors noted with using :base-table.
1754 6 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1755 * sql/objects.lisp: replace *update-records-on-make-instance* with
1756 *db-auto-sync* which also controls both automatic creation of
1757 new records on creation of new instance and updating of record
1758 fields on setting of instance slots (as suggested by Edi Weitz).
1759 * tests/test-init.lisp: replace *update-records-on-make-instance*
1760 with *db-auto-sync*.
1761 * sql/package.lisp: replace *update-records-on-make-instance*
1762 with *db-auto-sync*.
1763 * TODO: replace *update-records-on-make-instance* with *db-auto-sync*.
1764 * sql/objects.lisp: remove redundant rebindings of *db-initializing*
1765 and *default-database* in FIND-ALL.
1766 * sql/package.lisp: import time functions from CLSQL-BASE.
1767 * tests/test-time.lisp: replace CLSQl-BASE package qualifier with CLSQL.
1768 * tests/test-fdml.lisp: replace CLSQl-BASE package qualifier with CLSQL.
1769 * tests/test-init.lisp: replace CLSQl-BASE package qualifier with CLSQL.
1770 * tests/test-ooddl.lisp: replace CLSQl-BASE package qualifier with
1773 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1774 * sql/classes.lisp: Add SQL-OBJECT-QUERY type. Have [select 'class]
1775 now return a sql-object-query type rather than directly performing a query.
1776 This improves CommonSQL conformance.
1777 * sql/sql.lisp: Add new QUERY method for SQL-OBJECT-QUERY. Move
1778 from basic/basic-sql.lisp the DO-QUERY and MAP-QUERY since they now
1779 depend on sql-object-query-type.
1780 * sql/loop-extensions.lisp: Move from base package
1781 * classic/package.lisp: remove references to map-query and do-query
1783 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1784 * TODO: New section on optimizations, especially optimizing JOINs.
1785 * sql/objects.lisp: Have :target-slot return of list of lists rather
1786 than a list of cons pairs to be conformant with CommonSQL.
1787 Make :target-slot much more efficient by using a SQL inner join
1788 statement and just requiring one SQL query. Add :retrieval :deferrred
1789 to target-slot joins. Add placeholder for update-objects-join.
1790 * sql/classes.lisp: Add :inner-join and :on slots to sql-query class
1791 and process them for query output-sql.
1793 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1795 * base/basic-sql.lisp: Avoid multiple evaluation
1796 of query-expression in DO-QUERY
1797 * sql/objects.lisp: Make SELECT a normal function.
1798 SELECT now accepts type-modified database identifiers, such as
1799 [foo :string] which means that the values in column foo are returned
1800 as Lisp strings. Add new *update-records-on-make-instance* special
1801 variable controlling automatic creation of new instances. Add missing
1802 RESULT-TYPES keyword to FIND-ALL. Add :target-slot support.
1803 * sql/packages.lisp: Export *update-records-on-make-instance*
1804 * test/test-oodml.lisp: Add tests for :target-slot and many-to-many
1806 * test/test-fdml.lisp: Add tests for type-modified
1807 database identifiers.
1808 * test/test-init.lisp: Stop using add-relation since implementing
1809 many-to-many joins. Use *update-records-on-make-instance*
1810 to automatically store records on instance creation. Add many-to-many
1811 employee-address view-class.
1813 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1815 * base/loop.lisp: Add object iteration. Use :result-type
1816 :auto for result-set. Remove
1817 duplicate (and non-correct) code for non-list variables by
1818 simply making an atom variable into a list.
1819 * sql/package.lisp: Remove unnecessary clsql-sys package
1820 and replace it with clsql.
1821 * sql/metaclasses.lisp: Properly store specified-type from
1822 direct-slot-definition and then store translated type in
1823 effective-slot-definition
1824 * sql/classes.lisp: Don't output type in sql-output
1825 for SQL-IDENT-ATTRIBUTE. This is in preparation for supporting
1826 [foo :integer] as fields in SELECT.
1827 * sql/query.lisp: Set default for :result-types to :auto in
1829 * sql/objects.lisp: Use specified-type when invocating
1830 database-get-type-specifier. def-view-class macro now returns
1832 * base/basic-sql.lisp: Make :AUTO the default value for
1833 :RESULT-TYPES for MAP-QUERY and DO-QUERY.
1834 * sql/objects.lisp: Add bigint type
1835 * test/tests-basic.lisp: Add tests for :result-types for
1836 MAP-QUERY and DO-QUERY
1837 * test/test-fdml.lisp: Add test for result-types in LOOP
1838 and also using single symbol rather than a list for variables.
1839 Add test that default :result-types is auto for FDML QUERY.
1840 * test/test-syntax.lisp: Don't expect TYPE in the SQL-OUTPUT
1841 of SQL-IDENT-ATTRIBUTE.
1842 * test/test-oodml.lisp: Enable OO loop iteration test,
1843 modify it so it doesn't depend on boolean where.
1845 4 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1847 * sql/objects.lisp: added derived type specifier for universal time.
1848 * sql/package.lisp: added #:universal-time to clsql-sys exports.
1849 * tests/test-oodml.lisp: added test for translation of boolean slots
1850 in SELECT with object queries.
1852 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1853 * db-odbc/odbc-api.lisp: Fix changing nil to "NIL"
1854 for odbc/postgresql backend.
1855 * db-odbc/odbc-sql.lisp: Fix ATTRIBUTE-TYPE so that
1856 it can handle NIL values from the ODBC driver
1857 * tests/benchmarks.lisp: New file with initial
1859 * sql/relations.lisp: fix to add subclassing support,
1860 minor optimizations [Edi Weitz]
1862 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1864 * base/conditions.lisp: Add *backend-warning-behavior*
1866 * db-postgresql-socket/postgresql-socket-sql.lisp:
1867 Honor value of *backend-warning-behavior*
1868 * tests/test-fdml.lisp: Remove test of raw boolean value
1869 since different backends handle this differently. Add
1870 test for :column attribute.
1871 * tests/test-oodml.lisp: Add tests for boolean slot value
1872 and for :void-value attribute
1873 * tests/test-init.lisp: Use *backend-warning-behavior*
1874 to suppress warnings from postgresql about implicitly
1875 creating primary key in tables. Add new address table.
1877 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1879 * db-odbc/odbc-dbi.lisp: Convert TINYINT to integers when
1880 result-types is :auto
1881 * sql/objects.lisp: Properly handled writing/reading Boolean
1882 values from SQL database when retrieving objects.
1883 * test/test-fdml.lisp: Add another test for boolean results
1884 * test/utils.lisp: Fix incorrect declaration
1886 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1888 * sql/generics.lisp: add generic function for SELECT.
1889 * sql/objects.lisp: make SELECT a method specialisation.
1890 * sql/classes.lisp: MAKE-QUERY now calls SELECT if the selections
1891 referred to are View Classes.
1892 * base/basic-sql.lisp: in DO-QUERY and MAP-QUERY, if the
1893 query-expression arg evaluates to a list, then we have an object
1895 * tests/test-oodml.lisp: add tests for DO-QUERY and MAP-QUERY with
1897 * TODO: remove items done and add a todo for SELECT.
1898 * sql/objects.lisp: SELECT takes a :field-names arg to pass on to
1900 * sql/sql.lisp: add :field-names arg to QUERY.
1901 * tests/test-fdml.lisp: minor rework to use :field-names arg to
1904 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1905 * sql/objects.lisp: fix bug in FIND-ALL when SELECT called with 2
1906 or more View Classes.
1907 * sql/objects.lisp: make the :flatp argument to SELECT work with
1909 * sql/objects.lisp: make SELECT accept a :result-types argument
1910 (defaults to :auto) which is passed on to QUERY.
1911 * sql/objects.lisp: SELECT returns field-names as a second value.
1912 * tests/test-ooddl.lisp: add flatp arg to SELECT calls as appropriate.
1913 * tests/test-fdml.lisp: add flatp/result-types arguments to calls
1914 to SELECT and take only first value as appropriate.
1915 * tests/test-fdml.lisp: add two new tests for query result coercion
1916 and the field-names returned as a second value from SELECT.
1917 * tests/test-oodml.lisp: add flatp arg to SELECT calls as appropriate.
1919 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1920 * Version 2.10.6-pre1
1921 * sql/metaclasses.lisp: Add void-value slot
1922 * doc/csql.xml: Update def-view-class documentation
1923 * test/test-init.lisp: Change old :db-type to :db-kind.
1924 Remove old :nulls-ok attributes.
1925 * sql/objects.lisp: Add new universal-time and bigint
1926 types. Optimize reading of integers using parse-integer
1927 rather than read-from-string.
1928 * */*.lisp: Merge clsql-base-sys and clsql-base packages
1929 into clsql-base package
1930 * classic/sql.lisp: Move large object support into base, leaving
1931 classic without any functionality that is provided in the clsql
1933 * classic/package.lisp: Rename clsql-classic-sys package to
1934 its former nickname of clsql-classic
1936 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1937 * Version 2.10.5: SQLite backend now passes all result-types tests
1938 * clsql-sqlite.asd: Depend on clsql-uffi system
1939 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
1940 for efficiency and code reuse.
1941 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
1942 for better cross-implementation compatibility.
1944 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1946 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
1948 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
1949 bug on SBCL in result-field-names function as reported by Marcus Pearce
1950 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
1951 manifest in SBCL testing
1953 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1955 * sql/database.lisp: Conform more to CommonSQL output
1956 for STATUS command [Marcus Pearce]
1957 * sql/sqlite-sql.lisp: Rework to use result-types
1958 * sql/sqlite-api-clisp.lisp: Add compatibility layer
1959 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
1960 be cleaned up of most clisp reader conditionals
1961 * sql/test-init.lisp: Now run field type tests on sqlite
1964 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1966 * base/basic-sql.lisp: Set default value of :result-types
1967 to :auto for more CommonSQL conformance.
1968 * test/test-fdml.lisp: Add tests for numeric value of fields
1971 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1972 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
1973 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
1974 Return field names as second value for QUERY. This can be overridden
1975 for efficiency with the new keyword :FIELD-NAMES set to NIL
1976 in the QUERY invocation.
1977 * test/test-fdml.lisp: Add tests for new field-name feature
1978 * sql/metaclass.lisp: Remove old Lispworks cruft
1979 and replace it with invocation of new code in kmr-mop.lisp
1980 which actually works with Lispworks 4.2
1981 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
1983 * base/db-interface.lisp: Document the multiple values
1984 returned by DATABASE-ATTRIBUTE-TYPE so matches the
1985 undocumented CommonSQL behavior.
1986 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
1987 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
1988 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
1989 Implement CACHE-TABLE-QUERIES.
1990 * db-odbc/odbc-sql.lisp: Fix attribute-type function
1991 * test/test-fddl.lisp: Add tests for attribute type
1992 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
1994 * base/classes.lisp: Add attribute-cache slot to database clas
1995 * base/initialize.lisp: initialize-database-type now automatically
1996 loads database-type backend as needed.
1997 * base/test-init.lisp: Utilize new initialize-database-type functionality.
1998 * TODO: remove items done
2000 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2002 * sql/objects.lisp: remove create/drop-sequence-from-class.
2003 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
2004 * sql/objects.lisp: improved CommonSQL compatibility for
2005 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
2006 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
2007 * sql/generics.lisp: move generics from objects.lisp to here.
2009 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2010 * Version 2.9.6-pre1
2011 * db-mysql/mysql-client-info.lisp: Add client version 4.1
2013 * sql/sql.lisp: Make *default-database* the default for
2016 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2018 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
2020 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
2021 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
2022 on a metaclass specialized from standard-db-class.
2025 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2026 * Version 2.9.4: Multiple changes to support Allegro's "modern"
2027 lisp which uses a lowercase reader and has case-sensitive symbols
2028 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
2029 exposed by case-sensitive mlisp.
2031 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2032 * Version 2.9.3: All tests now pass on all platforms!
2033 * LATEST-TEST-RESULTS: New file with summary of test results
2034 * sql/generics.lisp: New file for generic function definitions.
2035 * test/test-init.lisp: Display names of skipped tests.
2036 Use unwind-protect to ensure disconnect
2037 * sql/objects.lisp: Change database-type to database-underlying-type
2038 so that actual database engine is properly identified
2039 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
2040 return an ISO timestring for compatibility with other drivers.
2041 Workaround bug in MyODBC for LIST-TABLE-INDEXES
2042 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
2043 returns floating-point values for floor and truncate operations
2044 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
2045 * tests/test-basic.lisp: Port to regression tester
2046 * test/test-init.lisp: Output to *report-stream*
2047 * docs/appendix.xml: Document ODBC and SQLite backends.
2048 * sql/classes.lisp: Make output-sql require a database parameter.
2049 This allows SQL generation to have the proper case to support
2050 the differences in case handling between CommonSQL API,
2051 Postgresql, MySQL, Oracle.
2053 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2054 * Version 2.9.2: Improvments in database capability introspection
2055 and querying. Support transactions in MySQL where available.
2056 All tests now pass on MySQL and SQLite in addition to postgresql
2057 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
2058 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
2059 DATABASE-LIST-SEQUENCES.
2060 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
2061 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
2062 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
2063 * tests/*.lisp: Check database capabilities and remove tests which
2064 the database backend does not support
2065 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
2066 controls whether InnoDB tables will be created when supported on
2067 the underlying MySQL server.
2069 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2070 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
2071 supported by all database backends (except AODBC since
2072 AODBC doesn't support index querying)
2073 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
2074 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
2075 to support index queries
2076 * db-aodbc/aodbc-sql.lisp: Filter driver manager
2077 "information_schema" tables from LIST-TABLES
2078 * tests/test-basic.lisp: Remove table after testing
2079 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
2080 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
2081 which gets the underlying type of database -- required
2082 when dealing with ODBC databases and want to query
2083 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
2084 as first database-backend specific feature. Is T on
2085 :mysql, NIL on other backends. Change DROP-TABLE to
2088 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2089 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
2091 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2093 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
2094 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
2096 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2097 * Version 2.8.0: New API function: LIST-DATABASES
2098 * base/utils.lisp: Fix command-output on CMUCL/SBCL
2099 * db-*/*-sql.lisp: Add new database-list function
2100 * base/database.lisp: Add new LIST-DATABASES command
2102 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2104 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
2105 * db-sqlite/sqlite-api-uffi.lisp: Print error string
2108 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2110 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
2113 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2115 * base/objects.lisp, base/classes.lisp: Patch
2116 for db-kind from Eduardo Munoz
2118 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2120 * base/basic-sql.lisp: Fix FLATP in QUERY
2122 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2123 * Version 2.7.3: Implement RECONNECT
2125 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2126 * Version 2.7.2: Fix ODBC on Lispworks Windows
2128 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2129 * Version 2.7.1: Fix for new ODBC backend.
2130 clsql-odbc now works on SBCL, CMUCL, OpenMCL
2131 in addition to AllegroCL and Lispworks.
2133 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2134 * Version 2.7.0: New backend: ODBC. Tests as
2135 well as AODBC backend on Allegro,Lispworks.
2136 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
2137 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
2138 to explicitly set ODBC2 support. Add BIGINT support.
2139 Add result-types support. Added SQLTables.
2140 Fix array type in fetch-all-rows. Make width
2141 changable by database or query.
2142 * base/utils.lisp: Add process functions
2143 * base/package.lisp: Export utils to CLSQL-BASE-SYS
2144 * db-aodbc: Implement sequence functions,
2145 database-list-tables, database-list-attributes
2146 * tests/utils.lisp: Add support for ODBC backend,
2147 rework READ-SPECS to use +all-db-types+
2148 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
2151 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2152 * Version 2.6.13. Requires UFFI version 1.4.9
2153 * db-odbc/*.lisp: Further porting.
2154 Pre-alpha code! But, basic query is now working.
2156 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2158 * base/transactions.lisp: Add quote for macro
2159 expansion of WITH-TRANSACTIONS [Time Howe]
2160 * db-sqlite/sqlite-sql.lisp: Support memory database
2161 in database-probe [Ng Pheng Siong]
2162 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
2163 The DBI layer is not finished.
2165 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2167 * sql/objects.lisp: add :root-class functionality for
2168 list-classes and add duration type support [Marcus Pearce]
2169 * db-odbc: Add mid-level [DBI] layer
2171 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2173 * db-aodbc: Add methods for generic functions, some are
2174 not yet implemented.
2175 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
2178 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2180 * base/package.lisp: Add missing symbols [Marcus Pearce]
2182 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2184 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
2185 * utils/time.lisp: Multiple fixes [Marcus Pearce]
2186 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
2188 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2190 * sql/*.lisp: Remove schema versioning cruft
2192 * Makefile: Add classic subdirectory
2194 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2196 * sql/sql.lisp: Fix TRUNCATE command, bug reported
2198 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
2199 specific and easy for an application to directly support.
2200 Idea from Marcus Pearce.
2201 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
2202 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
2203 Keep low-level interface for future optimization
2204 supporting LIST-ATTRIBUTE-TYPES command.
2205 * Makefile: Add to db-sqlite and test directories.
2206 Include them in top-level Makefile
2208 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2210 * sql/relations.lisp: Add missing file
2211 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
2212 * test/test-time.lips: New file [Marcus Pearce]
2214 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2216 * test/test-init.lisp: Properly handle object
2217 creation. Close database after use.
2218 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
2219 function so can have methods specialized on
2220 table being a string or an sql-table object.
2221 * base/pool.lisp: Really fix CMUCL locking
2223 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2225 * test/test-init.lisp: Signal correctly
2226 if any errors occurred in any test suite
2227 * base/loop-extensions.lisp: Fix error
2228 introduced for Lispworks
2229 * base/pool.lisp: Fix locking for CMUCL
2230 * base/objects.lisp: Remove schema-version cruft
2232 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2233 * Version 2.6.2: New CLSQL API functions:
2234 DESCRIBE-TABLE AND TRUNCATE-DATABASE
2235 Currently, this are only supported on :postgresql
2236 and :postgresql-socket
2237 * base/database.lisp: automatically load ASDF system
2238 in CONNECT if not already loaded
2239 * base/tests.lisp: disconnect database after testing
2240 * base/*.lisp: Remove CLOSED-DATABASE type in favor
2241 of storing open/closed status in slot of database
2242 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
2243 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
2244 DATABASE-DESCRIBE-TABLE
2245 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
2246 * base/conditions: Remove duplicate condition
2247 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
2248 * base/recording.lisp: Add new :QUERY type for recording
2250 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2251 * Version 2.6.1: documentation fixes, merged
2252 classic-tests into tests
2254 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2255 * Version 2.6.0 released: New API functions
2256 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
2257 * doc/ref_clsql.xml: Document new functions
2258 * base/database.lisp: New API functions
2259 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
2260 * base/utils.lisp: Fix use of position-char.
2261 Add COMMAND-OUTPUT used by backends for running
2262 external programs. Fix parsing of SQL*NET-compatible
2264 * base/loop-extension.lisp: Simplify package use
2265 for Lispworks and Allegro
2266 * db-*/*-sql.lisp: Added DATABASE-CREATE,
2267 DATABASE-DESTORY, PROBE-DATABASE methods
2268 * tests/test-init.lisp, clasic-tests/tests.lisp:
2269 Use destroy-database and create-database to ensure
2270 testing with empty database
2271 * tests/test-connection.lisp: Add tests for
2272 parsing of string connection-specs
2273 * examples/run-tests.sh: New file for running
2274 test suite on all installed CL implementations
2275 * examples/clsql-tutorial.lisp: moved from
2277 * examples/dot.clsql-tests.config: New file
2278 giving an example test configuration
2279 * test/README: Add notes about rtest/ptester
2280 downloads and link to sample test configuration file.
2282 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2283 * Version 2.5.1 released:
2284 * tests/*.lisp: Rework so tests are run
2285 on multiple backends automatically based
2286 on the contents of ~/.clsql-tests.config.
2287 Reuse helper functions from classic-tests.
2288 * base/database.lisp: Support connection-spec
2289 as string for CONNECT
2290 * classic-tests/tests.lisp: Automatically
2291 load database backends as needed.
2293 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2294 * Version 2.5.0 released:
2295 All tests for CLSQL and CLSQL-CLASSIC pass
2297 * base/loop-extension.lisp: Add Lispworks
2298 loop-extension. Improve type specifying on
2301 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2302 * Version 2.4.2 released:
2303 loop extension now supported on Allegro, all
2304 CLSQL-TESTS pass on Allegro.
2305 * sql/metaclasses.lisp: Some optimization
2306 of compute-slots, be selective when
2307 ordered-class-slots needs to be called
2308 instead of class-slots
2309 * TODO: add URL with documentation on
2310 extending Lispworks LOOP form
2312 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2313 * Version 2.4.1 released: CLSQL-TESt suite passes
2314 all tests for postgresql and CMUCL, SBCL, OpenMCL.
2315 Allegro and Lispworks pass all tests except for
2316 FDML/LOOP/1 since the loop extension have not yet
2317 been ported to those implementions.
2318 * sql/metaclasses.lisp: Added new slot to standard-db-class
2319 to hold user-specified type. OpenMCL adjustments to compensate
2320 for its type-predicate function. Since AllegroCL, Lispworks,
2321 and OpenMCL have different slot orders, added compute-slots
2322 and ordered-class-slots functions so their slot order matches
2325 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2326 * Version 2.4.0 released: All tests for clsql-classic now finish
2327 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
2328 mysql, postgresql, postgresql-sockets, and sqlite backends.
2329 * db-mysql/mysql-sql.lisp: Fix array dereferencing
2330 * classic-tests/tests.lisp: Fix package name of
2331 number-to-sql-string.
2332 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
2333 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
2334 now passes tests on all support UFFI platforms.
2335 * db-postgresql-socket/postgresql-socket-api.list: Ported to
2337 * multiple: Finish renaming of :types keyword to :result-types for
2338 greater CommonSQL compatibility, including documentation
2339 * sql/basic-cmds.lisp: Remove obsolete file
2341 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2342 * Version 2.3.3 released
2343 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
2344 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
2345 * Fix for schema table [Marcus Pearce]
2346 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
2347 * Fixes to test suite [Marcus Pearce]
2349 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2350 * db-*/*-sql.lisp: Ensure that expr in
2351 database-query-result-set is a string
2352 * Documentation integration
2354 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2355 * With for Marcus Pearce's excellent work, I've merged
2356 his clsql-usql port into clsql. The original clsql
2357 interface is available in the clsql-classic package.
2359 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2360 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
2361 adding further support for providing backend for UncommonSQL
2363 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
2364 * Integrate patch from Aurelio Bignoli for SQLite backend
2366 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
2367 * Converted documentation to XML format
2368 * Made package installable with asdf-install
2370 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
2371 * Add for-each-row macro
2373 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
2374 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
2376 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
2377 * Add support for SBCL, OpenMCL, and SCL
2378 * Add *load-truename* to search path for clsql's
2381 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
2382 * Rework use of file types in .asd files
2384 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
2385 * Add .asd definition files for ASDF users
2387 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
2388 * Restructure directories for Common Lisp Controller v3 compatibility
2390 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
2391 * Also change case of logical host in loader files
2392 * Rework handling of logical pathnames
2394 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
2395 * Change case of logical host
2397 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
2398 * clsql-base.system: Added base package that can be used without
2399 high-level SQL commands. Used for adding support for UncommonSQL.
2400 * *.system: Reworked logical pathnames to be more consistent with
2401 Common Lisp Controller.
2402 * debian/*: Completed initial Debian support
2404 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2406 * sql/transactions.cl:
2407 Added transaction support. Functions/macros added:
2408 with-transaction, commit-transaction, rollback-transaction,
2409 add-transaction-commit-hook, add-transaction-rollback-hook
2411 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2414 * sql/functional.cl:
2415 Added pool support in connect/disconnect and with-database.
2416 Removed with-db-from-pool as with-database can now works with the connections pool
2418 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2423 Completed connection pool.
2424 Added with-db-from-pool macro.
2426 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2428 Added initial support for connection pool
2429 * sql/transactions.cl
2430 Took transaction code from UncommonSQL and integrated
2431 into CLSQL code. See file for disclaimer about why this
2434 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2435 * interfaces/postgresql/postgresql-sql.cl:
2436 Fix keyword typo in database-read-large-object
2437 * interfaces/mysql/mysql-loader.cl
2438 Fix loading on Win32
2439 * test-suite/tester-clsql.cl
2440 Fix type coercion of double-float
2442 Added debian docbook catalog, made it the default
2444 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2445 * interface/postgresql/postgresql-api.cl:
2446 * interface/postgresql/postgresql-sql.cl:
2448 * sql/db-interface.cl:
2449 Added large objects support for postgresql.
2451 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2452 * src/postgresql-socket/postgresql-socket-api.cl:
2453 Fixed find-foreign-function call, eliminated crypt warning
2455 Multiple improvements
2457 Moved functionality from low-level interfaces to this file
2458 via generic functions
2459 * test-suite/tester.cl:
2460 Added test with acl-compat-tester, moved others to old-tests
2463 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2465 Reinstated commented out sections
2466 * interfaces/postgresql/postgresql-loader.cl:
2467 * interfaces/mysql/mysql-loader.cl:
2468 Updated find-forieign-library support.
2469 * interfaces/postgresql-socket/postgresql-socket-package.cl:
2470 Fixed require form for Lispworks (Thanks Marc Battyani!)
2471 * interfaces/postgresql-socket/postgresql-socket-api.cl:
2472 Fixed eval of def-function for crypt library.
2474 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2475 * Added interface to support USQL high-level rouines
2477 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2478 * Separated db-interface and conditions from sql/sql.cl
2479 * Improved foreign library loading testing
2480 * interfaces/postgresql/postgresql-api.cl
2481 Added PQisBusy function
2482 * interfaces/clsql-uffi/clsql-uffi.cl
2483 Fixed sign error for 64-bit processing
2485 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2486 * interfaces/postgresql-socket/postgresql-socket-api.cl:
2487 Fixes to read-double-from-socket. Added 64-bit integer support.
2488 * test-suite/xptest-clsql.cl
2489 Added testint for 64-bit integers
2490 * Additons to installation docs
2492 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2493 * interfaces/postgresql-socket/postgresql-socket-api.cl:
2494 Implemented direct socket reading for field type :double
2495 * Added usage information for :types to documentation
2496 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
2498 * interfaces/clsql-uffi: Created new directory. Split common
2499 interface routines that use UFFI into this package. Required
2500 especially to support direct reading of 64-bit integers into
2501 bignums and bypassing temporary strings.
2502 * test-clsql.cl: Updated to test postgresql-socket's
2503 read-double-from-socket function.
2504 * test-suite/xptest-clsql.cl
2505 Started work on test suite
2507 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2508 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
2509 mysql-fetch-field-direct Got :auto types working
2510 * interfaces/postgresql/postgresql-api.cl
2511 * interfaces/postgresql-socket/postgresql-socket-api.cl
2512 Added pgsql-field-types enum. Got :auto types working.
2514 Renamed :field-types to :types.
2516 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2517 * Added field-types parameter to query, database-query,
2518 database-query-result-set, map-query. Haven't added code
2519 to utilize field types, yet.
2520 * Changed postgresql-socket result set from cons to a structure
2521 * Updated test-clsql.cl to use automated testing with a config
2523 * Changed return types of field accessors from cstring to
2524 (* :unsigned-char). This prepares for being able to use specified
2525 type conversions when taking field data into lisp.
2526 * Added field-type processing for most interfaces. Not done yet.
2528 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2529 * doc/ref.sgml: Updated MAP-QUERY example to use
2530 *read-default-float-format* (John Foderaro)
2531 * Extensive work to foreign library loaders and .system files to
2532 check for successful loading of foreign libraries.
2533 * Modified test-clsql.cl to allow more modularity and
2534 automated testing in future release.
2535 * mysql/mysql-sql.lisp: Added field types
2537 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
2538 * mysql/mysql-sql.lisp:
2539 - Added support for Allegro CL and Lispworks using UFFI layer
2540 - Changed database-connect to use mysql-real-connect. This way,
2541 can avoid using double (unwind-protect)
2542 - Changed database-connect to have MySQL library allocate space
2543 for MYSQL structure. This will make the code more robust in
2544 the event that MySQL library changes the size of the mysql-mysql