NN | Test name | mode |
5.0.2.1577
|
5.0.2.1576
|
5.0.2.1575
|
5.0.2.1575
|
5.0.2.1571
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1533
|
5.0.2.1533
|
5.0.2.1532
|
5.0.2.1518
|
5.0.2.1518
|
5.0.2.1489
|
5.0.2.1476
|
5.0.1.1454
|
5.0.1.1453
|
5.0.1.1453
|
5.0.1.1453
|
5.0.1.1453
|
5.0.1.1429
|
5.0.1.1428
|
5.0.1.1428
|
5.0.1.1415
|
5.0.1.1415
|
5.0.1.1401
|
5.0.1.1398
|
5.0.1.1397
|
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 .... |
NN | Test name | mode | median_ms |
5.0.2.1577
|
5.0.2.1576
|
5.0.2.1575
|
5.0.2.1575
|
5.0.2.1571
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1567
|
5.0.2.1533
|
5.0.2.1533
|
5.0.2.1532
|
5.0.2.1518
|
5.0.2.1518
|
5.0.2.1489
|
5.0.2.1476
|
5.0.1.1454
|
5.0.1.1453
|
5.0.1.1453
|
5.0.1.1453
|
5.0.1.1453
|
5.0.1.1429
|
5.0.1.1428
|
5.0.1.1428
|
5.0.1.1415
|
5.0.1.1415
|
5.0.1.1401
|
5.0.1.1398
|
5.0.1.1397
|
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 .... |