01. Total results for each kind of outcome and server mode, for previous 30 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 (2 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 (3 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 (50 rows)
07. Has fails: tests with at least one fail for previous 30 runs (53 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (2 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (2 rows)
11. All tests: outcomes for previous 30 runs (2620 rows)
12. Skipped: tests which was intentionally excluded from execution (73 rows)

Generated UTC 18.01.2025 00:44
Tested: FB60.   Build / date: 6.0.0.585-2d6bb146 / 2025.01.16;
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: 1.10.6; firebird.Qa: 0.19.3 
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.33x. 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
6.0.0.585
2025.01.16
2d6bb
6.0.0.584
2025.01.15
a0aa2
6.0.0.581
2025.01.14
21e9e
6.0.0.577
2025.01.13
7e293
6.0.0.576
2025.01.12
05898
6.0.0.573
2025.01.10
c20f3
6.0.0.571
2024.12.31
81bba
6.0.0.570
2024.12.30
c3c8d
6.0.0.565
2024.12.28
5fc59
6.0.0.564
2024.12.26
12514
6.0.0.560
2024.12.25
fa83e
6.0.0.559
2024.12.23
cc800
6.0.0.556
2024.12.22
a0404
6.0.0.555
2024.12.19
6990a
6.0.0.553
2024.12.17
d1f8a
6.0.0.552
2024.12.11
85e25
6.0.0.550
2024.12.10
b37ac
6.0.0.548
2024.12.08
2cc77
6.0.0.544
2024.12.05
96943
6.0.0.543
2024.12.03
30b77
6.0.0.540
2024.12.02
4a1f4
6.0.0.539
2024.11.28
1f283
6.0.0.535
2024.11.26
77b95
6.0.0.534
2024.11.25
e9584
6.0.0.533
2024.11.17
933ac
6.0.0.532
2024.11.16
9e263
Test TITLE
1
bugs core 4075 
 tracker
 CS 2022.02.02 14:46
962 655 655 654 545 545 545 829 829 829 589 574 574 589 713 713 854 854 854 854 854 545 928 928 943 943
Server bugchecks or crashes on exception in calculated index
2
bugs core 4084 
 tracker
 CS 2022.02.02 14:46
1317 776 776 776 699 699 699 892 892 892 820 700 700 676 676 740 930 740 1029 1053 1053 728 1053 1098 1098 1098
Regression: Group by fails if subselect-column is involved
3
bugs core 4091 
 tracker
 CS 2022.02.02 14:46
1059 640 640 640 534 534 534 701 701 701 576 552 552 531 531 590 741 590 741 804 804 621 804 804 935 979
Incorrect full join result with ROW_NUMBER() Function in CTE
4
bugs core 4203 
 tracker
 CS 2023.10.09 08:55
980 652 627 627 627 530 530 916 916 916 916 848 848 830 848 830 888 888 930 935 935 1005 935 959 918 947
Cannot create packaged routines with [VAR]CHAR parameters
5
bugs core 4210 
 tracker
 CS 2022.02.02 14:46
1172 767 747 767 725 725 1035 1059 1062 1062 1059 976 976 687 976 976 1121 1121 1128 1164 1164 1128 1121 1121 1121 1121
Preserve comments for output parameters after altering procedures
6
bugs core 4236 
 tracker
 CS 2022.09.13 20:25
1057 X 646 646 599 599 599 929 929 974 974 974 X 974 974 942 942 X 942 X 890 723 888 888 888 X
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
7
bugs core 4247 
 tracker
 CS 2022.02.02 14:46
1305 815 815 815 725 725 725 1201 1201 1201 1188 1182 1151 993 1151 1151 1164 1164 1208 1208 1196 1037 1144 1144 1144 1144
Delete "where current of" cursor fails for tables with newly added fields
8
bugs core 4299 
 tracker
 CS 2022.02.02 14:46
2492 1515 1515 2177 2177 1992 1992 1992 1892 1892 1892 1896 1896 1896 2141 2141 2253 2141 2141 2253 2107 1258 2107 2159 1248 2159
Inappropriate self-reference of column when using "with check option" with extract(...)
9
bugs core 4301 
 tracker
 CS 2024.10.31 10:17
1652 1029 1029 1448 1448 1269 1269 1269 1210 1210 1210 1210 1210 870 1501 1536 1536 1535 1535 1528 1390 1228 1390 1414 1228 1414
Non-ASCII data in SEC$USERS is not read correctly
10
bugs core 5447 
 tracker
 CS 2022.02.02 14:46
1055 667 619 619 595 595 900 957 965 965 957 933 933 893 933 893 925 893 925 925 925 828 956 563 563 537
EXECUTE STATEMENT <e> when <e> starts with '--' issues -Unexpected ... column <NNN>, value <NNN> is invalid and can change randomly
11
bugs core 5538 
 tracker
 CS 2022.02.02 14:46
1263 720 720 1106 720 1028 1106 1087 1028 1028 1087 701 701 1078 1078 1078 1078 1077 1077 1040 1037 1037 1026 1023 1026 1053
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
12
bugs core 5542 db attach 
 tracker
 CS 2022.02.02 14:46
1262 804 804 1092 804 757 1092 1092 637 625 1100 625 625 1071 1134 1134 1136 1136 1134 1125 1100 1100 1100 633 633 1106
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
13
bugs core 5542 db detach 
 tracker
 CS 2022.02.02 14:46
1228 778 778 1108 778 713 1041 1041 633 645 1041 810 810 1129 1129 1107 1129 1129 1107 1107 989 989 989 638 638 1039
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
14
bugs gh 6808 
 tracker
 CS 2022.02.02 14:46
1071 737 737 714 664 714 776 897 1002 1002 1002 564 564 564 924 927 927 927 927 927 609 916 1003 959 959 990
Segfault in encrypt/decrypt functions when their first argument is NULL
15
bugs gh 7178 
 tracker
 CS 2023.02.21 09:54
1042 703 703 607 588 588 545 534 545 534 534 533 533 522 511 511 519 522 549 927 927 927 940 954 954 954
DEFAULTed grants to PUBLIC must act as DEFAULTed to every user
16
bugs gh 7222 
 tracker
 CS 2023.02.24 07:52
1950 1341 1116 1116 1045 1038 1007 1038 1038 1065 1073 1073 1065 1065 1013 1013 1374 1733 1733 1733 1733 1773 1823 1850 1883 1883
Dependencies of packaged functions are not tracked
17
bugs gh 7227 
 tracker
 CS 2024.03.23 18:25
1088 751 702 702 564 551 540 546 520 520 532 543 533 543 533 543 944 984 984 998 984 984 946 942 942 946
Dependencies of subroutines are not preserved after backup restore
18
bugs gh 7237 
 tracker
 CS 2023.02.22 19:21
1316 864 844 844 672 668 640 640 631 631 634 666 634 666 634 666 1226 1248 1248 1248 1192 1192 1192 1213 1268 1268
Starting operator become unstable on indexed varchar fields
19
bugs gh 7239 
 tracker
 CS 2023.02.22 21:14
1111 673 651 588 536 535 525 535 535 535 531 531 530 530 518 530 930 930 965 965 908 908 964 964 975 975
Connect using XNET protocol shows different exception if DB is in shutdown state (comparing to INET)
20
bugs gh 7243 
 tracker
 CS 2023.02.22 19:10
1081 741 721 656 610 568 558 568 568 655 655 655 583 583 546 583 721 1024 1036 1044 1036 1036 975 975 975 978
Some UNICODE characters can lead to wrong CONTAINING evaluation when lower/upper uses different number of bytes in its encoding
21
bugs gh 8100 
 tracker
 CS 2024.05.11 08:51
3733 2520 2505 2505 2348 2257 2257 2665 2257 2011 2665 2054 2054 2115 2115 2054 1978 1978 1960 1960 1940 1940 1913 1930 1940 2640
The isc_array_lookup_bounds function returns invalid values for low and high array bounds
22
bugs gh 8104 
 tracker
 CS 2024.05.09 10:02
1070 668 606 606 541 537 541 541 519 519 570 544 570 570 547 544 547 547 547 536 532 532 532 532 566 991
Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete
23
bugs gh 8108 
 tracker
 CS 2024.05.15 14:41
1187 770 715 715 667 632 632 632 587 587 609 587 609 609 605 605 636 636 636 636 593 593 593 594 660 739
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
24
bugs gh 8113 
 tracker
 CS 2024.11.18 13:42
1266 866 829 829 802 715 695 684 673 684 695 695 926 926 926 757 750 703 699 699 699 X X X X X
UNION ALL optimization with constant false condition
25
bugs gh 8120 
 tracker
 CS 2024.05.27 09:46
1116 744 717 717 641 581 581 581 560 560 571 571 1093 1093 1093 551 551 551 552 552 556 580 556 556 589 958
Cast dies with numeric value is out of range error
26
functional arno derived tables 07 
 CS 2022.02.04 18:05
1214 848 848 827 693 693 655 693 712 712 679 679 657 646 646 657 664 664 667 664 664 672 679 672 672 653
Outer reference inside derived table to other relations in from clause is not allowed
27
functional arno derived tables 27 
 CS 2023.03.09 07:23
1335 869 869 860 791 869 1114 699 699 699 688 683 683 683 683 785 923 786 786 785 741 741 673 673 664 651
Derived table with same alias for several columns
28
functional arno indices lower bound asc 02 segments 01 
 CS 2022.02.04 18:05
1416 961 961 762 762 813 1177 813 813 660 647 647 660 668 762 762 1089 1089 1089 679 684 684 679 684 684 670
ASC 2-segment index lower bound
29
functional arno indices timestamps 01 
 CS 2022.02.04 18:05
1349 914 914 744 732 744 690 671 671 666 657 666 655 666 707 717 1048 1056 1048 717 726 726 657 685 689 685
TIMESTAMP in index with values below julian date
30
functional arno indices upper bound asc 01 segments 01 
 CS 2022.02.04 18:05
1300 900 900 796 783 783 741 688 648 648 648 649 658 668 668 695 1140 1192 1140 695 689 689 651 651 683 654
ASC single segment index upper bound
31
functional arno indices upper bound asc 01 segments 02 
 CS 2022.02.04 18:05
1272 872 872 842 740 740 706 706 706 669 669 669 669 699 714 699 1152 1152 1148 687 718 718 659 685 708 685
ASC single segment index upper bound
32
functional arno optimizer opt aggregate distribution 05 
 CS 2022.02.04 18:05
1300 885 828 808 698 698 687 698 687 682 682 682 669 682 694 706 1141 1141 1089 778 778 778 762 778 742 763
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
33
functional arno optimizer opt aggregate distribution 07 
 CS 2022.02.04 18:05
1273 836 768 760 693 693 693 693 693 704 704 704 709 710 730 709 1116 1177 1116 714 739 739 714 739 739 670
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
34
functional arno optimizer opt aggregate distribution 08 
 CS 2022.02.04 18:05
1350 842 770 746 692 692 684 684 674 684 684 684 684 771 1180 771 984 1180 984 720 720 720 693 720 693 691
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
35
functional arno optimizer opt aggregate distribution 09 
 CS 2022.02.04 18:05
1307 831 802 802 708 708 689 708 708 665 665 665 665 665 1217 665 1102 1217 1102 694 699 699 694 699 699 688
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
36
functional arno optimizer opt inner join 05 
 CS 2024.10.31 12:48
1312 911 747 726 686 686 686 686 686 696 696 674 672 696 988 713 1118 1118 983 954 954 954 954 954 824 824
INNER JOIN join order LIKE and STARTING WITH
37
functional arno optimizer opt inner join 10 
 CS 2022.02.04 18:05
1268 846 842 745 736 736 667 675 675 675 675 675 713 725 1192 725 725 671 671 671 672 935 935 935 727 727
INNER JOIN join order
38
functional arno optimizer opt left join 04 
 CS 2022.02.04 18:05
1341 928 788 775 775 775 858 858 858 682 682 682 689 689 743 743 743 753 753 753 741 1023 741 1128 757 757
LEFT OUTER JOIN with full match
39
functional arno optimizer opt left join 05 
 CS 2022.02.04 18:05
1128 697 618 613 583 583 583 583 583 562 562 542 542 542 542 541 528 541 528 528 543 1011 543 633 597 597
LEFT OUTER JOIN with full match, but limited in ON clause
40
functional arno optimizer opt left join 08 
 CS 2022.02.04 18:05
1360 947 779 738 723 723 723 1088 1088 1088 1088 691 664 664 653 653 653 657 657 664 750 1135 750 750 750 675
LEFT OUTER JOIN with full match, but limited in ON and WHERE clause
41
functional arno optimizer opt left join 09 
 CS 2022.02.04 18:05
1309 828 757 748 722 722 722 1106 1106 1106 1237 683 683 683 672 672 685 686 686 710 710 953 695 697 697 702
LEFT OUTER JOIN with full match, but limited in ON and WHERE clause
42
functional arno optimizer opt multi index selection 04 
 CS 2022.02.10 09:12
1329 887 808 731 729 729 729 1168 1168 1168 1168 1013 700 700 718 718 735 810 810 735 727 727 712 692 727 693
Best match index selection (multi segment)
43
functional arno optimizer opt sort by index 16 
 CS 2022.02.04 18:05
1241 867 867 867 742 703 703 703 703 684 1164 1164 1164 759 1164 759 676 676 664 664 664 708 713 713 713 695
ORDER BY DESC NULLS FIRST using index
44
functional datatypes decfloat ordering rules 
 CS 2023.03.10 07:47
1009 664 661 664 661 599 599 599 566 552 566 545 545 542 524 524 522 524 543 551 578 893 893 893 893 893
Test ordering of decfloat values
45
functional procedure create 07 
 CS 2022.02.04 18:05
1012 621 621 577 525 520 514 514 520 520 524 880 579 579 579 580 579 580 513 513 513 538 538 538 538 907
CREATE PROCEDURE - try create SP with same name
46
functional tabloid gtcs proc isql 14 
 SS 2022.02.04 18:05
507 338 507 507 481 459 459 413 413 413 413 500 500 480 504 508 480 501 501 348 302 302 302 312 480 480
gtcs-proc-isql-14
47
functional tabloid join transformation 001 
 SS 2023.11.25 21:39
1106 731 1106 1143 1106 996 1143 1150 1126 1126 1299 1191 1191 1191 1272 1191 868 868 868 678 678 804 804 804 976 976
Check ability of outer join simplification.
48
functional tabloid join transformation 003 
 SS 2023.11.25 21:42
1124 730 1124 1130 1130 934 1130 1204 1039 1039 1039 1039 926 862 862 862 855 855 855 689 689 725 725 725 827 827
Check ability of outer join simplification.
49
functional tabloid join transformation 005 
 SS 2023.11.25 21:42
1429 764 1261 1261 836 836 965 965 965 965 872 872 872 872 1121 1121 896 896 896 726 726 732 726 629 732 629
Check ability of outer join simplification.
50
functional tabloid join transformation 007 
 SS 2023.11.25 21:42
1732 1180 1180 1371 1180 1371 1371 1373 1373 1373 1377 1424 1423 1423 1423 1423 1399 1399 1399 922 857 857 857 857 1213 1213
Check ability of outer join simplification.

Elapsed time, milliseconds:

NN Test name mode
6.0.0.585
2025.01.16
2d6bb
6.0.0.584
2025.01.15
a0aa2
6.0.0.581
2025.01.14
21e9e
6.0.0.577
2025.01.13
7e293
6.0.0.576
2025.01.12
05898
6.0.0.573
2025.01.10
c20f3
6.0.0.571
2024.12.31
81bba
6.0.0.570
2024.12.30
c3c8d
6.0.0.565
2024.12.28
5fc59
6.0.0.564
2024.12.26
12514
6.0.0.560
2024.12.25
fa83e
6.0.0.559
2024.12.23
cc800
6.0.0.556
2024.12.22
a0404
6.0.0.555
2024.12.19
6990a
6.0.0.553
2024.12.17
d1f8a
6.0.0.552
2024.12.11
85e25
6.0.0.550
2024.12.10
b37ac
6.0.0.548
2024.12.08
2cc77
6.0.0.544
2024.12.05
96943
6.0.0.543
2024.12.03
30b77
6.0.0.540
2024.12.02
4a1f4
6.0.0.539
2024.11.28
1f283
6.0.0.535
2024.11.26
77b95
6.0.0.534
2024.11.25
e9584
6.0.0.533
2024.11.17
933ac
6.0.0.532
2024.11.16
9e263
6.0.0.530
2024.11.15
49804
6.0.0.528
2024.11.14
9625b
6.0.0.526
2024.11.12
65b80
6.0.0.523
2024.11.08
8ca23
Test TITLE
1
bugs core 4075 
 tracker
 CS 962 597 1104 655 1077 654 517 525 545 829 915 847 574 533 589 523 713 864 981 567 854 513 970 928 545 510 1015 943 1048 932
Server bugchecks or crashes on exception in calculated index
2
bugs core 4084 
 tracker
 CS 1468 737 734 1333 1317 776 615 651 699 975 1192 892 820 700 676 602 930 628 1029 740 1113 724 1053 1260 728 674 1250 1098 1119 1074
Regression: Group by fails if subselect-column is involved
3
bugs core 4091 
 tracker
 CS 1059 581 592 1148 1121 640 506 507 534 813 892 701 552 576 531 497 1010 500 741 590 1016 513 944 804 535 621 935 999 1004 979
Incorrect full join result with ROW_NUMBER() Function in CTE
4
bugs core 4203 
 tracker
 CS 980 1131 1228 553 627 652 493 967 530 511 916 929 949 565 848 830 1003 516 930 507 888 1019 935 1037 555 1005 918 959 914 947
Cannot create packaged routines with [VAR]CHAR parameters
5
bugs core 4210 
 tracker
 CS 1172 1310 747 1361 767 725 604 1035 612 1062 1168 1059 1095 635 596 976 1152 687 1121 589 1185 1128 1164 1168 656 1043 1121 1151 1197 1064
Preserve comments for output parameters after altering procedures
6
bugs core 4236 
 tracker
 CS 1057 X 609 1141 1096 646 599 533 558 929 975 987 X 536 974 768 989 X 1102 X 942 510 890 1018 530 723 888 1028 966 X
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
7
bugs core 4247 
 tracker
 CS 1305 803 805 1354 1309 815 659 725 679 1255 1201 1335 1182 667 1188 993 1151 638 1164 1236 1277 664 1208 1196 696 1037 1144 1236 1232 1136
Delete "where current of" cursor fails for tables with newly added fields
8
bugs core 4299 
 tracker
 CS 2492 2648 1515 1502 2579 1443 2223 2177 1290 1992 1892 2292 1689 1213 2281 1896 2418 1284 2141 2356 2253 1258 2107 2337 1151 1248 2159 2184 1221 2172
Inappropriate self-reference of column when using "with check option" with extract(...)
9
bugs core 4301 
 tracker
 CS 1652 1713 1008 1029 1820 954 1448 1481 883 1269 1091 1489 1210 870 1501 839 1588 837 1555 1536 1535 831 1390 1528 872 1228 1414 1524 797 1454
Non-ASCII data in SEC$USERS is not read correctly
10
bugs core 5447 
 tracker
 CS 1083 1178 667 1055 619 595 536 900 523 965 995 957 967 536 933 572 1035 893 1028 744 925 828 982 956 563 529 965 537 1045 484
EXECUTE STATEMENT <e> when <e> starts with '--' issues -Unexpected ... column <NNN>, value <NNN> is invalid and can change randomly
11
bugs core 5538 
 tracker
 CS 1270 1283 712 1263 719 720 1109 1106 643 1028 1131 1087 701 647 1144 678 1138 1078 1077 1225 1040 1037 1178 1023 657 1101 1026 619 1053 1123
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
12
bugs core 5542 db attach 
 tracker
 CS 1262 1388 747 1288 804 757 1231 1092 637 588 1229 1100 570 625 1169 593 1071 1213 1134 1136 1185 1125 1100 577 616 1133 1106 633 598 1159
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
13
bugs core 5542 db detach 
 tracker
 CS 1285 1247 696 1228 778 713 1127 1108 633 576 1041 1165 565 645 1220 810 1159 1129 1085 1107 1250 1163 989 565 638 1039 1268 589 609 1082
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
14
bugs gh 6808 
 tracker
 CS 1071 1232 1105 737 664 655 776 714 554 897 1002 1008 1050 564 522 562 924 954 1019 927 573 524 1003 1079 609 916 1009 959 1020 990
Segfault in encrypt/decrypt functions when their first argument is NULL
15
bugs gh 7178 
 tracker
 CS 1151 1042 1140 703 607 588 946 509 545 988 534 484 1020 534 533 511 491 522 488 519 972 549 927 1188 594 940 954 995 1002 945
DEFAULTed grants to PUBLIC must act as DEFAULTed to every user
16
bugs gh 7222 
 tracker
 CS 2179 1950 1109 1341 2275 1116 1007 1045 1038 948 963 1145 1102 1065 1073 1013 981 1770 935 1374 1733 1773 1823 1716 1071 1889 1850 1883 2087 1845
Dependencies of packaged functions are not tracked
17
bugs gh 7227 
 tracker
 CS 1251 1088 603 751 1288 702 540 551 564 504 520 546 509 558 532 543 533 1043 518 1103 944 984 998 1032 589 942 946 926 968 987
Dependencies of subroutines are not preserved after backup restore
18
bugs gh 7237 
 tracker
 CS 1486 1316 758 844 1744 864 668 640 672 620 631 738 612 680 634 666 626 1226 630 1348 1259 1248 1192 1113 701 1213 1295 1336 1268 1232
Starting operator become unstable on indexed varchar fields
19
bugs gh 7239 
 tracker
 CS 1128 1111 651 673 1492 588 504 536 519 535 525 627 560 531 498 518 530 930 497 995 965 873 1007 908 597 1024 964 975 1011 954
Connect using XNET protocol shows different exception if DB is in shutdown state (comparing to INET)
20
bugs gh 7243 
 tracker
 CS 1220 1081 721 741 1541 610 553 656 558 568 547 660 669 655 541 583 546 721 513 1053 1024 1036 1044 1102 570 975 916 1048 1079 978
Some UNICODE characters can lead to wrong CONTAINING evaluation when lower/upper uses different number of bytes in its encoding
21
bugs gh 8100 
 tracker
 CS 3805 3986 3733 2520 2505 2348 2120 3024 2257 1912 3296 2665 1943 2011 3617 2054 3080 2115 1884 1960 1978 2164 1913 1911 1940 2640 1892 1930 2992 2902
The isc_array_lookup_bounds function returns invalid values for low and high array bounds
22
bugs gh 8104 
 tracker
 CS 1070 1080 1113 668 606 537 518 952 541 517 974 507 519 570 956 544 958 500 547 536 563 604 524 532 516 1020 566 528 991 1008
Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete
23
bugs gh 8108 
 tracker
 CS 1187 1264 1259 770 715 667 630 1107 632 582 1062 587 567 609 1162 575 1115 549 605 636 728 637 593 573 574 1077 660 594 739 1049
Engine returns empty string when unable to translate Unicode symbol into ICU-codepage.
24
bugs gh 8113 
 tracker
 CS 1266 1343 1512 866 802 829 715 1172 673 669 695 684 638 695 1236 926 1111 757 662 750 703 699 676 636 717 X X X X X
UNION ALL optimization with constant false condition
25
bugs gh 8120 
 tracker
 CS 1139 1116 1269 744 717 641 553 1115 581 549 1034 560 535 571 1131 1096 1093 508 516 551 552 580 556 508 589 1124 537 556 1036 958
Cast dies with numeric value is out of range error
26
functional arno derived tables 07 
 CS 1214 700 1340 848 1341 827 650 636 693 929 655 1204 712 679 639 657 626 646 1113 667 664 659 679 629 672 1103 692 633 640 653
Outer reference inside derived table to other relations in from clause is not allowed
27
functional arno derived tables 27 
 CS 1351 1370 1335 860 791 869 1157 660 669 1184 1114 699 654 688 683 659 1199 667 1240 785 923 786 654 673 741 1181 651 639 664 624
Derived table with same alias for several columns
28
functional arno indices lower bound asc 02 segments 01 
 CS 1416 1441 1438 961 753 762 1179 652 813 1258 1177 640 644 660 647 668 1334 762 1089 660 1264 1214 651 679 684 1204 624 697 670 652
ASC 2-segment index lower bound
29
functional arno indices timestamps 01 
 CS 1367 1352 1349 914 732 744 1214 653 690 1189 657 671 640 666 655 707 645 1056 1139 717 1048 1156 636 657 726 1153 616 685 689 625
TIMESTAMP in index with values below julian date
30
functional arno indices upper bound asc 01 segments 01 
 CS 1300 1328 1303 900 796 783 1164 688 741 1169 630 619 648 693 649 658 668 1210 1140 695 1192 1205 649 651 689 1235 628 648 683 654
ASC single segment index upper bound
31
functional arno indices upper bound asc 01 segments 02 
 CS 1302 1421 1272 872 842 740 997 625 706 1115 628 1028 642 669 714 630 699 1224 1152 687 1260 1148 659 648 718 1141 641 685 708 680
ASC single segment index upper bound
32
functional arno optimizer opt aggregate distribution 05 
 CS 1300 1307 1512 885 828 808 652 698 687 1053 643 1164 669 682 694 658 669 1197 1141 706 1255 1089 762 778 715 1173 663 783 742 763
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
33
functional arno optimizer opt aggregate distribution 07 
 CS 1468 1495 1273 836 760 768 693 668 693 1218 646 704 648 710 730 679 709 1177 1244 678 1116 1183 708 714 739 1176 644 756 670 647
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
34
functional arno optimizer opt aggregate distribution 08 
 CS 1364 1406 1350 842 746 770 692 684 674 1286 670 984 638 684 1362 666 771 1180 1283 647 984 1266 675 720 693 1044 612 777 691 632
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
35
functional arno optimizer opt aggregate distribution 09 
 CS 1338 1307 1416 831 802 802 679 689 708 1264 635 1192 629 665 1354 639 665 1239 1217 661 1102 1248 694 667 699 1221 635 708 688 684
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
36
functional arno optimizer opt inner join 05 
 CS 1415 1312 1383 911 726 747 668 653 686 1150 1110 674 645 696 988 672 662 1118 1133 713 1280 813 983 954 718 1182 824 1014 687 656
INNER JOIN join order LIKE and STARTING WITH
37
functional arno optimizer opt inner join 10 
 CS 1446 1268 842 846 1368 745 667 636 736 1152 660 675 638 713 1275 662 725 1192 1201 671 669 663 1180 935 672 1161 605 1258 727 635
INNER JOIN join order
38
functional arno optimizer opt left join 04 
 CS 1341 1385 1349 928 788 775 668 665 858 1212 1245 682 676 666 1319 689 743 687 1210 753 673 1023 663 1274 741 1128 627 1188 757 638
LEFT OUTER JOIN with full match
39
functional arno optimizer opt left join 05 
 CS 1155 1196 1128 697 618 613 551 572 583 1028 940 514 528 562 1030 542 507 541 777 528 519 1096 492 1011 543 1022 509 633 597 537
LEFT OUTER JOIN with full match, but limited in ON clause
40
functional arno optimizer opt left join 08 
 CS 1428 1409 1360 947 779 738 633 627 723 1255 1279 1088 651 691 1314 664 646 631 653 657 664 1237 652 1135 750 1380 670 675 791 623
LEFT OUTER JOIN with full match, but limited in ON and WHERE clause
41
functional arno optimizer opt left join 09 
 CS 1364 1327 1309 828 748 757 680 667 722 1106 1237 1261 631 683 1267 672 685 649 611 686 710 953 646 1128 695 1318 636 697 717 702
LEFT OUTER JOIN with full match, but limited in ON and WHERE clause
42
functional arno optimizer opt multi index selection 04 
 CS 1329 1429 1434 887 731 808 688 729 719 1295 1168 1281 1013 670 1377 653 700 718 937 1288 735 810 712 674 727 1100 692 663 761 693
Best match index selection (multi segment)
43
functional arno optimizer opt sort by index 16 
 CS 1292 739 1260 867 1241 742 698 1185 703 656 1205 670 1208 684 1164 1205 641 759 1197 676 664 659 658 708 713 1104 1123 652 659 695
ORDER BY DESC NULLS FIRST using index
44
functional datatypes decfloat ordering rules 
 CS 1080 1009 638 664 1059 661 497 948 599 552 623 501 566 545 967 542 491 511 524 543 522 551 962 972 578 893 489 1021 1016 489
Test ordering of decfloat values
45
functional procedure create 07 
 CS 1060 591 1070 621 1012 577 525 514 509 520 481 880 900 514 524 980 579 580 482 1000 513 852 507 507 538 969 907 518 492 956
CREATE PROCEDURE - try create SP with same name
46
functional tabloid gtcs proc isql 14 
 SS 536 325 311 507 575 338 576 481 308 459 399 413 500 296 504 550 480 273 508 552 348 501 301 282 302 480 487 312 501 275
gtcs-proc-isql-14
47
functional tabloid join transformation 001 
 SS 1109 673 731 1468 1106 702 1143 1150 755 996 1344 1331 1126 700 1299 1191 1297 630 1272 868 659 1016 600 678 804 976 1119 598 1038 586
Check ability of outer join simplification.
48
functional tabloid join transformation 003 
 SS 1444 692 730 1124 1327 717 1130 1204 746 934 1385 1207 1039 768 926 1197 862 653 855 921 689 1320 577 586 725 843 827 644 941 568
Check ability of outer join simplification.
49
functional tabloid join transformation 005 
 SS 1440 659 764 1588 1429 763 1261 836 777 965 1208 1222 863 737 872 1260 1362 573 1121 896 645 1089 726 618 732 972 600 629 961 596
Check ability of outer join simplification.
50
functional tabloid join transformation 007 
 SS 1983 1732 821 2031 1180 822 1371 1469 859 1373 1024 1536 1377 811 1424 1484 1423 677 1399 1523 922 1696 732 671 857 1213 1343 703 1276 627
Check ability of outer join simplification.

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-4075
http://tracker.firebirdsql.org/browse/CORE-4084
http://tracker.firebirdsql.org/browse/CORE-4091
http://tracker.firebirdsql.org/browse/CORE-4203
http://tracker.firebirdsql.org/browse/CORE-4210
http://tracker.firebirdsql.org/browse/CORE-4236
http://tracker.firebirdsql.org/browse/CORE-4247
http://tracker.firebirdsql.org/browse/CORE-4299
http://tracker.firebirdsql.org/browse/CORE-4301
http://tracker.firebirdsql.org/browse/CORE-5447
http://tracker.firebirdsql.org/browse/CORE-5538
http://tracker.firebirdsql.org/browse/CORE-5542
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_27.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/indices/test_lower_bound_asc_02_segments_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/indices/test_timestamps_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/indices/test_upper_bound_asc_01_segments_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/indices/test_upper_bound_asc_01_segments_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_aggregate_distribution_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_aggregate_distribution_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_aggregate_distribution_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_aggregate_distribution_09.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_10.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_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_left_join_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_left_join_09.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_multi_index_selection_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_16.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_decfloat_ordering_rules.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/procedure/create/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_gtcs_proc_isql_14.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_join_transformation_001.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_join_transformation_003.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_join_transformation_005.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_join_transformation_007.py
https://github.com/FirebirdSQL/firebird/issues/6808
https://github.com/FirebirdSQL/firebird/issues/7178
https://github.com/FirebirdSQL/firebird/issues/7222
https://github.com/FirebirdSQL/firebird/issues/7227
https://github.com/FirebirdSQL/firebird/issues/7237
https://github.com/FirebirdSQL/firebird/issues/7239
https://github.com/FirebirdSQL/firebird/issues/7243
https://github.com/FirebirdSQL/firebird/issues/8100
https://github.com/FirebirdSQL/firebird/issues/8104
https://github.com/FirebirdSQL/firebird/issues/8108
https://github.com/FirebirdSQL/firebird/issues/8113
https://github.com/FirebirdSQL/firebird/issues/8120
=== end of list ===

Last commits information (all timestamps in UTC):