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 (4 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (23 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (4 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (50 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 30 runs (138 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (1090 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (2 rows)
11. All tests: outcomes for previous 30 runs (3693 rows)
12. Skipped: tests which was intentionally excluded from execution (82 rows)

Generated UTC 17.01.2025 09:39
Tested: HQ50.   Build / date: 5.0.2.1577-3c80e7c5 / 2024.12.24;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.6; firebird.Qa: 0.19.3 
Loading data. Please wait...

Jump to the list of unique test names from this report
Jump to the list with last developing commits information

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

NN Test name mode
5.0.2.1577
2024.12.24
5.0.2.1576
2024.12.17
5.0.2.1575
2024.12.09
5.0.2.1575
2024.12.08
5.0.2.1571
2024.12.08
5.0.2.1567
2024.12.07
5.0.2.1567
2024.12.02
5.0.2.1567
2024.11.26
5.0.2.1567
2024.11.21
5.0.2.1567
2024.11.18
5.0.2.1533
2024.10.23
5.0.2.1533
2024.10.22
5.0.2.1532
2024.10.15
5.0.2.1518
2024.10.04
5.0.2.1518
2024.09.26
5.0.2.1489
2024.08.31
5.0.2.1476
2024.08.09
5.0.1.1454
2024.08.08
5.0.1.1453
2024.08.07
5.0.1.1453
2024.08.06
5.0.1.1453
2024.07.30
5.0.1.1453
2024.07.28
5.0.1.1429
2024.07.19
5.0.1.1428
2024.07.15
5.0.1.1428
2024.06.30
5.0.1.1415
2024.06.12
5.0.1.1415
2024.06.11
5.0.1.1401
2024.06.05
5.0.1.1398
2024.05.10
5.0.1.1397
2024.05.09
Test TITLE
1 CS P P P P P P P P P P P P P P P P P P P P P P P P P P F P P F
Count (DISTINCT ...) is too slow
2 CS F P F F F F F P F F P P P F F P F F F F P P P P P P P P P P
Compress Data over the Network
3 SS P F P P P P F P P P F P P P P P P P P P P P P P P P P P P P
Compress Data over the Network
4 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
5 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
6 CS P P P P P P P P P P P P P P P P P P P P P P P P P P F F P P
exclude_filter doesn't work for <services></section> section of the Trace facility
7 SS P P P P P P P P P P P P P P P P P P P P P P P P P P F F P P
exclude_filter doesn't work for <services></section> section of the Trace facility
8 SS P P P P P F P P P P P P P P P P P P P P P P P P P P P P P P
Ability to cancel waiting in lock manager
9 CS P P P P P P P P P P P P P P P P P P P P P P P P P P F F P P
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
10 SS P P P P P P P P P P P P P P P P P P P P P P P P P P F F P P
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
11 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
12 SS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
13 CS P P P P P P P P P P P P P P P F P P P P P P P P P P P P P P
IIF function prevents the condition from being pushed into the union for better optimization
14 CS P P P P P P P P P P P P P P P P P P P P P P P P P F S S S S
Allow to enforce IPv4 or IPv6 in URL-like connection strings
15 SS P P P P P P P P P P P P P P P P P P P P P P P P P F S S S S
Allow to enforce IPv4 or IPv6 in URL-like connection strings
16 CS P P P P P P P P P P P P P P P P P P P P P P P P P P F P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
17 SS P P P P P P P P P P P P P P P P P P P P P P P P P P F P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
18 CS P P P P P P P P P P P P P P P P F P P P P P P P P P P P P P
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
19 CS F F F F F F F F F F P P P P P P P P P P P P P P P P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
20 SS F F F F F F F F F F P P P P P P P P P P P P P P P P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
21 CS P P P P P P P P P F P P P P P P P P P P P P P P P P P P P P
Put options in user management statements in any order
22 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
Firebird is freezing when trying to manage users via triggers
23 SS P P P F F F F P P E P P P P P P P P P P P P P P P P P P P P
Firebird is freezing when trying to manage users via triggers
24 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
25 SS P P P F F F F P P E P P P P P P P P P P P P P P P P P P P P
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
26 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P X
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
27 SS P P P F F F F P P E P P P P P P P P P P P P P P P P P P P X
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
28 CS P P P P P P P P P P P P P P P P P P P P P P P P P P F F F F
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
29 SS P P P P P P P P P E P P P P P P P P P P P P P P P P F F F F
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
Wrong detection of must-be-delimited user names
31 SS P P P F F F F P P F P P P P P P P P P P P P P P P P P P P P
Wrong detection of must-be-delimited user names
32 SS P P P P P F P P P E P P P P P P P P P P P P P X X X X X X X
Memory leak in GDS32.DLL(FBClient.DLL), when multi-database transaction has done
33 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
Database restore must make every effort on activating deferred indexes
34 SS P P P P P P P P P E F X X X X X X X X X X X X X X X X X X X
Database restore must make every effort on activating deferred indexes
35 SS P P P P P P P P P F P P P P P P P P P P P P P P P P P P P P
Server crashes when working with DSQL savepoints
36 SS F F F F F F F F F E F X X X X X X X X X X X X X X X X X X X
Events in system attachments (like garbage collector) are not traced
37 CS F F F F F F F F F F P P P P P P P P P P P P P P P P P P P P
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
38 SS F F F F F F F F F E P P P P P P P P P P P P P P P P P P P P
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
39 SS P P P P P P P P P F P P P P P P P P P P P P P P P P P P P P
Server crash on some LockMemSize values
40 CS P P P P P P P P P P P P P P P P P P P P P F F F X X X X X X
Make the profiler store aggregated requests by default, with option for detailed store
41 SS P P P P P P P P P E P P P P P P P P P P P F F F X X X X X X
Make the profiler store aggregated requests by default, with option for detailed store
42 CS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
Inner join raises error "no current record for fetch operation" if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table
43 SS P P P P P P P P P E P P P P P P P P P P P P P P P F X X X X
Inner join raises error "no current record for fetch operation" if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table
44 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P F X X
Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
45 SS P P P P P P P P P E P P P P P P P P P P P P P P P P P F X X
Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
46 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P F F X
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
47 SS P P P P P P P P P E P P P P P P P P P P P P P P P P P F F X
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
48 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P F F X
Error isc_read_only_trans (335544361) should report SQLSTATE 25006.
49 SS P P P P P P P P P E P P P P P P P P P P P P P P P P P F F X
Error isc_read_only_trans (335544361) should report SQLSTATE 25006.
50 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P F X X
Cast dies with numeric value is out of range error
51 SS P P P P P P P P P E P P P P P P P P P P P P P P P P P F X X
Cast dies with numeric value is out of range error
52 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P F F X
Procedure manipulation can lead to wrong dependencies removal
53 SS P P P P P P P P P E P P P P P P P P P P P P P P P P P F F X
Procedure manipulation can lead to wrong dependencies removal
54 CS P P P P P P P P P P P P P P P P P P P P P P F F F X X X X X
Check result of conversion to string in COALESCE that involves all families of data types.
55 SS P P P P P P P P P E P P P P P P P P P P P P F F F X X X X X
Check result of conversion to string in COALESCE that involves all families of data types.
56 CS P P P P P P P P P P P P P P P P P P P P P P F F F X X X X X
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
57 SS P P P P P P P P P E P P P P P P P P P P P P F F F X X X X X
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
58 CS F F F F F F F F F F P X X X X X X X X X X X X X X X X X X X
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
59 SS F F F F F F F F F E P X X X X X X X X X X X X X X X X X X X
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
60 CS 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 X
DATEADD truncates milliseconds for month and year deltas.
61 SS P P P P P P P P P E P P P P P P F X X X X X X X X X X X X X
DATEADD truncates milliseconds for month and year deltas.
62 CS 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 X
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
63 SS P P P P P P P P P E P P P P P P F X X X X X X X X X X X X X
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
64 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
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
65 SS P P P P P P P P P E F X X X X X X X X X X X X X X X X X X X
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
66 CS 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 X
Crash when MAKE_DBKEY() is called with 0 or 1 arguments
67 CS 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 X
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
68 CS 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 X
Problematic queries when SubQueryConversion = true
69 CS 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 X
SubQueryConversion = true - multiple rows in singleton select
70 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
gbak may lose NULLs in restore
71 SS P P P P P P P P P E P P P P P F X X X X X X X X X X X X X X
gbak may lose NULLs in restore
72 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
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
73 SS P P P P P P P P P E P P P P P F X X X X X X X X X X X X X X
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
74 CS P P P F F F F P P P P P P P P F X X X X X X X X X X X X X X
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
75 SS P P P F F F F P P E P P P P P F X X X X X X X X X X X X X X
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
76 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
Catch possible stack overflow when preparing and compiling user statements
77 CS 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 X X X X X
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
78 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
Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
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
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
80 SS P P P P P P P P P E F X X X X X X X X X X X X X X X X X X X
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
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
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
82 SS P P P P P P P P P E F X X X X X X X X X X X X X X X X X X X
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
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
wrong results using minvalue/maxvalue in join condition
84 SS P P P P P P P P P E F X X X X X X X X X X X X X X X X X X X
wrong results using minvalue/maxvalue in join condition
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
Collect network statistics and make it available for the user applications
86 SS P P P P P P P P P E F X X X X X X X X X X X X X X X X X X X
Collect network statistics and make it available for the user applications
87 CS P P P P P F F F X X X X X X X X X X X X X X X X X X X X X X
Add AUTO RELEASE TEMP BLOBID transaction option
88 SS P P P P P F F F X X X X X X X X X X X X X X X X X X X X X X
Add AUTO RELEASE TEMP BLOBID transaction option
89 SS F F X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Report unique usernames for isc_info_user_names
90 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
Crash when creating index on table that uses UDR and ParallelWorkers > 1
91 CS X X X X X X X X X X X X X X X X X X X X X X X X X X X X F X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
92 SS X X X X X X X X X X X X X X X X X X X X X X X X X X X X F X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
93 CS X X X X X X X X X X X X X X X X X X X X X X X X X X X X F X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
94 SS X X X X X X X X X X X X X X X X X X X X X X X X X X X X F X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
95 CS P P P P P P P P P P F P P P P P P P P P P P P P P P P P P P
INNER JOIN join order LIKE and STARTING WITH
96 SS P P P P P P P P P E F P P P P E E P P P P P P P P P P P P P
INNER JOIN join order LIKE and STARTING WITH
97 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
98 SS F F F F F F F F F E F F F F F E E F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
99 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
100 SS F F F F F F F F F E F F F F F E E F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
101 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi) and WHERE clause
102 SS F F F F F F F F F E F F F F F E E F F F F F F F F F F F F F
ORDER BY ASC using index (multi) and WHERE clause
103 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
ISQL - SHOW DATABASE
104 SS P P P F F F F P P E P P P P P E E P P P P P P P P P P P P P
ISQL - SHOW DATABASE
105 CS F F F F F F F P P P P P P P P P P P P P P P P P P P P P P P
ISQL - SHOW SYSTEM TABLES
106 SS F F F F F F F P P E P P P P P E E P P P P P P P P P P P P P
ISQL - SHOW SYSTEM TABLES
107 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Add REPLICA MODE to the output of the isql SHOW DATABASE command
108 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
ISQL showing publication status
109 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
110 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
111 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Problem with replication of BLOB segments longer than 32KB
112 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
113 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
DDL-triggers must fire only on master DB
114 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Disallow replication of RDB$BACKUP_HISTORY
115 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
116 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Failed DDL commands can be replicated
117 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Generator values may not replicate after commit
118 CS P P P P P P P P P P P P P P P P P P P P F P P P F P P P P P
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
119 SS P P P P P P P P P F P P P P P F F P P P F P P P F P P P P P
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
120 CS F F F X X X X X X X X X X X X X X X X X X X X X X X X X X X
Make asynchronous replica re-initialization reliable #8324
121 SS F F F X X X X X X X X X X X X X X X X X X X X X X X X X X X
Make asynchronous replica re-initialization reliable #8324
122 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Applying full DDL from OLTP-EMUL test on master with further check replica
123 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Crash or hang while shutting down the replica database if segments are being applied
124 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Some updates can crash Firebird server on replica side
125 SS P P P P P P P P P F P P P P P F F P P P P P P P P P P P P P
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
126 CS P P P P P P P P P P P P P P P P P P P P P P P P P P F F P P
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
127 SS P P P P P P P P P E P P P P P E E P P P P P P P P P F F P P
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
128 CS P P P P P P P P P P F P P P P P P P P P P P P P P P P P P P
External Connections Pool, functionality test 01
129 CS P P P F F F F P P P P P P P P P P P P P P P P P P P P P P P
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
130 SS P P P F F F F P P E P P P P P E E P P P P P P P P P P P P P
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
131 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
132 SS F F F F F F F F F E F F F F F E E F F F F F F F F F F F F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
133 CS P P P F F F F P P P P P P P P P P P P P P P P X X X X X X X
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
134 SS P P P F F F F P P E P P P P P E E P P P P P P X X X X X X X
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
135 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
Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join
136 CS F F F F F F F F F F P P P P P P P P P P P P P P P P P P P P
Allow computable but non-invariant lists to be used for index lookup
137 SS F F F F F F F F F E P P P P P E E P P P P P P P P P P P P P
Allow computable but non-invariant lists to be used for index lookup
138 CS S S S S S S S S S S S S S S S F S S S S S S S S S S S S S S
CREATE VIEW as SELECT ....

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.2.1577
2024.12.24
5.0.2.1576
2024.12.17
5.0.2.1575
2024.12.09
5.0.2.1575
2024.12.08
5.0.2.1571
2024.12.08
5.0.2.1567
2024.12.07
5.0.2.1567
2024.12.02
5.0.2.1567
2024.11.26
5.0.2.1567
2024.11.21
5.0.2.1567
2024.11.18
5.0.2.1533
2024.10.23
5.0.2.1533
2024.10.22
5.0.2.1532
2024.10.15
5.0.2.1518
2024.10.04
5.0.2.1518
2024.09.26
5.0.2.1489
2024.08.31
5.0.2.1476
2024.08.09
5.0.1.1454
2024.08.08
5.0.1.1453
2024.08.07
5.0.1.1453
2024.08.06
5.0.1.1453
2024.07.30
5.0.1.1453
2024.07.28
5.0.1.1429
2024.07.19
5.0.1.1428
2024.07.15
5.0.1.1428
2024.06.30
5.0.1.1415
2024.06.12
5.0.1.1415
2024.06.11
5.0.1.1401
2024.06.05
5.0.1.1398
2024.05.10
5.0.1.1397
2024.05.09
Test TITLE
1 CS 2054 18262 18637 18263 17778 17996 18043 17665 18146 1971 2031 2138 2001 2106 2036 2043 1985 2038 2125 2045 2152 1895 1910 2149 1912 1878 1848 2093 1703 1750 2063
Count (DISTINCT ...) is too slow
2 CS 17102 17332 16309 18168 16591 16359 16553 16017 16161 16695 16836 17062 16205 16373 17010 18835 16089 16945 16942 17143 17261 24395 24688 24309 24176 23396 23549 23799 24205 24143 23893
Compress Data over the Network
3 SS 16123 15456 16364 15290 15072 16332 16162 15288 16151 15392 16095 15707 15752 15395 15330 15481 15383 15656 16032 16286 15841 24888 22971 22784 22752 22892 22931 22971 23158 23252 23143
Compress Data over the Network
4 CS 714 814 777 809 721 703 745 694 801 775 768 808 805 812 822 775 771 707 705 733 533 535 524 614 551 531 523 484 500 484 500
Improve sorting performance when long VARCHARs are involved
5 SS 446 835 470 467 409 414 444 392 487 488 489 473 477 481 474 483 482 458 449 449 342 366 354 338 342 357 339 266 266 266 266
Improve sorting performance when long VARCHARs are involved
6 CS 2726 2731 2727 2740 2667 2665 2692 2719 2740 2739 2791 2727 2725 2738 2731 2734 2737 2806 3079 2822 2659 2602 2608 2669 2597 2597 2616 2594 2954 2594 2594
exclude_filter doesn't work for <services></section> section of the Trace facility
7 SS 2519 2541 2535 2516 2449 2477 2452 2452 2701 2513 2531 2533 2520 2546 2522 2527 2519 2563 2568 2567 2786 2465 2449 2444 2444 2452 2441 2719 2719 2360 2360
exclude_filter doesn't work for <services></section> section of the Trace facility
8 SS 5963 5960 5943 5941 5871 5912 15567 6004 5978 6213 5969 5954 5968 5956 5966 5987 5966 5987 5982 6027 6466 6175 5872 5878 5975 5862 5891 5922 5938 5938 5938
Ability to cancel waiting in lock manager
9 CS 2399 2401 2398 2410 2352 2352 2421 2378 2400 2404 2404 2405 2494 2582 2419 2401 2414 2478 2468 2708 2319 2306 2278 2277 2324 2322 2278 2265 2266 2266 2251
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
10 SS 2221 2231 2221 2223 2219 2192 2228 2182 2225 2576 2220 2221 2646 2225 2243 2296 2223 2265 2263 2267 2148 2148 2144 2237 2143 2143 2144 2094 2094 2110 2109
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
11 CS 1236 1207 1251 1211 861 1067 936 877 1199 1207 1217 1211 1202 1215 1216 1221 1206 1386 1529 1499 1363 1303 1295 1361 1285 1373 1304 1437 1422 1422 1438
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
12 SS 854 838 828 823 885 1779 783 566 830 841 830 912 830 828 851 851 826 989 979 979 1037 874 857 867 848 864 842 922 891 891 907
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
13 CS 2955 2995 2965 2951 2945 3120 2877 2882 2949 2992 2963 3215 2959 3044 3017 3108 5122 3052 3021 3041 2870 2849 2905 2893 2837 2833 3077 2812 2844 2797 2797
IIF function prevents the condition from being pushed into the union for better optimization
14 CS 857 885 861 862 755 907 1112 763 866 857 854 916 858 875 851 900 865 955 933 954 819 772 750 750 795 756 1090 0 0 0 0
Allow to enforce IPv4 or IPv6 in URL-like connection strings
15 SS 423 480 441 428 328 337 415 322 438 454 446 443 433 422 436 442 425 487 477 469 370 372 354 354 367 349 685 0 0 0 0
Allow to enforce IPv4 or IPv6 in URL-like connection strings
16 CS 874 936 883 930 819 847 786 777 882 920 867 886 960 889 916 909 888 946 950 1035 987 841 838 763 765 835 760 734 734 734 735
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
17 SS 586 595 607 593 517 541 545 700 601 618 592 641 582 590 595 612 594 661 631 640 534 527 523 556 523 529 526 407 406 407 407
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
18 CS 3053 3056 3054 3082 2991 3048 3033 2996 3064 3056 3058 3053 3074 3077 3064 3069 3074 3803 3140 3126 2941 3048 2934 2933 3079 2942 2934 2923 2922 2922 2922
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
19 CS 2683 1523 1832 1518 1260 1350 1445 1253 1833 1471 1468 2706 2708 2710 2728 2691 2720 2777 2782 2802 3163 2702 2676 2649 2674 2576 2574 7329 8017 7469 7470
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
20 SS 1832 727 741 1052 660 732 749 662 1067 1063 1071 1898 1940 1913 1922 1908 1921 1950 1935 1948 1974 1824 1834 1830 1825 1823 1829 6391 6704 6720 6641
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
21 CS 3553 3646 3909 3649 3463 3338 3397 3353 3608 3919 3418 3950 3636 3646 3600 3628 3566 3715 3718 3777 3597 3541 3464 3508 3505 3480 3541 3173 3141 3203 3157
Put options in user management statements in any order
22 CS 988 959 989 974 622 622 585 592 964 952 956 1003 962 950 963 1032 962 1096 1176 1220 1012 1021 990 988 1065 971 1013 1125 1157 1125 1110
Firebird is freezing when trying to manage users via triggers
23 SS 665 662 679 660 375 664 461 631 686 672 2394 659 677 665 656 713 653 749 825 765 665 661 659 651 653 672 666 782 766 766 750
Firebird is freezing when trying to manage users via triggers
24 CS 1963 1893 1887 1965 591 594 576 578 1872 1871 1906 1962 1917 1887 1905 1954 1905 2120 2335 2457 2172 2197 2178 2186 2253 2322 2186 2344 2344 2344 2360
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
25 SS 1503 1448 1480 1416 380 369 368 377 1456 1453 2423 1419 1406 1433 1429 1445 1437 1774 1673 1660 1675 1556 1561 1530 1527 1599 1541 1828 1828 1828 1828
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
26 CS 758 770 764 770 673 672 679 665 760 758 776 796 773 768 771 1356 776 837 827 864 691 656 643 639 677 648 652 657 656 657 0
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
27 SS 430 434 436 448 358 358 359 368 434 533 2380 437 462 430 437 440 430 473 473 467 348 365 354 368 356 398 348 250 250 250 0
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
28 CS 21663 21666 21640 21975 21592 21577 21599 21572 21683 22020 21672 21907 21823 21652 21661 21644 21845 21837 21741 21784 21611 21584 21553 21567 21623 21564 21558 22472 22472 22815 22456
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
29 SS 21447 21423 21431 21462 21393 21355 21927 21392 21450 21448 2235 21466 21464 21487 21446 21432 21449 21492 21486 21473 21366 21374 21352 21343 21356 21359 21378 22237 23237 22596 22612
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30 CS 13922 13963 13888 13926 379 438 423 398 13885 13814 13775 13972 13937 13919 13872 13909 14074 13982 15182 15233 15772 15333 15508 15182 15283 15470 15233 12830 12986 12752 12736
Wrong detection of must-be-delimited user names
31 SS 9357 9361 9371 9354 380 455 1345 378 9351 9352 2498 9377 9381 9436 9382 9350 9351 9371 9403 9371 9444 9460 9410 9426 9345 9412 9422 8360 8376 8376 8376
Wrong detection of must-be-delimited user names
32 SS 8879 8261 9335 8892 7967 9215 8112 7852 8925 8040 2379 8959 9595 8879 9497 8528 8103 8273 9463 8137 9332 9066 9452 7887 0 0 0 0 0 0 0
Memory leak in GDS32.DLL(FBClient.DLL), when multi-database transaction has done
33 CS 728 734 725 740 661 664 714 670 733 728 741 1042 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Database restore must make every effort on activating deferred indexes
34 SS 490 521 490 493 436 440 450 426 501 540 2382 481 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Database restore must make every effort on activating deferred indexes
35 SS 312 290 292 293 271 274 271 273 286 310 4083 299 312 298 329 299 299 379 375 372 385 382 373 381 379 394 370 344 313 312 313
Server crashes when working with DSQL savepoints
36 SS 302 302 304 299 239 482 243 470 298 313 2384 301 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Events in system attachments (like garbage collector) are not traced
37 CS 3022 3006 3009 3029 2947 2960 2991 2939 2998 3005 3027 2981 2998 3001 3010 4023 3017 3078 3047 3058 3867 2938 3150 3171 3157 2927 3160 3094 3173 3095 3094
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
38 SS 2526 2543 3584 2548 2498 2493 2519 2481 2548 2563 2392 2536 2540 2535 2524 2529 2547 2590 2573 2577 2462 2466 2458 2536 2468 2682 2444 2360 2360 2359 2359
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
39 SS 212 203 202 203 189 190 190 195 199 203 2248 198 200 198 206 199 204 250 239 244 246 256 248 246 249 252 233 250 219 219 219
Server crash on some LockMemSize values
40 CS 922 936 930 889 847 865 857 855 931 923 894 911 931 940 891 896 922 1038 1010 1056 892 869 1287 1220 1217 0 0 0 0 0 0
Make the profiler store aggregated requests by default, with option for detailed store
41 SS 623 639 627 616 562 565 568 566 611 616 2381 620 615 644 618 659 640 661 694 667 532 548 930 884 861 0 0 0 0 0 0
Make the profiler store aggregated requests by default, with option for detailed store
42 CS 593 598 611 597 529 557 558 566 606 594 593 590 604 603 598 614 602 718 661 668 496 524 476 478 504 472 468 0 0 0 0
Inner join raises error "no current record for fetch operation" if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table
43 SS 391 427 400 393 329 333 359 325 388 399 2260 392 393 395 400 391 392 437 433 427 314 311 326 322 314 334 339 0 0 0 0
Inner join raises error "no current record for fetch operation" if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table
44 CS 8436 8443 8440 8457 7372 7383 7379 7375 8440 8436 8436 8442 8444 8457 8443 8457 8453 8510 8512 8506 8331 8326 8326 8327 8331 8325 8322 8314 5329 0 0
Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
45 SS 3212 3214 3212 3214 2146 2171 2158 2151 3212 3214 2392 3233 3221 3222 3227 3222 3222 3262 3262 3262 3146 3144 3147 3147 3145 3161 3146 3110 4157 0 0
Error "Too many recursion levels" does not stop execuition of code that uses ON DISCONNECT trigger (FB 4.x+)
46 CS 580 587 627 584 555 541 592 516 622 588 580 588 594 623 621 578 615 679 724 702 575 497 473 482 508 482 495 422 422 454 0
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
47 SS 372 390 391 376 325 324 344 322 386 372 2420 392 396 390 398 396 381 435 438 414 317 307 303 316 302 323 315 235 234 234 0
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
48 CS 671 713 672 716 646 634 624 609 688 720 671 736 682 717 684 706 689 742 810 778 572 584 566 653 600 569 626 516 515 547 0
Error isc_read_only_trans (335544361) should report SQLSTATE 25006.
49 SS 424 448 436 432 353 377 392 373 441 441 2438 430 425 442 445 424 441 467 494 470 357 359 361 368 342 384 347 281 266 266 0
Error isc_read_only_trans (335544361) should report SQLSTATE 25006.
50 CS 582 592 585 586 514 556 716 516 581 597 593 643 591 643 587 579 584 644 654 735 472 524 474 465 504 529 523 422 454 0 0
Cast dies with numeric value is out of range error
51 SS 379 405 385 385 308 321 331 315 388 374 2411 386 388 386 401 388 384 415 417 428 310 321 299 308 297 331 302 266 234 0 0
Cast dies with numeric value is out of range error
52 CS 612 623 675 641 551 616 609 575 644 624 622 618 648 628 612 617 612 671 743 717 516 555 496 560 589 495 505 469 484 484 0
Procedure manipulation can lead to wrong dependencies removal
53 SS 399 406 409 412 349 344 371 344 407 399 2400 405 407 443 427 412 409 454 463 451 333 337 329 333 329 343 326 250 250 250 0
Procedure manipulation can lead to wrong dependencies removal
54 CS 1633 2319 2176 2187 2130 2117 2500 2088 2164 2188 2158 2082 2128 1286 1281 1272 1250 1323 1484 1386 1189 1182 1158 1350 1317 1633 0 0 0 0 0
Check result of conversion to string in COALESCE that involves all families of data types.
55 SS 1406 1960 1958 1948 1878 1874 1966 1882 1933 1950 2390 1850 1894 1119 1188 1047 1047 1085 1125 1088 979 976 977 1043 1155 1406 0 0 0 0 0
Check result of conversion to string in COALESCE that involves all families of data types.
56 CS 586 619 594 586 524 537 602 532 587 583 613 585 589 593 648 583 623 657 739 665 565 549 481 506 496 546 0 0 0 0 0
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
57 SS 385 376 392 388 326 321 348 312 385 388 2403 378 389 411 392 391 389 424 421 443 312 316 298 319 324 331 0 0 0 0 0
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
58 CS 697 758 715 702 637 933 689 640 697 704 694 687 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
59 SS 479 497 489 479 663 420 448 414 472 475 2394 480 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
60 CS 609 609 582 583 519 524 1503 554 621 641 641 621 634 591 629 581 582 657 0 0 0 0 0 0 0 0 0 0 0 0 0
DATEADD truncates milliseconds for month and year deltas.
61 SS 381 379 424 381 323 332 312 320 374 380 2396 396 381 397 376 383 383 770 0 0 0 0 0 0 0 0 0 0 0 0 0
DATEADD truncates milliseconds for month and year deltas.
62 CS 619 643 619 615 546 601 1353 542 615 625 643 641 613 626 622 617 613 675 0 0 0 0 0 0 0 0 0 0 0 0 0
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
63 SS 411 425 421 416 350 361 354 347 425 402 2391 422 415 411 410 404 407 449 0 0 0 0 0 0 0 0 0 0 0 0 0
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
64 CS 666 696 692 666 623 631 1360 593 659 725 660 714 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
65 SS 431 429 439 451 374 377 367 394 437 431 2417 463 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
66 CS 595 606 613 583 527 543 1147 518 633 581 595 585 592 595 589 618 596 2991 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash when MAKE_DBKEY() is called with 0 or 1 arguments
67 CS 701 746 708 693 639 625 1489 629 714 700 686 701 715 722 843 700 690 926 0 0 0 0 0 0 0 0 0 0 0 0 0
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
68 CS 697 724 697 682 629 626 1294 638 690 708 700 681 698 695 700 695 706 784 0 0 0 0 0 0 0 0 0 0 0 0 0
Problematic queries when SubQueryConversion = true
69 CS 687 723 709 684 635 623 1364 627 687 685 685 686 694 700 701 690 683 793 0 0 0 0 0 0 0 0 0 0 0 0 0
SubQueryConversion = true - multiple rows in singleton select
70 CS 1341 1364 1387 1342 1180 1171 3084 1224 1364 1362 1341 1354 1332 1329 1379 1332 1330 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gbak may lose NULLs in restore
71 SS 886 887 886 861 781 751 922 772 893 877 2411 875 895 901 902 884 1440 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gbak may lose NULLs in restore
72 CS 434 434 461 434 387 412 681 391 438 443 436 425 433 430 433 460 468 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
73 SS 260 270 262 260 206 246 227 212 274 261 2400 258 256 252 268 263 274 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
74 CS 751 740 779 754 602 619 1623 616 750 753 748 749 755 759 763 743 768 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
75 SS 502 507 506 501 379 387 426 371 491 498 2415 501 504 510 507 511 531 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
76 CS 723 716 736 742 646 631 1403 636 714 704 748 734 724 722 754 713 6633 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Catch possible stack overflow when preparing and compiling user statements
77 CS 1094 1092 1104 1088 984 1102 3251 973 1060 1059 1311 1087 1427 1427 1099 1094 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
78 CS 995 991 991 1003 936 929 1567 942 995 998 991 1008 992 995 1018 996 1000 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
79 CS 697 723 690 722 624 633 812 641 693 725 697 710 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
80 SS 451 452 451 453 378 389 385 370 452 449 2420 477 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
81 CS 2263 2263 2241 2251 2294 2271 3063 2435 2223 2194 2243 2426 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
82 SS 1951 1917 1951 1937 1969 2022 1845 2086 1891 1945 2410 3129 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
83 CS 594 606 631 593 534 554 810 527 603 591 598 594 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
wrong results using minvalue/maxvalue in join condition
84 SS 395 400 398 395 357 331 329 334 395 408 2418 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
wrong results using minvalue/maxvalue in join condition
85 CS 583 615 583 597 554 515 771 514 620 581 575 593 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Collect network statistics and make it available for the user applications
86 SS 385 394 387 377 328 326 314 326 392 398 2235 385 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Collect network statistics and make it available for the user applications
87 CS 587 591 585 590 547 522 757 555 629 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Add AUTO RELEASE TEMP BLOBID transaction option
88 SS 367 392 393 386 329 328 348 347 399 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Add AUTO RELEASE TEMP BLOBID transaction option
89 SS 909 904 914 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
Report unique usernames for isc_info_user_names
90 SS 862 862 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
Crash when creating index on table that uses UDR and ParallelWorkers > 1
91 CS 2594 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 2594 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
92 SS 2375 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 2375 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
93 CS 2610 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 2610 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
94 SS 2376 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 2376 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
95 CS 729 751 807 748 657 680 697 653 742 735 731 739 749 746 745 727 738 823 861 823 733 613 624 633 689 689 633 594 578 578 563
INNER JOIN join order LIKE and STARTING WITH
96 SS 463 516 485 487 416 413 436 441 504 493 2238 505 487 498 487 492 2401 2421 532 533 432 409 401 409 421 405 417 313 312 313 313
INNER JOIN join order LIKE and STARTING WITH
97 CS 819 819 818 826 749 807 858 742 819 826 868 825 835 859 855 853 870 948 979 1030 807 1098 768 767 784 791 787 594 641 594 594
ORDER BY ASC using index (multi)
98 SS 571 581 574 560 482 722 508 489 569 564 2234 565 960 870 982 876 2237 2414 944 929 1274 821 717 486 481 483 491 359 359 360 359
ORDER BY ASC using index (multi)
99 CS 819 830 854 812 775 873 912 763 853 829 845 810 830 865 821 845 849 938 1004 977 808 818 789 769 785 800 775 594 610 594 625
ORDER BY ASC using index (multi)
100 SS 527 573 564 563 480 495 493 499 543 561 2418 573 583 555 563 561 2396 2240 605 593 511 489 490 482 477 490 484 359 359 359 359
ORDER BY ASC using index (multi)
101 CS 600 615 611 607 545 571 657 572 607 594 877 618 634 624 610 642 670 717 668 670 506 500 493 551 498 494 485 453 453 453 453
ORDER BY ASC using index (multi) and WHERE clause
102 SS 401 407 421 411 352 356 358 356 417 404 2402 413 404 410 420 423 2439 2422 453 454 399 324 352 336 344 326 329 234 235 235 250
ORDER BY ASC using index (multi) and WHERE clause
103 CS 583 583 616 589 540 583 962 521 584 577 600 585 615 636 592 585 623 684 659 659 518 496 531 471 529 473 464 500 453 453 453
ISQL - SHOW DATABASE
104 SS 359 376 376 379 331 334 329 343 391 375 2434 391 379 410 385 389 2395 2221 433 438 315 294 308 313 311 310 300 219 219 219 234
ISQL - SHOW DATABASE
105 CS 591 631 594 599 573 608 642 531 613 589 623 606 611 600 613 597 583 653 655 656 481 484 481 472 479 476 474 453 485 453 422
ISQL - SHOW SYSTEM TABLES
106 SS 377 419 413 400 352 354 353 586 394 380 2250 375 391 407 390 393 2421 2396 435 436 313 299 312 313 311 302 295 234 234 234 234
ISQL - SHOW SYSTEM TABLES
107 SS 311 321 311 309 281 351 347 350 384 307 2097 311 322 324 305 368 2088 2082 310 308 377 353 312 293 311 305 316 266 266 266 266
Add REPLICA MODE to the output of the isql SHOW DATABASE command
108 SS 156 158 154 156 139 144 143 141 158 155 2077 159 158 162 157 158 2113 2089 158 156 158 156 159 155 154 158 159 125 125 125 125
ISQL showing publication status
109 SS 8876 8702 9734 9558 9511 9032 9357 9498 8589 9548 2199 8694 9745 8706 8722 9584 2380 2221 8698 9692 9560 8707 8697 8683 8711 9031 7722 10627 10580 7595 9610
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
110 SS 9981 10148 9195 9044 9381 10056 10030 9512 10130 9082 2627 10160 9099 10070 10322 9238 2418 2414 9250 8976 9293 10316 10048 10037 10042 9932 9131 10876 13330 14252 10392
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
111 SS 6428 6432 6445 6412 6088 6109 6031 6161 5662 6483 2201 5772 6457 6434 6425 6775 2233 2190 6554 6583 6495 5494 5506 6422 5519 6499 6665 7954 7001 6970 7907
Problem with replication of BLOB segments longer than 32KB
112 SS 6169 6189 6221 6170 6059 6041 6257 6030 6142 6161 2428 6158 6407 6169 6171 6196 2394 2389 6194 6155 6158 6183 6136 6166 6218 6167 6169 6610 7438 6611 6580
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
113 SS 6390 6392 6389 7411 6252 6245 7696 6293 6409 7410 2430 7417 6422 6355 6369 6337 2219 2210 6368 6358 6333 7392 7329 6387 7369 6499 6354 9720 12784 10768 9768
DDL-triggers must fire only on master DB
114 SS 8527 8837 6259 8936 6702 6092 8359 8870 9629 8412 2197 9060 9405 8544 8657 6093 2412 2391 9517 9086 9419 8353 8971 8869 8510 8768 9610 5797 5469 6516 6532
Disallow replication of RDB$BACKUP_HISTORY
115 SS 9197 9565 8715 8726 8526 9368 9477 9497 8718 9705 2383 8700 9026 9568 9564 9705 2428 2393 8752 9698 8782 9534 8700 9552 9564 8880 8695 9548 9595 9705 8673
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
116 SS 6134 6122 6129 6172 6017 6013 7301 6029 6137 6149 2203 6137 6211 6150 6116 6125 2197 2193 6149 6148 7125 6128 6125 6116 6115 6207 6131 6172 6204 6204 7204
Failed DDL commands can be replicated
117 SS 6062 6079 6076 6056 6926 5925 6029 5953 6057 6149 2390 6054 6134 6084 6057 6063 2412 2425 6062 6066 6067 6081 6062 6036 6068 6055 6056 6079 6110 6094 6095
Generator values may not replicate after commit
118 CS 12994 11700 12715 13712 13588 13726 13037 13700 12741 13675 12697 13712 13746 13839 12729 12738 13673 12795 13839 12828 12850 77685 13796 12830 12849 77657 12818 12986 13002 11939 12924
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
119 SS 13172 13171 13151 13124 13019 14084 13478 14025 13185 13162 2413 13168 13601 13205 13187 13191 2227 2211 13148 12181 13174 69775 13160 13142 13155 70774 13182 14158 13206 13189 13157
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
120 CS 52888 50755 53472 52888 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
Make asynchronous replica re-initialization reliable #8324
121 SS 49221 49684 49221 48625 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
Make asynchronous replica re-initialization reliable #8324
122 SS 15963 13626 14084 15931 16332 15626 15995 15646 16818 15857 2213 16386 15787 13404 16475 15924 2393 2369 16292 16116 16919 18843 13211 16522 16261 15527 15711 18721 16079 18800 18627
Applying full DDL from OLTP-EMUL test on master with further check replica
123 SS 13867 14389 14777 13783 13420 14422 13301 13214 14286 14389 2401 14184 14151 14179 13601 14181 2213 2207 14212 13751 14078 13456 13610 13594 13392 13152 13952 13642 14330 14050 14048
Crash or hang while shutting down the replica database if segments are being applied
124 SS 6578 6073 6069 6214 6953 6942 7035 6966 7067 7090 2195 6102 6180 7079 6106 7075 2403 2382 7075 6058 6082 7082 7088 7075 6068 6068 6076 7126 6157 7157 7080
Some updates can crash Firebird server on replica side
125 SS 6071 6060 6080 7105 5972 5929 6013 5944 6073 6114 2416 6076 6656 6083 7090 6070 2214 2411 6070 6056 7059 6065 6057 6053 6072 6053 7073 6094 7095 6110 6079
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
126 CS 3499 3517 3497 3513 3341 3470 3475 3415 3514 3507 3517 3901 3547 3616 3513 3521 3538 3597 3616 3593 3397 3417 3386 3394 3398 3389 3374 3501 3485 3438 3438
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
127 SS 2813 2894 2895 2907 2706 2705 2728 2731 2911 2906 2437 2879 2958 2970 3164 3261 2241 2434 2927 2956 2831 2807 2824 2809 2817 2809 2808 2579 2579 2594 2594
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
128 CS 29072 29061 29124 29030 28918 29069 29369 29052 29111 29095 29076 29628 29143 29376 29098 29103 29028 29301 29236 29299 29040 29149 29243 29032 28968 29013 29057 29005 29050 28972 29005
External Connections Pool, functionality test 01
129 CS 1061 1035 1025 1033 610 649 832 683 1017 1027 1063 1026 1031 1096 1031 1038 1059 1153 1230 1240 1184 1104 1071 1097 1046 1073 1093 1344 1359 1375 1344
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
130 SS 703 727 702 712 395 456 479 618 702 712 2246 693 734 704 700 703 2226 2261 805 798 693 683 706 677 702 676 699 797 796 781 797
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
131 CS 1473 1452 1430 1445 1328 1369 1479 1420 1445 1454 1467 1426 1480 1575 1479 1467 1736 1721 1954 1743 1577 1568 1554 1568 1492 1495 1481 1266 1282 1266 1219
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
132 SS 1025 1020 1005 1004 902 910 919 895 1027 1000 2436 1014 1077 1017 1023 1044 2469 2450 1157 1147 1206 1043 1201 1204 1031 1047 1039 797 797 797 797
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
133 CS 1157 1157 1162 1151 526 652 563 508 1164 1148 1183 1146 1162 1230 1236 1197 1170 1248 1322 1224 1059 1113 1037 1044 0 0 0 0 0 0 0
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
134 SS 670 658 692 688 296 290 318 588 664 681 2452 659 740 678 670 685 2435 2242 710 741 591 590 582 587 0 0 0 0 0 0 0
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
135 CS 981 994 984 983 947 944 967 956 992 985 979 979 985 1016 1013 978 935 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join
136 CS 665 691 711 717 616 610 646 612 713 688 713 695 693 722 695 693 685 775 754 759 643 576 567 560 572 574 565 531 547 531 515
Allow computable but non-invariant lists to be used for index lookup
137 SS 415 452 454 455 398 380 379 379 457 471 2253 432 445 446 444 462 2436 2429 480 467 365 362 359 365 373 387 373 266 281 266 266
Allow computable but non-invariant lists to be used for index lookup
138 CS 411 406 408 407 395 486 582 404 412 407 412 405 10800405 10800410 10800408 10800411 10800440 405 419 399 455 404 407 400 400 392 410 532 500 500 500
CREATE VIEW as SELECT ....

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-214
http://tracker.firebirdsql.org/browse/CORE-2650
http://tracker.firebirdsql.org/browse/CORE-3168
http://tracker.firebirdsql.org/browse/CORE-3323
http://tracker.firebirdsql.org/browse/CORE-3658
http://tracker.firebirdsql.org/browse/CORE-4821
http://tracker.firebirdsql.org/browse/CORE-4927
http://tracker.firebirdsql.org/browse/CORE-5229
http://tracker.firebirdsql.org/browse/CORE-5236
http://tracker.firebirdsql.org/browse/CORE-5488
http://tracker.firebirdsql.org/browse/CORE-5501
http://tracker.firebirdsql.org/browse/CORE-6279
http://tracker.firebirdsql.org/browse/CORE-6412
http://tracker.firebirdsql.org/browse/CORE-6441
http://tracker.firebirdsql.org/browse/CORE-733
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_05.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/basic/isql/test_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_08.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_blob_not_found_in_rw_replica_if_target_row_exists.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_segments_longer_32kb_are_not_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_dblevel_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_ddl_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_disallow_rdb_backup_history_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_duplicates_in_rw_replica_after_conflicting_insert.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_failed_ddl_commands_can_be_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_generator_could_not_be_transferred_to_replica.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_make_async_reinit_reliable.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_oltp_emul_ddl.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/replication/test_some_updates_crash_server_on_replica_side.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_updating_blob_with_empty_string_stops_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/services/test_role_in_service_attachment.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/syspriv/test_user_management_in_selfsec_db.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_333be4bf.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_90129c6d.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_aae2ae32.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_e260ced8.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/view/create/test_10.py
https://github.com/FirebirdSQL/firebird/issues/5867
https://github.com/FirebirdSQL/firebird/issues/6802
https://github.com/FirebirdSQL/firebird/issues/7106
https://github.com/FirebirdSQL/firebird/issues/7188
https://github.com/FirebirdSQL/firebird/issues/7269
https://github.com/FirebirdSQL/firebird/issues/7288
https://github.com/FirebirdSQL/firebird/issues/7304
https://github.com/FirebirdSQL/firebird/issues/7466
https://github.com/FirebirdSQL/firebird/issues/7545
https://github.com/FirebirdSQL/firebird/issues/7652
https://github.com/FirebirdSQL/firebird/issues/7937
https://github.com/FirebirdSQL/firebird/issues/8077
https://github.com/FirebirdSQL/firebird/issues/8108
https://github.com/FirebirdSQL/firebird/issues/8112
https://github.com/FirebirdSQL/firebird/issues/8120
https://github.com/FirebirdSQL/firebird/issues/8123
https://github.com/FirebirdSQL/firebird/issues/8178
https://github.com/FirebirdSQL/firebird/issues/8185
https://github.com/FirebirdSQL/firebird/issues/8211
https://github.com/FirebirdSQL/firebird/issues/8213
https://github.com/FirebirdSQL/firebird/issues/8214
https://github.com/FirebirdSQL/firebird/issues/8221
https://github.com/FirebirdSQL/firebird/issues/8223
https://github.com/FirebirdSQL/firebird/issues/8225
https://github.com/FirebirdSQL/firebird/issues/8233
https://github.com/FirebirdSQL/firebird/issues/8241
https://github.com/FirebirdSQL/firebird/issues/8252
https://github.com/FirebirdSQL/firebird/issues/8253
https://github.com/FirebirdSQL/firebird/issues/8255
https://github.com/FirebirdSQL/firebird/issues/8263
https://github.com/FirebirdSQL/firebird/issues/8265
https://github.com/FirebirdSQL/firebird/issues/8290
https://github.com/FirebirdSQL/firebird/issues/8291
https://github.com/FirebirdSQL/firebird/issues/8304
https://github.com/FirebirdSQL/firebird/issues/8310
https://github.com/FirebirdSQL/firebird/issues/8323
https://github.com/FirebirdSQL/firebird/issues/8353
https://github.com/FirebirdSQL/firebird/issues/8386
=== end of list ===

Last commits information (all timestamps in UTC):