Debian Codegraph @

test/qrf04.test

raw
1 # 2025-11-23
2 #
3 # The author disclaims copyright to this source code. In place of
4 # 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 especially
13 # the bSplitColumn feature.
14 #
15
16 set testdir [file dirname $argv0]
17 source $testdir/tester.tcl
18 set testprefix qrf01
19
20 # The expected output from test 1.1. The "do_test" procedure normally
21 # ignores differences in whitespace, but whitespace is important for
22 # this test, so we have to do the comparison ourselves.
23 #
24 set expected {
25 <---- 22 ---->
26 alice
27 bob
28 cinderella-cinderella
29 daniel
30 emma
31 fred
32 gertrude
33 harold
34 ingrid
35 jake
36 lisa
37 mike
38 nina
39 octavian
40 paula
41 quintus
42 rita
43 sam
44 tammy
45 ulysses
46 violet
47 william
48 xanthippe
49 yates
50 zoe
51 <---- 23 ---->
52 alice
53 bob
54 cinderella-cinderella
55 daniel
56 emma
57 fred
58 gertrude
59 harold
60 ingrid
61 jake
62 lisa
63 mike
64 nina
65 octavian
66 paula
67 quintus
68 rita
69 sam
70 tammy
71 ulysses
72 violet
73 william
74 xanthippe
75 yates
76 zoe
77 <---- 24 ---->
78 alice
79 bob
80 cinderella-cinderella
81 daniel
82 emma
83 fred
84 gertrude
85 harold
86 ingrid
87 jake
88 lisa
89 mike
90 nina
91 octavian
92 paula
93 quintus
94 rita
95 sam
96 tammy
97 ulysses
98 violet
99 william
100 xanthippe
101 yates
102 zoe
103 <---- 25 ---->
104 alice
105 bob
106 cinderella-cinderella
107 daniel
108 emma
109 fred
110 gertrude
111 harold
112 ingrid
113 jake
114 lisa
115 mike
116 nina
117 octavian
118 paula
119 quintus
120 rita
121 sam
122 tammy
123 ulysses
124 violet
125 william
126 xanthippe
127 yates
128 zoe
129 <---- 26 ---->
130 alice
131 bob
132 cinderella-cinderella
133 daniel
134 emma
135 fred
136 gertrude
137 harold
138 ingrid
139 jake
140 lisa
141 mike
142 nina
143 octavian
144 paula
145 quintus
146 rita
147 sam
148 tammy
149 ulysses
150 violet
151 william
152 xanthippe
153 yates
154 zoe
155 <---- 27 ---->
156 alice
157 bob
158 cinderella-cinderella
159 daniel
160 emma
161 fred
162 gertrude
163 harold
164 ingrid
165 jake
166 lisa
167 mike
168 nina
169 octavian
170 paula
171 quintus
172 rita
173 sam
174 tammy
175 ulysses
176 violet
177 william
178 xanthippe
179 yates
180 zoe
181 <---- 28 ---->
182 alice
183 bob
184 cinderella-cinderella
185 daniel
186 emma
187 fred
188 gertrude
189 harold
190 ingrid
191 jake
192 lisa
193 mike
194 nina
195 octavian
196 paula
197 quintus
198 rita
199 sam
200 tammy
201 ulysses
202 violet
203 william
204 xanthippe
205 yates
206 zoe
207 <---- 29 ---->
208 alice
209 bob
210 cinderella-cinderella
211 daniel
212 emma
213 fred
214 gertrude
215 harold
216 ingrid
217 jake
218 lisa
219 mike
220 nina
221 octavian
222 paula
223 quintus
224 rita
225 sam
226 tammy
227 ulysses
228 violet
229 william
230 xanthippe
231 yates
232 zoe
233 <---- 30 ---->
234 alice
235 bob
236 cinderella-cinderella
237 daniel
238 emma
239 fred
240 gertrude
241 harold
242 ingrid
243 jake
244 lisa
245 mike
246 nina
247 octavian
248 paula
249 quintus
250 rita
251 sam
252 tammy
253 ulysses
254 violet
255 william
256 xanthippe
257 yates
258 zoe
259 <---- 31 ---->
260 alice
261 bob
262 cinderella-cinderella
263 daniel
264 emma
265 fred
266 gertrude
267 harold
268 ingrid
269 jake
270 lisa
271 mike
272 nina
273 octavian
274 paula
275 quintus
276 rita
277 sam
278 tammy
279 ulysses
280 violet
281 william
282 xanthippe
283 yates
284 zoe
285 <---- 32 ---->
286 alice octavian
287 bob paula
288 cinderella-cinderella quintus
289 daniel rita
290 emma sam
291 fred tammy
292 gertrude ulysses
293 harold violet
294 ingrid william
295 jake xanthippe
296 lisa yates
297 mike zoe
298 nina
299 <---- 33 ---->
300 alice octavian
301 bob paula
302 cinderella-cinderella quintus
303 daniel rita
304 emma sam
305 fred tammy
306 gertrude ulysses
307 harold violet
308 ingrid william
309 jake xanthippe
310 lisa yates
311 mike zoe
312 nina
313 <---- 34 ---->
314 alice octavian
315 bob paula
316 cinderella-cinderella quintus
317 daniel rita
318 emma sam
319 fred tammy
320 gertrude ulysses
321 harold violet
322 ingrid william
323 jake xanthippe
324 lisa yates
325 mike zoe
326 nina
327 <---- 35 ---->
328 alice octavian
329 bob paula
330 cinderella-cinderella quintus
331 daniel rita
332 emma sam
333 fred tammy
334 gertrude ulysses
335 harold violet
336 ingrid william
337 jake xanthippe
338 lisa yates
339 mike zoe
340 nina
341 <---- 36 ---->
342 alice octavian
343 bob paula
344 cinderella-cinderella quintus
345 daniel rita
346 emma sam
347 fred tammy
348 gertrude ulysses
349 harold violet
350 ingrid william
351 jake xanthippe
352 lisa yates
353 mike zoe
354 nina
355 <---- 37 ---->
356 alice octavian
357 bob paula
358 cinderella-cinderella quintus
359 daniel rita
360 emma sam
361 fred tammy
362 gertrude ulysses
363 harold violet
364 ingrid william
365 jake xanthippe
366 lisa yates
367 mike zoe
368 nina
369 <---- 38 ---->
370 alice octavian
371 bob paula
372 cinderella-cinderella quintus
373 daniel rita
374 emma sam
375 fred tammy
376 gertrude ulysses
377 harold violet
378 ingrid william
379 jake xanthippe
380 lisa yates
381 mike zoe
382 nina
383 <---- 39 ---->
384 alice octavian
385 bob paula
386 cinderella-cinderella quintus
387 daniel rita
388 emma sam
389 fred tammy
390 gertrude ulysses
391 harold violet
392 ingrid william
393 jake xanthippe
394 lisa yates
395 mike zoe
396 nina
397 <---- 40 ---->
398 alice octavian
399 bob paula
400 cinderella-cinderella quintus
401 daniel rita
402 emma sam
403 fred tammy
404 gertrude ulysses
405 harold violet
406 ingrid william
407 jake xanthippe
408 lisa yates
409 mike zoe
410 nina
411 <---- 41 ---->
412 alice octavian
413 bob paula
414 cinderella-cinderella quintus
415 daniel rita
416 emma sam
417 fred tammy
418 gertrude ulysses
419 harold violet
420 ingrid william
421 jake xanthippe
422 lisa yates
423 mike zoe
424 nina
425 <---- 42 ---->
426 alice jake tammy
427 bob lisa ulysses
428 cinderella-cinderella mike violet
429 daniel nina william
430 emma octavian xanthippe
431 fred paula yates
432 gertrude quintus zoe
433 harold rita
434 ingrid sam
435 <---- 43 ---->
436 alice jake tammy
437 bob lisa ulysses
438 cinderella-cinderella mike violet
439 daniel nina william
440 emma octavian xanthippe
441 fred paula yates
442 gertrude quintus zoe
443 harold rita
444 ingrid sam
445 <---- 44 ---->
446 alice jake tammy
447 bob lisa ulysses
448 cinderella-cinderella mike violet
449 daniel nina william
450 emma octavian xanthippe
451 fred paula yates
452 gertrude quintus zoe
453 harold rita
454 ingrid sam
455 <---- 45 ---->
456 alice jake tammy
457 bob lisa ulysses
458 cinderella-cinderella mike violet
459 daniel nina william
460 emma octavian xanthippe
461 fred paula yates
462 gertrude quintus zoe
463 harold rita
464 ingrid sam
465 <---- 46 ---->
466 alice jake tammy
467 bob lisa ulysses
468 cinderella-cinderella mike violet
469 daniel nina william
470 emma octavian xanthippe
471 fred paula yates
472 gertrude quintus zoe
473 harold rita
474 ingrid sam
475 <---- 47 ---->
476 alice jake tammy
477 bob lisa ulysses
478 cinderella-cinderella mike violet
479 daniel nina william
480 emma octavian xanthippe
481 fred paula yates
482 gertrude quintus zoe
483 harold rita
484 ingrid sam
485 <---- 48 ---->
486 alice jake tammy
487 bob lisa ulysses
488 cinderella-cinderella mike violet
489 daniel nina william
490 emma octavian xanthippe
491 fred paula yates
492 gertrude quintus zoe
493 harold rita
494 ingrid sam
495 <---- 49 ---->
496 alice jake tammy
497 bob lisa ulysses
498 cinderella-cinderella mike violet
499 daniel nina william
500 emma octavian xanthippe
501 fred paula yates
502 gertrude quintus zoe
503 harold rita
504 ingrid sam
505 <---- 50 ---->
506 alice jake tammy
507 bob lisa ulysses
508 cinderella-cinderella mike violet
509 daniel nina william
510 emma octavian xanthippe
511 fred paula yates
512 gertrude quintus zoe
513 harold rita
514 ingrid sam
515 <---- 51 ---->
516 alice harold paula william
517 bob ingrid quintus xanthippe
518 cinderella-cinderella jake rita yates
519 daniel lisa sam zoe
520 emma mike tammy
521 fred nina ulysses
522 gertrude octavian violet
523 <---- 52 ---->
524 alice harold paula william
525 bob ingrid quintus xanthippe
526 cinderella-cinderella jake rita yates
527 daniel lisa sam zoe
528 emma mike tammy
529 fred nina ulysses
530 gertrude octavian violet
531 <---- 53 ---->
532 alice harold paula william
533 bob ingrid quintus xanthippe
534 cinderella-cinderella jake rita yates
535 daniel lisa sam zoe
536 emma mike tammy
537 fred nina ulysses
538 gertrude octavian violet
539 <---- 54 ---->
540 alice harold paula william
541 bob ingrid quintus xanthippe
542 cinderella-cinderella jake rita yates
543 daniel lisa sam zoe
544 emma mike tammy
545 fred nina ulysses
546 gertrude octavian violet
547 <---- 55 ---->
548 alice harold paula william
549 bob ingrid quintus xanthippe
550 cinderella-cinderella jake rita yates
551 daniel lisa sam zoe
552 emma mike tammy
553 fred nina ulysses
554 gertrude octavian violet
555 <---- 56 ---->
556 alice harold paula william
557 bob ingrid quintus xanthippe
558 cinderella-cinderella jake rita yates
559 daniel lisa sam zoe
560 emma mike tammy
561 fred nina ulysses
562 gertrude octavian violet
563 <---- 57 ---->
564 alice harold paula william
565 bob ingrid quintus xanthippe
566 cinderella-cinderella jake rita yates
567 daniel lisa sam zoe
568 emma mike tammy
569 fred nina ulysses
570 gertrude octavian violet
571 <---- 58 ---->
572 alice harold paula william
573 bob ingrid quintus xanthippe
574 cinderella-cinderella jake rita yates
575 daniel lisa sam zoe
576 emma mike tammy
577 fred nina ulysses
578 gertrude octavian violet
579 <---- 59 ---->
580 alice harold paula william
581 bob ingrid quintus xanthippe
582 cinderella-cinderella jake rita yates
583 daniel lisa sam zoe
584 emma mike tammy
585 fred nina ulysses
586 gertrude octavian violet
587 <---- 60 ---->
588 alice harold paula william
589 bob ingrid quintus xanthippe
590 cinderella-cinderella jake rita yates
591 daniel lisa sam zoe
592 emma mike tammy
593 fred nina ulysses
594 gertrude octavian violet
595 <---- 61 ---->
596 alice fred lisa quintus violet
597 bob gertrude mike rita william
598 cinderella-cinderella harold nina sam xanthippe
599 daniel ingrid octavian tammy yates
600 emma jake paula ulysses zoe
601 <---- 62 ---->
602 alice fred lisa quintus violet
603 bob gertrude mike rita william
604 cinderella-cinderella harold nina sam xanthippe
605 daniel ingrid octavian tammy yates
606 emma jake paula ulysses zoe
607 <---- 63 ---->
608 alice fred lisa quintus violet
609 bob gertrude mike rita william
610 cinderella-cinderella harold nina sam xanthippe
611 daniel ingrid octavian tammy yates
612 emma jake paula ulysses zoe
613 <---- 64 ---->
614 alice fred lisa quintus violet
615 bob gertrude mike rita william
616 cinderella-cinderella harold nina sam xanthippe
617 daniel ingrid octavian tammy yates
618 emma jake paula ulysses zoe
619 <---- 65 ---->
620 alice fred lisa quintus violet
621 bob gertrude mike rita william
622 cinderella-cinderella harold nina sam xanthippe
623 daniel ingrid octavian tammy yates
624 emma jake paula ulysses zoe
625 <---- 66 ---->
626 alice fred lisa quintus violet
627 bob gertrude mike rita william
628 cinderella-cinderella harold nina sam xanthippe
629 daniel ingrid octavian tammy yates
630 emma jake paula ulysses zoe
631 <---- 67 ---->
632 alice fred lisa quintus violet
633 bob gertrude mike rita william
634 cinderella-cinderella harold nina sam xanthippe
635 daniel ingrid octavian tammy yates
636 emma jake paula ulysses zoe
637 <---- 68 ---->
638 alice fred lisa quintus violet
639 bob gertrude mike rita william
640 cinderella-cinderella harold nina sam xanthippe
641 daniel ingrid octavian tammy yates
642 emma jake paula ulysses zoe
643 <---- 69 ---->
644 alice fred lisa quintus violet
645 bob gertrude mike rita william
646 cinderella-cinderella harold nina sam xanthippe
647 daniel ingrid octavian tammy yates
648 emma jake paula ulysses zoe
649 <---- 70 ---->
650 alice fred lisa quintus violet
651 bob gertrude mike rita william
652 cinderella-cinderella harold nina sam xanthippe
653 daniel ingrid octavian tammy yates
654 emma jake paula ulysses zoe
655 <---- 71 ---->
656 alice fred lisa quintus violet
657 bob gertrude mike rita william
658 cinderella-cinderella harold nina sam xanthippe
659 daniel ingrid octavian tammy yates
660 emma jake paula ulysses zoe
661 <---- 72 ---->
662 alice fred lisa quintus violet
663 bob gertrude mike rita william
664 cinderella-cinderella harold nina sam xanthippe
665 daniel ingrid octavian tammy yates
666 emma jake paula ulysses zoe
667 <---- 73 ---->
668 alice fred lisa quintus violet
669 bob gertrude mike rita william
670 cinderella-cinderella harold nina sam xanthippe
671 daniel ingrid octavian tammy yates
672 emma jake paula ulysses zoe
673 <---- 74 ---->
674 alice emma ingrid nina rita violet zoe
675 bob fred jake octavian sam william
676 cinderella-cinderella gertrude lisa paula tammy xanthippe
677 daniel harold mike quintus ulysses yates
678 <---- 75 ---->
679 alice emma ingrid nina rita violet zoe
680 bob fred jake octavian sam william
681 cinderella-cinderella gertrude lisa paula tammy xanthippe
682 daniel harold mike quintus ulysses yates
683 <---- 76 ---->
684 alice emma ingrid nina rita violet zoe
685 bob fred jake octavian sam william
686 cinderella-cinderella gertrude lisa paula tammy xanthippe
687 daniel harold mike quintus ulysses yates
688 <---- 77 ---->
689 alice emma ingrid nina rita violet zoe
690 bob fred jake octavian sam william
691 cinderella-cinderella gertrude lisa paula tammy xanthippe
692 daniel harold mike quintus ulysses yates
693 <---- 78 ---->
694 alice emma ingrid nina rita violet zoe
695 bob fred jake octavian sam william
696 cinderella-cinderella gertrude lisa paula tammy xanthippe
697 daniel harold mike quintus ulysses yates
698 <---- 79 ---->
699 alice emma ingrid nina rita violet zoe
700 bob fred jake octavian sam william
701 cinderella-cinderella gertrude lisa paula tammy xanthippe
702 daniel harold mike quintus ulysses yates
703 <---- 80 ---->
704 alice emma ingrid nina rita violet zoe
705 bob fred jake octavian sam william
706 cinderella-cinderella gertrude lisa paula tammy xanthippe
707 daniel harold mike quintus ulysses yates
708 }
709
710 do_test 1.0 {
711 db eval {
712 CREATE TABLE t1(x);
713 INSERT INTO t1(x) VALUES
714 ('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 \n
741 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}