0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (3 rows)
2. FRESH FAILS: tests which failed for LAST execution only (0 rows)
3. FRESH ERRORS: tests which raised run-time error for LAST execution only (0 rows)
4. STILL FAILS: tests which fail for at least two last runs (22 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (92 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (1 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (2333 rows)
9. All tests: durations (4570 rows)
A. Skipped: tests which was intentionally excluded from execution (48 rows)

Generated 05.02.2023 03:26
Tested: FB50.   Build: 5.0.0.930;   SS: 05.02.23 01:32:45 - 05.02.23 02:22:45;   CS: 05.02.23 02:24:27 - 05.02.23 03:24:22;
OS and hardware info:  Windows 10 10.0.19041 ; logical CPUs: 8 ; total memory: 31.7 Gb 

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

Jump to LIST of unique test names from this report

NN Test name mode 5.0.0.930
2023-02-05
5.0.0.928
2023-02-03
5.0.0.923
2023-02-02
5.0.0.920
2023-01-28
5.0.0.917
2023-01-22
5.0.0.916
2023-01-20
5.0.0.915
2023-01-31
5.0.0.914
2023-01-18
5.0.0.912
2023-01-16
5.0.0.910
2023-01-14
5.0.0.908
2023-01-13
5.0.0.907
2023-01-12
5.0.0.905
2023-01-11
5.0.0.890
2023-01-07
5.0.0.888
2023-01-01
5.0.0.884
2022-12-24
5.0.0.883
2022-12-23
5.0.0.882
2022-12-22
5.0.0.879
2022-12-21
5.0.0.877
2022-12-17
5.0.0.871
2022-12-14
5.0.0.870
2022-12-13
5.0.0.869
2022-12-12
5.0.0.867
2022-12-11
5.0.0.865
2022-12-10
5.0.0.863
2022-12-07
5.0.0.862
2022-12-05
5.0.0.848
2022-11-29
5.0.0.847
2022-11-27
5.0.0.845
2022-11-26
Test TITLE
1 CS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order
2 SS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order
3 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Suboptimal join plan if there are selective non-indexed predicates involved
4 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Suboptimal join plan if there are selective non-indexed predicates involved
5 CS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Include PLAN in mon$statements
6 SS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Include PLAN in mon$statements
7 CS P P P P P P X P P     F         F         F         F     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
8 SS P P P P P P X P P     F         F         F         F     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
9 CS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
10 SS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
11 CS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
12 SS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
13 CS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
14 SS P P P P P P X P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
15 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
16 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
17 CS P P P P P P X P P P     F         F         F     P P P P P P P P P P P P P P P P P
Prohibit an ability to issue DML or DDL statements on RDB$ tables
18 SS P P P P P P X P P P     F         F         F     P P P P P P P P P P P P P P P P P
Prohibit an ability to issue DML or DDL statements on RDB$ tables
19 CS P P P P P P X P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
20 SS P P P P P P X P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
21 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
22 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
23 CS P P P P P P X P     F     P P P P P P P P P P P P P P P P P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
24 CS P P P P P P X P P P P P P P P P P P     F         F     P P P P P P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
25 CS P P P P P P X P     F         F         F         F         F     P P P P P P P P P P P P P P P P P
Inconsistent cursor-driven deletion
26 SS P P P P P P X P     F         F         F         F         F     P P P P P P P P P P P P P P P P P
Inconsistent cursor-driven deletion
27 CS P P P P P P X P P P     F         F         F     P P P P P P P P P P P P P P P P P
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
28 SS P P P P P P X P P P     F         F         F     P P P P P P P P P P P P P P P P P
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
29 CS P P P P P P X P P P P P P P P     F     P P P P P P P P P P P P P P
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30 SS P P P P P P X P P P P P P P P     F     P P P P P P P P P P     F     P P P
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
31 CS P P P P P P X P P P P P P P P P P P P P P P P P P P P P     F     P
Indexed STARTING WITH execution is very slow with UNICODE collation
32 SS P P P P P P X P P P P P P P P P P P P P P P P P P P P P P     F    
Indexed STARTING WITH execution is very slow with UNICODE collation
33 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
34 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
35 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
36 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
37 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
38 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
39 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
INNER JOIN join order LIKE and STARTING WITH
40 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
INNER JOIN join order LIKE and STARTING WITH
41 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
LEFT OUTER JOIN with full match and reference in WHERE clause
42 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
LEFT OUTER JOIN with full match and reference in WHERE clause
43 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
LEFT OUTER JOIN with full match, but limited in ON clause
44 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
LEFT OUTER JOIN with full match, but limited in ON clause
45 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
LEFT OUTER JOIN with STARTING WITH in WHERE clause
46 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
LEFT OUTER JOIN with STARTING WITH in WHERE clause
47 CS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Mixed JOINS
48 SS     F         F         F         F         F         F     X     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Mixed JOINS
49 CS S S S S S S X S P     F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
Empty DB - RDB$FIELDS
50 SS S S S S S S X S P     F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
Empty DB - RDB$FIELDS
51 CS S S S S S S X S     F         F         F         F         F     P P P P P P P P P P P P P P P P P
Empty DB - RDB$FORMATS
52 SS S S S S S S X S     F         F         F         F         F     P P P P P P P P P P P P P P P P P
Empty DB - RDB$FORMATS
53 CS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New DB - RDB$FUNCTION_ARGUMENTS
54 SS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New DB - RDB$FUNCTION_ARGUMENTS
55 CS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New DB - RDB$FUNCTIONS
56 SS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New DB - RDB$FUNCTIONS
57 CS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New DB - RDB$PROCEDURE_PARAMETERS
58 SS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New DB - RDB$PROCEDURE_PARAMETERS
59 CS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New database: content of RDB$PROCEDURES
60 SS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
New database: content of RDB$PROCEDURES
61 CS S S S S S S X S     F         F         F         F         F     P P P P P P P P P P P P P P P P P
Empty DB - RDB$RELATIONS
62 SS S S S S S S X S     F         F         F         F         F     P P P P P P P P P P P P P P P P P
Empty DB - RDB$RELATIONS
63 CS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
Empty DB - RDB$SECURITY_CLASSES
64 SS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
Empty DB - RDB$SECURITY_CLASSES
65 CS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
Empty DB - RDB$USER_PRIVILEGES
66 SS S S S S S S X S     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
Empty DB - RDB$USER_PRIVILEGES
67 CS P P P P P P X P P     F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
ISQL - SHOW SYSTEM TABLES
68 SS P P P P P P X P P     F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P P P
ISQL - SHOW SYSTEM TABLES
69 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
70 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
71 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Problem with replication of BLOB segments longer than 32KB
72 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Problem with replication of BLOB segments longer than 32KB
73 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica.
74 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica.
75 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
DDL-triggers must fire only on master DB.
76 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
DDL-triggers must fire only on master DB.
77 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
78 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
79 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Failed DDL commands can be replicated
80 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Failed DDL commands can be replicated
81 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Generator values may not replicate after commit
82 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Generator values may not replicate after commit
83 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
84 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
85 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Permission error with replication
86 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Permission error with replication
87 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Crash or hang while shutting down the replica database if segments are being applied
88 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Crash or hang while shutting down the replica database if segments are being applied
89 CS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Some updates can crash Firebird server on replica side
90 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Some updates can crash Firebird server on replica side
91 CS P P P     F     P P X P     F     P P P P P     F     P P P     F         F     P     F     P     F         F     P P     F         F         F    
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
92 SS P P P P P P X P P P P P P P     F     P P P     F         F     P P P     F         F     P P     F         F         F    
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error

Elapsed time, milliseconds:
NN Test name mode median_ms 5.0.0.930
2023-02-05
5.0.0.928
2023-02-03
5.0.0.923
2023-02-02
5.0.0.920
2023-01-28
5.0.0.917
2023-01-22
5.0.0.916
2023-01-20
5.0.0.915
2023-01-31
5.0.0.914
2023-01-18
5.0.0.912
2023-01-16
5.0.0.910
2023-01-14
5.0.0.908
2023-01-13
5.0.0.907
2023-01-12
5.0.0.905
2023-01-11
5.0.0.890
2023-01-07
5.0.0.888
2023-01-01
5.0.0.884
2022-12-24
5.0.0.883
2022-12-23
5.0.0.882
2022-12-22
5.0.0.879
2022-12-21
5.0.0.877
2022-12-17
5.0.0.871
2022-12-14
5.0.0.870
2022-12-13
5.0.0.869
2022-12-12
5.0.0.867
2022-12-11
5.0.0.865
2022-12-10
5.0.0.863
2022-12-07
5.0.0.862
2022-12-05
5.0.0.848
2022-11-29
5.0.0.847
2022-11-27
5.0.0.845
2022-11-26
Test TITLE
1 CS 630 660 620 650 620 620 610 670 610 630 700 620 630 680 680 610 600 610 690 610 610 640 620 670 630 610 590 650 630 650
Subquery-based predicates are not evaluated early in the join order
2 SS 440 460 450 460 430 430 620 430 430 450 440 460 450 800 450 760 610 430 440 440 440 440 870 430 450 430 430 430 450 440
Subquery-based predicates are not evaluated early in the join order
3 CS 1350 1360 1360 1380 1360 1340 1330 1400 1350 1350 1390 1380 1370 1370 1360 1280 1340 1320 1340 1390 1410 1310 1400 1310 1450 1330 1280 1330 1330 1320
Suboptimal join plan if there are selective non-indexed predicates involved
4 SS 1010 1080 1020 1000 990 1000 1010 990 1010 1020 1010 1000 1030 990 1000 1020 1040 1020 1000 1040 990 1080 1070 1010 1010 990 970 1000 990 990
Suboptimal join plan if there are selective non-indexed predicates involved
5 CS 855 850 880 860 840 840 860 850 860 870 840 840 870 830 820 0 830 900 860 930 870 840 860 860 860 830 800 820 870 850
Include PLAN in mon$statements
6 SS 580 600 580 580 570 580 590 570 580 590 600 590 590 570 590 580 600 580 600 600 580 570 620 580 600 560 560 570 580 570
Include PLAN in mon$statements
7 CS 950 950 980 950 930 930 920 980 990 960 1000 1010 970 990 920 870 940 950 1040 940 930 930 1010 1000 940 990 840 910 980 940
Improve sorting performance when long VARCHARs are involved
8 SS 660 650 660 650 650 640 690 680 650 680 660 670 660 650 680 660 660 660 690 680 680 640 660 680 680 670 640 650 650 640
Improve sorting performance when long VARCHARs are involved
9 CS 900 950 880 930 880 890 880 870 910 890 890 910 900 900 920 790 960 940 940 940 930 940 920 880 870 880 820 910 850 850
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
10 SS 630 620 640 620 650 630 600 610 630 620 630 630 640 620 610 640 640 670 640 710 600 630 630 610 640 620 610 600 620 610
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
11 CS 1990 2020 2100 2000 2040 1970 1940 1960 1950 2020 2050 2060 1970 2020 2030 1830 2200 2050 2060 1990 2040 1920 2000 1930 1960 1950 1830 1960 1910 1900
Poor performance of explicit cursors containing correlated subqueries in the select list
12 SS 1630 1610 1650 1640 1620 1630 1630 1650 1620 1650 1640 1660 1650 1620 1600 1650 1650 1630 1650 1640 1720 1620 1630 1600 1640 1680 1560 1600 1630 1600
Poor performance of explicit cursors containing correlated subqueries in the select list
13 CS 870 890 900 900 870 920 860 910 850 880 860 890 870 890 850 780 860 870 880 870 860 910 860 860 850 850 830 860 870 860
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
14 SS 620 620 620 600 600 610 600 600 630 640 640 620 620 610 600 620 620 620 620 620 600 600 630 590 630 610 570 610 620 600
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
15 CS 880 870 910 900 840 830 920 840 870 960 1220 880 900 900 940 1130 1280 880 850 880 840 930 880 900 870 830 780 1220 860 900
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
16 SS 600 610 590 580 600 600 600 610 620 630 610 630 610 580 600 590 610 620 600 650 620 600 620 600 620 580 560 610 600 580
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
17 CS 8870 9590 8970 8920 9060 9030 8740 8990 9120 9020 2480 2600 2420 8890 8000 8580 8940 9040 8850 8920 9010 8810 8840 8920 8770 8870 8630 8840 8770 8810
Prohibit an ability to issue DML or DDL statements on RDB$ tables
18 SS 5430 5450 5550 5480 5340 5330 5620 5330 5510 5830 1590 1620 1600 5400 5320 5320 5520 5700 5560 5490 5550 5910 5900 5340 5520 5000 5300 5000 5430 5410
Prohibit an ability to issue DML or DDL statements on RDB$ tables
19 CS 1710 1740 1710 1730 1720 1710 1680 1720 1710 1710 1720 1800 1800 1700 1710 1650 1720 1700 1710 1710 1710 1690 1720 1710 1710 1690 1670 1730 1700 1710
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
20 SS 1470 1470 1470 1480 1940 1460 1430 1460 1460 1620 1480 1000 1480 1460 1490 1440 1000 1840 2010 1920 1450 1460 1470 1490 1460 1790 1860 1460 1460 1450
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
21 CS 900 890 1000 980 880 920 850 870 930 920 880 880 950 900 850 830 970 920 890 960 1240 860 900 880 990 930 850 890 900 900
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
22 SS 630 620 650 680 670 980 640 630 620 1000 660 650 640 630 630 630 640 660 640 630 610 610 650 610 630 630 610 620 610 620
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
23 CS 5650 5700 5650 5790 5690 5640 5620 5690 5620 5610 5640 6110 5740 5890 5640 5000 5720 5650 5660 5740 5620 5630 5730 5840 5680 5610 5550 5650 5910 5640
Badly selective index could be used for extra filtering even if selective index is used for sorting
24 CS 13840 13720 14200 14420 13890 13000 13740 13840 14190 13730 13960 13820 13780 13960 13580 14020 14130 14260 13870 14390 13820 13830 13770 13890 13840 14240 13780 13720 13790 14290
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
25 CS 630 630 620 680 650 630 620 630 660 680 630 640 620 660 680 610 630 610 620 640 700 680 610 630 640 670 590 600 600 610
Inconsistent cursor-driven deletion
26 SS 440 430 470 470 420 430 430 430 440 460 450 430 470 440 430 410 470 450 460 440 430 430 460 450 440 440 400 440 430 430
Inconsistent cursor-driven deletion
27 CS 1710 1710 1740 1710 1720 1690 1740 1720 1710 1710 1710 1700 1710 1730 2120 1670 1710 1720 1720 2230 1740 1710 1700 1720 1000 1720 1660 1710 1700 1690
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
28 SS 1460 1460 1480 1490 1460 1440 1440 1460 1460 1460 1480 1470 1480 1450 1440 1410 1470 1470 1470 1460 1460 1510 1490 1490 1450 1470 1410 1440 1440 1460
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
29 CS 4650 4630 4690 4650 4620 4640 4650 4620 4610 4670 4680 4620 4680 4700 4690 4590 4680 4620 4620 4650 4670 4600 4620 4700 4610 4680 4600 4680 4600 4660
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30 SS 4440 4440 4470 4460 4450 4440 4430 4440 4450 4470 4450 4430 4440 4440 4440 4420 4440 4450 4450 4450 4440 4490 4450 4440 4440 4440 4420 4450 4430 4440
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
31 CS 7840 7720 7990 8060 7740 7670 7610 7910 7690 7650 7700 8180 7930 7990 7840 7540 7920 7900 7780 7840 7860 7840 7740 7000 7830 7840 7670 7970 8000 8430
Indexed STARTING WITH execution is very slow with UNICODE collation
32 SS 7580 7390 7820 7910 7580 7000 7490 8240 7520 7470 7730 7640 7470 7620 7710 7450 7000 7600 7570 7000 7620 8950 7580 7520 7540 7700 7480 7530 7910 7980
Indexed STARTING WITH execution is very slow with UNICODE collation
33 CS 1800 1800 2000 1840 1810 1820 1780 1770 1770 1840 1790 1770 1780 1840 1880 1770 1820 1830 1790 2560 1790 1810 1810 1930 1800 1770 1000 1790 1950 1790
FULL OUTER JOIN, list all values, but filtered in WHERE clause
34 SS 1550 1640 1660 1540 1540 1530 1540 1640 1540 1560 1550 1530 1730 1780 1540 1520 1540 1550 1560 1560 1530 1000 2100 1980 1560 1530 1510 1550 1530 1560
FULL OUTER JOIN, list all values, but filtered in WHERE clause
35 CS 1790 1800 2170 1830 1760 1780 1770 1900 1780 1790 1780 1800 1780 1800 1830 1000 1880 1780 1810 1830 1780 1790 1830 1800 1780 1800 1000 1790 1770 1780
FULL OUTER JOIN, list all values, but filtered in WHERE clause
36 SS 1550 1550 1740 1530 1630 1530 1520 1640 1670 1550 1550 1550 1550 1520 1520 1530 1560 1540 1560 1580 1640 1000 2080 1560 1560 1540 1520 1540 1530 1570
FULL OUTER JOIN, list all values, but filtered in WHERE clause
37 CS 1790 2170 2190 1780 1760 1770 1780 1780 1820 1800 1790 1780 1780 1780 1810 1730 1820 1770 1770 2290 1830 1780 1810 2360 1880 1790 1920 1790 1780 1000
FULL OUTER JOIN, list all values, but filtered in WHERE clause
38 SS 1550 1550 1560 1550 1520 1560 1520 1780 1540 1540 1550 1540 1550 1520 1550 1520 1560 1560 1570 1560 1530 1000 2130 1620 1550 1540 1510 1550 1740 2050
FULL OUTER JOIN, list all values, but filtered in WHERE clause
39 CS 950 990 960 1090 980 960 950 950 930 890 930 920 990 910 1000 890 980 1010 930 980 940 940 950 950 930 950 840 950 900 960
INNER JOIN join order LIKE and STARTING WITH
40 SS 680 700 690 700 650 680 650 670 680 680 690 680 790 670 650 640 690 690 690 700 660 660 700 660 690 680 640 680 680 690
INNER JOIN join order LIKE and STARTING WITH
41 CS 880 930 890 890 890 930 860 890 900 860 940 910 860 960 930 770 910 850 840 870 950 870 870 880 870 830 760 870 840 930
LEFT OUTER JOIN with full match and reference in WHERE clause
42 SS 620 630 630 620 600 620 610 590 590 630 660 630 630 620 590 610 640 620 650 640 600 620 630 600 630 630 600 650 620 630
LEFT OUTER JOIN with full match and reference in WHERE clause
43 CS 890 970 890 890 840 890 930 910 880 940 900 860 860 930 860 820 880 880 860 960 940 860 970 990 900 890 810 940 900 860
LEFT OUTER JOIN with full match, but limited in ON clause
44 SS 620 630 630 620 590 620 600 590 610 620 710 640 640 630 620 600 620 630 670 620 600 600 630 600 630 610 590 650 600 640
LEFT OUTER JOIN with full match, but limited in ON clause
45 CS 890 890 930 870 900 850 920 920 890 910 890 860 890 910 920 780 940 960 880 910 920 860 880 890 880 860 840 880 880 880
LEFT OUTER JOIN with STARTING WITH in WHERE clause
46 SS 620 630 640 620 620 610 600 590 620 640 640 640 640 620 600 610 630 640 630 640 620 600 630 610 630 610 600 630 610 640
LEFT OUTER JOIN with STARTING WITH in WHERE clause
47 CS 900 1010 890 980 910 880 930 910 890 890 910 890 900 890 920 820 890 920 900 1000 940 960 900 900 880 920 870 900 880 900
Mixed JOINS
48 SS 650 660 660 640 640 650 640 700 650 660 670 640 660 650 650 630 670 650 660 680 640 650 650 660 720 650 630 660 660 670
Mixed JOINS
49 CS 700 0 0 0 0 0 0 0 690 700 700 700 740 790 700 670 720 710 720 700 0 690 700 710 700 700 680 680 670 680
Empty DB - RDB$FIELDS
50 SS 490 0 0 0 0 0 0 0 480 490 0 510 0 0 0 460 510 510 510 490 490 480 490 480 0 490 450 470 480 490
Empty DB - RDB$FIELDS
51 CS 595 0 0 0 0 0 0 0 580 580 600 640 650 640 620 580 590 580 630 590 680 600 580 600 590 600 560 620 580 570
Empty DB - RDB$FORMATS
52 SS 420 0 0 0 0 0 0 0 420 430 420 430 430 420 410 400 420 420 440 420 400 420 410 420 430 410 390 410 410 0
Empty DB - RDB$FORMATS
53 CS 585 0 0 0 0 0 0 0 600 580 590 590 600 670 580 580 580 610 640 590 660 580 580 610 570 580 560 590 580 580
New DB - RDB$FUNCTION_ARGUMENTS
54 SS 420 0 0 0 0 0 0 0 410 420 430 430 420 420 420 410 450 430 460 420 410 430 430 430 430 420 390 410 420 420
New DB - RDB$FUNCTION_ARGUMENTS
55 CS 590 0 0 0 0 0 0 0 600 620 590 580 600 590 590 570 600 630 600 580 640 590 580 650 830 600 560 580 580 580
New DB - RDB$FUNCTIONS
56 SS 420 0 0 0 0 0 0 0 400 420 420 420 420 420 410 410 430 420 440 420 410 420 430 410 430 420 390 410 400 440
New DB - RDB$FUNCTIONS
57 CS 600 0 0 0 0 0 0 0 600 610 690 580 620 580 610 580 640 610 600 600 580 620 590 620 580 600 580 590 580 580
New DB - RDB$PROCEDURE_PARAMETERS
58 SS 430 0 0 0 0 0 0 0 430 450 430 430 430 420 430 400 440 440 440 430 410 410 430 420 430 450 410 430 420 440
New DB - RDB$PROCEDURE_PARAMETERS
59 CS 590 0 0 0 0 0 0 0 580 650 690 580 650 630 580 560 640 590 630 650 590 590 620 610 580 580 560 570 580 580
New database: content of RDB$PROCEDURES
60 SS 425 0 0 0 0 0 0 0 430 460 440 440 420 420 410 430 440 430 440 420 410 420 420 430 440 420 400 430 400 420
New database: content of RDB$PROCEDURES
61 CS 605 0 0 0 0 0 0 0 660 620 690 670 660 670 590 600 590 610 700 670 640 580 600 600 590 640 570 590 580 590
Empty DB - RDB$RELATIONS
62 SS 440 0 0 0 0 0 0 0 430 430 440 440 450 450 440 400 450 450 440 440 420 430 430 430 450 430 400 460 430 440
Empty DB - RDB$RELATIONS
63 CS 780 0 0 0 0 0 0 0 4370 4340 4360 4370 4330 780 830 800 780 800 880 820 760 700 740 730 0 710 650 710 710 720
Empty DB - RDB$SECURITY_CLASSES
64 SS 575 0 0 0 0 0 0 0 4140 4130 4140 4560 4110 580 560 550 640 570 570 600 510 0 0 0 0 510 490 550 0 0
Empty DB - RDB$SECURITY_CLASSES
65 CS 770 0 0 0 0 0 0 0 820 820 810 810 830 770 780 740 0 0 760 760 0 0 0 780 830 730 700 730 740 730
Empty DB - RDB$USER_PRIVILEGES
66 SS 550 0 0 0 0 0 0 0 590 600 620 610 600 530 530 520 580 550 590 560 560 520 540 530 540 570 510 550 520 510
Empty DB - RDB$USER_PRIVILEGES
67 CS 600 600 590 610 580 580 580 600 640 580 580 580 590 600 590 560 640 640 630 600 650 640 640 620 620 600 560 580 580 570
ISQL - SHOW SYSTEM TABLES
68 SS 420 440 420 430 410 410 410 410 410 440 450 430 440 420 410 410 450 430 440 450 400 410 440 410 430 420 410 410 410 410
ISQL - SHOW SYSTEM TABLES
69 CS 10590 10000 9580 11740 10570 9510 11560 10000 9550 8930 9550 11700 10600 11560 200000 11310 9480 10550 200080 200920 10590 9440 10580 200380 200280 9480 10390 200190 199960 199950
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
70 SS 10620 8490 10590 9670 9520 10490 11550 10540 11570 9610 9610 9600 10690 8520 199390 9420 10660 10630 198950 199110 9480 10620 11690 199120 199050 10550 9390 199030 199080 198930
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
71 CS 6040 5970 6020 6080 5950 5920 6020 5920 8960 6020 5890 6040 5890 5940 134290 6640 5880 5890 134090 134670 6880 6000 7010 134130 134590 6800 5680 134340 134080 133860
Problem with replication of BLOB segments longer than 32KB
72 SS 6080 6070 6080 6130 6000 6030 6010 6030 6060 6050 6070 6060 6100 7090 133200 5940 6110 6060 132980 133120 6010 7560 6180 133550 132990 6020 5890 133090 133050 133080
Problem with replication of BLOB segments longer than 32KB
73 CS 6030 5970 5940 6030 5840 5840 5880 5960 9010 5960 5930 8080 6140 5940 134440 5740 5920 5900 134120 134560 8930 9010 6070 134140 134610 5840 5680 134180 134030 134050
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica.
74 SS 6090 7040 6170 6120 6020 6010 6010 6060 6090 6080 6080 6090 6140 6160 133190 5920 6070 6090 133040 133090 6060 5020 6080 133210 133150 6040 5960 133190 133110 133040
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica.
75 CS 6830 7040 6760 6970 6780 6900 6730 6740 6830 6780 6830 7740 6870 6810 155300 6460 6760 6740 154880 155220 6780 6800 6890 155230 155320 6830 6540 155160 154990 155040
DDL-triggers must fire only on master DB.
76 SS 7880 7800 7900 7920 7790 7840 7760 8850 6850 7840 7870 7930 6870 7790 154210 6640 7890 7880 153910 154120 7780 8870 7880 154150 153970 7790 7680 154050 153980 153980
DDL-triggers must fire only on master DB.
77 CS 9860 9230 9860 9060 9720 9910 9840 9800 9790 9760 9740 9890 9820 9860 200510 9430 9890 9760 200260 201060 9890 9740 9980 200620 200550 9000 10430 201020 200400 200210
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
78 SS 9670 9670 9000 9760 9620 9610 9610 8000 9650 9670 9730 9740 9700 9590 199230 9510 9700 8700 199030 199230 9580 10630 8000 199610 199080 9650 9550 199130 199370 199070
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
79 CS 6270 6230 6270 6370 6130 6240 6230 6140 6220 6270 6190 8170 6140 6120 134360 5890 6140 6270 134000 134600 8290 6330 8320 134580 134340 6000 5860 134450 134310 134140
Failed DDL commands can be replicated
80 SS 6290 6240 7660 6330 6220 6260 7180 7620 6240 6270 6260 6290 6000 6220 133350 6100 6270 6300 133110 133680 6260 6270 7280 133280 133140 6000 6080 133280 133360 133240
Failed DDL commands can be replicated
81 CS 6460 6410 8650 6550 6000 6290 6340 6420 8450 6380 6390 6400 8360 6290 134720 6030 6460 6360 134460 135110 6300 8430 6340 134640 134980 9390 6030 134000 134480 134530
Generator values may not replicate after commit
82 SS 6370 6320 5350 6400 6300 6320 6340 5270 6360 6370 6370 5340 6430 6350 133450 6200 6380 6380 133300 133630 6280 6800 5350 133380 133300 6310 6190 133440 133400 133360
Generator values may not replicate after commit
83 CS 11110 10110 11310 13210 11050 9980 10120 10080 11090 10010 10070 11110 11140 10130 134310 10810 13110 10150 133900 134490 11100 11030 11140 134190 134040 13130 10740 134470 133960 133910
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
84 SS 10260 10160 10300 10300 10100 10150 10200 11140 10220 10190 10210 11240 10240 10170 133260 11050 10260 10210 133030 133210 10150 9140 11230 133120 133000 10200 10010 133260 133140 133010
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
85 CS 5570 3560 5720 5770 5460 3490 3560 3540 5000 3550 3600 5570 5710 3650 133860 3380 5520 6640 133610 133840 5000 5490 5640 134050 133830 5580 5280 133720 133640 133580
Permission error with replication
86 SS 14730 14650 14710 14800 15660 14670 14670 14670 14660 14680 14670 14710 14730 14680 132720 14560 14730 15710 132540 133070 15620 15680 14760 132640 132570 14650 14550 132690 132640 132710
Permission error with replication
87 CS 17320 29150 17320 14470 17000 17130 17150 17140 14070 17150 27700 17300 17190 27650 412430 16790 25540 27510 411810 412080 17200 14080 17630 412590 412700 7740 14720 412210 412120 412040
Crash or hang while shutting down the replica database if segments are being applied
88 SS 35920 35610 49670 35920 34700 50080 35690 35640 35660 35630 35670 38780 35630 38790 410950 35390 38680 34790 410230 411120 34000 35730 35620 410850 410000 38730 33610 410840 410900 410450
Crash or hang while shutting down the replica database if segments are being applied
89 CS 6420 8510 5800 5920 6670 5650 5630 5720 6760 5680 5770 5710 5680 5910 133890 6420 5820 5860 133730 133920 5680 6800 5760 133940 134430 8730 6510 134390 133730 133650
Some updates can crash Firebird server on replica side
90 SS 26890 29760 26680 26890 27720 26560 26790 29780 26760 26780 26790 26730 26800 26810 132650 30630 26790 27810 132440 132600 27730 26820 24720 132590 132520 26760 26690 132620 132580 132470
Some updates can crash Firebird server on replica side
91 CS 6230 6230 6040 6060 71560 6100 7000 6030 71620 5970 6080 5920 6950 6140 134270 5690 6110 6050 134130 134100 6880 71670 6100 134070 134000 5880 5610 134140 134050 134190
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
92 SS 30020 31000 31060 30060 29990 31060 26930 30980 26940 28000 30980 27000 29990 30020 132870 26780 29970 26970 132700 133700 26920 26900 27040 132920 132000 26980 29890 132870 132810 133010
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1549
http://tracker.firebirdsql.org/browse/core-2078
http://tracker.firebirdsql.org/browse/core-2303
http://tracker.firebirdsql.org/browse/core-2650
http://tracker.firebirdsql.org/browse/core-4318
http://tracker.firebirdsql.org/browse/core-4379
http://tracker.firebirdsql.org/browse/core-4447
http://tracker.firebirdsql.org/browse/core-4528
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-5061
http://tracker.firebirdsql.org/browse/core-5236
http://tracker.firebirdsql.org/browse/core-5435
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_full_join_04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_inner_join_05.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_left_join_03.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_left_join_06.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_left_join_11.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/arno/optimizer/opt_mixed_joins_05.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_07.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_10.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_11.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_12.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_19.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_20.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_23.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_26.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/db/db_31.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/isql/isql_02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/blob-not-found-in-rw-replica-if-target-row-exists.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/blob-segments-longer-32kb-are-not-replicated.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/dblevel-triggers-must-not-fire-on-replica.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/ddl-triggers-must-not-fire-on-replica.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/duplicates-in-rw-replica-after-conflicting-insert.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/failed-ddl-commands-can-be-replicated.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/generator-could-not-be-transferred-to-replica.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/invalid-msg-if-target-db-has-no-replica-flag.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/permission-error-on-ddl-issued-by-non-sysdba.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/shutdown-during-applying-segments-leads-to-crash.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/some-updates-crash-server-on-replica-side.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/replication/updating-blob-with-empty-string-stops-replication.fbt
https://github.com/FirebirdSQL/firebird/issues/6220
https://github.com/FirebirdSQL/firebird/issues/6778
https://github.com/FirebirdSQL/firebird/issues/6790
https://github.com/FirebirdSQL/firebird/issues/6802
https://github.com/FirebirdSQL/firebird/issues/6872

=== end of list ===