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 27.06.2025 12:53
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 1001 1001 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 777 777 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 722 722 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 434 434 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 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
Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.
6 SS 349 349 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 686 686 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 424 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 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 776 776 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 417 417 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 779 779 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 411 411 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 772 772 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 444 444 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 758 758 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 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
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 674 674 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 419 419 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 1983 1983 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 1049 1049 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 1924 1924 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 1107 1107 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 2024 2024 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 1169 1169 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 741 741 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 430 430 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 750 750 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 366 366 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 787 787 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 461 461 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 745 745 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 438 438 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):