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 (1 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 (1 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (10 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 30 runs (136 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 (0 rows)
11. All tests: outcomes for previous 30 runs (3696 rows)
12. Skipped: tests which was intentionally excluded from execution (80 rows)

Generated UTC 22.02.2025 08:33
Tested: HQ50.   Build / date: 5.0.2.1615-4a72664d / 2025.02.20;
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.1615
2025.02.20
5.0.2.1615
2025.02.14
5.0.2.1577
2025.02.07
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
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 P P P F
Count (DISTINCT ...) is too slow
2 CS F F P P 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
Compress Data over the Network
3 SS F P P 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
Compress Data over the Network
4 CS P P 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 P P P
Improve sorting performance when long VARCHARs are involved
5 SS P P 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 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 P P P F
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 P P P F
exclude_filter doesn't work for <services></section> section of the Trace facility
8 SS 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 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 P P P F
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 P P P F
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
11 CS P P P 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
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
12 SS P P P 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
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 P P P F 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 P P P F 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 P P P F 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 P P P F
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 P P P F
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 P P P F 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 F F F 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 F F F 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 P P P F 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 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
Firebird is freezing when trying to manage users via triggers
23 SS P P P 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
Firebird is freezing when trying to manage users via triggers
24 CS P P P 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
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
25 SS P P P 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
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
26 CS P P P 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
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
27 SS P P P 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
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
28 CS F 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
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
29 SS F F P P P P P P P P P P E P P P P P P P X X X X X X X X X X
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
30 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 P P F
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
31 SS P P P 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
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
32 CS P P P 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
Wrong detection of must-be-delimited user names
33 SS P P P 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
Wrong detection of must-be-delimited user names
34 SS P P P 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
Memory leak in GDS32.DLL(FBClient.DLL), when multi-database transaction has done
35 CS 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 X
Database restore must make every effort on activating deferred indexes
36 SS P P P 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
Database restore must make every effort on activating deferred indexes
37 SS 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 P P P
Server crashes when working with DSQL savepoints
38 SS F F F 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
Events in system attachments (like garbage collector) are not traced
39 CS P P P P 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
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
40 SS P P P P 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
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
41 SS 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 P P P
Server crash on some LockMemSize values
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 F F F X X X
Make the profiler store aggregated requests by default, with option for detailed store
43 SS P P P 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
Make the profiler store aggregated requests by default, with option for detailed store
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 P F 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
45 SS P P P 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
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
46 CS 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 P P P P P
Memory leak when executing a lot of different queries and StatementTimeout > 0
47 SS F F P 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
Memory leak when executing a lot of different queries and StatementTimeout > 0
48 CS P P 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
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
49 SS P P 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
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
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 F F F X X
Check result of conversion to string in COALESCE that involves all families of data types.
51 SS P P P 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
Check result of conversion to string in COALESCE that involves all families of data types.
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 F F F X X
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
53 SS P P P 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
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
54 CS P P F 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
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
55 SS P P F 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
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
56 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
DATEADD truncates milliseconds for month and year deltas.
57 SS P P P 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
DATEADD truncates milliseconds for month and year deltas.
58 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
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
59 SS P P P 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
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
60 CS 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 X
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
61 SS P P P 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
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
62 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
Crash when MAKE_DBKEY() is called with 0 or 1 arguments
63 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
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
64 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
Problematic queries when SubQueryConversion = true
65 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
SubQueryConversion = true - multiple rows in singleton select
66 CS 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 X
gbak may lose NULLs in restore
67 SS P P P 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
gbak may lose NULLs in restore
68 CS 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 X
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
69 SS P P P 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
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
70 CS P P P 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
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
71 SS P P P 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
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
72 CS 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 X
Catch possible stack overflow when preparing and compiling user statements
73 CS 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 X X
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
74 CS 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 X
Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
75 CS 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 X
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
76 SS P P P 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
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
77 CS 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 X
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
78 SS P P P 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
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
79 CS 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 X
wrong results using minvalue/maxvalue in join condition
80 SS P P P 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
wrong results using minvalue/maxvalue in join condition
81 CS 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 X
Collect network statistics and make it available for the user applications
82 SS P P P 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
Collect network statistics and make it available for the user applications
83 CS P P P 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
Add AUTO RELEASE TEMP BLOBID transaction option
84 SS P P P 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
Add AUTO RELEASE TEMP BLOBID transaction option
85 SS 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 X X X
Report unique usernames for isc_info_user_names
86 CS P P 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
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
87 SS P P 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
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
88 CS 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 X X
Crash when creating index on table that uses UDR and ParallelWorkers > 1
89 SS 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 X X
Crash when creating index on table that uses UDR and ParallelWorkers > 1
90 SS P P 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
gbak: Incorrect total statistics for restore
91 CS P P 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
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
92 SS P P 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
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
93 CS 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 P P
INNER JOIN join order LIKE and STARTING WITH
94 SS P P P 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
INNER JOIN join order LIKE and STARTING WITH
95 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)
96 SS F F F 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
ORDER BY ASC using index (multi)
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 F F F E F F F F F E E 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) and WHERE clause
100 SS F F F 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
ORDER BY ASC using index (multi) and WHERE clause
101 CS P P P 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
ISQL - SHOW DATABASE
102 SS P P P 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
ISQL - SHOW DATABASE
103 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
ISQL - SHOW SYSTEM TABLES
104 SS F F F 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
ISQL - SHOW SYSTEM TABLES
105 SS P P P 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
Add REPLICA MODE to the output of the isql SHOW DATABASE command
106 SS P P P 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
ISQL showing publication status
107 SS P P P 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
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
108 SS P P P 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
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
109 SS P P P 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
Problem with replication of BLOB segments longer than 32KB
110 SS P P P 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
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
111 SS P P P 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
DDL-triggers must fire only on master DB
112 SS P P P 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
Disallow replication of RDB$BACKUP_HISTORY
113 SS P P P 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
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
114 SS P P P 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
Failed DDL commands can be replicated
115 SS P P P 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
Generator values may not replicate after commit
116 CS 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 F 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
117 SS P P P 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
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
118 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
Make asynchronous replica re-initialization reliable #8324
119 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
Make asynchronous replica re-initialization reliable #8324
120 SS P P P 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
Applying full DDL from OLTP-EMUL test on master with further check replica
121 SS P P P 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
Crash or hang while shutting down the replica database if segments are being applied
122 SS P P P 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
Some updates can crash Firebird server on replica side
123 SS P P P 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
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
124 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 P P F
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
125 SS P P P 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
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
126 CS 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 P P
External Connections Pool, functionality test 01
127 CS P P P 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
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
128 SS P P P 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
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
129 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
130 SS F F F 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
131 CS P P P 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
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
132 SS P P P 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
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
133 CS 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 X
Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join
134 CS P P F 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
Allow computable but non-invariant lists to be used for index lookup
135 SS P P F 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
Allow computable but non-invariant lists to be used for index lookup
136 CS S S S 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
CREATE VIEW as SELECT ....

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.2.1615
2025.02.20
5.0.2.1615
2025.02.14
5.0.2.1577
2025.02.07
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
Test TITLE
1 CS 2115 17892 17928 18399 17982 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
Count (DISTINCT ...) is too slow
2 CS 16943 16422 16996 16698 16271 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
Compress Data over the Network
3 SS 16063 16151 15796 15656 16479 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
Compress Data over the Network
4 CS 755 788 766 1140 1112 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
Improve sorting performance when long VARCHARs are involved
5 SS 462 513 506 847 837 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
Improve sorting performance when long VARCHARs are involved
6 CS 2727 3117 2734 2723 2730 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
exclude_filter doesn't work for <services></section> section of the Trace facility
7 SS 2523 3058 2525 2528 2546 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
exclude_filter doesn't work for <services></section> section of the Trace facility
8 SS 5965 5964 5931 5962 5944 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
Ability to cancel waiting in lock manager
9 CS 2400 2396 2398 2402 2402 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
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
10 SS 2223 2249 2217 2228 2373 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
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
11 CS 1216 1381 1205 1203 1203 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
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
12 SS 845 833 829 841 829 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
grant create database to ROLE doesn`t work: "no permission for CREATE access to DATABASE ..." [CORE4821]
13 CS 2961 3047 2946 2988 2958 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
IIF function prevents the condition from being pushed into the union for better optimization
14 CS 859 978 845 848 887 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
Allow to enforce IPv4 or IPv6 in URL-like connection strings
15 SS 430 434 433 443 427 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
Allow to enforce IPv4 or IPv6 in URL-like connection strings
16 CS 884 1018 939 870 886 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
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
17 SS 593 621 607 602 603 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
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
18 CS 3057 3063 3054 3063 3086 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
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
19 CS 2612 1380 1354 1474 1482 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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
20 SS 1824 743 1073 743 956 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
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
21 CS 3573 3551 3575 3571 3592 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
Put options in user management statements in any order
22 CS 972 943 945 963 987 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
Firebird is freezing when trying to manage users via triggers
23 SS 662 659 653 657 652 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
Firebird is freezing when trying to manage users via triggers
24 CS 1918 1919 1880 1870 1865 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
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
25 SS 1451 1425 1450 1438 1444 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
Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
26 CS 761 755 764 762 769 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
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
27 SS 429 423 431 429 429 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
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]
28 CS 17828 18395 18221 17644 17945 18416 17954 17833 17984 17644 17862 25910 17823 17805 17789 17864 17586 17417 17688 17562 17737 0 0 0 0 0 0 0 0 0 0
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
29 SS 17807 18226 18300 17653 17881 18391 18331 17789 17586 17862 17491 17763 17902 2252 18058 17826 17551 17336 17912 17507 17654 0 0 0 0 0 0 0 0 0 0
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
30 CS 21657 21657 21662 21658 21788 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
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
31 SS 21447 21426 21461 21464 21458 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
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
32 CS 13914 13873 13839 13866 13896 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
Wrong detection of must-be-delimited user names
33 SS 9371 9388 9385 9353 9324 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
Wrong detection of must-be-delimited user names
34 SS 8885 9419 9496 8100 8256 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
Memory leak in GDS32.DLL(FBClient.DLL), when multi-database transaction has done
35 CS 732 739 732 733 746 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
Database restore must make every effort on activating deferred indexes
36 SS 493 503 507 506 494 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
Database restore must make every effort on activating deferred indexes
37 SS 304 296 284 284 297 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
Server crashes when working with DSQL savepoints
38 SS 302 299 429 301 570 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
Events in system attachments (like garbage collector) are not traced
39 CS 3009 3005 3069 2994 3000 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
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
40 SS 2532 3384 2525 2536 2519 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
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
41 SS 203 201 200 200 197 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
Server crash on some LockMemSize values
42 CS 922 965 914 893 930 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
Make the profiler store aggregated requests by default, with option for detailed store
43 SS 618 617 611 606 627 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
Make the profiler store aggregated requests by default, with option for detailed store
44 CS 594 594 591 598 636 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
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
45 SS 390 390 377 390 392 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
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
46 CS 18526 18938 18956 18538 18535 18523 18559 18462 18526 18492 18467 18525 18527 18532 18526 18534 18535 18534 18573 18523 18600 18620 18634 18438 18438 18429 18437 18466 18435 18438 18362
Memory leak when executing a lot of different queries and StatementTimeout > 0
47 SS 18285 18791 18783 18283 18287 18294 18287 18239 18231 18249 18228 18287 18298 2428 18286 18301 18295 18287 18287 18284 18340 18342 18331 18206 18217 18211 18212 18207 18224 18215 18143
Memory leak when executing a lot of different queries and StatementTimeout > 0
48 CS 1382 1379 1375 1390 1386 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
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
49 SS 1105 1088 1099 1111 1120 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
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
50 CS 1857 3927 3926 1404 2177 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
Check result of conversion to string in COALESCE that involves all families of data types.
51 SS 1628 3852 3920 1156 1955 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
Check result of conversion to string in COALESCE that involves all families of data types.
52 CS 588 590 616 590 626 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
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
53 SS 382 373 388 379 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
Problem with boolean conversion to string inside DataTypeUtil::makeFromList()
54 CS 695 687 690 706 696 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
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
55 SS 478 453 477 485 710 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
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
56 CS 590 582 580 590 631 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
DATEADD truncates milliseconds for month and year deltas.
57 SS 382 385 380 383 390 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
DATEADD truncates milliseconds for month and year deltas.
58 CS 616 616 641 611 606 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
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
59 SS 410 410 404 425 406 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
WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source
60 CS 659 658 665 653 653 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
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
61 SS 437 421 454 443 437 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
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
62 CS 590 576 584 594 581 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
Crash when MAKE_DBKEY() is called with 0 or 1 arguments
63 CS 704 702 709 725 706 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
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
64 CS 696 726 691 692 699 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
Problematic queries when SubQueryConversion = true
65 CS 690 697 694 690 702 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
SubQueryConversion = true - multiple rows in singleton select
66 CS 1341 1341 1341 1304 1322 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
gbak may lose NULLs in restore
67 SS 886 882 885 908 892 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
gbak may lose NULLs in restore
68 CS 434 427 469 441 427 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
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
69 SS 260 249 295 263 253 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
Incorrect subquery unnesting with complex dependencies (SubQueryConversion = true)
70 CS 754 758 752 763 772 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
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
71 SS 501 499 509 491 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
Incorrect handling of non-ASCII object names in CREATE MAPPING statement
72 CS 722 705 746 715 709 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
Catch possible stack overflow when preparing and compiling user statements
73 CS 1093 1094 1072 1092 1091 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
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
74 CS 995 992 997 992 992 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
Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
75 CS 695 698 700 691 692 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
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
76 SS 447 443 443 460 445 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
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
77 CS 2271 2272 2311 2277 2257 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
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
78 SS 1960 2347 2035 1916 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
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
79 CS 595 596 602 592 602 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
wrong results using minvalue/maxvalue in join condition
80 SS 394 385 394 395 390 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
wrong results using minvalue/maxvalue in join condition
81 CS 582 621 582 585 576 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
Collect network statistics and make it available for the user applications
82 SS 377 378 376 383 377 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
Collect network statistics and make it available for the user applications
83 CS 590 590 592 613 585 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
Add AUTO RELEASE TEMP BLOBID transaction option
84 SS 386 375 409 390 386 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
Add AUTO RELEASE TEMP BLOBID transaction option
85 SS 903 879 903 900 1134 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
Report unique usernames for isc_info_user_names
86 CS 2942 2939 2925 2958 2945 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 Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
87 SS 2678 2670 2669 2993 2687 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 Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
88 CS 1091 1084 1089 1094 1133 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
89 SS 877 861 1113 870 884 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
90 SS 2642 2616 2793 2644 2641 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
gbak: Incorrect total statistics for restore
91 CS 1235 1230 1241 1230 1308 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 Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
92 SS 937 917 927 951 948 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 Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
93 CS 733 771 745 730 734 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
INNER JOIN join order LIKE and STARTING WITH
94 SS 487 487 486 489 490 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
INNER JOIN join order LIKE and STARTING WITH
95 CS 826 838 810 831 827 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
ORDER BY ASC using index (multi)
96 SS 577 581 682 571 569 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
ORDER BY ASC using index (multi)
97 CS 829 841 833 842 811 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
ORDER BY ASC using index (multi)
98 SS 561 567 613 561 843 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
ORDER BY ASC using index (multi)
99 CS 607 628 615 599 607 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
ORDER BY ASC using index (multi) and WHERE clause
100 SS 410 410 420 415 426 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
ORDER BY ASC using index (multi) and WHERE clause
101 CS 587 610 615 618 593 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
ISQL - SHOW DATABASE
102 SS 377 374 387 380 379 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
ISQL - SHOW DATABASE
103 CS 592 591 589 589 599 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
ISQL - SHOW SYSTEM TABLES
104 SS 392 416 524 414 433 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
ISQL - SHOW SYSTEM TABLES
105 SS 314 308 371 356 308 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
Add REPLICA MODE to the output of the isql SHOW DATABASE command
106 SS 158 159 158 159 155 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
ISQL showing publication status
107 SS 9031 9564 8548 9701 9560 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
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
108 SS 9271 9054 9040 9127 9037 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
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
109 SS 6422 6487 6419 6422 6471 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
Problem with replication of BLOB segments longer than 32KB
110 SS 6168 6215 6138 6201 6219 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
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
111 SS 6388 7332 7398 6368 7395 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
DDL-triggers must fire only on master DB
112 SS 8527 6025 8473 8857 8352 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
Disallow replication of RDB$BACKUP_HISTORY
113 SS 9197 8564 9580 9681 9544 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
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
114 SS 6131 6131 6132 6136 6130 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
Failed DDL commands can be replicated
115 SS 6059 6048 6079 6057 6068 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
Generator values may not replicate after commit
116 CS 13312 13690 11703 13706 12708 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
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
117 SS 13161 13143 13131 13142 12129 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
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
118 CS 53180 52752 50821 53798 53754 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
Make asynchronous replica re-initialization reliable #8324
119 SS 50888 50378 54560 51399 53443 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
Make asynchronous replica re-initialization reliable #8324
120 SS 15963 17035 16335 16708 14426 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
Applying full DDL from OLTP-EMUL test on master with further check replica
121 SS 13626 13546 14149 13544 13374 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
Crash or hang while shutting down the replica database if segments are being applied
122 SS 6143 6070 6075 6078 6076 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
Some updates can crash Firebird server on replica side
123 SS 6067 6055 6082 6059 6054 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
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
124 CS 3511 3519 3510 3547 3536 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
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
125 SS 2853 2875 2891 2893 2914 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
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
126 CS 29085 29022 29021 29020 29132 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
External Connections Pool, functionality test 01
127 CS 1037 1033 1037 1014 1026 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
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
128 SS 703 735 706 707 712 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
Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted.
129 CS 1479 1429 1505 1478 1467 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
130 SS 1041 1053 1084 1012 1229 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
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
131 CS 1156 1140 1180 1150 1592 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
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
132 SS 677 713 659 691 677 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
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
133 CS 979 975 980 971 996 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
Better fix for #8252: incorrect subquery unnesting with complex dependencies, it re-allows converting nested IN/EXISTS into multiple semi-join
134 CS 687 699 680 687 741 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
Allow computable but non-invariant lists to be used for index lookup
135 SS 444 476 442 457 461 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
Allow computable but non-invariant lists to be used for index lookup
136 CS 409 492 408 407 459 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
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/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/6706
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/8085
https://github.com/FirebirdSQL/firebird/issues/8109
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/8356
https://github.com/FirebirdSQL/firebird/issues/8386
https://github.com/FirebirdSQL/firebird/issues/8391
https://github.com/FirebirdSQL/firebird/issues/8394
=== end of list ===

Last commits information (all timestamps in UTC):