Re: CLSQL 3.5.0 [was Patch for MS SQL Server 2000 via ODBC]

Hi Kevin

> If anyone has the ability to test with odbc/mysql (on either linux or
> windows), I'd appreciate a report of your results.

I've just run the tests with 3.5.0 under Windows XP Lispworks Pro 4.4.6

 MySQL 4.1.1 and MyODBC-3.51.11
 MS SQL Server 2000

Everything looks good...

- Dominic

******************************************************************************
***     CLSQL Test Suite begun at 2005-11-26 21:40:18.000000
***     LispWorks
***     4.4.6 on IBM PC Compatible
***     Database ODBC backend with underlying type MYSQL.
******************************************************************************
Doing 223 pending tests of 223 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/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/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/VIEW/1          views not supported
   FDDL/VIEW/3          views not supported
   FDDL/VIEW/4          views not supported
   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

******************************************************************************
***     CLSQL Test Suite begun at 2005-11-26 21:40:37.000000
***     LispWorks
***     4.4.6 on IBM PC Compatible
***     Database ODBC backend with underlying type MSSQL.
******************************************************************************
Doing 227 pending tests of 227 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/5 :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/10 :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/22 :FDML/SELECT/23
 :FDML/SELECT/24
 :FDML/SELECT/25 :FDML/SELECT/26 :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/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/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/7         intersect not supported
   FDML/QUERY/8         except not supported
   FDML/SELECT/1        fancy math not supported
   FDML/SELECT/9        mssql uses integer math for AVG
   FDML/SELECT/11       boolean where not supported
   OODML/SELECT/5       boolean where not supported