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

Generated 23.02.2021 10:14
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
Loading data. Please wait...

Tests with result = "PASSED" after previous outcome = FAIL/ERROR/SKIPPED or absent:

Jump to LIST of unique test names from this report

NN Test name mode 3.0.8.33420
2021-02-23
3.0.8.33418
2021-02-18
3.0.8.33416
2021-02-16
3.0.8.33415
2021-02-15
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
Test TITLE
1 SS P     E         E         E     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
Expression index can be created while doing inserts into table
2 SS P     E         E         E     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
Support hex numeric and string literals
3 CS P     E         E         E     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
Some standard calls show server installation directory to regular users
4 SS P     E         E         E     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
Some standard calls show server installation directory to regular users
5 CS P     E         E         E     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
BLR error on restore database with computed by Field
6 SS P     E         E         E     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
BLR error on restore database with computed by Field
7 CS P     E         E         E     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
ALTER USER XXX INACTIVE
8 SS P     E         E         E     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
ALTER USER XXX INACTIVE
9 CS P     E         E         E     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
Query plan is missing for the long query
10 SS P     E         E         E     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
Query plan is missing for the long query
11 CS P     E         E         E     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
Add support for -nodbtriggers switch in gbak into services API
12 SS P     E         E         E     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
Add support for -nodbtriggers switch in gbak into services API
13 CS P     E         E         E     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
New gbak option to ignore specific tables data during the backup
14 SS P     E         E         E     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
New gbak option to ignore specific tables data during the backup
15 CS P     E         E         E     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
gbak doesn't return error code
16 SS P     E         E         E     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
gbak doesn't return error code
17 CS P     E         E         E     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
Incomplete API information values
18 SS P     E         E         E     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
Incomplete API information values
19 CS P     E         E         E     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
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
20 SS P     E         E         E     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
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
21 CS P     E         E         E     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
mon$memory_usage: Sorting memory should be reported as owned by the statement
22 SS P     E         E         E     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
mon$memory_usage: Sorting memory should be reported as owned by the statement
23 CS P     E         E         E     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
Write note into log when automatic sweep is started
24 SS P     E         E         E     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
Write note into log when automatic sweep is started
25 CS P     E         E         E     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
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
26 SS P     E         E         E     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
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
27 CS P     E         E         E     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
isql extracts the array dimensions after the character set name
28 SS P     E         E         E     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
isql extracts the array dimensions after the character set name
29 CS P     E         E         E     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
Cannot remove user with dot in login
30 SS P     E         E         E     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
Cannot remove user with dot in login
31 CS P     E         E         E     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
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
32 SS P     E         E         E     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
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
33 CS P     E         E         E     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
Trace output could contain garbage data left from filtered out statements
34 SS P     E         E         E     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
Trace output could contain garbage data left from filtered out statements
35 CS P     E         E         E     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
Error in Trace plugin (use local symbols in query)
36 SS P     E         E         E     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
Error in Trace plugin (use local symbols in query)
37 CS P     E         E         E     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
Add attachment's CHARACTER SET name into corresponding trace records
38 SS P     E         E         E     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
Add attachment's CHARACTER SET name into corresponding trace records
39 CS P     E         E         E     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
page 0 is of wrong type (expected 6, found 1)
40 SS P     E         E         E     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
page 0 is of wrong type (expected 6, found 1)
41 CS P     E         E         E     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
Ability to cancel waiting in lock manager
42 SS P     E         E         E     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
Ability to cancel waiting in lock manager
43 CS P     E         E         E     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
Client writes error messages into firebird.log when database is shutted down
44 SS P     E         E         E     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
Client writes error messages into firebird.log when database is shutted down
45 CS P     E         E         E     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
Improve diagnostics of internal trace errors
46 SS P     E         E         E     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
Improve diagnostics of internal trace errors
47 CS P     E         E         E     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
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
48 SS P     E         E         E     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
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
49 CS P     E         E         E     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
Plan returned for query with recursive CTE return wrong count of parenthesis
50 SS P     E         E         E     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
Plan returned for query with recursive CTE return wrong count of parenthesis
51 CS P     E         E         E     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
Segfault when closing attachment to database
52 SS P     E         E         E     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
Segfault when closing attachment to database
53 CS P     F         F         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
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
54 SS P     F         F         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
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
55 CS P     E         E         E     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
Server crashes on preparing empty query when trace is enabled
56 SS P     E         E         E     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
Server crashes on preparing empty query when trace is enabled
57 CS P     E         E         E     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
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
58 SS P     E         E         E     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
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
59 CS P     E         E         E     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
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
60 SS P     E         E         E     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
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
61 CS P     E         E         E     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
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
62 SS P     E         E         E     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
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
63 CS P     E         E         E     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
Wrong parameters order in trace output
64 SS P     E         E         E     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
Wrong parameters order in trace output
65 CS P     E         E         E     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
gbak -r fails in restoring all stored procedures/functions in packages
66 SS P     E         E         E     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
gbak -r fails in restoring all stored procedures/functions in packages
67 CS P     E         E         E     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
In SS sweep blocks establishment of concurrent attachments
68 SS P     E         E         E     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
In SS sweep blocks establishment of concurrent attachments
69 CS P     E         E         E     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
Add database owner to mon$database
70 SS P     E         E         E     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
Add database owner to mon$database
71 CS P     E         E         E     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
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
72 SS P     E         E         E     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
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
73 CS P     E         E         E     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
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
74 SS P     E         E         E     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
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
75 CS P     E         E         E     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
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
76 SS P     E         E         E     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
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
77 CS P     E         E         E     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
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
78 SS P     E         E         E     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
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
79 CS P     E         E         E     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
Ability to trace stored functions execution
80 SS P     E         E         E     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
Ability to trace stored functions execution
81 CS P     E         E         E     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
ISQL truncates blob when reading an empty segment
82 SS P     E         E         E     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
ISQL truncates blob when reading an empty segment
83 CS P     E         E         E     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
Allow output to trace explain plan form.
84 SS P     E         E         E     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
Allow output to trace explain plan form.
85 CS P     E         E         E     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
Implement ability to validate tables and indices online (without exclusive access to database)
86 SS P     E         E         E     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
Implement ability to validate tables and indices online (without exclusive access to database)
87 CS P     E         E         E     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
Prohibit an ability to issue DML or DDL statements on RDB$ tables
88 SS P     E         E         E     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
Prohibit an ability to issue DML or DDL statements on RDB$ tables
89 CS P     E         E         E     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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
90 SS P     E         E         E     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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
91 CS P     E         E         E     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
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
92 SS P     E         E         E     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
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
93 SS P     E         E         E     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
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
94 CS P     E         E         E     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
CREATE DATABASE fail with ISQL
95 SS P     E         E         E     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
CREATE DATABASE fail with ISQL
96 CS P     E         E         E     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
Minor inconvenience in user management via services API
97 SS P     E         E         E     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
Minor inconvenience in user management via services API
98 CS P     E         E         E     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
Index corruption when add data in long-key-indexed field
99 SS P     E         E         E     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
Index corruption when add data in long-key-indexed field
100 CS P     E         E         E     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
IIF function prevents the condition from being pushed into the union for better optimization
101 SS P     E         E         E     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
IIF function prevents the condition from being pushed into the union for better optimization
102 CS P     E         E         E     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
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
103 SS P     E         E         E     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
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
104 CS P     E         E         E     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
Both client and server could not close connection after failed authentification
105 SS P     E         E         E     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
Both client and server could not close connection after failed authentification
106 CS P     E         E         E     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
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
107 SS P     E         E         E     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
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
108 CS P     E         E         E     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
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
109 SS P     E         E         E     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
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
110 CS P     E         E         E     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
"Invalid BLOB ID" error
111 SS P     E         E         E     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
"Invalid BLOB ID" error
112 CS P     E         E         E     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
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
113 SS P     E         E         E     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
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
114 CS P     E         E         E     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
ISQL extract command looses COMPUTED BY field types
115 SS P     E         E         E     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
ISQL extract command looses COMPUTED BY field types
116 CS P     E         E         E     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
Indices on computed fields are broken after restore (all keys are NULL)
117 SS P     E         E         E     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
Indices on computed fields are broken after restore (all keys are NULL)
118 CS P     E         E         E     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
Expression index may not be used by the optimizer if created and used in different connection charsets
119 SS P     E         E         E     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
Expression index may not be used by the optimizer if created and used in different connection charsets
120 CS P     E         E         E     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
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
121 SS P     E         E         E     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
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
122 CS P     E         E         E     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
Regression: line/column numbering may be twisted if alias.name syntax is used
123 SS P     E         E         E     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
Regression: line/column numbering may be twisted if alias.name syntax is used
124 CS P     E         E         E     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
Invalid computed by definition generated by isql -x
125 SS P     E         E         E     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
Invalid computed by definition generated by isql -x
126 CS P     E         E         E     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
Return nonzero result code when restore fails on activating and creating deferred user index
127 SS P     E         E         E     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
Return nonzero result code when restore fails on activating and creating deferred user index
128 CS P     E         E         E     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
ISQL -X may generate invalid GRANT USAGE statements for domains
129 SS P     E         E         E     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
ISQL -X may generate invalid GRANT USAGE statements for domains
130 CS P     E         E         E     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
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
131 SS P     E         E         E     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
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
132 CS P     E         E         E     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
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
133 SS P     E         E         E     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
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
134 CS P     E         E         E     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
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
135 SS P     E         E         E     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
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
136 CS P     E         E         E     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
Validation could read after the end-of-file when handle multifile database
137 SS P     E         E         E     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
Validation could read after the end-of-file when handle multifile database
138 CS P     F     P P 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
Performance regression when bulk inserting into table with indices
139 CS P     E         E         E     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
Database gets partially corrupted in the "no-reserve" mode
140 SS P     E         E         E     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
Database gets partially corrupted in the "no-reserve" mode
141 SS P     E         E         E     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
BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
142 CS P     E         E         E     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
Inconsistent output when retrieving the server log via Services API
143 SS P     E         E         E     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
Inconsistent output when retrieving the server log via Services API
144 CS P     E         E         E     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
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
145 CS P     E         E         E     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
Bugcheck 167 (invalid SEND request)
146 SS P     E         E         E     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
Bugcheck 167 (invalid SEND request)
147 CS P     E         E         E     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
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
148 SS P     E         E         E     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
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
149 CS P     E         E         E     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
Provide ability to filter out info and warnings from trace log
150 SS P     E         E         E     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
Provide ability to filter out info and warnings from trace log
151 CS P     E         E         E     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
Bad performance for NULLs filtering inside a navigational index scan
152 SS P     E         E         E     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
Bad performance for NULLs filtering inside a navigational index scan
153 CS P     E         E         E     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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
154 SS P     E         E         E     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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
155 CS P     E         E         E     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
Bugcheck on queries containing WITH LOCK clause
156 SS P     E         E         E     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
Bugcheck on queries containing WITH LOCK clause
157 CS P     E         E         E     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
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
158 SS P     E         E         E     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
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
159 CS P     E         E         E     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
Part of the pages of the second level blobs is not released when deleting relations.
160 SS P     E         E         E     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
Part of the pages of the second level blobs is not released when deleting relations.
161 CS P     E         E         E     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
Wrong transaction can be passed to external engine
162 SS P     E         E         E     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
Wrong transaction can be passed to external engine
163 CS P     E         E         E     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
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
164 SS P     E         E         E     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
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
165 CS P     E         E         E     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
Bad PLAN generated for query on Firebird v3.0
166 SS P     E         E         E     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
Bad PLAN generated for query on Firebird v3.0
167 CS P     E         E         E     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
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
168 SS P     E         E         E     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
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
169 CS P     E         E         E     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
Trace config with misplaced "{" lead firebird to crash
170 SS P     E         E         E     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
Trace config with misplaced "{" lead firebird to crash
171 CS P     E         E         E     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
FB >= 3 crashes when restoring backup made by FB 2.5.
172 SS P     E         E         E     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
FB >= 3 crashes when restoring backup made by FB 2.5.
173 CS P     E         E         E     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
Invalid parameters of gds transaction in ISQL
174 SS P     E         E         E     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
Invalid parameters of gds transaction in ISQL
175 CS P     E         E         E     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
User with DROP DATABASE privilege can't drop database
176 SS P     E         E         E     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
User with DROP DATABASE privilege can't drop database
177 CS P     E         E         E     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
Server crashes on preparing empty query when trace is enabled
178 SS P     E         E         E     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
Server crashes on preparing empty query when trace is enabled
179 CS P     E         E         E     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
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
180 SS P     E         E         E     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
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
181 CS P     E         E         E     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
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
182 SS P     E         E         E     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
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
183 CS P     E         E         E     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
External engine trigger crashing server if table have computed field
184 SS P     E         E         E     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
External engine trigger crashing server if table have computed field
185 CS P     E         E         E     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
Creator user name is empty in user trace sessions
186 SS P     E         E         E     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
Creator user name is empty in user trace sessions
187 CS P     E         E         E     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
gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
188 SS P     E         E         E     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
gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
189 CS P     E         E         E     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
Trigger on system table restored in FB3 database and can't be deleted
190 SS P     E         E         E     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
Trigger on system table restored in FB3 database and can't be deleted
191 CS P     E         E         E     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
Permissions for create or alter statements are not checked
192 SS P     E         E         E     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
Permissions for create or alter statements are not checked
193 CS P     E         E         E     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
BLOBs are unnecessarily copied during UPDATE after a table format change
194 SS P     E         E         E     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
BLOBs are unnecessarily copied during UPDATE after a table format change
195 CS P     E         E         E     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
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
196 SS P     E         E         E     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
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
197 CS P     E         E         E     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
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
198 SS P     E         E         E     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
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
199 CS P     E         E         E     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
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
200 SS P     E         E         E     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
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
201 CS P     E         E         E     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
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
202 SS P     E         E         E     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
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
203 CS P     E         E         E     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
Wrong dependencies of stored function on view after backup and restore
204 SS P     E         E         E     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
Wrong dependencies of stored function on view after backup and restore
205 CS P     E         E         E     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
Signature mismatch when creating package body on identical packaged procedure header
206 SS P     E         E         E     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
Signature mismatch when creating package body on identical packaged procedure header
207 CS P     E         E         E     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
mapping rules destroyed by backup / restore
208 SS P     E         E         E     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
mapping rules destroyed by backup / restore
209 CS P     E         E         E     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
fbsvcmgr can not decode information buffer returned by gfix list limbo service
210 SS P     E         E         E     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
fbsvcmgr can not decode information buffer returned by gfix list limbo service
211 CS P     E         E         E     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
NBACKUP locks db file on error
212 SS P     E         E         E     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
NBACKUP locks db file on error
213 CS P     E         E         E     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
FB crashes on attempt to create table with number of fields greater than 5460
214 SS P     E         E         E     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
FB crashes on attempt to create table with number of fields greater than 5460
215 CS P     E         E         E     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
gfix cannot set big value for buffers
216 SS P     E         E         E     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
gfix cannot set big value for buffers
217 CS P     E         E         E     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
FULL OUTER JOIN, list all values
218 SS P     E         E         E     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
FULL OUTER JOIN, list all values
219 CS P     E         E         E     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
FULL OUTER JOIN, list all values, but filtered in WHERE clause
220 SS P     E         E         E     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
FULL OUTER JOIN, list all values, but filtered in WHERE clause
221 CS P     E         E         E     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
FULL OUTER JOIN, list all values, but filtered in WHERE clause
222 SS P     E         E         E     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
FULL OUTER JOIN, list all values, but filtered in WHERE clause
223 CS P     E         E         E     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
FULL OUTER JOIN, list all values, but filtered in WHERE clause
224 SS P     E         E         E     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
FULL OUTER JOIN, list all values, but filtered in WHERE clause
225 CS P     E         E         E     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
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
226 SS P     E         E         E     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
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
227 CS P     E         E         E     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
GTCS/tests/AUTO_COMMIT.1.ESQL. AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued.
228 SS P     E         E         E     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
GTCS/tests/AUTO_COMMIT.1.ESQL. AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued.
229 CS P     E         E         E     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
GTCS/tests/AUTO_COMMIT.2.ESQL. Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER.
230 SS P     E         E         E     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
GTCS/tests/AUTO_COMMIT.2.ESQL. Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER.
231 CS P     E     P P 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
Check ability to make connect to FB services and add/drop user.
232 SS P     E     P P 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
Check ability to make connect to FB services and add/drop user.

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.8.33420
2021-02-23
3.0.8.33418
2021-02-18
3.0.8.33416
2021-02-16
3.0.8.33415
2021-02-15
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
Test TITLE
1 SS 1365 36769 1310 1269 1420
Expression index can be created while doing inserts into table
2 SS 530 1050 410 420 640
Support hex numeric and string literals
3 CS 1054 2950 949 1089 1019
Some standard calls show server installation directory to regular users
4 SS 529 1830 519 509 539
Some standard calls show server installation directory to regular users
5 CS 1680 3559 1609 1740 1620
BLR error on restore database with computed by Field
6 SS 1294 2830 1259 1309 1279
BLR error on restore database with computed by Field
7 CS 1104 3529 1039 1069 1140
ALTER USER XXX INACTIVE
8 SS 874 2730 880 869 789
ALTER USER XXX INACTIVE
9 CS 770 2740 960 559 580
Query plan is missing for the long query
10 SS 410 2460 400 420 380
Query plan is missing for the long query
11 CS 2080 2309 2230 1930 1519
Add support for -nodbtriggers switch in gbak into services API
12 SS 1539 1920 1339 1740 1309
Add support for -nodbtriggers switch in gbak into services API
13 CS 2000 3230 1879 1900 2100
New gbak option to ignore specific tables data during the backup
14 SS 1755 2940 1690 1820 1650
New gbak option to ignore specific tables data during the backup
15 CS 784 2210 779 789 779
gbak doesn't return error code
16 SS 545 1160 540 480 550
gbak doesn't return error code
17 CS 844 2160 869 700 819
Incomplete API information values
18 SS 504 1849 480 519 490
Incomplete API information values
19 CS 2234 4900 2690 1669 1779
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
20 SS 1459 4269 1000 1439 1480
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
21 CS 1590 9339 1610 1550 1570
mon$memory_usage: Sorting memory should be reported as owned by the statement
22 SS 1214 9480 1220 1209 1179
mon$memory_usage: Sorting memory should be reported as owned by the statement
23 CS 635 7000 640 630 590
Write note into log when automatic sweep is started
24 SS 424 7920 429 410 419
Write note into log when automatic sweep is started
25 CS 1674 3859 1709 1570 1640
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
26 SS 1424 3560 1339 1359 1490
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
27 CS 604 2879 609 600 599
isql extracts the array dimensions after the character set name
28 SS 429 2490 399 439 420
isql extracts the array dimensions after the character set name
29 CS 669 3170 609 730 579
Cannot remove user with dot in login
30 SS 425 2360 420 430 420
Cannot remove user with dot in login
31 CS 624 4710 629 619 609
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
32 SS 399 5660 380 389 410
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
33 CS 1010 6200 1090 880 930
Trace output could contain garbage data left from filtered out statements
34 SS 619 5759 600 590 639
Trace output could contain garbage data left from filtered out statements
35 CS 934 6470 1000 869 829
Error in Trace plugin (use local symbols in query)
36 SS 604 5849 579 600 609
Error in Trace plugin (use local symbols in query)
37 CS 895 6450 829 900 890
Add attachment's CHARACTER SET name into corresponding trace records
38 SS 615 6039 590 620 610
Add attachment's CHARACTER SET name into corresponding trace records
39 CS 985 1589 990 849 980
page 0 is of wrong type (expected 6, found 1)
40 SS 545 1160 480 600 490
page 0 is of wrong type (expected 6, found 1)
41 CS 1539 2349 1000 1310 1769
Ability to cancel waiting in lock manager
42 SS 1300 1590 1130 1470 1080
Ability to cancel waiting in lock manager
43 CS 1314 5189 1259 1330 1299
Client writes error messages into firebird.log when database is shutted down
44 SS 1130 5090 970 1150 1110
Client writes error messages into firebird.log when database is shutted down
45 CS 940 6190 930 950 839
Improve diagnostics of internal trace errors
46 SS 639 5859 619 599 660
Improve diagnostics of internal trace errors
47 CS 2079 8289 2009 1990 2149
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
48 SS 2224 8589 1679 2769 1680
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
49 CS 1334 2789 1319 1309 1349
Plan returned for query with recursive CTE return wrong count of parenthesis
50 SS 1175 2000 1089 1240 1110
Plan returned for query with recursive CTE return wrong count of parenthesis
51 CS 834 2460 880 780 789
Segfault when closing attachment to database
52 SS 579 1969 600 490 559
Segfault when closing attachment to database
53 CS 1199 1200 1769 1199 1000
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
54 SS 875 880 880 870 859
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
55 CS 874 7029 869 879 770
Server crashes on preparing empty query when trace is enabled
56 SS 549 6650 529 559 539
Server crashes on preparing empty query when trace is enabled
57 CS 629 18960 619 580 639
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
58 SS 430 18379 390 450 410
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
59 CS 934 5479 909 869 960
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
60 SS 705 5040 700 710 619
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
61 CS 1214 2029 1579 779 849
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
62 SS 529 1559 529 530 529
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
63 CS 1040 4579 1080 960 1000
Wrong parameters order in trace output
64 SS 824 4019 779 869 720
Wrong parameters order in trace output
65 CS 2569 3789 2309 2170 2829
gbak -r fails in restoring all stored procedures/functions in packages
66 SS 2044 3210 2029 2029 2060
gbak -r fails in restoring all stored procedures/functions in packages
67 CS 704 29450 660 710 699
In SS sweep blocks establishment of concurrent attachments
68 SS 440 84980 420 460 409
In SS sweep blocks establishment of concurrent attachments
69 CS 940 2269 909 970 910
Add database owner to mon$database
70 SS 665 2160 620 710 599
Add database owner to mon$database
71 CS 930 22700 920 940 920
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
72 SS 685 45990 639 680 690
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
73 CS 769 11890 0 769 759
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
74 SS 539 11609 539 509 0
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
75 CS 2204 4190 2130 2279 1889
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
76 SS 1599 3740 1609 1589 1589
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
77 CS 700 15830 700 600 700
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
78 SS 440 51449 439 440 440
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
79 CS 1164 9009 1259 1000 1070
Ability to trace stored functions execution
80 SS 1190 8349 1000 1380 970
Ability to trace stored functions execution
81 CS 970 1259 950 990 950
ISQL truncates blob when reading an empty segment
82 SS 799 809 759 789 849
ISQL truncates blob when reading an empty segment
83 CS 1114 7490 1119 1109 1029
Allow output to trace explain plan form.
84 SS 809 7069 820 799 799
Allow output to trace explain plan form.
85 CS 3269 7150 3420 2519 3119
Implement ability to validate tables and indices online (without exclusive access to database)
86 SS 2664 6559 2230 3039 2289
Implement ability to validate tables and indices online (without exclusive access to database)
87 CS 834 16730 799 769 869
Prohibit an ability to issue DML or DDL statements on RDB$ tables
88 SS 529 15149 509 509 550
Prohibit an ability to issue DML or DDL statements on RDB$ tables
89 CS 734 3080 659 799 669
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
90 SS 494 1590 549 389 440
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
91 CS 904 5309 900 789 909
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
92 SS 634 5019 619 650 590
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
93 SS 514 10460 539 490 490
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
94 CS 804 2059 720 719 889
CREATE DATABASE fail with ISQL
95 SS 485 1000 480 470 490
CREATE DATABASE fail with ISQL
96 CS 814 2680 839 789 719
Minor inconvenience in user management via services API
97 SS 549 2389 509 519 579
Minor inconvenience in user management via services API
98 CS 910 2460 0 910 720
Index corruption when add data in long-key-indexed field
99 SS 519 1900 490 519 0
Index corruption when add data in long-key-indexed field
100 CS 3020 8699 3100 2920 2940
IIF function prevents the condition from being pushed into the union for better optimization
101 SS 3304 8059 4000 2370 2609
IIF function prevents the condition from being pushed into the union for better optimization
102 CS 829 2059 839 789 819
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
103 SS 564 1649 559 569 530
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
104 CS 904 3439 990 819 779
Both client and server could not close connection after failed authentification
105 SS 549 2799 579 510 519
Both client and server could not close connection after failed authentification
106 CS 644 1840 650 579 639
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
107 SS 384 1450 390 379 379
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
108 CS 799 6089 759 819 779
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
109 SS 519 4869 480 519 0
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
110 CS 925 3019 889 940 910
"Invalid BLOB ID" error
111 SS 600 2690 590 569 610
"Invalid BLOB ID" error
112 CS 1989 6289 1829 2069 1910
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
113 SS 1634 4209 1669 1590 1599
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
114 CS 1209 3630 1210 1209 1000
ISQL extract command looses COMPUTED BY field types
115 SS 984 3210 940 960 1009
ISQL extract command looses COMPUTED BY field types
116 CS 1349 2920 1279 1309 1390
Indices on computed fields are broken after restore (all keys are NULL)
117 SS 1139 2670 1140 1069 1139
Indices on computed fields are broken after restore (all keys are NULL)
118 CS 1454 2389 1279 1289 1620
Expression index may not be used by the optimizer if created and used in different connection charsets
119 SS 1099 2210 1029 1149 1049
Expression index may not be used by the optimizer if created and used in different connection charsets
120 CS 1989 2919 2430 1430 1549
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
121 SS 1424 2769 1259 1589 1229
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
122 CS 769 2019 769 710 0
Regression: line/column numbering may be twisted if alias.name syntax is used
123 SS 499 1700 490 509 490
Regression: line/column numbering may be twisted if alias.name syntax is used
124 CS 624 3100 610 579 639
Invalid computed by definition generated by isql -x
125 SS 455 2649 470 399 440
Invalid computed by definition generated by isql -x
126 CS 1890 3620 2410 1319 1370
Return nonzero result code when restore fails on activating and creating deferred user index
127 SS 2074 2759 1119 1949 2200
Return nonzero result code when restore fails on activating and creating deferred user index
128 CS 784 2629 859 710 679
ISQL -X may generate invalid GRANT USAGE statements for domains
129 SS 530 2200 580 480 480
ISQL -X may generate invalid GRANT USAGE statements for domains
130 CS 1364 3089 1329 1320 1400
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
131 SS 1189 2000 1169 1089 1210
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
132 CS 810 7870 880 700 740
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
133 SS 534 5589 529 530 539
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
134 CS 1705 15899 1640 1730 1680
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
135 SS 1485 15339 1410 1560 1369
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
136 CS 2474 3640 2430 2000 2519
Validation could read after the end-of-file when handle multifile database
137 SS 2130 3420 2069 2120 2140
Validation could read after the end-of-file when handle multifile database
138 CS 16044 15100 25159 15829 16259
Performance regression when bulk inserting into table with indices
139 CS 909 2440 940 840 879
Database gets partially corrupted in the "no-reserve" mode
140 SS 710 1919 720 690 700
Database gets partially corrupted in the "no-reserve" mode
141 SS 564 13269 549 519 580
BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
142 CS 800 2149 780 779 820
Inconsistent output when retrieving the server log via Services API
143 SS 579 1609 619 539 509
Inconsistent output when retrieving the server log via Services API
144 CS 2020 6070 1850 1519 2190
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
145 CS 744 3850 759 730 589
Bugcheck 167 (invalid SEND request)
146 SS 424 3400 399 450 389
Bugcheck 167 (invalid SEND request)
147 CS 829 5759 819 840 769
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
148 SS 549 5190 539 559 510
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
149 CS 1399 6980 1000 1410 1389
Provide ability to filter out info and warnings from trace log
150 SS 1034 6119 1049 1000 1019
Provide ability to filter out info and warnings from trace log
151 CS 864 6809 839 859 870
Bad performance for NULLs filtering inside a navigational index scan
152 SS 789 6339 549 1029 490
Bad performance for NULLs filtering inside a navigational index scan
153 CS 3514 3649 3779 3380 3169
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
154 SS 3319 3149 2910 4710 3490
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
155 CS 1659 2480 1839 1480 1359
Bugcheck on queries containing WITH LOCK clause
156 SS 1359 2009 1390 1220 1329
Bugcheck on queries containing WITH LOCK clause
157 CS 3460 9929 3590 3000 3330
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
158 SS 3134 9720 3129 2950 3140
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
159 CS 1059 3639 990 1069 1049
Part of the pages of the second level blobs is not released when deleting relations.
160 SS 809 2400 789 779 829
Part of the pages of the second level blobs is not released when deleting relations.
161 CS 1764 2759 1730 1710 1799
Wrong transaction can be passed to external engine
162 SS 1480 2299 1490 1409 1470
Wrong transaction can be passed to external engine
163 CS 910 132200 819 850 970
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
164 SS 534 133900 519 490 549
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
165 CS 914 2990 690 879 950
Bad PLAN generated for query on Firebird v3.0
166 SS 544 2640 519 549 539
Bad PLAN generated for query on Firebird v3.0
167 CS 899 5049 980 780 819
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
168 SS 539 4769 539 529 539
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
169 CS 809 4400 789 740 829
Trace config with misplaced "{" lead firebird to crash
170 SS 644 3809 549 590 699
Trace config with misplaced "{" lead firebird to crash
171 CS 829 2430 890 740 769
FB >= 3 crashes when restoring backup made by FB 2.5.
172 SS 519 2079 509 529 470
FB >= 3 crashes when restoring backup made by FB 2.5.
173 CS 1485 4389 1490 1399 1480
Invalid parameters of gds transaction in ISQL
174 SS 1165 4220 1160 1130 1170
Invalid parameters of gds transaction in ISQL
175 CS 914 2459 849 769 980
User with DROP DATABASE privilege can't drop database
176 SS 569 2000 529 549 590
User with DROP DATABASE privilege can't drop database
177 CS 4349 6000 4280 4419 4019
Server crashes on preparing empty query when trace is enabled
178 SS 3769 5910 3859 3680 3480
Server crashes on preparing empty query when trace is enabled
179 CS 909 2620 929 890 859
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
180 SS 730 2200 740 720 640
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
181 CS 849 3530 779 0 849
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
182 SS 559 3220 570 549 509
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
183 CS 1855 2980 1809 1860 1850
External engine trigger crashing server if table have computed field
184 SS 1524 2000 1559 1420 1490
External engine trigger crashing server if table have computed field
185 CS 849 3069 799 900 730
Creator user name is empty in user trace sessions
186 SS 539 2639 559 519 519
Creator user name is empty in user trace sessions
187 CS 614 1920 640 579 589
gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
188 SS 410 1610 420 400 399
gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
189 CS 799 2629 799 790 0
Trigger on system table restored in FB3 database and can't be deleted
190 SS 529 2449 539 519 480
Trigger on system table restored in FB3 database and can't be deleted
191 CS 1060 3720 1420 640 700
Permissions for create or alter statements are not checked
192 SS 435 3240 460 410 389
Permissions for create or alter statements are not checked
193 CS 764 1620 720 759 769
BLOBs are unnecessarily copied during UPDATE after a table format change
194 SS 514 1330 509 519 509
BLOBs are unnecessarily copied during UPDATE after a table format change
195 CS 759 2950 730 709 789
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
196 SS 1560 2630 0 490 0
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
197 CS 1899 6339 2009 1539 1789
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
198 SS 1570 5740 1410 1730 1339
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
199 CS 889 2059 799 890 889
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
200 SS 650 1820 650 650 609
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
201 CS 7634 9859 7709 6410 7559
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
202 SS 7609 10180 7680 6990 7539
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
203 CS 1709 2359 1740 1679 1659
Wrong dependencies of stored function on view after backup and restore
204 SS 1364 1899 1369 1240 1360
Wrong dependencies of stored function on view after backup and restore
205 CS 1580 3419 1680 1480 1480
Signature mismatch when creating package body on identical packaged procedure header
206 SS 1175 2949 1190 1000 1160
Signature mismatch when creating package body on identical packaged procedure header
207 CS 859 3970 829 789 889
mapping rules destroyed by backup / restore
208 SS 1824 3119 0 529 0
mapping rules destroyed by backup / restore
209 CS 6670 9970 7000 6340 6220
fbsvcmgr can not decode information buffer returned by gfix list limbo service
210 SS 7419 9259 6980 7720 7119
fbsvcmgr can not decode information buffer returned by gfix list limbo service
211 CS 774 3280 789 759 759
NBACKUP locks db file on error
212 SS 509 3200 490 470 529
NBACKUP locks db file on error
213 CS 849 14539 849 0 680
FB crashes on attempt to create table with number of fields greater than 5460
214 SS 14210 14210 0 0 0
FB crashes on attempt to create table with number of fields greater than 5460
215 CS 679 3230 679 680 670
gfix cannot set big value for buffers
216 SS 424 3049 410 430 419
gfix cannot set big value for buffers
217 CS 669 2869 619 669 670
FULL OUTER JOIN, list all values
218 SS 425 2779 420 410 430
FULL OUTER JOIN, list all values
219 CS 640 2740 660 599 620
FULL OUTER JOIN, list all values, but filtered in WHERE clause
220 SS 434 3150 440 429 380
FULL OUTER JOIN, list all values, but filtered in WHERE clause
221 CS 599 2740 609 579 589
FULL OUTER JOIN, list all values, but filtered in WHERE clause
222 SS 440 3339 430 440 440
FULL OUTER JOIN, list all values, but filtered in WHERE clause
223 CS 630 2829 590 600 660
FULL OUTER JOIN, list all values, but filtered in WHERE clause
224 SS 420 2889 390 390 450
FULL OUTER JOIN, list all values, but filtered in WHERE clause
225 CS 849 20100 830 869 730
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
226 SS 599 18930 529 640 559
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
227 CS 749 2609 720 779 700
GTCS/tests/AUTO_COMMIT.1.ESQL. AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued.
228 SS 429 2529 439 419 389
GTCS/tests/AUTO_COMMIT.1.ESQL. AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued.
229 CS 690 2799 650 720 660
GTCS/tests/AUTO_COMMIT.2.ESQL. Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER.
230 SS 445 2550 440 409 450
GTCS/tests/AUTO_COMMIT.2.ESQL. Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER.
231 CS 1069 1069 849 1070 1089
Check ability to make connect to FB services and add/drop user.
232 SS 704 839 549 620 789
Check ability to make connect to FB services and add/drop user.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1746
http://tracker.firebirdsql.org/browse/core-1760
http://tracker.firebirdsql.org/browse/core-1845
http://tracker.firebirdsql.org/browse/core-1865
http://tracker.firebirdsql.org/browse/core-2004
http://tracker.firebirdsql.org/browse/core-2115
http://tracker.firebirdsql.org/browse/core-2197
http://tracker.firebirdsql.org/browse/core-2208
http://tracker.firebirdsql.org/browse/core-2251
http://tracker.firebirdsql.org/browse/core-2307
http://tracker.firebirdsql.org/browse/core-2408
http://tracker.firebirdsql.org/browse/core-2477
http://tracker.firebirdsql.org/browse/core-2668
http://tracker.firebirdsql.org/browse/core-2724
http://tracker.firebirdsql.org/browse/core-2788
http://tracker.firebirdsql.org/browse/core-2861
http://tracker.firebirdsql.org/browse/core-2879
http://tracker.firebirdsql.org/browse/core-2940
http://tracker.firebirdsql.org/browse/core-2981
http://tracker.firebirdsql.org/browse/core-3008
http://tracker.firebirdsql.org/browse/core-3188
http://tracker.firebirdsql.org/browse/core-3323
http://tracker.firebirdsql.org/browse/core-3328
http://tracker.firebirdsql.org/browse/core-3413
http://tracker.firebirdsql.org/browse/core-3537
http://tracker.firebirdsql.org/browse/core-3614
http://tracker.firebirdsql.org/browse/core-3732
http://tracker.firebirdsql.org/browse/core-3735
http://tracker.firebirdsql.org/browse/core-3884
http://tracker.firebirdsql.org/browse/core-3934
http://tracker.firebirdsql.org/browse/core-3977
http://tracker.firebirdsql.org/browse/core-4058
http://tracker.firebirdsql.org/browse/core-4094
http://tracker.firebirdsql.org/browse/core-4126
http://tracker.firebirdsql.org/browse/core-4135
http://tracker.firebirdsql.org/browse/core-4218
http://tracker.firebirdsql.org/browse/core-4236
http://tracker.firebirdsql.org/browse/core-4292
http://tracker.firebirdsql.org/browse/core-4319
http://tracker.firebirdsql.org/browse/core-4337
http://tracker.firebirdsql.org/browse/core-4345
http://tracker.firebirdsql.org/browse/core-4380
http://tracker.firebirdsql.org/browse/core-4451
http://tracker.firebirdsql.org/browse/core-4707
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-4766
http://tracker.firebirdsql.org/browse/core-4768
http://tracker.firebirdsql.org/browse/core-4855
http://tracker.firebirdsql.org/browse/core-4864
http://tracker.firebirdsql.org/browse/core-4879
http://tracker.firebirdsql.org/browse/core-4904
http://tracker.firebirdsql.org/browse/core-4927
http://tracker.firebirdsql.org/browse/core-4964
http://tracker.firebirdsql.org/browse/core-4998
http://tracker.firebirdsql.org/browse/core-5061
http://tracker.firebirdsql.org/browse/core-5075
http://tracker.firebirdsql.org/browse/core-5078
http://tracker.firebirdsql.org/browse/core-5089
http://tracker.firebirdsql.org/browse/core-5092
http://tracker.firebirdsql.org/browse/core-5118
http://tracker.firebirdsql.org/browse/core-5122
http://tracker.firebirdsql.org/browse/core-5143
http://tracker.firebirdsql.org/browse/core-5183
http://tracker.firebirdsql.org/browse/core-5194
http://tracker.firebirdsql.org/browse/core-5201
http://tracker.firebirdsql.org/browse/core-5207
http://tracker.firebirdsql.org/browse/core-5218
http://tracker.firebirdsql.org/browse/core-5231
http://tracker.firebirdsql.org/browse/core-5275
http://tracker.firebirdsql.org/browse/core-5295
http://tracker.firebirdsql.org/browse/core-5302
http://tracker.firebirdsql.org/browse/core-5329
http://tracker.firebirdsql.org/browse/core-5392
http://tracker.firebirdsql.org/browse/core-5418
http://tracker.firebirdsql.org/browse/core-5441
http://tracker.firebirdsql.org/browse/core-5457
http://tracker.firebirdsql.org/browse/core-5470
http://tracker.firebirdsql.org/browse/core-5475
http://tracker.firebirdsql.org/browse/core-5489
http://tracker.firebirdsql.org/browse/core-5501
http://tracker.firebirdsql.org/browse/core-5576
http://tracker.firebirdsql.org/browse/core-5598
http://tracker.firebirdsql.org/browse/core-5618
http://tracker.firebirdsql.org/browse/core-5645
http://tracker.firebirdsql.org/browse/core-5648
http://tracker.firebirdsql.org/browse/core-5659
http://tracker.firebirdsql.org/browse/core-5704
http://tracker.firebirdsql.org/browse/core-5706
http://tracker.firebirdsql.org/browse/core-5719
http://tracker.firebirdsql.org/browse/core-5737
http://tracker.firebirdsql.org/browse/core-5790
http://tracker.firebirdsql.org/browse/core-5833
http://tracker.firebirdsql.org/browse/core-5855
http://tracker.firebirdsql.org/browse/core-5965
http://tracker.firebirdsql.org/browse/core-5972
http://tracker.firebirdsql.org/browse/core-5995
http://tracker.firebirdsql.org/browse/core-6000
http://tracker.firebirdsql.org/browse/core-6028
http://tracker.firebirdsql.org/browse/core-6078
http://tracker.firebirdsql.org/browse/core-6089
http://tracker.firebirdsql.org/browse/core-6090
http://tracker.firebirdsql.org/browse/core-6095
http://tracker.firebirdsql.org/browse/core-6116
http://tracker.firebirdsql.org/browse/core-6141
http://tracker.firebirdsql.org/browse/core-6233
http://tracker.firebirdsql.org/browse/core-6250
http://tracker.firebirdsql.org/browse/core-6265
http://tracker.firebirdsql.org/browse/core-6309
http://tracker.firebirdsql.org/browse/core-6319
http://tracker.firebirdsql.org/browse/core-6411
http://tracker.firebirdsql.org/browse/core-6437
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_04.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/gtcs/transactions-autocommit-1.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/transactions-autocommit-2.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/services/user_management.fbt

=== end of list ===