1 12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
3 * clsql-uffi.asd: Patch from James Biel improving loading
4 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
5 to support 64-bit lisps
7 12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
9 * sql/expressions.lisp: Escape numbers to SQL strings
12 11 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
13 * Version 3.4: Add MySQL 5 support
14 * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
15 * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5
16 * doc/mysql-macosx-notes.txt: New document from Martin Brooks
18 7 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
19 * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL
21 * BUGS: Added report for update-object-joins by Aleksandar Bakic
23 4 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
24 * Version 3.3.4 [UFFI >= 1.5.5 needed]
25 * db-odbc/odbc-api.lisp: Apply patch from Yaroslav Kavenchuk
26 to add missing #\' character.
27 * clsql.asd: Add support for CLSQLINIT environmental variable,
28 based on patch from Yaroslav Kavenchcuk. New version of UFFI
31 30 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
33 * sql/oodml.lisp: Apply patch from Drew Crampsie to fix
34 update-objects-joins when using the :target-slot attribute
36 26 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
38 * sql/expressions.lisp: Avoid parenthesis on multiple group-by fields
39 as noted by Harald Hanche-Olsen.
40 * tests/test-syntax.lisp: Add test for multiple field group-by
42 25 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
44 * sql/time.lisp: Commit patch from Alan Shields to
45 display escape string on wall-time display only when *print-escape*
48 11 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
49 * sql/metaclasses.lisp: Commit patch from Will to
50 properly set db-reader slot in effective-slot-definition
51 * sql/expressions.lisp: Commit patch from Alan Shields
52 adding make-load-form for sql-relational-exp
53 * sql/generic-postgresql.lisp: Commit patch from Aleksandar Bakic
54 adding support for new NUMBER type
56 17 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
58 * sql/time.lisp: Apply patch from Alan Shields adding DATE type.
59 * doc/ref-ooddl.xml: Documentation of new type
60 * notes/add-type-hints.txt: New file from Alan Shields
61 * sql/fddl.lisp: Add owner keyword to drop-table as suggested
63 * db-postgresql-socket/postgresql-socket-sql.lisp: Fix database-probe
64 as noted by Francis Leboutte. Similar fix applied to db-mysql and
66 * sql/expressions.lisp: Allow string table names for output as
67 contributed by Francis Leboutte.
68 * examples/clsql-tutorial.lisp: Support :postgresql-socket as noted
71 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
73 * doc/into.xml: Change download from ftp to http protocol
75 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
77 * db-oracle/oracle-sql.lisp: Correction for v3.2.2 changes by
80 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
82 * db-oracle/oracle-sql.lisp: Add check for zero increment as
83 suggested by Edi Weitz. Add missing database-sequence-last function
84 as noted and tested by Edi Weitz. Ensure that UFFI buffer is freed
85 in handle-oci-error. Add unwind-protect to sql-stmt-exec. Free UFFI
86 stmthp object when query cursor is freed with OCI.
88 22 Aug 2005 Kevin Rosenberg <kevin@rosenberg.net>
89 * uffi/clsql-uffi-loader.lisp: Commit patch from astor@pvv.ntnu.no to
90 display search path when error occurs loading foreign library.
92 05 Jul 2005 Kevin Rosenberg <kevin@rosenberg.net>
94 * doc/appendix.xml: Incorporate Edi Weitz's notes into documentation
95 with changes to support case-sensitive lisp implementations. Add
96 paragraph on using /etc/clsql-init.lisp site initialization file.
97 * clsql.asd: Load file /etc/clsql-init.lisp, if it
98 exists, after package is loaded to set site-specific configuration
100 2005-06-24 Edi Weitz <edi@agharta.de>
101 * sql/db-interface.lisp: Added new special variable
102 *FOREIGN-LIBRARY-SEARCH-PATHS* and function PUSH-LIBRARY-PATH to
104 * sql/package.lisp: Export these.
105 * uffi/clsql-uffi-loader.lisp: Used new variable; changed order of
107 * db-mysql/mysql-loader.lisp: Changed order of libs.
109 09 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
110 * Version 3.2.0: REQUIRES UFFI VERSION 1.4.38 OR HIGHER
111 * clsql-mysql.asd: Renamed clsql/mysql interface library from
113 * clsql-uffi.asd: Renamed clsql/uffi interface library from
115 * uffi/clsql_uffi.c: Renamed from uffi.c
116 * db-mysql/clsql_mysql.c: Renamed from mysql.c
117 * db-mysql/Makefile, db-mysql/Makefile.msvc, db-mysql/mysql-loader.lisp: Rename shared library
118 * uffi/Makefile, uffi/Makefile.msvc, uffi/uffi-loader.lisp: Rename shared library
119 * db-*/*-loader.lisp: Commit big patch from Edi Weitz to remove
120 absolute pathnames when searching for foreign libraries.
121 foreign library loading.
123 07 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
125 * db-mysql/mysql-api.lisp: Commit patch from Espen Wiborn
126 to support UTF-8 on sbcl unicode.
128 18 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
130 * sql/time.lisp: Fix bug in roll that caused failure in test suite
132 17 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
134 * sql/oodml.lisp: Properly handle when db-writer is NIL
136 11 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
137 * sql/expressions.lisp: Avoid using simple-string declaration when
138 a non-simple string may be encountered. [issue noted by
139 will@cesmail.net] Add a simple-string declaration for a local
142 06 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
143 * sql/oodml.lisp: Change db-writer and db-reader processing to accept
144 a symbol as well as function to serve as a function designator
145 [issue noted by will@cesmail.net]
147 05 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
149 * sql/time.lisp: Fix error in submitted patch which caused error
150 in timestrings with 19 or less characters.
152 27 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
154 * db-postgresql-socket/postgresql-api.lisp: Commit patch from Tim Howe
155 to fix read-socket-sequence on non-sb-unicode sbcl.
157 26 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
159 * sql/time.lisp: Commit patch from Daniel Lowe which adds support
160 for fractional seconds which is required by PostgreSQL
161 * db-postgresql/postgresql-loader.lisp: Add library path for Windows
163 25 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
164 * sql/csql.lisp: Update URL for "SQL for Web Dummies" [Sean Champ]
166 24 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
168 * sql/syntax: Commit patch from Alan Shields to supress reader
169 macros when *read-supress* is T.
171 13 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
173 * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
174 from Janis Dzerins to support unicode on SBCL
175 * sql/syntax: Commit patch from Alan Shields to improve reporting
176 of invalid syntax statements.
178 06 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
180 * db-mysql/mysql-sql.lisp: Add port to connection specification
181 based on patch from Dave Watson
182 * doc/appendix.xml: Document MySQL port parameter to connection spec
184 03 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
186 * sql/time.lisp: Patch from Keith James for parsing ISO-8601 timestamps
188 18 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
189 * sql/oodml.lisp: Add missing database argument [Patch from
192 03 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
193 * sql/oodml.lisp: Improve database priority in
194 update-records-from-instance [Patch from Walter C. Pelissero]
196 17 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
198 * sql/package.lisp: Export database-reconnect from clsql-sys
200 08 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
201 * sql/oodml.lisp: Use explicit database in fault-join-target-slot
202 [Patch from Walter Pelissero]
204 29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
205 * db-postgresql/postgresql-loader.lisp: Add additional
206 directories to Fink on darwin [patch from Cyrus Harmon].
208 29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
210 * sql/oodml.lisp: Clear view instance cache when delete-instance-records
211 is invoked [suggested by Alan Shutko].
212 * uffi/clsql-uffi-loader.lisp: Improvements for loading with SBCL X86-64
213 * sql/metaclasses.lisp: Don't change case of a :base-table string supplied
214 to def-view-class [fix suggested by Fred Gilham].
216 25 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
217 * tests/*.lisp: Change Vladamir to Vladimir per Cyrus Harmon's
219 * sql/utils.lisp: Fix unnecessary consing noted by Fred Gilham.
220 * doc/*.xml: Fix spelling of Vladimir
222 24 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
223 * doc/bookinfo.xml, doc/csql.xml, doc/intro.xml: Update links
224 now that LispWorks is an independant company [noted by
227 22 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
228 * db-sqlite/sqlite-sql.lisp, db-sqlite3/sqlite3-sql.lisp:
229 Better support for 64 bit environments
231 05 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
233 * sql/metaclass.lisp: Make t the default value of :set
234 [noted by Cyrus Harmon]
236 28 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
238 * uffi/clsql-uffi.lisp: Add support for unsigned integers
239 * db-mysql/mysql-sql.lisp: Add support for detecting/marking
240 unsigned integers. Apply patch from Yannick Gingras to
241 implement database-sequence-last.
243 26 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
244 * doc/ref-fdml.lisp: Fix variable tag name to varname
245 [noted by Eduardo Munoz]
246 * db-mysql/mysql-loader.lisp: Handle library paths for 64-bit systems
248 06 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
250 * sql/ooddl.lisp: Accept patch from Klaus Harbo for
252 * sql/metaclass.lisp: Remove unnecssary (and runtime error
253 causing) change-class invocation when running on CLISP.
254 * db-mysql/mysql-api.lisp: Commit patch from Paul Werkowski
255 to fix structure name.
256 * sql/database.lisp: More specific error message with trying
257 to use a database value of NIL.
258 * sql/expressions.lisp: Accept a string for the table name
259 in (sql-output sql-delete database) [suggested by Ed Symanzik].
261 11 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
263 * sql/generic-postgresql.lisp: Commit patch from Chris Capel to
264 ignore columns which have been dropped.
265 * clsql-postgresql-socket.asd, db-postgresql-socket/postgresql-socket-package.lisp:
266 Use sb-md5 package on SBCL, recommended by Chris Capel
268 09 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
269 * Version 3.1.0 released: New SQLite3 backend by Aurelio Bignoli
270 * doc/appendix.xml: Document SQLITE3 backend, patch by Aurelio Bignoli
271 * sql/operations.lisp: Add lower and upper SQL functions [Daniel Lowe].
273 08 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
274 * sql/expressions.lisp: Fix slot name [thanks to Daniel Lowe]
276 31 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
277 * clsql-sqlite3, db-sqlite3/*: NEW BACKEND
278 contributed by Aurelio Bignoli
280 23 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
281 * sql/oodml.lisp: Commit patch from Walter Pelis
282 to use an object's database for a select on its slot.
284 20 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
285 * uffi/uffi.c, uffi/clsql-uffi.lisp: Commit patch from
286 Aurelio Bignoli to fix negative 64-bit integers
288 07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
289 * db-mysql/mysql.c: Fix parameters in bind_param call
291 07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
292 * uffi/clsql-uffi.lisp: Add support for :blob result-type
293 * db-mysql/mysql-sql.lisp: Add support for :blob
296 04 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
297 * db-mysql/mysql-sql.lisp, db-db2/db2-sql.lisp: Add
298 missing quotes for types in code that is still in development
299 (thanks to Joerg Hoehle)
301 03 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
302 * Version 3.0.8 released
303 * db-sqlite/sqlite-*.lisp: Apply patch from
304 Aurelio Bignoli with improvements
306 01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
307 * multiple: Apply patch from Joerg Hoehle with multiple
310 01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
311 * Version 3.0.7 released
312 * sql/oodml.lisp, sql/package.lisp, db-mysql/mysql-objects.lisp:
313 Add support for mediumint.
314 * sql/metaclass.lisp: Rework CLISP MOP handling
315 * sql/ooddl.lisp: Work-around to have CLISP finalize standard-db-class
317 28 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
318 * sql/metaclass.lisp: Support CLISP's attribute name
319 for the type field in direct class slots
321 27 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
322 * Version 3.0.6 released
323 * BUGS: New file. Document suspected SIGPIPE
324 interaction between SBCL and libpq used in
326 * doc/ref-fdml.lisp: Document the :caching and :refresh
327 keywords of the SELECT function.
328 * doc/ref-ooddml.lisp: Document the new *default-caching*
330 * sql/package.lisp: Export *default-caching*
331 * sql/oodml.lisp: Use *default-caching* to
332 control default caching behavior.
334 21 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
335 * Version 3.0.5 release
336 * doc/appendix.xml: Add note about loading Oracle8 version
337 * db-oracle/oracle-loader.lisp: Support Oracle8 based on
338 data from David Young.
340 10 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
341 * doc/Makefile, doc/catalog-darwin.xml: Apply
342 patch from Cyrus Harmon for building docs on Mac OS X
343 * sql/package.lisp: Add new (pre-release) clisp MOP package
345 09 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
346 * Version 3.0.4 Release
347 * multiple: Remove superfluous quotes in UFFI def-type
348 and def-foreign-type forms.
350 07 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
351 * Version 3.0.3 Release
352 * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
353 from Tagore Smith to call force-output after sending authentication
354 * db-odbc/odbc-api.lisp: Move ODBC v3 conversons
355 * db-odbc/odbc-sql.lisp: Load mysql or postgresql package when connecting
356 to a database of that type so that functions that indicate capabilities of
357 database are available.
359 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
360 * db-odbc/odbc-api.lisp: More conversions to ODBC v3
362 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
363 * Version 3.0.2 Release
364 * TODO: Add note about ODBC on Windows
365 * db-odbc/odbc-loader.lisp: Add /winnt/system32/ to
367 * db-odbc/odbc-ff-interface.lisp: Change the return type
368 of SQLSetEnvAttr to :short
370 02 Sep 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
371 * examples/clsql-tutorial.lisp: added missing initarg for the COMPANYID
372 slot of the employee View Class definition [reported by Franz Deuzer].
374 01 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
375 * Version 3.0.1 Release
376 * tests/test-init.lisp: Add second join class to employee-address
377 to test a class with two join slots.
378 * sql/oodml.lisp: Fix find-all function for a class with multiple
380 * TODO: Remove need to test/fix multiple join classes
382 27 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
383 * db-mysql/Makefile, db-mysql/mysql-loader.lisp: accept patch
384 from Jon Buffington for file locations on Darwin.
386 17 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
387 * sql/db-interface.lisp: Improve messages when functions
388 are passed a database object, but the method is not specialized
389 for that database type.
390 * sql/metaclasses.lisp: Fix inline declaration (reported by
393 14 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
394 * TODO: Add bug report about SQL generation with a table
395 containing two join slots.
396 * sql/oodml.lisp: Add optional size to VARCHAR type
398 3 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
399 * Version 3.0.0 Release
400 * sql/expressions.lisp: Change declaration that
401 caused error on openmcl
402 * db-aodbc/aodbc-sql.lisp: Fix storage location
403 of odbc connection. Specialize database-query since
404 dbi's :types keyword is different than generic-odbc's
405 :result-types keyword
406 * sql/db-interface.lisp: Add warnings for methods
407 not specialized by a db backends
408 * tests/test-fddl.lisp: Fix case of symbols to support
409 case-sensitive Allegro
410 * db-oracle/oracle-sql.lisp: Rework errbuf in handle-oci-error
411 * tests/test-init.lisp: Note that odbc driver for postgresql
412 doesn't properly handle table ownership
413 * LATEST-TEST-RESULTS: update with version 3.0.0
415 1 Aug 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
416 * sql/expressions.lisp: conditionalise escaping of backslash in
417 generated SQL strings on backend.
418 * tests/test-fdml.lisp: test for escaping of backslash.
419 * sql/oodml.lisp: minor tidying in FIND-ALL.
421 26 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
422 * NEWS: Initial 3.0 announcement draft
423 * README: Expand acknowledgements of incorporated projects
424 * CONTRIBUTORS: Further document Marcus Pearce contributions
426 23 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
427 * sql/oodml.lisp: add DATABASE-OUTPUT-SQL-AS-TYPE method specialisation
428 to print floats with the exponent markers removed.
429 * tests/test-oodml.lisp: add tests for updating records with floats.
431 22 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
432 * db-oracle/oracle-sql.lisp: enable :OWNER :ALL in DATABASE-LIST-* for
433 CommonSQL compatibility.
434 * tests/test-init.lisp: skip test :FDDL/TABLE/6 on Oracle since
435 this column constraint syntax is not supported.
436 * tests/test-fddl.lisp: change column indexed in test :FDDL/INDEXES/2
437 from EMPLID to LAST_NAME since Oracle complains that EMPLID is already
440 17 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
441 * doc/ref-fdml.xml: document CACHE-TABLE-QUERIES.
442 * tests/test-fdml.xml: add test for CACHE-TABLE-QUERIES.
443 * doc/ref-ooddl.xml: minor changes to syntax and examples entries
445 * doc/ref-oodml.xml: add examples for OODML.
446 * sql/oodml.lisp: ensure SELECT passes on its REFRESH argument
448 * sql/metaclasses.lisp: update docstrings.
449 * tests/test-init.lisp: change :db-constraints for emplid to
450 (:not-null :unique) as a temporary test for multiple column constraints
452 * tests/test-oodml.lisp: add tests for *DB-AUTO-SYNC* and
453 return type of (SETF SLOT-VALUE-USING-CLASS).
454 * TODO, doc/TODO: remove items done.
457 16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
458 * sql/oodml.lisp: on Lispworks, use weak valued hash tables for
460 * sql/expressions.lisp: Fix SQL generation for the symbol NIL.
462 16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
463 * sql/expressions.lisp: reactivate caching of generated SQL strings.
464 Move methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY
465 here from sql/fdml.lisp. Rationalise behaviour of SQL-OUTPUT,
466 OUTPUT-SQL and DATABASE-OUTPUT-SQL.
467 * sql/fdml.lisp: remove disabled method ADD-STORAGE-CLASS. Move
468 methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY to
469 sql/expressions.lisp.
470 * sql/ooddl.lisp: replace call to DATABASE-OUTPUT-SQL in
471 DATABASE-PKEY-CONSTRAINT with call to SQL-OUTPUT.
472 * sql/generics.lisp: add docstrings.
474 15 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
476 * db-oracle/oracle-sql.lisp: Remove OpenMCL specific
477 code in favor of fixing UFFI with James Bielman's patch
479 14 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
481 * db-oracle/oracle-sql.lisp: Apply patch for OpenMCL/OSX
484 14 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
485 * README, INSTALL: update URLs. Minor updates to descriptions.
486 * tests/README: remove stuff about editing contexts.
488 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
489 * db-oracle/oracle-objects.lisp: Change *default-varchar-length* to
490 *default-string-length*
492 12 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
493 * tests/test-syntax.lisp, tests/test-fdml.lisp: add tests for escaping
495 * tests/test-fddl.lisp: add tests for column and table constraints
496 in CREATE-TABLE. Add test for OWNER keyword parameter to
497 LIST-TABLES (assuming same underlying machinery in other FDDL
499 * tests/test-init.lisp: restrict above test to postgresql and oracle.
501 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
502 * db-sqlite/sqlite-sql.lisp: Fix condition as reported by Aurelio
505 11 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
506 * sql/oodml.lisp, sql/package.lisp, doc/ref-ooddl.lisp, db-mysql/mysql-objects.lisp: Add tinyint type
508 10 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
510 * doc/*.xml: documentation additionals and fixes so
511 that docbook passes xmllint.
513 9 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
515 * sql/fdml.lisp: Apply patch from Kim Minh Kaplan
516 to change escaping of single quotes. Mild optimizations
517 for escaped string output.
518 * doc/ref-ooddl.lisp: documentation additions
519 * doc/ref-oodml.lisp: Add purpose to functions
520 * TODO: Add need to test single quote escaping
522 7 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
523 * doc/ref-ooddl.xml, doc-ref-oodml.xml: documentation additions
524 * sql/ooddl.lisp: Added SMALLINT type
525 * sql/generic-postgresql.lisp: Added INT2 as SMALLINT type
526 * db-mysql/mysql-objects.lisp: Added SMALLINT type
527 * sql/package.lisp: Export SMALLINT
528 * sql/expressions.lisp: Add MYSQL's UNSIGNED and ZEROFILL as
531 6 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
532 * sql/expressions.lisp: add AUTO-INCREMENT and UNIQUE to the
533 recognised column constraints for CREATE-TABLE and the :DB-CONSTRAINTS
534 View Class slot option.
535 * sql/ooddl.lisp: fix bug preventing the :DB-CONSTRAINTS View Class
536 slot option accepting a list of constraints [reported by Travis Cross].
537 * doc/ref-fddl.xml: add some examples of specifying column and
538 table constraints to the documentation for CREATE-TABLE.
539 * TODO: add note about adding tests for table/column constraints. Add
540 optimisation note about using cached attribute types in insert/update
543 3 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
544 * doc/appendix.xml: add notes about idiosyncrasies/unsupported
545 features and so on the documentation for each backend.
546 * doc/TODO: remove items done.
547 * doc/ref-transaction.xml: add note in introduction about
548 autocommit mode as a difference from CommonSQL.
549 * doc/ref-syntax.xml: add notes about SQL syntax state functions
550 being macros in CLSQL. Add note about SQL operators which are
553 2 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
554 * Version 2.11.12 released
555 * doc/ref-recording.xml: document SQL I/O recording.
556 * doc/ref-prepared.xml: new file for documenting prepared statements.
557 * doc/clsql.xml: comment out include for large object and CLSQL-SYS
559 * doc/ref-conditions.xml: complete documentation of condition system.
560 * doc/global-index.xml: add symbols from condition system and remove
561 those from LOB and prepared statement APIs.
562 * doc/ref-fdml.xml: complete documentation of FDML.
563 * doc/glossary.xml: add View Class.
564 * doc/TODO: remove items done.
565 * sql/conditions.lisp: make SQL-CONDITION a parent of SQL-ERROR.
566 * sql/package.lisp: remove FOR-EACH-ROW from exports list. Export
567 additional slot accessors for condition classes.
569 1 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
570 * doc/ref-ooddl.lisp: Add documentation
571 * doc/ooddl.lisp: Move *DEFAULT-VARCHAR-LENGTH* from oodml.lisp
572 and rename to *DEFAULT-STRING-LENGTH*. Add docstring.
573 * doc/oodml.lisp: Rename references to new name of
574 *DEFAULT-STRING-LENGTH*
576 1 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
577 * doc/ref-transaction.xml: document transaction handling.
578 * sql/transaction.lisp: ensure that COMMIT, ROLLBACK and
579 START-TRANSACTION return NIL as per the CommonSQL spec. Modify
580 ADD-TRANSACTION-{ROLLBACK|COMMIT}-HOOK such that a database is
581 passed as a keyword argument defaulting to *DEFAULT-DATABASE*.
584 30 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
585 * doc/ref-fdml.xml: document the FDML.
586 * doc/ref-fddl.xml: move documentation for TRUNCATE-DATABASE here.
587 * sql/ooddl.lisp: moved *default-varchar-length* to here from
588 oodml.lisp and renamed to *default-string-length*
590 23 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
591 * sql/oodml.lisp: Add keyword :transactions to def-view-from-class
592 to allow specifying transactionless table creation
593 * doc/ref-oodml.lisp: Add new keyword to signature of
596 18 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
598 * sql/expressions.lisp: when removing duplicate table identifiers
599 in the FROM clause of a query, check both table name and alias
601 * sql/fdml.lisp: remove DESCRIBE-TABLE.
602 * sql/db-interface.lisp: remove generics DESCRIBE-TABLE and
603 DATABASE-DESCRIBE-TABLE.
604 * sql/package.lisp: remove DESCRIBE-TABLE, DATABASE-DESCRIBE-TABLE
605 and LIST-TABLE-INDEXES.
606 * sql/generic-postgresql.lisp: add reader conditional #+nil for
607 DATABASE-DESCRIBE-TABLE and comment about its uses for
608 re-implementing LIST-ATTRIBUTE-TYPES with a single SQL query
609 returning type info for all attributes.
610 Fix DATABASE-SEQUENCE-LAST.
611 * sql/fddl.lisp: remove LIST-TABLE-INDEXES and redefine
612 LIST-INDEXES with additional keyword parameter :ON.
613 * tests/test-fddl.lisp: replace LIST-TABLE-INDEXES in :fddl/index/3
614 with LIST-INDEXES (with :ON parameter).
615 * doc/global-index.xml: remove DESCRIBE-TABLE and LIST-TABLE-INDEXES.
616 * doc/ref-connect.xml: minor tidying.
617 * doc/ref-fddl.xml: document the FDDL.
618 * doc/TODO: removed items done. Moved note about transaction handling
620 * TODO: move note about transaction handling to doc/TODO. Added
621 optimization note about LIST-ATTRIBUTE-TYPES and LIST-INDEXES.
623 13 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
625 * sql/syntax.lisp: updated docstrings.
626 * sql/package.lisp: exported DATABASE-NAME-FROM-SPEC from CLSQL
628 * sql/database.lisp: add docstrings for CREATE-DATABASE,
629 DESTROY-DATABASE, TRUNCATE-DATABASE and LIST-DATABASES. Replace
630 CLSQL-GENERIC-ERROR signalled in RECONNECT with SQL-CONNECTION-ERROR.
631 * doc/ref-syntax.xml, doc/global-index.xml: minor tidying.
632 * doc/ref-connect.xml: document connection/initialisation.
633 * doc/ref-fdml.xml: move TRUNCATE-DATABASE reference entry here.
634 * doc/TODO: remove items done.
635 * Makefile: add db-oracle to to SUBDIRS.
637 13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
638 * sql/oodml.lisp: Add new serialization functions:
639 WRITE-INSTANCE-TO-STREAM and READ-INSTANCE-FROM-STREAM
640 * sql/expressions.lisp: Avoid duplicate FROM names when selecting
641 from a table that has more than one primary index.
642 * sql/conditions.lisp: Fix printing of closed-database error
644 13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
646 * sql/conditions.lisp: Set initial slot value for message in SQL-WARNING
647 * sql/transactions.lisp: Correctly set slots of SQL-WARNING
649 12 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
650 * sql/package.lisp: export DATABASE-TYPE from CLSQL and subclasses
651 of SQL-EXPRESSION from CLSQL-SYS.
652 * sql/syntax.lisp: make error signalled in SQL-OPERATION an
653 SQL-USER-ERROR. Make SQL-OPERATOR return just one value.
654 * doc/Makefile: added Mandrake linux.
655 * doc/catalog-redhat.xml, doc/catalog-mandrake.xml: new files.
656 * doc/appendix.xml: fixed little typo (adsf).
657 * doc/glossary.xml: removed closed-database and note about
658 sql-expression, added some entries.
659 * doc/ref-syntax.xml: documented the symbolic SQL syntax.
661 10 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
663 * db-mysql/mysql-loader.lisp: Remove load of unnecessary zlib library
664 * multiple: Add generalized-boolean type as requested by
666 * TODO: Added need for test of generalized-boolean
668 9 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
669 * Version 2.11.7 released
670 * uffi/clsql-uffi-loader.lisp: Apply patch from Edi Weitz
671 for loading with clc-register-user-package. Remove personal
672 directory from path lisp.
673 * db-mysql/mysql-loader.lisp: Similar changes
675 8 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
676 * Version 2.11.6 released
677 * sql/oodml.lisp: Commit patch from Edi Weitz
678 to fix symbol writing/reading
679 * TODO: Add need for symbol slot test
681 7 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
682 * sql/package.lisp: remove duplicate export of
683 *CACHE-TABLE-QUERIES-DEFAULT*.
684 * doc/ref-*.xml, doc/global-index.xml: new files documenting
685 the CommonSQL compatible api.
686 * tests/test-fdml.lisp: modified the test :fdml/transaction/3 to
687 reflect changes in return values of WITH-TRANSACTION.
689 04 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
690 * tests/README: Fix filename [reported by Bill Clementson]
691 * sql/transactions.lisp: Apply return value patch from
692 Edi Weitz for WITH-TRANSACTION
693 * tests/README: Remove ptester package requirement (as noted
696 03 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
697 * Version 2.11.5 released
698 * examples/clsql-tutorial.lisp: Remove obsolete :nulls-ok attribute,
699 Select connection-spec based on connection type. Bugs reported by
701 * uffi/uffi.dll, uffi/uffi.lib: Recompile with Visual Studio 2003
702 * db-mysql/mysql-loader.lisp: Update check for zlibwapi library
703 name on Windows, add \bin\ directory to search path
705 31 May 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
706 * db-odbc/odbc-sql.lisp: DB-TYPE replaced with DATABASE-TYPE in
708 * sql/operations.lisp: substr now generates SUBSTR for use on
709 Oracle; added a new operator SUBSTRING for use elsewhere. minus
710 now generates MINUS for use on Oracle. Nvl signals an error if
711 not called with exactly 2 arguments. Add concat function for use
712 instead of the || operator on MySQL and Oracle.
713 * sql/syntax.lisp: changed internal symbol for the || operator to
715 * sql/expressions.lisp: removed redundant and unused functions
716 GENERATE-SQL (cf. SQL-OUTPUT) and DATABASE-CONSTRAINT-DESCRIPTION
717 (cf. MAKE-CONSTRAINTS-DESCRIPTION).
718 * sql/generics.lisp: removed generic function for
719 DATABASE-CONSTRAINT-DESCRIPTION (see above).
720 * tests/test-syntax.lisp: modified/added tests according to changes
721 in sql/operations.lisp.
722 * tests/test-fdml.lisp: changed SUBSTR to SUBSTRING in test
724 * sql/package.lisp: added the operators SQL-SUBSTRING, SQL-CONCAT-OP
725 and SQL-USERENV to the shared exports list. Removed
726 ROLLBACK-TRANSACTION, COMMIT-TRANSACTION, DATABASE-START-TRANSACTION,
727 DATABASE-ABORT-TRANSACTION, DATABASE-COMMIT-TRANSACTION,
728 TRANSACTION-LEVEL, TRANSACTION, RECORD-SQL-COMMAND and
729 RECORD-SQL-RESULT from shared exports list.
731 30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
732 * db-postgresql/postgresl-sql.lisp: Avoid computing
733 result-types lisp when nil result-types. Return only
734 one value when field-types nil.
735 * db-mysql/mysql-sql.lisp: Simple queries now
736 working with prepared statements.
738 30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
739 * Version 2.11.4: MySQL 4.1 now passes all tests
740 * sql/package.lisp: Add API for prepared statments.
741 * sql/fdml.lisp: Change implicit flatp processing
742 for string map-query for greater CommonSQL conformance.
743 Add high-high API for prepared statements.
744 * tests/test-basic.lisp: Add test for map-query and
746 * sql/transactions.lisp: Change name/semantics of
747 autocommit to set-autocommit.
748 * sql/generic-postgresql.lisp: Add support for
750 * tests/test-internal.lisp: New file
751 * sql/odbc-api.lisp: Update to using ODBC V3 protocol
752 * clsql-mysql.asd, clsql-uffi.asd: Remove check and Common Lisp
753 Controller invocation.
754 * db-mysql/mysql-api.lisp: Add support for MySQL 4.1 field structure
755 * sql/expressions.lisp: Avoid emitting double parenthesis when a
756 function contains a subselect.
758 27 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
760 * sql/ooddl.lisp: Commit patch from Edi Weitz fixing return
761 type (setf slot-value-using-class)
762 * TODO: add not that need a test case for the above fix
763 * db-sqlite: Remove clisp support since clisp can not run CLSQL
765 * db-oracle/oracle-sql.lisp: By default, use OCIEnvCreate as
766 introduced in Oracle8. Leave older code selectable by a reader macro
767 for Oracle7 and prior. Avoid use of OCIServerAttach since CLSQL
768 uses OCILogon and does not the more complex session management.
770 26 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
771 * sql/oodml.lisp: Commit universal-time typo patch from Edi Weitz
772 * test/test-init.lisp: Add universal-time slot to person.
773 * test/test-fddl.lisp: Add tests of universal-time slot
774 * test/test-ooddl.lisp: Test universal-time slot in an object
775 * TODO: Remove need for universal-time test
776 * debian/rules, debian/control: Add cl-sql-oracle binary package
777 * doc/appendix.xml: Add Oracle backend information
778 * db-oracle/oracle-objects.lisp: Add database-get-type-specifier for
779 universal-time. Convert BIGINT CLSQL type to CHAR SQL type
780 * db-mysql/mysql-sql.lisp: Fix condition name to sql-connection-error
781 * doc/ref-clsql.xml: Renamed from ref_clsql.xml. Change the documentation
782 for map-query to reflect changed in arguments to be CommonSQL compatible.
783 Updated old clsql conditions to new CommonSQL compatible conditions.
785 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
786 * sql/oodml.lisp: (string n) now produces a CHAR field. Add new VARCHAR
787 type. Added *default-varchar-length* rather than previous hard-coded
788 varchar length. Remove 'simple-string and 'simple-base-string since they
789 are subtypes of 'string.
790 * db-oracle/oracle-sql.lisp: Use *default-varchar-length* rather than
791 local hard-coded value.
792 * sql/metaclasses.lisp: Convert specified type VARCHAR and (VARCHAR n) to Lisp
793 type string. Convert specified-type (CHAR n) to string. Convert specified-type
794 CHAR to lisp type character.
795 * sql/generic-postgresql.lisp: (string n) => (CHAR n)
796 * sql/operations.lisp: Add userenv
797 * doc/TODO: Add AUTOCOMMIT. Remove need for large table and bigint
799 * sql/oracle-sql.lisp: Add 64-bit bigint direct conversion
800 * uffi/clsql-uffi.lisp: Handle signed 64-bit integers
801 * test/test-init.lisp: Add large table with bigint slot
803 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
804 * Version 2.11.1 released: Much simpler Oracle client library loading.
805 Now uses ORACLE_HOME environmental variable as well as tests default
806 path for Oracle Instant Client.
808 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
809 * Version 2.11.0 released: Full Oracle support. All tests pass
810 * db-oracle/oracle-sql.lisp: Add declaration so that SBCL runs efficiently.
811 * tests/test-init.lisp: capitalize odbc backend name in banner
812 * CONTRIBUTORS: Add note about Marcus' excellent work
813 * sql/oodml.lisp: Removed old stub function
814 * clsql.asd: Use module names in current package rather than keyword package
815 * db-oracle/oracle-sql.lisp: Don't trim trailing spaces. Prevent interrupts
816 in setting sequence position. Make autocommits more efficient.
817 * tests/test-init.lisp: Skip 2 tests on Oracle which have unsupported syntax
818 * sql/oodml.lisp: Get rid of undocumented raw-string type. CommonSQL
819 strings are raw (non-trimmed trailing whitespace). Add database-get-type-specifier
820 and read-sql-value for NUMBER and CHAR.
821 * sql/base-classes.lisp: Add autocommit slot
822 * sql/transaction.lisp: Added autocommit processing, mild cleaning.
823 * doc/intro.xml: Add Oracle
825 24 May 2004: Marcus Pearce (m.t.pearce@city.ac.uk)
826 * db-postgresql-socket/postgresql-socket-sql.lisp: replace
827 CLSQL-SIMPLE-WARNING with SQL-WARNING.
828 * db-sqlite/sqlite-sql.lisp: replace CLSQL-SIMPLE-WARNING with
830 * db-aodbc/aodbc-sql.lisp: replace CLSQL-ERROR with SQL-ERROR.
831 * clsql.asd: reworked module structure in package definition and
832 file names to better reflect component functionality.
833 * sql/package.lisp: added SQL-FATAL-ERROR and SQL-TIMEOUT-ERROR to
834 exports list. Removed duplicate and obsolete exports. Exported
835 remaining SQL operations: SQL-SOME, SQL-<>, SQL-BETWEEN, SQL-DISTINCT,
836 SQL-NVL and SQL-FUNCTION. Organised exports by functionality/file and
837 according to whether they are specified by CommonSQL or CLSQL
839 * sql/transaction.lisp: replace CLSQL-SIMPLE-WARNING with
841 * sql/generics.lisp: moved generics for QUERY and EXECUTE-COMMAND
842 here from basic-sql.lisp.
843 * sql/expressions.lisp: NEW FILE: renamed from classes.lisp (deleted).
844 * sql/fddl.lisp: NEW FILE: renamed from table.lisp (deleted).
845 * sql/fdml.lisp: NEW FILE: merger of basic-sql.lisp and sql.lisp
847 * sql/ooddl.lisp: NEW FILE: ooddl from objects.lisp (deleted).
848 * sql/oodml.lisp: NEW FILE: oodml from objects.lisp (deleted).
850 23 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
851 * Version 2.10.22 released
852 * sql/kmr-mop.lisp, sql/objects.lisp: Since SBCL is the only implementation that
853 has reversed class slots, change the default for ordered-class-slots so that slots
854 are now in the same order an in the def-view-class.
855 * sql/sql.lisp: Honor case of string table identifier to INSERT-RECORDS
856 * test/test-fddl.lisp: Add two tests for mixed case names
857 * db-oracle/oracle-sql.lisp: Add missing database qualifier. Return NUMBER (double)
858 for computed fields, this will require some adjustment to the test suite which
859 in many cases expects integers.
860 * test/test-fdml.lisp: Accomodate that Oracle returns doubles for computed columns
862 22 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
863 * Version 2.10.21 released
864 * sql/sequences.lisp: Move generic sequence functions here from db-sqlite,
865 db-odbc, and db-aodbc.
866 * sql/*.lisp: Add db-type parameter to generic functions READ-SQL-VALUE,
867 DATABASE-GET-TYPE-SPECIFIER, and OUTPUT-SQL-VALUE-AS-TYPE. Update methods to use these.
868 * sql/generic-postgresql.lisp, sql/generic-odbc.lisp: New files
869 * db-odbc/odbc-sql.lisp, db-aodbc/aodbc-sql.lisp: Move common code to
870 sql/generic-odbc.lisp
871 * db-postgresql/postgresql-sql.lisp, db-postgresql-socket/postgresql-socket-sql.lisp:
872 Move common code to sql/generic-postgresql.lisp
873 * sql/classes.lisp: honor case of string tables when outputting queries
874 * sql/objects.lisp: Add database type to default database-get-type-specifier method
875 * sql/sql.lisp: Add database type to default database-abort-transaction method
876 * db-mysql/mysql-objects.lisp: New file
877 * sql/objects.lisp: Move MySQL specific code to mysql-objects.lisp
878 * sql/utils.lisp: Add GETENV function which will be used to get ORACLE_HOME
880 * test/test-fdml.lisp: String table names are now case sensitive, so convert to
881 default db case for FDML/SELECT/25
883 22 May 2004 Kevin Rosenberg
884 * Version 2.10.20 released: Oracle backend now fails 6 out of 200 tests
885 * TODO: Added 2 variances from CommonSQL. Add tests for owner phrases
886 and string identifiers with non-default case
887 * sql/table.lisp: Don't convert string table name to a symbol.
888 * sql/classes.lisp: Honor case of string identifiers
889 * sql/sql.lisp: Ensure recyclebin is purged for Oracle in
891 * db-oracle/oracle-sql.lisp: Add sequence functions, fix use of
892 of owner phrases. Obtain server and client versions.
893 * db-oracle/oracle-objects.lisp: Fix type specifiers
894 * tests/test-fddl.lisp: Allow :varchar2 and :number as data types
895 * tests/test-init.lisp: Properly get username from Oracle connection-spec
897 22 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
898 * sql/generics.lisp: reworked docstrings. Remove generics for
899 ADD-TO-RELATION and REMOVE-FROM-RELATION.
900 * sql/objects.lisp: reworked docstrings. Changed UPDATE-OBJECT-JOINS
901 to UPDATE-OBJECTS-JOINS for CommonSQL compatibility.
902 * sql/package.lisp: Changed UPDATE-OBJECT-JOINS to UPDATE-OBJECTS-JOINS
903 for CommonSQL compatibility. Remove ADD-TO-RELATION and
904 REMOVE-FROM-RELATION.
905 * tests/test-oodml.lisp: Changed UPDATE-OBJECT-JOINS to
906 UPDATE-OBJECTS-JOINS for CommonSQL compatibility.
907 * doc/TODO: added notes about extra slot options to DEF-VIEW-CLASS.
908 * sql/conditions.lisp: add documentation for conditions. Add
909 SQL-TIMEOUT-ERROR and SQL-FATAL-ERROR for CommonSQL compatibility.
911 21 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
912 * sql/basic-sql.lisp: reworked docstrings.
913 * sql/transactions.lisp: reworked docstrings.
914 * sql/sql.lisp: reworked docstrings.
915 * sql/initialize.lisp: reworked docstrings. INITIALIZE-DATABASE-TYPE
916 sets *DEFAULT-DATABASE-TYPE* for CommonSQL compatibility.
917 * sql/database.lisp: reworked docstrings.
918 * doc/TODO: added notes about START-TRANSACTION and IN-TRANSACTION-P
919 and FDML extensions and database extensions.
921 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
922 * db-oracle/oracle-sql: Use clsql-specific error conditions. Use owner keyword.
923 * db-oracle/make9.sh: add makefile for building with Oracle 9 client
925 * sql/table.lisp: Add logic for dealing with Oracle 10g vs. previous
926 Oracle versions with the PURGE option required for drop table. This needs
927 to be converted to a generic function and moved to db-oracle/oracle-sql.lisp
929 20 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
930 * sql/classes.lisp: remove unused PARAMS slot in SQL-IDENT-ATTRIBUTE.
931 * sql/syntax.lisp: remove unused PARAMS keyword arg to SQL-EXPRESSION.
932 * sql/table.lisp: reworked docstrings.
933 * sql/objects.lisp: moved *default-update-objects-max-len* here from
935 * doc/TODO: notes about :if-does-not-exist arg to DROP-TABLE,
936 DROP-VIEW and DROP-INDEX and the use of the :transactions and
937 :constraints keyword args to CREATE-TABLE.
938 * sql/classes.lisp: the DESCRIPTION argument to CREATE-TABLE is now
939 CommonSQL compatible with respect to column constraints.
941 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
942 * sql/oracle-sql.lisp: Now compiles and runs on SBCL.
943 Requires UFFI 1.5.0 or higher
945 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
947 * sql/conditions.lisp: Fix cerror
949 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
950 * Version 2.10.18 released: New condition hierarchy to be compatible
951 with CommonSQL -- not backward compatible with previous CLSQL.
952 * sql/db-interface.lisp: Add more default methods
953 * sql/objects.lisp: Add explicit table name to order-by parameters
954 in find-all when only one table to avoid selecting a duplicate row.
955 Fix error in FIND-ALL when using :order-by such as (([foo] :asc))
956 as previous logic was adding two fields (foo asc) to SELECT query.
957 Make :result-types :auto be the default for object selections.
958 Properly handle caching key when using multiple order-by with asc/desc
960 * db-oracle/*.lisp: Much improvements, now passes 90% of test suite
962 19 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
963 * sql/recording.lisp: reworked docstrings.
964 * sql/syntax.lisp: reworked docstrings.
965 * doc/TODO: added notes about extensions to SQL-RECORDING-P and the
966 SQL syntax state functions being macros.
968 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
969 * sql/package.lisp: Export initialize-database-type and
970 *initialize-database-types* from CLSQL package.
971 * sql/conditions.lisp: Add new CommonSQL compatible conditions,
972 remove old CLSQL conditions.
973 * sql/loop-extensions.lisp: Make errors of type sql-user-error
974 * */*.lisp: Convert to from old to new conditions
976 18 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
977 * sql/table.lisp: Add PURGE to drop command for oracle 10g backend.
978 To handle this difference, will need to add a new database-drop-table
980 * db-oracle/oracle-sql.lisp: Move server-version and
981 major-version-number to database object to allow multiple connections
982 to Oracle servers of different versions.
984 18 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
985 * TODO: moved notes about backends to doc/TODO.
986 * doc/TODO: added notes about backends and select extensions.
987 * sql/base-classes.lisp: remove obsolete schema slot in database
990 16 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
991 * db-oracle/oracle-api: Add OCIServerVersion
992 * db-oracle/oracle-sql: Query and store server version on connect
993 * sql/db-interface.lisp: Add new db-type-has-bigint? generic
994 function to handle OCI's lack of bigint support
995 * test/test-basic.lisp: Separate bigint testing
996 * test/test-utils.lisp: Add oracle to specs and list of backends
998 * test/test-fdml.lisp: Added FDML/SELECT/34 to test
999 run-time instantiation of variables in reader macros.
1000 * TODO: Remove item already complete. Add note about
1003 16 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1004 * sql/syntax.lisp: added condition to the reader macro to treat [*]
1005 as a column identifier (rather than an operation) for CommonSQL
1007 * tests/test-fdml.lisp: add tests for ORDER-BY and SET-OPERATION
1008 keword args to SELECT, [*] as column identifier, new MAP-QUERY
1009 behaviour and the ANY and ALL operators in subqueries.
1010 * tests/test-init.lisp: add set-operation and subquery tests to
1011 appropriate skip lists.
1012 * sql/objects.lisp: remove redundant and non CommonSQL compatible
1013 ORDER-BY-DESCENDING keyword argument for SELECT.
1014 * sql/classes.lisp: remove redundant and non CommonSQL compatible
1015 ORDER-BY-DESCENDING keyword argument for SELECT.
1016 * tests/test-oodml.lisp: add test for ORDER-BY keyword to SELECT
1017 with object queries.
1019 15 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1020 * sql/db-interface.lisp: Add new db-type-has-union?
1021 since Mysql 3.23 does not support unions.
1022 * sql/test-init.lisp: Don't try union tests on database
1023 backends which do not support it.
1024 * db-oracle/*.lisp: initial port to UFFI
1025 * sql/objects.lisp: implement UPDATE-OBJECT-JOINS,
1026 implement REFRESH for SELECT.
1027 * tests/test-oodml.lisp: Add tests for deferred retrieval,
1028 caching, refresh, and update-object-joins
1029 * tests/test-init.lisp: Add deferred-employee-address class
1031 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1032 * sql/operations.lisp: make MINUS operator a synonym for EXCEPT. Add
1033 COALESCE operator and make NVL a synonym for this. Make ANY, SOME,
1034 ALL and EXISTS generate function expressions so they output the
1036 * sql/classes.lisp: SELECT now generates appropriate SQL when
1037 passed the SET-OPERATION and ALL keyword arguments.
1038 * sql/classes.lisp: the ORDER-BY keyword argument to SELECT now
1039 accepts ordering constraints as pairs of the form (column direction)
1040 where direction may be :ASC or :DESC.
1041 * tests/test-syntax.lisp: added tests for MINUS and COALESCE/NVL.
1042 Correct tests for ANY, SOME, ALL and EXISTS.
1043 * tests/test-fdml.lisp: added test for COALESCE.
1044 * sql/sql.lisp: MAP-QUERY now applies FUNCTION to QUERY-EXPRESSION
1045 using funcall unless QUERY-EXPRESSION returns one column and its
1046 FLATP slot is not nil in which case apply is used.
1047 * tests/test-basic.lisp: modified calls to MAP-QUERY to reflect the
1049 * TODO: remove items done.
1050 * db-postgresql/postgresql-sql.lisp: no need to reverse results in
1051 DATABASE-LIST-ATTRIBUTES.
1052 * db-postgresql-socket/postgresql-socket-sql.lisp: no need to reverse
1053 results in DATABASE-LIST-ATTRIBUTES.
1055 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1056 * sql/classes.lisp: SELECT now accepts table identifiers as strings
1057 for CommonSQL compliance. Add support for qualified sql identifiers
1058 with aliased table names.
1059 * tests/test-fdml.lisp: added tests for table identifiers as strings
1060 in SELECT and for aliased definitions.
1061 * tests/test-syntax.lisp: added tests for alias definitions.
1063 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1064 * sql/sql.lisp: PRINT-QUERY now calls QUERY with result-types and
1065 field-names set to nil.
1066 * sql/sql.lisp: PRINT-QUERY now computes column sizes correctly
1067 with null attribute values.
1068 * sql/operations.lisp: modify SQL concatenation operator to accept
1069 unescaped || symbol.
1070 * sql/syntax.lisp: modify sql reader macro function to accept
1071 unescaped sql concatenation operator.
1072 * tests/test-fdml.lisp: unescape sql concatenation operator.
1073 * tests/test-syntax.lisp: unescape sql concatenation operator.
1074 * TODO: remove items done. Add notes about SQLITE/MYSQL backends.
1075 Note to add test for universal-time. Note about difference from
1076 CommonSQL in transaction handling.
1078 13 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1079 * tests/test-init.lisp: Add deferred-employee-address
1081 * tests/test-oodml.lisp: Add deferred retrieval testgs
1083 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1085 * LATEST-TEST-RESULTS: Run on all platforms, add AMD64
1086 * sql/sql.lisp: Add FOR-EACH-ROW macro from clsql-classic/sql.lisp
1087 * db-sqlite/sqlite-uffi-api.lisp: Fix row-pointer type
1088 * *: Fix minor style warnings
1089 * clsql-classic: Remove system and subdirectory
1090 * clsql-base: Remove system and subdirectory and
1091 fold into clsql system
1092 * doc/intro.xml: Remove reference to old clsql-base. Add x86_64
1093 as supported platform.
1095 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1096 * Version 2.10.16: CLSQL now fully supports AllegroCL AMD64
1097 * db-odbc/odbc-api.lisp: work around return-type bug [spr28889] in
1098 Allegro 7.0beta AMD64
1099 * db-odbc/*.lisp: Add a layer of indirection to foreign-type
1100 of ODBC longs since this type can vary on 64-bit platforms depending
1101 upon the compilation options of unixODBC.
1102 * db-mysql/mysql-api.lisp: Fix int vs. long slots in foreign
1103 structures found by testing with AllegroCL 7.0b AMD64.
1104 * db-*/*-loader.lisp: Load 64-bit libraries on 64-bit platorms
1105 * sql/objects.lisp: Simple implementation of UPDATE-OBJECT-JOINS.
1106 Initial caching support for SELECT
1107 * tests/test-oodml.lisp: Avoid using cache when testing select.
1108 * sql/kmr-mop.lisp: Explicitly check slot order and
1109 store as a cl:*feature*
1110 * sql/recording.lisp: Remove additional types to
1111 increase CommonSQL conformance.
1112 * tests/test-init.lisp: Change a :column attribute
1113 to test symbols as value
1114 * sql/relations.lisp: Remove functions since they don't support
1115 many to many relationships.
1116 * examples/clsql-tutorial.lisp, doc/csql.lisp: Remove use
1117 of add-to-relations function and replace with explicit field settings.
1118 * base/classes.lisp: Remove obsolute query-stream. Add record-caches slot.
1120 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1122 * LATEST-TEST-RESULTS: results with current version
1123 * sql/kmr-mop.lisp: Make CMUCL reader macros specific for cmu18
1124 since cmu19 has opposite order of class slots.
1125 * sql/objects.lisp: Fix (setf slot-value-using-class) for Lispworks
1126 * tests/test-fdml.lisp: Renumber SELECT tests to avoid overwriting
1128 * tests/test-init.lisp: Check test-database-underlying-type for
1131 8 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1132 * sql/operations.lisp: complete remaining operations for the sql
1133 syntax: SUBSTR, SOME, ORDER-BY, GROUP-BY, NULL, DISTINCT, EXCEPT,
1134 UNION, INTERSECT, BETWEEN.
1135 * sql/classes.lisp: add new classes: SQL-BETWEEN-EXPRESSION,
1136 SQL-QUERY-MODIFIER-EXPRESSION and SQL-SET-EXPRESSION.
1137 * tests/test-syntax.lisp: add tests for new operations.
1138 * tests/test-fdml.lisp: add tests for queries based on new operations.
1139 * tests/test-init.lisp: add select/20 to tests skipped for sqlite and
1140 select/20, query/5, query/7 and query/8 to tests skipped by mysql.
1141 * TODO: removed entries done.
1143 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1144 * tests/benchmarks.lisp: Add immediate vs. deferred
1147 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1148 * Version 2.10.13: Now works on openmcl 0.14.2
1149 * sql/objects.lisp: Add :retrieval :immediate for
1151 * tests/test-init.lisp: Add non-index fields for testing
1152 join class employee-addresss
1153 * test/test-oodml.lisp: Add tests for retrieval immediate
1154 * sql/metaclasses.lisp: Handle differences in direct-slot-definition
1155 values which are now listifed by openmcl 14.2.
1156 * sql/objects.lisp: more framework for supporing immediate retrieval
1158 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1159 * docs/intro.xml: Upload location of a README file
1160 * sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
1161 changing the type-specifier. Use a lisp type of (OR NULL FOO)
1162 for a specified-type of FOO unless :db-constraints :not-null.
1163 No need to specialize finalize-inheritance for openmcl.
1164 * tests/test-*.lisp: Rename fields so that joins occur on
1165 fields with different names. This ensures that join code is
1166 selecting the proper name.
1167 * test/test-init.lisp: Add :base-table for employee-address
1168 view class for testing.
1169 * sql/objects.lisp: Use view-table rather than name of table
1170 in a number of places to fix errors noted with using :base-table.
1172 6 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1173 * sql/objects.lisp: replace *update-records-on-make-instance* with
1174 *db-auto-sync* which also controls both automatic creation of
1175 new records on creation of new instance and updating of record
1176 fields on setting of instance slots (as suggested by Edi Weitz).
1177 * tests/test-init.lisp: replace *update-records-on-make-instance*
1178 with *db-auto-sync*.
1179 * sql/package.lisp: replace *update-records-on-make-instance*
1180 with *db-auto-sync*.
1181 * TODO: replace *update-records-on-make-instance* with *db-auto-sync*.
1182 * sql/objects.lisp: remove redundant rebindings of *db-initializing*
1183 and *default-database* in FIND-ALL.
1184 * sql/package.lisp: import time functions from CLSQL-BASE.
1185 * tests/test-time.lisp: replace CLSQl-BASE package qualifier with CLSQL.
1186 * tests/test-fdml.lisp: replace CLSQl-BASE package qualifier with CLSQL.
1187 * tests/test-init.lisp: replace CLSQl-BASE package qualifier with CLSQL.
1188 * tests/test-ooddl.lisp: replace CLSQl-BASE package qualifier with
1191 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1192 * sql/classes.lisp: Add SQL-OBJECT-QUERY type. Have [select 'class]
1193 now return a sql-object-query type rather than directly performing a query.
1194 This improves CommonSQL conformance.
1195 * sql/sql.lisp: Add new QUERY method for SQL-OBJECT-QUERY. Move
1196 from basic/basic-sql.lisp the DO-QUERY and MAP-QUERY since they now
1197 depend on sql-object-query-type.
1198 * sql/loop-extensions.lisp: Move from base package
1199 * classic/package.lisp: remove references to map-query and do-query
1201 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1202 * TODO: New section on optimizations, especially optimizing JOINs.
1203 * sql/objects.lisp: Have :target-slot return of list of lists rather
1204 than a list of cons pairs to be conformant with CommonSQL.
1205 Make :target-slot much more efficient by using a SQL inner join
1206 statement and just requiring one SQL query. Add :retrieval :deferrred
1207 to target-slot joins. Add placeholder for update-objects-join.
1208 * sql/classes.lisp: Add :inner-join and :on slots to sql-query class
1209 and process them for query output-sql.
1211 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1213 * base/basic-sql.lisp: Avoid multiple evaluation
1214 of query-expression in DO-QUERY
1215 * sql/objects.lisp: Make SELECT a normal function.
1216 SELECT now accepts type-modified database identifiers, such as
1217 [foo :string] which means that the values in column foo are returned
1218 as Lisp strings. Add new *update-records-on-make-instance* special
1219 variable controlling automatic creation of new instances. Add missing
1220 RESULT-TYPES keyword to FIND-ALL. Add :target-slot support.
1221 * sql/packages.lisp: Export *update-records-on-make-instance*
1222 * test/test-oodml.lisp: Add tests for :target-slot and many-to-many
1224 * test/test-fdml.lisp: Add tests for type-modified
1225 database identifiers.
1226 * test/test-init.lisp: Stop using add-relation since implementing
1227 many-to-many joins. Use *update-records-on-make-instance*
1228 to automatically store records on instance creation. Add many-to-many
1229 employee-address view-class.
1231 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1233 * base/loop.lisp: Add object iteration. Use :result-type
1234 :auto for result-set. Remove
1235 duplicate (and non-correct) code for non-list variables by
1236 simply making an atom variable into a list.
1237 * sql/package.lisp: Remove unnecessary clsql-sys package
1238 and replace it with clsql.
1239 * sql/metaclasses.lisp: Properly store specified-type from
1240 direct-slot-definition and then store translated type in
1241 effective-slot-definition
1242 * sql/classes.lisp: Don't output type in sql-output
1243 for SQL-IDENT-ATTRIBUTE. This is in preparation for supporting
1244 [foo :integer] as fields in SELECT.
1245 * sql/query.lisp: Set default for :result-types to :auto in
1247 * sql/objects.lisp: Use specified-type when invocating
1248 database-get-type-specifier. def-view-class macro now returns
1250 * base/basic-sql.lisp: Make :AUTO the default value for
1251 :RESULT-TYPES for MAP-QUERY and DO-QUERY.
1252 * sql/objects.lisp: Add bigint type
1253 * test/tests-basic.lisp: Add tests for :result-types for
1254 MAP-QUERY and DO-QUERY
1255 * test/test-fdml.lisp: Add test for result-types in LOOP
1256 and also using single symbol rather than a list for variables.
1257 Add test that default :result-types is auto for FDML QUERY.
1258 * test/test-syntax.lisp: Don't expect TYPE in the SQL-OUTPUT
1259 of SQL-IDENT-ATTRIBUTE.
1260 * test/test-oodml.lisp: Enable OO loop iteration test,
1261 modify it so it doesn't depend on boolean where.
1263 4 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1265 * sql/objects.lisp: added derived type specifier for universal time.
1266 * sql/package.lisp: added #:universal-time to clsql-sys exports.
1267 * tests/test-oodml.lisp: added test for translation of boolean slots
1268 in SELECT with object queries.
1270 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1271 * db-odbc/odbc-api.lisp: Fix changing nil to "NIL"
1272 for odbc/postgresql backend.
1273 * db-odbc/odbc-sql.lisp: Fix ATTRIBUTE-TYPE so that
1274 it can handle NIL values from the ODBC driver
1275 * tests/benchmarks.lisp: New file with initial
1277 * sql/relations.lisp: fix to add subclassing support,
1278 minor optimizations [Edi Weitz]
1280 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1282 * base/conditions.lisp: Add *backend-warning-behavior*
1284 * db-postgresql-socket/postgresql-socket-sql.lisp:
1285 Honor value of *backend-warning-behavior*
1286 * tests/test-fdml.lisp: Remove test of raw boolean value
1287 since different backends handle this differently. Add
1288 test for :column attribute.
1289 * tests/test-oodml.lisp: Add tests for boolean slot value
1290 and for :void-value attribute
1291 * tests/test-init.lisp: Use *backend-warning-behavior*
1292 to suppress warnings from postgresql about implicitly
1293 creating primary key in tables. Add new address table.
1295 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1297 * db-odbc/odbc-dbi.lisp: Convert TINYINT to integers when
1298 result-types is :auto
1299 * sql/objects.lisp: Properly handled writing/reading Boolean
1300 values from SQL database when retrieving objects.
1301 * test/test-fdml.lisp: Add another test for boolean results
1302 * test/utils.lisp: Fix incorrect declaration
1304 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1306 * sql/generics.lisp: add generic function for SELECT.
1307 * sql/objects.lisp: make SELECT a method specialisation.
1308 * sql/classes.lisp: MAKE-QUERY now calls SELECT if the selections
1309 referred to are View Classes.
1310 * base/basic-sql.lisp: in DO-QUERY and MAP-QUERY, if the
1311 query-expression arg evaluates to a list, then we have an object
1313 * tests/test-oodml.lisp: add tests for DO-QUERY and MAP-QUERY with
1315 * TODO: remove items done and add a todo for SELECT.
1316 * sql/objects.lisp: SELECT takes a :field-names arg to pass on to
1318 * sql/sql.lisp: add :field-names arg to QUERY.
1319 * tests/test-fdml.lisp: minor rework to use :field-names arg to
1322 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1323 * sql/objects.lisp: fix bug in FIND-ALL when SELECT called with 2
1324 or more View Classes.
1325 * sql/objects.lisp: make the :flatp argument to SELECT work with
1327 * sql/objects.lisp: make SELECT accept a :result-types argument
1328 (defaults to :auto) which is passed on to QUERY.
1329 * sql/objects.lisp: SELECT returns field-names as a second value.
1330 * tests/test-ooddl.lisp: add flatp arg to SELECT calls as appropriate.
1331 * tests/test-fdml.lisp: add flatp/result-types arguments to calls
1332 to SELECT and take only first value as appropriate.
1333 * tests/test-fdml.lisp: add two new tests for query result coercion
1334 and the field-names returned as a second value from SELECT.
1335 * tests/test-oodml.lisp: add flatp arg to SELECT calls as appropriate.
1337 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1338 * Version 2.10.6-pre1
1339 * sql/metaclasses.lisp: Add void-value slot
1340 * doc/csql.xml: Update def-view-class documentation
1341 * test/test-init.lisp: Change old :db-type to :db-kind.
1342 Remove old :nulls-ok attributes.
1343 * sql/objects.lisp: Add new universal-time and bigint
1344 types. Optimize reading of integers using parse-integer
1345 rather than read-from-string.
1346 * */*.lisp: Merge clsql-base-sys and clsql-base packages
1347 into clsql-base package
1348 * classic/sql.lisp: Move large object support into base, leaving
1349 classic without any functionality that is provided in the clsql
1351 * classic/package.lisp: Rename clsql-classic-sys package to
1352 its former nickname of clsql-classic
1354 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1355 * Version 2.10.5: SQLite backend now passes all result-types tests
1356 * clsql-sqlite.asd: Depend on clsql-uffi system
1357 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
1358 for efficiency and code reuse.
1359 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
1360 for better cross-implementation compatibility.
1362 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1364 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
1366 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
1367 bug on SBCL in result-field-names function as reported by Marcus Pearce
1368 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
1369 manifest in SBCL testing
1371 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1373 * sql/database.lisp: Conform more to CommonSQL output
1374 for STATUS command [Marcus Pearce]
1375 * sql/sqlite-sql.lisp: Rework to use result-types
1376 * sql/sqlite-api-clisp.lisp: Add compatibility layer
1377 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
1378 be cleaned up of most clisp reader conditionals
1379 * sql/test-init.lisp: Now run field type tests on sqlite
1382 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1384 * base/basic-sql.lisp: Set default value of :result-types
1385 to :auto for more CommonSQL conformance.
1386 * test/test-fdml.lisp: Add tests for numeric value of fields
1389 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1390 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
1391 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
1392 Return field names as second value for QUERY. This can be overridden
1393 for efficiency with the new keyword :FIELD-NAMES set to NIL
1394 in the QUERY invocation.
1395 * test/test-fdml.lisp: Add tests for new field-name feature
1396 * sql/metaclass.lisp: Remove old Lispworks cruft
1397 and replace it with invocation of new code in kmr-mop.lisp
1398 which actually works with Lispworks 4.2
1399 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
1401 * base/db-interface.lisp: Document the multiple values
1402 returned by DATABASE-ATTRIBUTE-TYPE so matches the
1403 undocumented CommonSQL behavior.
1404 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
1405 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
1406 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
1407 Implement CACHE-TABLE-QUERIES.
1408 * db-odbc/odbc-sql.lisp: Fix attribute-type function
1409 * test/test-fddl.lisp: Add tests for attribute type
1410 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
1412 * base/classes.lisp: Add attribute-cache slot to database clas
1413 * base/initialize.lisp: initialize-database-type now automatically
1414 loads database-type backend as needed.
1415 * base/test-init.lisp: Utilize new initialize-database-type functionality.
1416 * TODO: remove items done
1418 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1420 * sql/objects.lisp: remove create/drop-sequence-from-class.
1421 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
1422 * sql/objects.lisp: improved CommonSQL compatibility for
1423 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
1424 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
1425 * sql/generics.lisp: move generics from objects.lisp to here.
1427 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1428 * Version 2.9.6-pre1
1429 * db-mysql/mysql-client-info.lisp: Add client version 4.1
1431 * sql/sql.lisp: Make *default-database* the default for
1434 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1436 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
1438 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
1439 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
1440 on a metaclass specialized from standard-db-class.
1443 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1444 * Version 2.9.4: Multiple changes to support Allegro's "modern"
1445 lisp which uses a lowercase reader and has case-sensitive symbols
1446 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
1447 exposed by case-sensitive mlisp.
1449 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1450 * Version 2.9.3: All tests now pass on all platforms!
1451 * LATEST-TEST-RESULTS: New file with summary of test results
1452 * sql/generics.lisp: New file for generic function definitions.
1453 * test/test-init.lisp: Display names of skipped tests.
1454 Use unwind-protect to ensure disconnect
1455 * sql/objects.lisp: Change database-type to database-underlying-type
1456 so that actual database engine is properly identified
1457 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
1458 return an ISO timestring for compatibility with other drivers.
1459 Workaround bug in MyODBC for LIST-TABLE-INDEXES
1460 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
1461 returns floating-point values for floor and truncate operations
1462 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
1463 * tests/test-basic.lisp: Port to regression tester
1464 * test/test-init.lisp: Output to *report-stream*
1465 * docs/appendix.xml: Document ODBC and SQLite backends.
1466 * sql/classes.lisp: Make output-sql require a database parameter.
1467 This allows SQL generation to have the proper case to support
1468 the differences in case handling between CommonSQL API,
1469 Postgresql, MySQL, Oracle.
1471 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1472 * Version 2.9.2: Improvments in database capability introspection
1473 and querying. Support transactions in MySQL where available.
1474 All tests now pass on MySQL and SQLite in addition to postgresql
1475 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
1476 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
1477 DATABASE-LIST-SEQUENCES.
1478 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
1479 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
1480 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
1481 * tests/*.lisp: Check database capabilities and remove tests which
1482 the database backend does not support
1483 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
1484 controls whether InnoDB tables will be created when supported on
1485 the underlying MySQL server.
1487 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1488 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
1489 supported by all database backends (except AODBC since
1490 AODBC doesn't support index querying)
1491 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
1492 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
1493 to support index queries
1494 * db-aodbc/aodbc-sql.lisp: Filter driver manager
1495 "information_schema" tables from LIST-TABLES
1496 * tests/test-basic.lisp: Remove table after testing
1497 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
1498 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
1499 which gets the underlying type of database -- required
1500 when dealing with ODBC databases and want to query
1501 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
1502 as first database-backend specific feature. Is T on
1503 :mysql, NIL on other backends. Change DROP-TABLE to
1506 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1507 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
1509 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1511 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
1512 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
1514 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1515 * Version 2.8.0: New API function: LIST-DATABASES
1516 * base/utils.lisp: Fix command-output on CMUCL/SBCL
1517 * db-*/*-sql.lisp: Add new database-list function
1518 * base/database.lisp: Add new LIST-DATABASES command
1520 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1522 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
1523 * db-sqlite/sqlite-api-uffi.lisp: Print error string
1526 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1528 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
1531 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1533 * base/objects.lisp, base/classes.lisp: Patch
1534 for db-kind from Eduardo Munoz
1536 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1538 * base/basic-sql.lisp: Fix FLATP in QUERY
1540 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1541 * Version 2.7.3: Implement RECONNECT
1543 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1544 * Version 2.7.2: Fix ODBC on Lispworks Windows
1546 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1547 * Version 2.7.1: Fix for new ODBC backend.
1548 clsql-odbc now works on SBCL, CMUCL, OpenMCL
1549 in addition to AllegroCL and Lispworks.
1551 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1552 * Version 2.7.0: New backend: ODBC. Tests as
1553 well as AODBC backend on Allegro,Lispworks.
1554 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
1555 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
1556 to explicitly set ODBC2 support. Add BIGINT support.
1557 Add result-types support. Added SQLTables.
1558 Fix array type in fetch-all-rows. Make width
1559 changable by database or query.
1560 * base/utils.lisp: Add process functions
1561 * base/package.lisp: Export utils to CLSQL-BASE-SYS
1562 * db-aodbc: Implement sequence functions,
1563 database-list-tables, database-list-attributes
1564 * tests/utils.lisp: Add support for ODBC backend,
1565 rework READ-SPECS to use +all-db-types+
1566 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
1569 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1570 * Version 2.6.13. Requires UFFI version 1.4.9
1571 * db-odbc/*.lisp: Further porting.
1572 Pre-alpha code! But, basic query is now working.
1574 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1576 * base/transactions.lisp: Add quote for macro
1577 expansion of WITH-TRANSACTIONS [Time Howe]
1578 * db-sqlite/sqlite-sql.lisp: Support memory database
1579 in database-probe [Ng Pheng Siong]
1580 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
1581 The DBI layer is not finished.
1583 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1585 * sql/objects.lisp: add :root-class functionality for
1586 list-classes and add duration type support [Marcus Pearce]
1587 * db-odbc: Add mid-level [DBI] layer
1589 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1591 * db-aodbc: Add methods for generic functions, some are
1592 not yet implemented.
1593 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
1596 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1598 * base/package.lisp: Add missing symbols [Marcus Pearce]
1600 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1602 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
1603 * utils/time.lisp: Multiple fixes [Marcus Pearce]
1604 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
1606 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1608 * sql/*.lisp: Remove schema versioning cruft
1610 * Makefile: Add classic subdirectory
1612 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1614 * sql/sql.lisp: Fix TRUNCATE command, bug reported
1616 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
1617 specific and easy for an application to directly support.
1618 Idea from Marcus Pearce.
1619 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
1620 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
1621 Keep low-level interface for future optimization
1622 supporting LIST-ATTRIBUTE-TYPES command.
1623 * Makefile: Add to db-sqlite and test directories.
1624 Include them in top-level Makefile
1626 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1628 * sql/relations.lisp: Add missing file
1629 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
1630 * test/test-time.lips: New file [Marcus Pearce]
1632 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1634 * test/test-init.lisp: Properly handle object
1635 creation. Close database after use.
1636 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
1637 function so can have methods specialized on
1638 table being a string or an sql-table object.
1639 * base/pool.lisp: Really fix CMUCL locking
1641 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1643 * test/test-init.lisp: Signal correctly
1644 if any errors occurred in any test suite
1645 * base/loop-extensions.lisp: Fix error
1646 introduced for Lispworks
1647 * base/pool.lisp: Fix locking for CMUCL
1648 * base/objects.lisp: Remove schema-version cruft
1650 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1651 * Version 2.6.2: New CLSQL API functions:
1652 DESCRIBE-TABLE AND TRUNCATE-DATABASE
1653 Currently, this are only supported on :postgresql
1654 and :postgresql-socket
1655 * base/database.lisp: automatically load ASDF system
1656 in CONNECT if not already loaded
1657 * base/tests.lisp: disconnect database after testing
1658 * base/*.lisp: Remove CLOSED-DATABASE type in favor
1659 of storing open/closed status in slot of database
1660 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
1661 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
1662 DATABASE-DESCRIBE-TABLE
1663 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
1664 * base/conditions: Remove duplicate condition
1665 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
1666 * base/recording.lisp: Add new :QUERY type for recording
1668 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1669 * Version 2.6.1: documentation fixes, merged
1670 classic-tests into tests
1672 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1673 * Version 2.6.0 released: New API functions
1674 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
1675 * doc/ref_clsql.xml: Document new functions
1676 * base/database.lisp: New API functions
1677 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
1678 * base/utils.lisp: Fix use of position-char.
1679 Add COMMAND-OUTPUT used by backends for running
1680 external programs. Fix parsing of SQL*NET-compatible
1682 * base/loop-extension.lisp: Simplify package use
1683 for Lispworks and Allegro
1684 * db-*/*-sql.lisp: Added DATABASE-CREATE,
1685 DATABASE-DESTORY, PROBE-DATABASE methods
1686 * tests/test-init.lisp, clasic-tests/tests.lisp:
1687 Use destroy-database and create-database to ensure
1688 testing with empty database
1689 * tests/test-connection.lisp: Add tests for
1690 parsing of string connection-specs
1691 * examples/run-tests.sh: New file for running
1692 test suite on all installed CL implementations
1693 * examples/clsql-tutorial.lisp: moved from
1695 * examples/dot.clsql-tests.config: New file
1696 giving an example test configuration
1697 * test/README: Add notes about rtest/ptester
1698 downloads and link to sample test configuration file.
1700 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1701 * Version 2.5.1 released:
1702 * tests/*.lisp: Rework so tests are run
1703 on multiple backends automatically based
1704 on the contents of ~/.clsql-tests.config.
1705 Reuse helper functions from classic-tests.
1706 * base/database.lisp: Support connection-spec
1707 as string for CONNECT
1708 * classic-tests/tests.lisp: Automatically
1709 load database backends as needed.
1711 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1712 * Version 2.5.0 released:
1713 All tests for CLSQL and CLSQL-CLASSIC pass
1715 * base/loop-extension.lisp: Add Lispworks
1716 loop-extension. Improve type specifying on
1719 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1720 * Version 2.4.2 released:
1721 loop extension now supported on Allegro, all
1722 CLSQL-TESTS pass on Allegro.
1723 * sql/metaclasses.lisp: Some optimization
1724 of compute-slots, be selective when
1725 ordered-class-slots needs to be called
1726 instead of class-slots
1727 * TODO: add URL with documentation on
1728 extending Lispworks LOOP form
1730 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1731 * Version 2.4.1 released: CLSQL-TESt suite passes
1732 all tests for postgresql and CMUCL, SBCL, OpenMCL.
1733 Allegro and Lispworks pass all tests except for
1734 FDML/LOOP/1 since the loop extension have not yet
1735 been ported to those implementions.
1736 * sql/metaclasses.lisp: Added new slot to standard-db-class
1737 to hold user-specified type. OpenMCL adjustments to compensate
1738 for its type-predicate function. Since AllegroCL, Lispworks,
1739 and OpenMCL have different slot orders, added compute-slots
1740 and ordered-class-slots functions so their slot order matches
1743 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1744 * Version 2.4.0 released: All tests for clsql-classic now finish
1745 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
1746 mysql, postgresql, postgresql-sockets, and sqlite backends.
1747 * db-mysql/mysql-sql.lisp: Fix array dereferencing
1748 * classic-tests/tests.lisp: Fix package name of
1749 number-to-sql-string.
1750 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
1751 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
1752 now passes tests on all support UFFI platforms.
1753 * db-postgresql-socket/postgresql-socket-api.list: Ported to
1755 * multiple: Finish renaming of :types keyword to :result-types for
1756 greater CommonSQL compatibility, including documentation
1757 * sql/basic-cmds.lisp: Remove obsolete file
1759 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1760 * Version 2.3.3 released
1761 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
1762 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
1763 * Fix for schema table [Marcus Pearce]
1764 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
1765 * Fixes to test suite [Marcus Pearce]
1767 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1768 * db-*/*-sql.lisp: Ensure that expr in
1769 database-query-result-set is a string
1770 * Documentation integration
1772 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1773 * With for Marcus Pearce's excellent work, I've merged
1774 his clsql-usql port into clsql. The original clsql
1775 interface is available in the clsql-classic package.
1777 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
1778 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
1779 adding further support for providing backend for UncommonSQL
1781 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
1782 * Integrate patch from Aurelio Bignoli for SQLite backend
1784 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
1785 * Converted documentation to XML format
1786 * Made package installable with asdf-install
1788 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
1789 * Add for-each-row macro
1791 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
1792 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
1794 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
1795 * Add support for SBCL, OpenMCL, and SCL
1796 * Add *load-truename* to search path for clsql's
1799 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
1800 * Rework use of file types in .asd files
1802 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
1803 * Add .asd definition files for ASDF users
1805 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
1806 * Restructure directories for Common Lisp Controller v3 compatibility
1808 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
1809 * Also change case of logical host in loader files
1810 * Rework handling of logical pathnames
1812 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
1813 * Change case of logical host
1815 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
1816 * clsql-base.system: Added base package that can be used without
1817 high-level SQL commands. Used for adding support for UncommonSQL.
1818 * *.system: Reworked logical pathnames to be more consistent with
1819 Common Lisp Controller.
1820 * debian/*: Completed initial Debian support
1822 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
1824 * sql/transactions.cl:
1825 Added transaction support. Functions/macros added:
1826 with-transaction, commit-transaction, rollback-transaction,
1827 add-transaction-commit-hook, add-transaction-rollback-hook
1829 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
1832 * sql/functional.cl:
1833 Added pool support in connect/disconnect and with-database.
1834 Removed with-db-from-pool as with-database can now works with the connections pool
1836 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
1841 Completed connection pool.
1842 Added with-db-from-pool macro.
1844 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
1846 Added initial support for connection pool
1847 * sql/transactions.cl
1848 Took transaction code from UncommonSQL and integrated
1849 into CLSQL code. See file for disclaimer about why this
1852 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
1853 * interfaces/postgresql/postgresql-sql.cl:
1854 Fix keyword typo in database-read-large-object
1855 * interfaces/mysql/mysql-loader.cl
1856 Fix loading on Win32
1857 * test-suite/tester-clsql.cl
1858 Fix type coercion of double-float
1860 Added debian docbook catalog, made it the default
1862 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
1863 * interface/postgresql/postgresql-api.cl:
1864 * interface/postgresql/postgresql-sql.cl:
1866 * sql/db-interface.cl:
1867 Added large objects support for postgresql.
1869 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
1870 * src/postgresql-socket/postgresql-socket-api.cl:
1871 Fixed find-foreign-function call, eliminated crypt warning
1873 Multiple improvements
1875 Moved functionality from low-level interfaces to this file
1876 via generic functions
1877 * test-suite/tester.cl:
1878 Added test with acl-compat-tester, moved others to old-tests
1881 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
1883 Reinstated commented out sections
1884 * interfaces/postgresql/postgresql-loader.cl:
1885 * interfaces/mysql/mysql-loader.cl:
1886 Updated find-forieign-library support.
1887 * interfaces/postgresql-socket/postgresql-socket-package.cl:
1888 Fixed require form for Lispworks (Thanks Marc Battyani!)
1889 * interfaces/postgresql-socket/postgresql-socket-api.cl:
1890 Fixed eval of def-function for crypt library.
1892 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1893 * Added interface to support USQL high-level rouines
1895 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1896 * Separated db-interface and conditions from sql/sql.cl
1897 * Improved foreign library loading testing
1898 * interfaces/postgresql/postgresql-api.cl
1899 Added PQisBusy function
1900 * interfaces/clsql-uffi/clsql-uffi.cl
1901 Fixed sign error for 64-bit processing
1903 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1904 * interfaces/postgresql-socket/postgresql-socket-api.cl:
1905 Fixes to read-double-from-socket. Added 64-bit integer support.
1906 * test-suite/xptest-clsql.cl
1907 Added testint for 64-bit integers
1908 * Additons to installation docs
1910 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1911 * interfaces/postgresql-socket/postgresql-socket-api.cl:
1912 Implemented direct socket reading for field type :double
1913 * Added usage information for :types to documentation
1914 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
1916 * interfaces/clsql-uffi: Created new directory. Split common
1917 interface routines that use UFFI into this package. Required
1918 especially to support direct reading of 64-bit integers into
1919 bignums and bypassing temporary strings.
1920 * test-clsql.cl: Updated to test postgresql-socket's
1921 read-double-from-socket function.
1922 * test-suite/xptest-clsql.cl
1923 Started work on test suite
1925 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1926 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
1927 mysql-fetch-field-direct Got :auto types working
1928 * interfaces/postgresql/postgresql-api.cl
1929 * interfaces/postgresql-socket/postgresql-socket-api.cl
1930 Added pgsql-field-types enum. Got :auto types working.
1932 Renamed :field-types to :types.
1934 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1935 * Added field-types parameter to query, database-query,
1936 database-query-result-set, map-query. Haven't added code
1937 to utilize field types, yet.
1938 * Changed postgresql-socket result set from cons to a structure
1939 * Updated test-clsql.cl to use automated testing with a config
1941 * Changed return types of field accessors from cstring to
1942 (* :unsigned-char). This prepares for being able to use specified
1943 type conversions when taking field data into lisp.
1944 * Added field-type processing for most interfaces. Not done yet.
1946 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
1947 * doc/ref.sgml: Updated MAP-QUERY example to use
1948 *read-default-float-format* (John Foderaro)
1949 * Extensive work to foreign library loaders and .system files to
1950 check for successful loading of foreign libraries.
1951 * Modified test-clsql.cl to allow more modularity and
1952 automated testing in future release.
1953 * mysql/mysql-sql.lisp: Added field types
1955 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
1956 * mysql/mysql-sql.lisp:
1957 - Added support for Allegro CL and Lispworks using UFFI layer
1958 - Changed database-connect to use mysql-real-connect. This way,
1959 can avoid using double (unwind-protect)
1960 - Changed database-connect to have MySQL library allocate space
1961 for MYSQL structure. This will make the code more robust in
1962 the event that MySQL library changes the size of the mysql-mysql