r9364: Various fixes from CommonSQL Tutorial.

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

diff --git a/tests/test-fdml.lisp b/tests/test-fdml.lisp
index 33267a52f33d580866d7017f513fa09b7d8cc942..f764e73ae28db0c446fde6e42f9afdf57f2349c6 100644 (file)
--- a/tests/test-fdml.lisp
+++ b/tests/test-fdml.lisp
@@ -392,6 +392,11 @@
   :order-by '(["table" last-name])
   :result-types nil :field-names nil)
  (("Vladamir" "Lenin") ("Vladamir" "Putin")))
+
+(deftest :fdml/select/27 
+ (clsql:select [coalesce [managerid] 10] :from [employee] :order-by [emplid]
+  :field-names nil :result-types nil :flatp t)
+ ("10" "1" "1" "1" "1" "1" "1" "1" "1" "1"))
   
 ;(deftest :fdml/select/11
 ;    (clsql:select [emplid] :from [employee]