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 (19 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 (47 rows)
5. Has fails: tests with at least one fail for previous runs (69 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (289 rows)
[CURRENT] 7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (251 rows)
8. All tests: outcomes (2040 rows)
9. All tests: durations (3734 rows)
A. Skipped: tests which was intentionally excluded from execution (3 rows)

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

Elapsed time, milliseconds:
NN Test name mode median_ms 3.0.8.33415
2021-02-23
3.0.8.33403
2021-02-08
X X X X 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 CS 1045 1170 920
bug #910430 ISQL and database dialect
2 SS 699 909 490
bug #910430 ISQL and database dialect
3 CS 1924 2109 1740
Compress Data over the Network
4 SS 1404 1690 1119
Compress Data over the Network
5 CS 1294 1450 1139
Easy metadata extract improvements
6 SS 899 960 839
Easy metadata extract improvements
7 CS 2154 2700 1609
GSTAT does not work using the localhost connection string
8 SS 1879 2479 1279
GSTAT does not work using the localhost connection string
9 CS 1569 2430 709
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
10 SS 709 1000 419
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
11 CS 1390 1910 870
Every user can view server log using services API
12 SS 965 1470 460
Every user can view server log using services API
13 CS 3310 5620 1000
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
14 SS 2724 4909 539
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
15 CS 19054 36279 1830
Expression index can be created while doing inserts into table
16 SS 18954 36559 1349
Expression index can be created while doing inserts into table
17 CS 1059 1279 839
Support hex numeric and string literals
18 SS 684 930 439
Support hex numeric and string literals
19 CS 2239 3319 1160
Some standard calls show server installation directory to regular users
20 SS 1264 2000 529
Some standard calls show server installation directory to regular users
21 CS 2629 3460 1799
BLR error on restore database with computed by Field
22 SS 1954 2640 1269
BLR error on restore database with computed by Field
23 CS 2465 3740 1190
ALTER USER XXX INACTIVE
24 SS 1819 2789 850
ALTER USER XXX INACTIVE
25 CS 2269 2269
Stored procedure recursively called by calculated field fails after reconnect
26 SS 1509 1509
Stored procedure recursively called by calculated field fails after reconnect
27 CS 2829 2829 0
Query plan is missing for the long query
28 SS 1585 2720 450
Query plan is missing for the long query
29 CS 2114 2539 1689
Add support for -nodbtriggers switch in gbak into services API
30 SS 1749 2179 1319
Add support for -nodbtriggers switch in gbak into services API
31 CS 2669 3299 2039
New gbak option to ignore specific tables data during the backup
32 SS 2354 2950 1759
New gbak option to ignore specific tables data during the backup
33 CS 1860 2810 910
gbak doesn't return error code
34 SS 829 1130 529
gbak doesn't return error code
35 CS 1574 2289 860
Incomplete API information values
36 SS 1114 1720 509
Incomplete API information values
37 CS 3534 5289 1780
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
38 SS 2895 4430 1360
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
39 CS 5765 9830 1700
mon$memory_usage: Sorting memory should be reported as owned by the statement
40 SS 5464 9579 1349
mon$memory_usage: Sorting memory should be reported as owned by the statement
41 CS 4485 8240 730
Write note into log when automatic sweep is started
42 SS 4184 7960 409
Write note into log when automatic sweep is started
43 CS 2979 4029 1930
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
44 SS 2399 3480 1319
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
45 CS 1930 3170 690
isql extracts the array dimensions after the character set name
46 SS 1424 2450 399
isql extracts the array dimensions after the character set name
47 CS 2029 3329 730
Cannot remove user with dot in login
48 SS 1434 2470 399
Cannot remove user with dot in login
49 CS 2840 4950 730
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
50 SS 2929 5429 430
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
51 CS 3799 6389 1210
Trace output could contain garbage data left from filtered out statements
52 SS 3209 5739 680
Trace output could contain garbage data left from filtered out statements
53 CS 3834 6649 1020
Error in Trace plugin (use local symbols in query)
54 SS 3260 5850 670
Error in Trace plugin (use local symbols in query)
55 CS 3809 6569 1049
Add attachment's CHARACTER SET name into corresponding trace records
56 SS 3524 6309 740
Add attachment's CHARACTER SET name into corresponding trace records
57 CS 1444 1859 1029
page 0 is of wrong type (expected 6, found 1)
58 SS 879 1240 519
page 0 is of wrong type (expected 6, found 1)
59 CS 1944 2349 1539
Ability to cancel waiting in lock manager
60 SS 1914 2669 1160
Ability to cancel waiting in lock manager
61 CS 3254 5160 1349
Client writes error messages into firebird.log when database is shutted down
62 SS 3094 5279 910
Client writes error messages into firebird.log when database is shutted down
63 CS 3734 6389 1079
Improve diagnostics of internal trace errors
64 SS 3225 5840 610
Improve diagnostics of internal trace errors
65 CS 5549 8819 2279
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
66 SS 4844 7890 1799
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
67 CS 1845 2000 1690
Plan returned for query with recursive CTE return wrong count of parenthesis
68 SS 1594 2119 1069
Plan returned for query with recursive CTE return wrong count of parenthesis
69 CS 1849 2789 910
Segfault when closing attachment to database
70 SS 1270 1960 580
Segfault when closing attachment to database
71 CS 1424 1440 1409
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
72 SS 894 890 899
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
73 CS 4149 7329 970
Server crashes on preparing empty query when trace is enabled
74 SS 3689 6740 639
Server crashes on preparing empty query when trace is enabled
75 CS 9920 19140 700
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
76 SS 9369 18319 420
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
77 CS 3324 5659 990
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
78 SS 3374 6129 619
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
79 CS 1595 2240 950
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
80 SS 1054 1600 509
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
81 CS 2965 4710 1220
Wrong parameters order in trace output
82 SS 2515 3980 1050
Wrong parameters order in trace output
83 CS 3614 4970 2259
gbak -r fails in restoring all stored procedures/functions in packages
84 SS 2534 3139 1930
gbak -r fails in restoring all stored procedures/functions in packages
85 CS 15354 29920 789
In SS sweep blocks establishment of concurrent attachments
86 SS 44959 89490 429
In SS sweep blocks establishment of concurrent attachments
87 CS 1710 2480 940
Add database owner to mon$database
88 SS 1359 2059 659
Add database owner to mon$database
89 CS 12275 23430 1120
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
90 SS 24455 48200 710
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
91 CS 6424 11960 889
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
92 SS 6089 11609 570
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
93 CS 3769 5509 2029
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
94 SS 2729 3809 1650
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
95 CS 18279 18279 0
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
96 SS 23239 46059 420
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
97 CS 5294 9279 1309
Ability to trace stored functions execution
98 SS 4659 8409 910
Ability to trace stored functions execution
99 CS 1189 1289 1090
ISQL truncates blob when reading an empty segment
100 SS 774 839 710
ISQL truncates blob when reading an empty segment
101 CS 4579 7560 1599
Allow output to trace explain plan form.
102 SS 4229 7599 859
Allow output to trace explain plan form.
103 CS 5374 8019 2730
Implement ability to validate tables and indices online (without exclusive access to database)
104 SS 4464 6610 2319
Implement ability to validate tables and indices online (without exclusive access to database)
105 CS 8434 15839 1029
Prohibit an ability to issue DML or DDL statements on RDB$ tables
106 SS 7335 14130 540
Prohibit an ability to issue DML or DDL statements on RDB$ tables
107 CS 1794 2809 779
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
108 SS 1000 1600 400
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
109 CS 3195 5000 1390
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
110 SS 2659 4650 669
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
111 SS 4674 8840 509
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"
112 CS 1455 2000 910
CREATE DATABASE fail with ISQL
113 SS 1144 1759 529
CREATE DATABASE fail with ISQL
114 CS 1864 2800 929
Minor inconvenience in user management via services API
115 SS 1489 2419 559
Minor inconvenience in user management via services API
116 CS 1674 2419 930
Index corruption when add data in long-key-indexed field
117 SS 1194 1869 519
Index corruption when add data in long-key-indexed field
118 CS 5984 8880 3089
IIF function prevents the condition from being pushed into the union for better optimization
119 SS 5509 8319 2700
IIF function prevents the condition from being pushed into the union for better optimization
120 CS 1649 2379 920
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
121 SS 1079 1630 529
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
122 CS 2344 3699 990
Both client and server could not close connection after failed authentification
123 SS 1679 2779 579
Both client and server could not close connection after failed authentification
124 CS 1300 1920 680
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
125 SS 974 1550 399
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
126 CS 3069 5259 879
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
127 SS 2649 4759 540
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
128 CS 2154 3290 1019
"Invalid BLOB ID" error
129 SS 1660 2690 630
"Invalid BLOB ID" error
130 CS 3384 4769 2000
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
131 SS 3015 4410 1620
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
132 CS 2770 3920 1620
ISQL extract command looses COMPUTED BY field types
133 SS 2175 3290 1060
ISQL extract command looses COMPUTED BY field types
134 CS 2774 3850 1699
Indices on computed fields are broken after restore (all keys are NULL)
135 SS 1929 2799 1059
Indices on computed fields are broken after restore (all keys are NULL)
136 CS 2004 2600 1409
Expression index may not be used by the optimizer if created and used in different connection charsets
137 SS 1589 2179 1000
Expression index may not be used by the optimizer if created and used in different connection charsets
138 CS 2369 3100 1639
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
139 SS 2055 2890 1220
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
140 CS 1439 2029 849
Regression: line/column numbering may be twisted if alias.name syntax is used
141 SS 1094 1660 529
Regression: line/column numbering may be twisted if alias.name syntax is used
142 CS 2000 3190 810
Invalid computed by definition generated by isql -x
143 SS 1755 3070 440
Invalid computed by definition generated by isql -x
144 CS 2225 3000 1450
Return nonzero result code when restore fails on activating and creating deferred user index
145 SS 1824 2569 1079
Return nonzero result code when restore fails on activating and creating deferred user index
146 CS 1794 2730 859
ISQL -X may generate invalid GRANT USAGE statements for domains
147 SS 1364 2220 509
ISQL -X may generate invalid GRANT USAGE statements for domains
148 CS 2254 2899 1610
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
149 SS 1714 2349 1079
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
150 CS 3349 5780 919
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
151 SS 3014 5490 539
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
152 CS 9084 16160 2009
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
153 SS 8234 15090 1379
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
154 CS 3549 4080 3019
Validation could read after the end-of-file when handle multifile database
155 SS 2759 3000 2519
Validation could read after the end-of-file when handle multifile database
156 CS 1745 2490 1000
Database gets partially corrupted in the "no-reserve" mode
157 SS 2019 2019 0
Database gets partially corrupted in the "no-reserve" mode
158 SS 6209 11839 579
BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
159 CS 2644 2630 2659
Bad optimization of some operations with views containing subqueries
160 CS 1565 2170 960
Inconsistent output when retrieving the server log via Services API
161 SS 1079 1619 539
Inconsistent output when retrieving the server log via Services API
162 CS 3870 6000 1740
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
163 CS 2349 3929 769
Bugcheck 167 (invalid SEND request)
164 SS 1929 3440 419
Bugcheck 167 (invalid SEND request)
165 CS 3424 5779 1069
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
166 SS 2854 5150 559
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
167 CS 4540 7610 1470
Provide ability to filter out info and warnings from trace log
168 SS 3549 6000 1099
Provide ability to filter out info and warnings from trace log
169 CS 4024 7099 950
Bad performance for NULLs filtering inside a navigational index scan
170 SS 3439 6349 529
Bad performance for NULLs filtering inside a navigational index scan
171 CS 3360 3420 3300
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
172 SS 3149 3349 2950
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
173 CS 2184 2799 1569
Bugcheck on queries containing WITH LOCK clause
174 SS 1569 2059 1079
Bugcheck on queries containing WITH LOCK clause
175 CS 6560 10120 3000
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
176 SS 6180 9380 2980
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
177 CS 2090 2990 1190
Part of the pages of the second level blobs is not released when deleting relations.
178 SS 1569 2340 799
Part of the pages of the second level blobs is not released when deleting relations.
179 CS 2089 2370 1809
Wrong transaction can be passed to external engine
180 CS 66780 132590 970
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
181 SS 66699 132869 529
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
182 CS 2004 3059 949
Bad PLAN generated for query on Firebird v3.0
183 SS 1569 2630 509
Bad PLAN generated for query on Firebird v3.0
184 CS 3065 5170 960
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
185 SS 3140 5730 550
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
186 CS 2805 4710 900
Trace config with misplaced "{" lead firebird to crash
187 SS 2214 3869 559
Trace config with misplaced "{" lead firebird to crash
188 CS 1744 2559 930
FB >= 3 crashes when restoring backup made by FB 2.5.
189 SS 2230 2230 0
FB >= 3 crashes when restoring backup made by FB 2.5.
190 CS 3124 4569 1680
Invalid parameters of gds transaction in ISQL
191 SS 2680 4120 1240
Invalid parameters of gds transaction in ISQL
192 CS 1844 2729 960
User with DROP DATABASE privilege can't drop database
193 SS 1354 2190 519
User with DROP DATABASE privilege can't drop database
194 CS 5420 6640 4200
Server crashes on preparing empty query when trace is enabled
195 SS 4579 5679 3480
Server crashes on preparing empty query when trace is enabled
196 CS 1869 2799 939
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
197 SS 1464 2259 669
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
198 CS 2630 4380 880
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
199 SS 1929 3299 560
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
200 CS 2095 2230 1960
External engine trigger crashing server if table have computed field
201 SS 2164 2839 1490
External engine trigger crashing server if table have computed field
202 CS 2099 3160 1039
Creator user name is empty in user trace sessions
203 SS 1604 2670 539
Creator user name is empty in user trace sessions
204 CS 1444 2070 819
gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
205 SS 1029 1649 410
gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
206 CS 1885 2840 930
Trigger on system table restored in FB3 database and can't be deleted
207 SS 1514 2519 509
Trigger on system table restored in FB3 database and can't be deleted
208 CS 2654 4509 800
Permissions for create or alter statements are not checked
209 SS 1759 3090 429
Permissions for create or alter statements are not checked
210 CS 1279 1740 819
BLOBs are unnecessarily copied during UPDATE after a table format change
211 SS 979 1409 549
BLOBs are unnecessarily copied during UPDATE after a table format change
212 CS 1934 3049 819
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
213 SS 1539 2550 529
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
214 CS 4154 6549 1759
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
215 SS 3559 5649 1470
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
216 CS 1669 2339 1000
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
217 SS 1294 1859 730
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
218 CS 9065 11210 6920
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
219 SS 8369 9809 6930
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
220 CS 2149 2490 1809
Wrong dependencies of stored function on view after backup and restore
221 SS 1685 1950 1420
Wrong dependencies of stored function on view after backup and restore
222 CS 3335 5640 1030
Problem with too many number of columns in resultset.
223 SS 2864 5200 529
Problem with too many number of columns in resultset.
224 CS 2934 4189 1679
Signature mismatch when creating package body on identical packaged procedure header
225 SS 1989 2979 1000
Signature mismatch when creating package body on identical packaged procedure header
226 CS 2490 4000 980
mapping rules destroyed by backup / restore
227 SS 1929 3279 579
mapping rules destroyed by backup / restore
228 CS 8184 10109 6259
fbsvcmgr can not decode information buffer returned by gfix list limbo service
229 SS 7914 9339 6490
fbsvcmgr can not decode information buffer returned by gfix list limbo service
230 CS 2239 3579 900
NBACKUP locks db file on error
231 SS 1719 2849 589
NBACKUP locks db file on error
232 CS 7989 15090 889
FB crashes on attempt to create table with number of fields greater than 5460
233 SS 7420 14350 490
FB crashes on attempt to create table with number of fields greater than 5460
234 CS 1969 3139 799
gfix cannot set big value for buffers
235 SS 1649 2839 460
gfix cannot set big value for buffers
236 CS 1450 1450
Comments before the first line of code are removed (when extract metadata)
237 SS 840 840
Comments before the first line of code are removed (when extract metadata)
238 CS 1874 2980 769
FULL OUTER JOIN, list all values
239 SS 1519 2569 470
FULL OUTER JOIN, list all values
240 CS 1874 3009 740
FULL OUTER JOIN, list all values, but filtered in WHERE clause
241 SS 1534 2599 470
FULL OUTER JOIN, list all values, but filtered in WHERE clause
242 CS 1809 2909 710
FULL OUTER JOIN, list all values, but filtered in WHERE clause
243 SS 1480 2560 400
FULL OUTER JOIN, list all values, but filtered in WHERE clause
244 CS 1739 2789 690
FULL OUTER JOIN, list all values, but filtered in WHERE clause
245 SS 1505 2530 480
FULL OUTER JOIN, list all values, but filtered in WHERE clause
246 CS 10179 19379 980
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
247 SS 10064 19600 529
GTCS/tests/PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
248 CS 1894 3009 780
GTCS/tests/AUTO_COMMIT.1.ESQL. AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued.
249 SS 2440 2440 0
GTCS/tests/AUTO_COMMIT.1.ESQL. AUTO COMMIT must preserve changes that were made by all DML even if ROLLBACK is issued.
250 CS 1879 2829 930
GTCS/tests/AUTO_COMMIT.2.ESQL. Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER.
251 SS 1460 2490 430
GTCS/tests/AUTO_COMMIT.2.ESQL. Changes within AUTO COMMIT must be cancelled when exception raises in some TRIGGER.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1076
http://tracker.firebirdsql.org/browse/core-1148
http://tracker.firebirdsql.org/browse/core-1725
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-2032
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-337
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-5329
http://tracker.firebirdsql.org/browse/core-5392
http://tracker.firebirdsql.org/browse/core-5393
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-6246
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
http://tracker.firebirdsql.org/browse/core-6466
http://tracker.firebirdsql.org/browse/core-733
http://tracker.firebirdsql.org/browse/core-800
http://tracker.firebirdsql.org/browse/core-959
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

=== end of list ===