What combination of lisp implementation and sql engine are you using? The test suite works fine for me on debian sid mysql 5 with sbcl 1.0 (see below). BTW, I think this bug should be severity normal, not imporant. I might suggest you consider changing the priority.
Kevin ****************************************************************************** *** CLSQL Test Suite begun at 2006-11-30 20:13:28.000000 *** SBCL *** 1.0 on X86-64 *** Database MYSQL backend. ****************************************************************************** Doing 229 pending tests of 229 tests total. :INT/CONVERT/1 :INT/CONVERT/2 :INT/CONVERT/3 :INT/CONVERT/4 :INT/CONVERT/5 :CONNECTION/1 :CONNECTION/2 :CONNECTION/3 :BASIC/TYPE/1 :BASIC/TYPE/2 :BASIC/SELECT/1 :BASIC/SELECT/2 :BASIC/SELECT/3 :BASIC/MAP/1 :BASIC/MAP/2 :BASIC/MAP/3 :BASIC/MAP/4 :BASIC/DO/1 :BASIC/DO/2 :BASIC/BIGINT/1 :FDDL/TABLE/1 :FDDL/TABLE/2 :FDDL/TABLE/3 :FDDL/TABLE/4 :FDDL/TABLE/5 :FDDL/TABLE/6 :FDDL/TABLE/7 :FDDL/ATTRIBUTES/1 :FDDL/ATTRIBUTES/2 :FDDL/ATTRIBUTES/3 :FDDL/ATTRIBUTES/4 :FDDL/ATTRIBUTES/5 :FDDL/ATTRIBUTES/6 :FDDL/ATTRIBUTES/7 :FDDL/VIEW/1 :FDDL/VIEW/2 :FDDL/VIEW/3 :FDDL/VIEW/4 :FDDL/INDEX/1 :FDDL/INDEX/2 :FDDL/INDEX/3 :FDDL/SEQUENCE/1 :FDDL/SEQUENCE/2 :FDDL/SEQUENCE/3 :FDDL/BIG/1 :FDDL/CACHE-TABLE-QUERIES/1 :FDML/INSERT/1 :FDML/INSERT/2 :FDML/INSERT/3 :FDML/INSERT/4 :FDML/UPDATE/1 :FDML/UPDATE/2 :FDML/QUERY/1 :FDML/QUERY/2 :FDML/QUERY/3 :FDML/QUERY/4 :FDML/QUERY/6 :FDML/EXECUTE-COMMAND/1 :FDML/SELECT/2 :FDML/SELECT/3 :FDML/SELECT/4 :FDML/SELECT/5 :FDML/SELECT/6 :FDML/SELECT/7 :FDML/SELECT/8 :FDML/SELECT/9 :FDML/SELECT/10 :FDML/SELECT/11 :FDML/SELECT/12 :FDML/SELECT/13 :FDML/SELECT/14 :FDML/SELECT/15 :FDML/SELECT/16 :FDML/SELECT/17 :FDML/SELECT/18 :FDML/SELECT/19 :FDML/SELECT/20 :FDML/SELECT/21 :FDML/SELECT/23 :FDML/SELECT/24 :FDML/SELECT/25 :FDML/SELECT/27 :FDML/SELECT/28 :FDML/SELECT/29 :FDML/SELECT/30 :FDML/SELECT/31 :FDML/SELECT/32 :FDML/SELECT/33 :FDML/SELECT/34 :FDML/SELECT/35 :FDML/SELECT/36 :FDML/SELECT/37 :FDML/SELECT/38 :FDML/DO-QUERY/1 :FDML/MAP-QUERY/1 :FDML/MAP-QUERY/2 :FDML/MAP-QUERY/3 :FDML/MAP-QUERY/4 :FDML/LOOP/1 :FDML/LOOP/2 :FDML/LOOP/3 :FDML/TRANSACTION/1 :FDML/TRANSACTION/2 :FDML/TRANSACTION/3 :FDML/TRANSACTION/4 :OODDL/METACLASS/1 :OODDL/METACLASS/2 :OODDL/JOIN/1 :OODDL/JOIN/2 :OODDL/JOIN/3 :OODDL/TIME/1 :OODDL/TIME/2 :OODDL/TIME/3 :OODML/SELECT/1 :OODML/SELECT/2 :OODML/SELECT/3 :OODML/SELECT/4 :OODML/SELECT/5 :OODML/SELECT/6 :OODML/SELECT/7 :OODML/SELECT/8 :OODML/SELECT/9 :OODML/SELECT/10 :OODML/SELECT/11 :OODM/RETRIEVAL/1 :OODM/RETRIEVAL/2 :OODM/RETRIEVAL/3 :OODM/RETRIEVAL/4 :OODM/RETRIEVAL/5 :OODM/RETRIEVAL/6 :OODM/RETRIEVAL/7 :OODM/RETRIEVAL/8 :OODM/RETRIEVAL/9 :OODML/UPDATE-RECORDS/1 :OODML/UPDATE-RECORDS/2 :OODML/UPDATE-RECORDS/3 :OODML/UPDATE-INSTANCE/1 :OODML/UPDATE-INSTANCE/2 :OODML/DO-QUERY/1 :OODML/DO-QUERY/2 :OODML/MAP-QUERY/1 :OODML/MAP-QUERY/2 :OODML/ITERATION/3 :OODML/CACHE/1 :OODML/CACHE/2 :OODML/REFRESH/1 :OODML/REFRESH/2 :OODML/REFRESH/3 :OODML/REFRESH/4 :OODML/UOJ/1 :OODML/BIG/1 :OODML/DB-AUTO-SYNC/1 :OODML/DB-AUTO-SYNC/2 :OODML/SETF-SLOT-VALUE/1 :OODML/FLOAT/1 :OODML/FLOAT/2 :OODML/FLOAT/3 :OODML/FLOAT/4 :OODML/FLOAT/5 :SYNTAX/GENERIC/1 :SYNTAX/GENERIC/2 :SYNTAX/GENERIC/3 :SYNTAX/GENERIC/4 :SYNTAX/GENERIC/5 :SYNTAX/GENERIC/6 :SYNTAX/IDENT/1 :SYNTAX/IDENT/2 :SYNTAX/IDENT/3 :SYNTAX/IDENT/4 :SYNTAX/IDENT/5 :SYNTAX/IDENT/6 :SYNTAX/IDENT/7 :SYNTAX/SUBQUERY/1 :SYNTAX/SUBQUERY/2 :SYNTAX/SUBQUERY/3 :SYNTAX/SUBQUERY/4 :SYNTAX/SUBQUERY/5 :SYNTAX/AGGREGATE/1 :SYNTAX/AGGREGATE/2 :SYNTAX/AGGREGATE/3 :SYNTAX/AGGREGATE/4 :SYNTAX/AGGREGATE/5 :SYNTAX/LOGICAL/1 :SYNTAX/LOGICAL/2 :SYNTAX/LOGICAL/3 :SYNTAX/NULL/1 :SYNTAX/NULL/2 :SYNTAX/NULL/3 :SYNTAX/NULL/4 :SYNTAX/RELATIONAL/1 :SYNTAX/RELATIONAL/2 :SYNTAX/RELATIONAL/3 :SYNTAX/RELATIONAL/4 :SYNTAX/RELATIONAL/5 :SYNTAX/RELATIONAL/6 :SYNTAX/BETWEEN/1 :SYNTAX/BETWEEN/2 :SYNTAX/ARITHMETIC/1 :SYNTAX/ARITHMETIC/2 :SYNTAX/ARITHMETIC/3 :SYNTAX/ARITHMETIC/4 :SYNTAX/ARITHMETIC/5 :SYNTAX/ARITHMETIC/6 :SYNTAX/SUBSTR/1 :SYNTAX/SUBSTRING/1 :SYNTAX/CONCAT/1 :SYNTAX/CONCAT/2 :SYNTAX/PATTERN/1 :SYNTAX/PATTERN/2 :SYNTAX/DISTINCT/1 :SYNTAX/DISTINCT/2 :SYNTAX/ORDER-BY/1 :SYNTAX/GROUP-BY/1 :SYNTAX/GROUP-BY/2 :SYNTAX/COALESCE/1 :SYNTAX/COALESCE/2 :SYNTAX/NVL/1 :SYNTAX/SETS/1 :SYNTAX/SETS/2 :SYNTAX/SETS/3 :SYNTAX/SETS/4 :SYNTAX/FUNCTION/1 :SYNTAX/FUNCTION/2 :SYNTAX/QUERY/1 :SYNTAX/QUERY/2 :SYNTAX/QUERY/3 :SYNTAX/QUERY/4 :SYNTAX/EXPRESSION1 :SYNTAX/EXPRESSION/2 No tests failed. Tests skipped: FDDL/OWNER/1 table ownership not supported FDML/QUERY/5 not supported by mysql FDML/QUERY/7 not supported by mysql FDML/QUERY/8 not supported by mysql FDML/SELECT/1 fancy math not supported FDML/SELECT/22 not supported by mysql FDML/SELECT/26 string table aliases not supported on all mysql versions ; ; compilation unit finished ; caught 1 STYLE-WARNING condition ; printed 71 notes Kevin Rosenberg [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]