X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-init.lisp;h=d745ff0698e3823e4b2c7881d7f760e25eaac0a8;hb=fd2493718d0e1114fcbe3dd578dab658ea383e81;hp=b1a89341af6499018a7025cc7c4b0474519b1649;hpb=24a4186aa531c3e56953413119e2308bb7c50b6b;p=clsql.git

diff --git a/tests/test-init.lisp b/tests/test-init.lisp
index b1a8934..d745ff0 100644
--- a/tests/test-init.lisp
+++ b/tests/test-init.lisp
@@ -259,7 +259,7 @@
 				   :height (1+ (random 1.00))
 				   :bd-utime *test-start-utime*
 				   :birthday now-time
-				   :first-name "Vladamir"
+				   :first-name "Vladimir"
 				   :last-name "Lenin"
 				   :email "lenin@soviet.org"
 				   :companyid 1)
@@ -366,7 +366,7 @@
 				    :height (1+ (random 1.00))
 				    :bd-utime *test-start-utime*
 				    :birthday now-time
-				    :first-name "Vladamir"
+				    :first-name "Vladimir"
 				    :last-name "Putin"
 				    :email "putin@soviet.org"
 				    :managerid 1
@@ -584,6 +584,11 @@
 				:fdml/select/21 :fdml/select/32 
                                 :fdml/select/33))
 	   (push (cons test "not supported by sqlite") skip-tests))
+	  ((and (eql *test-database-type* :sqlite3)
+		(clsql-sys:in test :fddl/view/4 :fdml/select/10
+			      :fdml/select/21 :fdml/select/32 
+			      :fdml/select/33))
+	   (push (cons test "not supported by sqlite3") skip-tests))
 	  ((and (not (clsql-sys:db-type-has-bigint? db-type))
 		(clsql-sys:in test :basic/bigint/1))
 	   (push (cons test "bigint not supported") skip-tests))
@@ -609,6 +614,15 @@
                              '(:postgresql :oracle)))
 		(clsql-sys:in test :fddl/owner/1))
            (push (cons test "table ownership not supported") skip-tests))
+          ((and (null (clsql-sys:db-type-has-intersect? db-underlying-type))
+		(clsql-sys:in test :fdml/query/7))
+	   (push (cons test "intersect not supported") skip-tests))
+          ((and (null (clsql-sys:db-type-has-except? db-underlying-type))
+		(clsql-sys:in test :fdml/query/8))
+	   (push (cons test "except not supported") skip-tests))
+          ((and (eq *test-database-underlying-type* :mssql)
+                (clsql-sys:in test :fdml/select/9))
+           (push (cons test "mssql uses integer math for AVG") skip-tests))
 	  (t
 	   (push test-form test-forms)))))
       (values (nreverse test-forms) (nreverse skip-tests))))