X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-fddl.lisp;h=34c956a79a7918595556303c146beb15aa39d703;hb=162003a620fcbfabab5313887d0722f6168efd8c;hp=61329ff7149289a2c685ef21ff4a4fc07cb41989;hpb=8fa38a6c189dc8b42611c4ee3c31facd5fe00635;p=clsql.git

diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp
index 61329ff..34c956a 100644
--- a/tests/test-fddl.lisp
+++ b/tests/test-fddl.lisp
@@ -88,9 +88,13 @@
                           '(:postgresql :postgresql-socket))
                   :ignore
                   :warn)))
-         (clsql:create-table [foo] 
-                             '(([bar] integer :not-null :unique :primary-key) 
-                               ([baz] string :not-null :unique))))
+         (case *test-database-underlying-type*
+           (:mssql (clsql:create-table [foo] 
+                                       '(([bar] integer :not-null :primary-key)
+                                         ([baz] string :not-null :unique))))
+           (t (clsql:create-table [foo] 
+                                  '(([bar] integer :not-null :unique :primary-key)
+                                    ([baz] string :not-null :unique))))))
        (clsql:table-exists-p [foo]))
      (progn
        (clsql:drop-table [foo])
@@ -244,7 +248,7 @@
     (let ((names '("foo" foo [foo]))
           (result '()))
       (dolist (name names)
-        (clsql:create-index name :on [employee] :attributes '([emplid]))
+        (clsql:create-index name :on [employee] :attributes '([last-name]))
         (push (clsql:index-exists-p name :owner *test-database-user*) result)
 	(clsql:drop-index name :on [employee] :if-does-not-exist :ignore))
       (apply #'values result))
@@ -354,7 +358,7 @@
   (progn 
     (clsql:cache-table-queries "EMPLOYEE" :action :flush)
     (gethash "EMPLOYEE" (clsql-sys::attribute-cache clsql:*default-database*))))
- (NIL (T NIL) T (T NIL)))
+ (nil (t nil) t (t nil)))
 
   ))