01. Total results for each kind of outcome and server mode, for previous 35 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
03. NEW FAILS: tests which failed for LAST run (0 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (1 rows)
[CURRENT] 05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (50 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (13 rows)
07. Has fails: tests with at least one fail for previous 35 runs (22 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (6 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 35 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (1 rows)
11. All tests: outcomes for previous 35 runs (2865 rows)
12. Skipped: tests which was intentionally excluded from execution (169 rows)

Generated UTC 02.10.2025 06:15
Tested: FB50.   Build / date: 5.0.4.1722-d92e2d8c / 2025.10.01;
Test machine: Linux 6.11.5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.11.5-1 (2024-10-27); logical CPUs: 2; RAM: 7 Gb 
QA software: Python: 3.11.9; pytest: 7.4.4; firebird.driver: 2.0.2; firebird.Qa: 0.21.0 
Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Tests with performance slowdown for LAST 5 runs - moving medians

LAST moving median (window = 5) greater than previous for at least 1.5x. No more than 50 rows are shown, pre-filtered in descending order of ratio between latest and previous medians:
NN Test name mode Test last update Moving medians chart
5.0.4.1722
2025.10.01
d92e2
5.0.4.1720
2025.09.30
a703b
5.0.4.1717
2025.09.29
79841
5.0.4.1715
2025.09.24
4aac5
5.0.4.1714
2025.09.15
3e313
5.0.4.1713
2025.09.13
6997f
5.0.4.1711
2025.09.09
cf241
5.0.4.1706
2025.09.07
ab04a
5.0.4.1704
2025.08.28
3fedd
5.0.4.1703
2025.08.20
bd5ab
5.0.4.1701
2025.08.07
27cb4
5.0.4.1697
2025.08.06
f63a8
5.0.4.1696
2025.08.04
c784c
5.0.3.1693
2025.07.30
8da78
5.0.3.1690
2025.07.28
19167
5.0.3.1689
2025.07.24
57f39
5.0.3.1686
2025.07.23
981c0
5.0.3.1684
2025.07.19
e451f
5.0.3.1683
2025.07.12
e98c3
5.0.3.1681
2025.07.11
5a438
5.0.3.1679
2025.07.09
88943
5.0.3.1676
2025.07.01
88ba7
5.0.3.1675
2025.06.27
1bb2c
5.0.3.1674
2025.06.26
d366d
5.0.3.1673
2025.06.25
f0e1f
5.0.3.1668
2025.06.21
b8e22
5.0.3.1667
2025.06.15
4374a
5.0.3.1666
2025.06.14
97178
5.0.3.1665
2025.06.11
d8b62
5.0.3.1661
2025.06.10
cfcf0
5.0.3.1660
2025.06.07
db691
Test TITLE
1
bugs core 0733 
 tracker
 SS 2023.05.13 17:29
68139 41620 40707 40707 41620 42090 42090 42090 42430 41244 40552 39712 39680 39522 39286 39286 39286 39286 39544 40174 40538 40174 40538 40927 40941 41555 43423 44735 46662 47108 48327
Compress Data over the Network
2
bugs core 2678 
 tracker
 SS 2025.06.26 18:46
702 414 388 388 388 392 399 399 416 392 391 390 390 390 385 385 385 390 377 390 390 373 371 371 371 373 407 442 442 445 445
Full outer join cannot use available indices (very slow execution)
3
bugs core 2971 
 tracker
 CS 2022.02.02 14:46
1252 804 804 803 790 790 782 769 769 742 742 774 774 758 758 758 758 770 782 782 782 782 743 743 760 778 778 831 928 949 928
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
4
bugs core 3238 
 tracker
 SS 2022.02.02 14:46
1969 1243 1243 1236 1235 1235 1252 1254 1254 1254 1238 1238 1238 1220 1199 1199 1199 1194 1194 1225 1225 1209 1215 1215 1209 1215 1256 1432 1488 1495 1510
Makes GEN_UUID return a compliant RFC-4122 UUID
5
bugs core 3305 
 tracker
 SS 2025.06.27 14:40
537 348 348 348 352 377 377 377 378 382 407 382 382 374 371 368 368 374 365 358 375 375 378 378 394 410 410 412 448 448 416
"BLOB not found" error after creation/altering of the invalid trigger
6
bugs core 3435 
 tracker
 SS 2022.02.02 14:46
2011 1230 1230 1230 1518 1531 1531 1518 1518 1466 1397 1466 1386 1368 1337 1275 1275 1337 1383 1383 1383 1383 1393 1336 1393 1434 1461 1485 1552 1638 1655
Lateral derived tables
7
bugs core 4135 
 tracker
 CS 2024.05.15 17:26
33517 20108 20014 19922 19853 19853 19861 19861 19861 20179 20179 20179 19947 19947 19416 19416 19394 19120 19092 18961 18503 18240 18240 18240 18528 18709 20063 20770 20986 20986 20774
In SS sweep blocks establishment of concurrent attachments
8
bugs core 4135 
 tracker
 SS 2024.05.15 17:26
25844 15909 15390 15261 14896 14896 14896 15068 15197 15197 15283 15068 15283 14854 14854 14774 14551 14551 14532 14532 14404 14188 14088 13839 13839 14088 14974 15955 16338 16678 16678
In SS sweep blocks establishment of concurrent attachments
9
bugs core 4484 
 tracker
 CS 2025.06.30 08:58
1043 658 641 641 658 700 700 700 685 669 669 685 685 692 692 682 682 678 665 665 665 663 663 663 663 691 722 774 774 789 790
Description (COMMENT ON) for package procedures and functions, and its parameters
10
bugs core 4488 
 tracker
 CS 2025.09.09 15:02
1302 820 819 815 815 819 835 853 863 853 853 853 882 844 848 812 812 812 847 827 847 847 847 856 877 877 998 960 998 1000 1000
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
11
bugs core 4760 
 tracker
 CS 2024.10.31 10:17
1950 1252 1252 1252 1275 1275 1275 1265 1265 1232 1232 1185 1185 1119 1173 1105 1105 1172 1172 1172 1192 1192 1204 1204 1204 1247 1298 1386 1454 1463 1454
Can not create user with non-ascii (multi-byte) characters in it's name
12
bugs core 4864 
 tracker
 SS 2022.09.20 08:03
1053 676 676 662 662 676 651 676 694 676 676 676 673 671 630 630 633 633 630 633 634 634 641 641 641 683 683 779 779 779 751
CREATE DATABASE fail with ISQL
13
bugs core 5393 
 tracker
 SS 2023.05.13 17:30
50779 32766 32336 32336 32761 32761 32761 32775 33119 32812 32775 32775 32344 32344 32338 32338 32354 32802 33382 33382 33744 33765 33765 33737 33837 34071 34071 37424 38447 40399 41450
Bad optimization of some operations with views containing subqueries
14
bugs core 5935 
 tracker
 CS 2022.02.02 14:46
2692 1675 1673 1673 1673 1657 1673 1657 1657 1658 1658 1648 1648 1648 1601 1601 1581 1647 1613 1647 1613 1613 1613 1686 1652 1686 1815 1914 1934 1972 1975
Bugcheck 165 (cannot find tip page)
15
bugs core 6048 
 tracker
 CS 2025.01.18 13:26
9443 5847 5559 5472 5431 5431 5404 5404 5404 5404 5422 5422 5260 5260 5303 5260 5246 5066 5066 5066 5066 4969 4957 4885 4885 4957 5315 6143 6143 6143 5607
Provide ability to see current state of DB encryption
16
bugs core 6049 
 tracker
 CS 2025.07.02 21:10
1232 690 669 669 668 644 638 644 639 639 636 627 627 627 621 643 658 658 658 658 656 653 653 653 658 659 671 701 742 742 738
Builtin functions converting binary string to hexadecimal representation and vice versa
17
bugs core 6147 
 tracker
 CS 2022.08.07 08:27
1350 857 857 857 872 912 912 912 882 882 882 882 872 872 849 848 848 797 848 810 827 810 827 819 827 835 879 905 974 975 983
PLG$SRP table, PLG$SRP_VIEW View instructions are strangely added in the metadata script extracted when Windows trusted authentication is enabled
18
bugs core 6542 
 tracker
 CS 2023.05.13 17:32
10739 6383 6216 6216 6210 6210 6210 6262 6262 6262 6262 6262 6071 6071 6071 6104 6104 6139 6104 5988 5988 6027 5988 6027 6259 6378 6378 7847 7912 8264 8264
More efficient implementation of SUBSTRING for UTF8 character set
19
bugs gh 4723 incompressible 
 tracker
 CS 2024.06.20 23:36
3468 2097 2097 2097 2098 2100 2156 2266 2321 2321 2342 2321 2317 2236 2183 2114 2002 1998 1998 1998 2057 2135 2135 2135 2135 2272 2350 2485 2561 2561 2561
Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs [CORE4401]
20
bugs gh 6120 
 tracker
 CS 2024.07.22 17:38
2650 1708 1708 1708 1776 1805 1805 1807 1807 1764 1764 1764 1725 1725 1725 1692 1670 1670 1670 1711 1760 1760 1760 1760 1760 1848 1870 1870 1915 1966 2012
Support auth_plugin_list dpb/spb item from application to client [CORE5860]
21
bugs gh 6872 
 tracker
 CS 2024.12.29 06:59
18657 10653 10653 10653 10809 10809 10809 10809 10809 11183 11289 11289 11289 10895 10895 10747 10747 10714 10818 10818 10898 10818 10892 11100 11100 11100 11444 13282 13800 14795 15637
Indexed STARTING WITH execution is very slow with UNICODE collation
22
bugs gh 6875 
 tracker
 CS 2023.05.21 20:53
6899 4253 4245 4142 4080 4080 4080 4080 4110 4266 4277 4297 4297 4334 4334 4308 4297 4213 4213 4308 4213 4208 4203 4177 4177 4203 4364 5740 5740 5946 6399
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
23
bugs gh 7038 
 tracker
 CS 2023.05.13 17:33
51618 28128 27607 27607 28128 28022 28149 28149 28022 28022 28008 27832 27588 27588 27523 27471 27471 27471 27588 27826 28273 27844 28369 27844 28853 29027 29244 37884 38345 38639 38639
Improve performance of STARTING WITH with insensitive collations
24
bugs gh 7046 
 tracker
 CS 2025.07.04 20:15
1444 915 914 913 913 878 878 878 871 871 871 904 874 874 855 874 855 855 855 871 851 871 871 881 900 918 977 1010 1010 1016 1067
Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
25
bugs gh 7090 
 tracker
 CS 2023.12.29 20:35
24133 13069 12866 12684 12684 12607 12666 12684 12666 12666 12772 12772 12538 12435 12435 12435 12510 12510 12510 12507 12444 12444 12507 12723 12881 13105 13190 15565 16973 17513 17513
Performance degradation with CURRENT_DATE, LOCALTIME and LOCALTIMESTAMP
26
bugs gh 7092 
 tracker
 CS 2024.08.22 13:09
14479 7924 7924 7854 7854 7853 7779 7745 7661 7661 7661 7859 7859 7859 7820 7820 7814 7814 7714 7814 7814 7954 7954 7954 8170 8170 8170 9932 9932 10886 10886
Improve performance of CURRENT_TIME
27
bugs gh 7093 
 tracker
 CS 2024.12.29 06:58
4383 2744 2744 2744 2772 2772 2772 2821 2770 2770 2843 2843 2735 2768 2735 2716 2735 2768 2685 2685 2718 2718 2685 2718 2731 2792 2894 3054 3493 3493 3535
Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
28
bugs gh 7093 
 tracker
 SS 2024.12.29 06:58
3764 2374 2374 2374 2405 2410 2471 2471 2471 2471 2450 2430 2405 2430 2358 2416 2416 2416 2364 2366 2366 2366 2436 2436 2436 2436 2502 2988 3041 3247 3247
Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
29
bugs gh 7759 
 tracker
 CS 2023.11.23 15:06
13859 7940 7780 7780 7787 7780 7787 7787 7780 7780 7780 7609 7780 7629 7629 7788 7830 7844 8047 8047 8047 7988 7798 7771 7798 7798 8317 10321 10963 11385 11385
Routine calling overhead increased by factor 6
30
bugs gh 7804 
 tracker
 SS 2025.07.05 20:10
1501 925 921 907 907 879 879 888 888 890 890 890 890 890 865 865 865 882 882 882 882 882 879 879 879 903 956 972 1032 1067 1067
The partial index is not involved when filtering conditions through OR.
31
bugs gh 7854 
 tracker
 CS 2023.11.22 22:35
6798 3765 3743 3743 3716 3765 3757 3938 3757 3757 3695 3685 3685 3635 3625 3625 3737 3728 3728 3768 3805 3731 3731 3783 3783 3783 4136 4249 4813 4813 5075
Performance issue with time zones
32
bugs gh 8115 
 tracker
 CS 2025.07.06 14:27
1240 770 770 770 794 824 849 866 852 852 849 823 823 823 823 819 831 819 819 819 805 784 805 805 826 937 937 937 944 985 968
Avoid reading/hashing the inner stream(s) if the leader stream is empty
33
bugs gh 8291 
 tracker
 CS 2025.02.25 09:33
4163 2621 2541 2541 2605 2605 2605 2666 2605 2598 2565 2565 2537 2519 2500 2499 2499 2519 2527 2527 2527 2619 2627 2627 2790 2841 2850 3212 3212 3348 3212
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
34
bugs gh 8462 
 tracker
 SS 2025.03.10 13:55
1692 1084 1084 1072 1084 1084 1104 1104 1116 1116 1116 1116 1093 1085 1085 1093 1093 1074 1137 1074 1036 1031 1036 1031 1031 1038 1085 1138 1232 1232 1232
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
35
functional arno optimizer opt inner join 03 
 CS 2025.07.16 15:54
1581 1011 1011 995 1011 1004 1004 995 968 961 961 968 978 978 978 976 976 919 919 987 1005 1013 1013 1025 1025 1053 1180 1180 1180 1250 1206
INNER JOIN join order
36
functional arno optimizer opt inner join 07 
 CS 2025.07.16 15:54
1484 897 897 897 958 1007 1007 1000 997 1000 997 997 965 965 965 965 965 958 958 958 1090 1090 1090 1090 1090 1099 1179 1241 1241 1262 1262
INNER JOIN join order and VIEW
37
functional arno optimizer opt left join 04 
 CS 2025.07.16 15:54
1151 735 735 735 759 760 784 798 784 784 806 810 757 789 789 772 772 772 772 798 804 804 817 804 889 890 921 948 962 970 970
LEFT OUTER JOIN with full match
38
functional arno optimizer opt left join 12 
 CS 2025.07.16 15:54
1234 789 789 769 728 728 801 749 801 801 749 749 749 749 741 731 731 731 731 789 821 789 821 863 867 867 888 935 970 1002 970
LEFT OUTER JOIN with distribution CASE
39
functional arno optimizer opt multi index selection 08 
 CS 2025.07.16 15:54
1241 795 790 766 766 790 766 809 824 824 764 795 795 761 735 730 730 730 730 811 834 860 862 862 882 912 933 973 1006 1006 994
Best match index selection (multi segment)
40
functional arno optimizer opt single index selection 03 
 CS 2025.07.16 15:54
1213 782 764 764 764 766 776 776 766 746 746 731 746 795 795 783 783 783 783 781 806 816 829 829 889 893 914 928 949 974 949
Best match index selection (single segment)
41
functional arno optimizer opt single index selection 05 
 CS 2025.07.16 15:54
1149 715 712 712 715 739 782 818 818 786 786 772 772 778 772 778 783 783 787 792 792 816 816 824 852 877 944 954 962 966 1007
Best match index selection (single segment) ASC and DESC
42
functional blob read blob in multiple cursors 
 CS 2025.04.02 13:42
1610 1017 1017 1017 1019 1019 1081 1019 1019 1020 1020 1007 1001 1018 1018 1001 1009 1009 1009 1009 1087 1087 1087 1009 1009 1009 1118 1149 1158 1178 1190
Ability to read same blob_id using multiple cursors
43
functional gtcs gtcs proc isql 08 
 CS 2022.02.04 18:05
1058 663 663 663 675 687 687 714 706 706 664 665 665 662 662 665 684 684 684 684 668 663 659 659 668 668 758 763 781 789 789
gtcs-proc-isql-08
44
functional intfunc math mod 01 
 CS 2022.02.04 18:05
989 630 630 630 636 644 644 644 640 640 640 640 654 666 666 637 651 633 633 633 636 636 657 657 668 680 714 714 714 710 710
MOD( <number>, <number> )
45
functional sqlite 3be1295b26 
 CS 2025.08.18 16:11
1005 646 646 646 646 657 707 X X X X X X X X X X X X X X X X X X X X X X X X
Inconsistent behavior of a partial unique index on a boolean expression.
46
functional sqlite b50528af44 
 CS 2025.08.22 17:46
1505 960 938 938 960 965 X X X X X X X X X X X X X X X X X X X X X X X X X
"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.
47
functional tabloid dbp 0951 multiple nested cte 
 CS 2022.02.04 18:05
3518 2206 2149 2149 2149 2149 2149 2163 2138 2135 2089 2084 2066 2066 2084 2085 2111 2131 2145 2166 2145 2145 2223 2131 2131 2258 2274 2466 2486 2660 2794
Query for test multiple CTEs
48
functional tabloid eqc 306263 
 SS 2022.05.26 09:00
2231 1417 1416 1382 1382 1349 1349 1382 1382 1333 1350 1335 1335 1336 1350 1336 1354 1354 1368 1354 1444 1365 1375 1375 1390 1390 1480 1547 1616 1665 1665
Check ability to run complex query
49
functional tabloid oltp emul 30 compiler check 
 CS 2022.02.04 18:05
5907 3767 3520 3520 3767 3579 3686 3849 3686 3587 3623 3587 3492 3492 3492 3405 3405 3405 3546 3564 3564 3500 3564 3564 3565 3807 3896 4109 4300 4300 4444
Compiler check. Test ability to compile source code of OLTP-EMUL test.
50
functional tabloid optimizer index navigation 
 CS 2025.07.12 12:53
2313 1455 1413 1413 1416 1454 1427 1454 1454 1429 1427 1418 1416 1416 1418 1463 1490 1490 1463 1434 1392 1392 1434 1463 1507 1567 1644 1644 1644 1685 1697
Check that optimizer takes in account presense of index and does navigation instead of external sort.

Elapsed time, milliseconds:

NN Test name mode
5.0.4.1722
2025.10.01
d92e2
5.0.4.1720
2025.09.30
a703b
5.0.4.1717
2025.09.29
79841
5.0.4.1715
2025.09.24
4aac5
5.0.4.1714
2025.09.15
3e313
5.0.4.1713
2025.09.13
6997f
5.0.4.1711
2025.09.09
cf241
5.0.4.1706
2025.09.07
ab04a
5.0.4.1704
2025.08.28
3fedd
5.0.4.1703
2025.08.20
bd5ab
5.0.4.1701
2025.08.07
27cb4
5.0.4.1697
2025.08.06
f63a8
5.0.4.1696
2025.08.04
c784c
5.0.3.1693
2025.07.30
8da78
5.0.3.1690
2025.07.28
19167
5.0.3.1689
2025.07.24
57f39
5.0.3.1686
2025.07.23
981c0
5.0.3.1684
2025.07.19
e451f
5.0.3.1683
2025.07.12
e98c3
5.0.3.1681
2025.07.11
5a438
5.0.3.1679
2025.07.09
88943
5.0.3.1676
2025.07.01
88ba7
5.0.3.1675
2025.06.27
1bb2c
5.0.3.1674
2025.06.26
d366d
5.0.3.1673
2025.06.25
f0e1f
5.0.3.1668
2025.06.21
b8e22
5.0.3.1667
2025.06.15
4374a
5.0.3.1666
2025.06.14
97178
5.0.3.1665
2025.06.11
d8b62
5.0.3.1661
2025.06.10
cfcf0
5.0.3.1660
2025.06.07
db691
5.0.3.1659
2025.05.28
f4c0f
5.0.3.1658
2025.05.27
e3aa4
5.0.3.1657
2025.05.22
a6c19
5.0.3.1656
2025.05.12
37a12
Test TITLE
1
bugs core 0733 
 tracker
 SS 68139 72449 74466 40707 41620 39552 39480 42090 43572 42430 40552 41244 43850 39522 39712 39680 38699 38621 39286 39544 41037 39265 40174 40538 40941 39790 40927 41555 43423 44735 46662 47108 48327 49186 49671
Compress Data over the Network
2
bugs core 2678 
 tracker
 SS 847 736 702 414 388 323 363 399 426 392 468 390 416 391 375 390 385 424 377 372 390 396 366 397 345 373 371 354 407 474 445 442 405 473 465
Full outer join cannot use available indices (very slow execution)
3
bugs core 2971 
 tracker
 CS 1252 1329 1314 804 720 803 817 790 782 769 742 716 774 728 806 781 758 735 723 770 833 782 804 701 725 804 743 778 760 955 928 831 949 981 862
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
4
bugs core 3238 
 tracker
 SS 1969 1973 2164 1236 1243 1181 1252 1210 1235 1301 1284 1254 1238 1220 1184 1299 1255 1199 1139 1194 1250 1177 1225 1246 1209 1190 1215 1256 1207 1495 1488 1432 1646 1510 1684
Makes GEN_UUID return a compliant RFC-4122 UUID
5
bugs core 3305 
 tracker
 SS 545 537 558 312 348 325 387 377 352 377 407 378 382 409 423 371 368 374 365 358 422 375 353 348 378 413 394 350 410 452 412 455 448 416 394
"BLOB not found" error after creation/altering of the invalid trigger
6
bugs core 3435 
 tracker
 SS 2011 2017 2161 1230 1219 1221 1531 1567 1518 1541 1397 1466 1518 1368 1386 1485 1240 1337 1176 1275 1456 1383 1448 1325 1261 1393 1434 1336 1461 1552 1638 1485 1754 1655 1706
Lateral derived tables
7
bugs core 4135 
 tracker
 CS 34040 33892 33517 20014 20108 19853 19922 18496 19273 19861 20218 20484 19706 20179 19174 20530 19947 19416 19092 19120 19394 18961 18503 18240 18135 17491 18528 18709 20063 20986 20770 20999 21813 19535 20774
In SS sweep blocks establishment of concurrent attachments
8
bugs core 4135 
 tracker
 SS 25844 26426 25862 15261 15909 15390 14660 14896 14863 15197 35422 15068 15368 14623 15283 14774 15400 14854 14407 14532 14551 38539 14188 14404 13839 13562 14088 13630 14974 16338 16678 15955 42523 35865 14958
In SS sweep blocks establishment of concurrent attachments
9
bugs core 4484 
 tracker
 CS 1052 1043 1076 641 658 610 641 715 701 700 658 648 685 669 692 698 682 709 678 655 683 617 665 704 663 659 647 691 722 789 790 774 772 818 812
Description (COMMENT ON) for package procedures and functions, and its parameters
10
bugs core 4488 
 tracker
 CS 1326 1302 1384 820 815 819 810 812 863 904 835 853 882 844 888 801 887 812 848 806 771 872 847 827 884 833 1035 856 877 998 1084 960 1039 1000 973
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
11
bugs core 4760 
 tracker
 CS 1950 2028 2013 1211 1252 1180 1275 1344 1302 1265 1232 1145 1372 1119 1256 1185 1105 1029 1173 1070 1306 1172 1100 1281 1192 1247 1204 1142 1298 1497 1454 1386 1499 1463 1425
Can not create user with non-ascii (multi-byte) characters in it's name
12
bugs core 4864 
 tracker
 SS 1053 1115 1065 676 662 676 631 650 700 720 651 676 694 673 698 589 627 671 630 633 677 607 590 657 634 699 641 634 683 787 779 792 751 721 715
CREATE DATABASE fail with ISQL
13
bugs core 5393 
 tracker
 SS 52667 50779 54669 32332 32766 31419 32336 32761 33231 33119 32540 32775 33994 32812 32344 32338 32030 32802 32231 32354 33744 33382 33765 32870 33837 34556 33737 33164 34071 38447 40399 37424 42598 41450 41665
Bad optimization of some operations with views containing subqueries
14
bugs core 5935 
 tracker
 CS 2711 2692 2797 1578 1675 1626 1673 2004 1631 1657 1712 1584 1740 1658 1648 1601 1489 1801 1541 1647 1581 1782 1613 1690 1611 1565 1815 1686 1652 1914 1972 1934 2097 2006 1975
Bugcheck 165 (cannot find tip page)
15
bugs core 6048 
 tracker
 CS 9593 9443 9938 5847 5347 5559 5472 5431 5264 5404 5345 5530 5461 5187 5422 5260 5246 5361 5303 4993 5066 4969 5263 5124 4885 4642 4957 4835 5315 6143 6198 6331 5441 5544 5607
Provide ability to see current state of DB encryption
16
bugs core 6049 
 tracker
 CS 1387 1232 1316 690 668 669 638 705 621 644 636 690 639 627 621 582 680 643 600 715 658 714 656 633 583 653 658 659 671 799 701 742 792 738 716
Builtin functions converting binary string to hexadecimal representation and vice versa
17
bugs core 6147 
 tracker
 CS 1350 1375 1581 829 831 857 872 912 959 943 762 882 780 922 914 872 849 797 848 777 901 766 849 810 827 769 835 819 879 975 974 905 1044 983 1077
PLG$SRP table, PLG$SRP_VIEW View instructions are strangely added in the metadata script extracted when Windows trusted authentication is enabled
18
bugs core 6542 
 tracker
 CS 11599 11501 10739 6383 6216 6075 6067 6375 6210 6262 6146 6262 6311 6572 6071 6003 5865 6139 6104 6917 5886 6156 5887 5988 6027 7257 5789 6378 6259 7847 8264 7912 8599 8715 8116
More efficient implementation of SUBSTRING for UTF8 character set
19
bugs gh 4723 incompressible 
 tracker
 CS 3594 3468 3499 2097 2054 2052 2098 2156 2100 2266 2405 2342 2321 2317 2401 2236 2114 2002 2183 1998 1938 1904 2292 2275 2057 2135 2077 2272 2485 2350 2722 2643 2561 2419 2546
Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs [CORE4401]
20
bugs gh 6120 
 tracker
 CS 2717 2833 2650 1703 1708 1629 1805 1776 1807 1914 1716 1817 1764 1578 1780 1692 1725 1756 1657 1629 1670 1787 1711 1780 1760 1755 1848 1594 1870 1915 2139 1859 1966 2012 2085
Support auth_plugin_list dpb/spb item from application to client [CORE5860]
21
bugs gh 6872 
 tracker
 CS 19307 18657 20277 10490 10653 10394 11141 11013 10809 10618 10773 11183 11309 11528 11289 10895 10747 10614 10944 10660 10898 10714 10818 11350 11302 10647 10892 11100 11444 13800 14795 13282 15637 15666 15841
Indexed STARTING WITH execution is very slow with UNICODE collation
22
bugs gh 6875 
 tracker
 CS 7550 6899 7824 4245 4253 4036 4142 4058 4080 4266 4064 4110 4297 4277 4334 4345 4297 4407 4201 4308 4213 4208 4343 4363 4111 4203 4153 4177 4364 5946 6399 5740 4943 7083 6673
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
23
bugs gh 7038 
 tracker
 CS 54732 51618 54272 27308 28128 27283 27607 29062 28149 28022 28477 28008 27280 28429 27832 27523 27588 27471 27041 27371 28273 27588 28369 27826 28853 27844 29244 27647 29027 39292 42198 37884 38345 38639 41066
Improve performance of STARTING WITH with insensitive collations
24
bugs gh 7046 
 tracker
 CS 1444 1490 1450 914 915 811 913 913 878 869 870 904 871 972 831 909 874 836 855 903 851 882 822 871 827 918 881 900 977 1016 1067 1010 978 1070 1088
Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
25
bugs gh 7090 
 tracker
 CS 24133 26149 24905 12866 13069 12327 12607 12684 12815 12169 12666 12772 12538 13103 12772 12435 12340 12350 13351 12510 12624 12344 12316 12507 12444 12723 13105 12881 13190 17600 15565 17513 16973 20378 18194
Performance degradation with CURRENT_DATE, LOCALTIME and LOCALTIMESTAMP
26
bugs gh 7092 
 tracker
 CS 14898 14479 17858 7651 7924 7853 8019 7854 7745 7779 7661 7568 7574 7895 7859 8035 7739 7820 7528 7996 7814 7579 7714 7954 8490 8761 7825 7952 8170 10917 9932 10886 9486 11850 11457
Improve performance of CURRENT_TIME
27
bugs gh 7093 
 tracker
 CS 4476 4383 5822 2744 2645 2703 2772 2821 2902 2706 2770 2843 2711 2890 3001 2716 2735 2768 2621 2652 2811 3337 2685 2680 2718 2731 2680 2792 2894 3054 3535 3493 3624 3398 3764
Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
28
bugs gh 7093 
 tracker
 SS 3764 3837 4571 2374 2358 2360 2410 2405 2525 2471 2559 2450 2405 2478 2358 2430 2345 2452 2278 2416 2493 2359 2364 2366 2465 2436 2502 2434 2425 3041 3247 2988 3421 3375 2971
Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
29
bugs gh 7759 
 tracker
 CS 15072 13859 14994 7719 7940 7780 7538 7787 8059 7744 8271 7609 7780 8094 7412 7562 7788 7629 7844 7830 8047 8060 8234 7557 7988 7798 7644 7771 8317 10321 11771 11385 10963 12091 10978
Routine calling overhead increased by factor 6
30
bugs gh 7804 
 tracker
 SS 1560 1501 1564 867 925 921 807 907 837 879 897 888 891 890 807 949 865 895 864 786 969 882 957 850 829 903 879 956 870 972 1068 1032 1181 1067 1022
The partial index is not involved when filtering conditions through OR.
31
bugs gh 7854 
 tracker
 CS 7226 6798 7086 3743 3716 3765 3689 3938 3663 4062 3757 3978 3695 3635 3685 3574 3737 3625 3613 3768 3994 3728 3720 4145 3805 3731 3651 3783 4136 4249 4813 4813 5075 5379 5872
Performance issue with time zones
32
bugs gh 8115 
 tracker
 CS 1330 1246 1240 770 726 747 794 885 824 934 849 866 852 735 823 786 898 831 810 819 837 784 821 782 805 781 944 826 937 1016 909 944 985 1013 968
Avoid reading/hashing the inner stream(s) if the leader stream is empty
33
bugs gh 8291 
 tracker
 CS 4172 4163 4292 2541 2621 2499 2472 2737 2605 2728 2547 2666 2598 2537 2565 2500 2418 2519 2499 2499 2527 2527 2634 2499 2619 2627 2790 2850 2841 3396 3212 3348 3043 3548 3099
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
34
bugs gh 8462 
 tracker
 SS 1759 1694 1692 1072 1053 1084 1120 1050 1129 949 1104 1116 1143 1131 1060 1085 1093 1049 1137 1167 1074 1014 1208 1036 970 1031 1038 1018 1085 1138 1264 1242 1232 1167 1150
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
35
functional arno optimizer opt inner join 03 
 CS 1590 1581 1604 969 1011 992 1073 995 1066 1004 953 968 893 961 1013 978 983 976 887 919 987 885 1013 1171 1005 1053 994 1025 1180 1252 1250 1149 1180 1276 1206
INNER JOIN join order
36
functional arno optimizer opt inner join 07 
 CS 1551 1488 1484 816 842 897 1007 1035 958 1062 942 1000 997 1032 905 909 965 1023 977 897 958 929 1130 1125 1090 1064 1040 1099 1179 1241 1323 1262 1201 1342 1240
INNER JOIN join order and VIEW
37
functional arno optimizer opt left join 04 
 CS 1168 1173 1151 735 691 721 759 798 760 784 806 810 729 755 870 810 757 789 702 772 834 739 817 798 804 889 890 781 921 1061 948 962 992 970 1054
LEFT OUTER JOIN with full match
38
functional arno optimizer opt left join 12 
 CS 1255 1234 1320 789 769 696 887 728 725 801 848 749 840 749 741 826 704 758 680 731 845 672 789 821 879 774 863 867 935 1002 888 1022 970 1020 959
LEFT OUTER JOIN with distribution CASE
39
functional arno optimizer opt multi index selection 08 
 CS 1251 1241 1377 795 679 790 758 766 809 879 764 848 824 761 735 795 818 722 730 730 700 860 904 811 834 862 912 882 933 1006 1047 973 1053 991 994
Best match index selection (multi segment)
40
functional arno optimizer opt single index selection 03 
 CS 1215 1219 1213 782 737 764 740 832 766 892 776 690 746 731 806 721 824 795 783 761 756 816 872 781 806 889 829 893 914 996 949 928 1019 974 944
Best match index selection (single segment)
41
functional arno optimizer opt single index selection 05 
 CS 1204 1149 1226 712 676 715 687 782 818 739 873 880 741 786 716 772 778 783 744 794 787 692 792 824 816 852 791 877 944 966 962 954 1093 1018 1007
Best match index selection (single segment) ASC and DESC
42
functional blob read blob in multiple cursors 
 CS 1705 1610 1633 995 950 1017 1088 1019 1019 1093 1081 1007 946 1020 1078 1001 921 1018 1170 935 1009 968 1139 1087 1105 1009 966 957 1118 1178 1158 1149 1190 1322 1325
Ability to read same blob_id using multiple cursors
43
functional gtcs gtcs proc isql 08 
 CS 1093 1089 1058 635 601 663 687 714 675 740 664 726 706 632 662 665 698 652 662 694 684 685 663 659 668 659 657 668 758 763 817 781 855 789 789
gtcs-proc-isql-08
44
functional intfunc math mod 01 
 CS 989 1006 1025 610 630 602 636 693 644 662 620 640 596 654 670 637 671 666 596 633 651 609 636 610 657 680 668 632 714 763 714 695 710 710 738
MOD( <number>, <number> )
45
functional sqlite 3be1295b26 
 CS 1015 1005 1007 584 646 579 657 753 631 724 707 X X X X X X X X X X X X X X X X X X X X X X X X
Inconsistent behavior of a partial unique index on a boolean expression.
46
functional sqlite b50528af44 
 CS 1535 1557 1505 930 960 938 938 999 972 965 X X X X X X X X X X X X X X X X X X X X X X X X X
"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.
47
functional tabloid dbp 0951 multiple nested cte 
 CS 3589 3518 3526 2084 2206 2060 2149 2163 2138 2176 2089 2178 2135 2014 2019 2084 2066 2111 2085 2166 2131 2145 2259 2223 2088 2019 2258 2131 2274 2466 2794 2660 2486 3065 2879
Query for test multiple CTEs
48
functional tabloid eqc 306263 
 SS 2368 2270 2231 1417 1382 1416 1288 1349 1470 1325 1382 1382 1319 1333 1350 1335 1336 1354 1368 1324 1444 1281 1457 1354 1451 1365 1375 1390 1480 1866 1547 1616 1665 1712 1765
Check ability to run complex query
49
functional tabloid oltp emul 30 compiler check 
 CS 5916 5907 6263 3520 3767 3478 3263 3849 3978 3579 3686 4020 3455 3587 3623 3492 3403 3369 3546 3405 3715 3347 3622 3564 3500 3472 3565 3807 4443 3896 4109 4444 4300 4506 4537
Compiler check. Test ability to compile source code of OLTP-EMUL test.
50
functional tabloid optimizer index navigation 
 CS 2313 2409 2399 1413 1396 1455 1354 1416 1454 1551 1427 1501 1429 1368 1416 1418 1396 1490 1463 1498 1591 1361 1434 1365 1392 1507 1463 1729 1644 1567 1685 1613 1697 1721 1755
Check that optimizer takes in account presense of index and does navigation instead of external sort.

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-2678
http://tracker.firebirdsql.org/browse/CORE-2971
http://tracker.firebirdsql.org/browse/CORE-3238
http://tracker.firebirdsql.org/browse/CORE-3305
http://tracker.firebirdsql.org/browse/CORE-3435
http://tracker.firebirdsql.org/browse/CORE-4135
http://tracker.firebirdsql.org/browse/CORE-4484
http://tracker.firebirdsql.org/browse/CORE-4488
http://tracker.firebirdsql.org/browse/CORE-4760
http://tracker.firebirdsql.org/browse/CORE-4864
http://tracker.firebirdsql.org/browse/CORE-5393
http://tracker.firebirdsql.org/browse/CORE-5935
http://tracker.firebirdsql.org/browse/CORE-6048
http://tracker.firebirdsql.org/browse/CORE-6049
http://tracker.firebirdsql.org/browse/CORE-6147
http://tracker.firebirdsql.org/browse/CORE-6542
http://tracker.firebirdsql.org/browse/CORE-733
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_left_join_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_left_join_12.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_multi_index_selection_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_single_index_selection_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_single_index_selection_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/blob/test_read_blob_in_multiple_cursors.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_isql_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_mod_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_3be1295b26.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b50528af44.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_dbp_0951_multiple_nested_cte.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_eqc_306263.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_oltp_emul_30_compiler_check.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_optimizer_index_navigation.py
https://github.com/FirebirdSQL/firebird/issues/4723
https://github.com/FirebirdSQL/firebird/issues/6120
https://github.com/FirebirdSQL/firebird/issues/6872
https://github.com/FirebirdSQL/firebird/issues/6875
https://github.com/FirebirdSQL/firebird/issues/7038
https://github.com/FirebirdSQL/firebird/issues/7046
https://github.com/FirebirdSQL/firebird/issues/7090
https://github.com/FirebirdSQL/firebird/issues/7092
https://github.com/FirebirdSQL/firebird/issues/7093
https://github.com/FirebirdSQL/firebird/issues/7759
https://github.com/FirebirdSQL/firebird/issues/7804
https://github.com/FirebirdSQL/firebird/issues/7854
https://github.com/FirebirdSQL/firebird/issues/8115
https://github.com/FirebirdSQL/firebird/issues/8291
https://github.com/FirebirdSQL/firebird/issues/8462
=== end of list ===

Last commits information (all timestamps in UTC):