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 (1 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 (50 rows)
07. Has fails: tests with at least one fail for previous 35 runs (55 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (1 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 (2987 rows)
12. Skipped: tests which was intentionally excluded from execution (174 rows)

Generated UTC 11.12.2025 01:33
Tested: FB60.   Build / date: 6.0.0.1367-2a02c8c9 / 2025.12.10;
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
6.0.0.1367
2025.12.10
2a02c
6.0.0.1366
2025.12.08
3b980
6.0.0.1365
2025.12.07
e8787
6.0.0.1364
2025.12.04
90488
6.0.0.1363
2025.12.03
ead6d
6.0.0.1361
2025.12.01
56dfb
6.0.0.1360
2025.11.29
8b3c3
6.0.0.1358
2025.11.24
312cc
6.0.0.1357
2025.11.19
d37c9
6.0.0.1356
2025.11.17
df73f
6.0.0.1355
2025.11.16
f3c5d
6.0.0.1354
2025.11.09
174ee
6.0.0.1352
2025.11.08
c595c
6.0.0.1351
2025.11.07
d7fef
6.0.0.1346
2025.11.06
bf133
6.0.0.1342
2025.11.05
ff3e4
6.0.0.1338
2025.11.03
c32dc
6.0.0.1337
2025.11.01
339dc
6.0.0.1336
2025.10.31
a7d03
6.0.0.1335
2025.10.29
eceaf
6.0.0.1334
2025.10.27
67c93
6.0.0.1330
2025.10.26
07e61
6.0.0.1315
2025.10.24
8df33
6.0.0.1313
2025.10.21
7e32c
6.0.0.1312
2025.10.17
efa86
6.0.0.1311
2025.10.16
08844
6.0.0.1309
2025.10.15
fd9c0
6.0.0.1306
2025.10.13
a74c8
6.0.0.1305
2025.10.12
1bfb3
6.0.0.1304
2025.10.11
19b95
6.0.0.1301
2025.10.10
50548
Test TITLE
1
bugs core 1715 
 tracker
 CS 2025.06.26 07:18
2890 1852 2890 1894 1894 2007 3043 3009 3009 2888 2888 1893 1893 1893 2758 2758 2758 2740 2638 2638 2223 2638 2641 2641 2776 2838 2776 1916 2468 2468 1916
Incorrect "key size exceeds implementation restriction for index" error
2
bugs core 1735 
 tracker
 CS 2022.02.02 14:46
1420 855 1309 912 912 956 1309 1116 1607 1392 1392 1116 1392 1392 969 1393 1393 969 965 965 943 965 1082 1082 1082 1312 1312 878 1312 1397 894
Bug in SET DEFAULT statement
3
bugs core 1760 
 tracker
 CS 2025.06.25 21:33
1119 721 717 717 717 777 792 878 1158 1195 1195 1158 1158 814 741 814 814 727 726 726 726 839 1118 1118 1011 1118 1011 1011 1159 1170 1170
Support hex numeric and string literals
4
bugs core 1891 
 tracker
 CS 2025.06.26 10:27
1200 757 1147 757 757 1088 1147 1152 1152 1152 739 739 739 750 758 1103 758 750 736 680 680 703 703 783 1051 1116 1116 1134 1134 1130 776
SHOW VIEW shows non-sense information for view fields with expressions
5
bugs core 2005 
 tracker
 CS 2022.02.02 14:46
1196 748 748 748 709 748 837 837 817 817 817 817 817 810 1124 1124 771 789 789 749 717 713 713 717 1165 1175 1175 1175 1165 1140 848
Support SQL 2008 syntax for MERGE statement with DELETE extension
6
bugs core 2416 
 tracker
 CS 2022.02.02 14:46
1023 657 680 680 680 680 1212 1212 1084 1084 1084 1084 1084 1104 1104 746 746 1106 1076 1106 1106 1076 983 983 679 679 762 762 714 762 752
AV preparing a query with aggregate over derived table
7
bugs core 2722 
 tracker
 CS 2022.02.02 14:46
1436 883 883 1419 1420 1419 1420 1419 1346 1339 1346 1339 1283 1222 1222 1199 1222 1222 1221 1221 1275 1221 1275 1473 1473 821 829 829 829 1100 1100
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
8
bugs core 4604 
 tracker
 CS 2024.06.09 15:53
1249 805 805 805 805 847 1332 1332 1332 1320 1294 828 1060 1060 1060 1297 1297 1297 763 761 750 750 761 855 1175 1175 855 855 827 827 842
EXECUTE STATEMENT rise varchar char_length() size
9
bugs core 4693 
 tracker
 CS 2022.02.02 14:46
1079 705 705 738 738 738 809 1247 1247 1247 809 742 742 742 742 709 733 733 733 709 733 734 793 793 793 921 757 757 757 1122 757
CTE Aliases
10
bugs core 4735 
 tracker
 CS 2025.06.30 11:54
1058 683 683 683 736 749 945 945 736 695 695 695 740 740 740 740 740 762 774 957 957 1167 1175 1175 727 686 686 686 706 819 819
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
11
bugs core 4738 
 tracker
 CS 2025.06.30 12:56
1065 693 693 693 784 788 788 788 788 730 730 730 766 766 766 748 747 747 747 881 881 972 972 972 699 699 699 699 776 799 799
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
12
bugs core 4739 
 tracker
 CS 2024.10.31 10:32
1251 817 796 796 796 817 1017 1017 843 843 791 781 791 791 792 792 842 865 847 906 906 949 949 949 744 793 793 793 793 830 830
Accent insensitive comparison: diacritical letters with DIAGONAL crossing stroke pass only test on EQUALITY to their non-accented forms
13
bugs core 5896 
 tracker
 CS 2022.02.02 14:46
1128 724 1128 1133 1153 1284 1284 1284 1284 1262 1262 1262 1262 773 773 773 1261 1261 1261 1144 757 757 1144 1181 1255 1255 1181 1181 1192 1108 775
NOT NULL constraint is not synchronized after rename column
14
bugs core 5898 
 tracker
 CS 2024.06.09 15:53
3246 1859 3228 2671 2671 3096 3228 3660 3660 3660 3511 3421 3368 3368 3368 3388 3414 3414 3388 3244 2200 2200 3244 3393 3393 3394 3394 3324 3249 2157 2157
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
15
bugs core 5904 
 tracker
 CS 2022.02.02 14:46
1275 771 1244 806 806 1244 1260 1271 1346 1348 1348 1348 1365 1365 1365 1387 1387 1286 1276 1276 885 885 1148 1231 1231 1231 1170 1225 1170 798 798
An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails
16
bugs core 5939 
 tracker
 CS 2022.02.02 14:46
875 560 846 846 835 835 835 614 614 614 855 855 864 864 909 909 929 929 955 955 955 886 727 727 727 895 895 909 924 924 878
Crash for "gbak -se -b database nul"
17
bugs core 5943 
 tracker
 CS 2022.02.02 14:46
1151 743 1099 802 802 1099 1099 802 1100 1204 1130 1130 1204 1251 1244 1244 1244 1145 1145 1145 1145 1145 1092 1092 1092 1130 1146 1146 1183 1130 1079
Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list
18
bugs core 5949 
 tracker
 CS 2022.02.02 14:46
1334 759 1223 873 873 1223 1223 1336 1348 1409 1409 1409 1494 1494 1494 1494 1494 1443 1443 1446 1443 1443 1382 1257 1257 1297 1338 1333 1338 1338 1333
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
19
bugs core 5953 
 tracker
 CS 2022.02.02 14:46
1206 731 770 770 770 1005 1005 1281 1325 1329 1325 1325 1280 1280 1280 1295 1295 1332 1295 1275 1271 1265 1090 1090 1090 1270 1285 1285 1270 1263 1223
Statement level read consistency in read-committed transactions
20
bugs core 5957 
 tracker
 CS 2022.02.02 14:46
1132 719 719 719 719 802 809 1110 1159 1159 1159 1159 1168 1182 1203 1182 1203 1212 1212 1212 1212 1178 1136 1080 1080 1136 1136 1080 1140 1068 1052
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset
21
bugs core 5974 
 tracker
 CS 2022.02.02 14:46
1100 709 697 697 697 749 777 944 998 1140 1195 1195 1195 1203 1224 1203 1277 1203 1243 1152 1152 1152 953 953 1095 1209 1209 1209 1209 1186 1124
Wrong result of select distinct with decfload/timezone/collated column
22
bugs core 5982 
 tracker
 CS 2022.02.02 14:46
2345 1480 1586 1586 1561 1586 1634 1779 1779 2509 2509 2509 2509 2511 2465 2465 2511 2468 2468 2468 2468 2468 2252 2252 1979 2423 2423 2500 2515 2515 2500
error read permission for BLOB field, when it is input/output procedure`s parametr
23
bugs core 5985 
 tracker
 CS 2024.06.09 15:53
3679 2320 2320 2320 2320 2333 2521 2555 2864 4155 4155 4155 4029 4029 4022 4022 4022 4022 4022 3169 3169 3973 3169 3169 2312 3753 3753 3896 3931 3931 3896
Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored)
24
bugs core 5990 
 tracker
 CS 2024.06.09 15:53
1684 1004 1056 1056 1056 1098 1103 1109 1195 1235 1614 1614 1614 1691 1691 1691 1691 1725 1725 1752 1752 1752 1752 1059 1037 1037 1037 1838 1861 1861 1838
Pool of external connections
25
bugs gh 6869 
 tracker
 CS 2025.07.04 14:34
1468 922 922 922 1445 1488 1501 1488 1536 1536 1536 1385 1536 1527 1584 1527 1549 1549 1549 1549 1565 1565 1399 1565 1399 1399 1516 1526 1516 1516 1496
Domain CHECK-expression can be ignored when we DROP objects that are involved in it
26
bugs gh 7276 
 tracker
 SS 2023.11.25 16:51
717 463 494 717 494 494 646 646 466 466 466 466 466 494 494 494 423 423 400 385 385 400 380 400 430 546 430 430 476 462 462
Firebird 4 literal containing crashes server
27
bugs gh 7388 
 tracker
 SS 2025.01.18 13:08
799 475 521 799 702 700 702 702 700 520 520 520 662 696 696 662 537 537 511 511 511 511 501 501 717 766 766 766 766 694 636
Different invariants optimization between views and CTEs
28
bugs gh 7464 
 tracker
 SS 2023.02.15 14:58
600 392 552 458 552 552 644 644 644 501 501 501 508 535 535 508 508 552 449 449 552 427 427 491 643 622 622 660 622 622 596
Crash on repeating update in 5.0
29
bugs gh 7467 
 tracker
 SS 2023.02.14 14:05
614 360 494 614 645 528 551 551 528 477 477 477 477 494 494 475 475 467 382 382 377 372 372 377 437 529 529 484 460 484 460
Simple SQL crashes firebird: select cast(rdb$db_key as integer) from rdb$database
30
bugs gh 7474 
 tracker
 SS 2023.03.01 19:17
843 506 555 843 971 880 1011 1011 880 604 604 604 813 977 977 813 831 585 575 575 575 551 551 608 613 636 661 661 636 667 666
Incorrect condition evaluation - FB 5.0
31
bugs gh 7499 
 tracker
 SS 2025.07.05 17:12
770 485 485 756 756 756 876 876 876 857 857 857 857 857 857 754 754 754 650 650 745 531 531 745 750 769 857 769 750 666 538
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
32
bugs gh 7566 
 tracker
 SS 2024.01.21 07:31
691 433 433 463 598 598 631 738 896 896 754 884 884 879 761 761 761 835 835 835 835 793 535 535 641 535 535 641 500 500 619
Allow DEFAULT keyword in argument list
33
bugs gh 7568 
 tracker
 SS 2025.07.05 17:16
727 398 389 389 727 654 654 718 718 676 718 721 721 676 699 655 655 699 699 548 680 548 548 669 680 669 669 661 429 429 476
Equivalence of boolean condition in partial index
34
bugs gh 7590 
 tracker
 SS 2023.10.02 18:37
628 373 373 409 409 409 505 505 770 770 694 632 632 632 459 566 566 603 603 603 603 463 463 463 639 639 664 639 414 414 457
Improve DECLARE VARIABLE to accept complete value expressions
35
bugs gh 7647 
 tracker
 SS 2025.07.08 05:41
568 347 317 347 541 541 541 645 652 645 625 625 518 518 549 549 574 605 574 574 493 346 341 341 341 331 331 346 339 346 356
Regression: Error in isc_array_lookup_bounds
36
bugs gh 7664 
 tracker
 SS 2023.07.18 20:57
633 398 398 431 764 653 775 775 775 695 783 713 713 713 713 713 614 766 706 706 706 706 457 457 439 436 439 439 439 443 489
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
37
bugs gh 7691 
 tracker
 SS 2023.09.07 08:46
1186 755 674 755 1413 1387 1413 1413 1387 1385 1370 1278 1278 1278 1316 1236 1316 1316 1339 1172 1172 1031 1019 1019 1019 970 1276 1276 970 970 1030
'with caller privileges' has no effect in triggers
38
bugs gh 7713 
 tracker
 SS 2023.08.25 18:25
722 410 410 426 877 877 877 877 768 768 740 740 768 740 740 775 780 780 823 823 721 717 417 417 454 443 454 454 443 443 492
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
39
bugs gh 7715 
 tracker
 SS 2023.10.02 12:48
727 365 364 365 683 564 564 677 564 564 655 677 655 673 722 677 677 718 718 677 613 518 432 432 524 373 414 414 400 400 407
Alternative String Literals and multibyte (UTF8) alternatives
40
bugs gh 7727 
 tracker
 SS 2025.07.05 19:14
615 370 370 383 497 497 705 710 710 710 705 710 723 723 723 723 715 697 697 697 576 576 421 421 576 398 622 622 398 398 480
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
41
functional arno optimizer opt aggregate distribution 01 
 SS 2025.07.16 15:54
691 439 691 691 497 497 775 561 784 784 767 561 461 461 461 461 492 492 533 438 701 701 701 680 701 680 578 503 436 436 499
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
42
functional arno optimizer opt aggregate distribution 03 
 SS 2025.07.16 15:54
770 474 474 552 543 543 552 566 621 740 740 621 621 538 521 489 489 434 489 489 504 504 560 560 593 593 593 465 428 428 465
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
43
functional arno optimizer opt full join 03 
 SS 2025.07.16 15:54
729 433 433 625 497 497 625 625 505 717 717 505 505 717 480 445 445 480 480 465 465 562 465 465 622 710 622 622 468 468 468
FULL OUTER JOIN, list all values, but filtered in WHERE clause
44
functional arno optimizer opt full join 04 
 SS 2025.07.16 15:54
708 435 435 708 556 556 853 853 556 528 528 511 511 528 605 478 485 526 526 485 485 526 484 484 499 628 514 514 499 514 514
FULL OUTER JOIN, list all values, but filtered in WHERE clause
45
functional arno optimizer opt inner join 01 
 SS 2025.07.16 15:54
768 413 413 785 525 525 745 745 525 625 625 488 488 625 454 449 454 486 486 486 486 486 437 437 483 650 483 483 467 467 467
INNER JOIN join order
46
functional intfunc string overlay 01 
 SS 2022.02.04 18:05
579 368 579 443 443 476 605 476 524 524 524 397 524 397 397 479 517 517 517 517 622 622 544 544 544 544 436 583 583 583 461
OVERLAY function
47
functional intfunc string reverse 01 
 SS 2022.02.04 18:05
555 355 424 373 373 424 449 449 565 565 565 565 565 578 515 578 515 515 515 498 498 559 587 559 587 611 611 583 654 583 489
REVERSE( <value> )
48
functional tabloid eqc 141347 
 SS 2022.02.04 18:05
733 414 733 733 484 484 612 563 563 563 424 424 414 424 446 542 446 446 401 401 393 401 505 505 505 505 496 465 496 496 494
Check correctness of LEFT JOIN result when right source has two FK and one of fields from FK present both in ON and WHERE clauses.
49
functional tabloid eqc 160757 
 SS 2022.02.04 18:05
647 397 714 714 520 520 612 612 612 612 479 479 424 424 424 655 504 504 448 504 466 466 590 590 590 651 590 622 651 622 620
Check correctness of LEFT JOIN result when left source is table with several -vs- single rows and right source is SP.
50
functional tabloid gtcs proc isql 14 
 SS 2022.02.04 18:05
1012 639 1012 711 711 711 1044 959 959 959 810 810 638 638 954 1025 1025 1025 735 735 657 657 601 878 1009 1009 912 1028 1028 912 912
gtcs-proc-isql-14

Elapsed time, milliseconds:

NN Test name mode
6.0.0.1367
2025.12.10
2a02c
6.0.0.1366
2025.12.08
3b980
6.0.0.1365
2025.12.07
e8787
6.0.0.1364
2025.12.04
90488
6.0.0.1363
2025.12.03
ead6d
6.0.0.1361
2025.12.01
56dfb
6.0.0.1360
2025.11.29
8b3c3
6.0.0.1358
2025.11.24
312cc
6.0.0.1357
2025.11.19
d37c9
6.0.0.1356
2025.11.17
df73f
6.0.0.1355
2025.11.16
f3c5d
6.0.0.1354
2025.11.09
174ee
6.0.0.1352
2025.11.08
c595c
6.0.0.1351
2025.11.07
d7fef
6.0.0.1346
2025.11.06
bf133
6.0.0.1342
2025.11.05
ff3e4
6.0.0.1338
2025.11.03
c32dc
6.0.0.1337
2025.11.01
339dc
6.0.0.1336
2025.10.31
a7d03
6.0.0.1335
2025.10.29
eceaf
6.0.0.1334
2025.10.27
67c93
6.0.0.1330
2025.10.26
07e61
6.0.0.1315
2025.10.24
8df33
6.0.0.1313
2025.10.21
7e32c
6.0.0.1312
2025.10.17
efa86
6.0.0.1311
2025.10.16
08844
6.0.0.1309
2025.10.15
fd9c0
6.0.0.1306
2025.10.13
a74c8
6.0.0.1305
2025.10.12
1bfb3
6.0.0.1304
2025.10.11
19b95
6.0.0.1301
2025.10.10
50548
6.0.0.1300
2025.10.08
f40d5
6.0.0.1299
2025.10.07
7c542
6.0.0.1295
2025.10.06
b1425
6.0.0.1293
2025.10.04
2caed
Test TITLE
1
bugs core 1715 
 tracker
 CS 2891 1778 2890 3113 1852 1745 3043 1894 3112 2007 3235 3009 2888 1893 1836 1850 3151 2994 2758 2740 2223 1849 2638 2641 1819 3169 2776 1867 2910 2838 1916 1777 2468 2669 1831
Incorrect "key size exceeds implementation restriction for index" error
2
bugs core 1735 
 tracker
 CS 1420 855 1420 1539 831 848 1309 912 1714 956 1787 1116 1607 1392 800 814 1586 1393 969 1443 943 965 888 1470 881 1082 1396 859 1312 1401 878 864 1418 1397 894
Bug in SET DEFAULT statement
3
bugs core 1760 
 tracker
 CS 1440 721 1252 1119 717 643 627 777 792 878 1263 1195 1158 1245 735 741 1277 814 727 1260 705 726 697 1224 839 1118 1237 666 1011 1159 806 1255 1191 1170 755
Support hex numeric and string literals
4
bugs core 1891 
 tracker
 CS 1200 756 1229 1358 694 757 1147 754 1088 1627 1540 1152 739 644 673 1359 758 750 1125 1103 680 736 631 668 783 703 1051 1116 1271 1199 756 1134 646 1130 776
SHOW VIEW shows non-sense information for view fields with expressions
5
bugs core 2005 
 tracker
 CS 1208 728 1228 1196 709 748 679 837 680 1440 1460 753 817 810 1294 1311 771 759 1124 1230 749 789 688 717 713 692 1272 1244 1165 1175 848 1196 659 1140 777
Support SQL 2008 syntax for MERGE statement with DELETE extension
6
bugs core 2416 
 tracker
 CS 1049 657 1123 652 1023 611 680 1379 646 1345 1212 683 1084 676 1104 1220 746 1352 671 719 1106 1278 1076 1166 983 616 604 1033 679 762 1371 638 714 1198 752
AV preparing a query with aggregate over derived table
7
bugs core 2722 
 tracker
 CS 1462 1436 850 883 1539 856 1496 1419 1420 939 1915 1346 1283 1339 1405 887 1199 1222 1419 987 1467 855 1221 1275 1476 809 1473 1511 789 821 829 1410 1100 1465 867
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
8
bugs core 4604 
 tracker
 CS 1316 746 1249 1287 805 686 660 847 1468 1332 1400 828 1294 1320 750 770 1060 1593 1297 1630 763 738 761 750 720 1222 1260 855 1175 827 752 1017 710 1244 842
EXECUTE STATEMENT rise varchar char_length() size
9
bugs core 4693 
 tracker
 CS 1201 689 705 1292 1079 647 652 738 1348 1409 809 1247 696 1371 742 707 1292 709 1189 709 733 734 631 671 793 1135 921 658 719 1192 757 1190 614 1122 719
CTE Aliases
10
bugs core 4735 
 tracker
 CS 1205 1058 1101 644 683 674 749 1249 736 945 1466 691 695 658 829 937 740 610 683 762 957 1167 774 1175 727 1240 1187 630 686 650 893 706 819 1227 781
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
11
bugs core 4738 
 tracker
 CS 1200 1065 1273 649 677 693 784 1082 788 788 1484 713 730 730 785 795 766 748 679 708 747 1152 881 972 644 1163 1261 643 699 658 888 776 799 1216 679
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
12
bugs core 4739 
 tracker
 CS 1352 1251 1277 766 646 817 796 1251 788 1017 1587 781 843 715 791 776 842 865 792 777 906 1303 847 949 692 1289 1279 744 699 793 1094 830 748 1344 796
Accent insensitive comparison: diacritical letters with DIAGONAL crossing stroke pass only test on EQUALITY to their non-accented forms
13
bugs core 5896 
 tracker
 CS 1133 724 1128 1133 673 612 1153 1338 1284 1512 776 1183 1336 1262 1285 728 773 730 1361 1340 1261 723 757 1144 657 1255 1292 1181 1295 1108 672 1192 1324 652 775
NOT NULL constraint is not synchronized after rename column
14
bugs core 5898 
 tracker
 CS 3326 1831 3322 3246 1859 1788 3228 2671 3096 3912 3876 3660 3421 3511 3368 1941 2558 3414 3415 3388 3544 2003 2200 3244 1911 3393 3454 3609 3249 3394 2157 3324 2020 1938 2284
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
15
bugs core 5904 
 tracker
 CS 1314 673 1276 1275 761 771 1244 806 1260 1412 1346 1271 1348 1447 1365 764 1460 1286 1565 1387 1276 759 885 1370 837 1231 1148 1283 1275 1170 707 1225 798 699 847
An attempt to create global mapping with long (greater than SQL identifier length) FROM field fails
16
bugs core 5939 
 tracker
 CS 886 459 884 875 560 467 846 1025 835 614 576 554 987 864 855 515 965 909 929 900 977 1025 955 886 501 561 727 909 895 924 878 969 1027 635 563
Crash for "gbak -se -b database nul"
17
bugs core 5943 
 tracker
 CS 1180 622 1160 1151 743 673 1099 802 1100 1673 679 669 1204 1251 1130 722 1344 1361 1244 1116 1136 1145 1190 1185 750 625 1092 1146 1307 1130 1256 1079 1183 668 775
Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list
18
bugs core 5949 
 tracker
 CS 1562 759 1338 1334 747 748 1223 873 1336 1539 904 1348 1584 1409 1579 1164 1494 1518 1420 1500 1392 1443 1484 1446 794 779 1382 1257 1297 1338 1384 1333 1569 795 917
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
19
bugs core 5953 
 tracker
 CS 1458 714 1206 1243 731 681 770 1005 1281 1356 793 1325 1348 1329 1280 708 1236 1380 1295 1374 1271 1332 1275 1265 813 701 1090 1285 1331 1270 1436 1263 1223 695 767
Statement level read consistency in read-committed transactions
20
bugs core 5957 
 tracker
 CS 1132 668 1143 1152 719 640 663 802 1110 1321 809 1159 1168 1121 1335 656 1182 1203 1265 1156 1260 1212 1178 1250 649 660 1136 1080 1140 1192 1052 1068 1229 621 730
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset
21
bugs core 5974 
 tracker
 CS 1200 709 1195 1100 667 697 651 749 998 944 777 1461 1140 1195 1224 624 1277 1203 1320 692 1345 1152 1243 953 702 1283 633 1095 1209 1340 1324 1186 1124 668 814
Wrong result of select distinct with decfload/timezone/collated column
22
bugs core 5982 
 tracker
 CS 2502 1398 2345 2444 1393 1480 1586 1786 1561 1779 1634 2754 2509 2574 1315 1428 2511 2615 2465 1512 2945 2468 2645 2252 1422 2476 1465 2423 1979 2813 2515 2500 2639 1493 1680
error read permission for BLOB field, when it is input/output procedure`s parametr
23
bugs core 5985 
 tracker
 CS 4245 2099 3679 3978 2320 2188 2191 2555 2333 2864 2521 4166 4155 4204 2485 2231 4029 4107 4022 2348 2421 4183 4039 3169 2312 3973 2291 3753 2168 4235 3931 3896 4447 2320 2549
Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored)
24
bugs core 5990 
 tracker
 CS 1761 949 1684 1719 1004 969 1056 1103 1098 1235 1109 1812 1195 1812 1614 985 1691 1859 1725 1038 1269 1859 1752 1752 1059 1802 931 992 1037 1861 1838 2063 1948 1111 1167
Pool of external connections
25
bugs gh 6869 
 tracker
 CS 1510 1468 1544 922 833 827 1501 1488 1445 1557 1657 900 1536 1385 1584 819 1621 1527 1611 991 1549 1570 811 1593 1565 887 1399 1594 902 1516 1649 1526 1496 807 920
Domain CHECK-expression can be ignored when we DROP objects that are involved in it
26
bugs gh 7276 
 tracker
 SS 755 346 369 717 753 463 494 738 359 722 646 400 466 435 648 494 367 717 423 651 385 400 380 348 400 613 348 430 666 546 355 387 476 462 477
Firebird 4 literal containing crashes server
27
bugs gh 7388 
 tracker
 SS 804 454 475 799 926 457 521 858 702 700 1051 520 510 439 696 869 662 792 468 461 537 984 511 443 501 783 443 717 766 925 853 477 479 694 636
Different invariants optimization between views and CTEs
28
bugs gh 7464 
 tracker
 SS 690 342 600 392 741 364 552 458 644 767 700 442 501 448 742 535 508 797 408 449 734 552 408 427 643 390 491 728 672 622 596 660 377 627 493
Crash on repeating update in 5.0
29
bugs gh 7467 
 tracker
 SS 677 360 310 614 683 333 494 769 645 528 551 369 477 457 690 668 475 494 369 382 613 467 372 369 377 352 529 695 437 570 484 460 335 561 398
Simple SQL crashes firebird: select cast(rdb$db_key as integer) from rdb$database
30
bugs gh 7474 
 tracker
 SS 915 459 506 843 971 490 555 1144 1011 880 1028 528 566 604 977 813 980 1064 503 585 831 575 540 551 613 508 608 661 636 883 667 477 503 803 666
Incorrect condition evaluation - FB 5.0
31
bugs gh 7499 
 tracker
 SS 1032 484 485 770 957 420 461 756 876 1049 967 685 857 562 857 925 894 754 528 650 934 931 499 484 745 531 951 769 750 857 920 538 513 666 536
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
32
bugs gh 7566 
 tracker
 SS 691 725 433 431 863 411 463 598 910 912 631 738 896 975 754 884 761 879 747 484 835 896 840 432 793 479 535 779 641 436 500 765 462 619 622
Allow DEFAULT keyword in argument list
33
bugs gh 7568 
 tracker
 SS 730 727 398 383 727 357 389 771 735 654 572 718 856 676 721 795 655 617 699 428 702 715 548 358 680 387 709 669 742 382 375 661 429 616 476
Equivalence of boolean condition in partial index
34
bugs gh 7590 
 tracker
 SS 662 638 319 373 628 352 409 505 394 770 774 426 794 694 459 632 427 649 396 566 603 612 617 463 460 374 664 639 673 362 716 414 381 595 457
Improve DECLARE VARIABLE to accept complete value expressions
35
bugs gh 7647 
 tracker
 SS 631 568 303 347 657 317 286 541 689 670 470 645 652 518 625 432 416 605 549 610 574 651 346 312 493 341 311 606 331 330 568 346 339 580 356
Regression: Error in isc_array_lookup_bounds
36
bugs gh 7664 
 tracker
 SS 746 633 397 398 764 375 431 863 775 653 857 457 850 695 783 713 560 836 397 874 614 766 706 457 783 425 408 841 439 436 834 399 443 587 489
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
37
bugs gh 7691 
 tracker
 SS 1324 1186 669 755 1438 674 668 1537 1413 1387 1480 1187 1385 1278 1370 1236 1188 1316 1339 746 1368 1172 1458 1031 1019 684 649 1362 1276 970 1386 690 743 1301 1030
'with caller privileges' has no effect in triggers
38
bugs gh 7713 
 tracker
 SS 908 722 410 408 897 383 426 915 877 972 639 540 768 818 740 606 775 735 780 838 836 717 823 417 721 416 377 811 454 443 910 394 424 620 492
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
39
bugs gh 7715 
 tracker
 SS 823 727 364 365 880 352 360 683 843 564 461 677 499 655 910 731 471 673 722 677 788 718 518 432 613 373 342 719 524 369 414 400 364 407 524
Alternative String Literals and multibyte (UTF8) alternatives
40
bugs gh 7727 
 tracker
 SS 812 615 360 370 698 369 383 765 497 771 705 710 743 703 626 723 804 807 676 715 564 697 743 421 576 342 392 622 828 398 665 362 354 639 480
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
41
functional arno optimizer opt aggregate distribution 01 
 SS 700 413 439 691 800 418 775 465 497 924 784 561 814 767 446 461 459 492 533 430 768 415 701 438 802 701 578 680 794 428 503 436 434 745 499
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
42
functional arno optimizer opt aggregate distribution 03 
 SS 770 393 474 799 857 428 408 552 543 811 910 566 621 740 1011 425 538 392 521 489 434 419 664 504 560 466 593 699 660 418 465 428 415 720 478
Try to deliver HAVING CLAUSE conjunctions to the WHERE clause
43
functional arno optimizer opt full join 03 
 SS 748 416 414 729 975 433 398 625 497 863 868 476 505 717 736 423 429 745 480 445 432 562 570 465 420 710 438 841 622 734 468 403 448 734 485
FULL OUTER JOIN, list all values, but filtered in WHERE clause
44
functional arno optimizer opt full join 04 
 SS 852 385 435 708 814 394 415 892 556 1052 853 479 511 528 703 440 418 820 605 478 485 526 1049 449 484 628 433 873 499 708 514 440 424 642 534
FULL OUTER JOIN, list all values, but filtered in WHERE clause
45
functional arno optimizer opt inner join 01 
 SS 768 389 407 785 892 413 375 932 525 855 745 448 488 625 861 443 454 672 449 449 493 486 637 437 384 775 394 720 483 650 467 416 429 632 534
INNER JOIN join order
46
functional intfunc string overlay 01 
 SS 643 368 579 723 338 336 605 443 780 476 755 324 524 695 397 390 682 388 614 479 517 622 374 636 658 544 436 334 583 585 379 630 461 583 402
OVERLAY function
47
functional intfunc string reverse 01 
 SS 555 355 687 646 352 340 424 373 595 449 713 352 565 625 443 578 481 641 515 647 457 485 621 498 587 559 611 330 663 665 583 470 654 489 404
REVERSE( <value> )
48
functional tabloid eqc 141347 
 SS 751 414 396 783 733 373 757 484 470 840 612 563 393 408 424 542 414 593 446 842 393 401 364 721 365 559 505 426 659 496 421 465 689 624 494
Check correctness of LEFT JOIN result when right source has two FK and one of fields from FK present both in ON and WHERE clauses.
49
functional tabloid eqc 160757 
 SS 647 391 380 782 714 397 733 520 435 892 612 813 479 418 424 655 421 776 383 774 504 448 445 729 466 701 590 419 744 651 471 622 720 620 444
Check correctness of LEFT JOIN result when left source is table with several -vs- single rows and right source is SP.
50
functional tabloid gtcs proc isql 14 
 SS 1162 639 1012 613 1016 619 1044 711 624 1183 1065 959 810 638 637 954 625 1128 1025 1316 735 657 598 878 601 1009 537 1118 1028 581 912 1049 1091 875 798
gtcs-proc-isql-14

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1715
http://tracker.firebirdsql.org/browse/CORE-1735
http://tracker.firebirdsql.org/browse/CORE-1760
http://tracker.firebirdsql.org/browse/CORE-1891
http://tracker.firebirdsql.org/browse/CORE-2005
http://tracker.firebirdsql.org/browse/CORE-2416
http://tracker.firebirdsql.org/browse/CORE-2722
http://tracker.firebirdsql.org/browse/CORE-4604
http://tracker.firebirdsql.org/browse/CORE-4693
http://tracker.firebirdsql.org/browse/CORE-4735
http://tracker.firebirdsql.org/browse/CORE-4738
http://tracker.firebirdsql.org/browse/CORE-4739
http://tracker.firebirdsql.org/browse/CORE-5896
http://tracker.firebirdsql.org/browse/CORE-5898
http://tracker.firebirdsql.org/browse/CORE-5904
http://tracker.firebirdsql.org/browse/CORE-5939
http://tracker.firebirdsql.org/browse/CORE-5943
http://tracker.firebirdsql.org/browse/CORE-5949
http://tracker.firebirdsql.org/browse/CORE-5953
http://tracker.firebirdsql.org/browse/CORE-5957
http://tracker.firebirdsql.org/browse/CORE-5974
http://tracker.firebirdsql.org/browse/CORE-5982
http://tracker.firebirdsql.org/browse/CORE-5985
http://tracker.firebirdsql.org/browse/CORE-5990
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_aggregate_distribution_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_aggregate_distribution_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_full_join_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_full_join_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_overlay_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_reverse_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_eqc_141347.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_eqc_160757.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_gtcs_proc_isql_14.py
https://github.com/FirebirdSQL/firebird/issues/6869
https://github.com/FirebirdSQL/firebird/issues/7276
https://github.com/FirebirdSQL/firebird/issues/7388
https://github.com/FirebirdSQL/firebird/issues/7464
https://github.com/FirebirdSQL/firebird/issues/7467
https://github.com/FirebirdSQL/firebird/issues/7474
https://github.com/FirebirdSQL/firebird/issues/7499
https://github.com/FirebirdSQL/firebird/issues/7566
https://github.com/FirebirdSQL/firebird/issues/7568
https://github.com/FirebirdSQL/firebird/issues/7590
https://github.com/FirebirdSQL/firebird/issues/7647
https://github.com/FirebirdSQL/firebird/issues/7664
https://github.com/FirebirdSQL/firebird/issues/7691
https://github.com/FirebirdSQL/firebird/issues/7713
https://github.com/FirebirdSQL/firebird/issues/7715
https://github.com/FirebirdSQL/firebird/issues/7727
=== end of list ===

Last commits information (all timestamps in UTC):