0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (0 rows)
2. FRESH FAILS: tests which failed for LAST execution only (26 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 (0 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous runs (68 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (0 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (4388 rows)
8. All tests: outcomes (2286 rows)
9. All tests: durations (4504 rows)
A. Skipped: tests which was intentionally excluded from execution (45 rows)

Generated 05.02.2023 01:01
Tested: FB50.   Build: 5.0.0.930;   SS: 04.02.23 22:46:00 - 04.02.23 23:45:07;   CS: 04.02.23 23:48:42 - 05.02.23 00:58:14;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 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.927
2023-02-04
5.0.0.923
2023-02-02
5.0.0.920
2023-01-29
5.0.0.917
2023-01-22
5.0.0.916
2023-01-20
5.0.0.915
2023-01-19
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-06
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-04
5.0.0.861
2022-12-03
5.0.0.860
2022-12-02
5.0.0.848
2022-11-29
Test TITLE
1 CS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order
2 SS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order
3 CS     F     X     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         F         F         F    
Suboptimal join plan if there are selective non-indexed predicates involved
4 SS     F     X     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         F         F         F    
Suboptimal join plan if there are selective non-indexed predicates involved
5 CS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Include PLAN in mon$statements
6 SS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Include PLAN in mon$statements
7 CS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
8 SS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
9 CS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
10 SS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
11 CS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
12 SS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
13 CS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
14 SS P X P X P P P P P     F         F         F         F     P P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
15 CS     F     X     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         F         F         F    
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
16 SS     F     X     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         F         F         F    
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
17 CS P X P X P P P 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 X P X P P P 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 X P X P P P 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 X P X P P P 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     X     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         F         F         F    
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
22 SS     F     X     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         F         F         F    
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
23 CS     F     X     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         F         F         F    
Ability to query Firebird configuration using SQL
24 SS     F     X     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         F         F         F    
Ability to query Firebird configuration using SQL
25 CS P X P X P P P 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 X P X P P P 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 X P X P P P 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 X P X P P P 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     F     X     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         F         F         F    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30 SS     F     X     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         F         F         F    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
31 CS P X P X 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
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
32 SS P X P X 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
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
33 CS     F     X     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         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
34 SS     F     X     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         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
35 CS     F     X     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         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
36 SS     F     X     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         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
37 CS     F     X     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         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
38 SS     F     X     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         F         F         F    
FULL OUTER JOIN, list all values, but filtered in WHERE clause
39 CS     F     X     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         F         F         F    
INNER JOIN join order LIKE and STARTING WITH
40 SS     F     X     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         F         F         F    
INNER JOIN join order LIKE and STARTING WITH
41 CS     F     X     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         F         F         F    
LEFT OUTER JOIN with full match and reference in WHERE clause
42 SS     F     X     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         F         F         F    
LEFT OUTER JOIN with full match and reference in WHERE clause
43 CS     F     X     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         F         F         F    
LEFT OUTER JOIN with full match, but limited in ON clause
44 SS     F     X     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         F         F         F    
LEFT OUTER JOIN with full match, but limited in ON clause
45 CS     F     X     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         F         F         F    
LEFT OUTER JOIN with STARTING WITH in WHERE clause
46 SS     F     X     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         F         F         F    
LEFT OUTER JOIN with STARTING WITH in WHERE clause
47 CS     F     X     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         F         F         F    
Mixed JOINS
48 SS     F     X     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         F         F         F    
Mixed JOINS
49 CS S S S X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X S S S 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 X P P P 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 X P P P 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

Elapsed time, milliseconds:
NN Test name mode median_ms 5.0.0.930
2023-02-05
5.0.0.927
2023-02-04
5.0.0.923
2023-02-02
5.0.0.920
2023-01-29
5.0.0.917
2023-01-22
5.0.0.916
2023-01-20
5.0.0.915
2023-01-19
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-06
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-04
5.0.0.861
2022-12-03
5.0.0.860
2022-12-02
5.0.0.848
2022-11-29
Test TITLE
1 CS 640 690 700 630 600 670 660 640 670 630 640 590 600 630 690 690 660 650 650 670 610 650 610 660 640 620 640 590 630
Subquery-based predicates are not evaluated early in the join order
2 SS 545 520 550 530 560 550 530 550 550 590 520 510 540 550 570 590 540 600 510 540 550 530 520 600 0 510 580 530 0
Subquery-based predicates are not evaluated early in the join order
3 CS 1410 2010 1420 1390 1420 1410 1480 1380 1530 1520 1470 1490 1490 1400 1480 1390 1400 1640 1360 1380 1410 1430 1400 1350 1380 1400 1350 1410 1370
Suboptimal join plan if there are selective non-indexed predicates involved
4 SS 1340 1560 1340 1340 1390 1330 1480 1390 1430 1550 1420 1300 1420 1330 1320 1410 1420 1380 1300 1350 1270 1340 1330 1340 1340 1230 1340 1350 1340
Suboptimal join plan if there are selective non-indexed predicates involved
5 CS 700 1050 0 650 720 670 720 0 770 780 0 710 700 680 730 0 0 740 680 650 640 770 680 690 740 700 700 740 680
Include PLAN in mon$statements
6 SS 585 550 560 630 580 600 630 560 620 700 600 590 600 630 670 620 600 580 570 570 620 570 570 570 580 580 550 630 510
Include PLAN in mon$statements
7 CS 1025 910 1070 1050 1010 930 1000 950 1120 1150 1010 1020 1030 990 1070 1080 1030 1040 1060 1170 1140 1110 990 1040 930 950 880 970 960
Improve sorting performance when long VARCHARs are involved
8 SS 875 960 790 790 850 860 900 830 1020 990 880 850 890 880 1000 900 920 930 910 1020 820 820 870 850 870 880 830 850 860
Improve sorting performance when long VARCHARs are involved
9 CS 870 1200 860 870 900 880 880 850 950 1020 830 870 890 880 830 930 880 830 820 850 770 920 800 890 900 780 820 820 830
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
10 SS 780 980 760 720 780 770 760 740 780 850 810 780 780 780 820 710 800 740 810 800 800 800 730 830 700 910 810 800 740
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
11 CS 2385 3400 2630 2000 2340 2490 2560 2470 2650 2600 2610 2360 2550 2410 2690 2370 2360 2390 2300 2400 2290 2260 2390 2350 2290 2340 2280 2380 2260
Poor performance of explicit cursors containing correlated subqueries in the select list
12 SS 2270 2180 2200 2160 2350 2140 2360 2350 2590 2520 2440 2270 2310 2320 2480 2270 2190 2170 2120 2190 2270 2240 2150 2080 2070 2310 2460 2370 2050
Poor performance of explicit cursors containing correlated subqueries in the select list
13 CS 810 780 790 790 780 720 880 830 880 860 820 760 840 800 870 830 850 800 800 780 810 880 810 860 760 800 800 820 810
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
14 SS 700 690 680 690 680 730 740 690 730 740 700 760 660 690 690 770 770 700 740 730 710 690 0 700 640 710 700 690 730
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
15 CS 795 760 740 780 740 780 790 870 850 880 800 820 840 770 780 780 790 850 830 770 690 800 840 810 730 840 850 810 790
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
16 SS 680 630 680 680 680 690 670 650 760 770 0 670 740 730 790 730 680 690 660 690 630 670 710 660 670 660 710 760 730
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
17 CS 13250 16620 13200 13280 13120 13400 13010 13590 14650 2000 2600 2560 14350 13930 13000 13360 13610 13260 13220 13980 13180 13270 12620 13240 12960 13100 13330 12000 13390
Prohibit an ability to issue DML or DDL statements on RDB$ tables
18 SS 9630 9610 9650 9650 9820 9540 9770 10530 9930 2080 2160 2170 9510 9730 9300 10120 9760 9680 9960 9990 9650 9440 9940 9160 9000 9460 9440 9580 9560
Prohibit an ability to issue DML or DDL statements on RDB$ tables
19 CS 1640 1740 1570 1650 1650 1650 1570 1650 1710 1690 1640 1680 1610 1630 1640 1640 1580 1620 1630 1580 1580 1600 1640 1610 1580 1670 1640 1640 1640
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
20 SS 1470 1440 1000 1470 1470 1470 1510 1460 1530 1540 1480 1000 1470 1460 1470 1000 1520 1490 1470 1450 1490 1490 1440 1430 1470 1480 1450 1470 1450
ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
21 CS 860 1200 830 860 860 860 870 920 910 970 890 890 870 900 860 860 920 880 830 830 860 860 920 890 810 840 840 790 850
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
22 SS 800 1060 740 800 800 820 770 810 860 870 800 800 770 790 840 730 790 790 790 840 780 760 740 810 770 830 820 830 830
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
23 CS 2515 2510 2420 2580 2490 2430 2480 2420 2530 2540 2510 2630 2530 2590 2520 2580 2630 2630 2530 2390 2460 2570 2410 2490 2540 2400 2410 2360 2580
Ability to query Firebird configuration using SQL
24 SS 2365 2340 2280 2220 2400 2470 2380 2330 2410 2390 2410 2370 2440 2290 2320 2370 2450 2480 2290 2340 2560 2190 2350 2370 2400 2360 2330 2300 2340
Ability to query Firebird configuration using SQL
25 CS 650 680 680 660 670 620 640 670 670 640 670 670 650 600 630 650 670 730 610 620 700 640 630 680 530 610 680 650 570
Inconsistent cursor-driven deletion
26 SS 560 630 550 530 540 590 550 580 650 600 530 540 530 620 550 580 600 580 520 520 560 580 560 540 510 540 600 0 590
Inconsistent cursor-driven deletion
27 CS 1620 1630 1570 1590 1690 1610 1630 1640 1640 1670 1670 1620 1600 1630 1640 1590 1730 1700 1600 1610 1570 1590 1610 1530 1600 1650 1730 1550 1620
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
28 SS 1490 1420 1480 1470 1490 1540 1490 1510 1540 1550 1550 1520 1540 1000 1540 1490 1480 1510 1480 1460 1480 1530 1480 1490 1450 1510 1520 1470 1490
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
29 CS 4170 4350 3890 4030 4430 3840 4280 3970 4590 4440 4260 3910 4140 4470 4420 4390 3930 4060 4290 3920 4570 4540 4170 4610 4170 3000 3700 3970 3830
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30 SS 3865 3670 4000 4530 3930 4510 3710 3610 3770 3640 4100 4170 3860 3780 4020 3590 3580 4300 3970 3810 4160 3570 3740 3600 4550 3870 4460 3000 4040
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
31 CS 4260 4260 4400 4290 4590 4480 4260 4570 4450 4830 4300 4180 4590 4240 4210 4090 4100 4120 3890 4400 4190 4160 4620 4180 4210 4410 4940 4260 4150
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
32 SS 4155 4340 4310 4300 4640 4150 4060 4000 4670 4670 4200 4130 4000 4340 4240 3730 3990 3950 3840 4670 4160 4100 4290 4100 4070 3940 4290 4430 3960
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
33 CS 1775 1740 1800 1790 1810 1770 1780 1820 1810 1840 1000 1810 1770 1730 1790 1760 1850 1810 1780 1840 1720 1760 1790 1720 1740 1730 1760 1720 1770
FULL OUTER JOIN, list all values, but filtered in WHERE clause
34 SS 1685 1900 1650 1680 1680 1690 1690 1680 1790 1760 1690 1660 1710 1640 1720 1670 1670 1690 1730 1610 1700 1710 1670 1680 1720 1660 1630 1630 1710
FULL OUTER JOIN, list all values, but filtered in WHERE clause
35 CS 1785 1790 1760 1760 1740 1000 1770 1780 1930 1830 1820 1730 1810 1800 1740 1780 1000 1850 1000 1800 1790 1820 1710 1700 1720 1840 1820 1800 1830
FULL OUTER JOIN, list all values, but filtered in WHERE clause
36 SS 1680 1900 1640 1660 1670 1660 1620 1660 1780 1000 1700 1720 1720 1700 1670 1670 1740 1690 1680 1660 1740 1680 1740 1710 1650 1740 1000 1650 1730
FULL OUTER JOIN, list all values, but filtered in WHERE clause
37 CS 1800 1780 1860 1840 1740 1000 1720 1890 1860 1910 1800 1840 1790 1770 1730 1770 1840 1850 1820 1780 1820 1880 1840 1770 1760 1000 1720 1810 1800
FULL OUTER JOIN, list all values, but filtered in WHERE clause
38 SS 1690 1860 1650 1660 1670 1690 1670 1690 1850 1720 1700 1680 1700 1690 1710 1650 1680 1690 1670 1670 1650 1710 1710 1680 1770 1730 1650 1690 1680
FULL OUTER JOIN, list all values, but filtered in WHERE clause
39 CS 1005 950 950 960 900 1040 950 1000 1030 1070 980 1060 1050 1040 1010 1010 1040 1050 910 980 1070 1010 1000 950 1060 940 860 980 1050
INNER JOIN join order LIKE and STARTING WITH
40 SS 895 1140 860 930 870 930 930 880 970 910 930 980 960 960 850 890 910 900 900 860 890 840 870 840 820 880 860 850 980
INNER JOIN join order LIKE and STARTING WITH
41 CS 835 860 780 840 850 850 910 770 910 870 810 810 800 840 820 860 860 920 820 850 810 870 830 810 800 780 840 830 770
LEFT OUTER JOIN with full match and reference in WHERE clause
42 SS 720 1010 670 720 720 740 730 680 810 760 740 870 720 0 800 700 0 720 790 720 0 760 690 690 0 670 740 0 720
LEFT OUTER JOIN with full match and reference in WHERE clause
43 CS 830 830 860 830 840 820 840 820 900 950 800 900 830 810 860 860 910 810 820 860 870 840 780 790 770 890 830 730 0
LEFT OUTER JOIN with full match, but limited in ON clause
44 SS 730 970 770 740 710 710 710 0 790 760 0 710 730 700 710 710 820 790 720 800 740 850 700 0 710 690 740 770 700
LEFT OUTER JOIN with full match, but limited in ON clause
45 CS 840 1050 830 810 840 830 840 850 900 920 850 850 860 810 810 810 840 1000 880 830 800 760 850 950 840 840 840 780 880
LEFT OUTER JOIN with STARTING WITH in WHERE clause
46 SS 725 910 720 760 740 730 720 710 840 850 720 0 820 720 730 0 760 730 710 780 690 730 720 770 700 690 720 680 680
LEFT OUTER JOIN with STARTING WITH in WHERE clause
47 CS 950 1010 940 950 1010 930 940 970 1080 1240 980 940 950 980 870 970 970 970 960 1180 910 950 900 870 990 870 890 880 950
Mixed JOINS
48 SS 870 1150 770 850 850 870 900 880 890 1080 870 860 890 840 830 910 950 840 940 890 870 850 920 860 870 860 840 840 940
Mixed JOINS
49 CS 650 0 0 0 0 0 0 0 630 0 770 680 710 640 710 780 720 790 700 670 620 580 650 580 670 610 640 600 640 640
Empty DB - RDB$FIELDS
50 SS 560 0 0 0 0 0 0 0 560 640 660 580 530 570 560 590 540 540 580 580 560 530 510 550 560 570 570 510 530 570
Empty DB - RDB$FIELDS
51 CS 550 0 0 0 0 0 0 0 570 640 570 520 600 550 530 550 530 570 570 560 470 0 540 590 530 540 530 490 560 530
Empty DB - RDB$FORMATS
52 SS 460 0 0 0 0 0 0 0 470 470 530 540 460 460 460 470 440 470 480 450 420 460 400 520 420 430 440 490 450 460
Empty DB - RDB$FORMATS
53 CS 570 0 0 0 0 0 0 0 590 620 650 610 580 630 590 580 570 550 600 540 480 550 530 550 0 540 550 560 620 530
New DB - RDB$FUNCTION_ARGUMENTS
54 SS 470 0 0 0 0 0 0 0 470 480 530 480 490 490 0 510 440 460 490 0 430 460 470 450 430 430 450 480 490 430
New DB - RDB$FUNCTION_ARGUMENTS
55 CS 570 0 0 0 0 0 0 0 600 610 630 600 560 580 590 570 590 580 560 570 530 560 550 540 590 540 530 520 570 550
New DB - RDB$FUNCTIONS
56 SS 470 0 0 0 0 0 0 0 470 510 470 460 480 470 540 480 490 470 460 0 440 490 450 470 440 430 440 410 490 480
New DB - RDB$FUNCTIONS
57 CS 570 0 0 0 0 0 0 0 570 610 600 590 530 580 620 610 540 570 580 590 570 520 520 480 550 570 550 550 540 610
New DB - RDB$PROCEDURE_PARAMETERS
58 SS 470 0 0 0 0 0 0 0 460 450 470 0 530 490 470 0 480 480 470 450 450 440 630 450 470 430 0 480 460 450
New DB - RDB$PROCEDURE_PARAMETERS
59 CS 565 0 0 0 0 0 0 0 610 610 600 570 620 540 540 570 600 570 550 550 460 480 570 580 530 520 600 560 490 490
New database: content of RDB$PROCEDURES
60 SS 460 0 0 0 0 0 0 0 480 530 550 460 460 460 470 490 0 510 470 460 470 460 410 540 450 460 480 450 420 460
New database: content of RDB$PROCEDURES
61 CS 580 0 0 0 0 0 0 0 570 650 690 580 560 560 580 580 590 590 560 610 540 590 590 600 570 520 550 550 530 580
Empty DB - RDB$RELATIONS
62 SS 490 0 0 0 0 0 0 0 540 520 0 490 0 520 510 540 0 510 480 470 440 470 0 480 480 470 530 530 0 490
Empty DB - RDB$RELATIONS
63 CS 770 0 0 0 0 0 0 0 5300 5360 5860 5310 5290 830 820 900 740 810 860 770 690 0 770 720 700 670 660 680 670 700
Empty DB - RDB$SECURITY_CLASSES
64 SS 670 0 0 0 0 0 0 0 4930 5400 6560 5060 4870 760 740 860 740 710 650 690 610 620 590 620 570 610 590 640 550 630
Empty DB - RDB$SECURITY_CLASSES
65 CS 765 0 0 0 0 0 0 0 810 900 890 920 830 800 810 810 770 760 0 0 640 740 730 690 800 730 650 680 680 700
Empty DB - RDB$USER_PRIVILEGES
66 SS 635 0 0 0 0 0 0 0 680 730 760 720 760 640 670 780 620 640 680 630 580 590 630 600 640 600 590 590 570 580
Empty DB - RDB$USER_PRIVILEGES
67 CS 560 530 510 540 530 590 560 630 610 630 590 580 570 550 570 540 560 580 580 580 540 590 540 550 530 0 520 520 550 0
ISQL - SHOW SYSTEM TABLES
68 SS 460 720 460 480 460 430 460 480 490 540 510 480 460 480 460 470 470 460 460 490 440 460 450 460 460 470 450 440 480 420
ISQL - SHOW SYSTEM TABLES

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-6444
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/firebird/issues/6778
https://github.com/FirebirdSQL/firebird/issues/6790
https://github.com/FirebirdSQL/firebird/issues/6802
https://github.com/FirebirdSQL/firebird/issues/6875

=== end of list ===