01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
03. NEW FAILS: tests which failed for LAST run (6 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
05. STILL FAILS: tests which fail for at least TWO LAST runs (8 rows)
[CURRENT] 06. Has fails: tests with at least one fail for previous 30 runs (155 rows)
07. Has runtime errors: tests with at least one runtime error for previous 30 runs (2 rows)
08. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
09. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (5 rows)
10. All tests: outcomes for previous 30 runs (2479 rows)
11. All tests: durations for previous 30 runs (4788 rows)
12. Skipped: tests which was intentionally excluded from execution (70 rows)

Generated 16.05.2024 13:01
Tested: HQ40.   Build: 4.0.5.3097;   SS: 16.05.24 11:18:18 - 16.05.24 12:02:15;   CS: 16.05.24 12:03:39 - 16.05.24 12:59:33;
OS and hardware info:  Windows 10 10.0.19045 ; logical CPUs: 8 ; total memory: 31.7 Gb 
QA-software: Python 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.4; Firebird.Qa: 0.19.3
Loading data. Please wait...

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

Jump to LIST of unique test names from this report

NN Test name mode 4.0.5.3097
2024-05-16
4.0.5.3091
2024-05-08
4.0.5.3089
2024-04-27
4.0.5.3083
2024-04-20
4.0.5.3052
2024-04-06
4.0.5.3049
2024-01-26
4.0.5.3034
2023-12-30
4.0.4.3013
2023-11-30
4.0.4.2991
2023-11-09
4.0.4.2977
2023-09-15
4.0.3.2955
2023-08-11
4.0.3.2943
2023-06-22
4.0.3.2936
2023-05-25
4.0.3.2931
2023-04-30
4.0.3.2920
2023-04-21
4.0.3.2913
2023-04-02
4.0.3.2908
2023-03-22
4.0.3.2900
2023-03-14
4.0.3.2891
2023-02-09
4.0.3.2885
2023-01-27
X X X X X X X X X X
Test TITLE
1 CS P P P P P P P P P P P P P P P F F F F F X X X X X X X X X X
Compress Data over the Network
2 SS P P P P P P P P P P P P P P P F F F F F X X X X X X X X X X
Compress Data over the Network
3 CS P P P P P P P P P F P P P P P P P P P P X X X X X X X X X X
Index is not used for some date/time expressions in dialect 1
4 SS P P P P P P P P P F P P P P P P P P P P X X X X X X X X X X
Index is not used for some date/time expressions in dialect 1
5 CS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Suboptimal join plan if there are selective non-indexed predicates involved
6 SS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Suboptimal join plan if there are selective non-indexed predicates involved
7 CS P P P P P P P F F F F F F F F F F F F F 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
8 SS P P P P P P P F F F F F F F F F F F F F 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
9 CS P F P P P P P P P P P P P P P P P P P P 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
10 CS P P P P P P P P P P P P P P P P P P F F 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
11 SS P P P P P P P P P P P P P P P P P P F F 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
12 CS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
13 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
14 CS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Add better transaction control to isql
15 SS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Add better transaction control to isql
16 CS P P P P P P P P P P P P P P P P P P F P X X X X X X X X X X
Return nonzero result code when restore fails on activating and creating deferred user index
17 SS P P P P P P P P P P P P P P P P P P F P X X X X X X X X X X
Return nonzero result code when restore fails on activating and creating deferred user index
18 CS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
19 SS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
20 CS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Support for DROP IDENTITY clause
21 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Support for DROP IDENTITY clause
22 SS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change
23 CS P P P P P P P P P P F P P P P P P P P P X X X X X X X X X X
Support GENERATED ALWAYS identity columns and OVERRIDE clause
24 SS P P P P P P P P P P F P P P P P P P P P X X X X X X X X X X
Support GENERATED ALWAYS identity columns and OVERRIDE clause
25 CS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
26 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
27 CS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Timeouts for running SQL statements and idle connections
28 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Timeouts for running SQL statements and idle connections
29 CS P P P P P P P P P P P P P P F P P P P P X X X X X X X X X X
Add expression index name to exception message if computation failed
30 SS P P P P P P P P P P P P P P F P P P P P X X X X X X X X X X
Add expression index name to exception message if computation failed
31 SS P P P P P P P P F F F F F F F F F F P P X X X X X X X X X X
Parse error when compiling a statement causes memory leak until attachment is disconnected
32 CS P P P P P P P P P P F P P P P P P P P P X X X X X X X X X X
Allow unused Common Table Expressions
33 SS P P P P P P P P P P F P P P P P P P P P X X X X X X X X X X
Allow unused Common Table Expressions
34 CS P P P P P P P P P P P F P P P P P P P P X X X X X X X X X X
Date-time parsing is very weak
35 SS P P P P P P P P P P P F P P P P P P P P X X X X X X X X X X
Date-time parsing is very weak
36 CS P P P P P P P P P P P P P P P P P P F P X X X X X X X X X X
Allow the use of management statements in PSQL blocks
37 SS P P P P P P P P P P P P P P P P P P F P X X X X X X X X X X
Allow the use of management statements in PSQL blocks
38 CS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Make WIN_SSPI plugin produce keys for wirecrypt plugin
39 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Make WIN_SSPI plugin produce keys for wirecrypt plugin
40 CS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Statement level read consistency in read-committed transactions
41 SS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Statement level read consistency in read-committed transactions
42 CS P P P P P P P F P P P P P P P P P P P P X X X X X X X X X X
Builtin functions converting binary string to hexadecimal representation and vice versa
43 SS P P P P P P P F P P P P P P P P P P P P X X X X X X X X X X
Builtin functions converting binary string to hexadecimal representation and vice versa
44 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
45 CS P P P P P P P F P P P P P P P P P P P P X X X X X X X X X X
A number of errors when database name is longer than 255 symbols
46 SS P P P P P P P F P P P P P P P P P P P P X X X X X X X X X X
A number of errors when database name is longer than 255 symbols
47 SS P P P P P P P P P P P P P P P F P P P P X X X X X X X X X X
Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS
48 CS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Wire compression causes freezes
49 SS P P P P P P P P P P P P P P P P P P F F X X X X X X X X X X
Wire compression causes freezes
50 CS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Ability to query Firebird configuration using SQL
51 SS P P P P P P P F F F F F F F F F F F F F X X X X X X X X X X
Ability to query Firebird configuration using SQL
52 CS X X X X X X X X X X X X X X X X X X X F X X X X X X X X X X
Dummy test
53 SS X X X X X X X X X X X X X X X X X X X F X X X X X X X X X X
Dummy test
54 CS F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X
Backup error for wide table
55 SS F F F F F F X X X X X X X X X X X X X X X X X X X X X X X X
Backup error for wide table
56 SS P P P P P P P P P P P P P P P F P F X X X X X X X X X X X X
External engine SYSTEM not found
57 CS P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Invalid real to string cast.
58 SS P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Invalid real to string cast.
59 CS P P P P P P P P P P P P P P P F X X X X X X X X X X X X X X
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
60 SS P P P P P P P P P P P P P P P F X X X X X X X X X X X X X X
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
61 CS P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Precision of standalone unit may differ from packaged one in SQL dialect 1
62 SS P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Precision of standalone unit may differ from packaged one in SQL dialect 1
63 CS P P P P P P P P P P P P P P P F X X X X X X X X X X X X X X
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
64 SS P P P P P P P P P P P P P P P F X X X X X X X X X X X X X X
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
65 CS P P P P P P P P P P P P P P F X X X X X X X X X X X X X X X
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
66 SS P P P P P P P P P P P P P P F X X X X X X X X X X X X X X X
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
67 CS P P P P P P P P P P P P P P F X X X X X X X X X X X X X X X
Server crash on some LockMemSize values
68 SS P P P P P P P P P P P P P P F X X X X X X X X X X X X X X X
Server crash on some LockMemSize values
69 CS P P P P P P P P P P P P P P F X X X X X X X X X X X X X X X
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
70 SS P P P P P P P P P P P P P P F X X X X X X X X X X X X X X X
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
71 CS P P P P P P P P P P P P F X X X X X X X X X X X X X X X X X
RELEASE SAVEPOINT ONLY works incorrectly
72 SS P P P P P P P P P P P P F X X X X X X X X X X X X X X X X X
RELEASE SAVEPOINT ONLY works incorrectly
73 CS P P P P P P P P P P P F X X X X X X X X X X X X X X X X X X
PSQL functions do not convert the output BLOB to the connection character set
74 SS P P P P P P P P P P P F X X X X X X X X X X X X X X X X X X
PSQL functions do not convert the output BLOB to the connection character set
75 CS P P P P P P P P P P P F X X X X X X X X X X X X X X X X X X
Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup
76 SS P P P P P P P P P P P F X X X X X X X X X X X X X X X X X X
Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup
77 CS P P P P P P P F F F F F X X X X X X X X X X X X X X X X X X
Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters.
78 SS P P P P P P P F F F F F X X X X X X X X X X X X X X X X X X
Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters.
79 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY
80 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY
81 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Unable to find savepoint in insert with nested query and returning clause in FB4
82 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Unable to find savepoint in insert with nested query and returning clause in FB4
83 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
84 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
85 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Wrong result ordering in LEFT JOIN query
86 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Wrong result ordering in LEFT JOIN query
87 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Cursor name can duplicate parameter and variable names in procedures and functions
88 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Cursor name can duplicate parameter and variable names in procedures and functions
89 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
rdb$time_zone_util.transitions returns an infinite resultset
90 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
rdb$time_zone_util.transitions returns an infinite resultset
91 CS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
'with caller privileges' has no effect in triggers
92 SS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
'with caller privileges' has no effect in triggers
93 CS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
94 SS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
95 CS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
96 SS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
97 CS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N)
98 SS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N)
99 CS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
garbage collection in indexes and blobs is not performed in VIO_backout
100 SS P P P P P P P P P F X X X X X X X X X X X X X X X X X X X X
garbage collection in indexes and blobs is not performed in VIO_backout
101 CS P P P P P P P P F X X X X X X X X X X X X X X X X X X X X X
Regression when displaying line number of errors in ISQL scripts
102 SS P P P P P P P P F X X X X X X X X X X X X X X X X X X X X X
Regression when displaying line number of errors in ISQL scripts
103 CS P F P P P P P P F X X X X X X X X X X X X X X X X X X X X X
Extend rdb$get_context('SYSTEM', '***') with client-related info
104 SS P F P P P P P P F X X X X X X X X X X X X X X X X X X X X X
Extend rdb$get_context('SYSTEM', '***') with client-related info
105 CS P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X
Potential bug in BETWEEN Operator
106 SS P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X
Potential bug in BETWEEN Operator
107 CS P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X
Removing first column with SET WIDTH crashes ISQL
108 SS P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X
Removing first column with SET WIDTH crashes ISQL
109 CS P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X
Crash potentially caused by BETWEEN Operator
110 SS P P P P P P P F X X X X X X X X X X X X X X X X X X X X X X
Crash potentially caused by BETWEEN Operator
111 CS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
112 SS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
113 CS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
Some default values is set incorrectly for SC/CS architectures
114 CS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
Unexpected results when using CASE WHEN with RIGHT JOIN
115 SS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
Unexpected results when using CASE WHEN with RIGHT JOIN
116 CS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
Unexpected results when comparing integer with string containing value out of range of that integer datatype
117 SS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
Unexpected results when comparing integer with string containing value out of range of that integer datatype
118 CS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause
119 SS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause
120 CS P P P F X X X X X X X X X X X X X X X X X X X X X X X X X X
Memory leak when executing a lot of different queries and StatementTimeout > 0
121 SS P P P F X X X X X X X X X X X X X X X X X X X X X X X X X X
Memory leak when executing a lot of different queries and StatementTimeout > 0
122 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
Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete
123 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
Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete
124 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
125 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
126 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
127 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
128 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
129 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
130 CS P P P P P F F F F F F F F F F F F F F F X X X X X X X X X X
INNER JOIN join order LIKE and IS NULL
131 SS P P P P P F F F F F F F F F F F F F F F X X X X X X X X X X
INNER JOIN join order LIKE and IS NULL
132 CS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
ORDER BY ASC using index (multi)
133 SS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
ORDER BY ASC using index (multi)
134 CS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
ORDER BY ASC using index (multi)
135 SS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
ORDER BY ASC using index (multi)
136 CS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
ORDER BY ASC using index (multi) and WHERE clause
137 SS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
ORDER BY ASC using index (multi) and WHERE clause
138 CS P P P P P P P P P P P F P P P P P P P P X X X X X X X X X X
Test exception trapping for result of DECFLOAT operations
139 SS P P P P P P P P P P P F P P P P P P P P X X X X X X X X X X
Test exception trapping for result of DECFLOAT operations
140 CS P P P P P P P P P P P F P P P P P P P P X X X X X X X X X X
Basic test for binary functions against INT128 datatype
141 SS P P P P P P P P P P P F P P P P P P P P X X X X X X X X X X
Basic test for binary functions against INT128 datatype
142 CS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
143 SS P P P P F X X X X X X X X X X X X X X X X X X X X X X X X X
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
144 CS P P P P P P P F F P P P P P P P P P P P X X X X X X X X X X
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
145 SS P P P P P P P F F P P P P P P P P P P P X X X X X X X X X X
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
146 CS P P P P P P P P P P P P F F F P P P P P X X X X X X X X X X
Crash or hang while shutting down the replica database if segments are being applied
147 SS P P P P P P P P P P P P F F F P P P P P X X X X X X X X X X
Crash or hang while shutting down the replica database if segments are being applied
148 CS P P P P P P P P P F P P P P P P P P P P X X X X X X X X X X
External Connections Pool, functionality test 01
149 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
crash on assert or memory corruption when too long username is used for authentication
150 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
crash on assert or memory corruption when too long username is used for authentication
151 CS S S S S S S S S S S S S S S S S S S F F X X X X X X X X X X
Verify ability to make REMOTE connect to security.db
152 SS S S S S S S S S S S S S S S S S S S F F X X X X X X X X X X
Verify ability to make REMOTE connect to security.db
153 CS P P P P P P P P P F F F F F F F F F F F X X X X X X X X X X
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
154 SS P P P P P P P P P P F F P P P P P P P P X X X X X X X X X X
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
155 CS P P P P P P P P P P P P P P P P P P F P X X X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

Elapsed time, milliseconds:

NN Test name mode median_ms 4.0.5.3097
2024-05-16
4.0.5.3091
2024-05-08
4.0.5.3089
2024-04-27
4.0.5.3083
2024-04-20
4.0.5.3052
2024-04-06
4.0.5.3049
2024-01-26
4.0.5.3034
2023-12-30
4.0.4.3013
2023-11-30
4.0.4.2991
2023-11-09
4.0.4.2977
2023-09-15
4.0.3.2955
2023-08-11
4.0.3.2943
2023-06-22
4.0.3.2936
2023-05-25
4.0.3.2931
2023-04-30
4.0.3.2920
2023-04-21
4.0.3.2913
2023-04-02
4.0.3.2908
2023-03-22
4.0.3.2900
2023-03-14
4.0.3.2891
2023-02-09
4.0.3.2885
2023-01-27
X X X X X X X X X X
Test TITLE
1 CS 24313 24668 24450 24355 25463 24573 25052 25041 24076 23683 24187 24271 23463 24244 24587 23214 24104 24491 24945 2452 2276 0 0 0 0 0 0 0 0 0 0
Compress Data over the Network
2 SS 23344 23522 24615 23345 25112 23925 23800 23887 22956 23343 22984 22871 23007 23403 23087 22740 23130 24099 23940 2204 1847 0 0 0 0 0 0 0 0 0 0
Compress Data over the Network
3 CS 679 715 671 680 669 643 715 722 636 645 999 652 708 725 662 656 738 667 678 811 916 0 0 0 0 0 0 0 0 0 0
Index is not used for some date/time expressions in dialect 1
4 SS 485 483 520 484 495 479 488 478 469 470 764 472 468 488 486 487 488 482 491 660 462 0 0 0 0 0 0 0 0 0 0
Index is not used for some date/time expressions in dialect 1
5 CS 1334 1279 1272 1285 1264 1326 1254 1289 1530 1665 1233 1631 1601 1683 1621 1683 1269 1342 1369 1274 1452 0 0 0 0 0 0 0 0 0 0
Suboptimal join plan if there are selective non-indexed predicates involved
6 SS 934 909 924 940 920 928 944 878 1164 1252 874 1192 1191 1218 1222 1590 970 916 906 881 741 0 0 0 0 0 0 0 0 0 0
Suboptimal join plan if there are selective non-indexed predicates involved
7 CS 3856 3778 3847 4088 3846 3820 4184 3902 3798 3785 3716 3966 3790 3807 3867 3866 3804 3867 4125 4028 4264 0 0 0 0 0 0 0 0 0 0
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
8 SS 3234 3243 3229 3232 3232 3215 3815 3223 3662 3251 3202 3235 3208 3234 3234 3240 3267 3236 3249 3335 3174 0 0 0 0 0 0 0 0 0 0
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
9 CS 11395 11457 11894 11904 11441 11339 11467 11487 11490 11356 11317 11358 11391 11382 11399 11314 11413 11320 11323 11340 11706 0 0 0 0 0 0 0 0 0 0
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
10 CS 3002 2999 3016 2784 2764 2762 3006 3010 2975 2783 2753 3005 2775 3017 2792 3031 3028 3060 2790 3141 3276 0 0 0 0 0 0 0 0 0 0
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
11 SS 2474 2484 2489 2478 2474 2490 2497 2465 2456 2481 2456 2464 2446 2471 2474 2584 2472 2469 2472 2554 2477 0 0 0 0 0 0 0 0 0 0
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
12 CS 8685 8657 8909 8952 8642 8601 8866 8712 8589 8726 8608 8898 8670 8601 8613 8652 8720 8700 8611 10907 11524 0 0 0 0 0 0 0 0 0 0
Prohibit an ability to issue DML or DDL statements on RDB$ tables
13 SS 5117 5078 5156 5302 5111 5120 5793 5210 4915 5389 4984 5025 5341 5015 5284 5114 4946 5063 5051 7102 6562 0 0 0 0 0 0 0 0 0 0
Prohibit an ability to issue DML or DDL statements on RDB$ tables
14 CS 1086 1045 1206 1090 1081 1128 1040 1046 1013 1058 1031 1078 1053 1092 1128 1087 1090 1178 1085 1294 1338 0 0 0 0 0 0 0 0 0 0
Add better transaction control to isql
15 SS 688 640 748 704 683 700 707 645 642 670 639 649 662 690 690 706 686 699 701 763 577 0 0 0 0 0 0 0 0 0 0
Add better transaction control to isql
16 CS 1021 1039 1088 1098 1055 1016 995 990 1002 1026 983 986 998 999 992 1008 1084 1060 1053 1276 1232 0 0 0 0 0 0 0 0 0 0
Return nonzero result code when restore fails on activating and creating deferred user index
17 SS 695 747 776 750 766 716 685 657 649 740 656 674 691 723 696 701 680 688 695 787 615 0 0 0 0 0 0 0 0 0 0
Return nonzero result code when restore fails on activating and creating deferred user index
18 CS 15578 15572 15587 15583 15562 15553 15574 15567 15544 15550 15558 15541 15577 15596 15592 15596 15580 15594 15606 15774 15804 0 0 0 0 0 0 0 0 0 0
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
19 SS 15371 15349 15393 15341 15339 15376 15389 15355 15347 15368 15339 15357 15361 15376 15370 15373 15377 15373 15379 15462 15463 0 0 0 0 0 0 0 0 0 0
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
20 CS 502 506 510 506 492 501 551 515 464 488 499 483 486 502 500 519 502 515 500 745 700 0 0 0 0 0 0 0 0 0 0
Support for DROP IDENTITY clause
21 SS 326 325 335 326 313 331 325 330 309 344 311 310 311 329 323 327 333 331 333 418 320 0 0 0 0 0 0 0 0 0 0
Support for DROP IDENTITY clause
22 SS 249 235 276 235 243 239 244 241 239 263 249 239 249 252 261 273 243 252 262 346 262 0 0 0 0 0 0 0 0 0 0
Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change
23 CS 509 500 510 586 493 512 499 508 478 491 468 503 506 514 517 564 507 573 570 711 687 0 0 0 0 0 0 0 0 0 0
Support GENERATED ALWAYS identity columns and OVERRIDE clause
24 SS 330 350 344 318 317 318 357 344 321 337 296 341 329 327 344 329 327 336 331 424 321 0 0 0 0 0 0 0 0 0 0
Support GENERATED ALWAYS identity columns and OVERRIDE clause
25 CS 2638 2625 2639 2669 2637 2627 2653 2613 2631 2637 2609 2619 2751 2650 2635 2635 2648 2653 2640 2806 2877 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
26 SS 2457 2460 2486 2453 2459 2454 2464 2469 2453 2452 2435 2456 2443 2466 2446 2452 2455 2466 2464 2563 2461 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
27 CS 4697 4666 4705 4671 4647 4662 4698 4908 4650 4717 4722 4894 4697 4711 4939 4663 4685 4677 4688 4848 5184 0 0 0 0 0 0 0 0 0 0
Timeouts for running SQL statements and idle connections
28 SS 4488 4492 4556 4494 4482 4485 4495 4475 4479 4504 4488 4471 4477 4486 4468 4485 4488 4495 4489 4572 4494 0 0 0 0 0 0 0 0 0 0
Timeouts for running SQL statements and idle connections
29 CS 516 559 588 493 494 521 498 512 484 494 468 505 512 514 518 522 538 523 523 674 771 0 0 0 0 0 0 0 0 0 0
Add expression index name to exception message if computation failed
30 SS 341 331 357 340 325 342 341 342 329 358 312 314 322 355 345 355 330 354 352 428 330 0 0 0 0 0 0 0 0 0 0
Add expression index name to exception message if computation failed
31 SS 491 498 606 486 489 488 506 490 476 494 484 477 476 494 508 501 492 497 491 563 430 0 0 0 0 0 0 0 0 0 0
Parse error when compiling a statement causes memory leak until attachment is disconnected
32 CS 525 559 568 484 538 504 565 488 522 481 452 483 550 553 503 506 506 528 547 671 720 0 0 0 0 0 0 0 0 0 0
Allow unused Common Table Expressions
33 SS 322 316 337 318 312 329 325 326 304 328 296 315 308 335 324 322 320 322 323 404 307 0 0 0 0 0 0 0 0 0 0
Allow unused Common Table Expressions
34 CS 495 482 481 533 475 495 481 503 472 485 452 471 486 509 505 495 570 500 558 653 684 0 0 0 0 0 0 0 0 0 0
Date-time parsing is very weak
35 SS 325 307 350 322 310 346 323 341 316 349 296 315 328 344 327 324 315 326 329 408 321 0 0 0 0 0 0 0 0 0 0
Date-time parsing is very weak
36 CS 1748 1690 1831 1776 1699 2372 1729 1746 1647 1710 1640 1669 1711 1775 1750 1775 1771 1766 1737 1896 1970 0 0 0 0 0 0 0 0 0 0
Allow the use of management statements in PSQL blocks
37 SS 976 977 1054 976 988 1058 989 991 945 1011 937 960 954 974 976 964 958 980 977 1043 762 0 0 0 0 0 0 0 0 0 0
Allow the use of management statements in PSQL blocks
38 CS 627 597 627 626 596 622 643 640 627 605 608 625 638 624 650 622 653 663 628 1058 1022 0 0 0 0 0 0 0 0 0 0
Make WIN_SSPI plugin produce keys for wirecrypt plugin
39 SS 375 373 413 376 371 403 372 354 373 400 374 369 355 394 370 377 378 370 377 843 623 0 0 0 0 0 0 0 0 0 0
Make WIN_SSPI plugin produce keys for wirecrypt plugin
40 CS 538 504 519 540 507 600 501 580 543 574 499 500 527 536 575 540 531 569 527 661 746 0 0 0 0 0 0 0 0 0 0
Statement level read consistency in read-committed transactions
41 SS 357 348 365 347 343 353 351 359 342 373 358 342 341 363 356 359 358 359 363 458 330 0 0 0 0 0 0 0 0 0 0
Statement level read consistency in read-committed transactions
42 CS 505 504 551 490 558 578 507 503 475 500 483 476 492 510 545 507 499 509 497 637 744 0 0 0 0 0 0 0 0 0 0
Builtin functions converting binary string to hexadecimal representation and vice versa
43 SS 323 320 332 321 325 315 320 330 331 323 295 313 312 324 335 323 323 336 335 406 326 0 0 0 0 0 0 0 0 0 0
Builtin functions converting binary string to hexadecimal representation and vice versa
44 SS 2631 2632 2619 2635 2628 2631 2644 2889 2610 2673 2600 2618 2646 2637 2644 2625 2634 2625 2617 2731 2581 0 0 0 0 0 0 0 0 0 0
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
45 CS 19794 20025 19775 20032 19841 19700 19348 19453 1118 19063 18452 18997 19613 19960 19814 19978 20107 20230 20091 20112 16575 0 0 0 0 0 0 0 0 0 0
A number of errors when database name is longer than 255 symbols
46 SS 14527 15522 14791 14999 14722 15537 14433 14504 1079 15177 13046 14332 14335 14515 14682 14540 14501 14693 14777 14188 10759 0 0 0 0 0 0 0 0 0 0
A number of errors when database name is longer than 255 symbols
47 SS 322 339 324 331 310 344 316 320 310 331 295 319 315 326 319 323 320 321 323 419 330 0 0 0 0 0 0 0 0 0 0
Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS
48 CS 32829 37111 33252 32807 32936 32928 33294 32962 35675 33076 30561 30995 31341 30564 30976 31146 32510 32851 33084 1212 1002 0 0 0 0 0 0 0 0 0 0
Wire compression causes freezes
49 SS 31174 31937 32059 32052 32221 32478 31767 31320 31336 33215 30311 30988 30034 30454 30047 30098 31197 31151 31067 931 663 0 0 0 0 0 0 0 0 0 0
Wire compression causes freezes
50 CS 537 541 561 490 503 502 544 544 550 572 467 503 505 510 563 512 506 542 533 658 756 0 0 0 0 0 0 0 0 0 0
Ability to query Firebird configuration using SQL
51 SS 341 349 1092 311 312 325 310 327 327 331 484 462 466 333 337 351 345 492 346 414 315 0 0 0 0 0 0 0 0 0 0
Ability to query Firebird configuration using SQL
52 CS 953 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 953 0 0 0 0 0 0 0 0 0 0
Dummy test
53 SS 368 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 368 0 0 0 0 0 0 0 0 0 0
Dummy test
54 CS 1311 1375 838 1423 1205 1247 1484 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Backup error for wide table
55 SS 918 927 886 1139 891 910 1298 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Backup error for wide table
56 SS 241 256 237 239 233 250 240 238 223 249 233 222 225 247 253 242 3590 242 265 0 0 0 0 0 0 0 0 0 0 0 0
External engine SYSTEM not found
57 CS 500 475 502 575 491 496 479 524 468 498 468 476 502 496 560 505 569 507 503 0 0 0 0 0 0 0 0 0 0 0 0
Invalid real to string cast.
58 SS 318 354 321 316 311 336 319 318 309 340 296 298 302 318 333 320 317 319 320 0 0 0 0 0 0 0 0 0 0 0 0
Invalid real to string cast.
59 CS 579 600 628 647 603 625 530 525 513 581 562 542 545 577 582 574 600 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
60 SS 401 427 407 411 401 432 402 357 341 407 374 373 371 389 409 389 479 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
61 CS 800 776 800 821 806 803 788 777 811 804 765 806 834 793 785 794 801 787 806 0 0 0 0 0 0 0 0 0 0 0 0
Precision of standalone unit may differ from packaged one in SQL dialect 1
62 SS 366 393 368 365 358 372 371 363 361 379 343 376 366 360 375 365 384 362 366 0 0 0 0 0 0 0 0 0 0 0 0
Precision of standalone unit may differ from packaged one in SQL dialect 1
63 CS 513 552 569 601 547 506 566 502 466 514 483 475 541 516 503 512 513 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
64 SS 330 343 328 323 330 349 343 330 320 347 311 316 313 328 339 337 349 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
65 CS 501 474 574 576 473 496 553 501 477 499 483 524 488 561 504 528 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
66 SS 328 342 328 312 334 341 316 311 307 338 297 314 310 329 335 337 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
67 CS 266 312 325 355 304 321 255 244 242 275 250 266 261 258 259 2897 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Server crash on some LockMemSize values
68 SS 223 254 254 261 243 256 214 209 221 232 217 214 213 214 223 12315 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Server crash on some LockMemSize values
69 CS 11943 11406 11983 12125 11510 12043 11731 11960 11358 12008 11076 11240 11888 11994 11943 11989 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
70 SS 7592 7734 7593 7567 7594 7669 7687 7703 7587 7679 6827 7535 7592 7470 7531 7573 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
71 CS 489 521 491 489 473 547 551 476 473 504 468 483 473 498 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RELEASE SAVEPOINT ONLY works incorrectly
72 SS 319 348 318 319 343 354 317 318 323 335 280 309 311 324 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RELEASE SAVEPOINT ONLY works incorrectly
73 CS 742 711 753 790 708 762 764 748 714 745 702 720 740 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PSQL functions do not convert the output BLOB to the connection character set
74 SS 474 484 475 468 474 501 473 489 464 499 437 472 497 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PSQL functions do not convert the output BLOB to the connection character set
75 CS 1728 1775 1807 1829 1703 1778 1753 1655 1618 1796 1655 1653 1687 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup
76 SS 1081 1157 1122 1091 1120 1193 1072 1048 1018 1159 1046 1053 1043 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Uninitialized/random value assigned to RDB$ROLES -> RDB$SYSTEM PRIVILEGES when restoring from FB3 backup
77 CS 635 597 644 627 586 598 561 522 762 996 780 978 775 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters.
78 SS 436 433 424 405 395 440 363 356 704 806 733 731 732 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Can't backup/restore database from v3 to v4 with SEC$USER_NAME field longer than 10 characters.
79 CS 490 489 485 509 490 501 526 486 466 513 467 494 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY
80 SS 328 357 334 328 334 353 327 324 315 337 312 320 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY
81 CS 491 487 509 491 477 491 530 537 473 515 468 547 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unable to find savepoint in insert with nested query and returning clause in FB4
82 SS 332 342 332 334 323 341 328 346 313 341 311 326 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unable to find savepoint in insert with nested query and returning clause in FB4
83 CS 499 485 510 499 479 498 550 492 536 511 468 525 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
84 SS 328 348 342 325 327 433 324 328 317 346 312 329 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
85 CS 498 497 560 506 488 498 575 495 477 515 483 578 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result ordering in LEFT JOIN query
86 SS 330 336 323 325 332 329 330 331 335 339 312 327 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result ordering in LEFT JOIN query
87 CS 502 540 503 498 528 496 514 485 472 502 468 526 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cursor name can duplicate parameter and variable names in procedures and functions
88 SS 324 337 319 325 324 324 326 331 312 338 311 316 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cursor name can duplicate parameter and variable names in procedures and functions
89 CS 490 479 490 545 468 554 467 496 468 499 483 527 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
rdb$time_zone_util.transitions returns an infinite resultset
90 SS 316 351 323 314 314 308 312 316 323 351 296 322 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
rdb$time_zone_util.transitions returns an infinite resultset
91 CS 1185 1173 1255 1202 1139 1197 1272 1164 1142 1211 1140 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
'with caller privileges' has no effect in triggers
92 SS 707 759 705 703 716 697 710 699 682 780 717 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
'with caller privileges' has no effect in triggers
93 CS 527 528 514 518 540 527 531 559 484 527 515 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
94 SS 351 370 347 342 371 355 341 356 340 357 343 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
95 CS 497 481 512 505 480 505 484 489 526 515 484 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
96 SS 324 356 327 320 335 338 315 322 309 346 311 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
97 CS 494 463 490 540 487 552 541 533 467 499 467 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N)
98 SS 314 334 316 313 325 309 317 309 313 353 312 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Server ignores the size of VARCHAR when performing SET BIND ... TO VARCHAR(N)
99 CS 915 943 916 977 872 915 936 920 828 896 828 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
garbage collection in indexes and blobs is not performed in VIO_backout
100 SS 584 628 572 614 613 596 539 530 502 630 514 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
garbage collection in indexes and blobs is not performed in VIO_backout
101 CS 504 478 506 494 529 554 504 487 463 561 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression when displaying line number of errors in ISQL scripts
102 SS 321 328 319 323 310 324 321 316 300 348 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression when displaying line number of errors in ISQL scripts
103 CS 389 371 407 389 378 392 401 378 374 772 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Extend rdb$get_context('SYSTEM', '***') with client-related info
104 SS 216 234 216 218 216 213 232 213 198 626 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Extend rdb$get_context('SYSTEM', '***') with client-related info
105 CS 485 474 487 480 528 535 533 484 473 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Potential bug in BETWEEN Operator
106 SS 318 334 321 336 312 315 315 322 314 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Potential bug in BETWEEN Operator
107 CS 491 482 497 502 482 497 485 480 522 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Removing first column with SET WIDTH crashes ISQL
108 SS 330 345 332 320 311 325 352 330 331 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Removing first column with SET WIDTH crashes ISQL
109 CS 497 481 505 557 475 490 556 476 544 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash potentially caused by BETWEEN Operator
110 SS 325 341 324 338 319 324 327 319 419 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash potentially caused by BETWEEN Operator
111 CS 602 570 602 655 569 603 576 956 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
112 SS 380 409 375 374 380 386 371 715 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inconsistent state of master-detail occurs after RE-connect + 'SET AUTODDL OFF' + 'drop <FK>' which is ROLLED BACK
113 CS 492 473 492 498 479 492 506 522 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Some default values is set incorrectly for SC/CS architectures
114 CS 489 486 535 493 477 489 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unexpected results when using CASE WHEN with RIGHT JOIN
115 SS 328 356 330 327 328 320 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unexpected results when using CASE WHEN with RIGHT JOIN
116 CS 505 494 586 505 494 515 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unexpected results when comparing integer with string containing value out of range of that integer datatype
117 SS 345 358 345 342 343 346 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unexpected results when comparing integer with string containing value out of range of that integer datatype
118 CS 607 601 676 621 607 558 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause
119 SS 424 443 422 435 424 345 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause
120 CS 18464 18445 18477 18480 18452 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Memory leak when executing a lot of different queries and StatementTimeout > 0
121 SS 18237 18244 18228 18238 18236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Memory leak when executing a lot of different queries and StatementTimeout > 0
122 CS 1215 1159 1271 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete
123 SS 985 981 990 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete
124 CS 545 545 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
125 SS 340 340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
126 CS 2651 2651 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
127 SS 2488 2488 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
128 CS 2632 2632 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
129 SS 2485 2485 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
130 CS 852 864 850 854 828 839 834 866 782 857 718 823 791 805 901 900 867 872 825 996 944 0 0 0 0 0 0 0 0 0 0
INNER JOIN join order LIKE and IS NULL
131 SS 540 548 535 531 534 530 553 542 536 543 514 538 527 561 582 560 546 540 540 606 486 0 0 0 0 0 0 0 0 0 0
INNER JOIN join order LIKE and IS NULL
132 CS 828 830 790 829 846 804 807 801 773 775 828 738 822 823 864 867 835 833 835 932 934 0 0 0 0 0 0 0 0 0 0
ORDER BY ASC using index (multi)
133 SS 495 486 489 485 495 484 500 494 490 542 467 497 499 496 506 511 478 509 512 572 447 0 0 0 0 0 0 0 0 0 0
ORDER BY ASC using index (multi)
134 CS 823 818 834 824 827 809 856 804 762 796 702 750 781 838 829 843 843 822 818 932 900 0 0 0 0 0 0 0 0 0 0
ORDER BY ASC using index (multi)
135 SS 499 486 480 485 489 503 495 495 511 532 467 509 495 509 508 510 516 513 490 577 446 0 0 0 0 0 0 0 0 0 0
ORDER BY ASC using index (multi)
136 CS 544 510 553 547 548 495 584 517 493 565 499 490 563 513 542 597 522 605 520 658 736 0 0 0 0 0 0 0 0 0 0
ORDER BY ASC using index (multi) and WHERE clause
137 SS 347 346 336 345 329 339 360 338 362 355 327 336 335 351 359 348 366 348 354 429 337 0 0 0 0 0 0 0 0 0 0
ORDER BY ASC using index (multi) and WHERE clause
138 CS 495 484 485 476 486 522 492 490 477 489 483 498 486 528 515 579 504 515 507 648 710 0 0 0 0 0 0 0 0 0 0
Test exception trapping for result of DECFLOAT operations
139 SS 325 314 332 313 323 328 331 320 329 326 295 317 321 327 330 318 325 341 327 410 299 0 0 0 0 0 0 0 0 0 0
Test exception trapping for result of DECFLOAT operations
140 CS 495 484 479 480 527 487 493 485 471 490 484 483 501 498 497 528 528 513 516 644 729 0 0 0 0 0 0 0 0 0 0
Basic test for binary functions against INT128 datatype
141 SS 327 326 331 338 321 326 328 323 333 315 311 310 327 329 329 332 327 340 340 450 325 0 0 0 0 0 0 0 0 0 0
Basic test for binary functions against INT128 datatype
142 CS 9405 7689 9405 9446 7668 11250 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
143 SS 7865 9576 7865 7598 7743 9491 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
144 CS 13160 12937 12948 13013 13985 12985 12987 13144 66662 66533 13045 13177 13297 12352 13176 12236 13201 13267 13198 12451 13579 0 0 0 0 0 0 0 0 0 0
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
145 SS 13249 13266 13249 13250 12262 13246 13295 13239 66104 66032 13885 13000 13947 12979 12982 14057 12960 12993 13003 13946 14946 0 0 0 0 0 0 0 0 0 0
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
146 CS 14241 14338 13893 14114 13516 14144 13738 13997 16840 16755 13623 14124 13690 135916 105047 105590 18489 18371 18554 18517 13943 0 0 0 0 0 0 0 0 0 0
Crash or hang while shutting down the replica database if segments are being applied
147 SS 14125 13060 14024 13431 14227 14005 14457 13416 13118 13449 13394 13522 13662 116966 83649 98475 16664 16451 17537 16511 18555 0 0 0 0 0 0 0 0 0 0
Crash or hang while shutting down the replica database if segments are being applied
148 CS 29192 29192 29193 29121 29365 29036 29352 29187 29054 29105 30118 29155 29336 29540 29173 29211 29256 29140 29122 29548 30641 0 0 0 0 0 0 0 0 0 0
External Connections Pool, functionality test 01
149 CS 351 359 355 345 351 336 367 351 341 364 342 377 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
crash on assert or memory corruption when too long username is used for authentication
150 SS 195 278 201 190 196 189 193 206 193 195 170 215 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
crash on assert or memory corruption when too long username is used for authentication
151 CS 1 0 1 1 0 1 0 0 1 0 -1 0 0 0 0 0 0 1 1 962 961 0 0 0 0 0 0 0 0 0 0
Verify ability to make REMOTE connect to security.db
152 SS 475 0 0 0 0 0 0 0 0 1 -1 0 0 0 0 0 0 0 0 603 475 0 0 0 0 0 0 0 0 0 0
Verify ability to make REMOTE connect to security.db
153 CS 29450 48364 48754 48584 48953 48035 50213 49117 49010 47896 27691 27079 27576 27689 27042 28607 28346 27651 28471 30294 28498 0 0 0 0 0 0 0 0 0 0
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
154 SS 24794 41840 41884 42244 41636 41888 41828 41990 41627 41603 22938 23159 23238 23283 23257 23236 23899 23346 23259 25690 22193 0 0 0 0 0 0 0 0 0 0
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
155 CS 4062 6795 6739 6706 6762 6687 6744 6695 6646 6803 3389 3849 3669 3895 3530 3967 3546 3497 3551 4158 3858 0 0 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1812
http://tracker.firebirdsql.org/browse/core-2078
http://tracker.firebirdsql.org/browse/core-3537
http://tracker.firebirdsql.org/browse/core-4236
http://tracker.firebirdsql.org/browse/core-4319
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-4933
http://tracker.firebirdsql.org/browse/core-5201
http://tracker.firebirdsql.org/browse/core-5222
http://tracker.firebirdsql.org/browse/core-5431
http://tracker.firebirdsql.org/browse/core-5434
http://tracker.firebirdsql.org/browse/core-5463
http://tracker.firebirdsql.org/browse/core-5470
http://tracker.firebirdsql.org/browse/core-5488
http://tracker.firebirdsql.org/browse/core-5606
http://tracker.firebirdsql.org/browse/core-5646
http://tracker.firebirdsql.org/browse/core-5674
http://tracker.firebirdsql.org/browse/core-5750
http://tracker.firebirdsql.org/browse/core-5887
http://tracker.firebirdsql.org/browse/core-5948
http://tracker.firebirdsql.org/browse/core-5953
http://tracker.firebirdsql.org/browse/core-6049
http://tracker.firebirdsql.org/browse/core-6095
http://tracker.firebirdsql.org/browse/core-6248
http://tracker.firebirdsql.org/browse/core-6281
http://tracker.firebirdsql.org/browse/core-6348
http://tracker.firebirdsql.org/browse/core-6444
http://tracker.firebirdsql.org/browse/core-733
http://tracker.firebirdsql.org/browse/core-9999
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/bugs/test_trace_eol.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/bugs/test_trace_eol_cr_space_nl.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_13.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_19.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_decfloat_exceptions_trapping.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_int128_binary_operations.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_characters_garbled_when_conn_charset_differs.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_invalid_msg_if_target_db_has_no_replica_flag.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_shutdown_during_applying_segments_leads_to_crash.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/session/test_ext_conn_pool_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_crash_when_too_long_username_for_auth.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_remote_access_to_security_db.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_max_limit.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_04.py
https://github.com/FirebirdSQL/firebird/issues/7436
https://github.com/FirebirdSQL/firebird/issues/7484
https://github.com/FirebirdSQL/firebird/issues/7488
https://github.com/FirebirdSQL/firebird/issues/7499
https://github.com/FirebirdSQL/firebird/issues/7501
https://github.com/FirebirdSQL/firebird/issues/7517
https://github.com/FirebirdSQL/firebird/issues/7537
https://github.com/FirebirdSQL/firebird/issues/7545
https://github.com/FirebirdSQL/firebird/issues/7548
https://github.com/FirebirdSQL/firebird/issues/7591
https://github.com/FirebirdSQL/firebird/issues/7604
https://github.com/FirebirdSQL/firebird/issues/7610
https://github.com/FirebirdSQL/firebird/issues/7611
https://github.com/FirebirdSQL/firebird/issues/7638
https://github.com/FirebirdSQL/firebird/issues/7651
https://github.com/FirebirdSQL/firebird/issues/7664
https://github.com/FirebirdSQL/firebird/issues/7665
https://github.com/FirebirdSQL/firebird/issues/7670
https://github.com/FirebirdSQL/firebird/issues/7683
https://github.com/FirebirdSQL/firebird/issues/7691
https://github.com/FirebirdSQL/firebird/issues/7713
https://github.com/FirebirdSQL/firebird/issues/7727
https://github.com/FirebirdSQL/firebird/issues/7730
https://github.com/FirebirdSQL/firebird/issues/7747
https://github.com/FirebirdSQL/firebird/issues/7761
https://github.com/FirebirdSQL/firebird/issues/7818
https://github.com/FirebirdSQL/firebird/issues/7839
https://github.com/FirebirdSQL/firebird/issues/7844
https://github.com/FirebirdSQL/firebird/issues/7860
https://github.com/FirebirdSQL/firebird/issues/7899
https://github.com/FirebirdSQL/firebird/issues/7927
https://github.com/FirebirdSQL/firebird/issues/7993
https://github.com/FirebirdSQL/firebird/issues/7997
https://github.com/FirebirdSQL/firebird/issues/8056
https://github.com/FirebirdSQL/firebird/issues/8085
https://github.com/FirebirdSQL/firebird/issues/8104
https://github.com/FirebirdSQL/firebird/issues/8108

=== end of list ===