1 2012-07-09 Russ Tyndall <russ@acceleration.net>
2 * sql/oodml.lisp - fixed a bug where the order by was being
3 destructively modified, causing odd caching issues when the
4 selected object was not statically known (eg unreferenced tables
5 could show up in the query if they were cached by a previous call
6 through this function. I replaced this code with a
7 non-destructive variant which should solve this.
9 Thanks to Philipp Marek for the bug report
11 2012-06-25 Russ Tyndall <russ@acceleration.net>
12 * sql/util.lisp, sql/metaclasses.lisp
13 Dequote database-identifiers if needed (passed a quoted symbol)
14 Metaclass args come through unquoted, so this eases interactions
17 2012-06-22 Russ Tyndall <russ@acceleration.net>
18 * sql/metaclasses.lisp: Changed compute-effective-slot-definition
19 to correctly copy the autoincrement-sequence slot to the ESD
20 previously it was being skipped (seemingly by accident). Thanks
21 to flip214 on #lisp for the bug report
23 2012-04-26 Kevin Rosenberg <kevin@rosenberg.net>
24 * Version 6.2 released: thanks to all the contributors!
26 2012-04-25 Nathan Bird <nathan@acceleration.net>
28 * doc/threading-warnings.txt: Adding some notes from J.T.Klein
29 about the current state of thread-safety in clsql. This should be
30 incorporated into the main docs at some point.
32 2012-04-25 Russ Tyndall <russ@acceleration.net>
33 * sql/expressions.lisp (output-sql): on rendering update/insert
34 expression values, ensure that *in-subselect* is bound to T
35 so that the values will be correctly paren delimited
37 2012-04-24 Nathan Bird <nathan@acceleration.net>
39 * sql/expressions.lisp (output-sql): on mysql CREATE TABLE
40 statements use 'ENGINE=innodb' instead of 'Type=InnoDB'. This has
41 apparently been preferred since mysql 4.1 and mysql 5.5 removed
42 type as a valid keyword.
44 2012-03-28 Russ Tyndall <russ@acceleration.net>
46 * sql/sequences.lisp: [A Patch FROM 2011-07-28 changed sequences.
47 They were previously prefixed with _CLSQL_SEQ_ but are now
48 suffixed with _CLSQL_SEQ. This is likely to break existing
49 implementations using the default sequence names
51 setting *old-sequence-names* to T, should force using the older
54 2012-03-27 Ryan Davis <ryan@acceleration.net>
56 * sql/expressions.lisp: Fixed bug with subqueries in the where
57 clause of update-records and delete-records generating invalid
58 SQL. Previously subselects in where clauses would not have enough
59 parentheses, for example: "WHERE Id IN SELECT foo_id FROM bar"
60 vs. "WHERE Id IN (SELECT foo_id FROM bar)"
61 * tests/test-syntax.lisp: Added tests for using subqueries in the
62 where clause in update-records and delete-records. Moved asserts
63 in the test-output-sql/sql-ident-table function into the standard
65 * doc/appendix.xml: added :connection-string to the information on
66 ODBC connection specs, and added example code connecting to ODBC
69 2012-01-05 Nathan Bird <nathan@acceleration.net>
71 * db-odbc/odbc-dbi.lisp: handle sql decimal type in the same way
72 as numeric type-- read into a double float.
74 2011-01-04 Russ Tyndall <russ@acceleration.net>
77 Fixed bug reported by JTK related to the not-null sql-expression
78 especially as used in conjunction with the is operator.
80 Made null called with more than one argument throw an exception
81 instead of silently discarding all arguments past the first
83 2012-01-04 Nathan Bird <nathan@acceleration.net>
85 * db-odbc/odbc-api.lisp (%sql-driver-connect): in the call to
86 odbc's SQLDriverConnect default the WindowHandle argument to a null ptr so
87 that connecting with :connection-string will work in the default
88 case of SQL_DRIVER_NOPROMPT.
90 I.e. you can now do things like:
91 (clsql:connect '("DsnName" "UserName" "" :connection-string
92 "DRIVER={FreeTDS};SERVER=...;DATABASE=...;UID=...;PWD=...;PORT=1433;TDS_Version=8.0;APP=clsql")
95 I believe the DsnName and Username at that point are only used when
96 printing the connection information.
98 2011-12-20 Kevin Rosenberg <kevin@rosenberg.net>
100 * db-oracle/oracle.lisp: Typo correction (Elias Martenson)
102 2011-12-19 Kevin Rosenberg <kevin@rosenberg.net>
104 * db-oracle/oracle.lisp: Change length function to
105 uffi:foreign-string-length to handle foreign encodings.
106 Thanks to Elias Martenson.
108 2011-11-28 Russ Tyndall <russ@acceleration.net>
109 * db-odbc/odbc-api.lisp, tests/test-time.lisp
111 In ODBC backend, avoid going through the common lisp
112 universal-time type (because it lacks support for historic dates)
114 *time-conversion-function* renamed to *time-format*
116 Patch from: Francisco Vides Fernandez
118 2011-10-18 Russ Tyndall <russ@acceleration.net>
119 * db-odbc/odbc-api.lisp
121 Added type specifier so MSSQL nvarchar fields can make it through
123 2011-09-12 Russ Tyndall <russ@acceleration.net>
124 * sql/fddl.lisp sql/generic-postgres.lisp db-mysql/mysql-sql.lisp
125 sql/generic-odbc.lisp sql/odbc-api.lisp sql/odbc-dbi.lisp
127 Fix bugs in list-attribute(s|-types) where passing an escaped,
128 instead of unescaped column name, caused these functions to return
129 less data than they should have.
131 2011-08-03 Kevin Rosenberg <kevin@rosenberg.net>
132 * CLSQL 6.0.0 released
134 2011-07-28 Russ Tyndall <russ@acceleration.net>
136 * db-postgresql-socket3/: Added a backend that utilized postgres
137 socket api version 3. Uses the cl-postgres project (from
138 postmodern) to handle this. Allows use of parameterized /
139 prepared queries using clsql:command-object
141 * sql/{expressions,fddl, generic-postgresql, ooddl}.lisp:
142 Change how database identifiers are emitted to hopefully make this
143 less brittle, and more easily intuitable.
145 Previously every code path that wanted to emit a
146 database identifier was responsible for coercing what was provided
147 into a correctly escaped string. Sometimes two or three functions
148 in a row were trying to correctly quote and output that string. I
149 have tried to centralize this type coercion and logic into a
152 everything should now call (escaped-database-identifier thing)
153 immediately before splicing a database identifier into string being
156 * sql/oodml.lisp: added method choose-database-for-instance, which
157 allows overriding which database connections are used based on
158 object type. Can be used to prevent connection conflicts in
159 multi-threaded environments
161 * sql/syntax.lisp: [foo bar] and [foo.bar] read into the same
162 clsql expression now (they used to be output the same, but after
163 the above database-identifier change, they were output separately
165 * test/: Better, more tests, better type coercion in tests and
166 throughout (%get-int)
168 [edit 2012-03-28 - RT]
169 * sql/sequences.lisp: Sequences were previously prefixed with
170 _CLSQL_SEQ_ but are now suffixed with _CLSQL_SEQ. This is likely
171 to break existing implementations using the default sequence names
173 setting *old-sequence-names* to T, should force using the older
177 2011-07-16 Kevin Rosenberg <kevin@rosenberg.net>
178 * Version 5.4.0 release
180 2011-06-27 Nathan Bird <nathan@acceleration.net>
181 * db-odbc/: memory management improvements: leak slower
182 * MSSQL: TOP + DISTINCT work together
184 2011-06-20 Nathan Bird <nathan@acceleration.net>
186 * sql/time.lisp: Handle parsing already parsed objects.
187 * sql/oodml.lisp: raise exception if we generate an update with no
188 where clause; incorporate Ryszard Szopa's patch for functional
189 expressions in :order-by
190 * sql/expressions.lisp: (listify nil) => nil instead of (nil).
191 * db-odbc/: bugfixes for working with older versions of FreeTDS;
192 support for bigints that works on mssql and postgres
193 * MSSQL improvements: use top instead of limit, IDENTITY can be a
194 column constraint, clsql:date becomes 'smalldatetime'
196 2011-06-20 Nathan Bird <nathan@acceleration.net>
199 * db-postgresql-socket/postgresql-socket-api.lisp: Addendum
200 to Otto Diesenbacher's patch that had a spurious write a 0
201 byte (to terminate string) that should have been just CCL.
203 2011-06-12 Kevin Rosenberg <kevin@rosenberg.net>
205 * db-postgresql-socket/postgresql-socket-api.lisp:
206 Patch from Otto Diesenbacher for UTF8 encoded strings
207 for CCL. FIXME: The best patch would be to use the
208 user-set encoding from the database object and use
209 UFFI's encoding strings to/from octet vectors rather
210 than SB-UNICODE and CCL specific code in this file.
212 2011-04-21 Kevin Rosenberg <kevin@rosenberg.net>
213 * sql/generics.lisp: Add defgeneric for new
214 database-last-auto-increment-id
216 2011-04-01 Kevin Rosenberg <kevin@rosenberg.net>
218 * db-mysql/mysql-client-info.lisp: Add recognition of
219 version 6 of MySQL client library.
220 * sql/metaclass.lisp: Fix the fix in the reader conditional
222 2011-03-30 Kevin Rosenberg <kevin@rosenberg.net>
224 * sql/metaclasses.lisp: Fix previous patch to work
227 2011-03-29 Kevin Rosenberg <kevin@rosenberg.net>
229 * sql/metaclasses.lisp: Apply one-line patch to fix
230 for newer SBCL (thanks to Nikodemus Siivola)
231 * many_files: Applied multiple patches from Holger Schauer
232 to improve autoincrement capability.
234 2010-10-24 Kevin Rosenberg <kevin@rosenberg.net>
236 * db-odbc/odbc-api.lisp: Change from SBCL-specific
237 to UFFI version of octets-to-strings. Reported by
238 Daniel Brunner <daniel@dbrunner.de>
239 * sql/oodml.lisp: Apply patch from Rupert Swarbrick
240 <rswarbrick@gmail.com>: Fix behaviour with auto-inc
242 * sql/expressions.lisp, tests/test-syntax.lisp: Apply
243 patch from Russ Tyndall to quote identifiers with space
244 or special character.
246 2010-09-20 Kevin Rosenberg <kevin@rosenberg.net>
248 * sql/{pool,database}.lisp: Pass encoding argument to
249 connections made from pool and with reconnect.
251 2010-08-16 Kevin Rosenberg <kevin@rosenberg.net>
253 * db-odbc/odbc-{api,dbi}.lisp: Commit patch from
254 Memet Bilgin to fix issue with unicode and ODBC.
256 2010-08-16 Kevin Rosenberg <kevin@rosenberg.net>
258 * uffi/clsql-uffi.lisp: Commit patch from JT Klein fixing
259 invocation of uffi:convert-from-foreign-string macro. When
260 time allows, I'll investigate changing UFFI's macro to
261 a function call and then revert this patch.
263 2010-06-15 Kevin Rosenberg <kevin@rosenberg.net>
265 * clsql-{uffi,mysql}.asd: Modify operation-done-p functions
266 to guard against change introduced in new ASDF traversing.
268 2010-04-20 Kevin Rosenberg <kevin@rosenberg.net>
269 * Version 5.1.0 [DEPENDENCY UPGRADE: UFFI 2.x needed]
270 * clsql-uffi.asd: Depend on UFFI version >= 2.0
271 to support foreign encoding of strings.
273 2010-04-16 Kevin Rosenberg <kevin@rosenberg.net>
275 * db-postgresql.lisp, sql/fddl.lisp: Fix typos [Thanks to
277 * sql/metaclasses.lisp: Work around type-check-function being set
278 during defclass expansion in SBCL [Thanks to Walter C. Pelissero]
279 * uffi/clsql-uffi.lisp: In call to uffi:convert-from-foreign-string,
280 Set null-terminated-p to T when length not specified.
281 [Thanks to Walter C. Pelissero]
283 2010-03-21 Kevin Rosenberg <kevin@rosenberg.net>
285 * sql/fdml.lisp: Fix DO-QUERY to actually return the last value of
288 2010-03-02 Nathan Bird <nathan@acceleration.net>
289 * doc/: Added a README on how to build doc; now builds on Ubuntu.
290 * sql/oodml.lisp: READ-SQL-VALUE now has explicit method for
291 handling double-floats and the default method will no longer
292 attempt to convert values that have already been converted.
293 * sql/syntax.lisp: Introduce file-enable-sql-reader-syntax which
294 enables the syntax for the scope of the file without trying to
295 keep track of the current syntax state.
296 * sql/pool.lisp: Introduce
297 clsql-sys:*db-pool-max-free-connections* which is a heuristic
298 threshold for when to disconnect a connection rather than
299 returning it to the pool.
300 * sql/pool.lisp: Check connections for validity before returning
303 2010-03-01 Kevin Rosenberg <kevin@rosenberg.net>
304 * db-mysql/mysql-api.lisp: Remove spurious enumeration
306 2010-02-16 Kevin Rosenberg <kevin@rosenberg.net>
308 * db-mysql/mysql-api.lisp: Fix mysql_options UFFI parameter list
309 * doc/ref-connect.xml: Document the MySQL options parameter as
310 part of the connection-spec.
312 2010-02-15 Kevin Rosenberg <kevin@rosenberg.net>
313 * db-mysql/mysql-{api,sql}.lisp: Support sending options
314 to MySQL using mysql_options, which occurs between the API calls
315 of mysql_init and mysql_real_connect.
317 2010-02-11 Kevin Rosenberg <kevin@rosenberg.net>
319 * multiple-files: Further internationalization. Change
320 UFFI:CONVERT-RAW-FIELD and UFFI:CONVERT-FROM-FOREIGN-STRINGS
321 invocations to use the foreign character set encoding of the
322 database object. Requires UFFI v.1.8.6
323 * Makefile.common: Fix OS_DARWIN64 setting
325 2010-02-11 Nathan Bird <nathan@acceleration.net>
326 * MSSQL: better support for fddl 'date type.
328 2010-02-11 Kevin Rosenberg <kevin@rosenberg.net>
329 * Makefile.common, uffi/Makefile, db-mysql/Makefile:
330 Better support OS X Snow Leopard by building universal
331 (x86_64,i386) dylib bundles
333 2010-02-08 Kevin Rosenberg <kevin@rosenberg.net>
335 * sql/database.lisp: Fix missing slot-accessor
336 (Thanks to Stelian Ionescu)
337 * sql/generics.lisp: Add missing keyword to defgeneric
338 (Thanks to Stelian Ionescu)
340 2010-02-07 Kevin Rosenberg <kevin@rosenberg.net>
342 * sql/{base-classes,database}.lisp: Add encoding slot for
344 * db-mysql/mysql-sql.lisp: Use UFFI:FOREIGN-ENCODED-OCTET-COUNT.
345 Requires UFFI version 1.8.2 or above.
347 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
348 * Version 5.0.0: First release of CLSQL to formally and
349 consistently support non-ASCII strings with encoding of external
350 formats for SQL strings. UFFI version 1.8.1 is higher is required.
352 This change may introduce some differences in string handling for
353 people who are using non-ASCII encoded characters. Thus, because
354 of the risk of BACKWARD INCOMPATIBILITY, the major version number
355 was incremented with this release.
357 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
358 * tests/test-i18n.lisp: Bind UFFI:*DEFAULT-EXTERNAL-FORMAT*
359 for testing multibyte encodings.
360 * uffi/clsql-uffi.lisp: Changes for UFFI 1.7.4's new support
361 for encoding foreign strings with a specified external format.
363 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
364 * sql/metaclasses.lisp: If no declared slot type in
365 compute-lisp-type-from-specified-type, then use t as lisp type.
366 Issue noted when testing Clozure CL 1.4.
368 2010-02-06 Kevin Rosenberg <kevin@rosenberg.net>
369 * tests/test-init.lisp: Turn off the benign console notices for
372 2010-02-05 Kevin Rosenberg <kevin@rosenberg.net>
373 * clsql-test.asd, tests/{test-i18n,test-init}.lisp:
374 Load test-i18n.lisp and use its tests as long as 'uffi:no-i18n is
375 not present in cl:*features*. This requires UFFI 1.7.2 or above.
377 2010-02-05 Kevin Rosenberg <kevin@rosenberg.net>
378 * sql/utils.lisp: Reading #\no-break_space causes an
379 error for non-unicode SBCL. Conditionalize read of
380 #\no-break_space for non-unicode SBCL and 8-bit string
383 2010-02-03 Kevin Rosenberg <kevin@rosenberg.net>
384 * tests/test-init.lisp: Add *test-report-width* variable
385 and word-wrap skipped test reason field.
387 2010-01-29 Kevin Rosenberg <kevin@rosenberg.net>
389 * clsql-cffi.asd: New file that causes CLSQL to use
390 CFFI-UFFI-COMPAT library rather than UFFI. Perform 'asdf:load-op
391 on CLSQL-CFFI rather than CLSQL system to use CFFI-UFFI-COMPAT.
393 2010-01-29 Nathan Bird <nathan@acceleration.net>
394 * tests/*.lisp: A lot more tests and test setup tweaks.
395 * sql/expressions.lisp: output-sql on sql-relational-exp does
396 better arity checking now. (apply #'sql-and some-list) gives
399 29 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
400 * sql/oodml.lisp: Fix for UPDATE-RECORD-FROM-SLOTS for normalized
403 28 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
405 * Change "normalise" from British spelling for consistency with
406 other American spellings in CLSQL.
408 28 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
409 * db-mysql/Makefile: Add directory for Fedora 11/12 on 64-bit
410 platform (Thanks to Michael Pheasant) and remove a 32-bit directory
412 28 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
414 * sql/utils.lisp: Ensure Lispworks 6 lock is created in sharing mode
416 20 Jan 2009 Nathan Bird <nathan@acceleration.net>
418 * Rewrite tests to use datasets
420 07 Jan 2009 Kevin Rosenberg <kevin@rosenberg.net>
421 * sql/utils.lisp: Changes to support Lispworks 6
423 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
425 * doc/ref-ooddl.lisp: Add needed CDATA escapes
426 * doc/clsql.pdf, doc/html.tar.gz: Build new manuals with
427 normalized view classes.
429 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
430 Large patch from Thijs Oppermann <thijso+clsql@gmail.com> to add
431 support for normalized view classes. When having view class that
432 inherit from others, CLSQL by default builds tab all the columns
433 from the parent in the child. This patch is meant to normali so
434 that a join is done on the primary keys of the concerned tables to
437 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
438 * sql/time.lisp: Patch from Oleg Tihonov to SYNTAX-PARSE-ISO-8601
439 to properly parse fractions of seconds.
441 10 Dec 2009 Kevin Rosenberg <kevin@rosenberg.net>
442 * sql/time.lisp: Patch from Oleg Tihonov to roll function
443 to properly use USEC argument.
445 21 Nov 2009 Kevin Rosenberg <kevin@rosenberg.net>
447 * Makefiles: On 64-bit Linux systems, try to build both 32 and 64-bit
448 interface libraries. This requires the installation of multiarch build tools
449 as well as 32-bit support libraries (libc, libz and libmysqlclient).
451 04 Sep 2009 Kevin Rosenberg <kevin@rosenberg.net>
453 * sql/fdml.lisp: Rework do-query to use supplied database
454 parameter when passed a sql-object-query
455 (thanks to JTK <jetmonk@gmail.com>)
456 * sql/generic-postgresql.lisp: Allow optional connect
457 parameters for postgresql databases (thanks to Stephen Compall)
458 * doc/ref-{clsql,connect}.xml, sql/db-interfaces.lisp:
459 Fix transposed letters (thanks to Stephen Compall)
460 * db-mysql/Makefile: Add directory for MacPorts mysql5 port
461 (thanks to Stephen Compall)
462 * sql/database.lisp: Have database-type default be
463 *default-database-type* (thanks to Desmond O. Chang)
464 * sql/transactions.lisp: Improved handlining of nested
465 transactions (thanks to Eli Naeher)
466 * sql/time.lisp: Commit patch to fix parse-iso-8601-duration
467 (thanks to Stephen Compall)
468 * sql/database.lisp: Use :verbose nil for asdf:operate
469 invocation (Thanks to Mackram Raydan)
470 * sql/metaclasses.lisp: Rework initialize-instance for
471 view-class-direct-slot-definition (thanks to Stephen Compall)
473 31 Aug 2009 Kevin Rosenberg <kevin@rosenberg.net>
474 * sql/db-interface.lisp: Fix spelling error (thanks to
476 * clsql-mysql.asd/db-mysql/mysql-loader.lisp: Commit
477 patch from Andreas Franke to honor windows drive letter
478 when loading clsql_mysql C library.
480 31 Aug 2009 Kevin Rosenberg <kevin@rosenberg.net>
482 * db-mysql/mysql-{sql,api}.lisp,db-mysql/clsql_mysql.c:
483 Latest version of mysqlclient once again changed the C
484 structures from which the mysql backend reads data.
485 Rather than adding yet another structure definition which
486 is enabled by the client version as read by mysql-client-info.lisp,
487 the mysql backend has been re-written to ignore in the internal
488 C structures. Instead, C wrapper functions for slot access have
489 been added to clsql_mysql.c and are used by mysql-sql.lisp to
490 access the internals of C structures. This adds a bit of overhead,
491 but completely separates the lisp code from trying to keep up
492 with the continually changing internal C structure of mysql.
493 All tests in the test suite executed correctly with this change.
495 31 Aug 2009 Kevin Rosenberg <kevin@rosenberg.net>
497 * sql/database.lisp: Fix syntax on process-lock (thanks to
499 * db-mysql/mysql-sql.lisp: Allow use of database parameter
500 in database-list function (thanks to Michael Pheasant)
501 * sql/oodml.lisp: Allow NULL values for floating-point fields
502 (thanks to Jan Rychter)
504 02 Jun 2009 Kevin Rosenberg <kevin@rosenberg.net>
506 * sql/database.lisp: Add process-lock for deleting database from
507 a pool (thanks to Ralf Mattes).
509 25 Feb 2008 Kevin Rosenberg <kevin@rosenberg.net>
511 * sql/expressions.lisp: Remove stray form (thanks to Samuel Ward)
513 12 Dec 2007 Kevin Rosenberg <kevin@rosenberg.net>
514 * sql/expressions.lisp: Bind *in-subselect* when outputting
515 selections (patch from unknown source).
517 11 Dec 2007 Kevin Rosenberg <kevin@rosenberg.net>
519 * sql/metaclasses.lisp: Unify base-table processing by extracting
520 the correct code from initialize-instance :around into the helper
521 function set-view-table-slot. Call that function also in
522 reinitialize-instance :around replacing erroneous code discovered
525 17 Nov 2007 Kevin Rosenberg <kevin@rosenberg.net>
526 * BUGS: Add note about benefit of using configure file to create
527 Makefiles (suggestion from Joe Corneli)
529 22 Oct 2007 Kevin Rosenberg <kevin@rosenberg.net>
531 * db-postgresql/postgresql-sql.lisp: Patch from Gabriele Favalessa based on
532 Andrew Golding suggestion for more informative :error-id slot.
534 17 Sep 2007 Kevin Rosenberg <kevin@rosenberg.net>
536 * db-mysql/mysql-sql.lisp: Convert query to uffi cstring (thanks to
538 * doc/Makefile, doc/html.xsl: Change output encoding from ISO-8859-1 to UTF-8
540 14 Sep 2007 Kevin Rosenberg <kevin@rosenberg.net>
541 * Version 4.0.0: Major version increase to warn of potential
542 backwards incompatibility.
543 * NEWS: Document potentional backward incompatible changes
544 * db-mysql/mysql-sql.lisp: Changes session SQL mode to ANSI immediately
545 after connecting. This may break compatibility with some applications
546 who are using non-ANSI features with MySQL. This change is required to
547 properly support view-classes using a string as their :base-table
548 attribute. This allows users to specify the case of table names.
549 This is feature is even more essential for MySQL itself since MySQL
550 uses case-sensitive table names. Use connection-based database-create
551 and database-destroy rather than trying to invoke command-line mysql
552 utility. Remove automatic upcasing of strings from list-indices.
553 * db-postgresql/postgresql-sql.lisp: Use connection-based
554 database-create and database-destroy rather than trying to invoke
555 command-line utilities.
556 * db-postgresql-socket/postgresql-socket-sql.lisp: Use
557 database-execute-command rather than execute-command for
558 database-{create,destroy}. Connect to postgres database
559 rather than template1 for those database creation/deletion.
560 * sql/metaclasses.lisp: Store the string value of :base-table if a
561 string is provided. Perform sql-escape at time of view-table name
563 * tests/test-init.lisp: Use "ej_join" as a string, rather than a
564 symbol, since "ej_join" is specified as :base-table. Clear the
565 expression output-cache in case the code for generating sql output
567 * test/test-oodml.lisp: whitespace fix
568 * sql/ooddl.lisp: Use quoted string for primary key constraint if
569 table name is specified as a string.
570 * sql/oodml.lisp: Don't convert a string view-table name to database's
572 * sql/expressions.lisp: Properly handle table and attribute identifiers
573 when they are a string. Do not change case of symbols to match database
575 * sql/operations.lisp: Change multiword symbols to upper case.
576 * sql/fddl.lisp: Quote base-table if a string to preserve case
577 for drop-table and create-table.
578 * tests/test-syntax.lisp: Add tests of low-level string attribute
581 20 Jul 2007 Kevin Rosenberg <kevin@rosenberg.net>
583 * db-oracle/oracle-loader.lisp: Rework use of ORACLE_HOME directory
584 (problem noted on clsql-devel by icardo Boccato Alves)
585 * sql/pool.lisp: Remove incorrect keyword
586 * sql/database.lisp: Rework WITH-DATABASE to not make the database the
587 default database (reported by Saurabh Nanda and Chaitanya Gupta)
588 * doc/ref-connect.lisp: Update the documentation to WITH-DATABASE to
589 emphasis that make-default has a default value of nil.
590 * sql/transaction.lisp: Adjust commit/rollback messages for Microsoft
591 SQL Server. (patch from Nathan Bird)
592 * sql/metaclasses.lisp: Use finalize-inheritance hack on SBCL because
593 of trouble with def-view-class compilations (patch from Nathan Bird)
595 15 Jul 2007 Kevin Rosenberg <kevin@rosenberg.net>
597 * db-mysql/mysql-loader.lisp: Revert previous change since libmysql is
598 not dynamically loaded on Windows
600 22 Jun 2007 Kevin Rosenberg <kevin@rosenberg.net>
602 * db-mysql/mysql-loader.lisp: Do not bother loading libmysqlclient since
603 that library is dymically linked to clsql-mysql library. Thus, the mysql
604 library will be automatically loaded. This has only been tested on Linux,
607 29 May 2007 Kevin Rosenberg <kevin@rosenberg.net>
608 * tests/test-fddl.lisp: Add :order-by for :fddl/big/1 as
609 reported by Ricardo Boccato Alves
611 02 May 2007 Kevin Rosenberg <kevin@rosenberg.net>
612 * sql/database.lisp: Add ability of WITH-DATABASE to return
613 multiple values (patch from Liam Healy)
615 25 Apr 2007 Kevin Rosenberg <kevin@rosenberg.net>
617 * doc/connect.xml: variable description fix by Liam Healy
618 * db-sqlite3/sqlite3-api.lisp, uffi/clsql-uffi-loader.lisp:
619 Apply patches from Marcus Pierce to reduce load-time warnings
620 * sql/package.lisp: Export iso-timestring as requested by Kevin Blaisdell
622 23 Mar 2007 Kevin Rosenberg <kevin@rosenberg.net>
624 * sql/db-postgresql-socket-api.lisp: Change read-socket-sequence to
625 disable wide characters for crypt salt sequence on SBCL, based
626 on patch from Lars Nostdal.
628 26 Jan 2007 Kevin Rosenberg <kevin@rosenberg.net>
630 * sql/pool.lisp: Test pooled connection when popped from
631 the pool to ensure the connection still works. Currently, implemented
634 17 Jan 2007 Kevin Rosenberg <kevin@rosenberg.net>
635 * db-mysql/Makefile: Add potential mysql directories
637 31 Dec 2006 Kevin Rosenberg <kevin@rosenberg.net>
638 * sql/metaclasses.lisp: Remove usused saved-initargs
639 * clsql.asd: Also check ~/.clsql-init.lisp at load-time (usually used to
640 push search libraries)
642 30 Dec 2006 Kevin Rosenberg <kevin@rosenberg.net>
643 * Version 3.8.0: BACKWARD INCOMPATABLE CHANGE!
644 * db-postgresql/postgresql-{api,loader,sql,package}.lisp:
645 Apply patch from Edi Weitz to avoid conflict with new Lispworks 5
646 POSTGRESQL package name. CLSQL's new package will be PGSQL, however
647 on non-Lispworks platforms, the nickname POSTGRESQL will still be
648 available. Applications directly using low-level POSTGRESQL package
649 are recommended to use the new PGSQL name.
650 * db-oracle/oracle-{api,sql}.lisp, sql/{expressions,loop-extension}.lisp,
651 Apply patch from Edi Weitz to reduce compiler warnings.
653 28 Dec 2006 Kevin Rosenberg <kevin@rosenberg.net>
655 * sql/expressions.lisp: Commit patch from Edi Weitz to
656 use *default-database* for SQL-OUTPUT if no database is
657 explicitly passed to function.
658 * uffi/clsql-uffi-loader.lisp: Change load order to first try
659 plain name/type before attempting user-specified paths (patch
661 * uffi/ptrbits.c: New file to return number of bits in an pointer
662 * uffi/Makefile: use intbits to name .so file based on bit size.
663 Build both 32-bit and 64-bit libraries on 64-bit platform.
665 30 Nov 2006 Kevin Rosenberg <kevin@rosenberg.net>
667 * db-sqlite3/sqlite3-sql.lisp: Commit patch from Edi Weitz fixing
670 16 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
672 * db-postgresql/postgresql-sql.lisp: Remove
673 uffi:convert-foreign-to-native wrapper since using cstring for
676 16 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
678 * db-postgresql/postgresql-api.lisp: Fix UFFI return type for
679 PQresultErrorField foreign function.
681 16 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
683 * doc/intro.xml: Update supported platforms.
684 * db-postgresql/postgresql-{package,api,sql}.lisp: Apply
685 changes from Andew Golding to use a more-specific error code
686 from PostgreSQL than the generic fatal error code of the result set.
688 03 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
689 * sql/syntax.lisp: Commit patch from Marcus Pearce to improve
690 readtable modifications
692 02 Oct 2006 Kevin Rosenberg <kevin@rosenberg.net>
693 * sql/syntax.lisp: Check that original reader syntax functions
694 stored before trying to restore them.
696 20 Sep 2006 Kevin Rosenberg <kevin@rosenberg.net>
697 * sql/syntax.lisp: Apply patch from Marcus Pearce to correctly
698 display sql reader syntax.
700 06 Sep 2006 Kevin Rosenberg <kevin@rosenberg.net>
701 * uffi/clsql-uffi-loader.lisp, db-mysql/mysql-loader.lisp: Change from using *features*
702 to decide on 64-bit platform and check size of most-positive-fixnum instead.
703 Needed to support clisp amd64.
705 03 Sep 2006 Kevin Rosenberg <kevin@rosenberg.net>
707 * sql/metaclasses.lisp: Rework slot type's to be more AMOP
708 compatibile. Add warning for a metaclass condition that should
710 * sql/time.lisp: Fixed symbol case inconsistency causing problem
711 in AllegroCL's modern lisp. First sign of bug noted by
712 Joel Reymond on clsql-devel.
713 * clsql.asd: Make time.lisp depend on utils.lisp
715 31 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
716 * db-mysql/mysql-loader.lisp: Apply patch from Marcus Pearce to push
717 *library-file-dir* to CLSQL's library path.
719 30 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
720 * Version 3.7.0: New platforms supported: SBCL/Win32, CLISP/Win32, CLISP/Cygwin,
721 CLISP/Linux x86, CLISP/Linux amd64, OpenMCL amd64. CLISP support requires the
722 latest development versions of CLISP, cffi, and cffi-uffi-compat packages.
723 * Makefile.common: Add OS detection
724 * uffi/make.sh, db-mysql/make.sh: Remove files
725 * uffi/Makefile, db-mysql/Makefile: Add support for cygwin compilation.
726 Refactor to remove need to make.sh shell scripts.
727 * clsql.asd: Add support for loop extensions for clisp. Support clisp via cffi.
728 * sql/loop-extension.lisp: Define loop-record-iteration-path in CLSQL-SYS
729 package rather than CL-USER. Add support for ansi-loop on clisp.
730 * sql/ansi-loop.lisp: New file to support iteration on clisp.
731 * db-mysql/mysql-api.lisp: Remove old mysql C API functions that no
732 longer exist in the mysql client library.
733 * doc/ref-fdml.lisp: Correct default field-type.
734 * sql/expressions.lisp: Use database-output-as-type if value exists for boolean output.
735 Fixed bug with noted with MySQL 5.0.24 and boolean values.
737 28 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
739 * sql/oodml.lisp: Remove high debugging level declaration
741 14 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
743 * sql/generic-postgresql.lisp: Fix assumption that postgres user id
744 is always 1. Fixes problem noted with PostgreSQL 8.1.
746 12 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
748 * sql/generic-postgresql.lisp: Add slot for has-table-pg_roles to
749 lazily cache if pg_roles tables exist. Selectively use SQL from
750 Joel's previous patch if pg_roles table exists. Should now work
751 with both postgresql 7.4 and 8.x.
753 12 Aug 2006 Kevin Rosenberg <kevin@rosenberg.net>
755 * clsql.asd: Add support for c:\etc\clsql-init.lisp as possible
756 local initialization file
757 * db-mysql/mysql-loader.lisp: Remove former method of using pathnames
759 * db-odbc/odbc-api.lisp: Work-around Allegro/Windows FFI bug
760 that generates incorrect integer return type
761 * sql/generic-postgresql.lisp: Revert patch from Joel Reymont since
762 it fails on versions of postgresql that lack the pg_role table
764 07 Jul 2006 Kevin Rosenberg <kevin@rosenberg.net>
766 * sql/transactions.lisp: Important typo fix from Alexey Antipov
767 for database-start-transaction
769 04 Jul 2006 Kevin Rosenberg <kevin@rosenberg.net>
771 * db-postgresql/postgresql-sql.lisp: Apply patch from Vladimir Sekissov
772 to close connection when failing to connect to database.
773 * sql/generic-postgresql.lisp: Apply patch from Joel Reymont
774 to avoid dropping system views.
775 * sql/oodml.lisp: Apply patch from Joel Reymont to avoid listify
776 a nil value [patch sponsored by Flektor]
777 * clsql-uffi.asd, uffi/make.sh: Patch from Richard Kreuter
778 for netbsd compilation
780 15 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
781 * doc/ref-ooddl.xml: Add documentation for :db-reader and :db-writer
782 slots for def-view-class macro [as reported missing by Thomas Fischbacher].
784 09 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
785 * db-postgresql-socket/postgresql-socket-api.lisp:
786 Apply patch from Marko Kocic adding the socket creation
787 function needed for CLISP.
789 08 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
790 * Version: 3.6.0 (requires UFFI v1.5.11 or greater)
791 * db-oracle/metaclasses.lisp: Patch from James Bielman for
792 checking slot constraints.
793 * db-oracle/oracle-{api,sql}.lisp: Avoid dead pointers on loading
794 saved openmcl images (based on patch from James Bielman)
796 06 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
797 * doc/ref-fdml.xml: Documentation patch from Marcus Pearce for limit keyword
799 03 May 2006 Kevin Rosenberg <kevin@rosenberg.net>
801 * sql/time.lisp: Apply patch from Aleksandar Bakic to extended
802 duration parsing and unparsing to include year and month.
803 * clsql-uffi.asd, uffi/clsql-uffi-loader.lisp: Apply patch from Nathan Bird
804 improving library search on Windows platform.
805 * doc/ref-fdml.xml, /doc/TODO, tests/test-fdml.lisp, tests/test-init.lisp:
806 Apply patch from Marcus Pearce documenting and testing :limit and :offset for SELECT
808 20 Mar 2006 Kevin Rosenberg <kevin@rosenberg.net>
810 * clsql-postgresql-socket.asd,
811 * db-postgresql-socket/postgresql-socket-package.lisp:
812 Use the cl-md5 package on all platforms. Based on report
815 09 Mar 2006 Kevin Rosenberg <kevin@rosenberg.net>
817 * uffi/make.sh, db-mysql/make.sh: Add GNU uname
819 28 Feb 2006 Kevin Rosenberg <kevin@rosenberg.net>
821 * sql/metaclasses.lisp: Apply patch from Friedrich Dominicus to
822 fix accessor for new versions of SBCL
823 * db-oracle/oracle-sql.lisp: Apply patch from James Bielman
824 to improving parsing of time.
825 * db-db2/db2-constants.lisp: Change NULL_HANDLE has suggested
827 * db-oracle/oracle-dbi.lisp: Add support for SQL BIT type
828 as noted by Russ Tyndall.
830 16 Jan 2006 Kevin Rosenberg <kevin@rosenberg.net>
832 * sql/time.lisp: Commit patch from Aleksandar Bakic
833 to properly handle destructive flag
834 * db-postgresql-socket/postgresql-socket-api.lisp: Apply patch
835 from Steven Harris for socket files with SBCL.
836 * sql/pool.lisp: Apply patch from Vladimir Sekissov so that
837 new connections added to the pool do not become the *default-database*
838 * sql/connect.lisp: Optionally set *default-database* for pooled
839 connection when make-default is generalized true.
841 23 Dec 2005 Kevin Rosenberg <kevin@rosenberg.net>
843 * sql/expressions.lisp: Ensure table names are properly escaped
844 before comparing -- fixes bug reported by Asbjørn Bjørnstad
847 02 Dec 2005 Kevin Rosenberg <kevin@rosenberg.net>
848 * sql/generic-postgresql.lisp: improved decoding of table attribute
849 parameters [from Vladimir Sekissov]
850 * sql/metaclasses.lisp: check that metaclass is standard-db-class or
851 it's subclass to prevent adding standard-db-object to supers if
852 somebody in the path has it already when metaclass inherited from
853 standard-db-class. [from Vladimir Sekissov]
855 26 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
857 * tests/test-init.lisp, tests/test-fddl.lisp, tests/test-fdml.lisp,
858 * db-odbc/odbc-api.lisp, db-odbc/odbc-ff-interface.lisp,
859 * db-odbc/odbc-package.lisp, db-odbc/odbc-constants.lisp
860 * db-odbc/odbc-dbi.lisp, db-odbc/odbc-sql.lisp
861 * sql/fddl.lisp, sql/generic-odbc.lisp, sql/db-interface.lisp
862 * sql/transaction.lisp, sql/package.lisp, sql/time.lisp
863 Commit patch from Dominic Robinson providing support for
865 * doc/csql.lisp: Fix typo in slot name
867 24 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
869 * sql/time.lisp: Commit patch from Aleksandar Bakic for
870 correct handling of decode-time usec value
871 * clsql-mysql.asd: Commit patch from Harald Hanche-Olsen to
872 correct the name of the shared library file.
874 16 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
876 * sql/metaclasses.lisp: Avoid calling change-class on
877 effective-slot-definitions on sbcl to conform to sbcl 0.9.6.38
880 15 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
882 * sql/expressions.lisp: Patch from James Biel to add subselects
884 14 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
885 * Version 3.4.4 [ Requires UFFI 1.5.7+]
886 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
887 to fix lifetime of foreign strings for Oracle calls
889 13 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
891 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
892 to improve performance
894 12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
896 * clsql-uffi.asd: Patch from James Biel improving loading
897 * db-oracle/oracle-{api,sql}.lisp: Patch from James Biel
898 to support 64-bit lisps
900 12 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
902 * sql/expressions.lisp: Escape numbers to SQL strings
905 11 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
906 * Version 3.4: Add MySQL 5 support
907 * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
908 * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5
909 * doc/mysql-macosx-notes.txt: New document from Martin Brooks
911 7 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
912 * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL
914 * BUGS: Added report for update-object-joins by Aleksandar Bakic
916 4 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>
917 * Version 3.3.4 [UFFI >= 1.5.5 needed]
918 * db-odbc/odbc-api.lisp: Apply patch from Yaroslav Kavenchuk
919 to add missing #\' character.
920 * clsql.asd: Add support for CLSQLINIT environmental variable,
921 based on patch from Yaroslav Kavenchcuk. New version of UFFI
924 30 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
926 * sql/oodml.lisp: Apply patch from Drew Crampsie to fix
927 update-objects-joins when using the :target-slot attribute
929 26 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
931 * sql/expressions.lisp: Avoid parenthesis on multiple group-by fields
932 as noted by Harald Hanche-Olsen.
933 * tests/test-syntax.lisp: Add test for multiple field group-by
935 25 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
937 * sql/time.lisp: Commit patch from Alan Shields to
938 display escape string on wall-time display only when *print-escape*
941 11 Oct 2005 Kevin Rosenberg <kevin@rosenberg.net>
942 * sql/metaclasses.lisp: Commit patch from Will to
943 properly set db-reader slot in effective-slot-definition
944 * sql/expressions.lisp: Commit patch from Alan Shields
945 adding make-load-form for sql-relational-exp
946 * sql/generic-postgresql.lisp: Commit patch from Aleksandar Bakic
947 adding support for new NUMBER type
949 17 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
951 * sql/time.lisp: Apply patch from Alan Shields adding DATE type.
952 * doc/ref-ooddl.xml: Documentation of new type
953 * notes/add-type-hints.txt: New file from Alan Shields
954 * sql/fddl.lisp: Add owner keyword to drop-table as suggested
956 * db-postgresql-socket/postgresql-socket-sql.lisp: Fix database-probe
957 as noted by Francis Leboutte. Similar fix applied to db-mysql and
959 * sql/expressions.lisp: Allow string table names for output as
960 contributed by Francis Leboutte.
961 * examples/clsql-tutorial.lisp: Support :postgresql-socket as noted
964 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
966 * doc/into.xml: Change download from ftp to http protocol
968 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
970 * db-oracle/oracle-sql.lisp: Correction for v3.2.2 changes by
973 08 Sep 2005 Kevin Rosenberg <kevin@rosenberg.net>
975 * db-oracle/oracle-sql.lisp: Add check for zero increment as
976 suggested by Edi Weitz. Add missing database-sequence-last function
977 as noted and tested by Edi Weitz. Ensure that UFFI buffer is freed
978 in handle-oci-error. Add unwind-protect to sql-stmt-exec. Free UFFI
979 stmthp object when query cursor is freed with OCI.
981 22 Aug 2005 Kevin Rosenberg <kevin@rosenberg.net>
982 * uffi/clsql-uffi-loader.lisp: Commit patch from astor@pvv.ntnu.no to
983 display search path when error occurs loading foreign library.
985 05 Jul 2005 Kevin Rosenberg <kevin@rosenberg.net>
987 * doc/appendix.xml: Incorporate Edi Weitz's notes into documentation
988 with changes to support case-sensitive lisp implementations. Add
989 paragraph on using /etc/clsql-init.lisp site initialization file.
990 * clsql.asd: Load file /etc/clsql-init.lisp, if it
991 exists, after package is loaded to set site-specific configuration
993 2005-06-24 Edi Weitz <edi@agharta.de>
994 * sql/db-interface.lisp: Added new special variable
995 *FOREIGN-LIBRARY-SEARCH-PATHS* and function PUSH-LIBRARY-PATH to
997 * sql/package.lisp: Export these.
998 * uffi/clsql-uffi-loader.lisp: Used new variable; changed order of
1000 * db-mysql/mysql-loader.lisp: Changed order of libs.
1002 09 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
1003 * Version 3.2.0: REQUIRES UFFI VERSION 1.4.38 OR HIGHER
1004 * clsql-mysql.asd: Renamed clsql/mysql interface library from
1005 mysql to clsql_mysql
1006 * clsql-uffi.asd: Renamed clsql/uffi interface library from
1008 * uffi/clsql_uffi.c: Renamed from uffi.c
1009 * db-mysql/clsql_mysql.c: Renamed from mysql.c
1010 * db-mysql/Makefile, db-mysql/Makefile.msvc, db-mysql/mysql-loader.lisp: Rename shared library
1011 * uffi/Makefile, uffi/Makefile.msvc, uffi/uffi-loader.lisp: Rename shared library
1012 * db-*/*-loader.lisp: Commit big patch from Edi Weitz to remove
1013 absolute pathnames when searching for foreign libraries.
1014 foreign library loading.
1016 07 Jun 2005 Kevin Rosenberg <kevin@rosenberg.net>
1018 * db-mysql/mysql-api.lisp: Commit patch from Espen Wiborn
1019 to support UTF-8 on sbcl unicode.
1021 18 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
1023 * sql/time.lisp: Fix bug in roll that caused failure in test suite
1025 17 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
1027 * sql/oodml.lisp: Properly handle when db-writer is NIL
1029 11 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
1030 * sql/expressions.lisp: Avoid using simple-string declaration when
1031 a non-simple string may be encountered. [issue noted by
1032 will@cesmail.net] Add a simple-string declaration for a local
1035 06 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
1036 * sql/oodml.lisp: Change db-writer and db-reader processing to accept
1037 a symbol as well as function to serve as a function designator
1038 [issue noted by will@cesmail.net]
1040 05 May 2005 Kevin Rosenberg <kevin@rosenberg.net>
1042 * sql/time.lisp: Fix error in submitted patch which caused error
1043 in timestrings with 19 or less characters.
1045 27 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1047 * db-postgresql-socket/postgresql-api.lisp: Commit patch from Tim Howe
1048 to fix read-socket-sequence on non-sb-unicode sbcl.
1050 26 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1052 * sql/time.lisp: Commit patch from Daniel Lowe which adds support
1053 for fractional seconds which is required by PostgreSQL
1054 * db-postgresql/postgresql-loader.lisp: Add library path for Windows
1056 25 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1057 * sql/csql.lisp: Update URL for "SQL for Web Dummies" [Sean Champ]
1059 24 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1061 * sql/syntax: Commit patch from Alan Shields to supress reader
1062 macros when *read-supress* is T.
1064 13 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1066 * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
1067 from Janis Dzerins to support unicode on SBCL
1068 * sql/syntax: Commit patch from Alan Shields to improve reporting
1069 of invalid syntax statements.
1071 06 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1073 * db-mysql/mysql-sql.lisp: Add port to connection specification
1074 based on patch from Dave Watson
1075 * doc/appendix.xml: Document MySQL port parameter to connection spec
1077 03 Apr 2005 Kevin Rosenberg <kevin@rosenberg.net>
1079 * sql/time.lisp: Patch from Keith James for parsing ISO-8601 timestamps
1081 18 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
1082 * sql/oodml.lisp: Add missing database argument [Patch from
1085 03 Mar 2005 Kevin Rosenberg <kevin@rosenberg.net>
1086 * sql/oodml.lisp: Improve database priority in
1087 update-records-from-instance [Patch from Walter C. Pelissero]
1089 17 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
1091 * sql/package.lisp: Export database-reconnect from clsql-sys
1093 08 Feb 2005 Kevin Rosenberg <kevin@rosenberg.net>
1094 * sql/oodml.lisp: Use explicit database in fault-join-target-slot
1095 [Patch from Walter Pelissero]
1097 29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
1098 * db-postgresql/postgresql-loader.lisp: Add additional
1099 directories to Fink on darwin [patch from Cyrus Harmon].
1101 29 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
1103 * sql/oodml.lisp: Clear view instance cache when delete-instance-records
1104 is invoked [suggested by Alan Shutko].
1105 * uffi/clsql-uffi-loader.lisp: Improvements for loading with SBCL X86-64
1106 * sql/metaclasses.lisp: Don't change case of a :base-table string supplied
1107 to def-view-class [fix suggested by Fred Gilham].
1109 25 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
1110 * tests/*.lisp: Change Vladamir to Vladimir per Cyrus Harmon's
1112 * sql/utils.lisp: Fix unnecessary consing noted by Fred Gilham.
1113 * doc/*.xml: Fix spelling of Vladimir
1115 24 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
1116 * doc/bookinfo.xml, doc/csql.xml, doc/intro.xml: Update links
1117 now that LispWorks is an independant company [noted by
1120 22 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
1121 * db-sqlite/sqlite-sql.lisp, db-sqlite3/sqlite3-sql.lisp:
1122 Better support for 64 bit environments
1124 05 Jan 2005 Kevin Rosenberg <kevin@rosenberg.net>
1126 * sql/metaclass.lisp: Make t the default value of :set
1127 [noted by Cyrus Harmon]
1129 28 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
1131 * uffi/clsql-uffi.lisp: Add support for unsigned integers
1132 * db-mysql/mysql-sql.lisp: Add support for detecting/marking
1133 unsigned integers. Apply patch from Yannick Gingras to
1134 implement database-sequence-last.
1136 26 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
1137 * doc/ref-fdml.lisp: Fix variable tag name to varname
1138 [noted by Eduardo Munoz]
1139 * db-mysql/mysql-loader.lisp: Handle library paths for 64-bit systems
1141 06 Dec 2004 Kevin Rosenberg <kevin@rosenberg.net>
1143 * sql/ooddl.lisp: Accept patch from Klaus Harbo for
1144 update-object-joins.
1145 * sql/metaclass.lisp: Remove unnecssary (and runtime error
1146 causing) change-class invocation when running on CLISP.
1147 * db-mysql/mysql-api.lisp: Commit patch from Paul Werkowski
1148 to fix structure name.
1149 * sql/database.lisp: More specific error message with trying
1150 to use a database value of NIL.
1151 * sql/expressions.lisp: Accept a string for the table name
1152 in (sql-output sql-delete database) [suggested by Ed Symanzik].
1154 11 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
1156 * sql/generic-postgresql.lisp: Commit patch from Chris Capel to
1157 ignore columns which have been dropped.
1158 * clsql-postgresql-socket.asd, db-postgresql-socket/postgresql-socket-package.lisp:
1159 Use sb-md5 package on SBCL, recommended by Chris Capel
1161 09 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
1162 * Version 3.1.0 released: New SQLite3 backend by Aurelio Bignoli
1163 * doc/appendix.xml: Document SQLITE3 backend, patch by Aurelio Bignoli
1164 * sql/operations.lisp: Add lower and upper SQL functions [Daniel Lowe].
1166 08 Nov 2004 Kevin Rosenberg <kevin@rosenberg.net>
1167 * sql/expressions.lisp: Fix slot name [thanks to Daniel Lowe]
1169 31 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1170 * clsql-sqlite3, db-sqlite3/*: NEW BACKEND
1171 contributed by Aurelio Bignoli
1173 23 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1174 * sql/oodml.lisp: Commit patch from Walter Pelis
1175 to use an object's database for a select on its slot.
1177 20 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1178 * uffi/uffi.c, uffi/clsql-uffi.lisp: Commit patch from
1179 Aurelio Bignoli to fix negative 64-bit integers
1181 07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1182 * db-mysql/mysql.c: Fix parameters in bind_param call
1184 07 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1185 * uffi/clsql-uffi.lisp: Add support for :blob result-type
1186 * db-mysql/mysql-sql.lisp: Add support for :blob
1189 04 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1190 * db-mysql/mysql-sql.lisp, db-db2/db2-sql.lisp: Add
1191 missing quotes for types in code that is still in development
1192 (thanks to Joerg Hoehle)
1194 03 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1195 * Version 3.0.8 released
1196 * db-sqlite/sqlite-*.lisp: Apply patch from
1197 Aurelio Bignoli with improvements
1199 01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1200 * multiple: Apply patch from Joerg Hoehle with multiple
1203 01 Oct 2004 Kevin Rosenberg <kevin@rosenberg.net>
1204 * Version 3.0.7 released
1205 * sql/oodml.lisp, sql/package.lisp, db-mysql/mysql-objects.lisp:
1206 Add support for mediumint.
1207 * sql/metaclass.lisp: Rework CLISP MOP handling
1208 * sql/ooddl.lisp: Work-around to have CLISP finalize standard-db-class
1210 28 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1211 * sql/metaclass.lisp: Support CLISP's attribute name
1212 for the type field in direct class slots
1214 27 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1215 * Version 3.0.6 released
1216 * BUGS: New file. Document suspected SIGPIPE
1217 interaction between SBCL and libpq used in
1219 * doc/ref-fdml.lisp: Document the :caching and :refresh
1220 keywords of the SELECT function.
1221 * doc/ref-ooddml.lisp: Document the new *default-caching*
1223 * sql/package.lisp: Export *default-caching*
1224 * sql/oodml.lisp: Use *default-caching* to
1225 control default caching behavior.
1227 21 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1228 * Version 3.0.5 release
1229 * doc/appendix.xml: Add note about loading Oracle8 version
1230 * db-oracle/oracle-loader.lisp: Support Oracle8 based on
1231 data from David Young.
1233 10 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1234 * doc/Makefile, doc/catalog-darwin.xml: Apply
1235 patch from Cyrus Harmon for building docs on Mac OS X
1236 * sql/package.lisp: Add new (pre-release) clisp MOP package
1238 09 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1239 * Version 3.0.4 Release
1240 * multiple: Remove superfluous quotes in UFFI def-type
1241 and def-foreign-type forms.
1243 07 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1244 * Version 3.0.3 Release
1245 * db-postgresql-socket/postgresql-socket-api.lisp: Commit patch
1246 from Tagore Smith to call force-output after sending authentication
1247 * db-odbc/odbc-api.lisp: Move ODBC v3 conversons
1248 * db-odbc/odbc-sql.lisp: Load mysql or postgresql package when connecting
1249 to a database of that type so that functions that indicate capabilities of
1250 database are available.
1252 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1253 * db-odbc/odbc-api.lisp: More conversions to ODBC v3
1255 02 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1256 * Version 3.0.2 Release
1257 * TODO: Add note about ODBC on Windows
1258 * db-odbc/odbc-loader.lisp: Add /winnt/system32/ to
1260 * db-odbc/odbc-ff-interface.lisp: Change the return type
1261 of SQLSetEnvAttr to :short
1263 02 Sep 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1264 * examples/clsql-tutorial.lisp: added missing initarg for the COMPANYID
1265 slot of the employee View Class definition [reported by Franz Deuzer].
1267 01 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
1268 * Version 3.0.1 Release
1269 * tests/test-init.lisp: Add second join class to employee-address
1270 to test a class with two join slots.
1271 * sql/oodml.lisp: Fix find-all function for a class with multiple
1273 * TODO: Remove need to test/fix multiple join classes
1275 27 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
1276 * db-mysql/Makefile, db-mysql/mysql-loader.lisp: accept patch
1277 from Jon Buffington for file locations on Darwin.
1279 17 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
1280 * sql/db-interface.lisp: Improve messages when functions
1281 are passed a database object, but the method is not specialized
1282 for that database type.
1283 * sql/metaclasses.lisp: Fix inline declaration (reported by
1286 14 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
1287 * TODO: Add bug report about SQL generation with a table
1288 containing two join slots.
1289 * sql/oodml.lisp: Add optional size to VARCHAR type
1291 3 Aug 2004 Kevin Rosenberg <kevin@rosenberg.net>
1292 * Version 3.0.0 Release
1293 * sql/expressions.lisp: Change declaration that
1294 caused error on openmcl
1295 * db-aodbc/aodbc-sql.lisp: Fix storage location
1296 of odbc connection. Specialize database-query since
1297 dbi's :types keyword is different than generic-odbc's
1298 :result-types keyword
1299 * sql/db-interface.lisp: Add warnings for methods
1300 not specialized by a db backends
1301 * tests/test-fddl.lisp: Fix case of symbols to support
1302 case-sensitive Allegro
1303 * db-oracle/oracle-sql.lisp: Rework errbuf in handle-oci-error
1304 * tests/test-init.lisp: Note that odbc driver for postgresql
1305 doesn't properly handle table ownership
1306 * LATEST-TEST-RESULTS: update with version 3.0.0
1308 1 Aug 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1309 * sql/expressions.lisp: conditionalise escaping of backslash in
1310 generated SQL strings on backend.
1311 * tests/test-fdml.lisp: test for escaping of backslash.
1312 * sql/oodml.lisp: minor tidying in FIND-ALL.
1314 26 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1315 * NEWS: Initial 3.0 announcement draft
1316 * README: Expand acknowledgements of incorporated projects
1317 * CONTRIBUTORS: Further document Marcus Pearce contributions
1319 23 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1320 * sql/oodml.lisp: add DATABASE-OUTPUT-SQL-AS-TYPE method specialisation
1321 to print floats with the exponent markers removed.
1322 * tests/test-oodml.lisp: add tests for updating records with floats.
1324 22 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1325 * db-oracle/oracle-sql.lisp: enable :OWNER :ALL in DATABASE-LIST-* for
1326 CommonSQL compatibility.
1327 * tests/test-init.lisp: skip test :FDDL/TABLE/6 on Oracle since
1328 this column constraint syntax is not supported.
1329 * tests/test-fddl.lisp: change column indexed in test :FDDL/INDEXES/2
1330 from EMPLID to LAST_NAME since Oracle complains that EMPLID is already
1333 17 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1334 * doc/ref-fdml.xml: document CACHE-TABLE-QUERIES.
1335 * tests/test-fdml.xml: add test for CACHE-TABLE-QUERIES.
1336 * doc/ref-ooddl.xml: minor changes to syntax and examples entries
1338 * doc/ref-oodml.xml: add examples for OODML.
1339 * sql/oodml.lisp: ensure SELECT passes on its REFRESH argument
1341 * sql/metaclasses.lisp: update docstrings.
1342 * tests/test-init.lisp: change :db-constraints for emplid to
1343 (:not-null :unique) as a temporary test for multiple column constraints
1345 * tests/test-oodml.lisp: add tests for *DB-AUTO-SYNC* and
1346 return type of (SETF SLOT-VALUE-USING-CLASS).
1347 * TODO, doc/TODO: remove items done.
1350 16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1351 * sql/oodml.lisp: on Lispworks, use weak valued hash tables for
1353 * sql/expressions.lisp: Fix SQL generation for the symbol NIL.
1355 16 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1356 * sql/expressions.lisp: reactivate caching of generated SQL strings.
1357 Move methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY
1358 here from sql/fdml.lisp. Rationalise behaviour of SQL-OUTPUT,
1359 OUTPUT-SQL and DATABASE-OUTPUT-SQL.
1360 * sql/fdml.lisp: remove disabled method ADD-STORAGE-CLASS. Move
1361 methods for DATABASE-OUTPUT-SQL, OUTPUT-SQL and SQL-HASH-KEY to
1362 sql/expressions.lisp.
1363 * sql/ooddl.lisp: replace call to DATABASE-OUTPUT-SQL in
1364 DATABASE-PKEY-CONSTRAINT with call to SQL-OUTPUT.
1365 * sql/generics.lisp: add docstrings.
1367 15 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1369 * db-oracle/oracle-sql.lisp: Remove OpenMCL specific
1370 code in favor of fixing UFFI with James Bielman's patch
1372 14 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1374 * db-oracle/oracle-sql.lisp: Apply patch for OpenMCL/OSX
1377 14 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1378 * README, INSTALL: update URLs. Minor updates to descriptions.
1379 * tests/README: remove stuff about editing contexts.
1381 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1382 * db-oracle/oracle-objects.lisp: Change *default-varchar-length* to
1383 *default-string-length*
1385 12 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1386 * tests/test-syntax.lisp, tests/test-fdml.lisp: add tests for escaping
1388 * tests/test-fddl.lisp: add tests for column and table constraints
1389 in CREATE-TABLE. Add test for OWNER keyword parameter to
1390 LIST-TABLES (assuming same underlying machinery in other FDDL
1392 * tests/test-init.lisp: restrict above test to postgresql and oracle.
1394 12 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1395 * db-sqlite/sqlite-sql.lisp: Fix condition as reported by Aurelio
1398 11 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1399 * sql/oodml.lisp, sql/package.lisp, doc/ref-ooddl.lisp, db-mysql/mysql-objects.lisp: Add tinyint type
1401 10 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1403 * doc/*.xml: documentation additionals and fixes so
1404 that docbook passes xmllint.
1406 9 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1408 * sql/fdml.lisp: Apply patch from Kim Minh Kaplan
1409 to change escaping of single quotes. Mild optimizations
1410 for escaped string output.
1411 * doc/ref-ooddl.lisp: documentation additions
1412 * doc/ref-oodml.lisp: Add purpose to functions
1413 * TODO: Add need to test single quote escaping
1415 7 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1416 * doc/ref-ooddl.xml, doc-ref-oodml.xml: documentation additions
1417 * sql/ooddl.lisp: Added SMALLINT type
1418 * sql/generic-postgresql.lisp: Added INT2 as SMALLINT type
1419 * db-mysql/mysql-objects.lisp: Added SMALLINT type
1420 * sql/package.lisp: Export SMALLINT
1421 * sql/expressions.lisp: Add MYSQL's UNSIGNED and ZEROFILL as
1424 6 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1425 * sql/expressions.lisp: add AUTO-INCREMENT and UNIQUE to the
1426 recognised column constraints for CREATE-TABLE and the :DB-CONSTRAINTS
1427 View Class slot option.
1428 * sql/ooddl.lisp: fix bug preventing the :DB-CONSTRAINTS View Class
1429 slot option accepting a list of constraints [reported by Travis Cross].
1430 * doc/ref-fddl.xml: add some examples of specifying column and
1431 table constraints to the documentation for CREATE-TABLE.
1432 * TODO: add note about adding tests for table/column constraints. Add
1433 optimisation note about using cached attribute types in insert/update
1436 3 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1437 * doc/appendix.xml: add notes about idiosyncrasies/unsupported
1438 features and so on the documentation for each backend.
1439 * doc/TODO: remove items done.
1440 * doc/ref-transaction.xml: add note in introduction about
1441 autocommit mode as a difference from CommonSQL.
1442 * doc/ref-syntax.xml: add notes about SQL syntax state functions
1443 being macros in CLSQL. Add note about SQL operators which are
1446 2 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1447 * Version 2.11.12 released
1448 * doc/ref-recording.xml: document SQL I/O recording.
1449 * doc/ref-prepared.xml: new file for documenting prepared statements.
1450 * doc/clsql.xml: comment out include for large object and CLSQL-SYS
1452 * doc/ref-conditions.xml: complete documentation of condition system.
1453 * doc/global-index.xml: add symbols from condition system and remove
1454 those from LOB and prepared statement APIs.
1455 * doc/ref-fdml.xml: complete documentation of FDML.
1456 * doc/glossary.xml: add View Class.
1457 * doc/TODO: remove items done.
1458 * sql/conditions.lisp: make SQL-CONDITION a parent of SQL-ERROR.
1459 * sql/package.lisp: remove FOR-EACH-ROW from exports list. Export
1460 additional slot accessors for condition classes.
1462 1 Jul 2004 Kevin Rosenberg <kevin@rosenberg.net>
1463 * doc/ref-ooddl.lisp: Add documentation
1464 * doc/ooddl.lisp: Move *DEFAULT-VARCHAR-LENGTH* from oodml.lisp
1465 and rename to *DEFAULT-STRING-LENGTH*. Add docstring.
1466 * doc/oodml.lisp: Rename references to new name of
1467 *DEFAULT-STRING-LENGTH*
1469 1 Jul 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1470 * doc/ref-transaction.xml: document transaction handling.
1471 * sql/transaction.lisp: ensure that COMMIT, ROLLBACK and
1472 START-TRANSACTION return NIL as per the CommonSQL spec. Modify
1473 ADD-TRANSACTION-{ROLLBACK|COMMIT}-HOOK such that a database is
1474 passed as a keyword argument defaulting to *DEFAULT-DATABASE*.
1477 30 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1478 * doc/ref-fdml.xml: document the FDML.
1479 * doc/ref-fddl.xml: move documentation for TRUNCATE-DATABASE here.
1480 * sql/ooddl.lisp: moved *default-varchar-length* to here from
1481 oodml.lisp and renamed to *default-string-length*
1483 23 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1484 * sql/oodml.lisp: Add keyword :transactions to def-view-from-class
1485 to allow specifying transactionless table creation
1486 * doc/ref-oodml.lisp: Add new keyword to signature of
1489 18 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1491 * sql/expressions.lisp: when removing duplicate table identifiers
1492 in the FROM clause of a query, check both table name and alias
1494 * sql/fdml.lisp: remove DESCRIBE-TABLE.
1495 * sql/db-interface.lisp: remove generics DESCRIBE-TABLE and
1496 DATABASE-DESCRIBE-TABLE.
1497 * sql/package.lisp: remove DESCRIBE-TABLE, DATABASE-DESCRIBE-TABLE
1498 and LIST-TABLE-INDEXES.
1499 * sql/generic-postgresql.lisp: add reader conditional #+nil for
1500 DATABASE-DESCRIBE-TABLE and comment about its uses for
1501 re-implementing LIST-ATTRIBUTE-TYPES with a single SQL query
1502 returning type info for all attributes.
1503 Fix DATABASE-SEQUENCE-LAST.
1504 * sql/fddl.lisp: remove LIST-TABLE-INDEXES and redefine
1505 LIST-INDEXES with additional keyword parameter :ON.
1506 * tests/test-fddl.lisp: replace LIST-TABLE-INDEXES in :fddl/index/3
1507 with LIST-INDEXES (with :ON parameter).
1508 * doc/global-index.xml: remove DESCRIBE-TABLE and LIST-TABLE-INDEXES.
1509 * doc/ref-connect.xml: minor tidying.
1510 * doc/ref-fddl.xml: document the FDDL.
1511 * doc/TODO: removed items done. Moved note about transaction handling
1513 * TODO: move note about transaction handling to doc/TODO. Added
1514 optimization note about LIST-ATTRIBUTE-TYPES and LIST-INDEXES.
1516 13 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1518 * sql/syntax.lisp: updated docstrings.
1519 * sql/package.lisp: exported DATABASE-NAME-FROM-SPEC from CLSQL
1521 * sql/database.lisp: add docstrings for CREATE-DATABASE,
1522 DESTROY-DATABASE, TRUNCATE-DATABASE and LIST-DATABASES. Replace
1523 CLSQL-GENERIC-ERROR signalled in RECONNECT with SQL-CONNECTION-ERROR.
1524 * doc/ref-syntax.xml, doc/global-index.xml: minor tidying.
1525 * doc/ref-connect.xml: document connection/initialisation.
1526 * doc/ref-fdml.xml: move TRUNCATE-DATABASE reference entry here.
1527 * doc/TODO: remove items done.
1528 * Makefile: add db-oracle to to SUBDIRS.
1530 13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1531 * sql/oodml.lisp: Add new serialization functions:
1532 WRITE-INSTANCE-TO-STREAM and READ-INSTANCE-FROM-STREAM
1533 * sql/expressions.lisp: Avoid duplicate FROM names when selecting
1534 from a table that has more than one primary index.
1535 * sql/conditions.lisp: Fix printing of closed-database error
1537 13 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1539 * sql/conditions.lisp: Set initial slot value for message in SQL-WARNING
1540 * sql/transactions.lisp: Correctly set slots of SQL-WARNING
1542 12 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1543 * sql/package.lisp: export DATABASE-TYPE from CLSQL and subclasses
1544 of SQL-EXPRESSION from CLSQL-SYS.
1545 * sql/syntax.lisp: make error signalled in SQL-OPERATION an
1546 SQL-USER-ERROR. Make SQL-OPERATOR return just one value.
1547 * doc/Makefile: added Mandrake linux.
1548 * doc/catalog-redhat.xml, doc/catalog-mandrake.xml: new files.
1549 * doc/appendix.xml: fixed little typo (adsf).
1550 * doc/glossary.xml: removed closed-database and note about
1551 sql-expression, added some entries.
1552 * doc/ref-syntax.xml: documented the symbolic SQL syntax.
1554 10 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1556 * db-mysql/mysql-loader.lisp: Remove load of unnecessary zlib library
1557 * multiple: Add generalized-boolean type as requested by
1559 * TODO: Added need for test of generalized-boolean
1561 9 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1562 * Version 2.11.7 released
1563 * uffi/clsql-uffi-loader.lisp: Apply patch from Edi Weitz
1564 for loading with clc-register-user-package. Remove personal
1565 directory from path lisp.
1566 * db-mysql/mysql-loader.lisp: Similar changes
1568 8 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1569 * Version 2.11.6 released
1570 * sql/oodml.lisp: Commit patch from Edi Weitz
1571 to fix symbol writing/reading
1572 * TODO: Add need for symbol slot test
1574 7 Jun 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1575 * sql/package.lisp: remove duplicate export of
1576 *CACHE-TABLE-QUERIES-DEFAULT*.
1577 * doc/ref-*.xml, doc/global-index.xml: new files documenting
1578 the CommonSQL compatible api.
1579 * tests/test-fdml.lisp: modified the test :fdml/transaction/3 to
1580 reflect changes in return values of WITH-TRANSACTION.
1582 04 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1583 * tests/README: Fix filename [reported by Bill Clementson]
1584 * sql/transactions.lisp: Apply return value patch from
1585 Edi Weitz for WITH-TRANSACTION
1586 * tests/README: Remove ptester package requirement (as noted
1589 03 Jun 2004 Kevin Rosenberg <kevin@rosenberg.net>
1590 * Version 2.11.5 released
1591 * examples/clsql-tutorial.lisp: Remove obsolete :nulls-ok attribute,
1592 Select connection-spec based on connection type. Bugs reported by
1594 * uffi/uffi.dll, uffi/uffi.lib: Recompile with Visual Studio 2003
1595 * db-mysql/mysql-loader.lisp: Update check for zlibwapi library
1596 name on Windows, add \bin\ directory to search path
1598 31 May 2004 Marcus Pearce <m.t.pearce@city.ac.uk>
1599 * db-odbc/odbc-sql.lisp: DB-TYPE replaced with DATABASE-TYPE in
1601 * sql/operations.lisp: substr now generates SUBSTR for use on
1602 Oracle; added a new operator SUBSTRING for use elsewhere. minus
1603 now generates MINUS for use on Oracle. Nvl signals an error if
1604 not called with exactly 2 arguments. Add concat function for use
1605 instead of the || operator on MySQL and Oracle.
1606 * sql/syntax.lisp: changed internal symbol for the || operator to
1608 * sql/expressions.lisp: removed redundant and unused functions
1609 GENERATE-SQL (cf. SQL-OUTPUT) and DATABASE-CONSTRAINT-DESCRIPTION
1610 (cf. MAKE-CONSTRAINTS-DESCRIPTION).
1611 * sql/generics.lisp: removed generic function for
1612 DATABASE-CONSTRAINT-DESCRIPTION (see above).
1613 * tests/test-syntax.lisp: modified/added tests according to changes
1614 in sql/operations.lisp.
1615 * tests/test-fdml.lisp: changed SUBSTR to SUBSTRING in test
1617 * sql/package.lisp: added the operators SQL-SUBSTRING, SQL-CONCAT-OP
1618 and SQL-USERENV to the shared exports list. Removed
1619 ROLLBACK-TRANSACTION, COMMIT-TRANSACTION, DATABASE-START-TRANSACTION,
1620 DATABASE-ABORT-TRANSACTION, DATABASE-COMMIT-TRANSACTION,
1621 TRANSACTION-LEVEL, TRANSACTION, RECORD-SQL-COMMAND and
1622 RECORD-SQL-RESULT from shared exports list.
1624 30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1625 * db-postgresql/postgresl-sql.lisp: Avoid computing
1626 result-types lisp when nil result-types. Return only
1627 one value when field-types nil.
1628 * db-mysql/mysql-sql.lisp: Simple queries now
1629 working with prepared statements.
1631 30 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1632 * Version 2.11.4: MySQL 4.1 now passes all tests
1633 * sql/package.lisp: Add API for prepared statments.
1634 * sql/fdml.lisp: Change implicit flatp processing
1635 for string map-query for greater CommonSQL conformance.
1636 Add high-high API for prepared statements.
1637 * tests/test-basic.lisp: Add test for map-query and
1639 * sql/transactions.lisp: Change name/semantics of
1640 autocommit to set-autocommit.
1641 * sql/generic-postgresql.lisp: Add support for
1642 prepared statements.
1643 * tests/test-internal.lisp: New file
1644 * sql/odbc-api.lisp: Update to using ODBC V3 protocol
1645 * clsql-mysql.asd, clsql-uffi.asd: Remove check and Common Lisp
1646 Controller invocation.
1647 * db-mysql/mysql-api.lisp: Add support for MySQL 4.1 field structure
1648 * sql/expressions.lisp: Avoid emitting double parenthesis when a
1649 function contains a subselect.
1651 27 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1653 * sql/ooddl.lisp: Commit patch from Edi Weitz fixing return
1654 type (setf slot-value-using-class)
1655 * TODO: add not that need a test case for the above fix
1656 * db-sqlite: Remove clisp support since clisp can not run CLSQL
1658 * db-oracle/oracle-sql.lisp: By default, use OCIEnvCreate as
1659 introduced in Oracle8. Leave older code selectable by a reader macro
1660 for Oracle7 and prior. Avoid use of OCIServerAttach since CLSQL
1661 uses OCILogon and does not the more complex session management.
1663 26 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1664 * sql/oodml.lisp: Commit universal-time typo patch from Edi Weitz
1665 * test/test-init.lisp: Add universal-time slot to person.
1666 * test/test-fddl.lisp: Add tests of universal-time slot
1667 * test/test-ooddl.lisp: Test universal-time slot in an object
1668 * TODO: Remove need for universal-time test
1669 * debian/rules, debian/control: Add cl-sql-oracle binary package
1670 * doc/appendix.xml: Add Oracle backend information
1671 * db-oracle/oracle-objects.lisp: Add database-get-type-specifier for
1672 universal-time. Convert BIGINT CLSQL type to CHAR SQL type
1673 * db-mysql/mysql-sql.lisp: Fix condition name to sql-connection-error
1674 * doc/ref-clsql.xml: Renamed from ref_clsql.xml. Change the documentation
1675 for map-query to reflect changed in arguments to be CommonSQL compatible.
1676 Updated old clsql conditions to new CommonSQL compatible conditions.
1678 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1679 * sql/oodml.lisp: (string n) now produces a CHAR field. Add new VARCHAR
1680 type. Added *default-varchar-length* rather than previous hard-coded
1681 varchar length. Remove 'simple-string and 'simple-base-string since they
1682 are subtypes of 'string.
1683 * db-oracle/oracle-sql.lisp: Use *default-varchar-length* rather than
1684 local hard-coded value.
1685 * sql/metaclasses.lisp: Convert specified type VARCHAR and (VARCHAR n) to Lisp
1686 type string. Convert specified-type (CHAR n) to string. Convert specified-type
1687 CHAR to lisp type character.
1688 * sql/generic-postgresql.lisp: (string n) => (CHAR n)
1689 * sql/operations.lisp: Add userenv
1690 * doc/TODO: Add AUTOCOMMIT. Remove need for large table and bigint
1692 * sql/oracle-sql.lisp: Add 64-bit bigint direct conversion
1693 * uffi/clsql-uffi.lisp: Handle signed 64-bit integers
1694 * test/test-init.lisp: Add large table with bigint slot
1696 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1697 * Version 2.11.1 released: Much simpler Oracle client library loading.
1698 Now uses ORACLE_HOME environmental variable as well as tests default
1699 path for Oracle Instant Client.
1701 25 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1702 * Version 2.11.0 released: Full Oracle support. All tests pass
1703 * db-oracle/oracle-sql.lisp: Add declaration so that SBCL runs efficiently.
1704 * tests/test-init.lisp: capitalize odbc backend name in banner
1705 * CONTRIBUTORS: Add note about Marcus' excellent work
1706 * sql/oodml.lisp: Removed old stub function
1707 * clsql.asd: Use module names in current package rather than keyword package
1708 * db-oracle/oracle-sql.lisp: Don't trim trailing spaces. Prevent interrupts
1709 in setting sequence position. Make autocommits more efficient.
1710 * tests/test-init.lisp: Skip 2 tests on Oracle which have unsupported syntax
1711 * sql/oodml.lisp: Get rid of undocumented raw-string type. CommonSQL
1712 strings are raw (non-trimmed trailing whitespace). Add database-get-type-specifier
1713 and read-sql-value for NUMBER and CHAR.
1714 * sql/base-classes.lisp: Add autocommit slot
1715 * sql/transaction.lisp: Added autocommit processing, mild cleaning.
1716 * doc/intro.xml: Add Oracle
1718 24 May 2004: Marcus Pearce (m.t.pearce@city.ac.uk)
1719 * db-postgresql-socket/postgresql-socket-sql.lisp: replace
1720 CLSQL-SIMPLE-WARNING with SQL-WARNING.
1721 * db-sqlite/sqlite-sql.lisp: replace CLSQL-SIMPLE-WARNING with
1723 * db-aodbc/aodbc-sql.lisp: replace CLSQL-ERROR with SQL-ERROR.
1724 * clsql.asd: reworked module structure in package definition and
1725 file names to better reflect component functionality.
1726 * sql/package.lisp: added SQL-FATAL-ERROR and SQL-TIMEOUT-ERROR to
1727 exports list. Removed duplicate and obsolete exports. Exported
1728 remaining SQL operations: SQL-SOME, SQL-<>, SQL-BETWEEN, SQL-DISTINCT,
1729 SQL-NVL and SQL-FUNCTION. Organised exports by functionality/file and
1730 according to whether they are specified by CommonSQL or CLSQL
1732 * sql/transaction.lisp: replace CLSQL-SIMPLE-WARNING with
1734 * sql/generics.lisp: moved generics for QUERY and EXECUTE-COMMAND
1735 here from basic-sql.lisp.
1736 * sql/expressions.lisp: NEW FILE: renamed from classes.lisp (deleted).
1737 * sql/fddl.lisp: NEW FILE: renamed from table.lisp (deleted).
1738 * sql/fdml.lisp: NEW FILE: merger of basic-sql.lisp and sql.lisp
1740 * sql/ooddl.lisp: NEW FILE: ooddl from objects.lisp (deleted).
1741 * sql/oodml.lisp: NEW FILE: oodml from objects.lisp (deleted).
1743 23 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1744 * Version 2.10.22 released
1745 * sql/kmr-mop.lisp, sql/objects.lisp: Since SBCL is the only implementation that
1746 has reversed class slots, change the default for ordered-class-slots so that slots
1747 are now in the same order an in the def-view-class.
1748 * sql/sql.lisp: Honor case of string table identifier to INSERT-RECORDS
1749 * test/test-fddl.lisp: Add two tests for mixed case names
1750 * db-oracle/oracle-sql.lisp: Add missing database qualifier. Return NUMBER (double)
1751 for computed fields, this will require some adjustment to the test suite which
1752 in many cases expects integers.
1753 * test/test-fdml.lisp: Accomodate that Oracle returns doubles for computed columns
1755 22 May 2004 Kevin Rosenberg <kevin@rosenberg.net>
1756 * Version 2.10.21 released
1757 * sql/sequences.lisp: Move generic sequence functions here from db-sqlite,
1758 db-odbc, and db-aodbc.
1759 * sql/*.lisp: Add db-type parameter to generic functions READ-SQL-VALUE,
1760 DATABASE-GET-TYPE-SPECIFIER, and OUTPUT-SQL-VALUE-AS-TYPE. Update methods to use these.
1761 * sql/generic-postgresql.lisp, sql/generic-odbc.lisp: New files
1762 * db-odbc/odbc-sql.lisp, db-aodbc/aodbc-sql.lisp: Move common code to
1763 sql/generic-odbc.lisp
1764 * db-postgresql/postgresql-sql.lisp, db-postgresql-socket/postgresql-socket-sql.lisp:
1765 Move common code to sql/generic-postgresql.lisp
1766 * sql/classes.lisp: honor case of string tables when outputting queries
1767 * sql/objects.lisp: Add database type to default database-get-type-specifier method
1768 * sql/sql.lisp: Add database type to default database-abort-transaction method
1769 * db-mysql/mysql-objects.lisp: New file
1770 * sql/objects.lisp: Move MySQL specific code to mysql-objects.lisp
1771 * sql/utils.lisp: Add GETENV function which will be used to get ORACLE_HOME
1773 * test/test-fdml.lisp: String table names are now case sensitive, so convert to
1774 default db case for FDML/SELECT/25
1776 22 May 2004 Kevin Rosenberg
1777 * Version 2.10.20 released: Oracle backend now fails 6 out of 200 tests
1778 * TODO: Added 2 variances from CommonSQL. Add tests for owner phrases
1779 and string identifiers with non-default case
1780 * sql/table.lisp: Don't convert string table name to a symbol.
1781 * sql/classes.lisp: Honor case of string identifiers
1782 * sql/sql.lisp: Ensure recyclebin is purged for Oracle in
1784 * db-oracle/oracle-sql.lisp: Add sequence functions, fix use of
1785 of owner phrases. Obtain server and client versions.
1786 * db-oracle/oracle-objects.lisp: Fix type specifiers
1787 * tests/test-fddl.lisp: Allow :varchar2 and :number as data types
1788 * tests/test-init.lisp: Properly get username from Oracle connection-spec
1790 22 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1791 * sql/generics.lisp: reworked docstrings. Remove generics for
1792 ADD-TO-RELATION and REMOVE-FROM-RELATION.
1793 * sql/objects.lisp: reworked docstrings. Changed UPDATE-OBJECT-JOINS
1794 to UPDATE-OBJECTS-JOINS for CommonSQL compatibility.
1795 * sql/package.lisp: Changed UPDATE-OBJECT-JOINS to UPDATE-OBJECTS-JOINS
1796 for CommonSQL compatibility. Remove ADD-TO-RELATION and
1797 REMOVE-FROM-RELATION.
1798 * tests/test-oodml.lisp: Changed UPDATE-OBJECT-JOINS to
1799 UPDATE-OBJECTS-JOINS for CommonSQL compatibility.
1800 * doc/TODO: added notes about extra slot options to DEF-VIEW-CLASS.
1801 * sql/conditions.lisp: add documentation for conditions. Add
1802 SQL-TIMEOUT-ERROR and SQL-FATAL-ERROR for CommonSQL compatibility.
1804 21 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1805 * sql/basic-sql.lisp: reworked docstrings.
1806 * sql/transactions.lisp: reworked docstrings.
1807 * sql/sql.lisp: reworked docstrings.
1808 * sql/initialize.lisp: reworked docstrings. INITIALIZE-DATABASE-TYPE
1809 sets *DEFAULT-DATABASE-TYPE* for CommonSQL compatibility.
1810 * sql/database.lisp: reworked docstrings.
1811 * doc/TODO: added notes about START-TRANSACTION and IN-TRANSACTION-P
1812 and FDML extensions and database extensions.
1814 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1815 * db-oracle/oracle-sql: Use clsql-specific error conditions. Use owner keyword.
1816 * db-oracle/make9.sh: add makefile for building with Oracle 9 client
1818 * sql/table.lisp: Add logic for dealing with Oracle 10g vs. previous
1819 Oracle versions with the PURGE option required for drop table. This needs
1820 to be converted to a generic function and moved to db-oracle/oracle-sql.lisp
1822 20 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1823 * sql/classes.lisp: remove unused PARAMS slot in SQL-IDENT-ATTRIBUTE.
1824 * sql/syntax.lisp: remove unused PARAMS keyword arg to SQL-EXPRESSION.
1825 * sql/table.lisp: reworked docstrings.
1826 * sql/objects.lisp: moved *default-update-objects-max-len* here from
1828 * doc/TODO: notes about :if-does-not-exist arg to DROP-TABLE,
1829 DROP-VIEW and DROP-INDEX and the use of the :transactions and
1830 :constraints keyword args to CREATE-TABLE.
1831 * sql/classes.lisp: the DESCRIPTION argument to CREATE-TABLE is now
1832 CommonSQL compatible with respect to column constraints.
1834 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1835 * sql/oracle-sql.lisp: Now compiles and runs on SBCL.
1836 Requires UFFI 1.5.0 or higher
1838 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1840 * sql/conditions.lisp: Fix cerror
1842 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1843 * Version 2.10.18 released: New condition hierarchy to be compatible
1844 with CommonSQL -- not backward compatible with previous CLSQL.
1845 * sql/db-interface.lisp: Add more default methods
1846 * sql/objects.lisp: Add explicit table name to order-by parameters
1847 in find-all when only one table to avoid selecting a duplicate row.
1848 Fix error in FIND-ALL when using :order-by such as (([foo] :asc))
1849 as previous logic was adding two fields (foo asc) to SELECT query.
1850 Make :result-types :auto be the default for object selections.
1851 Properly handle caching key when using multiple order-by with asc/desc
1853 * db-oracle/*.lisp: Much improvements, now passes 90% of test suite
1855 19 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1856 * sql/recording.lisp: reworked docstrings.
1857 * sql/syntax.lisp: reworked docstrings.
1858 * doc/TODO: added notes about extensions to SQL-RECORDING-P and the
1859 SQL syntax state functions being macros.
1861 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1862 * sql/package.lisp: Export initialize-database-type and
1863 *initialize-database-types* from CLSQL package.
1864 * sql/conditions.lisp: Add new CommonSQL compatible conditions,
1865 remove old CLSQL conditions.
1866 * sql/loop-extensions.lisp: Make errors of type sql-user-error
1867 * */*.lisp: Convert to from old to new conditions
1869 18 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1870 * sql/table.lisp: Add PURGE to drop command for oracle 10g backend.
1871 To handle this difference, will need to add a new database-drop-table
1873 * db-oracle/oracle-sql.lisp: Move server-version and
1874 major-version-number to database object to allow multiple connections
1875 to Oracle servers of different versions.
1877 18 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1878 * TODO: moved notes about backends to doc/TODO.
1879 * doc/TODO: added notes about backends and select extensions.
1880 * sql/base-classes.lisp: remove obsolete schema slot in database
1883 16 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1884 * db-oracle/oracle-api: Add OCIServerVersion
1885 * db-oracle/oracle-sql: Query and store server version on connect
1886 * sql/db-interface.lisp: Add new db-type-has-bigint? generic
1887 function to handle OCI's lack of bigint support
1888 * test/test-basic.lisp: Separate bigint testing
1889 * test/test-utils.lisp: Add oracle to specs and list of backends
1890 * doc/TODO: New file
1891 * test/test-fdml.lisp: Added FDML/SELECT/34 to test
1892 run-time instantiation of variables in reader macros.
1893 * TODO: Remove item already complete. Add note about
1896 16 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1897 * sql/syntax.lisp: added condition to the reader macro to treat [*]
1898 as a column identifier (rather than an operation) for CommonSQL
1900 * tests/test-fdml.lisp: add tests for ORDER-BY and SET-OPERATION
1901 keword args to SELECT, [*] as column identifier, new MAP-QUERY
1902 behaviour and the ANY and ALL operators in subqueries.
1903 * tests/test-init.lisp: add set-operation and subquery tests to
1904 appropriate skip lists.
1905 * sql/objects.lisp: remove redundant and non CommonSQL compatible
1906 ORDER-BY-DESCENDING keyword argument for SELECT.
1907 * sql/classes.lisp: remove redundant and non CommonSQL compatible
1908 ORDER-BY-DESCENDING keyword argument for SELECT.
1909 * tests/test-oodml.lisp: add test for ORDER-BY keyword to SELECT
1910 with object queries.
1912 15 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1913 * sql/db-interface.lisp: Add new db-type-has-union?
1914 since Mysql 3.23 does not support unions.
1915 * sql/test-init.lisp: Don't try union tests on database
1916 backends which do not support it.
1917 * db-oracle/*.lisp: initial port to UFFI
1918 * sql/objects.lisp: implement UPDATE-OBJECT-JOINS,
1919 implement REFRESH for SELECT.
1920 * tests/test-oodml.lisp: Add tests for deferred retrieval,
1921 caching, refresh, and update-object-joins
1922 * tests/test-init.lisp: Add deferred-employee-address class
1924 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1925 * sql/operations.lisp: make MINUS operator a synonym for EXCEPT. Add
1926 COALESCE operator and make NVL a synonym for this. Make ANY, SOME,
1927 ALL and EXISTS generate function expressions so they output the
1929 * sql/classes.lisp: SELECT now generates appropriate SQL when
1930 passed the SET-OPERATION and ALL keyword arguments.
1931 * sql/classes.lisp: the ORDER-BY keyword argument to SELECT now
1932 accepts ordering constraints as pairs of the form (column direction)
1933 where direction may be :ASC or :DESC.
1934 * tests/test-syntax.lisp: added tests for MINUS and COALESCE/NVL.
1935 Correct tests for ANY, SOME, ALL and EXISTS.
1936 * tests/test-fdml.lisp: added test for COALESCE.
1937 * sql/sql.lisp: MAP-QUERY now applies FUNCTION to QUERY-EXPRESSION
1938 using funcall unless QUERY-EXPRESSION returns one column and its
1939 FLATP slot is not nil in which case apply is used.
1940 * tests/test-basic.lisp: modified calls to MAP-QUERY to reflect the
1942 * TODO: remove items done.
1943 * db-postgresql/postgresql-sql.lisp: no need to reverse results in
1944 DATABASE-LIST-ATTRIBUTES.
1945 * db-postgresql-socket/postgresql-socket-sql.lisp: no need to reverse
1946 results in DATABASE-LIST-ATTRIBUTES.
1948 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1949 * sql/classes.lisp: SELECT now accepts table identifiers as strings
1950 for CommonSQL compliance. Add support for qualified sql identifiers
1951 with aliased table names.
1952 * tests/test-fdml.lisp: added tests for table identifiers as strings
1953 in SELECT and for aliased definitions.
1954 * tests/test-syntax.lisp: added tests for alias definitions.
1956 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
1957 * sql/sql.lisp: PRINT-QUERY now calls QUERY with result-types and
1958 field-names set to nil.
1959 * sql/sql.lisp: PRINT-QUERY now computes column sizes correctly
1960 with null attribute values.
1961 * sql/operations.lisp: modify SQL concatenation operator to accept
1962 unescaped || symbol.
1963 * sql/syntax.lisp: modify sql reader macro function to accept
1964 unescaped sql concatenation operator.
1965 * tests/test-fdml.lisp: unescape sql concatenation operator.
1966 * tests/test-syntax.lisp: unescape sql concatenation operator.
1967 * TODO: remove items done. Add notes about SQLITE/MYSQL backends.
1968 Note to add test for universal-time. Note about difference from
1969 CommonSQL in transaction handling.
1971 13 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1972 * tests/test-init.lisp: Add deferred-employee-address
1974 * tests/test-oodml.lisp: Add deferred retrieval testgs
1976 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1978 * LATEST-TEST-RESULTS: Run on all platforms, add AMD64
1979 * sql/sql.lisp: Add FOR-EACH-ROW macro from clsql-classic/sql.lisp
1980 * db-sqlite/sqlite-uffi-api.lisp: Fix row-pointer type
1981 * *: Fix minor style warnings
1982 * clsql-classic: Remove system and subdirectory
1983 * clsql-base: Remove system and subdirectory and
1984 fold into clsql system
1985 * doc/intro.xml: Remove reference to old clsql-base. Add x86_64
1986 as supported platform.
1988 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
1989 * Version 2.10.16: CLSQL now fully supports AllegroCL AMD64
1990 * db-odbc/odbc-api.lisp: work around return-type bug [spr28889] in
1991 Allegro 7.0beta AMD64
1992 * db-odbc/*.lisp: Add a layer of indirection to foreign-type
1993 of ODBC longs since this type can vary on 64-bit platforms depending
1994 upon the compilation options of unixODBC.
1995 * db-mysql/mysql-api.lisp: Fix int vs. long slots in foreign
1996 structures found by testing with AllegroCL 7.0b AMD64.
1997 * db-*/*-loader.lisp: Load 64-bit libraries on 64-bit platorms
1998 * sql/objects.lisp: Simple implementation of UPDATE-OBJECT-JOINS.
1999 Initial caching support for SELECT
2000 * tests/test-oodml.lisp: Avoid using cache when testing select.
2001 * sql/kmr-mop.lisp: Explicitly check slot order and
2002 store as a cl:*feature*
2003 * sql/recording.lisp: Remove additional types to
2004 increase CommonSQL conformance.
2005 * tests/test-init.lisp: Change a :column attribute
2006 to test symbols as value
2007 * sql/relations.lisp: Remove functions since they don't support
2008 many to many relationships.
2009 * examples/clsql-tutorial.lisp, doc/csql.lisp: Remove use
2010 of add-to-relations function and replace with explicit field settings.
2011 * base/classes.lisp: Remove obsolute query-stream. Add record-caches slot.
2013 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2015 * LATEST-TEST-RESULTS: results with current version
2016 * sql/kmr-mop.lisp: Make CMUCL reader macros specific for cmu18
2017 since cmu19 has opposite order of class slots.
2018 * sql/objects.lisp: Fix (setf slot-value-using-class) for Lispworks
2019 * tests/test-fdml.lisp: Renumber SELECT tests to avoid overwriting
2021 * tests/test-init.lisp: Check test-database-underlying-type for
2024 8 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2025 * sql/operations.lisp: complete remaining operations for the sql
2026 syntax: SUBSTR, SOME, ORDER-BY, GROUP-BY, NULL, DISTINCT, EXCEPT,
2027 UNION, INTERSECT, BETWEEN.
2028 * sql/classes.lisp: add new classes: SQL-BETWEEN-EXPRESSION,
2029 SQL-QUERY-MODIFIER-EXPRESSION and SQL-SET-EXPRESSION.
2030 * tests/test-syntax.lisp: add tests for new operations.
2031 * tests/test-fdml.lisp: add tests for queries based on new operations.
2032 * tests/test-init.lisp: add select/20 to tests skipped for sqlite and
2033 select/20, query/5, query/7 and query/8 to tests skipped by mysql.
2034 * TODO: removed entries done.
2036 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2037 * tests/benchmarks.lisp: Add immediate vs. deferred
2040 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2041 * Version 2.10.13: Now works on openmcl 0.14.2
2042 * sql/objects.lisp: Add :retrieval :immediate for
2044 * tests/test-init.lisp: Add non-index fields for testing
2045 join class employee-addresss
2046 * test/test-oodml.lisp: Add tests for retrieval immediate
2047 * sql/metaclasses.lisp: Handle differences in direct-slot-definition
2048 values which are now listifed by openmcl 14.2.
2049 * sql/objects.lisp: more framework for supporing immediate retrieval
2051 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2052 * docs/intro.xml: Upload location of a README file
2053 * sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
2054 changing the type-specifier. Use a lisp type of (OR NULL FOO)
2055 for a specified-type of FOO unless :db-constraints :not-null.
2056 No need to specialize finalize-inheritance for openmcl.
2057 * tests/test-*.lisp: Rename fields so that joins occur on
2058 fields with different names. This ensures that join code is
2059 selecting the proper name.
2060 * test/test-init.lisp: Add :base-table for employee-address
2061 view class for testing.
2062 * sql/objects.lisp: Use view-table rather than name of table
2063 in a number of places to fix errors noted with using :base-table.
2065 6 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2066 * sql/objects.lisp: replace *update-records-on-make-instance* with
2067 *db-auto-sync* which also controls both automatic creation of
2068 new records on creation of new instance and updating of record
2069 fields on setting of instance slots (as suggested by Edi Weitz).
2070 * tests/test-init.lisp: replace *update-records-on-make-instance*
2071 with *db-auto-sync*.
2072 * sql/package.lisp: replace *update-records-on-make-instance*
2073 with *db-auto-sync*.
2074 * TODO: replace *update-records-on-make-instance* with *db-auto-sync*.
2075 * sql/objects.lisp: remove redundant rebindings of *db-initializing*
2076 and *default-database* in FIND-ALL.
2077 * sql/package.lisp: import time functions from CLSQL-BASE.
2078 * tests/test-time.lisp: replace CLSQl-BASE package qualifier with CLSQL.
2079 * tests/test-fdml.lisp: replace CLSQl-BASE package qualifier with CLSQL.
2080 * tests/test-init.lisp: replace CLSQl-BASE package qualifier with CLSQL.
2081 * tests/test-ooddl.lisp: replace CLSQl-BASE package qualifier with
2084 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2085 * sql/classes.lisp: Add SQL-OBJECT-QUERY type. Have [select 'class]
2086 now return a sql-object-query type rather than directly performing a query.
2087 This improves CommonSQL conformance.
2088 * sql/sql.lisp: Add new QUERY method for SQL-OBJECT-QUERY. Move
2089 from basic/basic-sql.lisp the DO-QUERY and MAP-QUERY since they now
2090 depend on sql-object-query-type.
2091 * sql/loop-extensions.lisp: Move from base package
2092 * classic/package.lisp: remove references to map-query and do-query
2094 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2095 * TODO: New section on optimizations, especially optimizing JOINs.
2096 * sql/objects.lisp: Have :target-slot return of list of lists rather
2097 than a list of cons pairs to be conformant with CommonSQL.
2098 Make :target-slot much more efficient by using a SQL inner join
2099 statement and just requiring one SQL query. Add :retrieval :deferrred
2100 to target-slot joins. Add placeholder for update-objects-join.
2101 * sql/classes.lisp: Add :inner-join and :on slots to sql-query class
2102 and process them for query output-sql.
2104 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2106 * base/basic-sql.lisp: Avoid multiple evaluation
2107 of query-expression in DO-QUERY
2108 * sql/objects.lisp: Make SELECT a normal function.
2109 SELECT now accepts type-modified database identifiers, such as
2110 [foo :string] which means that the values in column foo are returned
2111 as Lisp strings. Add new *update-records-on-make-instance* special
2112 variable controlling automatic creation of new instances. Add missing
2113 RESULT-TYPES keyword to FIND-ALL. Add :target-slot support.
2114 * sql/packages.lisp: Export *update-records-on-make-instance*
2115 * test/test-oodml.lisp: Add tests for :target-slot and many-to-many
2117 * test/test-fdml.lisp: Add tests for type-modified
2118 database identifiers.
2119 * test/test-init.lisp: Stop using add-relation since implementing
2120 many-to-many joins. Use *update-records-on-make-instance*
2121 to automatically store records on instance creation. Add many-to-many
2122 employee-address view-class.
2124 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2126 * base/loop.lisp: Add object iteration. Use :result-type
2127 :auto for result-set. Remove
2128 duplicate (and non-correct) code for non-list variables by
2129 simply making an atom variable into a list.
2130 * sql/package.lisp: Remove unnecessary clsql-sys package
2131 and replace it with clsql.
2132 * sql/metaclasses.lisp: Properly store specified-type from
2133 direct-slot-definition and then store translated type in
2134 effective-slot-definition
2135 * sql/classes.lisp: Don't output type in sql-output
2136 for SQL-IDENT-ATTRIBUTE. This is in preparation for supporting
2137 [foo :integer] as fields in SELECT.
2138 * sql/query.lisp: Set default for :result-types to :auto in
2140 * sql/objects.lisp: Use specified-type when invocating
2141 database-get-type-specifier. def-view-class macro now returns
2143 * base/basic-sql.lisp: Make :AUTO the default value for
2144 :RESULT-TYPES for MAP-QUERY and DO-QUERY.
2145 * sql/objects.lisp: Add bigint type
2146 * test/tests-basic.lisp: Add tests for :result-types for
2147 MAP-QUERY and DO-QUERY
2148 * test/test-fdml.lisp: Add test for result-types in LOOP
2149 and also using single symbol rather than a list for variables.
2150 Add test that default :result-types is auto for FDML QUERY.
2151 * test/test-syntax.lisp: Don't expect TYPE in the SQL-OUTPUT
2152 of SQL-IDENT-ATTRIBUTE.
2153 * test/test-oodml.lisp: Enable OO loop iteration test,
2154 modify it so it doesn't depend on boolean where.
2156 4 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2158 * sql/objects.lisp: added derived type specifier for universal time.
2159 * sql/package.lisp: added #:universal-time to clsql-sys exports.
2160 * tests/test-oodml.lisp: added test for translation of boolean slots
2161 in SELECT with object queries.
2163 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2164 * db-odbc/odbc-api.lisp: Fix changing nil to "NIL"
2165 for odbc/postgresql backend.
2166 * db-odbc/odbc-sql.lisp: Fix ATTRIBUTE-TYPE so that
2167 it can handle NIL values from the ODBC driver
2168 * tests/benchmarks.lisp: New file with initial
2170 * sql/relations.lisp: fix to add subclassing support,
2171 minor optimizations [Edi Weitz]
2173 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2175 * base/conditions.lisp: Add *backend-warning-behavior*
2177 * db-postgresql-socket/postgresql-socket-sql.lisp:
2178 Honor value of *backend-warning-behavior*
2179 * tests/test-fdml.lisp: Remove test of raw boolean value
2180 since different backends handle this differently. Add
2181 test for :column attribute.
2182 * tests/test-oodml.lisp: Add tests for boolean slot value
2183 and for :void-value attribute
2184 * tests/test-init.lisp: Use *backend-warning-behavior*
2185 to suppress warnings from postgresql about implicitly
2186 creating primary key in tables. Add new address table.
2188 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2190 * db-odbc/odbc-dbi.lisp: Convert TINYINT to integers when
2191 result-types is :auto
2192 * sql/objects.lisp: Properly handled writing/reading Boolean
2193 values from SQL database when retrieving objects.
2194 * test/test-fdml.lisp: Add another test for boolean results
2195 * test/utils.lisp: Fix incorrect declaration
2197 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2199 * sql/generics.lisp: add generic function for SELECT.
2200 * sql/objects.lisp: make SELECT a method specialisation.
2201 * sql/classes.lisp: MAKE-QUERY now calls SELECT if the selections
2202 referred to are View Classes.
2203 * base/basic-sql.lisp: in DO-QUERY and MAP-QUERY, if the
2204 query-expression arg evaluates to a list, then we have an object
2206 * tests/test-oodml.lisp: add tests for DO-QUERY and MAP-QUERY with
2208 * TODO: remove items done and add a todo for SELECT.
2209 * sql/objects.lisp: SELECT takes a :field-names arg to pass on to
2211 * sql/sql.lisp: add :field-names arg to QUERY.
2212 * tests/test-fdml.lisp: minor rework to use :field-names arg to
2215 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2216 * sql/objects.lisp: fix bug in FIND-ALL when SELECT called with 2
2217 or more View Classes.
2218 * sql/objects.lisp: make the :flatp argument to SELECT work with
2220 * sql/objects.lisp: make SELECT accept a :result-types argument
2221 (defaults to :auto) which is passed on to QUERY.
2222 * sql/objects.lisp: SELECT returns field-names as a second value.
2223 * tests/test-ooddl.lisp: add flatp arg to SELECT calls as appropriate.
2224 * tests/test-fdml.lisp: add flatp/result-types arguments to calls
2225 to SELECT and take only first value as appropriate.
2226 * tests/test-fdml.lisp: add two new tests for query result coercion
2227 and the field-names returned as a second value from SELECT.
2228 * tests/test-oodml.lisp: add flatp arg to SELECT calls as appropriate.
2230 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2231 * Version 2.10.6-pre1
2232 * sql/metaclasses.lisp: Add void-value slot
2233 * doc/csql.xml: Update def-view-class documentation
2234 * test/test-init.lisp: Change old :db-type to :db-kind.
2235 Remove old :nulls-ok attributes.
2236 * sql/objects.lisp: Add new universal-time and bigint
2237 types. Optimize reading of integers using parse-integer
2238 rather than read-from-string.
2239 * */*.lisp: Merge clsql-base-sys and clsql-base packages
2240 into clsql-base package
2241 * classic/sql.lisp: Move large object support into base, leaving
2242 classic without any functionality that is provided in the clsql
2244 * classic/package.lisp: Rename clsql-classic-sys package to
2245 its former nickname of clsql-classic
2247 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2248 * Version 2.10.5: SQLite backend now passes all result-types tests
2249 * clsql-sqlite.asd: Depend on clsql-uffi system
2250 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
2251 for efficiency and code reuse.
2252 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
2253 for better cross-implementation compatibility.
2255 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2257 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
2259 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
2260 bug on SBCL in result-field-names function as reported by Marcus Pearce
2261 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
2262 manifest in SBCL testing
2264 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2266 * sql/database.lisp: Conform more to CommonSQL output
2267 for STATUS command [Marcus Pearce]
2268 * sql/sqlite-sql.lisp: Rework to use result-types
2269 * sql/sqlite-api-clisp.lisp: Add compatibility layer
2270 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
2271 be cleaned up of most clisp reader conditionals
2272 * sql/test-init.lisp: Now run field type tests on sqlite
2275 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2277 * base/basic-sql.lisp: Set default value of :result-types
2278 to :auto for more CommonSQL conformance.
2279 * test/test-fdml.lisp: Add tests for numeric value of fields
2282 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2283 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
2284 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
2285 Return field names as second value for QUERY. This can be overridden
2286 for efficiency with the new keyword :FIELD-NAMES set to NIL
2287 in the QUERY invocation.
2288 * test/test-fdml.lisp: Add tests for new field-name feature
2289 * sql/metaclass.lisp: Remove old Lispworks cruft
2290 and replace it with invocation of new code in kmr-mop.lisp
2291 which actually works with Lispworks 4.2
2292 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
2294 * base/db-interface.lisp: Document the multiple values
2295 returned by DATABASE-ATTRIBUTE-TYPE so matches the
2296 undocumented CommonSQL behavior.
2297 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
2298 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
2299 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
2300 Implement CACHE-TABLE-QUERIES.
2301 * db-odbc/odbc-sql.lisp: Fix attribute-type function
2302 * test/test-fddl.lisp: Add tests for attribute type
2303 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
2305 * base/classes.lisp: Add attribute-cache slot to database clas
2306 * base/initialize.lisp: initialize-database-type now automatically
2307 loads database-type backend as needed.
2308 * base/test-init.lisp: Utilize new initialize-database-type functionality.
2309 * TODO: remove items done
2311 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
2313 * sql/objects.lisp: remove create/drop-sequence-from-class.
2314 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
2315 * sql/objects.lisp: improved CommonSQL compatibility for
2316 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
2317 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
2318 * sql/generics.lisp: move generics from objects.lisp to here.
2320 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2321 * Version 2.9.6-pre1
2322 * db-mysql/mysql-client-info.lisp: Add client version 4.1
2324 * sql/sql.lisp: Make *default-database* the default for
2327 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2329 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
2331 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
2332 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
2333 on a metaclass specialized from standard-db-class.
2336 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2337 * Version 2.9.4: Multiple changes to support Allegro's "modern"
2338 lisp which uses a lowercase reader and has case-sensitive symbols
2339 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
2340 exposed by case-sensitive mlisp.
2342 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2343 * Version 2.9.3: All tests now pass on all platforms!
2344 * LATEST-TEST-RESULTS: New file with summary of test results
2345 * sql/generics.lisp: New file for generic function definitions.
2346 * test/test-init.lisp: Display names of skipped tests.
2347 Use unwind-protect to ensure disconnect
2348 * sql/objects.lisp: Change database-type to database-underlying-type
2349 so that actual database engine is properly identified
2350 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
2351 return an ISO timestring for compatibility with other drivers.
2352 Workaround bug in MyODBC for LIST-TABLE-INDEXES
2353 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
2354 returns floating-point values for floor and truncate operations
2355 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
2356 * tests/test-basic.lisp: Port to regression tester
2357 * test/test-init.lisp: Output to *report-stream*
2358 * docs/appendix.xml: Document ODBC and SQLite backends.
2359 * sql/classes.lisp: Make output-sql require a database parameter.
2360 This allows SQL generation to have the proper case to support
2361 the differences in case handling between CommonSQL API,
2362 Postgresql, MySQL, Oracle.
2364 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2365 * Version 2.9.2: Improvments in database capability introspection
2366 and querying. Support transactions in MySQL where available.
2367 All tests now pass on MySQL and SQLite in addition to postgresql
2368 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
2369 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
2370 DATABASE-LIST-SEQUENCES.
2371 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
2372 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
2373 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
2374 * tests/*.lisp: Check database capabilities and remove tests which
2375 the database backend does not support
2376 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
2377 controls whether InnoDB tables will be created when supported on
2378 the underlying MySQL server.
2380 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2381 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
2382 supported by all database backends (except AODBC since
2383 AODBC doesn't support index querying)
2384 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
2385 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
2386 to support index queries
2387 * db-aodbc/aodbc-sql.lisp: Filter driver manager
2388 "information_schema" tables from LIST-TABLES
2389 * tests/test-basic.lisp: Remove table after testing
2390 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
2391 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
2392 which gets the underlying type of database -- required
2393 when dealing with ODBC databases and want to query
2394 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
2395 as first database-backend specific feature. Is T on
2396 :mysql, NIL on other backends. Change DROP-TABLE to
2399 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2400 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
2402 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2404 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
2405 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
2407 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2408 * Version 2.8.0: New API function: LIST-DATABASES
2409 * base/utils.lisp: Fix command-output on CMUCL/SBCL
2410 * db-*/*-sql.lisp: Add new database-list function
2411 * base/database.lisp: Add new LIST-DATABASES command
2413 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2415 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
2416 * db-sqlite/sqlite-api-uffi.lisp: Print error string
2419 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2421 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
2424 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2426 * base/objects.lisp, base/classes.lisp: Patch
2427 for db-kind from Eduardo Munoz
2429 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2431 * base/basic-sql.lisp: Fix FLATP in QUERY
2433 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2434 * Version 2.7.3: Implement RECONNECT
2436 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2437 * Version 2.7.2: Fix ODBC on Lispworks Windows
2439 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2440 * Version 2.7.1: Fix for new ODBC backend.
2441 clsql-odbc now works on SBCL, CMUCL, OpenMCL
2442 in addition to AllegroCL and Lispworks.
2444 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2445 * Version 2.7.0: New backend: ODBC. Tests as
2446 well as AODBC backend on Allegro,Lispworks.
2447 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
2448 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
2449 to explicitly set ODBC2 support. Add BIGINT support.
2450 Add result-types support. Added SQLTables.
2451 Fix array type in fetch-all-rows. Make width
2452 changable by database or query.
2453 * base/utils.lisp: Add process functions
2454 * base/package.lisp: Export utils to CLSQL-BASE-SYS
2455 * db-aodbc: Implement sequence functions,
2456 database-list-tables, database-list-attributes
2457 * tests/utils.lisp: Add support for ODBC backend,
2458 rework READ-SPECS to use +all-db-types+
2459 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
2462 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2463 * Version 2.6.13. Requires UFFI version 1.4.9
2464 * db-odbc/*.lisp: Further porting.
2465 Pre-alpha code! But, basic query is now working.
2467 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2469 * base/transactions.lisp: Add quote for macro
2470 expansion of WITH-TRANSACTIONS [Time Howe]
2471 * db-sqlite/sqlite-sql.lisp: Support memory database
2472 in database-probe [Ng Pheng Siong]
2473 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
2474 The DBI layer is not finished.
2476 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2478 * sql/objects.lisp: add :root-class functionality for
2479 list-classes and add duration type support [Marcus Pearce]
2480 * db-odbc: Add mid-level [DBI] layer
2482 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2484 * db-aodbc: Add methods for generic functions, some are
2485 not yet implemented.
2486 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
2489 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2491 * base/package.lisp: Add missing symbols [Marcus Pearce]
2493 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2495 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
2496 * utils/time.lisp: Multiple fixes [Marcus Pearce]
2497 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
2499 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2501 * sql/*.lisp: Remove schema versioning cruft
2503 * Makefile: Add classic subdirectory
2505 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2507 * sql/sql.lisp: Fix TRUNCATE command, bug reported
2509 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
2510 specific and easy for an application to directly support.
2511 Idea from Marcus Pearce.
2512 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
2513 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
2514 Keep low-level interface for future optimization
2515 supporting LIST-ATTRIBUTE-TYPES command.
2516 * Makefile: Add to db-sqlite and test directories.
2517 Include them in top-level Makefile
2519 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2521 * sql/relations.lisp: Add missing file
2522 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
2523 * test/test-time.lips: New file [Marcus Pearce]
2525 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2527 * test/test-init.lisp: Properly handle object
2528 creation. Close database after use.
2529 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
2530 function so can have methods specialized on
2531 table being a string or an sql-table object.
2532 * base/pool.lisp: Really fix CMUCL locking
2534 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2536 * test/test-init.lisp: Signal correctly
2537 if any errors occurred in any test suite
2538 * base/loop-extensions.lisp: Fix error
2539 introduced for Lispworks
2540 * base/pool.lisp: Fix locking for CMUCL
2541 * base/objects.lisp: Remove schema-version cruft
2543 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2544 * Version 2.6.2: New CLSQL API functions:
2545 DESCRIBE-TABLE AND TRUNCATE-DATABASE
2546 Currently, this are only supported on :postgresql
2547 and :postgresql-socket
2548 * base/database.lisp: automatically load ASDF system
2549 in CONNECT if not already loaded
2550 * base/tests.lisp: disconnect database after testing
2551 * base/*.lisp: Remove CLOSED-DATABASE type in favor
2552 of storing open/closed status in slot of database
2553 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
2554 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
2555 DATABASE-DESCRIBE-TABLE
2556 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
2557 * base/conditions: Remove duplicate condition
2558 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
2559 * base/recording.lisp: Add new :QUERY type for recording
2561 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2562 * Version 2.6.1: documentation fixes, merged
2563 classic-tests into tests
2565 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2566 * Version 2.6.0 released: New API functions
2567 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
2568 * doc/ref_clsql.xml: Document new functions
2569 * base/database.lisp: New API functions
2570 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
2571 * base/utils.lisp: Fix use of position-char.
2572 Add COMMAND-OUTPUT used by backends for running
2573 external programs. Fix parsing of SQL*NET-compatible
2575 * base/loop-extension.lisp: Simplify package use
2576 for Lispworks and Allegro
2577 * db-*/*-sql.lisp: Added DATABASE-CREATE,
2578 DATABASE-DESTORY, PROBE-DATABASE methods
2579 * tests/test-init.lisp, clasic-tests/tests.lisp:
2580 Use destroy-database and create-database to ensure
2581 testing with empty database
2582 * tests/test-connection.lisp: Add tests for
2583 parsing of string connection-specs
2584 * examples/run-tests.sh: New file for running
2585 test suite on all installed CL implementations
2586 * examples/clsql-tutorial.lisp: moved from
2588 * examples/dot.clsql-tests.config: New file
2589 giving an example test configuration
2590 * test/README: Add notes about rtest/ptester
2591 downloads and link to sample test configuration file.
2593 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2594 * Version 2.5.1 released:
2595 * tests/*.lisp: Rework so tests are run
2596 on multiple backends automatically based
2597 on the contents of ~/.clsql-tests.config.
2598 Reuse helper functions from classic-tests.
2599 * base/database.lisp: Support connection-spec
2600 as string for CONNECT
2601 * classic-tests/tests.lisp: Automatically
2602 load database backends as needed.
2604 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2605 * Version 2.5.0 released:
2606 All tests for CLSQL and CLSQL-CLASSIC pass
2608 * base/loop-extension.lisp: Add Lispworks
2609 loop-extension. Improve type specifying on
2612 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2613 * Version 2.4.2 released:
2614 loop extension now supported on Allegro, all
2615 CLSQL-TESTS pass on Allegro.
2616 * sql/metaclasses.lisp: Some optimization
2617 of compute-slots, be selective when
2618 ordered-class-slots needs to be called
2619 instead of class-slots
2620 * TODO: add URL with documentation on
2621 extending Lispworks LOOP form
2623 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2624 * Version 2.4.1 released: CLSQL-TESt suite passes
2625 all tests for postgresql and CMUCL, SBCL, OpenMCL.
2626 Allegro and Lispworks pass all tests except for
2627 FDML/LOOP/1 since the loop extension have not yet
2628 been ported to those implementions.
2629 * sql/metaclasses.lisp: Added new slot to standard-db-class
2630 to hold user-specified type. OpenMCL adjustments to compensate
2631 for its type-predicate function. Since AllegroCL, Lispworks,
2632 and OpenMCL have different slot orders, added compute-slots
2633 and ordered-class-slots functions so their slot order matches
2636 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2637 * Version 2.4.0 released: All tests for clsql-classic now finish
2638 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
2639 mysql, postgresql, postgresql-sockets, and sqlite backends.
2640 * db-mysql/mysql-sql.lisp: Fix array dereferencing
2641 * classic-tests/tests.lisp: Fix package name of
2642 number-to-sql-string.
2643 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
2644 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
2645 now passes tests on all support UFFI platforms.
2646 * db-postgresql-socket/postgresql-socket-api.list: Ported to
2648 * multiple: Finish renaming of :types keyword to :result-types for
2649 greater CommonSQL compatibility, including documentation
2650 * sql/basic-cmds.lisp: Remove obsolete file
2652 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2653 * Version 2.3.3 released
2654 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
2655 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
2656 * Fix for schema table [Marcus Pearce]
2657 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
2658 * Fixes to test suite [Marcus Pearce]
2660 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2661 * db-*/*-sql.lisp: Ensure that expr in
2662 database-query-result-set is a string
2663 * Documentation integration
2665 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2666 * With for Marcus Pearce's excellent work, I've merged
2667 his clsql-usql port into clsql. The original clsql
2668 interface is available in the clsql-classic package.
2670 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2671 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
2672 adding further support for providing backend for UncommonSQL
2674 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
2675 * Integrate patch from Aurelio Bignoli for SQLite backend
2677 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
2678 * Converted documentation to XML format
2679 * Made package installable with asdf-install
2681 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
2682 * Add for-each-row macro
2684 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
2685 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
2687 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
2688 * Add support for SBCL, OpenMCL, and SCL
2689 * Add *load-truename* to search path for clsql's
2692 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
2693 * Rework use of file types in .asd files
2695 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
2696 * Add .asd definition files for ASDF users
2698 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
2699 * Restructure directories for Common Lisp Controller v3 compatibility
2701 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
2702 * Also change case of logical host in loader files
2703 * Rework handling of logical pathnames
2705 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
2706 * Change case of logical host
2708 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
2709 * clsql-base.system: Added base package that can be used without
2710 high-level SQL commands. Used for adding support for UncommonSQL.
2711 * *.system: Reworked logical pathnames to be more consistent with
2712 Common Lisp Controller.
2713 * debian/*: Completed initial Debian support
2715 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2717 * sql/transactions.cl:
2718 Added transaction support. Functions/macros added:
2719 with-transaction, commit-transaction, rollback-transaction,
2720 add-transaction-commit-hook, add-transaction-rollback-hook
2722 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2725 * sql/functional.cl:
2726 Added pool support in connect/disconnect and with-database.
2727 Removed with-db-from-pool as with-database can now works with the connections pool
2729 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2734 Completed connection pool.
2735 Added with-db-from-pool macro.
2737 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2739 Added initial support for connection pool
2740 * sql/transactions.cl
2741 Took transaction code from UncommonSQL and integrated
2742 into CLSQL code. See file for disclaimer about why this
2745 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2746 * interfaces/postgresql/postgresql-sql.cl:
2747 Fix keyword typo in database-read-large-object
2748 * interfaces/mysql/mysql-loader.cl
2749 Fix loading on Win32
2750 * test-suite/tester-clsql.cl
2751 Fix type coercion of double-float
2753 Added debian docbook catalog, made it the default
2755 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
2756 * interface/postgresql/postgresql-api.cl:
2757 * interface/postgresql/postgresql-sql.cl:
2759 * sql/db-interface.cl:
2760 Added large objects support for postgresql.
2762 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2763 * src/postgresql-socket/postgresql-socket-api.cl:
2764 Fixed find-foreign-function call, eliminated crypt warning
2766 Multiple improvements
2768 Moved functionality from low-level interfaces to this file
2769 via generic functions
2770 * test-suite/tester.cl:
2771 Added test with acl-compat-tester, moved others to old-tests
2774 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
2776 Reinstated commented out sections
2777 * interfaces/postgresql/postgresql-loader.cl:
2778 * interfaces/mysql/mysql-loader.cl:
2779 Updated find-forieign-library support.
2780 * interfaces/postgresql-socket/postgresql-socket-package.cl:
2781 Fixed require form for Lispworks (Thanks Marc Battyani!)
2782 * interfaces/postgresql-socket/postgresql-socket-api.cl:
2783 Fixed eval of def-function for crypt library.
2785 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2786 * Added interface to support USQL high-level rouines
2788 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2789 * Separated db-interface and conditions from sql/sql.cl
2790 * Improved foreign library loading testing
2791 * interfaces/postgresql/postgresql-api.cl
2792 Added PQisBusy function
2793 * interfaces/clsql-uffi/clsql-uffi.cl
2794 Fixed sign error for 64-bit processing
2796 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2797 * interfaces/postgresql-socket/postgresql-socket-api.cl:
2798 Fixes to read-double-from-socket. Added 64-bit integer support.
2799 * test-suite/xptest-clsql.cl
2800 Added testint for 64-bit integers
2801 * Additons to installation docs
2803 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2804 * interfaces/postgresql-socket/postgresql-socket-api.cl:
2805 Implemented direct socket reading for field type :double
2806 * Added usage information for :types to documentation
2807 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
2809 * interfaces/clsql-uffi: Created new directory. Split common
2810 interface routines that use UFFI into this package. Required
2811 especially to support direct reading of 64-bit integers into
2812 bignums and bypassing temporary strings.
2813 * test-clsql.cl: Updated to test postgresql-socket's
2814 read-double-from-socket function.
2815 * test-suite/xptest-clsql.cl
2816 Started work on test suite
2818 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2819 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
2820 mysql-fetch-field-direct Got :auto types working
2821 * interfaces/postgresql/postgresql-api.cl
2822 * interfaces/postgresql-socket/postgresql-socket-api.cl
2823 Added pgsql-field-types enum. Got :auto types working.
2825 Renamed :field-types to :types.
2827 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2828 * Added field-types parameter to query, database-query,
2829 database-query-result-set, map-query. Haven't added code
2830 to utilize field types, yet.
2831 * Changed postgresql-socket result set from cons to a structure
2832 * Updated test-clsql.cl to use automated testing with a config
2834 * Changed return types of field accessors from cstring to
2835 (* :unsigned-char). This prepares for being able to use specified
2836 type conversions when taking field data into lisp.
2837 * Added field-type processing for most interfaces. Not done yet.
2839 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
2840 * doc/ref.sgml: Updated MAP-QUERY example to use
2841 *read-default-float-format* (John Foderaro)
2842 * Extensive work to foreign library loaders and .system files to
2843 check for successful loading of foreign libraries.
2844 * Modified test-clsql.cl to allow more modularity and
2845 automated testing in future release.
2846 * mysql/mysql-sql.lisp: Added field types
2848 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
2849 * mysql/mysql-sql.lisp:
2850 - Added support for Allegro CL and Lispworks using UFFI layer
2851 - Changed database-connect to use mysql-real-connect. This way,
2852 can avoid using double (unwind-protect)
2853 - Changed database-connect to have MySQL library allocate space
2854 for MYSQL structure. This will make the code more robust in
2855 the event that MySQL library changes the size of the mysql-mysql