--- /dev/null
+CLSQL Contributors
+------------------
+Kevin Rosenberg (main author CLSQL)
+Pierre Mai (original author MaiSQL from which CLSQL was based)
+Marcus Pearce (initial port of USQL to CLSQL)
+Marc Battyani
+
+
+USQL Contributors
+-----------------
+This is a list of those individuals who have contributed in some way
+or other to Uncommonsql. The sources of the attributions are CVS
+annotation, patch submission, and original authorship, write us if
+we've missed anybody.
+
+Jesse Bouwman
+Craig Brozefsky
+Sean Champ
+Matthew Danish
+Adam Di Carlo
+Lyn Headley
+John Krug
+Pierre Mai (original author)
+Christopher J. Vogt
--- /dev/null
+Copyright (c) 1999 - 2003 onShore Development, Inc.
+All rights reserved.
+
+Redistribution and use in source and binary forms, with or without
+modification, are permitted provided that the following conditions
+are met:
+1. Redistributions of source code must retain the above copyright
+ notice, this list of conditions and the following disclaimer.
+2. Redistributions in binary form must reproduce the above copyright
+ notice, this list of conditions and the following disclaimer in the
+ documentation and/or other materials provided with the distribution.
+3. The name of the author may not be used to endorse or promote products
+ derived from this software without specific prior written permission.
+
+THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
+IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
+OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
+IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT,
+INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
+NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
+DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
+THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
+THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+GENERAL
+* test on (and port to) scl, mcl and openmcl;
+* implement remaining functions for CLSQL AODBC backend;
+* port UncommonSQL ODBC and Oracle backends to CLSQL.
+
+COMMONSQL SPEC
+
+* Missing:
+
+ RECONNECT
+ CACHE-TABLE-QUERIES
+ *CACHE-TABLE-QUERIES-DEFAULT*
+ *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
+ UPDATE-OBJECT-JOINS
+ INSTANCE-REFRESHED
+
+
+* Incompatible
+
+
+ >> Initialisation and connection
+
+ CONNECT
+ o should accept string as connection spec
+
+ DISCONNECT
+ o should accept string as connection spec
+
+ INITIALIZE-DATABASE-TYPE
+ o should initialise appropriate backend
+
+ STATUS
+ o what is the behaviour in CommonSQL (esp :full parameter)?
+
+
+ >> The functional sql interface
+
+ SELECT
+ o should accept keyword arg :refresh and call INSTANCE-REFRESHED
+ o should return (values result-list field-names)
+ o should coerce values returned as strings to appropriate lisp type
+
+ QUERY
+ o should return (values result-list field-names)
+ o should coerce values returned as strings to appropriate lisp type
+
+ LIST-ATTRIBUTE-TYPES
+ o should return list of (attribute datatype precision scale nullable)
+
+ LOOP
+ o the extension is currently CMUCL specific
+
+
+ >> The object-oriented sql interface
+
+ DEF-VIEW-CLASS
+ o get :target-slot working
+ o implement :retrieval :immediate
+
+ LIST-CLASSES
+ o keyword arg :root-class should do something (portable)
+
+ DO-QUERY,MAP-QUERY,LOOP
+ o should work with object queries as well as functional ones
+
+
+ >> Symbolic SQL syntax
+
+ o Complete sql expressions (see operations.lisp)
+
+ substr
+ some
+ order-by
+ times
+ nvl
+ null
+ distinct
+ except
+ intersect
+ between
+ userenv
+
+ o variables (e.g., table identifiers) should be instantiated at runtime
+
+
+
+NOTES ABOUT THE BACKENDS
+
+MYSQL
+
+drop-index: requires a table to be specified with the :from keyword parameter
+transactions: don't seem to work
+views: mysql does not support views
+queries: nested subqueries do not seem to work
+
+SQLITE
+
+create-view: column-list parameter not supported
+++ /dev/null
-This is a list of those individuals who have contributed in some way
-or other to Uncommonsql. The sources of the attributions are CVS
-annotation, patch submission, and original authorship, write us if
-we've missed anybody.
-
-Jesse Bouwman
-
-Craig Brozefsky
-
-Sean Champ
-
-Matthew Danish
-
-Adam Di Carlo
-
-Lyn Headley
-
-John Krug
-
-Pierre Mai (original author)
-
-Christopher J. Vogt
+++ /dev/null
-This document contains the copyright notices distributed with:
-
- o UncommonSQL
- o CLSQL
- o MaiSQL
-
-from which this software was derived.
-
-
-UncommonSQL ================================================================
-============================================================================
-
-Copyright (c) 1999 - 2003 onShore Development, Inc.
-All rights reserved.
-
-Redistribution and use in source and binary forms, with or without
-modification, are permitted provided that the following conditions
-are met:
-1. Redistributions of source code must retain the above copyright
- notice, this list of conditions and the following disclaimer.
-2. Redistributions in binary form must reproduce the above copyright
- notice, this list of conditions and the following disclaimer in the
- documentation and/or other materials provided with the distribution.
-3. The name of the author may not be used to endorse or promote products
- derived from this software without specific prior written permission.
-
-THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
-IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
-OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
-IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT,
-INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
-NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
-DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
-THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
-(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
-THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
-
-
-CLSQL ======================================================================
-============================================================================
-
-CLSQL is written and Copyright (c) 2002 by Kevin M. Rosenberg and is
-based on the MaiSQL package written and Copyright (c) 1999-2001 by
-Pierre R. Mai.
-
-CLSQL is licensed under the terms of the Lisp Lesser GNU
-Public License (http://opensource.franz.com/preamble.html), known as
-the LLGPL. The LLGPL consists of a preamble (see above URL) and the
-LGPL. Where these conflict, the preamble takes precedence.
-CLSQL is referenced in the preamble as the "LIBRARY."
-
-CLSQL is distributed in the hope that it will be useful,
-but WITHOUT ANY WARRANTY; without even the implied warranty of
-MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
-
-
-MaiSQL =====================================================================
-============================================================================
-
- Copyright (C) 1999-2001 Pierre R. Mai
-
- Permission is hereby granted, free of charge, to any person obtaining
- a copy of this software and associated documentation files (the
- "Software"), to deal in the Software without restriction, including
- without limitation the rights to use, copy, modify, merge, publish,
- distribute, sublicense, and/or sell copies of the Software, and to
- permit persons to whom the Software is furnished to do so, subject to
- the following conditions:
-
- The above copyright notice and this permission notice shall be
- included in all copies or substantial portions of the Software.
-
- THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
- EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
- MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
- IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY CLAIM, DAMAGES OR
- OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
- ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
- OTHER DEALINGS IN THE SOFTWARE.
-
- Except as contained in this notice, the name of the author shall
- not be used in advertising or otherwise to promote the sale, use or
- other dealings in this Software without prior written authorization
- from the author.
+++ /dev/null
-
-GENERAL
-
-* test on (and port to) sbcl, lispworks, acl, scl, mcl and openmcl;
-* implement remaining functions for CLSQL AODBC backend;
-* port UncommonSQL ODBC and Oracle backends to CLSQL.
-
-
-COMMONSQL SPEC
-
-* Missing:
-
- RECONNECT
- CACHE-TABLE-QUERIES
- *CACHE-TABLE-QUERIES-DEFAULT*
- *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
- UPDATE-OBJECT-JOINS
- INSTANCE-REFRESHED
-
-
-* Incompatible
-
-
- >> Initialisation and connection
-
- CONNECT
- o should accept string as connection spec
-
- DISCONNECT
- o should accept string as connection spec
-
- INITIALIZE-DATABASE-TYPE
- o should initialise appropriate backend
-
- STATUS
- o what is the behaviour in CommonSQL (esp :full parameter)?
-
-
- >> The functional sql interface
-
- SELECT
- o should accept keyword arg :refresh and call INSTANCE-REFRESHED
- o should return (values result-list field-names)
- o should coerce values returned as strings to appropriate lisp type
-
- QUERY
- o should return (values result-list field-names)
- o should coerce values returned as strings to appropriate lisp type
-
- LIST-ATTRIBUTE-TYPES
- o should return list of (attribute datatype precision scale nullable)
-
- LOOP
- o the extension is currently CMUCL specific
-
-
- >> The object-oriented sql interface
-
- DEF-VIEW-CLASS
- o get :target-slot working
- o implement :retrieval :immediate
-
- LIST-CLASSES
- o keyword arg :root-class should do something (portable)
-
- DO-QUERY,MAP-QUERY,LOOP
- o should work with object queries as well as functional ones
-
-
- >> Symbolic SQL syntax
-
- o Complete sql expressions (see operations.lisp)
-
- substr
- some
- order-by
- times
- nvl
- null
- distinct
- except
- intersect
- between
- userenv
-
- o variables (e.g., table identifiers) should be instantiated at runtime
-
-
-
-NOTES ABOUT THE BACKENDS
-
-MYSQL
-
-drop-index: requires a table to be specified with the :from keyword parameter
-transactions: don't seem to work
-views: mysql does not support views
-queries: nested subqueries do not seem to work
-
-SQLITE
-
-create-view: column-list parameter not supported