X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=tests%2Ftest-basic.lisp;fp=tests%2Ftest-basic.lisp;h=24129e63adc189fc1044c554117134d9f70e8fb0;hp=9dad688c99954b7c4da456c12c2677e23a5f9fc7;hb=d7de408301661ef88f59d28387dfa419abbcc18e;hpb=1d8315575a3260f46cb2541d197b86c81f1a5f0a diff --git a/tests/test-basic.lisp b/tests/test-basic.lisp index 9dad688..24129e6 100644 --- a/tests/test-basic.lisp +++ b/tests/test-basic.lisp @@ -208,18 +208,24 @@ )) nil) (deftest :basic/bigtext/2 - (dotimes (n 10) - (with-dataset *ds-bigtext* - (let* ((len (random 7500)) - (str (make-string len :initial-element #\a)) - (cmd (format nil "INSERT INTO testbigtext (a) VALUES ('~a')" str))) - (execute-command cmd) - (let ((a (first (query "SELECT a from testbigtext" - :flatp t :field-names nil)))) - (assert (string= str a) (str a) - "mismatch on a. inserted: ~a returned: ~a" len (length a))) - ))) - nil) + (flet ((random-char () + (let ((alphabet "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ") + (idx (random 52))) + (elt alphabet idx)))) + (dotimes (n 10) + (with-dataset *ds-bigtext* + (let* ((len (random 7500)) + (str (coerce (make-array len + :initial-contents (loop repeat len collect (random-char))) + 'string)) + (cmd (format nil "INSERT INTO testbigtext (a) VALUES ('~a')" str))) + (execute-command cmd) + (let ((a (first (query "SELECT a from testbigtext" + :flatp t :field-names nil)))) + (assert (string= str a) (str a) + "mismatch on randomized bigtext(~a) inserted: ~s returned: ~s" len str a)) + )))) + nil) ))