1 18 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2 * sql/table.lisp: Add PURGE to drop command for oracle 10g backend.
3 To handle this difference, will need to add a new database-drop-table
5 * db-oracle/oracle-sql.lisp: Move server-version and
6 major-version-number to database object to allow multiple connections
7 to Oracle servers of different versions.
9 18 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
10 * TODO: moved notes about backends to doc/TODO.
11 * doc/TODO: added notes about backends and select extensions.
12 * sql/base-classes.lisp: remove obsolete schema slot in database
15 16 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
16 * db-oracle/oracle-api: Add OCIServerVersion
17 * db-oracle/oracle-sql: Query and store server version on connect
18 * sql/db-interface.lisp: Add new db-type-has-bigint? generic
19 function to handle OCI's lack of bigint support
20 * test/test-basic.lisp: Separate bigint testing
21 * test/test-utils.lisp: Add oracle to specs and list of backends
23 * test/test-fdml.lisp: Added FDML/SELECT/34 to test
24 run-time instantiation of variables in reader macros.
25 * TODO: Remove item already complete. Add note about
28 16 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
29 * sql/syntax.lisp: added condition to the reader macro to treat [*]
30 as a column identifier (rather than an operation) for CommonSQL
32 * tests/test-fdml.lisp: add tests for ORDER-BY and SET-OPERATION
33 keword args to SELECT, [*] as column identifier, new MAP-QUERY
34 behaviour and the ANY and ALL operators in subqueries.
35 * tests/test-init.lisp: add set-operation and subquery tests to
36 appropriate skip lists.
37 * sql/objects.lisp: remove redundant and non CommonSQL compatible
38 ORDER-BY-DESCENDING keyword argument for SELECT.
39 * sql/classes.lisp: remove redundant and non CommonSQL compatible
40 ORDER-BY-DESCENDING keyword argument for SELECT.
41 * tests/test-oodml.lisp: add test for ORDER-BY keyword to SELECT
44 15 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
45 * sql/db-interface.lisp: Add new db-type-has-union?
46 since Mysql 3.23 does not support unions.
47 * sql/test-init.lisp: Don't try union tests on database
48 backends which do not support it.
49 * db-oracle/*.lisp: initial port to UFFI
50 * sql/objects.lisp: implement UPDATE-OBJECT-JOINS,
51 implement REFRESH for SELECT.
52 * tests/test-oodml.lisp: Add tests for deferred retrieval,
53 caching, refresh, and update-object-joins
54 * tests/test-init.lisp: Add deferred-employee-address class
56 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
57 * sql/operations.lisp: make MINUS operator a synonym for EXCEPT. Add
58 COALESCE operator and make NVL a synonym for this. Make ANY, SOME,
59 ALL and EXISTS generate function expressions so they output the
61 * sql/classes.lisp: SELECT now generates appropriate SQL when
62 passed the SET-OPERATION and ALL keyword arguments.
63 * sql/classes.lisp: the ORDER-BY keyword argument to SELECT now
64 accepts ordering constraints as pairs of the form (column direction)
65 where direction may be :ASC or :DESC.
66 * tests/test-syntax.lisp: added tests for MINUS and COALESCE/NVL.
67 Correct tests for ANY, SOME, ALL and EXISTS.
68 * tests/test-fdml.lisp: added test for COALESCE.
69 * sql/sql.lisp: MAP-QUERY now applies FUNCTION to QUERY-EXPRESSION
70 using funcall unless QUERY-EXPRESSION returns one column and its
71 FLATP slot is not nil in which case apply is used.
72 * tests/test-basic.lisp: modified calls to MAP-QUERY to reflect the
74 * TODO: remove items done.
75 * db-postgresql/postgresql-sql.lisp: no need to reverse results in
76 DATABASE-LIST-ATTRIBUTES.
77 * db-postgresql-socket/postgresql-socket-sql.lisp: no need to reverse
78 results in DATABASE-LIST-ATTRIBUTES.
80 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
81 * sql/classes.lisp: SELECT now accepts table identifiers as strings
82 for CommonSQL compliance. Add support for qualified sql identifiers
83 with aliased table names.
84 * tests/test-fdml.lisp: added tests for table identifiers as strings
85 in SELECT and for aliased definitions.
86 * tests/test-syntax.lisp: added tests for alias definitions.
88 15 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
89 * sql/sql.lisp: PRINT-QUERY now calls QUERY with result-types and
90 field-names set to nil.
91 * sql/sql.lisp: PRINT-QUERY now computes column sizes correctly
92 with null attribute values.
93 * sql/operations.lisp: modify SQL concatenation operator to accept
95 * sql/syntax.lisp: modify sql reader macro function to accept
96 unescaped sql concatenation operator.
97 * tests/test-fdml.lisp: unescape sql concatenation operator.
98 * tests/test-syntax.lisp: unescape sql concatenation operator.
99 * TODO: remove items done. Add notes about SQLITE/MYSQL backends.
100 Note to add test for universal-time. Note about difference from
101 CommonSQL in transaction handling.
103 13 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
104 * tests/test-init.lisp: Add deferred-employee-address
106 * tests/test-oodml.lisp: Add deferred retrieval testgs
108 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
110 * LATEST-TEST-RESULTS: Run on all platforms, add AMD64
111 * sql/sql.lisp: Add FOR-EACH-ROW macro from clsql-classic/sql.lisp
112 * db-sqlite/sqlite-uffi-api.lisp: Fix row-pointer type
113 * *: Fix minor style warnings
114 * clsql-classic: Remove system and subdirectory
115 * clsql-base: Remove system and subdirectory and
116 fold into clsql system
117 * doc/intro.xml: Remove reference to old clsql-base. Add x86_64
118 as supported platform.
120 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
121 * Version 2.10.16: CLSQL now fully supports AllegroCL AMD64
122 * db-odbc/odbc-api.lisp: work around return-type bug [spr28889] in
123 Allegro 7.0beta AMD64
124 * db-odbc/*.lisp: Add a layer of indirection to foreign-type
125 of ODBC longs since this type can vary on 64-bit platforms depending
126 upon the compilation options of unixODBC.
127 * db-mysql/mysql-api.lisp: Fix int vs. long slots in foreign
128 structures found by testing with AllegroCL 7.0b AMD64.
129 * db-*/*-loader.lisp: Load 64-bit libraries on 64-bit platorms
130 * sql/objects.lisp: Simple implementation of UPDATE-OBJECT-JOINS.
131 Initial caching support for SELECT
132 * tests/test-oodml.lisp: Avoid using cache when testing select.
133 * sql/kmr-mop.lisp: Explicitly check slot order and
134 store as a cl:*feature*
135 * sql/recording.lisp: Remove additional types to
136 increase CommonSQL conformance.
137 * tests/test-init.lisp: Change a :column attribute
138 to test symbols as value
139 * sql/relations.lisp: Remove functions since they don't support
140 many to many relationships.
141 * examples/clsql-tutorial.lisp, doc/csql.lisp: Remove use
142 of add-to-relations function and replace with explicit field settings.
143 * base/classes.lisp: Remove obsolute query-stream. Add record-caches slot.
145 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
147 * LATEST-TEST-RESULTS: results with current version
148 * sql/kmr-mop.lisp: Make CMUCL reader macros specific for cmu18
149 since cmu19 has opposite order of class slots.
150 * sql/objects.lisp: Fix (setf slot-value-using-class) for Lispworks
151 * tests/test-fdml.lisp: Renumber SELECT tests to avoid overwriting
153 * tests/test-init.lisp: Check test-database-underlying-type for
156 8 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
157 * sql/operations.lisp: complete remaining operations for the sql
158 syntax: SUBSTR, SOME, ORDER-BY, GROUP-BY, NULL, DISTINCT, EXCEPT,
159 UNION, INTERSECT, BETWEEN.
160 * sql/classes.lisp: add new classes: SQL-BETWEEN-EXPRESSION,
161 SQL-QUERY-MODIFIER-EXPRESSION and SQL-SET-EXPRESSION.
162 * tests/test-syntax.lisp: add tests for new operations.
163 * tests/test-fdml.lisp: add tests for queries based on new operations.
164 * tests/test-init.lisp: add select/20 to tests skipped for sqlite and
165 select/20, query/5, query/7 and query/8 to tests skipped by mysql.
166 * TODO: removed entries done.
168 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
169 * tests/benchmarks.lisp: Add immediate vs. deferred
172 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
173 * Version 2.10.13: Now works on openmcl 0.14.2
174 * sql/objects.lisp: Add :retrieval :immediate for
176 * tests/test-init.lisp: Add non-index fields for testing
177 join class employee-addresss
178 * test/test-oodml.lisp: Add tests for retrieval immediate
179 * sql/metaclasses.lisp: Handle differences in direct-slot-definition
180 values which are now listifed by openmcl 14.2.
181 * sql/objects.lisp: more framework for supporing immediate retrieval
183 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
184 * docs/intro.xml: Upload location of a README file
185 * sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
186 changing the type-specifier. Use a lisp type of (OR NULL FOO)
187 for a specified-type of FOO unless :db-constraints :not-null.
188 No need to specialize finalize-inheritance for openmcl.
189 * tests/test-*.lisp: Rename fields so that joins occur on
190 fields with different names. This ensures that join code is
191 selecting the proper name.
192 * test/test-init.lisp: Add :base-table for employee-address
193 view class for testing.
194 * sql/objects.lisp: Use view-table rather than name of table
195 in a number of places to fix errors noted with using :base-table.
197 6 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
198 * sql/objects.lisp: replace *update-records-on-make-instance* with
199 *db-auto-sync* which also controls both automatic creation of
200 new records on creation of new instance and updating of record
201 fields on setting of instance slots (as suggested by Edi Weitz).
202 * tests/test-init.lisp: replace *update-records-on-make-instance*
204 * sql/package.lisp: replace *update-records-on-make-instance*
206 * TODO: replace *update-records-on-make-instance* with *db-auto-sync*.
207 * sql/objects.lisp: remove redundant rebindings of *db-initializing*
208 and *default-database* in FIND-ALL.
209 * sql/package.lisp: import time functions from CLSQL-BASE.
210 * tests/test-time.lisp: replace CLSQl-BASE package qualifier with CLSQL.
211 * tests/test-fdml.lisp: replace CLSQl-BASE package qualifier with CLSQL.
212 * tests/test-init.lisp: replace CLSQl-BASE package qualifier with CLSQL.
213 * tests/test-ooddl.lisp: replace CLSQl-BASE package qualifier with
216 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
217 * sql/classes.lisp: Add SQL-OBJECT-QUERY type. Have [select 'class]
218 now return a sql-object-query type rather than directly performing a query.
219 This improves CommonSQL conformance.
220 * sql/sql.lisp: Add new QUERY method for SQL-OBJECT-QUERY. Move
221 from basic/basic-sql.lisp the DO-QUERY and MAP-QUERY since they now
222 depend on sql-object-query-type.
223 * sql/loop-extensions.lisp: Move from base package
224 * classic/package.lisp: remove references to map-query and do-query
226 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
227 * TODO: New section on optimizations, especially optimizing JOINs.
228 * sql/objects.lisp: Have :target-slot return of list of lists rather
229 than a list of cons pairs to be conformant with CommonSQL.
230 Make :target-slot much more efficient by using a SQL inner join
231 statement and just requiring one SQL query. Add :retrieval :deferrred
232 to target-slot joins. Add placeholder for update-objects-join.
233 * sql/classes.lisp: Add :inner-join and :on slots to sql-query class
234 and process them for query output-sql.
236 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
238 * base/basic-sql.lisp: Avoid multiple evaluation
239 of query-expression in DO-QUERY
240 * sql/objects.lisp: Make SELECT a normal function.
241 SELECT now accepts type-modified database identifiers, such as
242 [foo :string] which means that the values in column foo are returned
243 as Lisp strings. Add new *update-records-on-make-instance* special
244 variable controlling automatic creation of new instances. Add missing
245 RESULT-TYPES keyword to FIND-ALL. Add :target-slot support.
246 * sql/packages.lisp: Export *update-records-on-make-instance*
247 * test/test-oodml.lisp: Add tests for :target-slot and many-to-many
249 * test/test-fdml.lisp: Add tests for type-modified
250 database identifiers.
251 * test/test-init.lisp: Stop using add-relation since implementing
252 many-to-many joins. Use *update-records-on-make-instance*
253 to automatically store records on instance creation. Add many-to-many
254 employee-address view-class.
256 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
258 * base/loop.lisp: Add object iteration. Use :result-type
259 :auto for result-set. Remove
260 duplicate (and non-correct) code for non-list variables by
261 simply making an atom variable into a list.
262 * sql/package.lisp: Remove unnecessary clsql-sys package
263 and replace it with clsql.
264 * sql/metaclasses.lisp: Properly store specified-type from
265 direct-slot-definition and then store translated type in
266 effective-slot-definition
267 * sql/classes.lisp: Don't output type in sql-output
268 for SQL-IDENT-ATTRIBUTE. This is in preparation for supporting
269 [foo :integer] as fields in SELECT.
270 * sql/query.lisp: Set default for :result-types to :auto in
272 * sql/objects.lisp: Use specified-type when invocating
273 database-get-type-specifier. def-view-class macro now returns
275 * base/basic-sql.lisp: Make :AUTO the default value for
276 :RESULT-TYPES for MAP-QUERY and DO-QUERY.
277 * sql/objects.lisp: Add bigint type
278 * test/tests-basic.lisp: Add tests for :result-types for
279 MAP-QUERY and DO-QUERY
280 * test/test-fdml.lisp: Add test for result-types in LOOP
281 and also using single symbol rather than a list for variables.
282 Add test that default :result-types is auto for FDML QUERY.
283 * test/test-syntax.lisp: Don't expect TYPE in the SQL-OUTPUT
284 of SQL-IDENT-ATTRIBUTE.
285 * test/test-oodml.lisp: Enable OO loop iteration test,
286 modify it so it doesn't depend on boolean where.
288 4 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
290 * sql/objects.lisp: added derived type specifier for universal time.
291 * sql/package.lisp: added #:universal-time to clsql-sys exports.
292 * tests/test-oodml.lisp: added test for translation of boolean slots
293 in SELECT with object queries.
295 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
296 * db-odbc/odbc-api.lisp: Fix changing nil to "NIL"
297 for odbc/postgresql backend.
298 * db-odbc/odbc-sql.lisp: Fix ATTRIBUTE-TYPE so that
299 it can handle NIL values from the ODBC driver
300 * tests/benchmarks.lisp: New file with initial
302 * sql/relations.lisp: fix to add subclassing support,
303 minor optimizations [Edi Weitz]
305 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
307 * base/conditions.lisp: Add *backend-warning-behavior*
309 * db-postgresql-socket/postgresql-socket-sql.lisp:
310 Honor value of *backend-warning-behavior*
311 * tests/test-fdml.lisp: Remove test of raw boolean value
312 since different backends handle this differently. Add
313 test for :column attribute.
314 * tests/test-oodml.lisp: Add tests for boolean slot value
315 and for :void-value attribute
316 * tests/test-init.lisp: Use *backend-warning-behavior*
317 to suppress warnings from postgresql about implicitly
318 creating primary key in tables. Add new address table.
320 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
322 * db-odbc/odbc-dbi.lisp: Convert TINYINT to integers when
323 result-types is :auto
324 * sql/objects.lisp: Properly handled writing/reading Boolean
325 values from SQL database when retrieving objects.
326 * test/test-fdml.lisp: Add another test for boolean results
327 * test/utils.lisp: Fix incorrect declaration
329 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
331 * sql/generics.lisp: add generic function for SELECT.
332 * sql/objects.lisp: make SELECT a method specialisation.
333 * sql/classes.lisp: MAKE-QUERY now calls SELECT if the selections
334 referred to are View Classes.
335 * base/basic-sql.lisp: in DO-QUERY and MAP-QUERY, if the
336 query-expression arg evaluates to a list, then we have an object
338 * tests/test-oodml.lisp: add tests for DO-QUERY and MAP-QUERY with
340 * TODO: remove items done and add a todo for SELECT.
341 * sql/objects.lisp: SELECT takes a :field-names arg to pass on to
343 * sql/sql.lisp: add :field-names arg to QUERY.
344 * tests/test-fdml.lisp: minor rework to use :field-names arg to
347 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
348 * sql/objects.lisp: fix bug in FIND-ALL when SELECT called with 2
349 or more View Classes.
350 * sql/objects.lisp: make the :flatp argument to SELECT work with
352 * sql/objects.lisp: make SELECT accept a :result-types argument
353 (defaults to :auto) which is passed on to QUERY.
354 * sql/objects.lisp: SELECT returns field-names as a second value.
355 * tests/test-ooddl.lisp: add flatp arg to SELECT calls as appropriate.
356 * tests/test-fdml.lisp: add flatp/result-types arguments to calls
357 to SELECT and take only first value as appropriate.
358 * tests/test-fdml.lisp: add two new tests for query result coercion
359 and the field-names returned as a second value from SELECT.
360 * tests/test-oodml.lisp: add flatp arg to SELECT calls as appropriate.
362 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
363 * Version 2.10.6-pre1
364 * sql/metaclasses.lisp: Add void-value slot
365 * doc/csql.xml: Update def-view-class documentation
366 * test/test-init.lisp: Change old :db-type to :db-kind.
367 Remove old :nulls-ok attributes.
368 * sql/objects.lisp: Add new universal-time and bigint
369 types. Optimize reading of integers using parse-integer
370 rather than read-from-string.
371 * */*.lisp: Merge clsql-base-sys and clsql-base packages
372 into clsql-base package
373 * classic/sql.lisp: Move large object support into base, leaving
374 classic without any functionality that is provided in the clsql
376 * classic/package.lisp: Rename clsql-classic-sys package to
377 its former nickname of clsql-classic
379 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
380 * Version 2.10.5: SQLite backend now passes all result-types tests
381 * clsql-sqlite.asd: Depend on clsql-uffi system
382 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
383 for efficiency and code reuse.
384 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
385 for better cross-implementation compatibility.
387 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
389 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
391 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
392 bug on SBCL in result-field-names function as reported by Marcus Pearce
393 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
394 manifest in SBCL testing
396 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
398 * sql/database.lisp: Conform more to CommonSQL output
399 for STATUS command [Marcus Pearce]
400 * sql/sqlite-sql.lisp: Rework to use result-types
401 * sql/sqlite-api-clisp.lisp: Add compatibility layer
402 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
403 be cleaned up of most clisp reader conditionals
404 * sql/test-init.lisp: Now run field type tests on sqlite
407 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
409 * base/basic-sql.lisp: Set default value of :result-types
410 to :auto for more CommonSQL conformance.
411 * test/test-fdml.lisp: Add tests for numeric value of fields
414 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
415 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
416 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
417 Return field names as second value for QUERY. This can be overridden
418 for efficiency with the new keyword :FIELD-NAMES set to NIL
419 in the QUERY invocation.
420 * test/test-fdml.lisp: Add tests for new field-name feature
421 * sql/metaclass.lisp: Remove old Lispworks cruft
422 and replace it with invocation of new code in kmr-mop.lisp
423 which actually works with Lispworks 4.2
424 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
426 * base/db-interface.lisp: Document the multiple values
427 returned by DATABASE-ATTRIBUTE-TYPE so matches the
428 undocumented CommonSQL behavior.
429 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
430 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
431 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
432 Implement CACHE-TABLE-QUERIES.
433 * db-odbc/odbc-sql.lisp: Fix attribute-type function
434 * test/test-fddl.lisp: Add tests for attribute type
435 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
437 * base/classes.lisp: Add attribute-cache slot to database clas
438 * base/initialize.lisp: initialize-database-type now automatically
439 loads database-type backend as needed.
440 * base/test-init.lisp: Utilize new initialize-database-type functionality.
441 * TODO: remove items done
443 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
445 * sql/objects.lisp: remove create/drop-sequence-from-class.
446 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
447 * sql/objects.lisp: improved CommonSQL compatibility for
448 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
449 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
450 * sql/generics.lisp: move generics from objects.lisp to here.
452 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
454 * db-mysql/mysql-client-info.lisp: Add client version 4.1
456 * sql/sql.lisp: Make *default-database* the default for
459 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
461 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
463 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
464 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
465 on a metaclass specialized from standard-db-class.
468 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
469 * Version 2.9.4: Multiple changes to support Allegro's "modern"
470 lisp which uses a lowercase reader and has case-sensitive symbols
471 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
472 exposed by case-sensitive mlisp.
474 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
475 * Version 2.9.3: All tests now pass on all platforms!
476 * LATEST-TEST-RESULTS: New file with summary of test results
477 * sql/generics.lisp: New file for generic function definitions.
478 * test/test-init.lisp: Display names of skipped tests.
479 Use unwind-protect to ensure disconnect
480 * sql/objects.lisp: Change database-type to database-underlying-type
481 so that actual database engine is properly identified
482 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
483 return an ISO timestring for compatibility with other drivers.
484 Workaround bug in MyODBC for LIST-TABLE-INDEXES
485 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
486 returns floating-point values for floor and truncate operations
487 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
488 * tests/test-basic.lisp: Port to regression tester
489 * test/test-init.lisp: Output to *report-stream*
490 * docs/appendix.xml: Document ODBC and SQLite backends.
491 * sql/classes.lisp: Make output-sql require a database parameter.
492 This allows SQL generation to have the proper case to support
493 the differences in case handling between CommonSQL API,
494 Postgresql, MySQL, Oracle.
496 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
497 * Version 2.9.2: Improvments in database capability introspection
498 and querying. Support transactions in MySQL where available.
499 All tests now pass on MySQL and SQLite in addition to postgresql
500 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
501 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
502 DATABASE-LIST-SEQUENCES.
503 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
504 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
505 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
506 * tests/*.lisp: Check database capabilities and remove tests which
507 the database backend does not support
508 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
509 controls whether InnoDB tables will be created when supported on
510 the underlying MySQL server.
512 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
513 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
514 supported by all database backends (except AODBC since
515 AODBC doesn't support index querying)
516 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
517 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
518 to support index queries
519 * db-aodbc/aodbc-sql.lisp: Filter driver manager
520 "information_schema" tables from LIST-TABLES
521 * tests/test-basic.lisp: Remove table after testing
522 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
523 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
524 which gets the underlying type of database -- required
525 when dealing with ODBC databases and want to query
526 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
527 as first database-backend specific feature. Is T on
528 :mysql, NIL on other backends. Change DROP-TABLE to
531 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
532 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
534 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
536 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
537 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
539 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
540 * Version 2.8.0: New API function: LIST-DATABASES
541 * base/utils.lisp: Fix command-output on CMUCL/SBCL
542 * db-*/*-sql.lisp: Add new database-list function
543 * base/database.lisp: Add new LIST-DATABASES command
545 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
547 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
548 * db-sqlite/sqlite-api-uffi.lisp: Print error string
551 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
553 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
556 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
558 * base/objects.lisp, base/classes.lisp: Patch
559 for db-kind from Eduardo Munoz
561 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
563 * base/basic-sql.lisp: Fix FLATP in QUERY
565 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
566 * Version 2.7.3: Implement RECONNECT
568 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
569 * Version 2.7.2: Fix ODBC on Lispworks Windows
571 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
572 * Version 2.7.1: Fix for new ODBC backend.
573 clsql-odbc now works on SBCL, CMUCL, OpenMCL
574 in addition to AllegroCL and Lispworks.
576 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
577 * Version 2.7.0: New backend: ODBC. Tests as
578 well as AODBC backend on Allegro,Lispworks.
579 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
580 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
581 to explicitly set ODBC2 support. Add BIGINT support.
582 Add result-types support. Added SQLTables.
583 Fix array type in fetch-all-rows. Make width
584 changable by database or query.
585 * base/utils.lisp: Add process functions
586 * base/package.lisp: Export utils to CLSQL-BASE-SYS
587 * db-aodbc: Implement sequence functions,
588 database-list-tables, database-list-attributes
589 * tests/utils.lisp: Add support for ODBC backend,
590 rework READ-SPECS to use +all-db-types+
591 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
594 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
595 * Version 2.6.13. Requires UFFI version 1.4.9
596 * db-odbc/*.lisp: Further porting.
597 Pre-alpha code! But, basic query is now working.
599 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
601 * base/transactions.lisp: Add quote for macro
602 expansion of WITH-TRANSACTIONS [Time Howe]
603 * db-sqlite/sqlite-sql.lisp: Support memory database
604 in database-probe [Ng Pheng Siong]
605 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
606 The DBI layer is not finished.
608 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
610 * sql/objects.lisp: add :root-class functionality for
611 list-classes and add duration type support [Marcus Pearce]
612 * db-odbc: Add mid-level [DBI] layer
614 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
616 * db-aodbc: Add methods for generic functions, some are
618 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
621 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
623 * base/package.lisp: Add missing symbols [Marcus Pearce]
625 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
627 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
628 * utils/time.lisp: Multiple fixes [Marcus Pearce]
629 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
631 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
633 * sql/*.lisp: Remove schema versioning cruft
635 * Makefile: Add classic subdirectory
637 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
639 * sql/sql.lisp: Fix TRUNCATE command, bug reported
641 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
642 specific and easy for an application to directly support.
643 Idea from Marcus Pearce.
644 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
645 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
646 Keep low-level interface for future optimization
647 supporting LIST-ATTRIBUTE-TYPES command.
648 * Makefile: Add to db-sqlite and test directories.
649 Include them in top-level Makefile
651 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
653 * sql/relations.lisp: Add missing file
654 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
655 * test/test-time.lips: New file [Marcus Pearce]
657 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
659 * test/test-init.lisp: Properly handle object
660 creation. Close database after use.
661 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
662 function so can have methods specialized on
663 table being a string or an sql-table object.
664 * base/pool.lisp: Really fix CMUCL locking
666 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
668 * test/test-init.lisp: Signal correctly
669 if any errors occurred in any test suite
670 * base/loop-extensions.lisp: Fix error
671 introduced for Lispworks
672 * base/pool.lisp: Fix locking for CMUCL
673 * base/objects.lisp: Remove schema-version cruft
675 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
676 * Version 2.6.2: New CLSQL API functions:
677 DESCRIBE-TABLE AND TRUNCATE-DATABASE
678 Currently, this are only supported on :postgresql
679 and :postgresql-socket
680 * base/database.lisp: automatically load ASDF system
681 in CONNECT if not already loaded
682 * base/tests.lisp: disconnect database after testing
683 * base/*.lisp: Remove CLOSED-DATABASE type in favor
684 of storing open/closed status in slot of database
685 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
686 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
687 DATABASE-DESCRIBE-TABLE
688 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
689 * base/conditions: Remove duplicate condition
690 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
691 * base/recording.lisp: Add new :QUERY type for recording
693 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
694 * Version 2.6.1: documentation fixes, merged
695 classic-tests into tests
697 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
698 * Version 2.6.0 released: New API functions
699 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
700 * doc/ref_clsql.xml: Document new functions
701 * base/database.lisp: New API functions
702 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
703 * base/utils.lisp: Fix use of position-char.
704 Add COMMAND-OUTPUT used by backends for running
705 external programs. Fix parsing of SQL*NET-compatible
707 * base/loop-extension.lisp: Simplify package use
708 for Lispworks and Allegro
709 * db-*/*-sql.lisp: Added DATABASE-CREATE,
710 DATABASE-DESTORY, PROBE-DATABASE methods
711 * tests/test-init.lisp, clasic-tests/tests.lisp:
712 Use destroy-database and create-database to ensure
713 testing with empty database
714 * tests/test-connection.lisp: Add tests for
715 parsing of string connection-specs
716 * examples/run-tests.sh: New file for running
717 test suite on all installed CL implementations
718 * examples/clsql-tutorial.lisp: moved from
720 * examples/dot.clsql-tests.config: New file
721 giving an example test configuration
722 * test/README: Add notes about rtest/ptester
723 downloads and link to sample test configuration file.
725 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
726 * Version 2.5.1 released:
727 * tests/*.lisp: Rework so tests are run
728 on multiple backends automatically based
729 on the contents of ~/.clsql-tests.config.
730 Reuse helper functions from classic-tests.
731 * base/database.lisp: Support connection-spec
732 as string for CONNECT
733 * classic-tests/tests.lisp: Automatically
734 load database backends as needed.
736 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
737 * Version 2.5.0 released:
738 All tests for CLSQL and CLSQL-CLASSIC pass
740 * base/loop-extension.lisp: Add Lispworks
741 loop-extension. Improve type specifying on
744 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
745 * Version 2.4.2 released:
746 loop extension now supported on Allegro, all
747 CLSQL-TESTS pass on Allegro.
748 * sql/metaclasses.lisp: Some optimization
749 of compute-slots, be selective when
750 ordered-class-slots needs to be called
751 instead of class-slots
752 * TODO: add URL with documentation on
753 extending Lispworks LOOP form
755 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
756 * Version 2.4.1 released: CLSQL-TESt suite passes
757 all tests for postgresql and CMUCL, SBCL, OpenMCL.
758 Allegro and Lispworks pass all tests except for
759 FDML/LOOP/1 since the loop extension have not yet
760 been ported to those implementions.
761 * sql/metaclasses.lisp: Added new slot to standard-db-class
762 to hold user-specified type. OpenMCL adjustments to compensate
763 for its type-predicate function. Since AllegroCL, Lispworks,
764 and OpenMCL have different slot orders, added compute-slots
765 and ordered-class-slots functions so their slot order matches
768 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
769 * Version 2.4.0 released: All tests for clsql-classic now finish
770 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
771 mysql, postgresql, postgresql-sockets, and sqlite backends.
772 * db-mysql/mysql-sql.lisp: Fix array dereferencing
773 * classic-tests/tests.lisp: Fix package name of
774 number-to-sql-string.
775 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
776 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
777 now passes tests on all support UFFI platforms.
778 * db-postgresql-socket/postgresql-socket-api.list: Ported to
780 * multiple: Finish renaming of :types keyword to :result-types for
781 greater CommonSQL compatibility, including documentation
782 * sql/basic-cmds.lisp: Remove obsolete file
784 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
785 * Version 2.3.3 released
786 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
787 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
788 * Fix for schema table [Marcus Pearce]
789 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
790 * Fixes to test suite [Marcus Pearce]
792 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
793 * db-*/*-sql.lisp: Ensure that expr in
794 database-query-result-set is a string
795 * Documentation integration
797 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
798 * With for Marcus Pearce's excellent work, I've merged
799 his clsql-usql port into clsql. The original clsql
800 interface is available in the clsql-classic package.
802 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
803 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
804 adding further support for providing backend for UncommonSQL
806 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
807 * Integrate patch from Aurelio Bignoli for SQLite backend
809 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
810 * Converted documentation to XML format
811 * Made package installable with asdf-install
813 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
814 * Add for-each-row macro
816 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
817 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
819 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
820 * Add support for SBCL, OpenMCL, and SCL
821 * Add *load-truename* to search path for clsql's
824 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
825 * Rework use of file types in .asd files
827 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
828 * Add .asd definition files for ASDF users
830 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
831 * Restructure directories for Common Lisp Controller v3 compatibility
833 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
834 * Also change case of logical host in loader files
835 * Rework handling of logical pathnames
837 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
838 * Change case of logical host
840 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
841 * clsql-base.system: Added base package that can be used without
842 high-level SQL commands. Used for adding support for UncommonSQL.
843 * *.system: Reworked logical pathnames to be more consistent with
844 Common Lisp Controller.
845 * debian/*: Completed initial Debian support
847 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
849 * sql/transactions.cl:
850 Added transaction support. Functions/macros added:
851 with-transaction, commit-transaction, rollback-transaction,
852 add-transaction-commit-hook, add-transaction-rollback-hook
854 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
858 Added pool support in connect/disconnect and with-database.
859 Removed with-db-from-pool as with-database can now works with the connections pool
861 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
866 Completed connection pool.
867 Added with-db-from-pool macro.
869 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
871 Added initial support for connection pool
872 * sql/transactions.cl
873 Took transaction code from UncommonSQL and integrated
874 into CLSQL code. See file for disclaimer about why this
877 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
878 * interfaces/postgresql/postgresql-sql.cl:
879 Fix keyword typo in database-read-large-object
880 * interfaces/mysql/mysql-loader.cl
882 * test-suite/tester-clsql.cl
883 Fix type coercion of double-float
885 Added debian docbook catalog, made it the default
887 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
888 * interface/postgresql/postgresql-api.cl:
889 * interface/postgresql/postgresql-sql.cl:
891 * sql/db-interface.cl:
892 Added large objects support for postgresql.
894 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
895 * src/postgresql-socket/postgresql-socket-api.cl:
896 Fixed find-foreign-function call, eliminated crypt warning
898 Multiple improvements
900 Moved functionality from low-level interfaces to this file
901 via generic functions
902 * test-suite/tester.cl:
903 Added test with acl-compat-tester, moved others to old-tests
906 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
908 Reinstated commented out sections
909 * interfaces/postgresql/postgresql-loader.cl:
910 * interfaces/mysql/mysql-loader.cl:
911 Updated find-forieign-library support.
912 * interfaces/postgresql-socket/postgresql-socket-package.cl:
913 Fixed require form for Lispworks (Thanks Marc Battyani!)
914 * interfaces/postgresql-socket/postgresql-socket-api.cl:
915 Fixed eval of def-function for crypt library.
917 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
918 * Added interface to support USQL high-level rouines
920 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
921 * Separated db-interface and conditions from sql/sql.cl
922 * Improved foreign library loading testing
923 * interfaces/postgresql/postgresql-api.cl
924 Added PQisBusy function
925 * interfaces/clsql-uffi/clsql-uffi.cl
926 Fixed sign error for 64-bit processing
928 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
929 * interfaces/postgresql-socket/postgresql-socket-api.cl:
930 Fixes to read-double-from-socket. Added 64-bit integer support.
931 * test-suite/xptest-clsql.cl
932 Added testint for 64-bit integers
933 * Additons to installation docs
935 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
936 * interfaces/postgresql-socket/postgresql-socket-api.cl:
937 Implemented direct socket reading for field type :double
938 * Added usage information for :types to documentation
939 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
941 * interfaces/clsql-uffi: Created new directory. Split common
942 interface routines that use UFFI into this package. Required
943 especially to support direct reading of 64-bit integers into
944 bignums and bypassing temporary strings.
945 * test-clsql.cl: Updated to test postgresql-socket's
946 read-double-from-socket function.
947 * test-suite/xptest-clsql.cl
948 Started work on test suite
950 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
951 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
952 mysql-fetch-field-direct Got :auto types working
953 * interfaces/postgresql/postgresql-api.cl
954 * interfaces/postgresql-socket/postgresql-socket-api.cl
955 Added pgsql-field-types enum. Got :auto types working.
957 Renamed :field-types to :types.
959 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
960 * Added field-types parameter to query, database-query,
961 database-query-result-set, map-query. Haven't added code
962 to utilize field types, yet.
963 * Changed postgresql-socket result set from cons to a structure
964 * Updated test-clsql.cl to use automated testing with a config
966 * Changed return types of field accessors from cstring to
967 (* :unsigned-char). This prepares for being able to use specified
968 type conversions when taking field data into lisp.
969 * Added field-type processing for most interfaces. Not done yet.
971 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
972 * doc/ref.sgml: Updated MAP-QUERY example to use
973 *read-default-float-format* (John Foderaro)
974 * Extensive work to foreign library loaders and .system files to
975 check for successful loading of foreign libraries.
976 * Modified test-clsql.cl to allow more modularity and
977 automated testing in future release.
978 * mysql/mysql-sql.lisp: Added field types
980 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
981 * mysql/mysql-sql.lisp:
982 - Added support for Allegro CL and Lispworks using UFFI layer
983 - Changed database-connect to use mysql-real-connect. This way,
984 can avoid using double (unwind-protect)
985 - Changed database-connect to have MySQL library allocate space
986 for MYSQL structure. This will make the code more robust in
987 the event that MySQL library changes the size of the mysql-mysql