0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (66 rows)
2. FRESH FAILS: tests which failed for LAST execution only (0 rows)
3. FRESH ERRORS: tests which raised run-time error for LAST execution only (0 rows)
4. STILL FAILS: tests which fail for at least two last runs (0 rows)
5. Has fails: tests with at least one fail for previous runs (80 rows)
[CURRENT] 6. Has runtime errors: tests with at least one runtime error for previous runs (29 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (2330 rows)
9. All tests: durations (4542 rows)
A. Skipped: tests which was intentionally excluded from execution (4 rows)

Generated 11.01.2022 19:20
Tested: FB40.   Build: 4.0.1.2704;   SS: 11.01.22 14:43:03 - 11.01.22 17:05:38;   CS: 11.01.22 17:09:35 - 11.01.22 19:15:49;
OS and hardware info:  Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 Gb 

Test with at least one result = "ERROR" for last 30 runs:
NN Test name mode 4.0.1.2704
2022-01-11
4.0.1.2701
2022-01-04
4.0.1.2700
2022-01-02
4.0.1.2699
2022-01-01
4.0.1.2697
2021-12-29
4.0.1.2696
2021-12-23
4.0.1.2694
2021-12-22
4.0.1.2693
2021-12-21
4.0.1.2692
2021-12-20
4.0.1.2691
2021-12-17
4.0.1.2690
2021-12-16
4.0.1.2689
2021-12-15
4.0.1.2687
2021-12-14
4.0.1.2685
2021-12-13
4.0.1.2682
2021-12-12
4.0.1.2680
2021-12-10
4.0.1.2676
2021-12-07
4.0.1.2675
2021-12-04
4.0.1.2673
2021-12-02
4.0.1.2672
2021-12-01
4.0.1.2669
2021-11-26
4.0.1.2668
2021-11-23
4.0.1.2667
2021-11-17
4.0.1.2666
2021-11-16
4.0.1.2660
2021-11-15
4.0.1.2658
2021-11-12
4.0.1.2656
2021-11-11
4.0.1.2653
2021-11-08
4.0.1.2650
2021-11-06
4.0.1.2649
2021-10-31
Test TITLE
1 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
2 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
3 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
4 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
5 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
6 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
7 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
8 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
9 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Can't select from table with ICU column when database (.FDB) is created on LINUX with icu 4.2.1 and then copied to WINDOWS
10 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Can't select from table with ICU column when database (.FDB) is created on LINUX with icu 4.2.1 and then copied to WINDOWS
11 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
12 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
13 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
14 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
15 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Bugcheck 167 (invalid SEND request)
16 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Bugcheck 167 (invalid SEND request)
17 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
18 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
19 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
20 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
21 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Unique constraint not working in encrypted database on first command
22 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Unique constraint not working in encrypted database on first command
23 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Regression: can not get statistics for selected table(s) via services, get "found unknown switch" error
24 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
Regression: can not get statistics for selected table(s) via services, get "found unknown switch" error
25 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
ORDER BY ASC using index (multi)
26 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
ORDER BY ASC using index (multi)
27 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
ORDER BY ASC using index (multi)
28 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
ORDER BY ASC using index (multi)
29 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E     P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.

Elapsed time, milliseconds:
NN Test name mode median_ms 4.0.1.2704
2022-01-11
4.0.1.2701
2022-01-04
4.0.1.2700
2022-01-02
4.0.1.2699
2022-01-01
4.0.1.2697
2021-12-29
4.0.1.2696
2021-12-23
4.0.1.2694
2021-12-22
4.0.1.2693
2021-12-21
4.0.1.2692
2021-12-20
4.0.1.2691
2021-12-17
4.0.1.2690
2021-12-16
4.0.1.2689
2021-12-15
4.0.1.2687
2021-12-14
4.0.1.2685
2021-12-13
4.0.1.2682
2021-12-12
4.0.1.2680
2021-12-10
4.0.1.2676
2021-12-07
4.0.1.2675
2021-12-04
4.0.1.2673
2021-12-02
4.0.1.2672
2021-12-01
4.0.1.2669
2021-11-26
4.0.1.2668
2021-11-23
4.0.1.2667
2021-11-17
4.0.1.2666
2021-11-16
4.0.1.2660
2021-11-15
4.0.1.2658
2021-11-12
4.0.1.2656
2021-11-11
4.0.1.2653
2021-11-08
4.0.1.2650
2021-11-06
4.0.1.2649
2021-10-31
Test TITLE
1 CS 2185 2080 2330 2820 2200 2170 2180 2270 2310 2200 2200 2240 2170 2000 2200 2290 2200 2220 2070 2070 2020 2020 1160 2030 2190 2050 2090 2040 2200 2850 2180
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
2 SS 2530 2530 2480 2000 2000 2000 2530 2540 2520 2520 2530 2510 2520 2540 2510 2480 2560 2560 2540 2560 2540 2000 1420 2520 2540 2530 2480 2530 2550 2860 2530
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
3 CS 2085 1840 2150 2060 2090 2140 2080 2070 2090 2150 2120 2130 2240 2070 2100 2120 2090 2090 1870 1900 1920 1890 1030 1890 1920 1940 1870 1880 2120 3560 2170
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
4 SS 2390 2390 2410 2360 2350 2380 2370 2420 2420 2390 2450 2410 2370 2440 2370 2370 2380 2530 2380 2380 2410 2430 1300 2440 2370 2420 2390 2410 2370 2830 2350
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
5 CS 4180 4000 4000 4400 4280 4290 4210 4140 4290 4240 4200 4330 4000 4130 4180 4370 4180 4130 4090 4230 4370 4100 3270 4150 4040 4000 4840 4000 4300 2530 4330
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
6 SS 4090 4100 4120 4040 4040 4060 4090 4090 4140 4130 4120 4160 4070 4110 4090 4130 4000 4070 4020 4210 4060 4120 2930 4110 4060 4150 4030 4050 4110 2760 4140
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
7 CS 2090 1950 2140 2100 2080 2140 2090 2100 2100 2140 2090 2150 2130 2100 2090 2100 2120 2090 1930 1950 1920 1940 1060 1900 1920 1910 1860 1920 2110 2400 2150
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
8 SS 2435 2840 2480 2450 2400 2400 2400 2430 2460 2450 2430 2410 2430 2430 2440 2450 2470 2550 2450 2450 2420 2430 1290 2450 2460 2430 2420 2400 2440 3170 2420
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
9 CS 4890 4650 4810 4880 4900 5380 5060 4940 5100 4930 4910 4930 5080 4810 4780 4810 4930 4370 4680 4900 4670 4630 2460 4760 5440 5580 4620 4620 4960 3260 4940
Can't select from table with ICU column when database (.FDB) is created on LINUX with icu 4.2.1 and then copied to WINDOWS
10 SS 4630 4650 4670 4000 4580 4580 4540 5240 4620 4640 4650 4670 4680 4550 4520 4580 4680 4680 4830 4730 4720 4620 2810 4690 4780 4680 4530 4610 4560 3040 4530
Can't select from table with ICU column when database (.FDB) is created on LINUX with icu 4.2.1 and then copied to WINDOWS
11 CS 2830 2640 2930 2000 2810 2830 2000 2900 2860 2890 2830 2920 2830 2840 2800 2700 2830 2880 2700 2890 2550 2590 1450 2770 2650 2580 3120 2590 2840 3080 2880
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
12 SS 3200 3390 3340 3210 3180 3000 3210 3140 3160 3140 3200 3210 3180 3170 3170 3210 3200 3170 3000 3210 3150 3000 1810 3230 3240 3210 3200 3260 3200 3480 3180
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
13 CS 8640 8650 8760 8630 8640 8610 8710 8000 8920 8660 8710 8950 8580 8640 8770 8830 8580 8830 8690 8620 8640 8620 7010 8520 8580 8560 8550 8450 8790 2670 8800
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
14 SS 8340 8240 8310 8330 8290 8270 8290 8360 8350 8360 8360 8310 8340 8330 8360 8340 8780 8350 8340 8360 8360 8390 6770 8370 8720 8330 8000 8370 8330 2820 8360
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
15 CS 4960 4940 5120 5030 5020 4970 4960 4950 4930 4940 4960 4960 5870 4970 5070 5040 4980 4980 5110 4850 4780 4740 3350 4820 4790 4840 4830 4000 5050 3480 4990
Bugcheck 167 (invalid SEND request)
16 SS 4670 4730 4660 4710 4620 4600 4710 4710 5140 4670 4650 4730 4640 4660 4680 4630 4720 4640 4740 4680 4660 4680 3430 4670 4660 4670 4660 4670 4710 3340 4670
Bugcheck 167 (invalid SEND request)
17 CS 3310 3040 3440 3350 3260 3450 3370 3300 3310 3370 3430 3400 3380 3370 3380 3340 3260 3460 3120 3090 3030 3340 1450 3100 3210 3030 2990 3210 3310 2270 3400
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
18 SS 3260 3170 3260 3150 3270 3240 3000 3360 3300 3000 3310 3000 3220 3260 3310 3260 3290 3280 3230 3290 3330 3310 1730 3260 3360 3320 3230 3240 3270 2610 3320
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
19 CS 15490 15530 15190 15600 15550 16190 15360 15450 15400 15620 15400 16270 16270 15990 16130 16170 15420 16070 16050 15150 14850 15000 13220 14960 15600 15200 16240 15910 15090 4940 15290
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
20 SS 14850 14880 14610 14900 14660 14610 14600 14850 14640 14710 14850 15280 15350 15400 15210 15290 14640 15430 15420 14680 14400 15090 12580 14900 14640 15710 15400 15120 14440 4370 14380
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
21 CS 4545 4480 4570 4520 4540 4560 4610 4600 4570 4660 4590 4590 4590 4620 4550 4540 4550 4540 4420 4570 4320 4400 3230 4370 4410 4410 4380 4480 4630 3300 4630
Unique constraint not working in encrypted database on first command
22 SS 5005 4980 5070 5040 5000 4910 5100 4960 4990 5020 4920 5010 5010 4980 5020 5020 5100 5020 5030 4990 5000 5100 3540 5100 5010 5100 4920 5000 5000 3870 4990
Unique constraint not working in encrypted database on first command
23 CS 2495 2330 2570 2520 2530 2510 2590 2000 2480 2560 2550 2560 2480 2580 2550 2550 2480 2570 2280 2270 2300 2390 1150 2000 2300 2260 2260 2260 2530 4030 2550
Regression: can not get statistics for selected table(s) via services, get "found unknown switch" error
24 SS 2920 2880 3100 2870 2990 3200 2870 2890 2910 2950 2920 2980 2970 2950 2910 2960 2910 2920 2920 2940 2910 2970 1000 2920 2920 2910 2870 2910 2970 2790 2900
Regression: can not get statistics for selected table(s) via services, get "found unknown switch" error
25 CS 2140 2230 2220 2450 2140 2130 2150 2140 2160 2130 2140 2150 2150 2150 2230 2150 2130 2140 1950 1930 1930 1950 1090 1930 1930 1940 1930 2060 2150 3590 2170
ORDER BY ASC using index (multi)
26 SS 2450 2450 2470 2450 2440 2410 2380 2460 2450 2450 2000 2470 2450 2480 2000 2450 2000 2480 2000 2490 2480 2450 1310 2530 2510 2540 2430 2480 2480 2810 2420
ORDER BY ASC using index (multi)
27 CS 2140 2000 2180 2140 2140 2130 2120 2150 2190 2260 2150 2150 2130 2160 2180 2140 2140 2140 2000 1950 1940 1920 1090 2070 1920 1950 1860 1920 2170 2400 2150
ORDER BY ASC using index (multi)
28 SS 2450 2470 2450 2430 2410 2510 2400 2460 2000 2460 2480 2480 2430 2450 2440 2460 2460 2450 2470 2000 2470 2450 1290 2470 2450 2460 2450 2480 2450 2210 2480
ORDER BY ASC using index (multi)
29 CS 10120 9850 9990 9890 10110 9860 10310 10350 9940 10270 10450 10390 10350 10400 10280 10660 9970 10340 9690 10340 9980 10120 7840 10020 9260 10530 9960 9330 10340 10220 10120
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-3639
http://tracker.firebirdsql.org/browse/core-4142
http://tracker.firebirdsql.org/browse/core-4375
http://tracker.firebirdsql.org/browse/core-4447
http://tracker.firebirdsql.org/browse/core-4571
http://tracker.firebirdsql.org/browse/core-4675
http://tracker.firebirdsql.org/browse/core-5441
http://tracker.firebirdsql.org/browse/core-5457
http://tracker.firebirdsql.org/browse/core-5501
http://tracker.firebirdsql.org/browse/core-5598
http://tracker.firebirdsql.org/browse/core-5673
http://tracker.firebirdsql.org/browse/core-6499
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_sort_by_index_10.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_sort_by_index_13.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-01.fbt

=== end of list ===