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
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 |
| 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 |