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

Generated 15.10.2021 23:15
Tested: HQ30.   Build: 3.0.8.33501;   CS: 15.10.21 21:33:38 - 15.10.21 23:08:29;   SS: 15.10.21 20:20:25 - 15.10.21 21:31:27;
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.8.33501
2021-10-15
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
3.0.7.33375
2021-01-18
3.0.7.33368
2021-01-18
3.0.7.33358
2021-01-18
3.0.7.33356
2021-01-18
3.0.7.33352
2021-01-18
3.0.7.33350
2021-01-19
3.0.7.33348
2021-01-19
3.0.7.33343
2021-01-19
3.0.6.33332
2021-01-20
3.0.6.33331
2021-01-20
3.0.6.33292
2021-01-20
3.0.6.33289
2021-01-21
Test TITLE
1 SS 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 P P
Blob Comparison with constant
2 CS P P P P P 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    
Lot of syntax tests for COALESCE()
3 SS P P P P P 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    
Lot of syntax tests for COALESCE()
4 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
CREATE COLLATION connection lost under Posix
5 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
CREATE COLLATION connection lost under Posix
6 CS     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 P P
Success message when connecting to tiny trash database file
7 SS     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 P P
Success message when connecting to tiny trash database file
8 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         F         F         F         F         F         F    
Write note into log when automatic sweep is started
9 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
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
10 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
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
11 CS 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
Increase speed of creating package when number of its functions more than several hundreds
12 SS     F     P     F     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
Increase speed of creating package when number of its functions more than several hundreds
13 CS P P P P P P     F         F     P     F     P P P P P P P P P P P P 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
14 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
Performance regression when bulk inserting into table with indices
15 SS     F         F         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
Wrong transaction can be passed to external engine
16 CS 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 X X
Increase number of formats/versions of views from 255 to 32K
17 SS 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 X X
Increase number of formats/versions of views from 255 to 32K
18 CS 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 P
Sometime it is impossible to cancel\kill connection executing external query
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     F         F    
Varchar length limit is not enforced when assigning string with trailing spaces in MBCS
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     F         F    
Varchar length limit is not enforced when assigning string with trailing spaces in MBCS
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     F         F    
Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit
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     F         F    
Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit
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     F         F    
Server is crashing on long GRANT statement
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     F         F    
Server is crashing on long GRANT statement
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         F    
Alternate quoting does not work on some particular cases
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     F         F    
Alternate quoting does not work on some particular cases
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     F         F    
Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field
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     F         F    
Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field
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     F         F    
Server crashes on overflow of division result
30 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    
Server crashes on overflow of division result
31 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    
Wire compression causes freezes
32 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    
Wire compression causes freezes
33 CS P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F     X X X X
Computed field could be wrongly evaluated as NULL
34 SS P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F     X X X X
Computed field could be wrongly evaluated as NULL
35 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
Better diagnostic when 'Missing security context'
36 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
Better diagnostic when 'Missing security context'
37 CS P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F     X X X X
Space in database path prevent working gbak -se ... -b "pat to/database" backup
38 SS P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F     X X X X
Space in database path prevent working gbak -se ... -b "pat to/database" backup
39 CS P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F         F     X X X X
FB crashes on attempt to create table with number of fields greater than 5460
40 SS P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F         F     X X X X
FB crashes on attempt to create table with number of fields greater than 5460
41 CS P P P P P P P P P P P P P P P P     F     P P     F         F         F     P P P P     F         F         F         F    
gfix cannot set big value for buffers
42 SS 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     F         F         F         F         F    
gfix cannot set big value for buffers
43 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
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
44 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
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
45 CS 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 X X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
46 SS 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 X X X X
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
47 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
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
48 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
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
49 CS 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 X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
50 SS 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 X
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
51 CS 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 X
CAST of Infinity values to FLOAT doesn't work
52 SS 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 X
CAST of Infinity values to FLOAT doesn't work
53 CS 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 X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
54 SS 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 X
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
55 CS 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 X
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
56 SS 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 X
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
57 CS 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 X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
58 SS 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 X
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
59 CS 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 X
Implementation of SUBSTRING for UTF8 character set is inefficient
60 SS 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 X
Implementation of SUBSTRING for UTF8 character set is inefficient
61 CS X X     F         F         F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
62 SS X X     F         F         F         F         F         F         F         F         F     X X X X X X X X X X X X X X X X X X X
Many indexed reads in a compound index with NULLs [CORE2709]
63 CS 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 X X
Getting "records fetched" for functions/procedures in trace
64 SS P P P P P P     F         F     P P     F     X X X X X X X X X X X X X X X X X X X
Getting "records fetched" for functions/procedures in trace
65 CS S S S S S S     F     X X X X X X X X X X X X X X X X X X X X X X X
Crash occurs when use SIMILAR TO ...
66 SS S S S S S S     F     X X X X X X X X X X X X X X X X X X X X X X X
Crash occurs when use SIMILAR TO ...
67 CS P P P P P     F     X X X X X X X X X X X X 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
68 SS P P P P P     F     X X X X X X X X X X X X 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
69 CS     F     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 X X X
DATEDIFF does not support fractional value for MILLISECOND
70 SS     F     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 X X X
DATEDIFF does not support fractional value for MILLISECOND
71 CS     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
72 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
73 CS     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 P P P P
LEFT OUTER JOIN with full match, but limited in ON clause
74 SS     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 P P P P
LEFT OUTER JOIN with full match, but limited in ON clause
75 CS     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 P P P P
LEFT OUTER JOIN with STARTING WITH in WHERE clause
76 SS     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 P P P P
LEFT OUTER JOIN with STARTING WITH in WHERE clause
77 CS P P     F         F         F         F         F         F         F     P P P P P P P P P P P P P P P P P X X X X
Check list of files in the current Firebird snapshot
78 SS P P     F         F         F         F         F         F         F     P P P P P P P P P P P P P P P P P X X X X
Check list of files in the current Firebird snapshot
79 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
Empty DB - RDB$ROLES
80 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
Empty DB - RDB$ROLES
81 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
Empty DB - RDB$SECURITY_CLASSES
82 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
Empty DB - RDB$SECURITY_CLASSES
83 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
Empty DB - RDB$USER_PRIVILEGES
84 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
Empty DB - RDB$USER_PRIVILEGES
85 CS 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 P P
ISQL - SHOW DATABASE
86 SS 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 P P
ISQL - SHOW DATABASE
87 CS P P P P 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    
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.
88 SS P P P P 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    
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.
89 CS P P P P 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    
CREATE DATABASE - Multi file DB
90 SS P P P P 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    
CREATE DATABASE - Multi file DB
91 CS P P P P 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    
CREATE DATABASE - Multi file DB - starting
92 SS P P P P 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    
CREATE DATABASE - Multi file DB - starting
93 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    
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
94 CS     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
test de la fonction datediff pour avoir le resultat en minute
95 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
test de la fonction datediff pour avoir le resultat en minute
96 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
CREATE ROLE
97 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
CREATE ROLE

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.8.33501
2021-10-15
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
3.0.7.33375
2021-01-18
3.0.7.33368
2021-01-18
3.0.7.33358
2021-01-18
3.0.7.33356
2021-01-18
3.0.7.33352
2021-01-18
3.0.7.33350
2021-01-19
3.0.7.33348
2021-01-19
3.0.7.33343
2021-01-19
3.0.6.33332
2021-01-20
3.0.6.33331
2021-01-20
3.0.6.33292
2021-01-20
3.0.6.33289
2021-01-21
Test TITLE
1 SS 1289 1400 1450 1409 1440 1430 1440 1440 1000 1450 1430 1380 1389 1420 1289 1359 1110 1100 1089 1180 1180 1080 1289 1099 880 1829 1090 859 850 910 880
Blob Comparison with constant
2 CS 2149 2230 2200 2000 2200 2220 2180 2000 2279 2289 2230 2090 2120 2139 2269 2059 2200 2460 2160 2039 2430 2059 2440 2269 1539 1690 1690 1629 1659 2069 1820
Lot of syntax tests for COALESCE()
3 SS 1529 1579 1569 1529 1589 1549 1569 1599 1589 1589 1610 1519 1549 1529 1450 1430 1490 1539 1210 1580 1700 1329 1740 1459 1150 1420 1220 1220 1140 1089 1200
Lot of syntax tests for COALESCE()
4 CS 1459 1589 1610 1579 1539 1609 1560 1560 1640 1620 1609 1429 1589 1460 1629 1490 1279 1420 1389 1319 1380 1299 1480 1459 1019 1210 980 980 1089 1079 1190
CREATE COLLATION connection lost under Posix
5 SS 1039 1080 1079 1110 1079 1100 1100 1089 1090 1109 1089 1059 1039 1050 1020 1049 870 799 0 1360 1029 700 879 779 1029 590 549 609 650 630 580
CREATE COLLATION connection lost under Posix
6 CS 3200 3000 4119 3720 3680 3660 3690 3509 3620 3529 3409 3210 3349 3000 3289 3230 3259 3190 3070 3190 3140 3029 3360 3190 2920 2849 2799 2650 2809 2890 2829
Success message when connecting to tiny trash database file
7 SS 2309 2569 2590 2570 2590 2559 2629 2529 2529 2509 2400 2390 2439 2390 2289 2329 2059 2330 2119 2029 2070 2170 2090 2140 2100 1980 1970 1900 1940 1970 1970
Success message when connecting to tiny trash database file
8 CS 10089 11209 11049 11170 10940 11009 11019 10779 11000 11000 10380 10069 10349 10279 10350 10039 10109 9860 9000 9679 9929 9389 10169 9920 9060 9199 9039 9029 8829 9210 8930
Write note into log when automatic sweep is started
9 CS 1999 2089 2190 2120 2089 2110 2079 2120 2170 2169 2089 1960 2230 2819 1910 1889 1889 1920 2090 1880 1990 1849 2339 2009 1539 1970 1539 1509 1440 1869 1450
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
10 SS 1304 1400 1419 1380 1390 1380 1430 1480 1449 1400 1449 1390 1399 1390 1369 1319 1289 1029 1209 1269 1069 1159 1180 1160 890 799 1029 850 869 899 819
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
11 CS 23514 27380 27330 27329 27309 27180 23470 23700 23849 23680 23450 23240 23880 23539 23490 23400 24090 22930 27779 22440 23920 22579 23000 22880 22230 24849 22420 22680 22210 25240 22539
Increase speed of creating package when number of its functions more than several hundreds
12 SS 21975 25410 25000 25880 25529 25519 21549 21889 22149 22069 21960 21779 22279 22139 21829 21990 21840 22700 21170 24159 21289 25000 22779 20800 21279 23930 20830 20959 21559 21140 20950
Increase speed of creating package when number of its functions more than several hundreds
13 CS 29359 36240 33960 34000 36110 34420 33839 57859 58410 47559 40240 24080 29200 28529 27960 27470 27830 30310 29940 26910 28410 26329 29519 28849 30259 29699 23960 25000 25009 23150 20369
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
14 CS 4989 4609 4000 4690 4689 4650 4810 4560 4650 4529 4589 4000 4730 4549 4470 4000 5980 6809 5799 6070 5890 5980 5870 5850 6029 5179 5169 5859 5440 5519 5400
Performance regression when bulk inserting into table with indices
15 SS 2970 3390 3259 3330 3390 3289 3349 3290 3350 3319 3259 3099 3160 3130 3019 2980 2170 2100 2000 2079 2960 2259 2390 2119 1809 1720 1670 1730 1640 1599 1640
Wrong transaction can be passed to external engine
16 CS 20560 20960 21140 20819 21009 20360 20209 20530 20720 20560 20509 5189
Increase number of formats/versions of views from 255 to 32K
17 SS 19329 19359 19859 19529 19000 19119 19030 19329 19480 19360 19309 3859
Increase number of formats/versions of views from 255 to 32K
18 CS 25420 26089 25969 26100 26030 26140 26039 26129 26130 26039 25910 25470 25620 25610 25470 25569 24940 25239 25039 25009 25070 24769 25170 25370 24220 24590 24210 24230 24389 24809 24230
Sometime it is impossible to cancel\kill connection executing external query
19 CS 1464 1619 1569 1589 1570 1579 1610 1630 1649 1639 1599 1479 1519 1490 1450 1410 1180 1430 1489 1380 1360 1450 1399 1549 1030 1210 1039 1049 1000 1129 1119
Varchar length limit is not enforced when assigning string with trailing spaces in MBCS
20 SS 929 1090 1070 1090 1089 1069 1089 1119 1140 1129 1140 1089 1049 1049 1000 1150 709 720 839 820 859 809 779 769 589 670 579 620 649 600 600
Varchar length limit is not enforced when assigning string with trailing spaces in MBCS
21 CS 1439 1589 1590 1559 1559 1599 1559 1639 1640 1640 1590 1480 1490 1740 1430 1449 1359 1389 1390 1339 1479 1360 1430 1429 1039 1059 1029 1069 1019 1130 1039
Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit
22 SS 954 1079 1079 1109 1110 1079 1079 1090 1109 1120 1099 1039 1039 1109 990 1029 740 740 780 809 910 849 849 919 629 649 650 619 610 629 629
Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit
23 CS 2544 2720 2669 2640 2640 2640 2710 2759 2730 2700 2619 2470 2519 3009 2390 2390 2430 2570 2460 2380 2430 2369 2569 2660 1929 1730 1670 1710 1700 3200 2480
Server is crashing on long GRANT statement
24 SS 1940 1980 1970 2039 1980 1960 2009 1970 2080 2059 2019 1950 1970 1950 1869 1930 1230 1529 1579 1409 1779 1590 1529 1530 1310 1160 1299 1190 1169 4299 7000
Server is crashing on long GRANT statement
25 CS 1529 1669 1619 1620 1610 1659 1619 1690 1690 1670 1670 1529 1609 1549 1529 1700 1329 1380 1430 1339 1549 1350 1409 1420 1099 1179 1029 1129 1009 1480 1460
Alternate quoting does not work on some particular cases
26 SS 989 1129 1119 1140 1139 1119 1120 1120 1170 1170 1139 1090 1089 1099 1059 1069 839 799 799 900 919 829 789 840 639 569 580 579 649 620 630
Alternate quoting does not work on some particular cases
27 CS 1635 1700 1700 1669 1669 1640 1670 1729 1740 1710 1710 1579 1590 1690 1580 1529 1630 1829 1619 1560 1680 1699 1640 1559 1230 1240 1269 1339 1319 1299 1430
Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field
28 SS 1114 1150 1160 1159 1150 1160 1150 1139 1189 1219 1170 1159 1150 1120 1059 1100 1160 1109 1009 1200 1000 1050 1049 990 810 740 869 840 980 859 799
Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field
29 CS 1465 1610 1589 1559 1559 1559 1589 1640 1639 1640 1589 1480 1000 1000 1409 1450 1369 1359 1540 1309 1359 1259 1579 1440 980 1140 1009 1020 940 1610 1670
Server crashes on overflow of division result
30 SS 1039 1079 1069 1090 1089 1079 1099 1080 1120 1100 1089 1059 1079 1039 1019 1039 740 740 630 789 990 859 829 789 629 669 660 619 630 1440 1420
Server crashes on overflow of division result
31 CS 11985 11949 12150 11740 12090 11620 11799 12089 12000 16909 11970 11640 11470 8450 8340 8269 15400 15660 9859 14859 10160 10080 15099 14819 14370 9139 9650 14299 14259 129990 130159
Wire compression causes freezes
32 SS 10070 10310 9930 9809 10210 9670 9509 10539 10409 9789 10480 9840 9309 6899 6840 6680 9190 13319 13259 8559 13450 8119 8000 13169 12569 7760 13559 12440 13019 128000 128009
Wire compression causes freezes
33 CS 2579 2700 2639 2660 2619 2649 2650 2740 2000 2690 2650 2480 2489 2559 2579 2839 2000 2620 2569 2490 2720 2359 2000 2579 1819 1900 1699
Computed field could be wrongly evaluated as NULL
34 SS 1644 1730 1710 1759 1730 1710 1730 1000 1790 1789 1830 1649 1730 1680 1639 1700 1359 1430 1389 1390 1490 1270 1450 1440 1150 1129 1230
Computed field could be wrongly evaluated as NULL
35 CS 3804 5430 4309 4359 5210 4269 4319 4360 4809 4319 4019 3680 3930 3929 4759 2859 2790 2900 2839 2629 2929 2709 3000 2939 2200 2330 2119
Better diagnostic when 'Missing security context'
36 SS 2569 2779 2789 2740 2769 2759 3779 2799 2759 2789 2640 2619 2569 2599 2569 1539 1380 1109 1000 1359 1350 1349 1620 1200 1119 1079 980
Better diagnostic when 'Missing security context'
37 CS 8374 9069 8910 9150 8849 8890 8879 9079 9059 8980 9240 8399 8769 8800 8349 8339 7730 7829 7890 7450 7810 7279 6279 6600 5319 5000 5220
Space in database path prevent working gbak -se ... -b "pat to/database" backup
38 SS 7085 7390 7330 7349 7460 7360 7240 7359 7550 7460 7420 7070 7380 7220 6920 7100 5259 5880 5340 5920 6189 5000 4619 4390 3900 3819 3979
Space in database path prevent working gbak -se ... -b "pat to/database" backup
39 CS 26720 26839 26799 26849 26730 26730 26740 27509 27109 26930 26940 26380 26990 26470 26450 26529 24269 26710 29899 26899 25819 22830 23380 23269 22700 25389 22799
FB crashes on attempt to create table with number of fields greater than 5460
40 SS 25009 25319 25039 25059 24990 25019 24909 25100 25240 25130 24899 25019 24990 24900 25000 24929 24079 22879 22779 27819 25210 37180 24480 22920 22759 26549 34600
FB crashes on attempt to create table with number of fields greater than 5460
41 CS 4319 4150 4160 4100 4259 4369 4100 4259 4230 4149 4100 3939 4269 4019 5400 5470 7000 6319 5529 9540 24319 24700 40210 3869 3610 3690 18590 38419 20000 5700 23050
gfix cannot set big value for buffers
42 SS 3559 3509 3509 3540 3559 3480 3560 3559 3559 3549 3549 3450 3539 3479 4879 4940 3410 7680 4019 3569 4220 4819 12360 3199 2839 3180 14680 4380 4819 4950 4629
gfix cannot set big value for buffers
43 CS 2200 2309 2209 2200 2190 2179 2210 2289 2279 2220 2199 2000 2059 2039
COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
44 SS 1450 1449 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
45 CS 1579 1629 1609 1560 1579 1579 1560 1640 1639 1590 1579 1470 1540 1480 1410
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
46 SS 1084 1159 1079 1100 1079 1070 1090 1090 1110 1120 1090 1039 1059 1059 1019
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
47 CS 3630 3740 3620 3740 3620 3650 3619 3799 3810 3710 3630 3380 3429 3480
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
48 SS 2340 2340 2320 2359 2340 2309 2339 2359 2419 2589 2000 2230 2380 2000
User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
49 CS 1589 1590 1589 1589 1569 1559 1569 1660 1619 1609 1609 1490 1550
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
50 SS 1089 1089 1079 1090 1079 1079 1069 1090 1100 1109 1089 1060 1129
Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
51 CS 1604 1629 1579 1589 1609 1599 1589 1640 1670 1609 1589 1470 1609
CAST of Infinity values to FLOAT doesn't work
52 SS 1084 1140 1079 1440 1079 1079 1080 1089 1120 1129 1090 1049 1079
CAST of Infinity values to FLOAT doesn't work
53 CS 5465 5710 5460 5539 5000 5920 5430 5799 5470 5410 5559 5240 5160
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
54 SS 3910 3869 3820 3980 3880 3850 3959 3920 3960 3910 3929 3820 3910
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
55 CS 1635 1680 1629 1620 1620 1659 1640 1720 1670 1650 1630 1529 1559
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
56 SS 1139 1150 1139 1129 1139 1159 1140 1139 1159 1190 1160 1089 1119
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
57 CS 1649 1680 1660 1689 1629 1600 1599 1700 1699 1659 1640 1529 1589
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
58 SS 1139 1139 1120 1170 1140 1100 1109 1140 1150 1170 1140 1089 1110
Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
59 CS 2264 2329 2240 2260 2240 2269 2000 2369 2340 2290 2229 2099 3640
Implementation of SUBSTRING for UTF8 character set is inefficient
60 SS 1589 1600 1579 1609 1569 1579 1540 1589 1670 1599 1589 1529 3079
Implementation of SUBSTRING for UTF8 character set is inefficient
61 CS 7440 7809 7340 7359 7440 7549 7480 8000 7350 6830
Many indexed reads in a compound index with NULLs [CORE2709]
62 SS 5650 5710 5650 5620 5629 5710 5819 5740 5410 5310
Many indexed reads in a compound index with NULLs [CORE2709]
63 CS 6980 6789 6710 6610 6730 6980 6710 9690 9649 9609 9339 9119
Getting "records fetched" for functions/procedures in trace
64 SS 5490 5429 5440 5490 5460 5429 5460 8309 8329 8410 8129 8029
Getting "records fetched" for functions/procedures in trace
65 CS 3940 0 0 0 0 0 0 3940
Crash occurs when use SIMILAR TO ...
66 SS 5850 0 0 0 0 0 0 5850
Crash occurs when use SIMILAR TO ...
67 CS 1869 1950 1869 1960 1860 1869 1839
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
68 SS 1319 1309 1309 1329 1340 1329 1290
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
69 CS 1639 1639
DATEDIFF does not support fractional value for MILLISECOND
70 SS 1090 1090
DATEDIFF does not support fractional value for MILLISECOND
71 CS 2569 2719 2630 2579 2630 2000 2549 2590 2549 2660 2630 2559 2529 2480 2440 2310 3159 3160 3119 3069 2920 3000 2850 2950 2360 2279 2240 2470 2159 2450 2170
INNER JOIN join order
72 SS 1869 1870 2000 1899 1890 1869 1809 1799 1910 1869 1940 1940 1839 1000 1740 1810 2240 2370 2169 2099 1990 2089 2089 1990 1589 1759 1670 1860 1690 1779 1590
INNER JOIN join order
73 CS 2054 2200 2240 2190 2159 2170 2169 2270 2000 2220 2139 2009 2080 2069 2019 1980 2029 2290 2009 2059 2049 1830 2190 1969 1519 1519 1460 1470 1490 3539 1519
LEFT OUTER JOIN with full match, but limited in ON clause
74 SS 1235 1480 1450 1460 1449 1460 1450 1000 1000 1000 1470 1390 1439 1470 1359 1449 1230 1269 1170 1210 1330 1160 1129 1180 939 899 910 980 949 950 1240
LEFT OUTER JOIN with full match, but limited in ON clause
75 CS 2054 2289 2000 2000 2149 2160 2170 2000 2259 2200 2150 2009 2059 2129 2109 1920 2140 3039 2059 2050 2039 1850 2140 2059 1549 1969 1410 1569 1759 1579 1629
LEFT OUTER JOIN with STARTING WITH in WHERE clause
76 SS 1249 1480 1429 1470 1460 1440 1450 1480 1000 1000 1529 1419 1480 1399 1410 1430 1289 1099 1210 1140 1029 1200 1310 1159 879 939 919 929 1090 970 1170
LEFT OUTER JOIN with STARTING WITH in WHERE clause
77 CS 1579 1770 1680 1000 1730 1700 1690 1000 1000 1700 1720 1559 1610 1570 1579 1579 1639 1529 1620 1519 1630 1360 1560 1580 1190 1279 1169
Check list of files in the current Firebird snapshot
78 SS 1084 1230 1110 1120 1090 1119 1129 1139 1170 1159 1160 1099 1099 1090 1079 1049 810 799 779 870 700 839 940 770 629 620 630
Check list of files in the current Firebird snapshot
79 CS 1460 1620 1589 1590 1579 1589 1589 1639 1660 1630 1589 1000 1740 1470 1000 2669 1319 1379 1450 1350 1470 1220 1519 1430 1060 1190 1039 990 1099 1209 1149
Empty DB - RDB$ROLES
80 SS 1059 1099 1079 1089 1129 1079 1079 1089 1110 1170 1109 1059 1099 1079 1079 1109 820 769 840 799 629 0 940 809 619 630 680 569 630 670 609
Empty DB - RDB$ROLES
81 CS 1589 1000 1680 1720 1680 1700 1700 1759 1829 1710 1700 1589 1689 2509 1549 1920 1340 1540 1589 1680 1630 1399 1559 1480 1179 1279 1140 1029 1109 1320 1310
Empty DB - RDB$SECURITY_CLASSES
82 SS 1085 1200 1200 1200 1200 1180 1180 1220 1240 1230 1220 1150 1200 1850 1180 1180 949 890 819 819 1020 910 940 900 670 710 720 650 669 730 640
Empty DB - RDB$SECURITY_CLASSES
83 CS 1729 1950 1930 1949 1910 1960 1950 1980 1980 1950 1939 1779 1849 1860 1720 1729 1520 1690 1730 1829 1649 1430 1690 1630 1259 1380 1230 1529 1240 1329 1349
Empty DB - RDB$USER_PRIVILEGES
84 SS 1000 1259 1000 1000 1230 1230 1230 1000 1269 1279 1000 1200 1270 1279 1129 1230 910 890 800 960 799 890 959 920 700 740 670 0 700 670 660
Empty DB - RDB$USER_PRIVILEGES
85 CS 1450 1649 1620 1579 1559 1590 1559 1630 1650 1610 1590 1460 1490 1589 1450 1619 1190 1420 1379 1380 1410 1000 1409 1450 1030 1069 980 1009 969 1090 1049
ISQL - SHOW DATABASE
86 SS 1029 1099 1090 1110 1089 1069 1070 1109 1129 1140 1120 1039 1090 1129 1200 1029 0 790 819 859 660 689 899 769 630 679 680 549 580 650 640
ISQL - SHOW DATABASE
87 CS 2000 2160 2160 2160 2120 2110 2129 2200 2209 2210 2190 1970 2000 2000 1940 1890 2150 1940 1929 2870 2019 1680 1930 2159 1409 1519 1359 1430 1389 1549 1579
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.
88 SS 1475 1600 1559 1569 1580 1559 1560 1569 1620 1619 1639 1519 1529 1509 1480 1470 1349 1210 1170 1000 1130 1210 1130 1150 979 880 940 1869 990 950 900
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.
89 CS 1985 2200 2159 2170 2139 2139 2160 2230 2230 2219 2150 1960 2000 1980 1940 1879 1990 2000 1900 2889 1990 1680 1890 1920 1420 1509 1390 1619 1420 1769 1609
CREATE DATABASE - Multi file DB
90 SS 1445 1639 1610 1629 1629 1600 1599 1640 1669 1670 1640 1539 1570 1559 1000 1480 1410 1200 1309 1490 1189 1000 1169 1220 950 1000 1039 940 990 1009 939
CREATE DATABASE - Multi file DB
91 CS 1960 2230 2160 2169 2150 2180 2180 2000 2000 2230 2149 1950 2039 2029 1899 1970 1929 2159 1869 2540 1929 1659 1939 1819 1399 1819 1450 1410 1490 1690 1769
CREATE DATABASE - Multi file DB - starting
92 SS 1509 1650 1619 1640 1610 1609 1629 1619 1670 1669 1640 1559 1559 1549 1579 1470 1329 1130 1440 1580 1050 1279 1180 1000 1019 1139 1080 1059 949 970 910
CREATE DATABASE - Multi file DB - starting
93 CS 6935 6240 6610 6000 6589 6519 6730 6980 6570 7029 6210 6009 6109 6579 6030 5889 7369 8560 7039 7290 7790 7490 8799 7689 9359 11090 7230 6890 7759 6700 10740
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
94 CS 1460 1619 1590 1609 1620 1569 1610 1639 1640 1640 1590 1480 1600 1529 1519 1420 1349 1419 1440 1370 1789 1310 1419 1420 1049 1109 1039 1079 1000 1059 1149
test de la fonction datediff pour avoir le resultat en minute
95 SS 1019 1130 1110 1089 1069 1089 1079 1089 1109 1109 1089 1039 1109 1110 1019 1019 830 0 690 810 669 839 779 829 590 660 610 589 720 600 599
test de la fonction datediff pour avoir le resultat en minute
96 CS 1480 1619 1610 1589 1560 1599 1609 1670 1650 1610 1610 1000 1780 1609 1450 1519 1339 1480 1380 1400 1480 1279 1420 1480 1110 1099 1000 1049 1089 1079 1169
CREATE ROLE
97 SS 1030 1109 1069 1089 1099 1069 1089 1089 1140 1129 1110 1040 1060 1039 1030 1130 850 910 0 929 929 819 920 839 619 649 640 589 650 689 670
CREATE ROLE

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1885
http://tracker.firebirdsql.org/browse/core-2484
http://tracker.firebirdsql.org/browse/core-2668
http://tracker.firebirdsql.org/browse/core-284
http://tracker.firebirdsql.org/browse/core-2977
http://tracker.firebirdsql.org/browse/core-4880
http://tracker.firebirdsql.org/browse/core-501
http://tracker.firebirdsql.org/browse/core-5034
http://tracker.firebirdsql.org/browse/core-5302
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-6310
http://tracker.firebirdsql.org/browse/core-6314
http://tracker.firebirdsql.org/browse/core-6317
http://tracker.firebirdsql.org/browse/core-6340
http://tracker.firebirdsql.org/browse/core-6343
http://tracker.firebirdsql.org/browse/core-6345
http://tracker.firebirdsql.org/browse/core-6348
http://tracker.firebirdsql.org/browse/core-6351
http://tracker.firebirdsql.org/browse/core-6362
http://tracker.firebirdsql.org/browse/core-6392
http://tracker.firebirdsql.org/browse/core-6411
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/gtcs/cast-datatypes.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/6782
https://github.com/FirebirdSQL/firebird/issues/6854
https://github.com/FirebirdSQL/firebird/issues/6866
https://github.com/FirebirdSQL/firebird/issues/6987

=== end of list ===