0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (3 rows)
2. FRESH FAILS: tests which failed for LAST execution only (2 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 (4 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (19 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (0 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (2 rows)
8. All tests: outcomes (3862 rows)
9. All tests: durations (3873 rows)
A. Skipped: tests which was intentionally excluded from execution (6 rows)

Generated 15.10.2021 20:17
Tested: FB30.   Build: 3.0.8.33520;   SS: 15.10.21 16:32:18 - 15.10.21 18:12:22;   CS: 15.10.21 18:14:12 - 15.10.21 20:16:05;
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:
NN Test name mode 3.0.8.33520
2021-10-15
3.0.8.33519
2021-10-07
3.0.8.33506
2021-10-01
3.0.8.33505
2021-09-30
3.0.8.33504
2021-09-29
3.0.8.33501
2021-09-27
3.0.8.33498
2021-09-20
3.0.8.33497
2021-09-16
3.0.8.33496
2021-09-15
3.0.8.33495
2021-09-14
3.0.8.33494
2021-09-09
3.0.8.33493
2021-09-08
3.0.8.33492
2021-09-07
3.0.8.33491
2021-09-04
3.0.8.33490
2021-08-31
3.0.8.33489
2021-08-20
3.0.8.33488
2021-08-14
3.0.8.33487
2021-08-07
3.0.8.33486
2021-07-20
3.0.8.33476
2021-06-23
3.0.8.33475
2021-06-21
3.0.8.33474
2021-06-16
3.0.8.33473
2021-06-12
3.0.8.33472
2021-06-09
3.0.8.33471
2021-06-02
3.0.8.33470
2021-06-01
3.0.8.33468
2021-05-29
3.0.8.33467
2021-05-06
3.0.8.33465
2021-05-05
3.0.8.33463
2021-05-04
Test TITLE
1 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     F     P P P P
ANY user can drop procedures, generators, exceptions.
2 CS P P P P P P P P P P P P P P P P P P P X P P P P P P P P     F     P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
3 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     F     P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
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     F     P P P P
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
5 CS P P P     F     P P P P P P P P P P P P P P P X P P P P P P P P P P
Prohibit ability to cast timestamps that out of valid range to varchar
6 SS P P P     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 P
Prohibit ability to cast timestamps that out of valid range to varchar
7 CS     F     P P P     F     P P     F         F     P     F     P     F     P P P P     F     P X P P P P P P P P P P
Increase speed of creating package when number of its functions more than several hundreds
8 SS     F     P P P     F     P     F         F     P P P P     F     P     F         F     P P P P P P P P P P P P P P
Increase speed of creating package when number of its functions more than several hundreds
9 SS 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
Detach using Linux client takes much longer than from Windows
10 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X     F         F         F         F         F     P P P P P
Wire compression causes freezes
11 SS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P
Wire compression causes freezes
12 CS X X X X X X X X X X X     F         F         F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F     X
Many indexed reads in a compound index with NULLs [CORE2709]
13 SS X X X X X X X X X X X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X
Many indexed reads in a compound index with NULLs [CORE2709]
14 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F    
INNER JOIN join order
15 SS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
INNER JOIN join order
16 CS P P P P P P P P P P P     F         F         F         F         F         F         F         F     X     F         F         F         F         F         F     P P P P
Check list of files in the current Firebird snapshot
17 SS P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P
Check list of files in the current Firebird snapshot
18 CS P     F         F         F     P P P P P P P P P P P P P P P X P P P P P P P P P P
test de la fonction datediff pour avoir le resultat en minute
19 SS P     F         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 P
test de la fonction datediff pour avoir le resultat en minute

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.8.33520
2021-10-15
3.0.8.33519
2021-10-07
3.0.8.33506
2021-10-01
3.0.8.33505
2021-09-30
3.0.8.33504
2021-09-29
3.0.8.33501
2021-09-27
3.0.8.33498
2021-09-20
3.0.8.33497
2021-09-16
3.0.8.33496
2021-09-15
3.0.8.33495
2021-09-14
3.0.8.33494
2021-09-09
3.0.8.33493
2021-09-08
3.0.8.33492
2021-09-07
3.0.8.33491
2021-09-04
3.0.8.33490
2021-08-31
3.0.8.33489
2021-08-20
3.0.8.33488
2021-08-14
3.0.8.33487
2021-08-07
3.0.8.33486
2021-07-20
3.0.8.33476
2021-06-23
3.0.8.33475
2021-06-21
3.0.8.33474
2021-06-16
3.0.8.33473
2021-06-12
3.0.8.33472
2021-06-09
3.0.8.33471
2021-06-02
3.0.8.33470
2021-06-01
3.0.8.33468
2021-05-29
3.0.8.33467
2021-05-06
3.0.8.33465
2021-05-05
3.0.8.33463
2021-05-04
Test TITLE
1 SS 3535 3570 3580 3570 3000 3590 3550 3000 3560 3540 3560 3490 3490 3510 3590 3490 3610 4010 3490 3510 3560 3530 3610 3510 3540 3570 2580 2560 2000 2570 2620
ANY user can drop procedures, generators, exceptions.
2 CS 6000 6000 6220 6100 6150 6040 5910 6040 6120 6090 6040 6020 5940 6010 5920 6010 5950 6040 5940 5980 5990 5880 5940 7080 6540 5210 5210 4910 5000 5060
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
3 SS 4760 4780 4830 4000 4850 4780 4800 4780 4830 4760 4790 4760 4000 4000 4760 4820 4810 4000 4820 4710 4810 4740 4920 4730 4870 4720 4350 4380 4270 4450 4280
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
4 SS 55915 60360 55990 56020 54350 56580 56000 55600 53690 61990 59880 56830 60950 57120 54970 54770 55840 55220 57410 59150 57940 51710 59220 50740 54930 56800 50760 53520 52090 50240 47850
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
5 CS 1780 1780 1900 1670 1690 1800 1850 1770 1830 1780 1760 1810 1760 1780 1860 1780 1790 1810 1670 1760 1840 1790 1810 1870 1850 1520 1480 1390 1420 1420
Prohibit ability to cast timestamps that out of valid range to varchar
6 SS 1380 1440 1390 1450 1400 1390 1380 1370 1380 1370 1370 1370 1440 1380 1370 1410 1370 1380 1380 1380 1420 1470 1380 1370 1360 1370 1380 1390 1370 1360 1340
Prohibit ability to cast timestamps that out of valid range to varchar
7 CS 27280 28520 28460 27360 27280 27490 28180 27800 27000 27270 27400 27440 27270 27470 27440 27410 27930 27550 27400 27060 24030 24350 24160 24090 23920 23280 23140 22900 23020 23690
Increase speed of creating package when number of its functions more than several hundreds
8 SS 25880 27050 26840 25940 25870 27000 26690 25880 25960 25970 25940 26030 25880 25940 25870 26120 26280 26370 25840 25740 26810 22610 22680 22550 22520 22640 22490 22000 22050 22280 22070
Increase speed of creating package when number of its functions more than several hundreds
9 SS 2920 2930 2920 2940 2920 2910 2930 2900 2920 2920 2920 2920 2950 2970 3340 2920 2930 2910 2950 2910 2930 2950 2850 2920 2860 2870 2810 2850 2740 2760 2760
Detach using Linux client takes much longer than from Windows
10 CS 27970 28240 27940 28670 27940 28010 27700 27760 27820 28050 29220 27970 28070 27990 28030 40660 28240 28000 27920 27900 27700 27980 27890 45990 28040 11000 12270 11310 11610 11510
Wire compression causes freezes
11 SS 26535 27050 27070 26710 26490 26510 26060 26680 26470 26420 26230 26420 26510 26050 26560 26360 27190 26920 26910 27150 26870 27220 26590 27520 26720 26660 10480 10000 10000 10230 10200
Wire compression causes freezes
12 CS 8020 8030 7940 8140 7880 8130 7920 7970 8020 8070 8060 8330 8170 8050 6940 7240 7070 6690
Many indexed reads in a compound index with NULLs [CORE2709]
13 SS 6550 6620 6510 6600 6530 6520 6490 6460 6780 6570 6570 6600 6630 6600 6600 5910 5840 5820 5740
Many indexed reads in a compound index with NULLs [CORE2709]
14 CS 5790 5900 6300 5880 5810 5900 5850 5740 5770 5790 5710 5910 5640 5690 5740 5780 5820 5800 5800 5920 5790 5770 5800 5860 5940 2590 2600 2310 2770 2440
INNER JOIN join order
15 SS 5390 5550 5430 5360 5460 5370 5320 5290 5350 5370 5440 5520 5410 5470 5330 5400 5420 5000 5560 5460 5480 5440 5510 5380 5320 5460 2290 2280 2260 2340 2320
INNER JOIN join order
16 CS 2060 2060 1970 1990 2000 2050 2090 2090 1960 2170 2000 2170 2200 2030 2030 2150 2160 2170 2060 2130 2120 2140 2170 2590 1970 1620 1590 1470 1460 1000
Check list of files in the current Firebird snapshot
17 SS 1410 1410 1420 1420 1420 1400 1410 1400 1410 1470 1400 1480 1410 1400 1400 1400 1410 1410 1400 1420 1440 1400 1420 1430 1410 1420 1400 1410 1390 1390 1370
Check list of files in the current Firebird snapshot
18 CS 1780 1790 1810 1760 1000 1860 1800 1880 1830 1810 1850 1740 1000 1760 1840 1690 1760 1820 1760 1760 1890 1880 1900 1790 1780 1540 1510 1390 1420 1440
test de la fonction datediff pour avoir le resultat en minute
19 SS 1380 1380 1390 1450 1380 1370 1380 1370 1430 1370 1370 1370 1370 1370 1450 1370 1370 1370 1380 1440 1370 1390 1380 1380 1380 1390 1400 1370 1370 1390 1380
test de la fonction datediff pour avoir le resultat en minute

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-2531
http://tracker.firebirdsql.org/browse/core-304
http://tracker.firebirdsql.org/browse/core-4236
http://tracker.firebirdsql.org/browse/core-4789
http://tracker.firebirdsql.org/browse/core-4880
http://tracker.firebirdsql.org/browse/core-4977
http://tracker.firebirdsql.org/browse/core-6348
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_inner_join_03.fbt
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/intfunc/date/datediff_07.fbt
https://github.com/FirebirdSQL/firebird/issues/3106

=== end of list ===