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)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (78 rows)
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 (2329 rows)
9. All tests: durations (4542 rows)
A. Skipped: tests which was intentionally excluded from execution (4 rows)

Generated 21.01.2022 10:46
Tested: FB40.   Build: 4.0.1.2707;   SS: 21.01.22 06:03:24 - 21.01.22 08:27:23;   CS: 21.01.22 08:32:43 - 21.01.22 10:40:53;
OS and hardware info:  Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 Gb 

Test with at least one result = "FAIL" for last 30 runs:

Jump to LIST of unique test names from this report

NN Test name mode 4.0.1.2707
2022-01-21
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
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 P     F    
Subquery-based predicates are not evaluated early in the join order
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 P     F    
Subquery-based predicates are not evaluated early in the join order
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 P     F    
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
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 P     F    
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
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 P     F    
Cursors should ignore changes made by the same statement
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 P     F    
Cursors should ignore changes made by the same statement
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 P     F    
BUGCHECK(177) for MERGE with multiple matches
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 P     F    
BUGCHECK(177) for MERGE with multiple matches
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 P     F    
Server crashes while sorting records longer than 128KB
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 P     F    
Server crashes while sorting records longer than 128KB
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 P     F    
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
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 P     F    
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
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 P     F    
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
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 P     F    
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
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 P     F    
Select from mon$table_stats doesn`t work on SC and CS
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 P     F    
Select from mon$table_stats doesn`t work on SC and CS
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 P     F    
Restore of shadowed database fails using -k ("restore without shadow") switch
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 P     F    
Restore of shadowed database fails using -k ("restore without shadow") switch
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 P     F    
Prohibit an ability to issue DML or DDL statements on RDB$ tables
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 P     F    
Prohibit an ability to issue DML or DDL statements on RDB$ tables
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 P     F    
Cannot CREATE VIEW that selects from a system table, despite having all grants
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 P     F    
Cannot CREATE VIEW that selects from a system table, despite having all grants
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 P     F    
Bad optimization of some operations with views containing subqueries
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 P     F    
Bad optimization of some operations with views containing subqueries
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 P     F    
Invalid blob id when add a new blob column of type text and update another field
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 P     F    
Invalid blob id when add a new blob column of type text and update another field
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 P     F    
Shadow file is can not be created during restore when -use_all_space option is used
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 P     F    
Shadow file is can not be created during restore when -use_all_space option is used
29 SS P P P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P
SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.
30 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 P     F    
Consider equivalence classes for index navigation
31 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 P     F    
Consider equivalence classes for index navigation
32 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 P     F    
Efficient table scans for DBKEY-based range conditions
33 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 P     F    
Efficient table scans for DBKEY-based range conditions
34 CS P P P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P
Ability to query Firebird configuration using SQL
35 SS P P P P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P
Ability to query Firebird configuration using SQL
36 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 P     F    
Hash join cannot match records using some TIME ZONE / DECFLOAT keys
37 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 P     F    
Hash join cannot match records using some TIME ZONE / DECFLOAT keys
38 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 P     F    
Getting "records fetched" for functions/procedures in trace
39 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 P     F    
Getting "records fetched" for functions/procedures in trace
40 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 P     F    
Problems with windows frames
41 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 P     F    
Problems with windows frames
42 CS X X X X X X X X X X X X X X X X X X X X X X X X X X     F         F         F         F    
Improve performance of STARTING WITH with insensitive collations
43 SS X X X X X X X X X X X X X X X X X X X X X X X X X X     F         F         F         F    
Improve performance of STARTING WITH with insensitive collations
44 CS P P P     F         F     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
Check list of files in the current Firebird snapshot
45 SS P P P     F         F     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
Check list of files in the current Firebird snapshot
46 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 P     F    
Common SQL. Check correctness of the results
47 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 P     F    
Common SQL. Check correctness of the results
48 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 P     F    
Common SQL. Check correctness of the results
49 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 P     F    
Common SQL. Check correctness of the results
50 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 P     F    
Common SQL. Check correctness of the results
51 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 P     F    
Common SQL. Check correctness of the results
52 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 P     F    
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
53 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 P     F    
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
54 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 P     F    
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
55 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 P     F    
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
56 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 P     F    
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
57 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 P     F    
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
58 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 P     F    
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
59 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 P     F    
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
60 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
61 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
62 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
63 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
64 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
65 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
66 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
67 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
68 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
69 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
70 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
71 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
72 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
73 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
74 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
75 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
76 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
77 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
78 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 P     F    
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

Elapsed time, milliseconds:
NN Test name mode median_ms 4.0.1.2707
2022-01-21
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
Test TITLE
1 CS 1670 1600 1570 1780 1640 1630 1670 1640 1670 1720 1700 1730 1700 1670 1710 1670 1760 1680 1720 1720 1510 1510 1560 830 1510 1540 1540 2000 1520 1720 3530
Subquery-based predicates are not evaluated early in the join order
2 SS 1890 1880 1850 1910 1840 1860 1850 1840 1890 1880 1890 1900 1900 1890 1880 1890 1890 1870 1860 2050 1890 1920 1970 1050 1920 1900 1910 1880 1890 1870 6440
Subquery-based predicates are not evaluated early in the join order
3 CS 9895 9990 9720 9920 9830 9970 9880 9530 9980 9810 9780 10120 10040 10040 9670 9860 9930 10220 9000 10400 10280 9110 9910 4670 10050 9000 9780 10350 9630 9770 12160
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
4 SS 8290 8470 8230 8390 8180 8210 8200 8630 8520 8290 8430 8350 8310 8300 8380 8460 8420 8210 8470 8290 8240 8270 8290 5260 8230 8380 8190 8180 8180 8280 8630
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
5 CS 2695 2640 2470 2730 2000 2790 2670 2810 2760 2790 2780 2730 2690 2000 2790 2710 2700 2870 2760 3460 2420 2590 2000 1730 2520 2480 2570 3200 2620 2000 5030
Cursors should ignore changes made by the same statement
6 SS 3140 3180 3090 3290 3030 3070 2990 3120 3170 3310 3150 2980 3010 3000 3130 3060 3200 3180 3190 3150 3150 3020 3060 2060 3040 3160 3160 3060 3230 3190 3360
Cursors should ignore changes made by the same statement
7 CS 2090 1950 2010 2100 2140 2070 2100 2090 2110 2080 2140 2100 2130 2140 2090 2110 2090 2090 2090 1920 1930 1900 1910 1060 1900 1910 1900 2790 1880 2110 3910
BUGCHECK(177) for MERGE with multiple matches
8 SS 2415 2450 2450 2430 2390 2420 2400 2390 2390 2400 2400 2420 2420 2470 2420 2730 2460 2410 2400 2430 2420 2400 2410 1290 2400 2000 2380 2400 2420 2440 2900
BUGCHECK(177) for MERGE with multiple matches
9 CS 2090 2090 1970 2340 2120 2180 2120 2090 2120 2130 2150 2090 2140 2130 2090 2110 2260 2090 2120 1930 1900 1930 1950 1030 1920 1930 1940 1870 1920 2130 2140
Server crashes while sorting records longer than 128KB
10 SS 2430 2430 2430 2420 2400 2400 2380 2420 2480 2410 2430 2430 2440 2400 2430 2420 2420 2450 2430 2690 2430 2420 2420 1390 2450 2480 2510 2430 2420 2440 2400
Server crashes while sorting records longer than 128KB
11 CS 2060 2000 1900 2110 2090 2060 2090 2040 2060 2080 2140 2140 2090 2140 2060 2070 2060 2070 2610 1900 1890 1890 1880 1000 1850 1860 1890 1830 1860 2050 2820
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
12 SS 2380 2370 2400 2380 2350 2380 2370 2380 2340 2390 2370 2360 2390 2370 2390 2400 2430 2400 2390 2340 2390 2370 2370 1280 2400 2390 2400 2340 2340 2380 3290
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
13 CS 2105 1950 1960 2150 2070 2110 2160 2170 2120 2160 2180 2090 2140 2160 2590 2170 2110 2140 2100 1900 1920 1900 1900 1030 1980 2080 1900 1890 1900 2170 2920
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
14 SS 2420 2440 2450 2420 2410 2390 2390 2380 2400 2420 2400 2510 2400 2430 2440 2410 2430 2430 2440 2400 2430 2400 2450 1280 2450 2430 2410 2400 2400 2450 2840
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
15 CS 2860 2860 2780 2870 2820 2830 2880 2800 2910 3150 2870 2810 2950 3080 2860 2950 2930 2870 2810 2880 2820 2840 2820 1900 2790 2780 2780 2920 2860 2880 3150
Select from mon$table_stats doesn`t work on SC and CS
16 SS 2710 2000 2710 2700 2630 2710 2660 2590 2650 2760 2760 2720 2710 2740 2710 2730 2830 2670 2730 2710 2760 2700 2690 1560 2800 2730 2680 2700 2670 2680 2910
Select from mon$table_stats doesn`t work on SC and CS
17 CS 3920 3840 3810 4020 3900 3900 3910 3930 4090 3980 4070 3980 3960 3980 4030 3940 3980 4050 3990 3730 3710 3840 3770 2020 3740 3000 3000 3000 3740 3980 4470
Restore of shadowed database fails using -k ("restore without shadow") switch
18 SS 4570 4690 4550 4660 4590 4570 4580 4560 4550 4550 4730 4680 4630 4640 4730 4560 4550 4650 4840 4630 4480 4400 4540 2530 4460 4570 4570 4350 4000 4540 5470
Restore of shadowed database fails using -k ("restore without shadow") switch
19 CS 17865 18280 18340 18060 17800 17490 17610 17720 17700 18380 17930 17780 17620 17620 17470 18120 17690 17730 17620 18920 18870 18220 18200 15180 18280 18340 18690 21160 18760 17690 6860
Prohibit an ability to issue DML or DDL statements on RDB$ tables
20 SS 12675 12630 12910 12920 12820 12640 12670 12720 12660 12470 12730 12890 13280 12700 12420 12200 12210 12810 12760 13200 12790 12000 12840 10420 12670 12680 12720 12200 12620 12310 5380
Prohibit an ability to issue DML or DDL statements on RDB$ tables
21 CS 3415 3340 3280 3450 3430 3480 3000 3510 4570 3620 3400 3540 3370 3380 3450 3450 4120 3510 3460 3210 3230 3230 3490 1660 3200 3170 3120 3310 3200 3460 6240
Cannot CREATE VIEW that selects from a system table, despite having all grants
22 SS 4040 4080 4010 4070 4010 3990 4010 4040 4070 4070 4220 4000 4110 4080 4040 4010 4070 4040 4030 4080 4030 4040 4040 2090 4070 4090 4040 3960 4000 4040 5880
Cannot CREATE VIEW that selects from a system table, despite having all grants
23 CS 3480 4040 4090 4270 3510 3430 3450 3540 3520 3480 3470 3480 3540 3560 3490 3480 3530 3620 3490 3930 3360 3290 3430 2300 2470 2370 2350 2400 2310 2530 3810
Bad optimization of some operations with views containing subqueries
24 SS 3605 4290 4870 4210 4060 3620 3540 3660 3700 4040 3570 3570 3640 3570 3600 3620 3560 3650 3610 3570 3630 3640 3630 2480 2580 2590 2560 2590 2580 2570 3400
Bad optimization of some operations with views containing subqueries
25 CS 1665 1560 1630 1690 1690 1660 1670 1690 1820 1690 1680 1680 1700 1690 1670 1670 1660 1660 1670 1520 1540 1480 1520 840 1480 1000 1510 1510 1480 1670 2470
Invalid blob id when add a new blob column of type text and update another field
26 SS 1890 1890 1890 1870 1840 1840 1840 1870 1880 2320 1890 1890 1900 1890 1920 1920 1890 1900 1870 1880 1900 1910 1920 990 1890 1880 1900 1870 1860 1870 2780
Invalid blob id when add a new blob column of type text and update another field
27 CS 4995 4800 4760 5170 4950 5000 5060 5120 5010 5040 5070 5060 5070 5050 5010 5040 5060 4990 4970 4560 4680 4530 4590 2570 4670 4640 4600 4600 4530 5030 5730
Shadow file is can not be created during restore when -use_all_space option is used
28 SS 5875 5930 5930 5950 5820 5850 5790 5790 5860 5840 5850 5880 5870 5940 5870 5910 5850 5890 5820 5930 5850 5900 6060 3200 5960 5950 5900 5850 5930 5870 6060
Shadow file is can not be created during restore when -use_all_space option is used
29 SS 16200 16320 16390 16270 16090 16320 16160 16190 16150 16210 16190 16390 16240 16190 16140 16210 16400 16400 16220 16330 16370 16520 16290 15020 9620 9830 9900 9800 9870 9840 9980
SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.
30 CS 2180 2030 2030 2270 2190 2150 2200 2000 2190 2200 2210 2180 2260 2300 2200 2180 2200 2190 2180 2030 2080 1950 1980 1120 2040 2040 2040 2020 2020 2200 3010
Consider equivalence classes for index navigation
31 SS 2480 2560 2490 2000 2000 2460 2470 2480 2480 2520 2510 2460 2000 2480 2510 2480 2490 2480 2520 2490 2530 2480 2510 1310 2510 2530 2000 2460 2000 2520 3330
Consider equivalence classes for index navigation
32 CS 10375 10190 10240 10350 10420 10280 10440 10390 10450 10450 10580 10440 10470 10360 10420 10430 10640 10450 10470 10140 10190 10300 10280 7580 10000 10280 10200 10260 10210 10410 12460
Efficient table scans for DBKEY-based range conditions
33 SS 9100 9090 9060 9090 9070 9080 9100 9140 9060 9110 9300 9080 9120 9120 9090 9110 9390 9080 9090 9030 9410 9680 9000 7880 9160 9320 9280 9100 9090 9140 9680
Efficient table scans for DBKEY-based range conditions
34 CS 7895 7780 7620 7980 8070 7720 8220 9000 8290 8070 7920 7830 8160 7930 7920 8020 8200 7840 8020 9650 7870 7800 7700 6390 7000 7820 7790 7710 7610 7810 8110
Ability to query Firebird configuration using SQL
35 SS 7670 8050 7910 7410 7820 7550 7600 7740 7650 8720 7760 7730 7660 7910 7650 7490 7680 7560 7880 7990 7400 7000 7800 5680 7370 7960 7000 7600 7580 7730 7860
Ability to query Firebird configuration using SQL
36 CS 1620 1510 1490 1000 1610 1620 1620 1640 1640 1620 1640 1640 1640 1630 1650 1640 1600 1620 1720 1670 1540 1480 1450 790 1480 1480 1460 1450 1450 1650 2360
Hash join cannot match records using some TIME ZONE / DECFLOAT keys
37 SS 1845 1840 1840 1850 1890 1820 1810 1890 1840 1850 1840 1850 1900 1840 2030 1950 1860 1900 1830 1840 1860 1830 1990 1030 1870 1840 1840 1810 1830 1850 2270
Hash join cannot match records using some TIME ZONE / DECFLOAT keys
38 CS 6795 6590 6670 6870 6000 7230 6850 6820 6930 6790 6860 6960 6850 6830 6850 6800 6000 6800 6870 6650 6730 6630 6720 5040 6640 6690 6740 6630 6670 6900 7490
Getting "records fetched" for functions/procedures in trace
39 SS 6660 6610 6530 6580 6630 6620 6600 6610 6710 6680 7220 6660 6660 6630 6600 6930 6720 6770 6690 6760 6680 6710 6690 5100 6000 6670 6790 6640 6620 6650 7070
Getting "records fetched" for functions/procedures in trace
40 CS 1625 1530 1700 1690 1620 1650 1600 1620 1650 1660 1670 1620 1680 1640 1630 1640 1640 1630 1640 1510 1490 1000 1480 820 1480 1000 1490 1000 1540 1640 3980
Problems with windows frames
41 SS 1960 1970 1960 1930 1980 1930 1900 1990 1960 1880 2010 1970 1960 1960 1890 1890 1870 1990 1930 1960 1980 1950 2950 1030 2000 1950 1970 1840 1950 1840 2310
Problems with windows frames
42 CS 41750 41720 40860 41780 42290
Improve performance of STARTING WITH with insensitive collations
43 SS 41910 42170 41650 41070 42290
Improve performance of STARTING WITH with insensitive collations
44 CS 1680 1600 1530 1710 1670 1670 1660 1670 2360 1680 1740 1680 1700 1700 1690 1680 1690 1730 1810 1590 1560 1580 2400 890 1550 1560 1570 2280 1540 1700 2450
Check list of files in the current Firebird snapshot
45 SS 2010 2100 2080 2010 2010 1980 2000 2030 2000 1880 2070 1990 2010 2030 1850 1860 1880 2010 2020 2170 2020 2060 2050 1040 2010 2000 2010 1870 2000 1850 2090
Check list of files in the current Firebird snapshot
46 CS 2830 3260 2700 2920 2810 2820 2830 2840 2840 2860 2870 2860 2860 2830 2870 2850 2830 2870 2820 2620 2600 2570 2590 1460 2570 2610 2570 2620 2550 2920 2870
Common SQL. Check correctness of the results
47 SS 3280 3390 3450 3310 3260 3200 3260 3230 3340 3230 3310 3280 3290 3240 3260 3310 3270 3220 3780 3320 3310 3310 3280 1900 3290 3300 3270 3270 3190 3220 3320
Common SQL. Check correctness of the results
48 CS 3525 3420 3650 3620 3580 3670 3550 3600 3550 3560 3540 3580 3570 3600 3000 3510 3480 3000 3430 3510 3960 3470 3460 2170 3420 3420 3450 3360 3340 3570 3600
Common SQL. Check correctness of the results
49 SS 3640 3650 3660 4230 3670 3580 3630 3640 3640 3650 3620 3680 3630 3650 3690 3650 3620 3610 3640 3630 3660 3730 3640 2290 3650 3640 3660 3630 3640 3570 3590
Common SQL. Check correctness of the results
50 CS 2635 2620 2440 2790 2650 2620 2630 2640 2650 3140 2770 2630 2650 2670 2740 2650 2000 2630 2650 2530 2700 2480 2430 1330 2400 2510 2470 3030 2400 2670 2710
Common SQL. Check correctness of the results
51 SS 3115 3140 3180 3190 3070 2970 3110 3060 3100 3030 3110 3120 3150 3150 3120 3090 3090 3020 3120 3140 3140 3100 3140 1720 3120 3150 3100 3070 3130 3030 3120
Common SQL. Check correctness of the results
52 CS 7310 7270 7180 7410 6940 7380 7360 7300 7320 7340 7540 7360 7440 7610 7270 7420 7410 7380 7330 7240 7150 7170 7120 4560 7180 7110 7270 7180 7070 7320 9260
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
53 SS 6595 6630 6570 6560 6560 6480 6490 6910 6640 6610 6700 6620 6650 6710 6550 6580 6590 6520 6590 6570 6600 6620 6000 4590 6580 6680 6660 6560 7060 6630 7430
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
54 CS 6850 6670 6690 6950 6840 6970 6870 7060 6830 6840 6890 6940 6960 6920 6880 7340 6880 6860 7070 6000 6640 6650 6630 4690 6630 6770 6630 6630 6360 6900 7870
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
55 SS 6590 6680 6680 6600 6490 6420 6440 6600 6600 6630 6510 6560 6550 6610 6580 6550 6530 6480 6720 6610 6650 6580 6530 4790 6630 6660 6650 6000 6530 6600 7390
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
56 CS 10865 10480 10900 11050 10870 10780 10840 10380 10860 10980 10880 11030 11060 10870 10990 10990 11080 10440 11010 10870 10660 9970 10730 7350 10710 10590 10640 10390 10270 10870 13020
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
57 SS 9890 10060 10140 9890 9000 9850 9740 9000 9860 10070 9700 9960 9990 9850 9970 9800 9890 9890 9970 10030 9940 10020 9810 7020 9830 9920 9920 9710 9850 9810 11330
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
58 CS 66585 69530 66480 67770 65440 64550 65890 68610 65850 67140 65610 67450 66280 65350 68150 66410 67640 68160 67850 66690 67670 66810 65350 46410 67470 65180 64680 67040 65360 65280 91280
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
59 SS 57995 60230 58740 56860 56940 58390 56850 56230 57030 56730 55790 57970 58060 57340 58190 58240 59060 57130 59420 58300 57900 58930 58020 41730 56900 58910 58720 58400 56130 57550 66660
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
60 CS 10090 10580 10150 10530 10270 9930 9910 9880 9830 9920 10000 9990 10050 9950 9950 10420 10290 10730 10420 9660 10160 10140 9700 6650 10200 10140 10100 9770 10080 10380 12760
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
61 SS 9840 9860 9840 9860 9610 9800 10390 9690 9690 9880 9560 9850 9840 9770 9810 9810 9940 9670 9890 9730 9850 9990 10300 6820 9880 9900 10040 9790 9730 9780 11420
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
62 CS 10060 11040 9890 10590 10840 9000 9810 9830 10310 10420 10220 10230 10400 9870 10410 9880 10000 10010 10220 9800 10230 10000 10140 7000 10050 10280 9810 9240 10070 10010 13260
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
63 SS 9980 10150 9790 10070 9000 9000 9620 10050 10950 9760 9740 10460 11030 10370 9910 9800 10000 10030 9890 9980 9980 9950 10020 7060 11150 9910 10630 10160 9760 9840 11380
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
64 CS 10015 10230 10030 10140 10100 9450 9910 10450 10300 10440 10000 10000 10480 10310 9970 9940 10000 9880 10440 9830 10370 10090 10100 7990 10130 9610 9960 9670 9990 9840 12100
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
65 SS 9970 10000 10470 9910 9690 9710 9690 10310 9840 9730 9730 10530 9830 9910 9740 10000 10350 10070 10120 10040 10000 9940 9810 6740 10050 10080 10340 9770 9850 10330 11390
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
66 CS 10095 10110 9860 10460 9960 10000 9840 10650 10460 9880 9760 9940 10360 9840 10490 10360 10360 9930 10330 11560 10110 10060 10080 8140 10070 9690 10020 10120 10490 10260 12260
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
67 SS 9830 9960 9860 9670 9770 9560 9590 9880 9770 9800 9880 10370 10390 9790 9780 9000 10550 10660 9850 10260 9810 9890 9900 6740 9800 9810 9860 9630 9980 9790 11560
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
68 CS 10185 10350 9870 10060 10180 10370 9860 10000 10300 10360 10190 10030 10340 9990 10360 10230 9970 10580 10230 9940 10060 10310 10220 7940 10540 10280 9880 10130 9840 9000 12090
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
69 SS 9865 10430 9000 9890 10200 9700 9590 9600 9950 9000 9790 9780 9830 9830 9890 9890 9860 9670 9940 10080 9890 9780 10060 6690 9870 11480 9980 9760 10520 9800 11120
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
70 CS 10285 10170 10360 10330 10080 10510 9940 9940 10300 10340 10650 10300 10310 10380 10480 10400 10020 10360 10340 10170 10160 10120 9800 7190 10060 10320 9700 9980 9970 10270 11860
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
71 SS 9880 10400 9740 9730 9590 9690 9680 10280 9830 10170 10310 9970 9890 9000 10480 10020 10260 9000 10910 10050 9860 10360 9800 6770 9870 10480 9810 9800 9630 9910 10870
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
72 SS 9925 10050 9930 10000 9810 10150 9670 10240 9920 10450 10420 9820 9940 10210 10940 10720 9830 9780 9810 9910 9860 9810 10020 6790 9910 9930 9890 9730 9780 10290 12030
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
73 CS 10195 10190 10100 10490 9920 10940 10110 9970 10360 10390 10200 10420 10340 10310 10210 10280 9990 10390 10300 10110 10170 10070 10310 7340 10080 9690 10030 9710 10060 10280 15520
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
74 SS 9860 10340 9920 9900 9000 10190 9580 9000 9840 9740 9800 9860 10290 9880 9860 9980 9860 9670 9800 10440 9810 9800 10230 6770 9920 9980 9800 9680 10330 9930 11510
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
75 CS 10095 9820 10220 9770 9890 9970 10140 10420 9970 10540 9800 10370 10310 10420 10280 10300 9780 10260 10080 10320 10020 10570 10060 8130 10080 9270 10060 10060 10110 10330 12310
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
76 SS 9905 10830 10450 9830 10320 9780 9980 9730 9950 9810 9900 9890 9770 10540 9860 9950 9840 9700 9950 9920 10230 9910 9830 7270 9920 10090 9810 10280 9770 9890 11540
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
77 CS 10135 10170 9920 10110 10200 10030 10080 10360 9910 9960 10370 10360 10430 10300 9860 10330 9940 10190 10450 9890 10040 10160 10020 7000 10260 9670 9850 9000 10230 10390 12510
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
78 SS 9870 9920 9880 9880 9590 9640 11060 9670 9930 10360 9000 9930 9780 9820 9860 9860 9830 9710 9770 9880 10000 9780 10210 6830 9960 9970 10080 9900 9710 9840 10830
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1549
http://tracker.firebirdsql.org/browse/core-1725
http://tracker.firebirdsql.org/browse/core-3362
http://tracker.firebirdsql.org/browse/core-4369
http://tracker.firebirdsql.org/browse/core-4419
http://tracker.firebirdsql.org/browse/core-4422
http://tracker.firebirdsql.org/browse/core-4528
http://tracker.firebirdsql.org/browse/core-4668
http://tracker.firebirdsql.org/browse/core-4715
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-5060
http://tracker.firebirdsql.org/browse/core-5393
http://tracker.firebirdsql.org/browse/core-5600
http://tracker.firebirdsql.org/browse/core-5630
http://tracker.firebirdsql.org/browse/core-5664
http://tracker.firebirdsql.org/browse/core-5676
http://tracker.firebirdsql.org/browse/core-6278
http://tracker.firebirdsql.org/browse/core-6444
http://tracker.firebirdsql.org/browse/core-6534
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/build/snapshot-files-check-list.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-1940_20110725_1159.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-7029-heavy-test-for-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dbp-7114-windowed-funcs.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-statement-delete-undone-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-statement-delete-undone-02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-merge-deny-multiple-matches.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-max-limit.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-delete-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-delete-02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-delete-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-merge-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-merge-02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-merge-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-04.fbt
https://github.com/FirebirdSQL/firebird/issues/6782
https://github.com/FirebirdSQL/firebird/issues/7018
https://github.com/FirebirdSQL/firebird/issues/7038

=== end of list ===