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)
[CURRENT] 6. Has runtime errors: tests with at least one runtime error for previous runs (285 rows)
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...

Test with at least one result = "ERROR" for last 30 runs:

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 CS P P     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
bug #910430 ISQL and database dialect
2 SS P P     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
bug #910430 ISQL and database dialect
3 CS P P     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
Compress Data over the Network
4 SS P P     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
Compress Data over the Network
5 CS P P     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
Easy metadata extract improvements
6 SS P P     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
Easy metadata extract improvements
7 CS P P     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
GSTAT does not work using the localhost connection string
8 SS P P     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
GSTAT does not work using the localhost connection string
9 CS P P     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
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
10 SS P P     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
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
11 CS P P     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
Every user can view server log using services API
12 SS P P     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
Every user can view server log using services API
13 CS     E         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
Unexpected "cannot transliterate" error
14 SS     E         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
Unexpected "cannot transliterate" error
15 CS     E         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
French insensitive collation FR_FR_CI_AI
16 SS     E         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
French insensitive collation FR_FR_CI_AI
17 CS P P     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
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
18 SS P P     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
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
19 CS P P     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
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
Expression index can be created while doing inserts into table
21 CS P P     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
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
Support hex numeric and string literals
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
Some standard calls show server installation directory to regular users
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
Some standard calls show server installation directory to regular users
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
BLR error on restore database with computed by Field
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
BLR error on restore database with computed by Field
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
ALTER USER XXX INACTIVE
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
ALTER USER XXX INACTIVE
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
Query plan is missing for the long query
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
Query plan is missing for the long query
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
Add support for -nodbtriggers switch in gbak into services API
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
Add support for -nodbtriggers switch in gbak into services API
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
New gbak option to ignore specific tables data during the backup
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
New gbak option to ignore specific tables data during the backup
35 CS     E         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
Problem with column names with Accents and triggers
36 SS     E         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
Problem with column names with Accents and triggers
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
gbak doesn't return error code
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
gbak doesn't return error code
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
Incomplete API information values
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
Incomplete API information values
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
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
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
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
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
mon$memory_usage: Sorting memory should be reported as owned by the statement
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
mon$memory_usage: Sorting memory should be reported as owned by the statement
45 CS X     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
Append the IP address of the remote host to error messages in firebird.log for TCP connections
46 SS X     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
Append the IP address of the remote host to error messages in firebird.log for TCP connections
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
Write note into log when automatic sweep is started
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
Write note into log when automatic sweep is started
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
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
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
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
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
isql extracts the array dimensions after the character set name
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
isql extracts the array dimensions after the character set name
53 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
54 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
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
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
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
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
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
Trace output could contain garbage data left from filtered out statements
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
Trace output could contain garbage data left from filtered out statements
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
Error in Trace plugin (use local symbols in query)
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
Error in Trace plugin (use local symbols in query)
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
Add attachment's CHARACTER SET name into corresponding trace records
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
Add attachment's CHARACTER SET name into corresponding trace records
63 CS     E         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
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
64 SS     E         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
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
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
page 0 is of wrong type (expected 6, found 1)
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
page 0 is of wrong type (expected 6, found 1)
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
Ability to cancel waiting in lock manager
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
Ability to cancel waiting in lock manager
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
Client writes error messages into firebird.log when database is shutted down
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
Client writes error messages into firebird.log when database is shutted down
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
Improve diagnostics of internal trace errors
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
Improve diagnostics of internal trace errors
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
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
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
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
75 CS     F         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: add statistics of actions that were after transaction finished
76 SS     F         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: add statistics of actions that were after transaction finished
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
Plan returned for query with recursive CTE return wrong count of parenthesis
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
Plan returned for query with recursive CTE return wrong count of parenthesis
79 CS     F         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 connects to server as OS user name rather than value of ISC_USER environment variable
80 SS     F         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 connects to server as OS user name rather than value of ISC_USER environment variable
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
Segfault when closing attachment to database
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
Segfault when closing attachment to database
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
Server crashes on preparing empty query when trace is enabled
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
Server crashes on preparing empty query when trace is enabled
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
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
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
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
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
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
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
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
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
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
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
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
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
Wrong parameters order in trace output
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
Wrong parameters order in trace output
93 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
94 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
95 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
96 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
97 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
98 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
99 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
100 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
101 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
102 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
103 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
104 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
105 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)
106 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)
107 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
108 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
109 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
110 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
111 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.
112 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.
113 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)
114 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)
115 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
116 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
117 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
118 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
119 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
120 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
121 CS     F         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"
122 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"
123 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
124 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
125 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
126 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
127 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
128 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
129 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
130 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
131 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.
132 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.
133 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
134 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
135 CS     F         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
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
136 SS     F         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
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
137 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
138 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
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
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
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
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
141 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
142 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
143 CS     E         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 can cause server crash if multiple attachments run EXECUTE STATEMENT
144 SS     E         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 can cause server crash if multiple attachments run EXECUTE STATEMENT
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
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
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
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
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
ISQL extract command looses COMPUTED BY field types
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
ISQL extract command looses COMPUTED BY field types
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
Indices on computed fields are broken after restore (all keys are NULL)
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
Indices on computed fields are broken after restore (all keys are NULL)
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
Expression index may not be used by the optimizer if created and used in different connection charsets
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
Expression index may not be used by the optimizer if created and used in different connection charsets
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
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
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
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
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
Regression: line/column numbering may be twisted if alias.name syntax is used
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
Regression: line/column numbering may be twisted if alias.name syntax is used
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
Invalid computed by definition generated by isql -x
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
Invalid computed by definition generated by isql -x
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
Return nonzero result code when restore fails on activating and creating deferred user index
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
Return nonzero result code when restore fails on activating and creating deferred user index
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
ISQL -X may generate invalid GRANT USAGE statements for domains
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
ISQL -X may generate invalid GRANT USAGE statements for domains
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
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
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
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
165 CS     E         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
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
166 SS     E         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
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
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
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
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
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
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
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
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
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
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
Validation could read after the end-of-file when handle multifile database
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
Validation could read after the end-of-file when handle multifile database
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
Database gets partially corrupted in the "no-reserve" mode
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
Database gets partially corrupted in the "no-reserve" mode
175 CS     F         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 -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
176 SS     F         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 -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
177 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
178 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
179 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
180 CS     E         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
Badly selective index could be used for extra filtering even if selective index is used for sorting
181 SS     E         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
Badly selective index could be used for extra filtering even if selective index is used for sorting
182 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
183 SS     F         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
184 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)
185 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)
186 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
187 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
188 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
189 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
190 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
191 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
192 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
193 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
194 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
195 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
196 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
197 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
198 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.
199 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.
200 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
201 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
202 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
203 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
204 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
205 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
206 CS     E         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
Sometime it is impossible to cancel\kill connection executing external query
207 SS     E         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
Sometime it is impossible to cancel\kill connection executing external query
208 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
209 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
210 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
211 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
212 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.
213 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.
214 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
215 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
216 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
217 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
218 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
219 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
220 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
221 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
222 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
223 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
224 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
225 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
226 CS     F         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 could not work correctly with quoted file names in trace configurations
227 SS     F         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 could not work correctly with quoted file names in trace configurations
228 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
229 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
230 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
231 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
232 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
233 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
234 CS     E         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
GTTs do not release used space
235 SS     E         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
GTTs do not release used space
236 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
237 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
238 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
239 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
240 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
241 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
242 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
243 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
244 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
245 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
246 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
247 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
248 CS     E         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
Generator pages are not encrypted
249 SS     E         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
Generator pages are not encrypted
250 CS     F         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
isc_info_svc_user_dbpath always returns alias of main security database
251 SS     F         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
isc_info_svc_user_dbpath always returns alias of main security database
252 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
253 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
254 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
255 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
256 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
257 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
258 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
259 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
260 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
261 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
262 CS     F         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
Better diagnostic when 'Missing security context'
263 SS     F         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
Better diagnostic when 'Missing security context'
264 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
265 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
266 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
267 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
268 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
269 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
270 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
271 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
272 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
273 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
274 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
275 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
276 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
277 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
278 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.
279 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.
280 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.
281 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.
282 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.
283 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.
284 CS     E         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
Malformed string error when using cyrilic symbols and x'0d0a' in exception
285 SS     E         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
Malformed string error when using cyrilic symbols and x'0d0a' in exception

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 CS 879 990 1039 719 769
bug #910430 ISQL and database dialect
2 SS 730 730 780 529 0
bug #910430 ISQL and database dialect
3 CS 1779 2049 2359 1409 1509
Compress Data over the Network
4 SS 1284 1429 1460 1140 1110
Compress Data over the Network
5 CS 1169 1270 1650 1020 1069
Easy metadata extract improvements
6 SS 925 930 1619 920 789
Easy metadata extract improvements
7 CS 2104 2509 3399 1450 1700
GSTAT does not work using the localhost connection string
8 SS 1894 2279 2380 1509 1490
GSTAT does not work using the localhost connection string
9 CS 1375 2160 2330 589 590
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
10 SS 1070 1759 1740 400 390
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
11 CS 1199 1779 1779 609 619
Every user can view server log using services API
12 SS 965 1460 1560 470 440
Every user can view server log using services API
13 CS 655 589 680 640 670
Unexpected "cannot transliterate" error
14 SS 419 470 420 370 419
Unexpected "cannot transliterate" error
15 CS 1359 1309 1869 1369 1350
French insensitive collation FR_FR_CI_AI
16 SS 1270 1200 1170 1340 1620
French insensitive collation FR_FR_CI_AI
17 CS 3059 5279 6150 840 819
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
18 SS 4809 4809 4980 569 0
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
19 CS 19275 37670 36860 1690 1509
Expression index can be created while doing inserts into table
20 SS 1365 36769 1310 1269 1420
Expression index can be created while doing inserts into table
21 CS 994 1259 1590 650 730
Support hex numeric and string literals
22 SS 530 1050 410 420 640
Support hex numeric and string literals
23 CS 1054 2950 949 1089 1019
Some standard calls show server installation directory to regular users
24 SS 529 1830 519 509 539
Some standard calls show server installation directory to regular users
25 CS 1680 3559 1609 1740 1620
BLR error on restore database with computed by Field
26 SS 1294 2830 1259 1309 1279
BLR error on restore database with computed by Field
27 CS 1104 3529 1039 1069 1140
ALTER USER XXX INACTIVE
28 SS 874 2730 880 869 789
ALTER USER XXX INACTIVE
29 CS 770 2740 960 559 580
Query plan is missing for the long query
30 SS 410 2460 400 420 380
Query plan is missing for the long query
31 CS 2080 2309 2230 1930 1519
Add support for -nodbtriggers switch in gbak into services API
32 SS 1539 1920 1339 1740 1309
Add support for -nodbtriggers switch in gbak into services API
33 CS 2000 3230 1879 1900 2100
New gbak option to ignore specific tables data during the backup
34 SS 1755 2940 1690 1820 1650
New gbak option to ignore specific tables data during the backup
35 CS 619 609 700 609 629
Problem with column names with Accents and triggers
36 SS 410 410 420 410 399
Problem with column names with Accents and triggers
37 CS 784 2210 779 789 779
gbak doesn't return error code
38 SS 545 1160 540 480 550
gbak doesn't return error code
39 CS 844 2160 869 700 819
Incomplete API information values
40 SS 504 1849 480 519 490
Incomplete API information values
41 CS 2234 4900 2690 1669 1779
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
42 SS 1459 4269 1000 1439 1480
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
43 CS 1590 9339 1610 1550 1570
mon$memory_usage: Sorting memory should be reported as owned by the statement
44 SS 1214 9480 1220 1209 1179
mon$memory_usage: Sorting memory should be reported as owned by the statement
45 CS 1160 1289 1129 1160
Append the IP address of the remote host to error messages in firebird.log for TCP connections
46 SS 970 900 979 970
Append the IP address of the remote host to error messages in firebird.log for TCP connections
47 CS 635 7000 640 630 590
Write note into log when automatic sweep is started
48 SS 424 7920 429 410 419
Write note into log when automatic sweep is started
49 CS 1674 3859 1709 1570 1640
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
50 SS 1424 3560 1339 1359 1490
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
51 CS 604 2879 609 600 599
isql extracts the array dimensions after the character set name
52 SS 429 2490 399 439 420
isql extracts the array dimensions after the character set name
53 CS 669 3170 609 730 579
Cannot remove user with dot in login
54 SS 425 2360 420 430 420
Cannot remove user with dot in login
55 CS 624 4710 629 619 609
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
56 SS 399 5660 380 389 410
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
57 CS 1010 6200 1090 880 930
Trace output could contain garbage data left from filtered out statements
58 SS 619 5759 600 590 639
Trace output could contain garbage data left from filtered out statements
59 CS 934 6470 1000 869 829
Error in Trace plugin (use local symbols in query)
60 SS 604 5849 579 600 609
Error in Trace plugin (use local symbols in query)
61 CS 895 6450 829 900 890
Add attachment's CHARACTER SET name into corresponding trace records
62 SS 615 6039 590 620 610
Add attachment's CHARACTER SET name into corresponding trace records
63 CS 1054 1080 1000 1150 1029
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
64 SS 894 879 909 1160 880
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
65 CS 985 1589 990 849 980
page 0 is of wrong type (expected 6, found 1)
66 SS 545 1160 480 600 490
page 0 is of wrong type (expected 6, found 1)
67 CS 1539 2349 1000 1310 1769
Ability to cancel waiting in lock manager
68 SS 1300 1590 1130 1470 1080
Ability to cancel waiting in lock manager
69 CS 1314 5189 1259 1330 1299
Client writes error messages into firebird.log when database is shutted down
70 SS 1130 5090 970 1150 1110
Client writes error messages into firebird.log when database is shutted down
71 CS 940 6190 930 950 839
Improve diagnostics of internal trace errors
72 SS 639 5859 619 599 660
Improve diagnostics of internal trace errors
73 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
74 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
75 CS 1610 6360 1730 1490 1490
TRACE: add statistics of actions that were after transaction finished
76 SS 1185 5390 1180 1150 1190
TRACE: add statistics of actions that were after transaction finished
77 CS 1334 2789 1319 1309 1349
Plan returned for query with recursive CTE return wrong count of parenthesis
78 SS 1175 2000 1089 1240 1110
Plan returned for query with recursive CTE return wrong count of parenthesis
79 CS 964 7059 1049 880 869
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
80 SS 624 6610 590 639 610
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
81 CS 834 2460 880 780 789
Segfault when closing attachment to database
82 SS 579 1969 600 490 559
Segfault when closing attachment to database
83 CS 874 7029 869 879 770
Server crashes on preparing empty query when trace is enabled
84 SS 549 6650 529 559 539
Server crashes on preparing empty query when trace is enabled
85 CS 629 18960 619 580 639
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
86 SS 430 18379 390 450 410
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
87 CS 934 5479 909 869 960
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
88 SS 705 5040 700 710 619
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
89 CS 1214 2029 1579 779 849
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
90 SS 529 1559 529 530 529
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
91 CS 1040 4579 1080 960 1000
Wrong parameters order in trace output
92 SS 824 4019 779 869 720
Wrong parameters order in trace output
93 CS 2569 3789 2309 2170 2829
gbak -r fails in restoring all stored procedures/functions in packages
94 SS 2044 3210 2029 2029 2060
gbak -r fails in restoring all stored procedures/functions in packages
95 CS 704 29450 660 710 699
In SS sweep blocks establishment of concurrent attachments
96 SS 440 84980 420 460 409
In SS sweep blocks establishment of concurrent attachments
97 CS 940 2269 909 970 910
Add database owner to mon$database
98 SS 665 2160 620 710 599
Add database owner to mon$database
99 CS 930 22700 920 940 920
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
100 SS 685 45990 639 680 690
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
101 CS 769 11890 0 769 759
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
102 SS 539 11609 539 509 0
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
103 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
104 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
105 CS 700 15830 700 600 700
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
106 SS 440 51449 439 440 440
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
107 CS 1164 9009 1259 1000 1070
Ability to trace stored functions execution
108 SS 1190 8349 1000 1380 970
Ability to trace stored functions execution
109 CS 970 1259 950 990 950
ISQL truncates blob when reading an empty segment
110 SS 799 809 759 789 849
ISQL truncates blob when reading an empty segment
111 CS 1114 7490 1119 1109 1029
Allow output to trace explain plan form.
112 SS 809 7069 820 799 799
Allow output to trace explain plan form.
113 CS 3269 7150 3420 2519 3119
Implement ability to validate tables and indices online (without exclusive access to database)
114 SS 2664 6559 2230 3039 2289
Implement ability to validate tables and indices online (without exclusive access to database)
115 CS 834 16730 799 769 869
Prohibit an ability to issue DML or DDL statements on RDB$ tables
116 SS 529 15149 509 509 550
Prohibit an ability to issue DML or DDL statements on RDB$ tables
117 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
118 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
119 CS 904 5309 900 789 909
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
120 SS 634 5019 619 650 590
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
121 CS 864 10200 879 849 829
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"
122 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"
123 CS 804 2059 720 719 889
CREATE DATABASE fail with ISQL
124 SS 485 1000 480 470 490
CREATE DATABASE fail with ISQL
125 CS 814 2680 839 789 719
Minor inconvenience in user management via services API
126 SS 549 2389 509 519 579
Minor inconvenience in user management via services API
127 CS 910 2460 0 910 720
Index corruption when add data in long-key-indexed field
128 SS 519 1900 490 519 0
Index corruption when add data in long-key-indexed field
129 CS 3020 8699 3100 2920 2940
IIF function prevents the condition from being pushed into the union for better optimization
130 SS 3304 8059 4000 2370 2609
IIF function prevents the condition from being pushed into the union for better optimization
131 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.
132 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.
133 CS 904 3439 990 819 779
Both client and server could not close connection after failed authentification
134 SS 549 2799 579 510 519
Both client and server could not close connection after failed authentification
135 CS 2830 15690 2970 2690 2589
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
136 SS 2569 13390 2799 2299 2339
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
137 CS 644 1840 650 579 639
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
138 SS 384 1450 390 379 379
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
139 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
140 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
141 CS 925 3019 889 940 910
"Invalid BLOB ID" error
142 SS 600 2690 590 569 610
"Invalid BLOB ID" error
143 CS 2819 2869 3039 2759 2769
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
144 SS 2609 2669 2419 3359 2549
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
145 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
146 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
147 CS 1209 3630 1210 1209 1000
ISQL extract command looses COMPUTED BY field types
148 SS 984 3210 940 960 1009
ISQL extract command looses COMPUTED BY field types
149 CS 1349 2920 1279 1309 1390
Indices on computed fields are broken after restore (all keys are NULL)
150 SS 1139 2670 1140 1069 1139
Indices on computed fields are broken after restore (all keys are NULL)
151 CS 1454 2389 1279 1289 1620
Expression index may not be used by the optimizer if created and used in different connection charsets
152 SS 1099 2210 1029 1149 1049
Expression index may not be used by the optimizer if created and used in different connection charsets
153 CS 1989 2919 2430 1430 1549
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
154 SS 1424 2769 1259 1589 1229
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
155 CS 769 2019 769 710 0
Regression: line/column numbering may be twisted if alias.name syntax is used
156 SS 499 1700 490 509 490
Regression: line/column numbering may be twisted if alias.name syntax is used
157 CS 624 3100 610 579 639
Invalid computed by definition generated by isql -x
158 SS 455 2649 470 399 440
Invalid computed by definition generated by isql -x
159 CS 1890 3620 2410 1319 1370
Return nonzero result code when restore fails on activating and creating deferred user index
160 SS 2074 2759 1119 1949 2200
Return nonzero result code when restore fails on activating and creating deferred user index
161 CS 784 2629 859 710 679
ISQL -X may generate invalid GRANT USAGE statements for domains
162 SS 530 2200 580 480 480
ISQL -X may generate invalid GRANT USAGE statements for domains
163 CS 1364 3089 1329 1320 1400
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
164 SS 1189 2000 1169 1089 1210
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
165 CS 1700 1800 1700 1700 1680
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
166 SS 1604 1589 1610 1819 1599
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
167 CS 810 7870 880 700 740
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
168 SS 534 5589 529 530 539
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
169 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
170 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
171 CS 2474 3640 2430 2000 2519
Validation could read after the end-of-file when handle multifile database
172 SS 2130 3420 2069 2120 2140
Validation could read after the end-of-file when handle multifile database
173 CS 909 2440 940 840 879
Database gets partially corrupted in the "no-reserve" mode
174 SS 710 1919 720 690 700
Database gets partially corrupted in the "no-reserve" mode
175 CS 1305 3789 1060 1550 960
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
176 SS 720 2329 710 710 730
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
177 SS 564 13269 549 519 580
BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
178 CS 800 2149 780 779 820
Inconsistent output when retrieving the server log via Services API
179 SS 579 1609 619 539 509
Inconsistent output when retrieving the server log via Services API
180 CS 824 1009 819 779 830
Badly selective index could be used for extra filtering even if selective index is used for sorting
181 SS 524 620 519 529 490
Badly selective index could be used for extra filtering even if selective index is used for sorting
182 CS 2020 6070 1850 1519 2190
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
183 SS 1359 5529 1339 1380 1299
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
184 CS 744 3850 759 730 589
Bugcheck 167 (invalid SEND request)
185 SS 424 3400 399 450 389
Bugcheck 167 (invalid SEND request)
186 CS 829 5759 819 840 769
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
187 SS 549 5190 539 559 510
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
188 CS 1399 6980 1000 1410 1389
Provide ability to filter out info and warnings from trace log
189 SS 1034 6119 1049 1000 1019
Provide ability to filter out info and warnings from trace log
190 CS 864 6809 839 859 870
Bad performance for NULLs filtering inside a navigational index scan
191 SS 789 6339 549 1029 490
Bad performance for NULLs filtering inside a navigational index scan
192 CS 3514 3649 3779 3380 3169
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
193 SS 3319 3149 2910 4710 3490
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
194 CS 1659 2480 1839 1480 1359
Bugcheck on queries containing WITH LOCK clause
195 SS 1359 2009 1390 1220 1329
Bugcheck on queries containing WITH LOCK clause
196 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
197 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
198 CS 1059 3639 990 1069 1049
Part of the pages of the second level blobs is not released when deleting relations.
199 SS 809 2400 789 779 829
Part of the pages of the second level blobs is not released when deleting relations.
200 CS 1764 2759 1730 1710 1799
Wrong transaction can be passed to external engine
201 SS 1480 2299 1490 1409 1470
Wrong transaction can be passed to external engine
202 CS 910 132200 819 850 970
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
203 SS 534 133900 519 490 549
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
204 CS 914 2990 690 879 950
Bad PLAN generated for query on Firebird v3.0
205 SS 544 2640 519 549 539
Bad PLAN generated for query on Firebird v3.0
206 CS 1264 132589 1289 1170 1240
Sometime it is impossible to cancel\kill connection executing external query
207 SS 944 132329 919 970 869
Sometime it is impossible to cancel\kill connection executing external query
208 CS 899 5049 980 780 819
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
209 SS 539 4769 539 529 539
Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
210 CS 809 4400 789 740 829
Trace config with misplaced "{" lead firebird to crash
211 SS 644 3809 549 590 699
Trace config with misplaced "{" lead firebird to crash
212 CS 829 2430 890 740 769
FB >= 3 crashes when restoring backup made by FB 2.5.
213 SS 519 2079 509 529 470
FB >= 3 crashes when restoring backup made by FB 2.5.
214 CS 1485 4389 1490 1399 1480
Invalid parameters of gds transaction in ISQL
215 SS 1165 4220 1160 1130 1170
Invalid parameters of gds transaction in ISQL
216 CS 914 2459 849 769 980
User with DROP DATABASE privilege can't drop database
217 SS 569 2000 529 549 590
User with DROP DATABASE privilege can't drop database
218 CS 4349 6000 4280 4419 4019
Server crashes on preparing empty query when trace is enabled
219 SS 3769 5910 3859 3680 3480
Server crashes on preparing empty query when trace is enabled
220 CS 909 2620 929 890 859
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
221 SS 730 2200 740 720 640
Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names
222 CS 849 3530 779 0 849
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
223 SS 559 3220 570 549 509
FB3 Optimiser chooses less efficient plan than FB2.5 optimiser
224 CS 1855 2980 1809 1860 1850