# 2025-11-23 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # Test cases for the Query Result Formatter (QRF), and especially # the bSplitColumn feature. # set testdir [file dirname $argv0] source $testdir/tester.tcl set testprefix qrf01 # The expected output from test 1.1. The "do_test" procedure normally # ignores differences in whitespace, but whitespace is important for # this test, so we have to do the comparison ourselves. # set expected { <---- 22 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 23 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 24 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 25 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 26 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 27 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 28 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 29 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 30 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 31 ----> alice bob cinderella-cinderella daniel emma fred gertrude harold ingrid jake lisa mike nina octavian paula quintus rita sam tammy ulysses violet william xanthippe yates zoe <---- 32 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 33 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 34 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 35 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 36 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 37 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 38 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 39 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 40 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 41 ----> alice octavian bob paula cinderella-cinderella quintus daniel rita emma sam fred tammy gertrude ulysses harold violet ingrid william jake xanthippe lisa yates mike zoe nina <---- 42 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 43 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 44 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 45 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 46 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 47 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 48 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 49 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 50 ----> alice jake tammy bob lisa ulysses cinderella-cinderella mike violet daniel nina william emma octavian xanthippe fred paula yates gertrude quintus zoe harold rita ingrid sam <---- 51 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 52 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 53 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 54 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 55 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 56 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 57 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 58 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 59 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 60 ----> alice harold paula william bob ingrid quintus xanthippe cinderella-cinderella jake rita yates daniel lisa sam zoe emma mike tammy fred nina ulysses gertrude octavian violet <---- 61 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 62 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 63 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 64 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 65 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 66 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 67 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 68 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 69 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 70 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 71 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 72 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 73 ----> alice fred lisa quintus violet bob gertrude mike rita william cinderella-cinderella harold nina sam xanthippe daniel ingrid octavian tammy yates emma jake paula ulysses zoe <---- 74 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates <---- 75 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates <---- 76 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates <---- 77 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates <---- 78 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates <---- 79 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates <---- 80 ----> alice emma ingrid nina rita violet zoe bob fred jake octavian sam william cinderella-cinderella gertrude lisa paula tammy xanthippe daniel harold mike quintus ulysses yates } do_test 1.0 { db eval { CREATE TABLE t1(x); INSERT INTO t1(x) VALUES ('alice'), ('bob'), ('cinderella-cinderella'), ('daniel'), ('emma'), ('fred'), ('gertrude'), ('harold'), ('ingrid'), ('jake'), ('lisa'), ('mike'), ('nina'), ('octavian'), ('paula'), ('quintus'), ('rita'), ('sam'), ('tammy'), ('ulysses'), ('violet'), ('william'), ('xanthippe'), ('yates'), ('zoe'); } set res \n for {set i 22} {$i<=80} {incr i} { set sp [expr {$i-13}] append res [format "<----%*s%3d%*s---->\n" \ [expr {$sp/2}] {} $i [expr {$sp-$sp/2}] {}] append res [db format -style column -title off \ -screenwidth $i -splitcolumn on \ {SELECT x FROM t1 ORDER BY x ASC}] } expr {$res eq $::expected} } {1}