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

Generated 11.05.2022 09:30
Tested: HQ30.   Build: 3.0.10.33587;   CS: 11.05.22 07:40:57 - 11.05.22 09:22:30;   SS: 11.05.22 06:05:08 - 11.05.22 07:38:20;
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 3.0.10.33587
2022-05-11
3.0.10.33580
2022-04-30
3.0.10.33577
2022-04-25
3.0.10.33570
2022-04-17
3.0.10.33569
2022-02-25
3.0.9.33561
2022-02-22
3.0.9.33560
2022-02-13
3.0.9.33556
2022-02-09
3.0.9.33548
2022-01-12
3.0.8.33540
2021-12-20
3.0.8.33533
2021-12-01
3.0.8.33528
2021-11-08
3.0.8.33501
2021-10-31
3.0.8.33490
2021-09-22
3.0.8.33489
2021-08-10
3.0.8.33488
2021-08-07
3.0.8.33487
2021-07-31
3.0.8.33475
2021-07-20
3.0.8.33472
2021-06-18
3.0.8.33471
2021-06-09
3.0.8.33470
2021-06-02
3.0.8.33468
2021-05-29
3.0.8.33452
2021-05-13
3.0.8.33430
2021-04-17
3.0.8.33423
2021-03-30
3.0.8.33415
2021-03-04
3.0.8.33403
2021-01-27
3.0.8.33392
2021-01-17
3.0.7.33388
2021-01-17
3.0.7.33379
2021-01-18
Test TITLE
1 SS     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 P P P
Count ( DISTINCT ... ) is too slow
2 SS P     F     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
Blob Comparison with constant
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     F         F    
Lot of syntax tests for COALESCE()
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     F         F    
Lot of syntax tests for COALESCE()
5 CS 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 P P P
Server crash with isc_dsql_execute_immediate and zero length string
6 SS 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 P P P
Server crash with isc_dsql_execute_immediate and zero length string
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     F     P P P P
CREATE COLLATION connection lost under Posix
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     F     P P P P
CREATE COLLATION connection lost under Posix
9 CS P     F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P P P P P P P
Success message when connecting to tiny trash database file
10 SS P     F         F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P P P P P P P
Success message when connecting to tiny trash database file
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     F     P P P P P P
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
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     F     P P P P P P
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
13 CS 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 P P
In SS sweep blocks establishment of concurrent attachments
14 CS P P P P P P P P P P P     F     P     F         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
15 SS P P     F     P P P P P P P P P P P     F     P     F     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
16 SS P P P P     F         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
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
17 CS 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 P P P P P
Detach using Linux client takes much longer than from Windows
18 CS P     F     P P P P P P P P P     F     P P P P P P     F         F     P     F     P P P P P P P P
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
19 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     P P P
Wrong transaction can be passed to external engine
20 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X X
Increase number of formats/versions of views from 255 to 32K
21 SS P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X X
Increase number of formats/versions of views from 255 to 32K
22 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     F     P P P
Sometime it is impossible to cancel\kill connection executing external query
23 CS 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 P P
Better diagnostic when 'Missing security context'
24 SS 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 P P
Better diagnostic when 'Missing security context'
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     F     P
gfix cannot set big value for buffers
26 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     F     X X X X X
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
27 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     F     X X X X X
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
28 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     F     X X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
29 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     X X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
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     F     X X X X X
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
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     F     X X X X X
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
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     F     X X X X X X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
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     F     X X X X X X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
34 CS P P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X
CAST of Infinity values to FLOAT doesn't work
35 SS P P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X
CAST of Infinity values to FLOAT doesn't work
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     F     X X X X X X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
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     F     X X X X X X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
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     F     X X X X X X
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
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     F     X X X X X X
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
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     F     X X X X X X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
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     F     X X X X X X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
42 CS P P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X
Implementation of SUBSTRING for UTF8 character set is inefficient
43 SS P P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X
Implementation of SUBSTRING for UTF8 character set is inefficient
44 CS X X X X X X X X X X X X X X     F         F         F         F         F         F         F         F         F     X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
45 SS X X X X X X X X X X X X X X     F         F         F         F         F         F         F         F         F     X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
46 CS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
47 SS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
48 CS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
49 SS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
50 CS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
51 SS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
52 CS P P P P P P P P P P P P P P P P P P P P P P     F     X X X X X X X
Getting "records fetched" for functions/procedures in trace
53 SS P P P P P P P P P P P P P P P P P P     F         F     P P     F     X X X X X X X
Getting "records fetched" for functions/procedures in trace
54 CS S S S S S S S S S S S S S S S S S S     F     X X X X X X X X X X X
Crash occurs when use SIMILAR TO ...
55 SS S S S S S S S S S S S S S S S S S S     F     X X X X X X X X X X X
Crash occurs when use SIMILAR TO ...
56 CS P P P P P P P P P P P P P P P P P     F     X X X X X X X X X X X X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
57 SS P P P P P P P P P P P P P P P P P     F     X X X X X X X X X X X X
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
58 CS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
DATEDIFF does not support fractional value for MILLISECOND
59 SS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
DATEDIFF does not support fractional value for MILLISECOND
60 CS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
61 SS P P P P P P P P P P P P     F     X X X X X X X X X X X X X X X X X
gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
62 CS S S S S S S S S S S     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
INNER JOIN join order
63 SS S S S S S S S S S S     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
INNER JOIN join order
64 CS 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 P P P P
LEFT OUTER JOIN with full match, but limited in ON clause
65 SS 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 P P P P
LEFT OUTER JOIN with full match, but limited in ON clause
66 CS 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 P P P P
LEFT OUTER JOIN with STARTING WITH in WHERE clause
67 SS 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 P P P P
LEFT OUTER JOIN with STARTING WITH in WHERE clause
68 CS P P P P P P P P P P P P P P     F         F         F         F         F         F         F     P P P P P P P P P
Check list of files in the current Firebird snapshot
69 SS P P P P P P P P P P P P P P     F         F         F         F         F         F         F     P P P P P P P P P
Check list of files in the current Firebird snapshot
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     F     P P P P P
Empty DB - RDB$ROLES
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     F     P P P P P
Empty DB - RDB$ROLES
72 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     F     P P P P P
Empty DB - RDB$SECURITY_CLASSES
73 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     F     P P P P P
Empty DB - RDB$SECURITY_CLASSES
74 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     F     P P P P P
Empty DB - RDB$USER_PRIVILEGES
75 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     F     P P P P P
Empty DB - RDB$USER_PRIVILEGES
76 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
ISQL - SHOW DATABASE
77 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
ISQL - SHOW DATABASE
78 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     F         F         F    
CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
79 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     F         F         F    
CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
80 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     F         F         F    
CREATE DATABASE - Multi file DB
81 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     F         F         F    
CREATE DATABASE - Multi file DB
82 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     F         F         F    
CREATE DATABASE - Multi file DB - starting
83 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     F         F         F    
CREATE DATABASE - Multi file DB - starting
84 CS 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 P
test de la fonction datediff pour avoir le resultat en minute
85 SS 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 P
test de la fonction datediff pour avoir le resultat en minute
86 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     F     P P P P P
CREATE ROLE
87 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     F     P P P P P
CREATE ROLE

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.10.33587
2022-05-11
3.0.10.33580
2022-04-30
3.0.10.33577
2022-04-25
3.0.10.33570
2022-04-17
3.0.10.33569
2022-02-25
3.0.9.33561
2022-02-22
3.0.9.33560
2022-02-13
3.0.9.33556
2022-02-09
3.0.9.33548
2022-01-12
3.0.8.33540
2021-12-20
3.0.8.33533
2021-12-01
3.0.8.33528
2021-11-08
3.0.8.33501
2021-10-31
3.0.8.33490
2021-09-22
3.0.8.33489
2021-08-10
3.0.8.33488
2021-08-07
3.0.8.33487
2021-07-31
3.0.8.33475
2021-07-20
3.0.8.33472
2021-06-18
3.0.8.33471
2021-06-09
3.0.8.33470
2021-06-02
3.0.8.33468
2021-05-29
3.0.8.33452
2021-05-13
3.0.8.33430
2021-04-17
3.0.8.33423
2021-03-30
3.0.8.33415
2021-03-04
3.0.8.33403
2021-01-27
3.0.8.33392
2021-01-17
3.0.7.33388
2021-01-17
3.0.7.33379
2021-01-18
Test TITLE
1 SS 4955 106460 7530 4350 5200 5290 5130 5200 5140 4950 4960 5050 5010 4820 4900 4860 4940 4650 4930 5010 4990 4920 4900 4790 4600 4710 4600 4640 6630 5850 5680
Count ( DISTINCT ... ) is too slow
2 SS 1430 2370 2530 890 1680 1800 1710 1000 1760 1440 1460 1580 1420 1400 1450 1410 1440 1430 1440 1440 1000 1450 1430 1380 1390 1420 1290 1360 1110 1100 1090
Blob Comparison with constant
3 CS 2250 2340 2420 1050 3590 2410 2340 2540 2490 2300 2310 2300 2310 2230 2200 2000 2200 2220 2180 2000 2280 2290 2230 2090 2120 2140 2270 2060 2200 2460 2160
Lot of syntax tests for COALESCE()
4 SS 1590 2260 2510 950 1890 1930 1880 1920 1900 1000 1630 1620 1590 1610 1570 1530 1590 1550 1570 1600 1590 1590 1610 1520 1550 1530 1450 1430 1490 1540 1210
Lot of syntax tests for COALESCE()
5 CS 2070 2230 2260 830 2080 2200 2150 2070 2070 2090 2100 2110 2100 2090 2060 2060 2070 2030 2060 2080 2150 2090 2040 1890 2200 1910 1830 1900 1890 1900 1000
Server crash with isc_dsql_execute_immediate and zero length string
6 SS 1390 2170 11650 760 1830 1710 1700 1960 1710 1430 1890 1420 1380 1380 1390 1350 1390 1340 1380 1480 1390 1390 1390 1340 1360 1330 1000 1340 1140 890 930
Server crash with isc_dsql_execute_immediate and zero length string
7 CS 1590 1620 1730 610 1720 1730 1000 1640 1790 1600 1600 1590 1570 1580 1610 1580 1540 1610 1560 1560 1640 1620 1610 1430 1590 1460 1630 1490 1280 1420 1390
CREATE COLLATION connection lost under Posix
8 SS 1090 1610 1440 610 1470 1400 1530 1420 1410 1120 1080 1120 1080 1110 1080 1110 1080 1100 1100 1090 1090 1110 1090 1060 1040 1050 1020 1050 870 800 0
CREATE COLLATION connection lost under Posix
9 CS 3670 3740 3000 1900 3780 3760 3810 3980 3730 3720 3710 3730 3710 3710 4120 3720 3680 3660 3690 3510 3620 3530 3410 3210 3350 3000 3290 3230 3260 3190 3070
Success message when connecting to tiny trash database file
10 SS 2580 2950 3120 1770 3160 2910 2890 3060 2930 2620 2610 2620 2590 2590 2590 2570 2590 2560 2630 2530 2530 2510 2400 2390 2440 2390 2290 2330 2060 2330 2120
Success message when connecting to tiny trash database file
11 CS 2120 2370 2180 740 2150 2280 2460 2320 2120 2150 2110 2130 2170 2100 2190 2120 2090 2110 2080 2120 2170 2170 2090 1960 2230 2820 1910 1890 1890 1920 2090
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
12 SS 1400 1670 1920 780 1710 1810 1780 1000 1000 1480 1410 1000 1440 1420 1420 1380 1390 1380 1430 1480 1450 1400 1450 1390 1400 1390 1370 1320 1290 1030 1210
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
13 CS 33400 33770 36730 27870 34550 33410 33700 33540 33380 33290 33870 33700 33390 34530 33340 33820 33700 33670 33540 34090 34720 33280 32400 32270 32110 31710 31440 29330 31360 31940 31680
In SS sweep blocks establishment of concurrent attachments
14 CS 27320 94190 94000 64050 103460 97290 95440 94680 85690 83710 83090 83630 27950 27020 27330 27330 27310 27180 23470 23700 23850 23680 23450 23240 23880 23540 23490 23400 24090 22930 27780
Increase speed of creating package when number of its functions more than several hundreds
15 SS 25525 87060 89810 70890 86810 87360 87930 87740 88730 77080 75910 76660 26360 25850 25000 25880 25530 25520 21550 21890 22150 22070 21960 21780 22280 22140 21830 21990 21840 22700 21170
Increase speed of creating package when number of its functions more than several hundreds
16 SS 3285 4480 4090 2150 4140 4330 4240 4240 4090 3370 3310 3360 3280 3260 3230 3350 3260 3000 3240 3300 3320 3290 3290 3060 3180 3150 3030 3040 2420 2490 2360
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
17 CS 3620 3790 3820 1810 3760 3690 3870 3790 3700 4450 3620 4400 3850 3640 3620 3670 3600 3620 3610 3650 3680 3620 3590 3210 3270 1950 1890 1860 1780 1840 1860
Detach using Linux client takes much longer than from Windows
18 CS 39620 42060 50980 26210 47480 49140 42920 39000 42880 41780 48080 42030 51630 52320 33960 34000 36110 34420 33840 57860 58410 47560 40240 24080 29200 28530 27960 27470 27830 30310 29940
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
19 SS 3305 3710 3710 2350 3680 4530 3000 3570 3840 3490 3340 3340 3360 3280 3260 3330 3390 3290 3350 3290 3350 3320 3260 3100 3160 3130 3020 2980 2170 2100 2000
Wrong transaction can be passed to external engine
20 CS 21140 21530 24560 27820 21550 22000 22560 22240 21520 21920 21090 21620 22000 20890 21140 20820 21010 20360 20210 20530 20720 20560 20510 5190
Increase number of formats/versions of views from 255 to 32K
21 SS 19970 20400 20470 20200 20540 20800 21010 21130 20600 20470 19970 20480 20770 19290 19860 19530 19000 19120 19030 19330 19480 19360 19310 3860
Increase number of formats/versions of views from 255 to 32K
22 CS 26040 26370 26180 23270 26140 26470 26190 26100 26080 26190 26100 26020 26070 25970 25970 26100 26030 26140 26040 26130 26130 26040 25910 25470 25620 25610 25470 25570 24940 25240 25040
Sometime it is impossible to cancel\kill connection executing external query
23 CS 4330 4540 4560 2320 4390 4480 4770 4490 4400 4340 4290 4370 5850 4310 4310 4360 5210 4270 4320 4360 4810 4320 4020 3680 3930 3930 4760 2860 2790 2900 2840
Better diagnostic when 'Missing security context'
24 SS 2790 3030 3160 1970 3230 3110 3260 3090 3220 2830 2810 2860 4700 2800 2790 2740 2770 2760 3780 2800 2760 2790 2640 2620 2570 2600 2570 1540 1380 1110 1000
Better diagnostic when 'Missing security context'
25 CS 4200 4990 4150 2850 4200 4370 4000 4260 4200 4200 4130 4140 4230 4130 4160 4100 4260 4370 4100 4260 4230 4150 4100 3940 4270 4020 5400 5470 7000 6320 5530
gfix cannot set big value for buffers
26 CS 2210 2260 2260 1080 2200 2350 2380 2840 2260 2280 2260 2000 2240 2200 2210 2200 2190 2180 2210 2290 2280 2220 2200 2000 2060 2040
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
27 SS 1480 1700 1720 830 1760 1870 1840 1850 1760 1530 1480 1540 1440 1450 1450 1000 1450 1420 1430 1490 1490 1490 1470 1390 1470 1390
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
28 CS 1610 1680 1640 0 1640 1910 1800 1900 1620 1630 1610 1660 1630 1590 1610 1560 1580 1580 1560 1640 1640 1590 1580 1470 1540 1480 1410
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
29 SS 1095 1370 1350 710 1390 1450 1460 1530 1390 1150 1120 1170 1070 1090 1080 1100 1080 1070 1090 1090 1110 1120 1090 1040 1060 1060 1020
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
30 CS 3730 3930 3890 1330 4090 3970 3950 4360 3000 3870 3760 3730 3770 3730 3620 3740 3620 3650 3620 3800 3810 3710 3630 3380 3430 3480
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
31 SS 2360 2560 2580 1160 2650 2730 2000 2740 2650 2400 2410 2430 2330 2340 2320 2360 2340 2310 2340 2360 2420 2590 2000 2230 2380 2000
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
32 CS 1615 1690 1650 760 1680 1710 1720 1990 1620 1630 1640 1630 1610 1600 1590 1590 1570 1560 1570 1660 1620 1610 1610 1490 1550
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
33 SS 1100 1350 1350 0 1390 1000 1590 1440 1420 1140 1100 1160 1090 1070 1080 1090 1080 1080 1070 1090 1100 1110 1090 1060 1130
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
34 CS 1610 1610 1640 640 1640 1660 1680 1670 1720 1640 1590 1670 1620 1590 1580 1590 1610 1600 1590 1640 1670 1610 1590 1470 1610
CAST of Infinity values to FLOAT doesn't work
35 SS 1115 1350 1420 630 1450 1460 1480 1420 1470 1210 1110 1130 1060 1090 1080 1440 1080 1080 1080 1090 1120 1130 1090 1050 1080
CAST of Infinity values to FLOAT doesn't work
36 CS 5465 5300 5420 2640 5550 5840 5370 5330 5660 5390 5600 5650 5510 5470 5460 5540 5000 5920 5430 5800 5470 5410 5560 5240 5160
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
37 SS 3955 4120 4230 2520 4230 4800 4560 4280 4160 3940 3960 4050 3950 3900 3820 3980 3880 3850 3960 3920 3960 3910 3930 3820 3910
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
38 CS 1650 1700 1640 700 1780 1760 1000 1730 1700 1700 1650 1680 1700 1640 1630 1620 1620 1660 1640 1720 1670 1650 1630 1530 1560
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
39 SS 1160 1420 1460 690 1410 1520 1510 1490 1450 1370 1170 1200 1150 1140 1140 1130 1140 1160 1140 1140 1160 1190 1160 1090 1120
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
40 CS 1660 1730 1720 800 2180 1730 2110 1000 1700 1710 1650 1650 1700 1650 1660 1690 1630 1600 1600 1700 1700 1660 1640 1530 1590
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
41 SS 1145 1410 1410 690 1420 1480 1000 1440 1460 1170 1150 1200 1140 1120 1120 1170 1140 1100 1110 1140 1150 1170 1140 1090 1110
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
42 CS 3005 5000 5100 4010 6520 4890 5000 4870 4910 4830 4820 4930 2340 2260 2240 2260 2240 2270 2000 2370 2340 2290 2230 2100 3640
Implementation of SUBSTRING for UTF8 character set is inefficient
43 SS 2375 4550 4570 4290 4400 4520 4490 4440 4460 4200 4120 4260 1550 1560 1580 1610 1570 1580 1540 1590 1670 1600 1590 1530 3080
Implementation of SUBSTRING for UTF8 character set is inefficient
44 CS 7440 7810 7340 7360 7440 7550 7480 8000 7350 6830
Many indexed reads in a compound index with NULLs [CORE2709]
45 SS 5650 5710 5650 5620 5630 5710 5820 5740 5410 5310
Many indexed reads in a compound index with NULLs [CORE2709]
46 CS 1670 1670 1780 770 2440 1700 1770 1700 1660 1670 1660 1700 1670 1630
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
47 SS 1400 1420 1400 680 1420 1480 1480 1450 1480 1200 1160 1200 1120 1140
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
48 CS 1670 1670 1680 670 1870 1690 1820 1930 1650 1670 1600 1660 1650 1650
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
49 SS 1170 1380 1380 770 1410 1550 1000 1410 1450 1170 1140 1170 1110 1110
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
50 CS 1680 1700 1720 710 2060 1000 1780 1730 1660 1680 1670 1670 1670 1690
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
51 SS 1380 1380 1380 670 1430 1480 1540 1510 1480 1200 1180 1200 1150 1120
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
52 CS 6820 6000 6740 4650 7210 6920 6910 6880 6820 6800 6820 6720 6770 6730 6710 6610 6730 6980 6710 9690 9650 9610 9340 9120
Getting "records fetched" for functions/procedures in trace
53 SS 5660 5660 5000 4570 5730 5870 5910 5780 5770 5930 5590 5530 5470 5450 5440 5490 5460 5430 5460 8310 8330 8410 8130 8030
Getting "records fetched" for functions/procedures in trace
54 CS 3940 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3940
Crash occurs when use SIMILAR TO ...
55 SS 5850 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5850
Crash occurs when use SIMILAR TO ...
56 CS 1925 2030 1990 960 1970 1990 1980 1960 2200 1930 1890 1890 1920 1880 1870 1960 1860 1870 1840
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
57 SS 1340 1580 1630 870 1610 1000 1680 1680 1650 1400 1340 1410 1310 1330 1310 1330 1340 1330 1290
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
58 CS 1655 1620 1620 0 1640 1670 1700 1680 1660 1640 1670 1660 1650 1600
DATEDIFF does not support fractional value for MILLISECOND
59 SS 1370 1360 1530 640 1370 1610 1460 1420 1380 1080 1370 1150 1090 1100
DATEDIFF does not support fractional value for MILLISECOND
60 CS 4790 4780 4700 2530 4790 4830 4790 4710 5030 4800 4660 4000 4840 5130
gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
61 SS 3820 3710 4310 2470 3890 4660 3870 3820 3850 3540 3600 3590 3490 4700
gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
62 CS 2590 0 0 0 0 0 0 0 0 0 0 2670 2830 2590 2630 2580 2630 2000 2550 2590 2550 2660 2630 2560 2530 2480 2440 2310 3160 3160 3120
INNER JOIN join order
63 SS 1895 0 0 0 0 0 0 0 0 0 0 1930 1920 1840 2000 1900 1890 1870 1810 1800 1910 1870 1940 1940 1840 1000 1740 1810 2240 2370 2170
INNER JOIN join order
64 CS 2170 2180 2390 1030 2260 2480 2270 2390 2000 2230 2000 2200 2210 2170 2240 2190 2160 2170 2170 2270 2000 2220 2140 2010 2080 2070 2020 1980 2030 2290 2010
LEFT OUTER JOIN with full match, but limited in ON clause
65 SS 1460 1730 1720 810 2030 1860 1880 1850 1810 1510 1480 1540 1480 1520 1450 1460 1450 1460 1450 1000 1000 1000 1470 1390 1440 1470 1360 1450 1230 1270 1170
LEFT OUTER JOIN with full match, but limited in ON clause
66 CS 2165 2340 2290 960 2260 2700 2420 2320 2260 2230 2220 2200 2000 2170 2000 2000 2150 2160 2170 2000 2260 2200 2150 2010 2060 2130 2110 1920 2140 3040 2060
LEFT OUTER JOIN with STARTING WITH in WHERE clause
67 SS 1465 1710 1770 820 1730 1870 1860 1780 1830 1520 1000 1550 1510 1470 1430 1470 1460 1440 1450 1480 1000 1000 1530 1420 1480 1400 1410 1430 1290 1100 1210
LEFT OUTER JOIN with STARTING WITH in WHERE clause
68 CS 1695 1950 1830 830 2150 1810 1780 1790 2270 1730 1740 1730 1740 1690 1680 1000 1730 1700 1690 1000 1000 1700 1720 1560 1610 1570 1580 1580 1640 1530 1620
Check list of files in the current Firebird snapshot
69 SS 1135 1550 1810 770 1820 1630 1480 1440 1820 1160 1140 1170 1140 1120 1110 1120 1090 1120 1130 1140 1170 1160 1160 1100 1100 1090 1080 1050 810 800 780
Check list of files in the current Firebird snapshot
70 CS 1615 1640 1660 670 1620 1730 1690 1670 1640 1650 1610 1660 1610 1660 1590 1590 1580 1590 1590 1640 1660 1630 1590 1000 1740 1470 1000 2670 1320 1380 1450
Empty DB - RDB$ROLES
71 SS 1110 1340 1360 720 1370 1530 1440 1420 1430 1170 1120 1160 1110 1090 1080 1090 1130 1080 1080 1090 1110 1170 1110 1060 1100 1080 1080 1110 820 770 840
Empty DB - RDB$ROLES
72 CS 1715 1730 1890 900 1990 1820 1840 1820 1790 1780 1700 1740 1730 1680 1680 1720 1680 1700 1700 1760 1830 1710 1700 1590 1690 2510 1550 1920 1340 1540 1590
Empty DB - RDB$SECURITY_CLASSES
73 SS 1200 1510 1480 0 1000 1580 1570 1570 1560 1260 1220 1000 1210 1000 1200 1200 1200 1180 1180 1220 1240 1230 1220 1150 1200 1850 1180 1180 950 890 820
Empty DB - RDB$SECURITY_CLASSES
74 CS 1950 2260 1920 820 2020 2210 1980 1940 2040 1980 1980 1970 1950 1950 1930 1950 1910 1960 1950 1980 1980 1950 1940 1780 1850 1860 1720 1730 1520 1690 1730
Empty DB - RDB$USER_PRIVILEGES
75 SS 1245 1530 1510 800 1610 1840 1590 1560 1000 1300 1260 1310 1270 1270 1000 1000 1230 1230 1230 1000 1270 1280 1000 1200 1270 1280 1130 1230 910 890 800
Empty DB - RDB$USER_PRIVILEGES
76 CS 1615 1730 1780 640 1770 1700 1950 1670 1660 1630 1650 1640 1640 1590 1620 1580 1560 1590 1560 1630 1650 1610 1590 1460 1490 1590 1450 1620 1190 1420 1380
ISQL - SHOW DATABASE
77 SS 1120 1490 1380 720 2050 1460 1440 1390 1440 1120 1130 1150 1110 1110 1090 1110 1090 1070 1070 1110 1130 1140 1120 1040 1090 1130 1200 1030 0 790 820
ISQL - SHOW DATABASE
78 CS 2165 2310 2640 1090 2170 2270 2310 2260 2230 2230 2180 2200 2170 2130 2160 2160 2120 2110 2130 2200 2210 2210 2190 1970 2000 2000 1940 1890 2150 1940 1930
CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
79 SS 1585 1840 1860 1020 1950 1950 1970 2030 1970 1600 1670 1640 1610 1590 1560 1570 1580 1560 1560 1570 1620 1620 1640 1520 1530 1510 1480 1470 1350 1210 1170
CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
80 CS 2165 2300 2540 1200 2240 2280 2330 2360 2280 2000 2220 2210 2220 2190 2160 2170 2140 2140 2160 2230 2230 2220 2150 1960 2000 1980 1940 1880 1990 2000 1900
CREATE DATABASE - Multi file DB
81 SS 1635 1920 1890 1060 1960 2200 2000 2280 2000 1680 1650 1680 1680 1630 1610 1630 1630 1600 1600 1640 1670 1670 1640 1540 1570 1560 1000 1480 1410 1200 1310
CREATE DATABASE - Multi file DB
82 CS 2170 2270 2840 1190 2200 2280 2320 2320 2230 2210 2210 2190 2200 2170 2160 2170 2150 2180 2180 2000 2000 2230 2150 1950 2040 2030 1900 1970 1930 2160 1870
CREATE DATABASE - Multi file DB - starting
83 SS 1630 1890 1900 970 1920 2090 1990 1920 1980 1680 1660 1000 1670 1630 1620 1640 1610 1610 1630 1620 1670 1670 1640 1560 1560 1550 1580 1470 1330 1130 1440
CREATE DATABASE - Multi file DB - starting
84 CS 1610 1650 1680 1230 1640 1710 1670 1680 1640 1740 1610 1640 1640 1590 1590 1610 1620 1570 1610 1640 1640 1640 1590 1480 1600 1530 1520 1420 1350 1420 1440
test de la fonction datediff pour avoir le resultat en minute
85 SS 1110 1520 1360 640 1380 1450 1430 1430 1440 1130 1110 1150 1260 1100 1110 1090 1070 1090 1080 1090 1110 1110 1090 1040 1110 1110 1020 1020 830 0 690
test de la fonction datediff pour avoir le resultat en minute
86 CS 1610 1770 1760 840 1640 1770 2040 1920 1710 1670 1600 1640 1620 1610 1610 1590 1560 1600 1610 1670 1650 1610 1610 1000 1780 1610 1450 1520 1340 1480 1380
CREATE ROLE
87 SS 1100 1370 1380 0 1000 1440 1440 1400 1440 1150 1120 1170 1100 1100 1070 1090 1100 1070 1090 1090 1140 1130 1110 1040 1060 1040 1030 1130 850 910 0
CREATE ROLE

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1506
http://tracker.firebirdsql.org/browse/core-1885
http://tracker.firebirdsql.org/browse/core-214
http://tracker.firebirdsql.org/browse/core-2484
http://tracker.firebirdsql.org/browse/core-284
http://tracker.firebirdsql.org/browse/core-2977
http://tracker.firebirdsql.org/browse/core-4135
http://tracker.firebirdsql.org/browse/core-4880
http://tracker.firebirdsql.org/browse/core-4928
http://tracker.firebirdsql.org/browse/core-4977
http://tracker.firebirdsql.org/browse/core-501
http://tracker.firebirdsql.org/browse/core-5034
http://tracker.firebirdsql.org/browse/core-5645
http://tracker.firebirdsql.org/browse/core-5647
http://tracker.firebirdsql.org/browse/core-5685
http://tracker.firebirdsql.org/browse/core-6362
http://tracker.firebirdsql.org/browse/core-6437
http://tracker.firebirdsql.org/browse/core-6479
http://tracker.firebirdsql.org/browse/core-6487
http://tracker.firebirdsql.org/browse/core-6489
http://tracker.firebirdsql.org/browse/core-6494
http://tracker.firebirdsql.org/browse/core-6521
http://tracker.firebirdsql.org/browse/core-6527
http://tracker.firebirdsql.org/browse/core-6531
http://tracker.firebirdsql.org/browse/core-6532
http://tracker.firebirdsql.org/browse/core-6542
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/arno/optimizer/opt_left_join_06.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_left_join_11.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/basic/db/db_25.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_26.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_31.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/isql/isql_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/database/create_08.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/database/create_09.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/database/create_10.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/intfunc/date/datediff_07.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/role/create_01.fbt
https://github.com/FirebirdSQL/firebird/issues/3106
https://github.com/FirebirdSQL/firebird/issues/3886
https://github.com/FirebirdSQL/firebird/issues/5082
https://github.com/FirebirdSQL/firebird/issues/5173
https://github.com/FirebirdSQL/firebird/issues/6782
https://github.com/FirebirdSQL/firebird/issues/6854
https://github.com/FirebirdSQL/firebird/issues/6866
https://github.com/FirebirdSQL/firebird/issues/6987
https://github.com/FirebirdSQL/firebird/issues/7031

=== end of list ===