AryaWu/sqlite
0
1# 2025-11-232#3# The author disclaims copyright to this source code. In place of4# a legal notice, here is a blessing:5#6# May you do good and not evil.7# May you find forgiveness for yourself and forgive others.8# May you share freely, never taking more than you give.9#10#***********************************************************************11#12# Test cases for the Query Result Formatter (QRF), and especially13# the bSplitColumn feature.14#15 16set testdir [file dirname $argv0]17source $testdir/tester.tcl18set testprefix qrf0119 20# The expected output from test 1.1. The "do_test" procedure normally21# ignores differences in whitespace, but whitespace is important for22# this test, so we have to do the comparison ourselves.23#24set expected {25<---- 22 ---->26alice27bob28cinderella-cinderella29daniel30emma31fred32gertrude33harold34ingrid35jake36lisa37mike38nina39octavian40paula41quintus42rita43sam44tammy45ulysses46violet47william48xanthippe49yates50zoe51<---- 23 ---->52alice53bob54cinderella-cinderella55daniel56emma57fred58gertrude59harold60ingrid61jake62lisa63mike64nina65octavian66paula67quintus68rita69sam70tammy71ulysses72violet73william74xanthippe75yates76zoe77<---- 24 ---->78alice79bob80cinderella-cinderella81daniel82emma83fred84gertrude85harold86ingrid87jake88lisa89mike90nina91octavian92paula93quintus94rita95sam96tammy97ulysses98violet99william100xanthippe101yates102zoe103<---- 25 ---->104alice105bob106cinderella-cinderella107daniel108emma109fred110gertrude111harold112ingrid113jake114lisa115mike116nina117octavian118paula119quintus120rita121sam122tammy123ulysses124violet125william126xanthippe127yates128zoe129<---- 26 ---->130alice131bob132cinderella-cinderella133daniel134emma135fred136gertrude137harold138ingrid139jake140lisa141mike142nina143octavian144paula145quintus146rita147sam148tammy149ulysses150violet151william152xanthippe153yates154zoe155<---- 27 ---->156alice157bob158cinderella-cinderella159daniel160emma161fred162gertrude163harold164ingrid165jake166lisa167mike168nina169octavian170paula171quintus172rita173sam174tammy175ulysses176violet177william178xanthippe179yates180zoe181<---- 28 ---->182alice183bob184cinderella-cinderella185daniel186emma187fred188gertrude189harold190ingrid191jake192lisa193mike194nina195octavian196paula197quintus198rita199sam200tammy201ulysses202violet203william204xanthippe205yates206zoe207<---- 29 ---->208alice209bob210cinderella-cinderella211daniel212emma213fred214gertrude215harold216ingrid217jake218lisa219mike220nina221octavian222paula223quintus224rita225sam226tammy227ulysses228violet229william230xanthippe231yates232zoe233<---- 30 ---->234alice235bob236cinderella-cinderella237daniel238emma239fred240gertrude241harold242ingrid243jake244lisa245mike246nina247octavian248paula249quintus250rita251sam252tammy253ulysses254violet255william256xanthippe257yates258zoe259<---- 31 ---->260alice261bob262cinderella-cinderella263daniel264emma265fred266gertrude267harold268ingrid269jake270lisa271mike272nina273octavian274paula275quintus276rita277sam278tammy279ulysses280violet281william282xanthippe283yates284zoe285<---- 32 ---->286alice octavian287bob paula288cinderella-cinderella quintus289daniel rita290emma sam291fred tammy292gertrude ulysses293harold violet294ingrid william295jake xanthippe296lisa yates297mike zoe298nina299<---- 33 ---->300alice octavian301bob paula302cinderella-cinderella quintus303daniel rita304emma sam305fred tammy306gertrude ulysses307harold violet308ingrid william309jake xanthippe310lisa yates311mike zoe312nina313<---- 34 ---->314alice octavian315bob paula316cinderella-cinderella quintus317daniel rita318emma sam319fred tammy320gertrude ulysses321harold violet322ingrid william323jake xanthippe324lisa yates325mike zoe326nina327<---- 35 ---->328alice octavian329bob paula330cinderella-cinderella quintus331daniel rita332emma sam333fred tammy334gertrude ulysses335harold violet336ingrid william337jake xanthippe338lisa yates339mike zoe340nina341<---- 36 ---->342alice octavian343bob paula344cinderella-cinderella quintus345daniel rita346emma sam347fred tammy348gertrude ulysses349harold violet350ingrid william351jake xanthippe352lisa yates353mike zoe354nina355<---- 37 ---->356alice octavian357bob paula358cinderella-cinderella quintus359daniel rita360emma sam361fred tammy362gertrude ulysses363harold violet364ingrid william365jake xanthippe366lisa yates367mike zoe368nina369<---- 38 ---->370alice octavian371bob paula372cinderella-cinderella quintus373daniel rita374emma sam375fred tammy376gertrude ulysses377harold violet378ingrid william379jake xanthippe380lisa yates381mike zoe382nina383<---- 39 ---->384alice octavian385bob paula386cinderella-cinderella quintus387daniel rita388emma sam389fred tammy390gertrude ulysses391harold violet392ingrid william393jake xanthippe394lisa yates395mike zoe396nina397<---- 40 ---->398alice octavian399bob paula400cinderella-cinderella quintus401daniel rita402emma sam403fred tammy404gertrude ulysses405harold violet406ingrid william407jake xanthippe408lisa yates409mike zoe410nina411<---- 41 ---->412alice octavian413bob paula414cinderella-cinderella quintus415daniel rita416emma sam417fred tammy418gertrude ulysses419harold violet420ingrid william421jake xanthippe422lisa yates423mike zoe424nina425<---- 42 ---->426alice jake tammy427bob lisa ulysses428cinderella-cinderella mike violet429daniel nina william430emma octavian xanthippe431fred paula yates432gertrude quintus zoe433harold rita434ingrid sam435<---- 43 ---->436alice jake tammy437bob lisa ulysses438cinderella-cinderella mike violet439daniel nina william440emma octavian xanthippe441fred paula yates442gertrude quintus zoe443harold rita444ingrid sam445<---- 44 ---->446alice jake tammy447bob lisa ulysses448cinderella-cinderella mike violet449daniel nina william450emma octavian xanthippe451fred paula yates452gertrude quintus zoe453harold rita454ingrid sam455<---- 45 ---->456alice jake tammy457bob lisa ulysses458cinderella-cinderella mike violet459daniel nina william460emma octavian xanthippe461fred paula yates462gertrude quintus zoe463harold rita464ingrid sam465<---- 46 ---->466alice jake tammy467bob lisa ulysses468cinderella-cinderella mike violet469daniel nina william470emma octavian xanthippe471fred paula yates472gertrude quintus zoe473harold rita474ingrid sam475<---- 47 ---->476alice jake tammy477bob lisa ulysses478cinderella-cinderella mike violet479daniel nina william480emma octavian xanthippe481fred paula yates482gertrude quintus zoe483harold rita484ingrid sam485<---- 48 ---->486alice jake tammy487bob lisa ulysses488cinderella-cinderella mike violet489daniel nina william490emma octavian xanthippe491fred paula yates492gertrude quintus zoe493harold rita494ingrid sam495<---- 49 ---->496alice jake tammy497bob lisa ulysses498cinderella-cinderella mike violet499daniel nina william500emma octavian xanthippe501fred paula yates502gertrude quintus zoe503harold rita504ingrid sam505<---- 50 ---->506alice jake tammy507bob lisa ulysses508cinderella-cinderella mike violet509daniel nina william510emma octavian xanthippe511fred paula yates512gertrude quintus zoe513harold rita514ingrid sam515<---- 51 ---->516alice harold paula william517bob ingrid quintus xanthippe518cinderella-cinderella jake rita yates519daniel lisa sam zoe520emma mike tammy521fred nina ulysses522gertrude octavian violet523<---- 52 ---->524alice harold paula william525bob ingrid quintus xanthippe526cinderella-cinderella jake rita yates527daniel lisa sam zoe528emma mike tammy529fred nina ulysses530gertrude octavian violet531<---- 53 ---->532alice harold paula william533bob ingrid quintus xanthippe534cinderella-cinderella jake rita yates535daniel lisa sam zoe536emma mike tammy537fred nina ulysses538gertrude octavian violet539<---- 54 ---->540alice harold paula william541bob ingrid quintus xanthippe542cinderella-cinderella jake rita yates543daniel lisa sam zoe544emma mike tammy545fred nina ulysses546gertrude octavian violet547<---- 55 ---->548alice harold paula william549bob ingrid quintus xanthippe550cinderella-cinderella jake rita yates551daniel lisa sam zoe552emma mike tammy553fred nina ulysses554gertrude octavian violet555<---- 56 ---->556alice harold paula william557bob ingrid quintus xanthippe558cinderella-cinderella jake rita yates559daniel lisa sam zoe560emma mike tammy561fred nina ulysses562gertrude octavian violet563<---- 57 ---->564alice harold paula william565bob ingrid quintus xanthippe566cinderella-cinderella jake rita yates567daniel lisa sam zoe568emma mike tammy569fred nina ulysses570gertrude octavian violet571<---- 58 ---->572alice harold paula william573bob ingrid quintus xanthippe574cinderella-cinderella jake rita yates575daniel lisa sam zoe576emma mike tammy577fred nina ulysses578gertrude octavian violet579<---- 59 ---->580alice harold paula william581bob ingrid quintus xanthippe582cinderella-cinderella jake rita yates583daniel lisa sam zoe584emma mike tammy585fred nina ulysses586gertrude octavian violet587<---- 60 ---->588alice harold paula william589bob ingrid quintus xanthippe590cinderella-cinderella jake rita yates591daniel lisa sam zoe592emma mike tammy593fred nina ulysses594gertrude octavian violet595<---- 61 ---->596alice fred lisa quintus violet597bob gertrude mike rita william598cinderella-cinderella harold nina sam xanthippe599daniel ingrid octavian tammy yates600emma jake paula ulysses zoe601<---- 62 ---->602alice fred lisa quintus violet603bob gertrude mike rita william604cinderella-cinderella harold nina sam xanthippe605daniel ingrid octavian tammy yates606emma jake paula ulysses zoe607<---- 63 ---->608alice fred lisa quintus violet609bob gertrude mike rita william610cinderella-cinderella harold nina sam xanthippe611daniel ingrid octavian tammy yates612emma jake paula ulysses zoe613<---- 64 ---->614alice fred lisa quintus violet615bob gertrude mike rita william616cinderella-cinderella harold nina sam xanthippe617daniel ingrid octavian tammy yates618emma jake paula ulysses zoe619<---- 65 ---->620alice fred lisa quintus violet621bob gertrude mike rita william622cinderella-cinderella harold nina sam xanthippe623daniel ingrid octavian tammy yates624emma jake paula ulysses zoe625<---- 66 ---->626alice fred lisa quintus violet627bob gertrude mike rita william628cinderella-cinderella harold nina sam xanthippe629daniel ingrid octavian tammy yates630emma jake paula ulysses zoe631<---- 67 ---->632alice fred lisa quintus violet633bob gertrude mike rita william634cinderella-cinderella harold nina sam xanthippe635daniel ingrid octavian tammy yates636emma jake paula ulysses zoe637<---- 68 ---->638alice fred lisa quintus violet639bob gertrude mike rita william640cinderella-cinderella harold nina sam xanthippe641daniel ingrid octavian tammy yates642emma jake paula ulysses zoe643<---- 69 ---->644alice fred lisa quintus violet645bob gertrude mike rita william646cinderella-cinderella harold nina sam xanthippe647daniel ingrid octavian tammy yates648emma jake paula ulysses zoe649<---- 70 ---->650alice fred lisa quintus violet651bob gertrude mike rita william652cinderella-cinderella harold nina sam xanthippe653daniel ingrid octavian tammy yates654emma jake paula ulysses zoe655<---- 71 ---->656alice fred lisa quintus violet657bob gertrude mike rita william658cinderella-cinderella harold nina sam xanthippe659daniel ingrid octavian tammy yates660emma jake paula ulysses zoe661<---- 72 ---->662alice fred lisa quintus violet663bob gertrude mike rita william664cinderella-cinderella harold nina sam xanthippe665daniel ingrid octavian tammy yates666emma jake paula ulysses zoe667<---- 73 ---->668alice fred lisa quintus violet669bob gertrude mike rita william670cinderella-cinderella harold nina sam xanthippe671daniel ingrid octavian tammy yates672emma jake paula ulysses zoe673<---- 74 ---->674alice emma ingrid nina rita violet zoe675bob fred jake octavian sam william676cinderella-cinderella gertrude lisa paula tammy xanthippe677daniel harold mike quintus ulysses yates678<---- 75 ---->679alice emma ingrid nina rita violet zoe680bob fred jake octavian sam william681cinderella-cinderella gertrude lisa paula tammy xanthippe682daniel harold mike quintus ulysses yates683<---- 76 ---->684alice emma ingrid nina rita violet zoe685bob fred jake octavian sam william686cinderella-cinderella gertrude lisa paula tammy xanthippe687daniel harold mike quintus ulysses yates688<---- 77 ---->689alice emma ingrid nina rita violet zoe690bob fred jake octavian sam william691cinderella-cinderella gertrude lisa paula tammy xanthippe692daniel harold mike quintus ulysses yates693<---- 78 ---->694alice emma ingrid nina rita violet zoe695bob fred jake octavian sam william696cinderella-cinderella gertrude lisa paula tammy xanthippe697daniel harold mike quintus ulysses yates698<---- 79 ---->699alice emma ingrid nina rita violet zoe700bob fred jake octavian sam william701cinderella-cinderella gertrude lisa paula tammy xanthippe702daniel harold mike quintus ulysses yates703<---- 80 ---->704alice emma ingrid nina rita violet zoe705bob fred jake octavian sam william706cinderella-cinderella gertrude lisa paula tammy xanthippe707daniel harold mike quintus ulysses yates708}709 710do_test 1.0 {711 db eval {712 CREATE TABLE t1(x);713 INSERT INTO t1(x) VALUES714 ('alice'),715 ('bob'),716 ('cinderella-cinderella'),717 ('daniel'),718 ('emma'),719 ('fred'),720 ('gertrude'),721 ('harold'),722 ('ingrid'),723 ('jake'),724 ('lisa'),725 ('mike'),726 ('nina'),727 ('octavian'),728 ('paula'),729 ('quintus'),730 ('rita'),731 ('sam'),732 ('tammy'),733 ('ulysses'),734 ('violet'),735 ('william'),736 ('xanthippe'),737 ('yates'),738 ('zoe');739 }740 set res \n741 for {set i 22} {$i<=80} {incr i} {742 set sp [expr {$i-13}]743 append res [format "<----%*s%3d%*s---->\n" \744 [expr {$sp/2}] {} $i [expr {$sp-$sp/2}] {}]745 append res [db format -style column -title off \746 -screenwidth $i -splitcolumn on \747 {SELECT x FROM t1 ORDER BY x ASC}]748 }749 expr {$res eq $::expected}750} {1}751