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 (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 (26 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (0 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (50 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 30 runs (90 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (1 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 (6 rows)
11. All tests: outcomes for previous 30 runs (2660 rows)
12. Skipped: tests which was intentionally excluded from execution (85 rows)

Generated UTC 28.06.2025 12:41
Tested: HQ50.   Build / date: 5.0.3.1674-3ee5cc1f / 2025.06.27;
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.9; 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

Test with at least one result = "FAIL" for last 30 runs:

NN Test name mode
5.0.3.1674
2025.06.27
5.0.3.1657
2025.06.19
5.0.3.1657
2025.06.11
5.0.3.1657
2025.06.10
5.0.3.1656
2025.05.20
5.0.3.1652
2025.05.13
5.0.3.1651
2025.04.30
5.0.3.1650
2025.04.28
5.0.3.1649
2025.04.21
5.0.3.1648
2025.04.18
5.0.3.1635
2025.03.31
5.0.3.1633
2025.03.28
5.0.3.1633
2025.03.27
5.0.3.1631
2025.03.21
5.0.3.1628
2025.03.14
5.0.3.1627
2025.02.26
5.0.3.1624
2025.02.25
5.0.2.1615
2025.02.20
5.0.2.1615
2025.02.14
5.0.2.1577
2024.12.24
5.0.2.1576
2024.12.17
5.0.2.1575
2024.12.08
5.0.2.1567
2024.11.26
5.0.2.1567
2024.11.21
5.0.2.1567
2024.11.18
5.0.2.1533
2024.10.23
5.0.2.1533
2024.10.22
5.0.2.1532
2024.10.15
5.0.2.1518
2024.10.04
5.0.2.1518
2024.09.26
Test TITLE
1 CS F F P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
2 SS F F P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
3 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Compress Data over the Network
4 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Compress Data over the Network
5 CS F F F F F F F F F F F F F F F F F F F F F F P P P P P P P P
GSec incorrectly processes some switches
6 SS F F F F F F F F F F F F F F F F F F F F F F P P P P P P P P
GSec incorrectly processes some switches
7 CS F F P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation
8 SS F F P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation
9 CS P P P P P P P P P P P P P P P P P P P F P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
10 SS P P P P P P P P P P P P P P P P P P P F P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
11 CS F F F F F F F F F F F F F F F F F F F F F F F F F P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
12 SS F F F F F F F F F F F F F F F F F F F F F F F F F P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
13 CS P P P P P P P P P P P P P P P P P P P P P P P P F P P P P P
Put options in user management statements in any order
14 SS P P P P P P P P P P P P P P P P P P P P P P P P F P P P P P
Put options in user management statements in any order
15 CS P P P P P P P P P P P P F F F F F F F P P P P P P P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user
16 SS P P P P P P P P P P P P F F F F F F F P P P P P P P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user
17 CS P P P P P P P P P P P P F F F F F F F P P P P P P P P P P P
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
18 SS P P P P P P P P P P P P F F F F F F F P P P P P P P P P P P
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
19 CS P P P P P P P P P P P F P P P P P P F P P P P P P P P P P P
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
20 SS P P P P P P P P P P P P F P P P P P P P P P P P P P P P P P
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
21 CS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
Database restore must make every effort on activating deferred indexes
22 SS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
Database restore must make every effort on activating deferred indexes
23 SS F F F F F F F F F F F F F F F F F F F F F F F F F F X X X X
Events in system attachments (like garbage collector) are not traced
24 CS P P P P P P P P P P P P P P P P P P P P F F F F F P P P P P
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
25 SS P P P P P P P P P P P P P P P P P P P P F F F F F P P P P P
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
26 CS P P P P P P P P P P P P F F F F F F F P P P P P P P P P P P
Memory leak when executing a lot of different queries and StatementTimeout > 0
27 SS P P P P P P P P P P P P F F F F F F F P P P P P P P P P P P
Memory leak when executing a lot of different queries and StatementTimeout > 0
28 CS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
29 SS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
30 CS P F F 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 X X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
31 SS P F F 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 X X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
32 CS P P P P P P P P P P P P P P P P P P P F F F F F F P X X X X
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
33 SS P P P P P P P P P P P P P P P P P P P F F F F F F P X X X X
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
34 SS X X X X X F F F F X X X X X X X X X X X X X X X X X X X X X
Internal consistency check (page in use during flush) with small number of DefaultDbCachePages
35 CS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
36 SS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
37 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
38 CS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
39 SS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
40 CS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
41 SS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
42 CS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
wrong results using minvalue/maxvalue in join condition
43 SS P P P P P P P P P P P P P P P P P P P P P P P P P F X X X X
wrong results using minvalue/maxvalue in join condition
44 CS P P P P P P P P P P P P P P P P P P P P P P F X X X X X X X
Add AUTO RELEASE TEMP BLOBID transaction option
45 SS P P P P P P P P P P P P P P P P P P P P P P F X X X X X X X
Add AUTO RELEASE TEMP BLOBID transaction option
46 SS P P P P P P P P P P P P P P P P P P P F F X X X X X X X X X
Report unique usernames for isc_info_user_names
47 CS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
48 SS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
49 CS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
Crash when creating index on table that uses UDR and ParallelWorkers > 1
50 SS F F F F F F F F F F F F F F F F F F F F X X X X X X X X X X
Crash when creating index on table that uses UDR and ParallelWorkers > 1
51 SS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
gbak: Incorrect total statistics for restore
52 CS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
53 SS P P P P P P P P P P P P P P P P P P P F X X X X X X X X X X
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
54 SS P P P P P P P P P P P P P P P P P F X X X X X X X X X X X X
Segfault when already destroyed callback interface is used
55 CS X X X X X X X X X P P P P P P P P F X X X X X X X X X X X X
Segmentation fault when running query with partition by and subquery
56 CS P P P P P P P P P P F F F F F F X X X X X X X X X X X X X X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
57 SS P P P P P P P P P P F F F F F F X X X X X X X X X X X X X X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
58 CS P P P P P P P P P P F F F F X X X X X X X X X X X X X X X X
Inheritance of WINDOW does not work
59 SS P P P P P P P P P P F F F F X X X X X X X X X X X X X X X X
Inheritance of WINDOW does not work
60 CS S S S S S S S S S P F X X X X X X X X X X X X X X X X X X X
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
61 SS S S S S S S S S S P F X X X X X X X X X X X X X X X X X X X
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
62 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Conversion Error with old.field in UPDATE OR INSERT
63 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Conversion Error with old.field in UPDATE OR INSERT
64 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
65 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
66 CS P F F F F 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
PERCENT_RANK may return NaN instead of 0
67 SS P F F F F 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
PERCENT_RANK may return NaN instead of 0
68 CS P F F F 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 X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
69 SS P F F F 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 X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
70 CS P P P P P P P P P P P P P P P P P P P P P P P P P F P P P P
INNER JOIN join order LIKE and STARTING WITH
71 SS P P P P P P P P P P P P P P P P P P P P P P P P P F P P P P
INNER JOIN join order LIKE and STARTING WITH
72 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
73 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
74 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
75 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
76 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi) and WHERE clause
77 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi) and WHERE clause
78 CS F F F F F F F F F F F F F F F F F F F F F F P P P P P P P P
ISQL - SHOW SYSTEM TABLES
79 SS F F F F F F F F F F F F F F F F F F F F F F P P P P P P P P
ISQL - SHOW SYSTEM TABLES
80 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Ability to read same blob_id using multiple cursors
81 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Ability to read same blob_id using multiple cursors
82 CS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
83 SS P P P P P P P P P P F X X X X X X X X X X X X X X X X X X X
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
84 CS F F F F F F F F F F F F F F F F F F F F F F X X X X X X X X
Make asynchronous replica re-initialization reliable #8324
85 SS F F F F F F F F F F F F F F F F F F F F F F X X X X X X X X
Make asynchronous replica re-initialization reliable #8324
86 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
87 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
88 CS P P P P P P P P P P P P P P P P P P P F F F F F F P P P P P
Allow computable but non-invariant lists to be used for index lookup
89 SS P P P P P P P P P P P P P P P P P P P F F F F F F P P P P P
Allow computable but non-invariant lists to be used for index lookup
90 SS P P P P F P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.3.1674
2025.06.27
5.0.3.1657
2025.06.19
5.0.3.1657
2025.06.11
5.0.3.1657
2025.06.10
5.0.3.1656
2025.05.20
5.0.3.1652
2025.05.13
5.0.3.1651
2025.04.30
5.0.3.1650
2025.04.28
5.0.3.1649
2025.04.21
5.0.3.1648
2025.04.18
5.0.3.1635
2025.03.31
5.0.3.1633
2025.03.28
5.0.3.1633
2025.03.27
5.0.3.1631
2025.03.21
5.0.3.1628
2025.03.14
5.0.3.1627
2025.02.26
5.0.3.1624
2025.02.25
5.0.2.1615
2025.02.20
5.0.2.1615
2025.02.14
5.0.2.1577
2024.12.24
5.0.2.1576
2024.12.17
5.0.2.1575
2024.12.08
5.0.2.1567
2024.11.26
5.0.2.1567
2024.11.21
5.0.2.1567
2024.11.18
5.0.2.1533
2024.10.23
5.0.2.1533
2024.10.22
5.0.2.1532
2024.10.15
5.0.2.1518
2024.10.04
5.0.2.1518
2024.09.26
Test TITLE
1 CS 855 1003 990 856 1039 911 989 1017 993 946 1010 1005 868 901 983 813 900 713 825 855 845 615 673 630 591 571 561 652 614 610 717
CREATE VIEW ignores PLAN
2 SS 484 741 754 508 603 575 563 584 697 569 528 663 577 592 638 509 425 460 445 460 447 332 326 340 333 330 330 333 332 330 376
CREATE VIEW ignores PLAN
3 CS 875 27975 29429 30469 37875 31684 36825 39906 40243 37666 33362 39272 33374 39827 36894 857 893 831 776 804 843 625 582 665 580 590 582 688 678 603 661
Compress Data over the Network
4 SS 463 28243 27334 27570 36448 30337 34884 38268 38790 35390 32253 35410 32196 34778 34557 453 462 453 449 464 438 319 334 369 340 326 355 345 372 344 343
Compress Data over the Network
5 CS 698 524 497 569 711 531 559 657 665 665 607 625 624 527 599 1023 1049 902 964 958 947 803 703 749 744 687 693 729 721 767 751
GSec incorrectly processes some switches
6 SS 404 309 354 376 398 331 412 422 373 371 407 382 356 382 384 544 540 539 520 508 554 401 384 410 400 403 443 422 405 426 437
GSec incorrectly processes some switches
7 CS 848 738 695 665 938 729 795 798 847 719 836 776 671 827 792 1144 1207 1066 1158 1113 1141 850 864 919 876 835 812 892 872 930 864
Maximum key size using PXW_CSY collation
8 SS 428 356 387 360 387 371 420 445 347 421 399 418 422 374 432 642 650 535 539 600 627 433 430 419 426 468 447 422 433 480 457
Maximum key size using PXW_CSY collation
9 CS 926 908 844 1007 1716 989 1183 1222 1133 1080 1080 1107 1018 924 1096 929 940 921 941 881 986 663 695 688 675 701 682 772 754 706 762
Improve sorting performance when long VARCHARs are involved
10 SS 487 643 482 551 684 590 617 584 656 633 598 710 562 518 590 461 511 488 437 487 456 340 337 347 349 348 363 341 357 355 364
Improve sorting performance when long VARCHARs are involved
11 CS 1016 1802 1783 1937 1827 1860 2247 2194 2469 2162 2122 2184 1972 2001 2135 803 1203 775 830 762 798 589 656 605 593 601 575 680 680 605 714
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
12 SS 451 1111 1036 1249 1198 1112 1389 1324 1359 1361 1104 1220 1160 1164 1260 469 434 402 395 416 433 325 311 321 306 333 337 328 366 312 343
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
13 CS 1029 11087 11613 11160 6965 11534 13240 14308 13861 14371 12871 14901 13151 11944 12791 1013 931 1040 980 947 1018 783 778 770 754 704 741 773 824 785 861
Put options in user management statements in any order
14 SS 586 9681 9990 10006 12877 10500 13792 12929 12852 13049 11994 14000 11821 10373 11547 594 578 561 504 516 502 437 415 483 405 432 413 420 436 476 432
Put options in user management statements in any order
15 CS 745 27278 27703 27557 29475 30948 35408 34876 35595 34117 32908 34697 32836 52157 33641 637 660 675 693 688 798 519 502 547 516 528 568 526 563 560 666
Slow performance when executing SQL scripts as non-SYSDBA user
16 SS 410 26356 27633 28521 32091 29909 34511 33799 31950 33342 31650 33535 31941 126504 58956 395 426 379 378 372 388 252 235 238 235 277 260 270 242 279 250
Slow performance when executing SQL scripts as non-SYSDBA user
17 CS 3917 48960 49586 48881 48059 56275 62265 63757 61696 63405 63504 61414 55294 59282 60419 3928 3827 3720 3783 3753 3907 2886 2921 3057 2919 2944 2877 2950 2995 3027 3255
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
18 SS 2833 48580 48025 47902 59373 55883 59023 63242 62755 61980 59750 63530 56087 60469 59142 2864 2802 2667 2627 2661 2686 2084 2041 2166 1975 2077 2066 2018 2218 2199 2117
Memory leak when running EXECUTE STATEMENT with named parameters [CORE6475]
19 CS 839 3209 3178 3149 3056 3279 3342 3321 3367 3323 3301 3348 3338 3280 3308 855 811 817 782 788 823 617 613 606 577 589 599 673 651 648 597
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
20 SS 492 2674 2682 2679 2762 2676 2741 2722 2748 2744 2748 2751 2725 2823 2713 470 449 395 514 448 434 326 310 359 355 359 348 344 361 361 334
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
21 CS 827 893 815 838 705 870 987 835 940 1027 1043 973 978 1045 1014 756 820 780 768 727 839 573 594 624 582 569 638 0 0 0 0
Database restore must make every effort on activating deferred indexes
22 SS 574 564 593 601 691 632 684 680 643 672 585 670 633 594 634 509 456 415 469 482 468 346 324 312 302 337 327 0 0 0 0
Database restore must make every effort on activating deferred indexes
23 SS 394 327 329 356 356 386 378 394 386 380 320 394 345 391 354 1532 1488 1608 1188 1358 1600 1035 1054 1078 1137 1067 1161 0 0 0 0
Events in system attachments (like garbage collector) are not traced
24 CS 3201 3062 3083 3112 3067 3433 3474 3462 3465 3422 3490 3547 3431 3471 3509 3215 3213 3154 3228 3189 3267 3041 2982 3054 2998 3789 2992 3036 3058 3014 3076
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
25 SS 2570 2568 2510 2535 2572 2560 3632 2648 2620 2604 2612 2612 2598 2539 3617 2636 2649 3555 3587 3612 3575 2501 2475 2505 2507 2503 2526 2483 2511 2531 2506
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
26 CS 825 18654 18772 18629 18764 18826 18848 18769 18821 18849 18769 18853 18744 19276 19124 815 822 829 711 772 758 618 580 622 587 584 658 597 629 604 638
Memory leak when executing a lot of different queries and StatementTimeout > 0
27 SS 472 18392 18495 18373 18405 18433 18497 18476 18428 18447 18395 18501 18462 18756 18917 476 469 446 423 424 415 326 322 341 332 365 330 352 352 439 352
Memory leak when executing a lot of different queries and StatementTimeout > 0
28 CS 1912 1901 1739 1821 1804 1923 2165 2151 2289 2031 2169 2122 1940 2323 2253 960 904 868 843 891 951 0 0 0 0 0 0 0 0 0 0
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
29 SS 1514 1364 1377 1360 1622 1533 1740 1596 1586 1603 1645 1612 1495 1656 1651 528 519 447 479 525 510 0 0 0 0 0 0 0 0 0 0
Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x
30 CS 634 634 592 635 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
31 SS 388 412 362 388 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
32 CS 912 766 687 734 685 728 922 854 792 844 877 871 858 903 799 11940 11878 12760 13910 12525 15162 9622 9737 10106 9638 9430 9776 0 0 0 0
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
33 SS 534 434 379 468 525 409 472 510 520 463 426 495 458 467 543 11848 12374 12966 12454 12483 13657 9669 9425 9676 9216 9273 9898 0 0 0 0
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
34 SS 1638 0 0 0 0 0 1711 1565 1769 1412 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Internal consistency check (page in use during flush) with small number of DefaultDbCachePages
35 CS 824 733 773 874 801 914 943 1036 974 1041 962 950 945 952 951 876 822 798 807 808 826 593 596 628 650 599 616 0 0 0 0
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
36 SS 772 471 418 549 661 488 691 654 664 604 578 578 532 853 561 16991 17243 18311 18046 17334 18803 15054 14746 15541 14951 14687 15281 0 0 0 0
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI
37 CS 1341 1554 1611 1662 1667 1731 2032 1987 1935 1966 1864 2005 1865 2058 2154 1295 1170 1164 1288 1388 1249 934 925 1025 932 969 961 925 925 929 996
gbak on Classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message
38 CS 1022 814 814 812 876 885 894 1013 928 968 975 970 1032 925 938 3430 3690 3616 3677 3561 4264 2735 2730 3290 2868 2796 3234 0 0 0 0
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
39 SS 628 456 502 434 561 474 535 513 495 492 471 529 497 695 443 3276 3470 3011 3188 2930 3228 2479 2373 2540 2378 2403 2626 0 0 0 0
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
40 CS 2973 2845 3172 3102 3205 3257 3938 3980 4068 3299 3611 3807 3527 3647 3969 848 888 852 680 790 834 579 614 629 578 626 651 0 0 0 0
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
41 SS 2574 2458 2691 2850 3489 2818 3206 3191 3723 3244 2781 3453 3288 3390 3196 404 502 462 396 455 423 356 296 350 338 362 335 0 0 0 0
NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs
42 CS 750 680 663 740 727 790 888 846 799 806 832 867 733 732 816 760 852 778 735 674 824 576 604 588 604 560 2531 0 0 0 0
wrong results using minvalue/maxvalue in join condition
43 SS 419 382 391 416 473 428 453 515 408 429 420 431 456 502 404 422 443 434 419 392 361 328 294 303 328 306 2250 0 0 0 0
wrong results using minvalue/maxvalue in join condition
44 CS 793 662 634 657 725 695 792 793 796 777 769 831 764 682 729 1916 2070 1792 1775 1685 1916 1382 2502 2483 0 0 0 0 0 0 0
Add AUTO RELEASE TEMP BLOBID transaction option
45 SS 452 425 330 370 446 403 452 421 426 399 452 397 368 496 386 1297 1469 1325 1212 1199 1096 827 2252 2239 0 0 0 0 0 0 0
Add AUTO RELEASE TEMP BLOBID transaction option
46 SS 1195 1013 1030 954 1140 1041 1220 1217 1059 1172 1195 1112 1190 1357 1086 2705 2707 2676 2699 2760 2674 2239 0 0 0 0 0 0 0 0 0
Report unique usernames for isc_info_user_names
47 CS 3071 2993 3007 3066 3058 3103 3076 3197 3188 3158 3162 3196 3101 3136 3120 828 883 791 747 807 898 0 0 0 0 0 0 0 0 0 0
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
48 SS 2664 2657 2664 2664 2789 2660 2779 2740 2748 2711 2629 2691 2696 2775 2726 427 468 438 400 424 432 0 0 0 0 0 0 0 0 0 0
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
49 CS 719 702 656 711 699 756 871 817 847 842 744 920 727 751 776 26 15 15 14 11 19 0 0 0 0 0 0 0 0 0 0
Crash when creating index on table that uses UDR and ParallelWorkers > 1
50 SS 443 387 409 385 445 442 471 469 424 408 391 441 373 595 424 17443 17909 17138 17208 16855 16595 0 0 0 0 0 0 0 0 0 0
Crash when creating index on table that uses UDR and ParallelWorkers > 1
51 SS 15244 12932 13175 13423 16549 15113 17186 17727 17424 17568 16246 16232 18041 15376 18611 9594 9097 9527 9022 8840 9316 0 0 0 0 0 0 0 0 0 0
gbak: Incorrect total statistics for restore
52 CS 8534 6861 6890 7287 7095 8118 9314 9198 8818 8512 8713 8556 8258 8809 9560 42962 43892 47391 3909 2607 2703 0 0 0 0 0 0 0 0 0 0
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
53 SS 8032 6645 6701 7277 7831 7976 9628 8231 8088 7952 7934 8131 8645 9732 8395 26493 25829 26032 2170 2365 2349 0 0 0 0 0 0 0 0 0 0
Make Trace use HEX representation for parameter values of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY
54 SS 2547 2241 2305 2317 2744 2440 2619 2719 2675 2716 2595 2499 3096 3080 2622 437 400 398 1242 0 0 0 0 0 0 0 0 0 0 0 0
Segfault when already destroyed callback interface is used
55 CS 817 0 0 0 0 0 0 0 0 0 797 789 706 737 817 2428 2328 3709 2705 0 0 0 0 0 0 0 0 0 0 0 0
Segmentation fault when running query with partition by and subquery
56 CS 2230 1778 1911 2027 2094 2164 2223 2375 2390 2339 2336 2321 2084 2197 2238 2757 3677 0 0 0 0 0 0 0 0 0 0 0 0 0 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
57 SS 1180 966 938 960 1200 985 1031 1308 1197 1163 1254 1260 1154 1450 1029 3327 2316 0 0 0 0 0 0 0 0 0 0 0 0 0 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
58 CS 777 712 629 678 668 730 813 873 775 798 801 858 774 780 794 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inheritance of WINDOW does not work
59 SS 420 370 379 377 478 329 461 491 428 413 409 453 441 455 359 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inheritance of WINDOW does not work
60 CS 9 7 5 7 9 8 10 8 9 9 574 618 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
61 SS 10 6 9 10 11 6 9 10 8 10 289 241 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
62 CS 732 625 719 627 722 675 732 761 836 777 790 775 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Conversion Error with old.field in UPDATE OR INSERT
63 SS 375 375 355 344 437 356 366 381 467 365 436 462 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Conversion Error with old.field in UPDATE OR INSERT
64 CS 774 646 672 678 682 778 834 836 790 817 774 766 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
65 SS 432 329 379 354 444 387 463 452 432 450 432 427 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement
66 CS 706 727 684 702 706 743 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PERCENT_RANK may return NaN instead of 0
67 SS 406 409 342 373 444 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PERCENT_RANK may return NaN instead of 0
68 CS 706 676 679 734 740 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
69 SS 408 358 405 411 424 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
70 CS 988 868 882 982 1062 1087 1253 1234 1179 1088 1155 1244 1116 1149 1162 1108 1071 995 959 967 1015 739 770 771 781 798 729 737 793 780 814
INNER JOIN join order LIKE and STARTING WITH
71 SS 567 536 638 716 809 709 724 772 804 706 758 854 732 785 711 557 577 619 557 531 555 502 436 482 444 456 456 414 451 495 478
INNER JOIN join order LIKE and STARTING WITH
72 CS 860 881 861 860 890 905 1043 1010 987 972 1041 1017 1013 991 965 858 959 846 781 785 931 617 652 614 695 642 624 627 653 674 701
ORDER BY ASC using index (multi)
73 SS 522 524 536 520 617 555 604 567 601 552 591 594 575 744 615 553 481 527 439 498 432 352 350 357 306 365 337 374 377 379 370
ORDER BY ASC using index (multi)
74 CS 922 828 909 911 837 942 1046 1024 1098 976 1094 1078 1082 901 1184 1072 1027 1050 933 989 1015 750 726 799 745 725 746 758 764 801 788
ORDER BY ASC using index (multi)
75 SS 550 496 501 515 568 551 568 591 630 579 585 560 560 750 774 552 570 549 537 600 563 447 425 452 419 453 435 408 497 471 434
ORDER BY ASC using index (multi)
76 CS 11 717 635 687 831 755 801 853 822 745 829 817 839 808 774 9 10 8 5 7 8 7 4 6 7 5 7 12 9 6 6
ORDER BY ASC using index (multi) and WHERE clause
77 SS 9 419 458 426 515 429 522 492 453 509 471 533 405 667 433 9 10 7 8 8 9 6 7 6 5 7 5 7 5 7 6
ORDER BY ASC using index (multi) and WHERE clause
78 CS 745 680 718 695 775 754 780 842 838 811 847 797 841 737 772 868 780 794 782 724 800 592 572 655 567 499 581 630 588 618 628
ISQL - SHOW SYSTEM TABLES
79 SS 399 370 430 361 485 399 438 395 439 441 429 421 444 505 400 497 427 399 434 414 434 305 316 373 320 316 332 351 364 340 305
ISQL - SHOW SYSTEM TABLES
80 CS 1208 905 984 1102 1088 1129 1208 1367 1238 1317 1305 2294 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Ability to read same blob_id using multiple cursors
81 SS 826 723 684 683 879 743 864 883 836 824 826 2085 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Ability to read same blob_id using multiple cursors
82 CS 1434 1267 1284 1260 1344 1434 1579 1609 1568 1558 1672 1273 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
83 SS 1070 894 994 867 1251 982 1172 1367 1176 1186 1070 770 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Operations with inline streamed blobs when boundary values are used for seek() and read() methods.
84 CS 47650 47552 49877 49728 47318 47103 52611 56165 53054 50745 53171 47749 50475 50360 50470 34906 37174 34965 32370 34664 35780 27040 27677 0 0 0 0 0 0 0 0
Make asynchronous replica re-initialization reliable #8324
85 SS 47116 50114 47002 50132 49613 47230 49956 46617 50551 50553 50843 50694 50997 46826 50510 34671 35156 31666 32251 31753 31808 23582 26433 0 0 0 0 0 0 0 0
Make asynchronous replica re-initialization reliable #8324
86 CS 174312 1471 1520 1603 1595 1623 1802 1830 1807 1596 1776 1885 1846 1794 1717 405388 431273 362977 365115 354287 317811 178556 176816 180575 171808 181481 194450 192180 193229 194275 193538
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
87 SS 175955 1019 976 1018 1147 1081 1093 1183 1071 1080 1170 1182 1086 1373 1032 411086 179039 364065 360746 362390 331814 179619 176212 181790 175699 182188 192466 188410 194723 194220 195183
Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range
88 CS 1264 725 835 769 773 810 989 988 975 917 906 931 880 908 944 1636 1761 1509 1677 1670 1682 1319 1285 1332 1348 1254 1345 1333 1452 1347 1275
Allow computable but non-invariant lists to be used for index lookup
89 SS 895 382 420 428 545 443 557 465 472 479 469 447 436 628 433 1228 1367 1193 1116 1195 1344 999 912 961 907 978 925 884 1006 970 992
Allow computable but non-invariant lists to be used for index lookup
90 SS 44335 6179 5813 6248 6464 3141 6468 6627 6113 6370 6386 6455 5986 6819 6478 51618 48432 49722 50340 50075 49532 44768 44467 45530 44204 45165 45012 45376 45228 45216 45509
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1263
http://tracker.firebirdsql.org/browse/CORE-1802
http://tracker.firebirdsql.org/browse/CORE-203
http://tracker.firebirdsql.org/browse/CORE-2650
http://tracker.firebirdsql.org/browse/CORE-5501
http://tracker.firebirdsql.org/browse/CORE-6279
http://tracker.firebirdsql.org/browse/CORE-733
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_sort_by_index_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_13.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_19.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_02.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/blob/test_small_blob_caching.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_make_async_reinit_reliable.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_333be4bf.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_e260ced8.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_merge_deny_multiple_matches.py
https://github.com/FirebirdSQL/firebird/issues/6220
https://github.com/FirebirdSQL/firebird/issues/6706
https://github.com/FirebirdSQL/firebird/issues/7141
https://github.com/FirebirdSQL/firebird/issues/7269
https://github.com/FirebirdSQL/firebird/issues/7304
https://github.com/FirebirdSQL/firebird/issues/7466
https://github.com/FirebirdSQL/firebird/issues/8085
https://github.com/FirebirdSQL/firebird/issues/8109
https://github.com/FirebirdSQL/firebird/issues/8182
https://github.com/FirebirdSQL/firebird/issues/8185
https://github.com/FirebirdSQL/firebird/issues/8194
https://github.com/FirebirdSQL/firebird/issues/8214
https://github.com/FirebirdSQL/firebird/issues/8263
https://github.com/FirebirdSQL/firebird/issues/8290
https://github.com/FirebirdSQL/firebird/issues/8291
https://github.com/FirebirdSQL/firebird/issues/8304
https://github.com/FirebirdSQL/firebird/issues/8323
https://github.com/FirebirdSQL/firebird/issues/8353
https://github.com/FirebirdSQL/firebird/issues/8356
https://github.com/FirebirdSQL/firebird/issues/8386
https://github.com/FirebirdSQL/firebird/issues/8391
https://github.com/FirebirdSQL/firebird/issues/8394
https://github.com/FirebirdSQL/firebird/issues/8429
https://github.com/FirebirdSQL/firebird/issues/8437
https://github.com/FirebirdSQL/firebird/issues/8462
https://github.com/FirebirdSQL/firebird/issues/8477
https://github.com/FirebirdSQL/firebird/issues/8485
https://github.com/FirebirdSQL/firebird/issues/8508
https://github.com/FirebirdSQL/firebird/issues/8513
https://github.com/FirebirdSQL/firebird/issues/8589
https://github.com/FirebirdSQL/firebird/issues/8592
=== end of list ===

Last commits information (all timestamps in UTC):