Kevin M. Rosenberg [Fri, 21 May 2004 14:33:46 +0000 (14:33 +0000)]
r9424: * db-oracle/oracle-sql: Use clsql-specific error conditions. Use owner keyword.
Kevin M. Rosenberg [Fri, 21 May 2004 03:19:07 +0000 (03:19 +0000)]
r9423: fix case of test names
Kevin M. Rosenberg [Fri, 21 May 2004 03:06:38 +0000 (03:06 +0000)]
r9422: 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* db-oracle/make9.sh: add makefile for building with Oracle 9 client
libraries
* sql/table.lisp: Add logic for dealing with Oracle 10g vs. previous
Oracle versions with the PURGE option required for drop table. This needs
to be converted to a generic function and moved to db-oracle/oracle-sql.lisp
2
Marcus Pearce [Fri, 21 May 2004 01:02:12 +0000 (01:02 +0000)]
r9421: Docstrings for table.lisp
Kevin M. Rosenberg [Thu, 20 May 2004 17:14:48 +0000 (17:14 +0000)]
r9417: * sql/oracle-sql.lisp: Now compiles and runs on SBCL.
Requires UFFI 1.5.0 or higher
Kevin M. Rosenberg [Thu, 20 May 2004 12:31:47 +0000 (12:31 +0000)]
r9416: 20 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* Version 2.10.19
* sql/conditions.lisp: Fix cerror
Kevin M. Rosenberg [Thu, 20 May 2004 12:31:19 +0000 (12:31 +0000)]
r9415: fix for cerror
Kevin M. Rosenberg [Thu, 20 May 2004 09:49:51 +0000 (09:49 +0000)]
r9411: fix caching of order-by clauses
Kevin M. Rosenberg [Thu, 20 May 2004 09:06:14 +0000 (09:06 +0000)]
r9410: fix case where reading a float which is already convert to a float by the backend
Kevin M. Rosenberg [Thu, 20 May 2004 08:55:12 +0000 (08:55 +0000)]
r9409: fix :cstring compilation on cmucl/sbcl
Kevin M. Rosenberg [Thu, 20 May 2004 08:42:57 +0000 (08:42 +0000)]
r9408: 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/db-interface.lisp: Add more default methods
* sql/objects.lisp: Add explicit table name to order-by parameters
in find-all when only one table to avoid selecting a duplicate row.
Fix error in FIND-ALL when using :order-by such as (([foo] :asc))
as previous logic was adding two fields (foo asc) to SELECT query.
* db-oracle/*.lisp: Much improvements, now passes 90% of test suite
Kevin M. Rosenberg [Thu, 20 May 2004 02:10:01 +0000 (02:10 +0000)]
r9407: add missing \#: to some test names
Kevin M. Rosenberg [Thu, 20 May 2004 00:06:42 +0000 (00:06 +0000)]
r9404: update for new condition name
Kevin M. Rosenberg [Wed, 19 May 2004 23:46:45 +0000 (23:46 +0000)]
r9403: Rework conditions to be CommonSQL backward compatible
Marcus Pearce [Wed, 19 May 2004 23:07:05 +0000 (23:07 +0000)]
r9402: Reworked docstrings.
Kevin M. Rosenberg [Wed, 19 May 2004 15:01:43 +0000 (15:01 +0000)]
r9399: 19 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/package.lisp: Export initialize-database-type and
*initialize-database-types* from CLSQL package.
Kevin M. Rosenberg [Tue, 18 May 2004 22:39:27 +0000 (22:39 +0000)]
r9398: oracle backend now compiles on sbcl/lispworks
Kevin M. Rosenberg [Tue, 18 May 2004 18:48:39 +0000 (18:48 +0000)]
r9395: 18 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/table.lisp: Add PURGE to drop command for oracle 10g backend.
To handle this difference, will need to add a new database-drop-table
generic function.
* db-oracle/oracle-sql.lisp: Move server-version and
major-version-number to database object to allow multiple connections
to Oracle servers of different versions.
Marcus Pearce [Tue, 18 May 2004 09:51:00 +0000 (09:51 +0000)]
r9389: Additions to doc/TODO.
Kevin M. Rosenberg [Tue, 18 May 2004 03:15:04 +0000 (03:15 +0000)]
r9388: * db-oracle/oracle-api: Add OCIServerVersion
* db-oracle/oracle-sql: Query and store server version on connect
* sql/db-interface.lisp: Add new db-type-has-bigint? generic
function to handle OCI's lack of bigint support
* test/test-basic.lisp: Separate bigint testing
* test/test-utils.lisp: Add oracle to specs and list of backends
Kevin M. Rosenberg [Mon, 17 May 2004 02:57:10 +0000 (02:57 +0000)]
r9387: * test/test-utils.lisp: Add oracle to specs and list of backends
Kevin M. Rosenberg [Sun, 16 May 2004 21:59:25 +0000 (21:59 +0000)]
r9385: simple queries now work
Kevin M. Rosenberg [Sun, 16 May 2004 20:56:16 +0000 (20:56 +0000)]
r9383: rename file for consistency with other backends
Kevin M. Rosenberg [Sun, 16 May 2004 20:55:35 +0000 (20:55 +0000)]
r9382: now connects, disconnects, and executes statements
Kevin M. Rosenberg [Sun, 16 May 2004 18:33:36 +0000 (18:33 +0000)]
r9379: Add note about
condition variances
Kevin M. Rosenberg [Sun, 16 May 2004 14:33:38 +0000 (14:33 +0000)]
r9378: * test/test-fdml.lisp: Added FDML/SELECT/34 to test
run-time instantiation of variables in reader macros.
* TODO: Remove item already complete
Kevin M. Rosenberg [Sun, 16 May 2004 13:55:03 +0000 (13:55 +0000)]
r9377: add building of shared library
Kevin M. Rosenberg [Sun, 16 May 2004 13:40:07 +0000 (13:40 +0000)]
r9376: 6 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* doc/TODO: New file
Kevin M. Rosenberg [Sun, 16 May 2004 13:19:41 +0000 (13:19 +0000)]
r9375: fix conflicted merge
Marcus Pearce [Sun, 16 May 2004 11:47:13 +0000 (11:47 +0000)]
r9374: Remove redundant and commonsql incompatible order-by-descending keyword arg to select.
Marcus Pearce [Sun, 16 May 2004 11:17:49 +0000 (11:17 +0000)]
r9373: Treat [*] as a column identifier.
Kevin M. Rosenberg [Sun, 16 May 2004 08:57:35 +0000 (08:57 +0000)]
r9372: further uffi porting
Kevin M. Rosenberg [Sun, 16 May 2004 08:57:26 +0000 (08:57 +0000)]
r9371: minor formatting change
Kevin M. Rosenberg [Sun, 16 May 2004 08:12:44 +0000 (08:12 +0000)]
r9370: * sql/db-interface.lisp: Add new db-type-has-union?
since Mysql 3.23 does not support unions.
* sql/test-init.lisp: Don't try union tests on database
backends which do not support it.
Kevin M. Rosenberg [Sun, 16 May 2004 07:02:10 +0000 (07:02 +0000)]
r9369: add directory where redhat as3 keeps library
Kevin M. Rosenberg [Sun, 16 May 2004 06:56:18 +0000 (06:56 +0000)]
r9368: initial port to uffi
Kevin M. Rosenberg [Sun, 16 May 2004 05:12:10 +0000 (05:12 +0000)]
r9367: initial import
Kevin M. Rosenberg [Sun, 16 May 2004 01:30:25 +0000 (01:30 +0000)]
r9366: pending new version
Kevin M. Rosenberg [Sun, 16 May 2004 01:28:40 +0000 (01:28 +0000)]
r9365: 15 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* Version 2.10.18: Caching and refreshing complete
* sql/objects.lisp: implement UPDATE-OBJECT-JOINS,
implement REFRESH for SELECT.
* tests/test-oodml.lisp: Add tests for deferred retrieval,
caching, refresh, and update-object-joins
* tests/test-init.lisp: Add deferred-employee-address class
Marcus Pearce [Sun, 16 May 2004 01:05:48 +0000 (01:05 +0000)]
r9364: Various fixes from CommonSQL Tutorial.
Marcus Pearce [Sat, 15 May 2004 13:07:11 +0000 (13:07 +0000)]
r9361: Support for qualified sql identifiers with aliased table names.
Marcus Pearce [Sat, 15 May 2004 12:22:31 +0000 (12:22 +0000)]
r9360: Strings as table identifiers in SELECT.
Marcus Pearce [Sat, 15 May 2004 10:44:54 +0000 (10:44 +0000)]
r9359: Fixes for PRINT-QUERY and sql concatenation operator (||).
Kevin M. Rosenberg [Fri, 14 May 2004 20:25:00 +0000 (20:25 +0000)]
r9357: initial update-object-joins
Kevin M. Rosenberg [Thu, 13 May 2004 18:01:13 +0000 (18:01 +0000)]
r9355: updates
Kevin M. Rosenberg [Thu, 13 May 2004 13:44:43 +0000 (13:44 +0000)]
r9353: package name change
Kevin M. Rosenberg [Thu, 13 May 2004 10:51:46 +0000 (10:51 +0000)]
r9347: Automated commit for Debian build of clsql upstream-version-2.10.17
Kevin M. Rosenberg [Thu, 13 May 2004 10:50:08 +0000 (10:50 +0000)]
r9346: Automated commit for Debian build of clsql upstream-version-2.10.17
Kevin M. Rosenberg [Thu, 13 May 2004 10:49:39 +0000 (10:49 +0000)]
r9345: * LATEST-TEST-RESULTS: Run on all platforms, add AMD64
* doc/intro.xml: Remove reference to old clsql-base. Add x86_64
Kevin M. Rosenberg [Thu, 13 May 2004 10:41:14 +0000 (10:41 +0000)]
r9344: fix type on sqlite
Kevin M. Rosenberg [Thu, 13 May 2004 10:21:23 +0000 (10:21 +0000)]
r9342: * db-sqlite/sqlite-uffi-api.lisp: Fix row-pointer type
* *: Fix minor style warnings
Kevin M. Rosenberg [Thu, 13 May 2004 08:13:39 +0000 (08:13 +0000)]
r9339: add missing symbols
Kevin M. Rosenberg [Thu, 13 May 2004 08:07:27 +0000 (08:07 +0000)]
r9338: fix database-query calls
Kevin M. Rosenberg [Thu, 13 May 2004 08:00:00 +0000 (08:00 +0000)]
r9337: package rename
Kevin M. Rosenberg [Thu, 13 May 2004 06:55:48 +0000 (06:55 +0000)]
r9336: 12 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/sql.lisp: Add FOR-EACH-ROW macro from clsql-classic/sql.lisp
* clsql-classic: Remove system and subdirectory
* clsql-base: Remove system and subdirectory and
fold into clsql system
Kevin M. Rosenberg [Thu, 13 May 2004 04:46:17 +0000 (04:46 +0000)]
r9335: Automated commit for Debian build of clsql upstream-version-2.10.16
Kevin M. Rosenberg [Thu, 13 May 2004 04:38:52 +0000 (04:38 +0000)]
r9331: * db-odbc/odbc-api.lisp: work around return-type bug [spr28889] in
Allegro 7.0beta AMD64
Kevin M. Rosenberg [Wed, 12 May 2004 21:58:26 +0000 (21:58 +0000)]
r9329: * db-odbc/*.lisp: Add a layer of indirection to foreign-type
of ODBC longs since this type can vary on 64-bit platforms depending
upon the compilation options of unixODBC.
Kevin M. Rosenberg [Wed, 12 May 2004 20:25:42 +0000 (20:25 +0000)]
r9325: * db-*/*-loader.lisp: Load 64-bit libraries on 64-bit platorms
Kevin M. Rosenberg [Wed, 12 May 2004 20:10:19 +0000 (20:10 +0000)]
r9323: * db-mysql/mysql-api.lisp: Fix int vs. long slots in foreign
structures found by testing with AllegroCL 7.0b AMD64.
Kevin M. Rosenberg [Wed, 12 May 2004 17:18:41 +0000 (17:18 +0000)]
r9318: define explicit lisp function name
Kevin M. Rosenberg [Tue, 11 May 2004 17:02:30 +0000 (17:02 +0000)]
r9314: 11 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/objects.lisp: Initial caching support for SELECT
* tests/test-oodml.lisp: Avoid using cache when testing select.
Kevin M. Rosenberg [Mon, 10 May 2004 22:36:14 +0000 (22:36 +0000)]
r9312: * sql/relations.lisp: Remove functions since they don't support
many to many relationships.
* examples/clsql-tutorial.lisp, doc/csql.lisp: Remove use
of add-to-relations function and replace with explicit field settings.
* base/classes.lisp: Remove obsolute query-stream. Add record-caches slot.
Kevin M. Rosenberg [Mon, 10 May 2004 21:45:28 +0000 (21:45 +0000)]
r9311: more header fixes
Kevin M. Rosenberg [Mon, 10 May 2004 21:42:59 +0000 (21:42 +0000)]
r9310: update headers
Kevin M. Rosenberg [Mon, 10 May 2004 20:59:22 +0000 (20:59 +0000)]
r9309: fix recording reversion
tests/test-init.lisp: Change a :column attribute
to test symbols as value
Kevin M. Rosenberg [Mon, 10 May 2004 20:49:31 +0000 (20:49 +0000)]
r9308: * sql/recording.lisp: Remove additional types to
increase CommonSQL conformance.
Kevin M. Rosenberg [Mon, 10 May 2004 11:14:11 +0000 (11:14 +0000)]
r9299: 10 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/kmr-mop.lisp: Explicitly check slot order and
store as a cl:*feature*
Kevin M. Rosenberg [Mon, 10 May 2004 01:11:45 +0000 (01:11 +0000)]
r9294: new test report
Kevin M. Rosenberg [Mon, 10 May 2004 00:59:53 +0000 (00:59 +0000)]
r9293: 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* Version 2.10.15
* sql/kmr-mop.lisp: Make CMUCL reader macros specific for cmu18
since cmu19 has opposite order of class slots.
Kevin M. Rosenberg [Sun, 9 May 2004 22:46:36 +0000 (22:46 +0000)]
r9292: fix filename typo
Kevin M. Rosenberg [Sun, 9 May 2004 22:33:12 +0000 (22:33 +0000)]
r9291: 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/test-fdml.lisp: Renumber SELECT tests to avoid overwriting
a previous test
* sql/test-init.lisp: Check test-database-underlying-type for
ODBC/MySQL tests
* sql/objects.lisp: Fix (setf slot-value-using-class) for Lispworks
Kevin M. Rosenberg [Sun, 9 May 2004 02:30:44 +0000 (02:30 +0000)]
r9290: Automated commit for Debian build of clsql upstream-version-2.10.14
Marcus Pearce [Sat, 8 May 2004 19:30:57 +0000 (19:30 +0000)]
r9289: Added new operations for the sql syntax.
Kevin M. Rosenberg [Sat, 8 May 2004 19:02:55 +0000 (19:02 +0000)]
r9288: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* tests/benchmarks.lisp: Add immediate vs. deferred
join test.
Kevin M. Rosenberg [Sat, 8 May 2004 18:05:02 +0000 (18:05 +0000)]
r9287: add object selection tests
Kevin M. Rosenberg [Sat, 8 May 2004 17:43:08 +0000 (17:43 +0000)]
r9286: Automated commit for Debian build of clsql upstream-version-2.10.13
Kevin M. Rosenberg [Sat, 8 May 2004 17:41:46 +0000 (17:41 +0000)]
r9285: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/objects.lisp: Add :retrieval :immediate for
object selections. More tests
Kevin M. Rosenberg [Fri, 7 May 2004 06:15:59 +0000 (06:15 +0000)]
r9280: sql/objects.lisp: more framework for supporing immediate retrieval
Kevin M. Rosenberg [Fri, 7 May 2004 05:53:13 +0000 (05:53 +0000)]
r9279: Handle differences in direct-slot-definition values which
are now listify by openmcl 14.2
Kevin M. Rosenberg [Thu, 6 May 2004 20:32:05 +0000 (20:32 +0000)]
r9277: 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* tests/test-init.lisp: Add non-index fields for testing
join class employee-addresss
* test/test-oodml.lisp: Add tests for retrieval immediate
Kevin M. Rosenberg [Thu, 6 May 2004 19:42:39 +0000 (19:42 +0000)]
r9275: new debian release, update README file location in docs
Kevin M. Rosenberg [Thu, 6 May 2004 17:13:00 +0000 (17:13 +0000)]
r9270: No need to specialize finalize-inheritance for openmcl
Kevin M. Rosenberg [Thu, 6 May 2004 17:10:52 +0000 (17:10 +0000)]
r9269: 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
changing the type-specifier. Use a lisp type of (OR NULL FOO)
for a specified-type of FOO unless :db-constraints :not-null.
Kevin M. Rosenberg [Thu, 6 May 2004 03:58:36 +0000 (03:58 +0000)]
r9261: more :base-table testing
Kevin M. Rosenberg [Thu, 6 May 2004 03:51:35 +0000 (03:51 +0000)]
r9260: 6 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* tests/test-*.lisp: Rename fields so that joins occur on
fields with different names. This ensures that join code is
selecting the proper name.
* test/test-init.lisp: Add :base-table for employee-address
view class for testing.
* sql/objects.lisp: Use view-table rather than name of table
in a number of places to fix errors noted with using :base-table.
Kevin M. Rosenberg [Thu, 6 May 2004 00:36:09 +0000 (00:36 +0000)]
r9259: fix typo in var name
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:47 +0000 (00:32 +0000)]
r9258: change package name
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:29 +0000 (00:32 +0000)]
r9257: proper name for file
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:19 +0000 (00:32 +0000)]
r9256: proper name for file
Kevin M. Rosenberg [Thu, 6 May 2004 00:32:06 +0000 (00:32 +0000)]
r9255: move loop extension file
Kevin M. Rosenberg [Wed, 5 May 2004 23:43:47 +0000 (23:43 +0000)]
r9254: 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
* tests/test-syntax.lisp: Add syntax tests for SQL-OBJECT-QUERY
Marcus Pearce [Wed, 5 May 2004 23:32:42 +0000 (23:32 +0000)]
r9253: Add *db-auto-sync* special var for controlling creation/updating of db records when objects are created/manipulated. Import symbols from time.lisp into clsql.
Kevin M. Rosenberg [Wed, 5 May 2004 23:03:02 +0000 (23:03 +0000)]
r9252: Implement new SQL-QUERY-OBJECT class and change behavior of [select 'class]
Kevin M. Rosenberg [Wed, 5 May 2004 17:52:04 +0000 (17:52 +0000)]
r9251:
Kevin M. Rosenberg [Wed, 5 May 2004 15:02:31 +0000 (15:02 +0000)]
r9250: make :target-slot joins many times more efficient
Kevin M. Rosenberg [Wed, 5 May 2004 11:11:36 +0000 (11:11 +0000)]
r9249: separate target-slot processing in prep for rewrite to use single join statement
Kevin M. Rosenberg [Wed, 5 May 2004 10:09:10 +0000 (10:09 +0000)]
r9246: return list of lists for :target-slot
Kevin M. Rosenberg [Wed, 5 May 2004 09:09:35 +0000 (09:09 +0000)]
r9245: New section on optimizations, especially optimizing JOINs
Kevin M. Rosenberg [Wed, 5 May 2004 08:36:20 +0000 (08:36 +0000)]
r9244: Automated commit for Debian build of clsql upstream-version-2.10.11