X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=tests%2Ftest-fddl.lisp;h=0ffe57e376db795686ba33e85fc1755a0ec03703;hp=301c37c0af89f440ac8dd135253ac9ef331a60fe;hb=645d2ea7396466b8673e3421b55e45cd327f0195;hpb=2ffbaf8f63878de07311a7a4a29dd737e0121ee8 diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp index 301c37c..0ffe57e 100644 --- a/tests/test-fddl.lisp +++ b/tests/test-fddl.lisp @@ -24,11 +24,10 @@ ;; list current tables (deftest :fddl/table/1 - (apply #'values - (sort (mapcar #'string-downcase - (clsql:list-tables :owner *test-database-user*)) - #'string<)) - "addr" "company" "ea_join" "employee" "type_bigint" "type_table") + (sort (mapcar #'string-downcase + (clsql:list-tables :owner *test-database-user*)) + #'string<) + ("addr" "big" "company" "ea_join" "employee" "type_bigint" "type_table")) ;; create a table, test for its existence, drop it and test again (deftest :fddl/table/2 @@ -266,6 +265,22 @@ (clsql:drop-sequence [foo] :if-does-not-exist :ignore))) 6) +(deftest :fddl/big/1 + (let ((rows (clsql:select [*] :from [big] :field-names nil))) + (values + (length rows) + (do ((i 0 (1+ i)) + (max (expt 2 60)) + (rest rows (cdr rest))) + ((= i (length rows)) t) + (let ((row (car rest)) + (index (1+ i))) + (unless (and (eql (first row) index) + (eql (second row) (truncate max index))) + (return nil)))))) + 555 t) + + )) #.(clsql:restore-sql-reader-syntax-state)