Lines Matching refs:r

375 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND …
376     lappend myres [format %.4f [set r]]
380   foreach r [set myres] r2 [set res2] {
381     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
382       error "list element [set i] does not match: got=[set r] expected=[set r2]"
392 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN UNBOUN…
393     lappend myres [format %.4f [set r]]
397   foreach r [set myres] r2 [set res2] {
398     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
399       error "list element [set i] does not match: got=[set r] expected=[set r2]"
409 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND …
410     lappend myres [format %.4f [set r]]
414   foreach r [set myres] r2 [set res2] {
415     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
416       error "list element [set i] does not match: got=[set r] expected=[set r2]"
426 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN UNBOUN…
427     lappend myres [format %.4f [set r]]
431   foreach r [set myres] r2 [set res2] {
432     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
433       error "list element [set i] does not match: got=[set r] expected=[set r2]"
443 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 RANGE BETWEEN UNBOUNDED PRECEDING A…
444     lappend myres [format %.4f [set r]]
448   foreach r [set myres] r2 [set res2] {
449     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
450       error "list element [set i] does not match: got=[set r] expected=[set r2]"
460 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN UNBOU…
461     lappend myres [format %.4f [set r]]
465   foreach r [set myres] r2 [set res2] {
466     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
467       error "list element [set i] does not match: got=[set r] expected=[set r2]"
477 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CUR…
478     lappend myres [format %.4f [set r]]
482   foreach r [set myres] r2 [set res2] {
483     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
484       error "list element [set i] does not match: got=[set r] expected=[set r2]"
494 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN UNBOUNDED…
495     lappend myres [format %.4f [set r]]
499   foreach r [set myres] r2 [set res2] {
500     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
501       error "list element [set i] does not match: got=[set r] expected=[set r2]"
511 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CUR…
512     lappend myres [format %.4f [set r]]
516   foreach r [set myres] r2 [set res2] {
517     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
518       error "list element [set i] does not match: got=[set r] expected=[set r2]"
528 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN UNBOUNDED…
529     lappend myres [format %.4f [set r]]
533   foreach r [set myres] r2 [set res2] {
534     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
535       error "list element [set i] does not match: got=[set r] expected=[set r2]"
545 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 RANGE BETWEEN UNBOUNDED PRECEDING AND …
546     lappend myres [format %.4f [set r]]
550   foreach r [set myres] r2 [set res2] {
551     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
552       error "list element [set i] does not match: got=[set r] expected=[set r2]"
562 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN UNBOUND…
563     lappend myres [format %.4f [set r]]
567   foreach r [set myres] r2 [set res2] {
568     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
569       error "list element [set i] does not match: got=[set r] expected=[set r2]"
579 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURR…
580     lappend myres [format %.4f [set r]]
584   foreach r [set myres] r2 [set res2] {
585     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
586       error "list element [set i] does not match: got=[set r] expected=[set r2]"
596 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN UNBOUNDED …
597     lappend myres [format %.4f [set r]]
601   foreach r [set myres] r2 [set res2] {
602     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
603       error "list element [set i] does not match: got=[set r] expected=[set r2]"
613 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a RANGE BETWEEN UNBOUNDED PRECEDING AND CU…
614     lappend myres [format %.4f [set r]]
618   foreach r [set myres] r2 [set res2] {
619     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
620       error "list element [set i] does not match: got=[set r] expected=[set r2]"
630 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a RANGE BETWEEN UNBOUNDE…
631     lappend myres [format %.4f [set r]]
635   foreach r [set myres] r2 [set res2] {
636     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
637       error "list element [set i] does not match: got=[set r] expected=[set r2]"
647 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a RANGE BETWEEN UNBOUNDED PRECEDING AND…
648     lappend myres [format %.4f [set r]]
652   foreach r [set myres] r2 [set res2] {
653     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
654       error "list element [set i] does not match: got=[set r] expected=[set r2]"
664 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 RANGE BETWEEN UNBOUND…
665     lappend myres [format %.4f [set r]]
669   foreach r [set myres] r2 [set res2] {
670     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
671       error "list element [set i] does not match: got=[set r] expected=[set r2]"
681 …foreach r [db eval {SELECT ntile(105) OVER ( RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) F…
682     lappend myres [format %.4f [set r]]
686   foreach r [set myres] r2 [set res2] {
687     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
688       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2628 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND …
2629     lappend myres [format %.4f [set r]]
2633   foreach r [set myres] r2 [set res2] {
2634     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2635       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2645 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN UNBOUN…
2646     lappend myres [format %.4f [set r]]
2650   foreach r [set myres] r2 [set res2] {
2651     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2652       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2662 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND …
2663     lappend myres [format %.4f [set r]]
2667   foreach r [set myres] r2 [set res2] {
2668     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2669       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2679 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN UNBOUN…
2680     lappend myres [format %.4f [set r]]
2684   foreach r [set myres] r2 [set res2] {
2685     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2686       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2696 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 RANGE BETWEEN UNBOUNDED PRECEDING A…
2697     lappend myres [format %.4f [set r]]
2701   foreach r [set myres] r2 [set res2] {
2702     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2703       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2713 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN UNBOU…
2714     lappend myres [format %.4f [set r]]
2718   foreach r [set myres] r2 [set res2] {
2719     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2720       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2730 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND UNB…
2731     lappend myres [format %.4f [set r]]
2735   foreach r [set myres] r2 [set res2] {
2736     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2737       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2747 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN UNBOUNDED…
2748     lappend myres [format %.4f [set r]]
2752   foreach r [set myres] r2 [set res2] {
2753     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2754       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2764 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND UNB…
2765     lappend myres [format %.4f [set r]]
2769   foreach r [set myres] r2 [set res2] {
2770     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2771       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2781 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN UNBOUNDED…
2782     lappend myres [format %.4f [set r]]
2786   foreach r [set myres] r2 [set res2] {
2787     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2788       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2798 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 RANGE BETWEEN UNBOUNDED PRECEDING AND …
2799     lappend myres [format %.4f [set r]]
2803   foreach r [set myres] r2 [set res2] {
2804     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2805       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2815 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN UNBOUND…
2816     lappend myres [format %.4f [set r]]
2820   foreach r [set myres] r2 [set res2] {
2821     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2822       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2832 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND UNBO…
2833     lappend myres [format %.4f [set r]]
2837   foreach r [set myres] r2 [set res2] {
2838     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2839       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2849 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN UNBOUNDED …
2850     lappend myres [format %.4f [set r]]
2854   foreach r [set myres] r2 [set res2] {
2855     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2856       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2866 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a RANGE BETWEEN UNBOUNDED PRECEDING AND UN…
2867     lappend myres [format %.4f [set r]]
2871   foreach r [set myres] r2 [set res2] {
2872     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2873       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2883 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a RANGE BETWEEN UNBOUNDE…
2884     lappend myres [format %.4f [set r]]
2888   foreach r [set myres] r2 [set res2] {
2889     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2890       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2900 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a RANGE BETWEEN UNBOUNDED PRECEDING AND…
2901     lappend myres [format %.4f [set r]]
2905   foreach r [set myres] r2 [set res2] {
2906     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2907       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2917 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 RANGE BETWEEN UNBOUND…
2918     lappend myres [format %.4f [set r]]
2922   foreach r [set myres] r2 [set res2] {
2923     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2924       error "list element [set i] does not match: got=[set r] expected=[set r2]"
2934 …foreach r [db eval {SELECT ntile(105) OVER ( RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLO…
2935     lappend myres [format %.4f [set r]]
2939   foreach r [set myres] r2 [set res2] {
2940     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
2941       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5148 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a RANGE BETWEEN CURRENT ROW         AND …
5149     lappend myres [format %.4f [set r]]
5153   foreach r [set myres] r2 [set res2] {
5154     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5155       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5165 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN CURREN…
5166     lappend myres [format %.4f [set r]]
5170   foreach r [set myres] r2 [set res2] {
5171     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5172       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5182 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b RANGE BETWEEN CURRENT ROW         AND …
5183     lappend myres [format %.4f [set r]]
5187   foreach r [set myres] r2 [set res2] {
5188     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5189       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5199 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN CURREN…
5200     lappend myres [format %.4f [set r]]
5204   foreach r [set myres] r2 [set res2] {
5205     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5206       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5216 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 RANGE BETWEEN CURRENT ROW         A…
5217     lappend myres [format %.4f [set r]]
5221   foreach r [set myres] r2 [set res2] {
5222     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5223       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5233 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN CURRE…
5234     lappend myres [format %.4f [set r]]
5238   foreach r [set myres] r2 [set res2] {
5239     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5240       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5250 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a RANGE BETWEEN CURRENT ROW         AND CUR…
5251     lappend myres [format %.4f [set r]]
5255   foreach r [set myres] r2 [set res2] {
5256     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5257       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5267 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN CURRENT R…
5268     lappend myres [format %.4f [set r]]
5272   foreach r [set myres] r2 [set res2] {
5273     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5274       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5284 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b RANGE BETWEEN CURRENT ROW         AND CUR…
5285     lappend myres [format %.4f [set r]]
5289   foreach r [set myres] r2 [set res2] {
5290     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5291       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5301 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN CURRENT R…
5302     lappend myres [format %.4f [set r]]
5306   foreach r [set myres] r2 [set res2] {
5307     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5308       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5318 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 RANGE BETWEEN CURRENT ROW         AND …
5319     lappend myres [format %.4f [set r]]
5323   foreach r [set myres] r2 [set res2] {
5324     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5325       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5335 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN CURRENT…
5336     lappend myres [format %.4f [set r]]
5340   foreach r [set myres] r2 [set res2] {
5341     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5342       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5352 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a RANGE BETWEEN CURRENT ROW         AND CURR…
5353     lappend myres [format %.4f [set r]]
5357   foreach r [set myres] r2 [set res2] {
5358     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5359       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5369 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN CURRENT RO…
5370     lappend myres [format %.4f [set r]]
5374   foreach r [set myres] r2 [set res2] {
5375     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5376       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5386 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a RANGE BETWEEN CURRENT ROW         AND CU…
5387     lappend myres [format %.4f [set r]]
5391   foreach r [set myres] r2 [set res2] {
5392     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5393       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5403 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a RANGE BETWEEN CURRENT …
5404     lappend myres [format %.4f [set r]]
5408   foreach r [set myres] r2 [set res2] {
5409     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5410       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5420 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a RANGE BETWEEN CURRENT ROW         AND…
5421     lappend myres [format %.4f [set r]]
5425   foreach r [set myres] r2 [set res2] {
5426     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5427       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5437 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 RANGE BETWEEN CURRENT…
5438     lappend myres [format %.4f [set r]]
5442   foreach r [set myres] r2 [set res2] {
5443     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5444       error "list element [set i] does not match: got=[set r] expected=[set r2]"
5454 …foreach r [db eval {SELECT ntile(105) OVER ( RANGE BETWEEN CURRENT ROW         AND CURRENT ROW ) F…
5455     lappend myres [format %.4f [set r]]
5459   foreach r [set myres] r2 [set res2] {
5460     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
5461       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6509 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a RANGE BETWEEN CURRENT ROW         AND …
6510     lappend myres [format %.4f [set r]]
6514   foreach r [set myres] r2 [set res2] {
6515     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6516       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6526 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN CURREN…
6527     lappend myres [format %.4f [set r]]
6531   foreach r [set myres] r2 [set res2] {
6532     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6533       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6543 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b RANGE BETWEEN CURRENT ROW         AND …
6544     lappend myres [format %.4f [set r]]
6548   foreach r [set myres] r2 [set res2] {
6549     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6550       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6560 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN CURREN…
6561     lappend myres [format %.4f [set r]]
6565   foreach r [set myres] r2 [set res2] {
6566     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6567       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6577 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 RANGE BETWEEN CURRENT ROW         A…
6578     lappend myres [format %.4f [set r]]
6582   foreach r [set myres] r2 [set res2] {
6583     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6584       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6594 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN CURRE…
6595     lappend myres [format %.4f [set r]]
6599   foreach r [set myres] r2 [set res2] {
6600     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6601       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6611 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a RANGE BETWEEN CURRENT ROW         AND UNB…
6612     lappend myres [format %.4f [set r]]
6616   foreach r [set myres] r2 [set res2] {
6617     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6618       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6628 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN CURRENT R…
6629     lappend myres [format %.4f [set r]]
6633   foreach r [set myres] r2 [set res2] {
6634     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6635       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6645 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b RANGE BETWEEN CURRENT ROW         AND UNB…
6646     lappend myres [format %.4f [set r]]
6650   foreach r [set myres] r2 [set res2] {
6651     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6652       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6662 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b RANGE BETWEEN CURRENT R…
6663     lappend myres [format %.4f [set r]]
6667   foreach r [set myres] r2 [set res2] {
6668     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6669       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6679 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 RANGE BETWEEN CURRENT ROW         AND …
6680     lappend myres [format %.4f [set r]]
6684   foreach r [set myres] r2 [set res2] {
6685     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6686       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6696 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 RANGE BETWEEN CURRENT…
6697     lappend myres [format %.4f [set r]]
6701   foreach r [set myres] r2 [set res2] {
6702     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6703       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6713 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a RANGE BETWEEN CURRENT ROW         AND UNBO…
6714     lappend myres [format %.4f [set r]]
6718   foreach r [set myres] r2 [set res2] {
6719     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6720       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6730 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a RANGE BETWEEN CURRENT RO…
6731     lappend myres [format %.4f [set r]]
6735   foreach r [set myres] r2 [set res2] {
6736     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6737       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6747 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a RANGE BETWEEN CURRENT ROW         AND UN…
6748     lappend myres [format %.4f [set r]]
6752   foreach r [set myres] r2 [set res2] {
6753     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6754       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6764 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a RANGE BETWEEN CURRENT …
6765     lappend myres [format %.4f [set r]]
6769   foreach r [set myres] r2 [set res2] {
6770     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6771       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6781 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a RANGE BETWEEN CURRENT ROW         AND…
6782     lappend myres [format %.4f [set r]]
6786   foreach r [set myres] r2 [set res2] {
6787     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6788       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6798 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 RANGE BETWEEN CURRENT…
6799     lappend myres [format %.4f [set r]]
6803   foreach r [set myres] r2 [set res2] {
6804     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6805       error "list element [set i] does not match: got=[set r] expected=[set r2]"
6815 …foreach r [db eval {SELECT ntile(105) OVER ( RANGE BETWEEN CURRENT ROW         AND UNBOUNDED FOLLO…
6816     lappend myres [format %.4f [set r]]
6820   foreach r [set myres] r2 [set res2] {
6821     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
6822       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8780 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 4…
8781     lappend myres [format %.4f [set r]]
8785   foreach r [set myres] r2 [set res2] {
8786     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8787       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8797 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUND…
8798     lappend myres [format %.4f [set r]]
8802   foreach r [set myres] r2 [set res2] {
8803     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8804       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8814 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND 4…
8815     lappend myres [format %.4f [set r]]
8819   foreach r [set myres] r2 [set res2] {
8820     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8821       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8831 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUND…
8832     lappend myres [format %.4f [set r]]
8836   foreach r [set myres] r2 [set res2] {
8837     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8838       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8848 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AN…
8849     lappend myres [format %.4f [set r]]
8853   foreach r [set myres] r2 [set res2] {
8854     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8855       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8865 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUN…
8866     lappend myres [format %.4f [set r]]
8870   foreach r [set myres] r2 [set res2] {
8871     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8872       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8882 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 4 PR…
8883     lappend myres [format %.4f [set r]]
8887   foreach r [set myres] r2 [set res2] {
8888     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8889       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8899 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED …
8900     lappend myres [format %.4f [set r]]
8904   foreach r [set myres] r2 [set res2] {
8905     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8906       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8916 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND 4 PR…
8917     lappend myres [format %.4f [set r]]
8921   foreach r [set myres] r2 [set res2] {
8922     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8923       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8933 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUNDED …
8934     lappend myres [format %.4f [set r]]
8938   foreach r [set myres] r2 [set res2] {
8939     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8940       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8950 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AND 4…
8951     lappend myres [format %.4f [set r]]
8955   foreach r [set myres] r2 [set res2] {
8956     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8957       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8967 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
8968     lappend myres [format %.4f [set r]]
8972   foreach r [set myres] r2 [set res2] {
8973     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8974       error "list element [set i] does not match: got=[set r] expected=[set r2]"
8984 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 4 PRE…
8985     lappend myres [format %.4f [set r]]
8989   foreach r [set myres] r2 [set res2] {
8990     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
8991       error "list element [set i] does not match: got=[set r] expected=[set r2]"
9001 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED P…
9002     lappend myres [format %.4f [set r]]
9006   foreach r [set myres] r2 [set res2] {
9007     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
9008       error "list element [set i] does not match: got=[set r] expected=[set r2]"
9018 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN UNBOUNDED PRECEDING AND 4 P…
9019     lappend myres [format %.4f [set r]]
9023   foreach r [set myres] r2 [set res2] {
9024     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
9025       error "list element [set i] does not match: got=[set r] expected=[set r2]"
9035 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN UNBOUNDED…
9036     lappend myres [format %.4f [set r]]
9040   foreach r [set myres] r2 [set res2] {
9041     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
9042       error "list element [set i] does not match: got=[set r] expected=[set r2]"
9052 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN UNBOUNDED PRECEDING AND …
9053     lappend myres [format %.4f [set r]]
9057   foreach r [set myres] r2 [set res2] {
9058     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
9059       error "list element [set i] does not match: got=[set r] expected=[set r2]"
9069 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
9070     lappend myres [format %.4f [set r]]
9074   foreach r [set myres] r2 [set res2] {
9075     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
9076       error "list element [set i] does not match: got=[set r] expected=[set r2]"
9086 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN UNBOUNDED PRECEDING AND 4 PRECEDING ) FR…
9087     lappend myres [format %.4f [set r]]
9091   foreach r [set myres] r2 [set res2] {
9092     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
9093       error "list element [set i] does not match: got=[set r] expected=[set r2]"
10923 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND 2 PREC…
10924     lappend myres [format %.4f [set r]]
10928   foreach r [set myres] r2 [set res2] {
10929     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
10930       error "list element [set i] does not match: got=[set r] expected=[set r2]"
10940 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
10941     lappend myres [format %.4f [set r]]
10945   foreach r [set myres] r2 [set res2] {
10946     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
10947       error "list element [set i] does not match: got=[set r] expected=[set r2]"
10957 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND 2 PREC…
10958     lappend myres [format %.4f [set r]]
10962   foreach r [set myres] r2 [set res2] {
10963     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
10964       error "list element [set i] does not match: got=[set r] expected=[set r2]"
10974 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
10975     lappend myres [format %.4f [set r]]
10979   foreach r [set myres] r2 [set res2] {
10980     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
10981       error "list element [set i] does not match: got=[set r] expected=[set r2]"
10991 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND 2 P…
10992     lappend myres [format %.4f [set r]]
10996   foreach r [set myres] r2 [set res2] {
10997     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
10998       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11008 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
11009     lappend myres [format %.4f [set r]]
11013   foreach r [set myres] r2 [set res2] {
11014     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11015       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11025 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND 2 PRECEDI…
11026     lappend myres [format %.4f [set r]]
11030   foreach r [set myres] r2 [set res2] {
11031     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11032       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11042 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
11043     lappend myres [format %.4f [set r]]
11047   foreach r [set myres] r2 [set res2] {
11048     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11049       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11059 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND 2 PRECEDI…
11060     lappend myres [format %.4f [set r]]
11064   foreach r [set myres] r2 [set res2] {
11065     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11066       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11076 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
11077     lappend myres [format %.4f [set r]]
11081   foreach r [set myres] r2 [set res2] {
11082     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11083       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11093 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND 2 PREC…
11094     lappend myres [format %.4f [set r]]
11098   foreach r [set myres] r2 [set res2] {
11099     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11100       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11110 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
11111     lappend myres [format %.4f [set r]]
11115   foreach r [set myres] r2 [set res2] {
11116     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11117       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11127 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND 2 PRECEDIN…
11128     lappend myres [format %.4f [set r]]
11132   foreach r [set myres] r2 [set res2] {
11133     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11134       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11144 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
11145     lappend myres [format %.4f [set r]]
11149   foreach r [set myres] r2 [set res2] {
11150     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11151       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11161 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND 2 PRECED…
11162     lappend myres [format %.4f [set r]]
11166   foreach r [set myres] r2 [set res2] {
11167     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11168       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11178 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
11179     lappend myres [format %.4f [set r]]
11183   foreach r [set myres] r2 [set res2] {
11184     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11185       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11195 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND 2 PRE…
11196     lappend myres [format %.4f [set r]]
11200   foreach r [set myres] r2 [set res2] {
11201     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11202       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11212 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
11213     lappend myres [format %.4f [set r]]
11217   foreach r [set myres] r2 [set res2] {
11218     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11219       error "list element [set i] does not match: got=[set r] expected=[set r2]"
11229 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND 2 PRECEDING ) FROM t2…
11230     lappend myres [format %.4f [set r]]
11234   foreach r [set myres] r2 [set res2] {
11235     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
11236       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12358 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND C…
12359     lappend myres [format %.4f [set r]]
12363   foreach r [set myres] r2 [set res2] {
12364     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12365       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12375 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUND…
12376     lappend myres [format %.4f [set r]]
12380   foreach r [set myres] r2 [set res2] {
12381     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12382       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12392 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND C…
12393     lappend myres [format %.4f [set r]]
12397   foreach r [set myres] r2 [set res2] {
12398     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12399       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12409 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUND…
12410     lappend myres [format %.4f [set r]]
12414   foreach r [set myres] r2 [set res2] {
12415     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12416       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12426 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AN…
12427     lappend myres [format %.4f [set r]]
12431   foreach r [set myres] r2 [set res2] {
12432     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12433       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12443 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUN…
12444     lappend myres [format %.4f [set r]]
12448   foreach r [set myres] r2 [set res2] {
12449     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12450       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12460 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURR…
12461     lappend myres [format %.4f [set r]]
12465   foreach r [set myres] r2 [set res2] {
12466     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12467       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12477 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED …
12478     lappend myres [format %.4f [set r]]
12482   foreach r [set myres] r2 [set res2] {
12483     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12484       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12494 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURR…
12495     lappend myres [format %.4f [set r]]
12499   foreach r [set myres] r2 [set res2] {
12500     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12501       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12511 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUNDED …
12512     lappend myres [format %.4f [set r]]
12516   foreach r [set myres] r2 [set res2] {
12517     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12518       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12528 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AND C…
12529     lappend myres [format %.4f [set r]]
12533   foreach r [set myres] r2 [set res2] {
12534     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12535       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12545 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
12546     lappend myres [format %.4f [set r]]
12550   foreach r [set myres] r2 [set res2] {
12551     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12552       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12562 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRE…
12563     lappend myres [format %.4f [set r]]
12567   foreach r [set myres] r2 [set res2] {
12568     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12569       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12579 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED P…
12580     lappend myres [format %.4f [set r]]
12584   foreach r [set myres] r2 [set res2] {
12585     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12586       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12596 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN UNBOUNDED PRECEDING AND CUR…
12597     lappend myres [format %.4f [set r]]
12601   foreach r [set myres] r2 [set res2] {
12602     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12603       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12613 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN UNBOUNDED…
12614     lappend myres [format %.4f [set r]]
12618   foreach r [set myres] r2 [set res2] {
12619     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12620       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12630 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN UNBOUNDED PRECEDING AND …
12631     lappend myres [format %.4f [set r]]
12635   foreach r [set myres] r2 [set res2] {
12636     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12637       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12647 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
12648     lappend myres [format %.4f [set r]]
12652   foreach r [set myres] r2 [set res2] {
12653     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12654       error "list element [set i] does not match: got=[set r] expected=[set r2]"
12664 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) FR…
12665     lappend myres [format %.4f [set r]]
12669   foreach r [set myres] r2 [set res2] {
12670     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
12671       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14612 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND CURREN…
14613     lappend myres [format %.4f [set r]]
14617   foreach r [set myres] r2 [set res2] {
14618     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14619       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14629 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
14630     lappend myres [format %.4f [set r]]
14634   foreach r [set myres] r2 [set res2] {
14635     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14636       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14646 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND CURREN…
14647     lappend myres [format %.4f [set r]]
14651   foreach r [set myres] r2 [set res2] {
14652     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14653       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14663 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
14664     lappend myres [format %.4f [set r]]
14668   foreach r [set myres] r2 [set res2] {
14669     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14670       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14680 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND CUR…
14681     lappend myres [format %.4f [set r]]
14685   foreach r [set myres] r2 [set res2] {
14686     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14687       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14697 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
14698     lappend myres [format %.4f [set r]]
14702   foreach r [set myres] r2 [set res2] {
14703     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14704       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14714 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND CURRENT R…
14715     lappend myres [format %.4f [set r]]
14719   foreach r [set myres] r2 [set res2] {
14720     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14721       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14731 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
14732     lappend myres [format %.4f [set r]]
14736   foreach r [set myres] r2 [set res2] {
14737     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14738       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14748 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND CURRENT R…
14749     lappend myres [format %.4f [set r]]
14753   foreach r [set myres] r2 [set res2] {
14754     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14755       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14765 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
14766     lappend myres [format %.4f [set r]]
14770   foreach r [set myres] r2 [set res2] {
14771     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14772       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14782 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND CURREN…
14783     lappend myres [format %.4f [set r]]
14787   foreach r [set myres] r2 [set res2] {
14788     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14789       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14799 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
14800     lappend myres [format %.4f [set r]]
14804   foreach r [set myres] r2 [set res2] {
14805     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14806       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14816 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND CURRENT RO…
14817     lappend myres [format %.4f [set r]]
14821   foreach r [set myres] r2 [set res2] {
14822     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14823       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14833 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
14834     lappend myres [format %.4f [set r]]
14838   foreach r [set myres] r2 [set res2] {
14839     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14840       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14850 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND CURRENT …
14851     lappend myres [format %.4f [set r]]
14855   foreach r [set myres] r2 [set res2] {
14856     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14857       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14867 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
14868     lappend myres [format %.4f [set r]]
14872   foreach r [set myres] r2 [set res2] {
14873     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14874       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14884 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND CURRE…
14885     lappend myres [format %.4f [set r]]
14889   foreach r [set myres] r2 [set res2] {
14890     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14891       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14901 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
14902     lappend myres [format %.4f [set r]]
14906   foreach r [set myres] r2 [set res2] {
14907     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14908       error "list element [set i] does not match: got=[set r] expected=[set r2]"
14918 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND CURRENT ROW ) FROM t2…
14919     lappend myres [format %.4f [set r]]
14923   foreach r [set myres] r2 [set res2] {
14924     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
14925       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16160 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND C…
16161     lappend myres [format %.4f [set r]]
16165   foreach r [set myres] r2 [set res2] {
16166     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16167       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16177 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT…
16178     lappend myres [format %.4f [set r]]
16182   foreach r [set myres] r2 [set res2] {
16183     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16184       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16194 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN CURRENT ROW         AND C…
16195     lappend myres [format %.4f [set r]]
16199   foreach r [set myres] r2 [set res2] {
16200     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16201       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16211 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN CURRENT…
16212     lappend myres [format %.4f [set r]]
16216   foreach r [set myres] r2 [set res2] {
16217     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16218       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16228 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN CURRENT ROW         AN…
16229     lappend myres [format %.4f [set r]]
16233   foreach r [set myres] r2 [set res2] {
16234     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16235       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16245 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN CURREN…
16246     lappend myres [format %.4f [set r]]
16250   foreach r [set myres] r2 [set res2] {
16251     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16252       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16262 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND CURR…
16263     lappend myres [format %.4f [set r]]
16267   foreach r [set myres] r2 [set res2] {
16268     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16269       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16279 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT RO…
16280     lappend myres [format %.4f [set r]]
16284   foreach r [set myres] r2 [set res2] {
16285     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16286       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16296 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN CURRENT ROW         AND CURR…
16297     lappend myres [format %.4f [set r]]
16301   foreach r [set myres] r2 [set res2] {
16302     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16303       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16313 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN CURRENT RO…
16314     lappend myres [format %.4f [set r]]
16318   foreach r [set myres] r2 [set res2] {
16319     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16320       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16330 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN CURRENT ROW         AND C…
16331     lappend myres [format %.4f [set r]]
16335   foreach r [set myres] r2 [set res2] {
16336     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16337       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16347 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN CURRENT …
16348     lappend myres [format %.4f [set r]]
16352   foreach r [set myres] r2 [set res2] {
16353     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16354       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16364 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND CURRE…
16365     lappend myres [format %.4f [set r]]
16369   foreach r [set myres] r2 [set res2] {
16370     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16371       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16381 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT ROW…
16382     lappend myres [format %.4f [set r]]
16386   foreach r [set myres] r2 [set res2] {
16387     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16388       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16398 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN CURRENT ROW         AND CUR…
16399     lappend myres [format %.4f [set r]]
16403   foreach r [set myres] r2 [set res2] {
16404     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16405       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16415 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN CURRENT R…
16416     lappend myres [format %.4f [set r]]
16420   foreach r [set myres] r2 [set res2] {
16421     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16422       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16432 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN CURRENT ROW         AND …
16433     lappend myres [format %.4f [set r]]
16437   foreach r [set myres] r2 [set res2] {
16438     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16439       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16449 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN CURRENT …
16450     lappend myres [format %.4f [set r]]
16454   foreach r [set myres] r2 [set res2] {
16455     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16456       error "list element [set i] does not match: got=[set r] expected=[set r2]"
16466 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN CURRENT ROW         AND CURRENT ROW ) FR…
16467     lappend myres [format %.4f [set r]]
16471   foreach r [set myres] r2 [set res2] {
16472     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
16473       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17521 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 4…
17522     lappend myres [format %.4f [set r]]
17526   foreach r [set myres] r2 [set res2] {
17527     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17528       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17538 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUND…
17539     lappend myres [format %.4f [set r]]
17543   foreach r [set myres] r2 [set res2] {
17544     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17545       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17555 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND 4…
17556     lappend myres [format %.4f [set r]]
17560   foreach r [set myres] r2 [set res2] {
17561     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17562       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17572 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUND…
17573     lappend myres [format %.4f [set r]]
17577   foreach r [set myres] r2 [set res2] {
17578     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17579       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17589 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AN…
17590     lappend myres [format %.4f [set r]]
17594   foreach r [set myres] r2 [set res2] {
17595     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17596       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17606 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUN…
17607     lappend myres [format %.4f [set r]]
17611   foreach r [set myres] r2 [set res2] {
17612     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17613       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17623 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 4 FO…
17624     lappend myres [format %.4f [set r]]
17628   foreach r [set myres] r2 [set res2] {
17629     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17630       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17640 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED …
17641     lappend myres [format %.4f [set r]]
17645   foreach r [set myres] r2 [set res2] {
17646     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17647       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17657 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND 4 FO…
17658     lappend myres [format %.4f [set r]]
17662   foreach r [set myres] r2 [set res2] {
17663     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17664       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17674 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUNDED …
17675     lappend myres [format %.4f [set r]]
17679   foreach r [set myres] r2 [set res2] {
17680     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17681       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17691 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AND 4…
17692     lappend myres [format %.4f [set r]]
17696   foreach r [set myres] r2 [set res2] {
17697     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17698       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17708 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
17709     lappend myres [format %.4f [set r]]
17713   foreach r [set myres] r2 [set res2] {
17714     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17715       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17725 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 4 FOL…
17726     lappend myres [format %.4f [set r]]
17730   foreach r [set myres] r2 [set res2] {
17731     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17732       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17742 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED P…
17743     lappend myres [format %.4f [set r]]
17747   foreach r [set myres] r2 [set res2] {
17748     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17749       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17759 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN UNBOUNDED PRECEDING AND 4 F…
17760     lappend myres [format %.4f [set r]]
17764   foreach r [set myres] r2 [set res2] {
17765     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17766       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17776 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN UNBOUNDED…
17777     lappend myres [format %.4f [set r]]
17781   foreach r [set myres] r2 [set res2] {
17782     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17783       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17793 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN UNBOUNDED PRECEDING AND …
17794     lappend myres [format %.4f [set r]]
17798   foreach r [set myres] r2 [set res2] {
17799     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17800       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17810 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
17811     lappend myres [format %.4f [set r]]
17815   foreach r [set myres] r2 [set res2] {
17816     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17817       error "list element [set i] does not match: got=[set r] expected=[set r2]"
17827 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN UNBOUNDED PRECEDING AND 4 FOLLOWING ) FR…
17828     lappend myres [format %.4f [set r]]
17832   foreach r [set myres] r2 [set res2] {
17833     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
17834       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19884 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND 2 FOLL…
19885     lappend myres [format %.4f [set r]]
19889   foreach r [set myres] r2 [set res2] {
19890     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19891       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19901 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
19902     lappend myres [format %.4f [set r]]
19906   foreach r [set myres] r2 [set res2] {
19907     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19908       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19918 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND 2 FOLL…
19919     lappend myres [format %.4f [set r]]
19923   foreach r [set myres] r2 [set res2] {
19924     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19925       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19935 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
19936     lappend myres [format %.4f [set r]]
19940   foreach r [set myres] r2 [set res2] {
19941     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19942       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19952 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND 2 F…
19953     lappend myres [format %.4f [set r]]
19957   foreach r [set myres] r2 [set res2] {
19958     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19959       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19969 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
19970     lappend myres [format %.4f [set r]]
19974   foreach r [set myres] r2 [set res2] {
19975     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19976       error "list element [set i] does not match: got=[set r] expected=[set r2]"
19986 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND 2 FOLLOWI…
19987     lappend myres [format %.4f [set r]]
19991   foreach r [set myres] r2 [set res2] {
19992     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
19993       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20003 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
20004     lappend myres [format %.4f [set r]]
20008   foreach r [set myres] r2 [set res2] {
20009     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20010       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20020 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND 2 FOLLOWI…
20021     lappend myres [format %.4f [set r]]
20025   foreach r [set myres] r2 [set res2] {
20026     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20027       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20037 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
20038     lappend myres [format %.4f [set r]]
20042   foreach r [set myres] r2 [set res2] {
20043     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20044       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20054 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND 2 FOLL…
20055     lappend myres [format %.4f [set r]]
20059   foreach r [set myres] r2 [set res2] {
20060     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20061       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20071 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
20072     lappend myres [format %.4f [set r]]
20076   foreach r [set myres] r2 [set res2] {
20077     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20078       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20088 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND 2 FOLLOWIN…
20089     lappend myres [format %.4f [set r]]
20093   foreach r [set myres] r2 [set res2] {
20094     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20095       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20105 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
20106     lappend myres [format %.4f [set r]]
20110   foreach r [set myres] r2 [set res2] {
20111     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20112       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20122 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND 2 FOLLOW…
20123     lappend myres [format %.4f [set r]]
20127   foreach r [set myres] r2 [set res2] {
20128     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20129       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20139 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
20140     lappend myres [format %.4f [set r]]
20144   foreach r [set myres] r2 [set res2] {
20145     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20146       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20156 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND 2 FOL…
20157     lappend myres [format %.4f [set r]]
20161   foreach r [set myres] r2 [set res2] {
20162     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20163       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20173 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
20174     lappend myres [format %.4f [set r]]
20178   foreach r [set myres] r2 [set res2] {
20179     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20180       error "list element [set i] does not match: got=[set r] expected=[set r2]"
20190 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND 2 FOLLOWING ) FROM t2…
20191     lappend myres [format %.4f [set r]]
20195   foreach r [set myres] r2 [set res2] {
20196     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
20197       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21526 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND 4…
21527     lappend myres [format %.4f [set r]]
21531   foreach r [set myres] r2 [set res2] {
21532     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21533       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21543 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT…
21544     lappend myres [format %.4f [set r]]
21548   foreach r [set myres] r2 [set res2] {
21549     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21550       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21560 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN CURRENT ROW         AND 4…
21561     lappend myres [format %.4f [set r]]
21565   foreach r [set myres] r2 [set res2] {
21566     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21567       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21577 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN CURRENT…
21578     lappend myres [format %.4f [set r]]
21582   foreach r [set myres] r2 [set res2] {
21583     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21584       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21594 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN CURRENT ROW         AN…
21595     lappend myres [format %.4f [set r]]
21599   foreach r [set myres] r2 [set res2] {
21600     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21601       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21611 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN CURREN…
21612     lappend myres [format %.4f [set r]]
21616   foreach r [set myres] r2 [set res2] {
21617     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21618       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21628 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND 4 FO…
21629     lappend myres [format %.4f [set r]]
21633   foreach r [set myres] r2 [set res2] {
21634     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21635       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21645 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT RO…
21646     lappend myres [format %.4f [set r]]
21650   foreach r [set myres] r2 [set res2] {
21651     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21652       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21662 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN CURRENT ROW         AND 4 FO…
21663     lappend myres [format %.4f [set r]]
21667   foreach r [set myres] r2 [set res2] {
21668     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21669       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21679 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN CURRENT RO…
21680     lappend myres [format %.4f [set r]]
21684   foreach r [set myres] r2 [set res2] {
21685     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21686       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21696 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN CURRENT ROW         AND 4…
21697     lappend myres [format %.4f [set r]]
21701   foreach r [set myres] r2 [set res2] {
21702     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21703       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21713 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN CURRENT …
21714     lappend myres [format %.4f [set r]]
21718   foreach r [set myres] r2 [set res2] {
21719     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21720       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21730 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND 4 FOL…
21731     lappend myres [format %.4f [set r]]
21735   foreach r [set myres] r2 [set res2] {
21736     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21737       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21747 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT ROW…
21748     lappend myres [format %.4f [set r]]
21752   foreach r [set myres] r2 [set res2] {
21753     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21754       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21764 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN CURRENT ROW         AND 4 F…
21765     lappend myres [format %.4f [set r]]
21769   foreach r [set myres] r2 [set res2] {
21770     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21771       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21781 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN CURRENT R…
21782     lappend myres [format %.4f [set r]]
21786   foreach r [set myres] r2 [set res2] {
21787     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21788       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21798 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN CURRENT ROW         AND …
21799     lappend myres [format %.4f [set r]]
21803   foreach r [set myres] r2 [set res2] {
21804     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21805       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21815 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN CURRENT …
21816     lappend myres [format %.4f [set r]]
21820   foreach r [set myres] r2 [set res2] {
21821     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21822       error "list element [set i] does not match: got=[set r] expected=[set r2]"
21832 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN CURRENT ROW         AND 4 FOLLOWING ) FR…
21833     lappend myres [format %.4f [set r]]
21837   foreach r [set myres] r2 [set res2] {
21838     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
21839       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23075 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 2 FOLLOWING    AND 4 FOLL…
23076     lappend myres [format %.4f [set r]]
23080   foreach r [set myres] r2 [set res2] {
23081     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23082       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23092 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 2 FOLLO…
23093     lappend myres [format %.4f [set r]]
23097   foreach r [set myres] r2 [set res2] {
23098     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23099       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23109 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 2 FOLLOWING    AND 4 FOLL…
23110     lappend myres [format %.4f [set r]]
23114   foreach r [set myres] r2 [set res2] {
23115     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23116       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23126 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 2 FOLLO…
23127     lappend myres [format %.4f [set r]]
23131   foreach r [set myres] r2 [set res2] {
23132     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23133       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23143 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 2 FOLLOWING    AND 4 F…
23144     lappend myres [format %.4f [set r]]
23148   foreach r [set myres] r2 [set res2] {
23149     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23150       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23160 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 2 FOLL…
23161     lappend myres [format %.4f [set r]]
23165   foreach r [set myres] r2 [set res2] {
23166     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23167       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23177 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 2 FOLLOWING    AND 4 FOLLOWI…
23178     lappend myres [format %.4f [set r]]
23182   foreach r [set myres] r2 [set res2] {
23183     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23184       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23194 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 2 FOLLOWIN…
23195     lappend myres [format %.4f [set r]]
23199   foreach r [set myres] r2 [set res2] {
23200     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23201       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23211 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 2 FOLLOWING    AND 4 FOLLOWI…
23212     lappend myres [format %.4f [set r]]
23216   foreach r [set myres] r2 [set res2] {
23217     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23218       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23228 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 2 FOLLOWIN…
23229     lappend myres [format %.4f [set r]]
23233   foreach r [set myres] r2 [set res2] {
23234     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23235       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23245 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 2 FOLLOWING    AND 4 FOLL…
23246     lappend myres [format %.4f [set r]]
23250   foreach r [set myres] r2 [set res2] {
23251     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23252       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23262 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 2 FOLLOW…
23263     lappend myres [format %.4f [set r]]
23267   foreach r [set myres] r2 [set res2] {
23268     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23269       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23279 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 2 FOLLOWING    AND 4 FOLLOWIN…
23280     lappend myres [format %.4f [set r]]
23284   foreach r [set myres] r2 [set res2] {
23285     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23286       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23296 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 2 FOLLOWING…
23297     lappend myres [format %.4f [set r]]
23301   foreach r [set myres] r2 [set res2] {
23302     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23303       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23313 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 2 FOLLOWING    AND 4 FOLLOW…
23314     lappend myres [format %.4f [set r]]
23318   foreach r [set myres] r2 [set res2] {
23319     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23320       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23330 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 2 FOLLOWI…
23331     lappend myres [format %.4f [set r]]
23335   foreach r [set myres] r2 [set res2] {
23336     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23337       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23347 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 2 FOLLOWING    AND 4 FOL…
23348     lappend myres [format %.4f [set r]]
23352   foreach r [set myres] r2 [set res2] {
23353     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23354       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23364 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 2 FOLLOW…
23365     lappend myres [format %.4f [set r]]
23369   foreach r [set myres] r2 [set res2] {
23370     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23371       error "list element [set i] does not match: got=[set r] expected=[set r2]"
23381 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 2 FOLLOWING    AND 4 FOLLOWING ) FROM t2…
23382     lappend myres [format %.4f [set r]]
23386   foreach r [set myres] r2 [set res2] {
23387     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
23388       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24510 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND U…
24511     lappend myres [format %.4f [set r]]
24515   foreach r [set myres] r2 [set res2] {
24516     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24517       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24527 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUND…
24528     lappend myres [format %.4f [set r]]
24532   foreach r [set myres] r2 [set res2] {
24533     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24534       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24544 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND U…
24545     lappend myres [format %.4f [set r]]
24549   foreach r [set myres] r2 [set res2] {
24550     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24551       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24561 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUND…
24562     lappend myres [format %.4f [set r]]
24566   foreach r [set myres] r2 [set res2] {
24567     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24568       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24578 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AN…
24579     lappend myres [format %.4f [set r]]
24583   foreach r [set myres] r2 [set res2] {
24584     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24585       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24595 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUN…
24596     lappend myres [format %.4f [set r]]
24600   foreach r [set myres] r2 [set res2] {
24601     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24602       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24612 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND UNBO…
24613     lappend myres [format %.4f [set r]]
24617   foreach r [set myres] r2 [set res2] {
24618     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24619       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24629 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED …
24630     lappend myres [format %.4f [set r]]
24634   foreach r [set myres] r2 [set res2] {
24635     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24636       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24646 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND UNBO…
24647     lappend myres [format %.4f [set r]]
24651   foreach r [set myres] r2 [set res2] {
24652     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24653       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24663 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN UNBOUNDED …
24664     lappend myres [format %.4f [set r]]
24668   foreach r [set myres] r2 [set res2] {
24669     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24670       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24680 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN UNBOUNDED PRECEDING AND U…
24681     lappend myres [format %.4f [set r]]
24685   foreach r [set myres] r2 [set res2] {
24686     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24687       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24697 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
24698     lappend myres [format %.4f [set r]]
24702   foreach r [set myres] r2 [set res2] {
24703     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24704       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24714 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOU…
24715     lappend myres [format %.4f [set r]]
24719   foreach r [set myres] r2 [set res2] {
24720     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24721       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24731 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN UNBOUNDED P…
24732     lappend myres [format %.4f [set r]]
24736   foreach r [set myres] r2 [set res2] {
24737     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24738       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24748 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN UNBOUNDED PRECEDING AND UNB…
24749     lappend myres [format %.4f [set r]]
24753   foreach r [set myres] r2 [set res2] {
24754     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24755       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24765 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN UNBOUNDED…
24766     lappend myres [format %.4f [set r]]
24770   foreach r [set myres] r2 [set res2] {
24771     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24772       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24782 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN UNBOUNDED PRECEDING AND …
24783     lappend myres [format %.4f [set r]]
24787   foreach r [set myres] r2 [set res2] {
24788     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24789       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24799 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN UNBOUNDE…
24800     lappend myres [format %.4f [set r]]
24804   foreach r [set myres] r2 [set res2] {
24805     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24806       error "list element [set i] does not match: got=[set r] expected=[set r2]"
24816 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOW…
24817     lappend myres [format %.4f [set r]]
24821   foreach r [set myres] r2 [set res2] {
24822     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
24823       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27028 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
27029     lappend myres [format %.4f [set r]]
27033   foreach r [set myres] r2 [set res2] {
27034     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27035       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27045 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
27046     lappend myres [format %.4f [set r]]
27050   foreach r [set myres] r2 [set res2] {
27051     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27052       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27062 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
27063     lappend myres [format %.4f [set r]]
27067   foreach r [set myres] r2 [set res2] {
27068     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27069       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27079 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
27080     lappend myres [format %.4f [set r]]
27084   foreach r [set myres] r2 [set res2] {
27085     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27086       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27096 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNB…
27097     lappend myres [format %.4f [set r]]
27101   foreach r [set myres] r2 [set res2] {
27102     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27103       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27113 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
27114     lappend myres [format %.4f [set r]]
27118   foreach r [set myres] r2 [set res2] {
27119     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27120       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27130 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
27131     lappend myres [format %.4f [set r]]
27135   foreach r [set myres] r2 [set res2] {
27136     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27137       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27147 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
27148     lappend myres [format %.4f [set r]]
27152   foreach r [set myres] r2 [set res2] {
27153     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27154       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27164 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
27165     lappend myres [format %.4f [set r]]
27169   foreach r [set myres] r2 [set res2] {
27170     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27171       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27181 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
27182     lappend myres [format %.4f [set r]]
27186   foreach r [set myres] r2 [set res2] {
27187     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27188       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27198 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
27199     lappend myres [format %.4f [set r]]
27203   foreach r [set myres] r2 [set res2] {
27204     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27205       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27215 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
27216     lappend myres [format %.4f [set r]]
27220   foreach r [set myres] r2 [set res2] {
27221     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27222       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27232 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED …
27233     lappend myres [format %.4f [set r]]
27237   foreach r [set myres] r2 [set res2] {
27238     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27239       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27249 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
27250     lappend myres [format %.4f [set r]]
27254   foreach r [set myres] r2 [set res2] {
27255     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27256       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27266 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDE…
27267     lappend myres [format %.4f [set r]]
27271   foreach r [set myres] r2 [set res2] {
27272     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27273       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27283 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
27284     lappend myres [format %.4f [set r]]
27288   foreach r [set myres] r2 [set res2] {
27289     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27290       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27300 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND UNBOU…
27301     lappend myres [format %.4f [set r]]
27305   foreach r [set myres] r2 [set res2] {
27306     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27307       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27317 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
27318     lappend myres [format %.4f [set r]]
27322   foreach r [set myres] r2 [set res2] {
27323     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27324       error "list element [set i] does not match: got=[set r] expected=[set r2]"
27334 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED FOLLOWING )…
27335     lappend myres [format %.4f [set r]]
27339   foreach r [set myres] r2 [set res2] {
27340     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
27341       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29405 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND U…
29406     lappend myres [format %.4f [set r]]
29410   foreach r [set myres] r2 [set res2] {
29411     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29412       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29422 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT…
29423     lappend myres [format %.4f [set r]]
29427   foreach r [set myres] r2 [set res2] {
29428     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29429       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29439 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN CURRENT ROW         AND U…
29440     lappend myres [format %.4f [set r]]
29444   foreach r [set myres] r2 [set res2] {
29445     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29446       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29456 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN CURRENT…
29457     lappend myres [format %.4f [set r]]
29461   foreach r [set myres] r2 [set res2] {
29462     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29463       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29473 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN CURRENT ROW         AN…
29474     lappend myres [format %.4f [set r]]
29478   foreach r [set myres] r2 [set res2] {
29479     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29480       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29490 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN CURREN…
29491     lappend myres [format %.4f [set r]]
29495   foreach r [set myres] r2 [set res2] {
29496     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29497       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29507 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND UNBO…
29508     lappend myres [format %.4f [set r]]
29512   foreach r [set myres] r2 [set res2] {
29513     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29514       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29524 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT RO…
29525     lappend myres [format %.4f [set r]]
29529   foreach r [set myres] r2 [set res2] {
29530     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29531       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29541 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN CURRENT ROW         AND UNBO…
29542     lappend myres [format %.4f [set r]]
29546   foreach r [set myres] r2 [set res2] {
29547     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29548       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29558 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN CURRENT RO…
29559     lappend myres [format %.4f [set r]]
29563   foreach r [set myres] r2 [set res2] {
29564     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29565       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29575 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN CURRENT ROW         AND U…
29576     lappend myres [format %.4f [set r]]
29580   foreach r [set myres] r2 [set res2] {
29581     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29582       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29592 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN CURRENT …
29593     lappend myres [format %.4f [set r]]
29597   foreach r [set myres] r2 [set res2] {
29598     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29599       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29609 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN CURRENT ROW         AND UNBOU…
29610     lappend myres [format %.4f [set r]]
29614   foreach r [set myres] r2 [set res2] {
29615     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29616       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29626 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN CURRENT ROW…
29627     lappend myres [format %.4f [set r]]
29631   foreach r [set myres] r2 [set res2] {
29632     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29633       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29643 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN CURRENT ROW         AND UNB…
29644     lappend myres [format %.4f [set r]]
29648   foreach r [set myres] r2 [set res2] {
29649     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29650       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29660 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN CURRENT R…
29661     lappend myres [format %.4f [set r]]
29665   foreach r [set myres] r2 [set res2] {
29666     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29667       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29677 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN CURRENT ROW         AND …
29678     lappend myres [format %.4f [set r]]
29682   foreach r [set myres] r2 [set res2] {
29683     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29684       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29694 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN CURRENT …
29695     lappend myres [format %.4f [set r]]
29699   foreach r [set myres] r2 [set res2] {
29700     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29701       error "list element [set i] does not match: got=[set r] expected=[set r2]"
29711 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN CURRENT ROW         AND UNBOUNDED FOLLOW…
29712     lappend myres [format %.4f [set r]]
29716   foreach r [set myres] r2 [set res2] {
29717     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
29718       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31676 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 FOLLOWING    AND UNBOUN…
31677     lappend myres [format %.4f [set r]]
31681   foreach r [set myres] r2 [set res2] {
31682     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31683       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31693 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 FOLLO…
31694     lappend myres [format %.4f [set r]]
31698   foreach r [set myres] r2 [set res2] {
31699     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31700       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31710 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 FOLLOWING    AND UNBOUN…
31711     lappend myres [format %.4f [set r]]
31715   foreach r [set myres] r2 [set res2] {
31716     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31717       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31727 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 FOLLO…
31728     lappend myres [format %.4f [set r]]
31732   foreach r [set myres] r2 [set res2] {
31733     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31734       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31744 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 FOLLOWING    AND UNB…
31745     lappend myres [format %.4f [set r]]
31749   foreach r [set myres] r2 [set res2] {
31750     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31751       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31761 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 FOLL…
31762     lappend myres [format %.4f [set r]]
31766   foreach r [set myres] r2 [set res2] {
31767     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31768       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31778 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 FOLLOWING    AND UNBOUNDED…
31779     lappend myres [format %.4f [set r]]
31783   foreach r [set myres] r2 [set res2] {
31784     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31785       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31795 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 FOLLOWIN…
31796     lappend myres [format %.4f [set r]]
31800   foreach r [set myres] r2 [set res2] {
31801     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31802       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31812 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 FOLLOWING    AND UNBOUNDED…
31813     lappend myres [format %.4f [set r]]
31817   foreach r [set myres] r2 [set res2] {
31818     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31819       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31829 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 FOLLOWIN…
31830     lappend myres [format %.4f [set r]]
31834   foreach r [set myres] r2 [set res2] {
31835     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31836       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31846 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 FOLLOWING    AND UNBOUN…
31847     lappend myres [format %.4f [set r]]
31851   foreach r [set myres] r2 [set res2] {
31852     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31853       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31863 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 FOLLOW…
31864     lappend myres [format %.4f [set r]]
31868   foreach r [set myres] r2 [set res2] {
31869     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31870       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31880 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 FOLLOWING    AND UNBOUNDED …
31881     lappend myres [format %.4f [set r]]
31885   foreach r [set myres] r2 [set res2] {
31886     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31887       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31897 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 FOLLOWING…
31898     lappend myres [format %.4f [set r]]
31902   foreach r [set myres] r2 [set res2] {
31903     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31904       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31914 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 FOLLOWING    AND UNBOUNDE…
31915     lappend myres [format %.4f [set r]]
31919   foreach r [set myres] r2 [set res2] {
31920     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31921       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31931 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 FOLLOWI…
31932     lappend myres [format %.4f [set r]]
31936   foreach r [set myres] r2 [set res2] {
31937     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31938       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31948 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 FOLLOWING    AND UNBOU…
31949     lappend myres [format %.4f [set r]]
31953   foreach r [set myres] r2 [set res2] {
31954     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31955       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31965 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 FOLLOW…
31966     lappend myres [format %.4f [set r]]
31970   foreach r [set myres] r2 [set res2] {
31971     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31972       error "list element [set i] does not match: got=[set r] expected=[set r2]"
31982 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 FOLLOWING    AND UNBOUNDED FOLLOWING )…
31983     lappend myres [format %.4f [set r]]
31987   foreach r [set myres] r2 [set res2] {
31988     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
31989       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33835 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
33836     lappend myres [format %.4f [set r]]
33840   foreach r [set myres] r2 [set res2] {
33841     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33842       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33852 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
33853     lappend myres [format %.4f [set r]]
33857   foreach r [set myres] r2 [set res2] {
33858     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33859       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33869 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
33870     lappend myres [format %.4f [set r]]
33874   foreach r [set myres] r2 [set res2] {
33875     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33876       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33886 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
33887     lappend myres [format %.4f [set r]]
33891   foreach r [set myres] r2 [set res2] {
33892     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33893       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33903 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNB…
33904     lappend myres [format %.4f [set r]]
33908   foreach r [set myres] r2 [set res2] {
33909     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33910       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33920 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
33921     lappend myres [format %.4f [set r]]
33925   foreach r [set myres] r2 [set res2] {
33926     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33927       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33937 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
33938     lappend myres [format %.4f [set r]]
33942   foreach r [set myres] r2 [set res2] {
33943     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33944       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33954 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
33955     lappend myres [format %.4f [set r]]
33959   foreach r [set myres] r2 [set res2] {
33960     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33961       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33971 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
33972     lappend myres [format %.4f [set r]]
33976   foreach r [set myres] r2 [set res2] {
33977     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33978       error "list element [set i] does not match: got=[set r] expected=[set r2]"
33988 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
33989     lappend myres [format %.4f [set r]]
33993   foreach r [set myres] r2 [set res2] {
33994     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
33995       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34005 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
34006     lappend myres [format %.4f [set r]]
34010   foreach r [set myres] r2 [set res2] {
34011     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34012       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34022 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
34023     lappend myres [format %.4f [set r]]
34027   foreach r [set myres] r2 [set res2] {
34028     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34029       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34039 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED …
34040     lappend myres [format %.4f [set r]]
34044   foreach r [set myres] r2 [set res2] {
34045     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34046       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34056 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
34057     lappend myres [format %.4f [set r]]
34061   foreach r [set myres] r2 [set res2] {
34062     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34063       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34073 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDE…
34074     lappend myres [format %.4f [set r]]
34078   foreach r [set myres] r2 [set res2] {
34079     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34080       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34090 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
34091     lappend myres [format %.4f [set r]]
34095   foreach r [set myres] r2 [set res2] {
34096     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34097       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34107 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND UNBOU…
34108     lappend myres [format %.4f [set r]]
34112   foreach r [set myres] r2 [set res2] {
34113     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34114       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34124 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
34125     lappend myres [format %.4f [set r]]
34129   foreach r [set myres] r2 [set res2] {
34130     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34131       error "list element [set i] does not match: got=[set r] expected=[set r2]"
34141 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED FOLLOWING E…
34142     lappend myres [format %.4f [set r]]
34146   foreach r [set myres] r2 [set res2] {
34147     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
34148       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36187 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
36188     lappend myres [format %.4f [set r]]
36192   foreach r [set myres] r2 [set res2] {
36193     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36194       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36204 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
36205     lappend myres [format %.4f [set r]]
36209   foreach r [set myres] r2 [set res2] {
36210     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36211       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36221 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
36222     lappend myres [format %.4f [set r]]
36226   foreach r [set myres] r2 [set res2] {
36227     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36228       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36238 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
36239     lappend myres [format %.4f [set r]]
36243   foreach r [set myres] r2 [set res2] {
36244     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36245       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36255 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNB…
36256     lappend myres [format %.4f [set r]]
36260   foreach r [set myres] r2 [set res2] {
36261     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36262       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36272 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
36273     lappend myres [format %.4f [set r]]
36277   foreach r [set myres] r2 [set res2] {
36278     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36279       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36289 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
36290     lappend myres [format %.4f [set r]]
36294   foreach r [set myres] r2 [set res2] {
36295     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36296       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36306 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
36307     lappend myres [format %.4f [set r]]
36311   foreach r [set myres] r2 [set res2] {
36312     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36313       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36323 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
36324     lappend myres [format %.4f [set r]]
36328   foreach r [set myres] r2 [set res2] {
36329     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36330       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36340 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
36341     lappend myres [format %.4f [set r]]
36345   foreach r [set myres] r2 [set res2] {
36346     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36347       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36357 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
36358     lappend myres [format %.4f [set r]]
36362   foreach r [set myres] r2 [set res2] {
36363     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36364       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36374 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
36375     lappend myres [format %.4f [set r]]
36379   foreach r [set myres] r2 [set res2] {
36380     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36381       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36391 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED …
36392     lappend myres [format %.4f [set r]]
36396   foreach r [set myres] r2 [set res2] {
36397     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36398       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36408 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
36409     lappend myres [format %.4f [set r]]
36413   foreach r [set myres] r2 [set res2] {
36414     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36415       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36425 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDE…
36426     lappend myres [format %.4f [set r]]
36430   foreach r [set myres] r2 [set res2] {
36431     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36432       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36442 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
36443     lappend myres [format %.4f [set r]]
36447   foreach r [set myres] r2 [set res2] {
36448     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36449       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36459 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND UNBOU…
36460     lappend myres [format %.4f [set r]]
36464   foreach r [set myres] r2 [set res2] {
36465     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36466       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36476 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
36477     lappend myres [format %.4f [set r]]
36481   foreach r [set myres] r2 [set res2] {
36482     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36483       error "list element [set i] does not match: got=[set r] expected=[set r2]"
36493 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED FOLLOWING E…
36494     lappend myres [format %.4f [set r]]
36498   foreach r [set myres] r2 [set res2] {
36499     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
36500       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38564 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
38565     lappend myres [format %.4f [set r]]
38569   foreach r [set myres] r2 [set res2] {
38570     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38571       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38581 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECE…
38582     lappend myres [format %.4f [set r]]
38586   foreach r [set myres] r2 [set res2] {
38587     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38588       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38598 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
38599     lappend myres [format %.4f [set r]]
38603   foreach r [set myres] r2 [set res2] {
38604     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38605       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38615 …foreach r [db eval {SELECT percent_rank() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECE…
38616     lappend myres [format %.4f [set r]]
38620   foreach r [set myres] r2 [set res2] {
38621     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38622       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38632 …foreach r [db eval {SELECT percent_rank() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNB…
38633     lappend myres [format %.4f [set r]]
38637   foreach r [set myres] r2 [set res2] {
38638     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38639       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38649 …foreach r [db eval {SELECT percent_rank() OVER (PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PREC…
38650     lappend myres [format %.4f [set r]]
38654   foreach r [set myres] r2 [set res2] {
38655     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38656       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38666 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
38667     lappend myres [format %.4f [set r]]
38671   foreach r [set myres] r2 [set res2] {
38672     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38673       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38683 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDIN…
38684     lappend myres [format %.4f [set r]]
38688   foreach r [set myres] r2 [set res2] {
38689     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38690       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38700 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED…
38701     lappend myres [format %.4f [set r]]
38705   foreach r [set myres] r2 [set res2] {
38706     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38707       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38717 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%10 ORDER BY b ROWS BETWEEN 4 PRECEDIN…
38718     lappend myres [format %.4f [set r]]
38722   foreach r [set myres] r2 [set res2] {
38723     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38724       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38734 …foreach r [db eval {SELECT cume_dist() OVER ( ORDER BY b%10 ROWS BETWEEN 4 PRECEDING    AND UNBOUN…
38735     lappend myres [format %.4f [set r]]
38739   foreach r [set myres] r2 [set res2] {
38740     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38741       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38751 …foreach r [db eval {SELECT cume_dist() OVER ( PARTITION BY b%2 ORDER BY b%10 ROWS BETWEEN 4 PRECED…
38752     lappend myres [format %.4f [set r]]
38756   foreach r [set myres] r2 [set res2] {
38757     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38758       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38768 …foreach r [db eval {SELECT ntile(100) OVER ( ORDER BY a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED …
38769     lappend myres [format %.4f [set r]]
38773   foreach r [set myres] r2 [set res2] {
38774     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38775       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38785 …foreach r [db eval {SELECT ntile(101) OVER ( PARTITION BY b%10 ORDER BY a ROWS BETWEEN 4 PRECEDING…
38786     lappend myres [format %.4f [set r]]
38790   foreach r [set myres] r2 [set res2] {
38791     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38792       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38802 …foreach r [db eval {SELECT ntile(102) OVER ( ORDER BY b,a ROWS BETWEEN 4 PRECEDING    AND UNBOUNDE…
38803     lappend myres [format %.4f [set r]]
38807   foreach r [set myres] r2 [set res2] {
38808     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38809       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38819 …foreach r [db eval {SELECT ntile(103) OVER ( PARTITION BY b%10 ORDER BY b,a ROWS BETWEEN 4 PRECEDI…
38820     lappend myres [format %.4f [set r]]
38824   foreach r [set myres] r2 [set res2] {
38825     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38826       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38836 …foreach r [db eval {SELECT ntile(104) OVER ( ORDER BY b%10,a ROWS BETWEEN 4 PRECEDING    AND UNBOU…
38837     lappend myres [format %.4f [set r]]
38841   foreach r [set myres] r2 [set res2] {
38842     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38843       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38853 …foreach r [db eval {SELECT ntile(105) OVER (PARTITION BY b%2,a ORDER BY b%10 ROWS BETWEEN 4 PRECED…
38854     lappend myres [format %.4f [set r]]
38858   foreach r [set myres] r2 [set res2] {
38859     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38860       error "list element [set i] does not match: got=[set r] expected=[set r2]"
38870 …foreach r [db eval {SELECT ntile(105) OVER ( ROWS BETWEEN 4 PRECEDING    AND UNBOUNDED FOLLOWING E…
38871     lappend myres [format %.4f [set r]]
38875   foreach r [set myres] r2 [set res2] {
38876     if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
38877       error "list element [set i] does not match: got=[set r] expected=[set r2]"