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

Generated UTC 18.01.2025 04:22
Tested: FB50.   Build / date: 5.0.2.1595-85d825aa / 2025.01.17;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; 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

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

NN Test name mode
5.0.2.1595
2025.01.17
5.0.2.1593
2025.01.16
5.0.2.1592
2025.01.15
5.0.2.1590
2025.01.14
5.0.2.1589
2025.01.13
5.0.2.1585
2025.01.11
5.0.2.1584
2025.01.09
5.0.2.1583
2024.12.23
5.0.2.1582
2024.12.19
5.0.2.1580
2024.12.13
5.0.2.1579
2024.12.12
5.0.2.1577
2024.12.11
5.0.2.1576
2024.12.10
5.0.2.1575
2024.12.08
5.0.2.1571
2024.12.02
5.0.2.1570
2024.11.28
5.0.2.1569
2024.11.27
5.0.2.1569
2024.11.25
5.0.2.1567
2024.11.16
5.0.2.1566
2024.11.15
5.0.2.1565
2024.11.14
5.0.2.1564
2024.11.12
5.0.2.1561
2024.11.08
5.0.2.1560
2024.11.08
5.0.2.1560
2024.11.07
5.0.2.1555
2024.11.06
5.0.2.1553
2024.11.04
5.0.2.1551
2024.10.30
5.0.2.1550
2024.10.29
5.0.2.1547
2024.10.24
Test TITLE
1 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 P F P P P
Count (DISTINCT ...) is too slow
2 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 F P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 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 F P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
4 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 F P P P P
Include PLAN in mon$statements
5 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 F P P P P
Include PLAN in mon$statements
6 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 F P P P P
Introducer (_charset) problems with monitoring and persistent modules
7 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 F P P P P
Introducer (_charset) problems with monitoring and persistent modules
8 CS P P F 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
Improve sorting performance when long VARCHARs are involved
9 SS P P F 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
Improve sorting performance when long VARCHARs are involved
10 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 P P P F P
Lookup (or scan) in descending index could be very inefficient for some keys
11 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 P P P F P
Lookup (or scan) in descending index could be very inefficient for some keys
12 SS P 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
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
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 F P P P P
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
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 F P P P P
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
15 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 P P P F P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
16 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 P P P F P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
17 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 P P P F P
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
18 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 P P P F P
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
19 CS 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 P P P
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
20 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 F P P P P
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
21 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 F P P P P
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
22 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 F P P P P
Bugcheck on queries containing WITH LOCK clause
23 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 F P P P P
Bugcheck on queries containing WITH LOCK clause
24 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 F P P P P
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
25 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 F P P P P
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
26 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
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
27 CS 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 P
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
28 SS 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 P
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
29 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 F P P P P
International characters in table or alias names causes queries of MON$STATEMENTS to fail
30 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 F P P P P
International characters in table or alias names causes queries of MON$STATEMENTS to fail
31 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 F P P P P
garbage collection in indexes and blobs is not performed in VIO_backout
32 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 F P P P P
garbage collection in indexes and blobs is not performed in VIO_backout
33 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 F P P P P
The access path information is truncated to 255 characters in the PLG$PROF_RECORD_SOURCES table
34 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 F P P P P
The access path information is truncated to 255 characters in the PLG$PROF_RECORD_SOURCES table
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 F F P P P P
Improve SKIP LOCKED implementation
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 F F P P P P
Improve SKIP LOCKED implementation
37 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 P P P F P
Cardinality estimation should use primary record versions only
38 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 P P P F P
Cardinality estimation should use primary record versions only
39 CS P P P P F F F F F F F F F F F F F F F F F F F F F F F F X X
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
40 SS P P P P F F F F F F F F F F F F F F F F F F F F F F F F X X
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
41 CS 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 X F X
Ability to obtain PID of server process for current connection without querying mon$ tables
42 SS 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 X F X
Ability to obtain PID of server process for current connection without querying mon$ tables
43 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 P P P F P
INNER JOIN join order LIKE and STARTING WITH
44 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 P P P F P
INNER JOIN join order LIKE and STARTING WITH
45 CS P P P P P P P P P P P P P P P P P P P F F P P P P P P P P P
Check output of "HELP" and "HELP SET" commands
46 SS P P P P P P P P P P P P P P P P P P P F F P P P P P P P P P
Check output of "HELP" and "HELP SET" commands
47 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 F P P P P
List function with distinct option
48 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 F P P P P
List function with distinct option
49 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 F P P P P
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
50 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 F P P P P
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
51 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 P P P F P
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
52 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 P P P F P
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
53 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 F P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
54 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 F P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
55 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 F P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
56 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 F P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
57 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 F P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
58 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 F P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
59 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 F P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
60 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 F P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
61 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
62 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
63 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
64 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
65 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
66 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
67 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
68 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
69 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
70 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
71 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
72 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
73 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
74 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
75 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
76 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
77 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
78 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
79 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
80 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
81 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
82 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
83 CS P P P P F P P P P P P P P P P P P P P P P P P P F F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
84 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 F P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
85 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 F P P P P
gbak utility: check ability to use -ZIP command switch when create backup
86 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 F P P P P
gbak utility: check ability to use -ZIP command switch when create backup

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.2.1595
2025.01.17
5.0.2.1593
2025.01.16
5.0.2.1592
2025.01.15
5.0.2.1590
2025.01.14
5.0.2.1589
2025.01.13
5.0.2.1585
2025.01.11
5.0.2.1584
2025.01.09
5.0.2.1583
2024.12.23
5.0.2.1582
2024.12.19
5.0.2.1580
2024.12.13
5.0.2.1579
2024.12.12
5.0.2.1577
2024.12.11
5.0.2.1576
2024.12.10
5.0.2.1575
2024.12.08
5.0.2.1571
2024.12.02
5.0.2.1570
2024.11.28
5.0.2.1569
2024.11.27
5.0.2.1569
2024.11.25
5.0.2.1567
2024.11.16
5.0.2.1566
2024.11.15
5.0.2.1565
2024.11.14
5.0.2.1564
2024.11.12
5.0.2.1561
2024.11.08
5.0.2.1560
2024.11.08
5.0.2.1560
2024.11.07
5.0.2.1555
2024.11.06
5.0.2.1553
2024.11.04
5.0.2.1551
2024.10.30
5.0.2.1550
2024.10.29
5.0.2.1547
2024.10.24
Test TITLE
1 CS 17532 17454 17610 17614 18385 18212 18043 18696 17912 17959 17667 17700 17744 18430 18770 17862 17900 2030 2231 2147 2015 2048 2004 2072 1985 2135 2000 2532 2020 1994 2042
Count (DISTINCT ...) is too slow
2 CS 1360 1266 1351 1385 1379 1361 1426 1365 1357 1354 1357 1370 1366 1373 1366 1366 1351 1354 1359 1354 1266 1416 1359 1356 1282 1222 1233 1415 1429 1373 1375
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 SS 1010 922 1062 1000 1007 1010 1066 1037 1017 1007 1015 1039 1006 1006 1019 1005 1013 1006 1004 1001 922 1015 1026 1038 1031 930 932 1008 1049 1053 1010
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
4 CS 482 469 481 478 485 477 630 514 483 479 487 483 482 480 481 482 480 476 498 480 469 483 477 479 484 885 848 485 496 482 483
Include PLAN in mon$statements
5 SS 278 266 286 279 274 274 312 300 268 282 278 311 311 269 280 274 276 284 277 274 266 279 269 289 266 620 656 277 276 295 281
Include PLAN in mon$statements
6 CS 549 547 542 547 553 544 553 552 548 549 564 581 577 544 550 554 548 544 549 546 547 552 579 544 546 918 910 547 541 560 550
Introducer (_charset) problems with monitoring and persistent modules
7 SS 297 282 292 297 294 309 333 333 293 299 297 300 295 303 300 302 297 305 295 291 282 298 291 297 297 626 632 293 303 299 294
Introducer (_charset) problems with monitoring and persistent modules
8 CS 773 719 757 1167 1129 1123 764 770 770 795 771 793 788 800 835 774 765 772 799 764 766 762 793 766 750 766 779 766 805 784 776
Improve sorting performance when long VARCHARs are involved
9 SS 476 453 467 814 1050 826 525 515 472 473 468 471 469 479 493 471 492 473 490 477 469 504 476 472 469 483 482 478 470 472 485
Improve sorting performance when long VARCHARs are involved
10 CS 809 782 805 856 809 807 871 802 801 809 813 842 812 827 800 802 893 851 801 850 781 804 796 804 781 836 798 838 893 1154 813
Lookup (or scan) in descending index could be very inefficient for some keys
11 SS 593 563 581 605 594 600 599 599 594 599 610 609 592 580 580 595 592 598 590 582 578 584 595 596 578 580 574 588 586 1205 596
Lookup (or scan) in descending index could be very inefficient for some keys
12 SS 11483 12732 12851 11286 11788 11310 11317 11849 11704 12374 11440 11154 11234 11355 85780 11924 11386 11602 13032 13214 11120 11062 13298 11364 11000 11787 11526 11206 10986 11395 13047
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
13 CS 1058 969 1037 1073 1078 1066 1055 1079 1052 1045 1060 1091 1055 1075 1071 1047 1116 1035 1085 1084 1000 1044 1134 1052 969 852 842 1079 1056 1067 1082
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
14 SS 714 672 708 727 726 709 703 702 694 696 744 735 740 705 745 741 910 729 719 720 672 715 710 755 656 539 573 693 726 723 714
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
15 CS 1059 1000 1058 1043 1099 1084 1060 1051 1084 1051 1041 1061 1052 1077 1062 1077 1056 1034 1064 1071 1015 1032 1066 1055 1015 1033 1089 1076 1054 1070 1069
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
16 SS 703 671 709 749 696 709 700 715 701 702 732 746 732 710 693 722 701 695 705 698 671 717 707 747 672 702 699 702 702 954 789
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
17 CS 3240 3208 3309 3249 3201 3323 3227 3286 3253 3272 3312 3303 3228 3231 3251 3234 3241 3219 3300 3234 3168 3213 3235 3240 3175 3280 3252 3244 3221 3289 3238
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
18 SS 2730 2680 2732 2737 2719 2726 2723 2737 2730 2738 2740 3136 2738 2744 2742 2722 2740 2714 2760 2730 2681 2730 2727 2759 2682 2694 2717 2705 2715 2747 2733
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
19 CS 3062 3078 3065 3047 3054 3068 3059 3090 3051 3067 3056 3066 3066 3087 3060 3049 3090 3052 3058 3078 3031 3055 3850 3057 3046 3056 3066 3100 3076 3068 3058
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
20 CS 6517 6219 6567 6621 6522 6490 6526 6763 6506 6499 6500 6515 6498 6556 6498 6597 6841 6517 6610 6529 5969 6906 6473 6465 6126 900 860 6518 6553 6672 6629
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
21 SS 4581 4235 4717 4544 4592 4540 4791 4630 4553 4562 4597 4733 4562 4521 4674 4566 4514 4582 4617 4545 4219 4633 4581 4751 4234 587 597 4693 4712 4665 4635
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
22 CS 1858 1797 1978 1852 1880 1874 1856 1915 1892 1895 1823 1831 1860 1817 1851 1874 2130 1848 1877 1874 1703 1896 1902 1830 1813 860 830 1825 1867 1856 1900
Bugcheck on queries containing WITH LOCK clause
23 SS 1218 1157 1200 1198 1251 1208 1224 1278 1223 1224 1195 1280 1227 1199 1825 1230 1224 1195 1214 1240 1157 1240 1205 1261 1156 564 576 1207 1201 1239 1267
Bugcheck on queries containing WITH LOCK clause
24 CS 1961 1844 2065 1978 1969 1968 2088 2071 1949 1970 1959 2177 1956 1974 1958 1946 2038 1943 1961 1967 1812 1961 1939 1947 1860 1183 1200 1968 1955 2019 1973
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
25 SS 1371 1297 1368 1383 1468 1350 1352 1388 1387 1414 1352 1383 1360 1355 1572 1350 1375 1358 1362 1385 1281 1381 1409 1349 1282 867 886 1381 1378 1377 1409
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
26 CS 3317 3172 3303 3319 3671 3315 3345 3692 3344 3386 3316 3429 3357 3417 3271 3240 3268 3316 3258 3385 3578 3336 3276 3285 3297 3416 3308 3305 3307 3435 3339
Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
27 CS 21661 22969 21693 21637 21647 21681 22011 21932 21644 21658 21662 21668 21656 21685 21636 21645 21654 21664 21670 21649 22625 21660 21657 21651 21641 21655 21643 21668 21670 21709 21683
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
28 SS 21446 21422 21445 21472 21473 21447 21434 21440 21464 21450 21443 21457 21446 21426 21650 21451 21442 21433 21444 21462 22391 21426 21464 21433 22734 21454 21461 21433 21427 21459 21425
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
29 CS 522 515 523 530 511 521 571 511 522 517 515 520 537 526 518 521 525 519 549 520 500 516 528 523 515 735 728 526 533 538 538
International characters in table or alias names causes queries of MON$STATEMENTS to fail
30 SS 322 312 311 336 321 314 331 329 337 339 343 379 324 384 311 321 327 313 311 318 312 310 307 309 312 656 667 317 340 325 342
International characters in table or alias names causes queries of MON$STATEMENTS to fail
31 CS 989 953 993 974 973 975 1051 1015 974 994 982 984 1011 981 983 997 1031 1025 982 994 969 1035 963 981 969 1254 1245 1005 1046 1003 986
garbage collection in indexes and blobs is not performed in VIO_backout
32 SS 617 625 617 624 625 619 597 602 635 633 617 621 624 613 605 604 647 599 618 616 610 603 623 605 609 760 794 608 607 618 632
garbage collection in indexes and blobs is not performed in VIO_backout
33 CS 568 547 562 569 567 565 585 559 568 560 565 561 574 570 571 570 601 583 566 569 547 576 567 573 563 965 947 560 568 568 568
The access path information is truncated to 255 characters in the PLG$PROF_RECORD_SOURCES table
34 SS 358 360 357 353 364 359 353 354 373 358 351 358 355 351 367 355 375 355 360 387 359 361 356 354 360 720 745 352 352 390 364
The access path information is truncated to 255 characters in the PLG$PROF_RECORD_SOURCES table
35 CS 1204 1172 1219 1187 1190 1209 1272 1305 1204 1193 1202 1199 1202 1198 1204 1257 1213 1185 1241 1184 1172 1230 1244 1226 1187 1084 1061 1314 1331 1323 1329
Improve SKIP LOCKED implementation
36 SS 863 828 867 854 846 855 853 857 850 900 845 932 900 859 872 857 908 928 851 941 844 858 880 855 843 883 1171 936 958 994 1086
Improve SKIP LOCKED implementation
37 CS 967 922 968 969 967 1066 975 1061 973 956 974 967 952 961 950 970 962 962 961 991 921 973 1120 955 938 974 952 957 954 982 970
Cardinality estimation should use primary record versions only
38 SS 742 719 740 745 744 742 823 742 742 748 778 783 744 740 728 736 739 731 727 746 719 745 726 744 703 733 773 754 744 772 743
Cardinality estimation should use primary record versions only
39 CS 1096 656 676 688 695 708 1051 1041 1030 1177 1179 1191 1181 1168 1805 1181 1181 1186 1188 1215 828 1276 713 1183 1141 711 696 844 1044 0 0
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
40 SS 825 453 468 457 471 491 1085 1140 831 1066 852 916 822 1071 539 1054 831 826 812 825 797 1050 904 859 469 489 743 812 1054 0 0
SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor
41 CS 590 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 0 590 0
Ability to obtain PID of server process for current connection without querying mon$ tables
42 SS 397 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 0 397 0
Ability to obtain PID of server process for current connection without querying mon$ tables
43 CS 737 719 775 736 760 767 743 769 761 732 737 734 734 733 767 735 739 765 737 766 719 743 730 731 734 728 735 757 729 920 739
INNER JOIN join order LIKE and STARTING WITH
44 SS 489 469 490 485 488 485 533 525 497 485 482 499 505 487 487 492 487 492 488 489 469 487 487 494 469 503 536 496 491 509 489
INNER JOIN join order LIKE and STARTING WITH
45 CS 591 562 592 611 577 631 591 617 579 618 591 594 621 612 615 626 623 586 709 581 578 621 583 584 578 584 622 582 623 582 590
Check output of "HELP" and "HELP SET" commands
46 SS 385 375 381 369 383 382 390 399 390 388 386 387 386 370 382 385 386 372 393 383 375 419 385 400 375 397 398 375 385 391 382
Check output of "HELP" and "HELP SET" commands
47 CS 484 469 485 476 489 484 520 487 480 488 487 481 486 480 489 480 477 533 487 481 484 482 478 476 485 951 1067 476 481 496 495
List function with distinct option
48 SS 282 266 282 283 287 278 282 277 274 277 276 285 285 274 293 287 285 289 281 286 265 300 291 369 281 729 715 280 279 275 274
List function with distinct option
49 CS 1153 1126 1165 1144 1139 1155 1153 1224 1187 1153 1153 1151 1152 1149 1202 1153 1142 1146 1204 1141 1281 1317 1160 1248 1140 967 948 1329 1155 1175 1167
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
50 SS 664 656 651 658 653 666 732 722 663 666 662 723 658 664 742 678 691 677 657 735 656 665 676 657 656 699 693 666 648 659 656
Scrollable cursors. Fixed isBof/isEof when the prefetch is active
51 CS 1305 1250 1297 1303 1302 1342 1327 1327 1312 1323 1264 1317 1299 1340 1362 1305 1259 1313 1330 1313 1203 1289 1338 1301 1250 1306 1305 1289 1262 1325 1329
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
52 SS 876 828 892 869 877 873 916 902 876 901 872 912 947 875 920 887 875 874 870 876 843 869 884 861 844 889 881 900 868 899 879
Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW
53 CS 6282 8174 6260 6273 6267 6292 6268 6370 7280 6276 6227 6277 6484 6236 6326 6272 6256 6288 7300 7367 7169 7242 6294 6292 6192 3621 3621 6250 6260 6300 6421
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
54 SS 5902 5795 5891 5901 5938 5937 6068 5972 5918 5937 5904 5988 5917 5890 5938 5920 5895 5897 5871 5914 5811 5896 5900 5970 5801 3377 3357 5915 5876 5897 5955
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
55 CS 6267 7122 6205 6220 6278 6253 6202 6228 6289 7257 6233 6257 6224 6212 7804 6219 6204 7231 6763 7225 7148 6225 7302 7236 8117 3797 3793 7218 6247 7248 7217
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
56 SS 5854 5745 5859 5844 5876 5835 5866 5933 5880 5861 5852 5892 5838 5862 6364 5897 5860 5866 5852 5843 5782 5875 5851 5837 5765 3997 3572 5831 5843 5856 5860
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
57 CS 6289 7222 6309 6277 6300 6275 6290 6281 6717 6304 6286 6514 6335 6238 6316 6243 6279 6289 6331 6276 7159 6240 6296 6306 7207 3615 3658 6253 6288 6311 6271
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
58 SS 5949 5828 5981 5940 5960 5944 5936 5984 5917 6004 5979 5966 5963 5925 5961 5972 5945 5997 5948 5950 5829 5960 5948 5924 5830 3339 3638 5953 5975 5951 5922
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
59 CS 44733 43749 44768 44643 44588 44807 44707 44818 45093 44799 44643 45202 45358 44737 45702 45082 44638 44837 46570 45674 44371 44698 44729 44579 44089 3901 3857 44717 44662 44892 45854
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
60 SS 41740 41098 41638 41740 41910 41646 41878 43168 41979 41832 41603 42029 41740 41724 43830 41549 41697 41639 41832 42061 41299 42767 41780 41544 43375 3689 3367 42068 41598 41822 41693
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
61 CS 6767 8097 6225 7237 6248 7229 7236 6231 7230 6250 6228 6246 7227 6241 7832 6221 7296 6262 6253 7470 8137 7288 7288 6262 8122 3660 3620 6249 7243 6307 7717
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
62 SS 5882 5795 5884 5886 5930 5878 5900 6201 5878 5887 5889 5937 5868 5899 6000 5844 5855 5880 5857 5888 6012 6102 5848 5859 5765 3527 3516 5894 5855 5869 5890
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
63 CS 6263 7159 6231 6221 6251 6243 7220 6230 6286 7204 6245 6311 7226 6235 6254 6440 7240 6244 6269 6218 7169 6266 6213 6212 7150 3829 3788 7224 6261 6293 7285
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
64 SS 5882 5780 5874 5870 5934 5929 5872 6588 5878 5903 5880 6318 5875 5885 5912 5913 5883 6030 5863 6214 5805 5918 5881 5900 5767 3345 3335 5903 5860 5874 5890
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
65 CS 7208 8576 6685 8714 7666 7746 6692 7694 6714 7694 6703 6759 7702 6725 7690 6729 7674 6687 6752 6666 8531 6725 8636 6725 8573 4042 4018 7657 7701 6723 8971
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
66 SS 6177 6095 6190 6170 6228 6169 6198 6166 6234 6206 6165 6776 6197 6253 6315 6225 6175 6154 6191 6166 6108 6207 6148 6196 6077 3665 3638 6176 6178 6169 6193
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
67 CS 7174 7136 7248 6220 6219 7272 7265 6212 7255 6236 7214 7308 6270 6229 7244 6230 7293 6269 6838 6257 8134 6235 7236 7212 8158 3620 3640 7248 6205 7226 7297
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
68 SS 5886 5776 5890 5891 5878 5871 5882 6091 5867 5954 5905 5930 5865 5891 5925 5873 5877 5910 6228 6125 5794 6292 5865 5871 5762 3350 3796 5904 5939 5876 5899
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
69 CS 6376 7116 7257 6225 6235 7251 6204 6216 6233 6284 7244 6207 7231 6198 6216 6460 6220 7262 8292 7240 7136 7208 6218 7319 7150 3772 3818 6292 6232 7242 6697
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
70 SS 5856 5809 5845 5846 5873 5843 5877 6265 5876 5884 5847 5893 5857 5860 5866 5867 5850 5862 6853 5850 5731 6688 5848 5867 5782 3515 3774 5894 5839 5855 5849
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
71 CS 6269 8151 7271 6215 6268 6269 6265 6284 6326 6328 6245 7238 6241 6270 6263 6263 6223 6226 6271 7276 7143 6286 6306 6215 7175 3647 3797 6293 6255 6247 6311
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
72 SS 5883 5746 5883 5882 6155 5866 5889 6237 5880 5882 5885 5918 5877 5883 5879 5892 5868 5874 5885 5902 5793 5882 5897 5886 5939 3332 3506 5892 5875 5907 5886
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
73 CS 6710 8565 6703 6662 6661 7668 7681 6679 6664 8703 7765 6714 7745 8699 6652 6706 6681 6727 7718 6657 8529 6691 7657 6688 8522 3998 4035 6695 7710 6685 9072
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
74 SS 6189 6092 6180 6183 6194 6185 6199 6248 6165 6213 6188 6245 6187 6213 6221 6191 6156 6199 6524 6193 6107 6708 6179 6192 6113 3701 3603 6504 6176 6185 6190
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
75 CS 6288 7164 6254 6249 6226 7260 6240 6246 6292 7249 7213 7232 6237 7261 6242 7259 7219 6241 6410 6370 8323 6284 7249 6254 8151 3629 3626 6227 6265 6274 7517
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
76 SS 5881 5764 5874 5874 6104 5883 5891 5903 5867 5910 6880 5999 5868 5898 5963 5863 5862 5865 5879 6895 5810 7005 5871 5903 5766 3537 3499 5884 5877 5893 5885
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
77 CS 6941 6185 6278 7278 7325 6237 7310 7221 7455 6233 6208 7229 7303 7259 6284 6247 6254 6229 7286 6238 8151 7206 6236 7243 8150 3797 3795 6677 6282 7261 7734
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
78 SS 5872 5779 5864 5908 5881 5869 5917 6343 5868 5943 5854 6329 5864 5863 5872 5922 5877 5863 6190 6865 5779 5952 5873 5858 6173 3333 3546 6266 5862 5929 5859
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
79 CS 6275 7188 6371 6228 7217 6272 6246 7271 6254 6265 7235 7372 6345 6251 7289 6252 6278 6251 6295 6306 6163 6309 6235 6255 7164 3799 3830 6270 6247 7279 7297
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
80 SS 5887 5827 5880 5893 6224 5888 5910 6204 5871 5873 6356 6640 5897 5882 5907 5887 5906 5892 5883 5887 5807 6108 5886 5873 5811 3552 3395 7167 5898 5892 5877
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
81 CS 7906 8257 7556 8366 8416 8367 8319 8347 8342 8325 8328 8330 8383 8397 8353 8628 7318 7320 7332 8539 7148 6360 6284 6305 6196 3617 3640 6292 6295 6356 6619
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
82 SS 5929 6061 6163 5982 5845 5915 6953 7193 5938 5949 6723 6733 5929 5925 5705 5922 5930 6918 6417 6118 5794 5974 5902 5920 5796 3411 3532 5948 5899 5902 5894
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
83 CS 6711 7169 6263 6204 6213 7974 6217 7220 7325 6240 8271 8344 6240 6227 7430 6278 6251 6245 7880 7407 7152 7287 7262 6195 7144 3798 3785 6271 7222 6224 7316
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
84 SS 5873 5780 5868 5883 5875 5861 5911 6197 5887 5865 6874 6311 5894 5885 6160 5865 5879 6876 5865 5864 5812 6076 5871 5870 5810 3586 3354 5849 5871 6042 5883
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
85 CS 5532 5321 5500 5728 5525 5588 6015 5637 5601 5509 6215 5740 5562 5512 5589 5518 5518 5712 5524 5566 5230 5540 5509 5498 5329 3581 3581 5554 5512 5562 6546
gbak utility: check ability to use -ZIP command switch when create backup
86 SS 4471 4315 4481 4476 4466 4471 4469 4606 4456 4471 4474 4640 4471 4464 4490 4452 4542 4803 4692 4515 4329 4583 4482 4427 4329 3068 3070 4471 4463 4576 4452
gbak utility: check ability to use -ZIP command switch when create backup

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1725
http://tracker.firebirdsql.org/browse/CORE-214
http://tracker.firebirdsql.org/browse/CORE-2303
http://tracker.firebirdsql.org/browse/CORE-2607
http://tracker.firebirdsql.org/browse/CORE-2650
http://tracker.firebirdsql.org/browse/CORE-4302
http://tracker.firebirdsql.org/browse/CORE-4337
http://tracker.firebirdsql.org/browse/CORE-4928
http://tracker.firebirdsql.org/browse/CORE-5018
http://tracker.firebirdsql.org/browse/CORE-5441
http://tracker.firebirdsql.org/browse/CORE-5488
http://tracker.firebirdsql.org/browse/CORE-5538
http://tracker.firebirdsql.org/browse/CORE-5576
http://tracker.firebirdsql.org/browse/CORE-5833
http://tracker.firebirdsql.org/browse/CORE-6142
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/basic/isql/test_00.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/list/test_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_90129c6d.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_eqc_343715.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_statement_delete_undone_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_statement_delete_undone_02.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-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_max_limit.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/util/test_gbak_zip.py
https://github.com/FirebirdSQL/firebird/issues/6802
https://github.com/FirebirdSQL/firebird/issues/7045
https://github.com/FirebirdSQL/firebird/issues/7747
https://github.com/FirebirdSQL/firebird/issues/7752
https://github.com/FirebirdSQL/firebird/issues/7810
https://github.com/FirebirdSQL/firebird/issues/8161
https://github.com/FirebirdSQL/firebird/issues/8185
https://github.com/FirebirdSQL/firebird/issues/8230
=== end of list ===

Last commits information (all timestamps in UTC):