r9119: Automated commit for Debian build of clsql upstream-version-2.9.2

[clsql.git] / tests / test-basic.lisp

diff --git a/tests/test-basic.lisp b/tests/test-basic.lisp
index e57ee2875a64a2519debe5956784a2983ffb0a11..2a63c77846fafea1eee972e04650c3088377d84f 100644 (file)
--- a/tests/test-basic.lisp
+++ b/tests/test-basic.lisp
@@ -53,7 +53,7 @@
     (test-table-row (list int float bigint str) nil type))
   (do-query ((int float bigint str) "select * from test_clsql" :result-types :auto)
     (test-table-row (list int float bigint str) :auto type))
-  #+ignore (drop-test-table db))
+  (drop-test-table db))
 
 
 (defun %test-basic-untyped (db type)
@@ -84,7 +84,7 @@
     (clsql:execute-command 
      "DROP TABLE test_clsql" :database db))
   (clsql:execute-command 
-   "CREATE TABLE test_clsql (t_int integer, t_float double, t_bigint BIGINT, t_str CHAR(30))" 
+   "CREATE TABLE test_clsql (t_int integer, t_float double precision, t_bigint BIGINT, t_str VARCHAR(30))" 
    :database db)
   (dotimes (i 11)
     (let* ((test-int (- i 5))
@@ -113,7 +113,7 @@
       ((eq types :auto)
        (test (and (integerp int)
                  (typep float 'double-float)
-                 (or (eq db-type :aodbc)  ;; aodbc considers bigints as strings
+                 (or (member db-type '(:odbc :aodbc))  ;; aodbc considers bigints as strings
                      (integerp bigint)) 
                  (stringp str))
             t