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 (4 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 (28 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)
07. Has fails: tests with at least one fail for previous 30 runs (97 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)
[CURRENT] 10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (16 rows)
11. All tests: outcomes for previous 30 runs (2664 rows)
12. Skipped: tests which was intentionally excluded from execution (85 rows)

Generated UTC 26.06.2025 12:45
Tested: HQ50.   Build / date: 5.0.3.1657-4bd4c1f2 / 2025.06.19;
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

Tests with result = "PASSED" after previous outcome = FAIL/ERROR/SKIPPED or absent:

NN Test name mode
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
5.0.2.1489
2024.09.05
Test TITLE
1 ALL P 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 X
Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables.
2 ALL P 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 X
Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option
3 ALL P 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 X
Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.
4 ALL P 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 X
Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used
5 ALL P 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 X
Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option
6 ALL P 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 X
Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option
7 ALL P 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 X
Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used
8 ALL P 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 X
Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option
9 ALL P 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 X
FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null
10 ALL P 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 X
Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration.
11 ALL P 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 X
Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration.
12 ALL P 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 X
Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration.
13 ALL P 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 X
Attempt to change type of any column involved in PK/FK constraints must fail.
14 ALL P 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 X
FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed
15 ALL P 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 X
Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound).
16 ALL P 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 X
FK definition: SET NULL clause should not lead FK-columns to have NULLs.

Elapsed time, milliseconds:

NN Test name mode median_ms
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
5.0.2.1489
2024.09.05
Test TITLE
1 CS 986 986 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 0
Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables.
2 SS 753 753 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 0
Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables.
3 CS 719 719 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 0
Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option
4 SS 556 556 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 0
Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option
5 CS 603 603 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 0
Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.
6 SS 496 496 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 0
Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.
7 CS 699 699 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 0
Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used
8 SS 447 447 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 0
Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used
9 CS 723 723 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 0
Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option
10 SS 431 431 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 0
Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option
11 CS 764 764 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 0
Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option
12 SS 414 414 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 0
Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option
13 CS 692 692 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 0
Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used
14 SS 488 488 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 0
Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used
15 CS 712 712 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 0
Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option
16 SS 493 493 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 0
Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option
17 CS 691 691 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 0
FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null
18 SS 478 478 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 0
FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null
19 CS 1889 1889 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 0
Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration.
20 SS 1051 1051 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 0
Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration.
21 CS 1856 1856 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 0
Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration.
22 SS 1014 1014 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 0
Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration.
23 CS 2035 2035 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 0
Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration.
24 SS 1061 1061 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 0
Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration.
25 CS 789 789 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 0
Attempt to change type of any column involved in PK/FK constraints must fail.
26 SS 453 453 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 0
Attempt to change type of any column involved in PK/FK constraints must fail.
27 CS 806 806 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 0
FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed
28 SS 388 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 0 0
FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed
29 CS 808 808 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 0
Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound).
30 SS 446 446 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 0
Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound).
31 CS 735 735 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 0
FK definition: SET NULL clause should not lead FK-columns to have NULLs.
32 SS 489 489 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 0
FK definition: SET NULL clause should not lead FK-columns to have NULLs.

List of tests in this report:


https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_cascade_recursive_actions.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_pk_delete_if_no_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_pk_on_delete_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_pk_on_update_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_pk_update_if_no_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_uk_delete_if_no_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_uk_on_update_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_uk_update_if_no_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_dml_in_detail_if_no_parent_exists.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_non_priv_user_access_to_child_for_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_non_priv_user_access_to_child_for_set_default.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_non_priv_user_access_to_child_for_set_null.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_prohibit_change_of_key_column_types.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_restrictions_for_default_fk_fields.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_restrictions_for_diff_table_types.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/common/test_restrictions_for_not_null_fk_fields.py
=== end of list ===

Last commits information (all timestamps in UTC):