X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=tests%2Ftest-fdml.lisp;h=8f9fd3f63980c88fcd0e7b35a80ddb8b70125636;hp=ca491ac957ca9560887809fdbfe28315e4acd1eb;hb=026988a3144e3ed7f48552b5567c34448fef51bc;hpb=aad71482a312cf287e2f6e3e926cf671cd382ec7 diff --git a/tests/test-fdml.lisp b/tests/test-fdml.lisp index ca491ac..8f9fd3f 100644 --- a/tests/test-fdml.lisp +++ b/tests/test-fdml.lisp @@ -374,6 +374,14 @@ ("Boris" "Josef" "Konstantin" "Leon" "Leonid" "Mikhail" "Nikita" "Vladamir" "Yuri")) +(deftest :fdml/select/25 + (clsql:select [first-name] :from "employee" :flatp t :distinct t + :field-names nil + :result-types nil + :order-by [first-name]) + ("Boris" "Josef" "Konstantin" "Leon" "Leonid" "Mikhail" "Nikita" "Vladamir" + "Yuri")) + ;(deftest :fdml/select/11 ; (clsql:select [emplid] :from [employee] ; :where [= [emplid] [any [select [companyid] :from [company]]]]