X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-fdml.lisp;h=906852be6d49d1d645f9e334167be60cc1b45863;hb=a99f275949c7e638a1e7fcf2ebfbb21f0a8c448a;hp=b74e53275479e41205f7b8d904ce3338e454c4d8;hpb=ec9b352b8205e4204a06797f98970b03cf532ab2;p=clsql.git diff --git a/tests/test-fdml.lisp b/tests/test-fdml.lisp index b74e532..906852b 100644 --- a/tests/test-fdml.lisp +++ b/tests/test-fdml.lisp @@ -334,7 +334,21 @@ collect (concatenate 'string forename " " surname)) ("Yuri Andropov" "Leonid Brezhnev" "Konstantin Chernenko" "Mikhail Gorbachev" "Nikita Kruschev" "Vladamir Lenin" "Vladamir Putin" - "Josef Stalin" "Leon Trotsky" "Boris Yeltsin")) + "Josef Stalin" "Leon Trotsky" "Boris Yeltsin")) + +(deftest :fdml/loop/2 + (loop for (emplid) + being each tuple in + [select [emplid] :from [address] :order-by [emplid]] + collect emplid) + (1 2)) + +(deftest :fdml/loop/3 + (loop for emplid + being each tuple in + [select [emplid] :from [address] :order-by [emplid]] + collect emplid) + (1 2)) ;; starts a transaction deletes a record and then rolls back the deletion (deftest :fdml/transaction/1