X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=tests%2Ftest-fdml.lisp;h=5c95fcd19c2aeb9a65b9ed4da5a37f9d139dae17;hp=93d3597d8cc959b65366e144f238ee4d6424ca1e;hb=5953db07cc2276392d0a81052d2d8c71d3252b5a;hpb=737c27605b8d2308b95d9717644ba496f37fcd20 diff --git a/tests/test-fdml.lisp b/tests/test-fdml.lisp index 93d3597..5c95fcd 100644 --- a/tests/test-fdml.lisp +++ b/tests/test-fdml.lisp @@ -350,25 +350,25 @@ :field-names nil :result-types nil :flatp t) ("1" "2" "3" "4")) -(deftest :fdml/select/20 +(deftest :fdml/select/21 (clsql:select [substr [first-name] 1 4] :from [employee] :flatp t :order-by [emplid] :field-names nil) ("Vlad" "Jose" "Leon" "Niki" "Leon" "Yuri" "Kons" "Mikh" "Bori" "Vlad")) -(deftest :fdml/select/21 +(deftest :fdml/select/22 (clsql:select [\|\| [first-name] " " [last-name]] :from [employee] :flatp t :order-by [emplid] :field-names nil) ("Vladamir Lenin" "Josef Stalin" "Leon Trotsky" "Nikita Kruschev" "Leonid Brezhnev" "Yuri Andropov" "Konstantin Chernenko" "Mikhail Gorbachev" "Boris Yeltsin" "Vladamir Putin")) -(deftest :fdml/select/22 +(deftest :fdml/select/23 (clsql:select [emplid] :from [employee] :where [in [emplid] '(1 2 3 4)] :flatp t :order-by [emplid] :field-names nil :result-types nil) ("1" "2" "3" "4")) -(deftest :fdml/select/23 +(deftest :fdml/select/24 (clsql:select [distinct [first-name]] :from [employee] :flatp t :order-by [first-name] :field-names nil :result-types nil) ("Boris" "Josef" "Konstantin" "Leon" "Leonid" "Mikhail" "Nikita" "Vladamir"