nix-4x new_passed

0. Total results for each kind of outcome and server mode, for previous 30 runs
1. CRASHES/BUGCHECKS: tests that caused Firebird process abend for previous 30 runs (0 rows)
2. FRESH FAILS: tests which failed for LAST execution only (3 rows)
3. FRESH ERRORS: tests which raised runtime error for LAST execution only (10 rows)
4. STILL FAILS: tests which fail for at least TWO LAST runs (7 rows)
5. Has fails: tests with at least one fail for previous 30 runs (64 rows)
6. Has runtime errors: tests with at least one runtime error for previous 30 runs (17 rows)
[CURRENT] 7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (6 rows)
8. All tests: outcomes for previous 30 runs (2343 rows)
9. All tests: durations for previous 30 runs (4576 rows)
A. Skipped: tests which was intentionally excluded from execution (55 rows)

Generated 23.03.2023 02:01
Tested: FB40. Build: 4.0.3.2913; SS: 23.03.23 00:02:00 - 23.03.23 00:56:09; CS: 23.03.23 00:57:45 - 23.03.23 01:59:26;
OS and hardware info: Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb
QA-software: Python 3.10.9, virtual env; pytest: 7.2.1; firebird.driver: 1.8.0; Firebird.Qa: 0.17.2

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

NN Test name mode 4.0.3.2913
2023-03-23 4.0.3.2911
2023-03-22 4.0.3.2909
2023-03-17 4.0.3.2908
2023-03-14 4.0.3.2907
2023-03-10 4.0.3.2906
2023-03-08 4.0.3.2905
2023-03-04 4.0.3.2904
2023-03-03 4.0.3.2903
2023-02-27 4.0.3.2902
2023-02-18 4.0.3.2900
2023-02-14 4.0.3.2899
2023-02-09 4.0.3.2898
2023-02-08 4.0.3.2895
2023-02-05 4.0.3.2891
2023-01-24 4.0.3.2890
2023-01-17 4.0.3.2887
2023-01-12 4.0.3.2885
2023-01-18 4.0.3.2882
2023-01-18 4.0.3.2878
2023-01-05 4.0.3.2873
2023-01-06 4.0.3.2863
2023-01-03 X X X X X X X X
Test TITLE

1
bugs core 5667

tracker
SS P     E     P P P P P P P P P P P P P P P P P P P P X X X X X X X X
Regression in 3.0+: message CTE 'X' has cyclic dependencies appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query

2
bugs gh 7200

tracker
SS P     F     P P P P P P X X X X X X X X X X X X X X X X X X X X X X
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress

3
functional transactions read consist sttm restart on delete 04
CS P     F     P     F     P P P     F         F     P P P P P     F         F     P     F         F     P     F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.

4
functional transactions read consist sttm restart on merge 04
CS P     F     P P     F     P     F         F     P P     F         F         F     P     F     P     F         F         F         F         F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.

5
functional transactions read consist sttm restart on merge 04
SS P     F     P P     F     P P P     F     P     F         F     P P     F         F         F         F         F     P     F     P X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.

6
functional transactions read consist sttm restart on update 04
CS P     F     P     F     P     F     P P     F     P P P     F         F     P     F         F     P P P     F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

Elapsed time, milliseconds:

NN Test name mode median_ms 4.0.3.2913
2023-03-23 4.0.3.2911
2023-03-22 4.0.3.2909
2023-03-17 4.0.3.2908
2023-03-14 4.0.3.2907
2023-03-10 4.0.3.2906
2023-03-08 4.0.3.2905
2023-03-04 4.0.3.2904
2023-03-03 4.0.3.2903
2023-02-27 4.0.3.2902
2023-02-18 4.0.3.2900
2023-02-14 4.0.3.2899
2023-02-09 4.0.3.2898
2023-02-08 4.0.3.2895
2023-02-05 4.0.3.2891
2023-01-24 4.0.3.2890
2023-01-17 4.0.3.2887
2023-01-12 4.0.3.2885
2023-01-18 4.0.3.2882
2023-01-18 4.0.3.2878
2023-01-05 4.0.3.2873
2023-01-06 4.0.3.2863
2023-01-03 X X X X X X X X
Test TITLE

1
bugs core 5667

tracker
SS 372 244 66 252 312 267 270 246 250 272 260 402 432 412 378 392 376 369 406 392 422 387 380 0 0 0 0 0 0 0 0
Regression in 3.0+: message CTE 'X' has cyclic dependencies appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query

2
bugs gh 7200

tracker
SS 4119 4051 4186 4209 4048 4177 4109 4130 3033 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress

3
functional transactions read consist sttm restart on delete 04
CS 3783 3646 3662 3533 3678 3542 3697 3620 3781 3712 3656 3816 3925 3966 3701 3794 3848 3860 3786 3869 3889 3862 3954 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.

4
functional transactions read consist sttm restart on merge 04
CS 3791 3664 3767 3561 3573 3615 3660 3627 3776 3556 3541 3895 3907 3890 4070 3773 3810 3847 3847 3807 3907 3914 3932 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.

5
functional transactions read consist sttm restart on merge 04
SS 3188 3282 3325 3196 3210 3205 3285 3181 3181 3153 3226 3408 3433 3385 3459 3121 3118 3129 3117 3136 3079 3163 3142 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.

6
functional transactions read consist sttm restart on update 04
CS 3779 3651 3680 3631 3604 3510 3596 3736 3719 3648 3622 3822 3844 3945 4523 3835 3820 3845 3782 3776 3961 3910 3922 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

List of tests in this report:

http://tracker.firebirdsql.org/browse/core-5667
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_04.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/issues/7200

=== end of list ===

NN	Test name	mode	4.0.3.2913 2023-03-23	4.0.3.2911 2023-03-22	4.0.3.2909 2023-03-17	4.0.3.2908 2023-03-14	4.0.3.2907 2023-03-10	4.0.3.2906 2023-03-08	4.0.3.2905 2023-03-04	4.0.3.2904 2023-03-03	4.0.3.2903 2023-02-27	4.0.3.2902 2023-02-18	4.0.3.2900 2023-02-14	4.0.3.2899 2023-02-09	4.0.3.2898 2023-02-08	4.0.3.2895 2023-02-05	4.0.3.2891 2023-01-24	4.0.3.2890 2023-01-17	4.0.3.2887 2023-01-12	4.0.3.2885 2023-01-18	4.0.3.2882 2023-01-18	4.0.3.2878 2023-01-05	4.0.3.2873 2023-01-06	4.0.3.2863 2023-01-03	X	X	X	X	X	X	X	X	Test TITLE
1	bugs core 5667 tracker	SS	P	E	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	X	X	X	X	X	X	X	X	Regression in 3.0+: message CTE 'X' has cyclic dependencies appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query
2	bugs gh 7200 tracker	SS	P	F	P	P	P	P	P	P	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
3	functional transactions read consist sttm restart on delete 04	CS	P	F	P	F	P	P	P	F	F	P	P	P	P	P	F	F	P	F	F	P	F	F	X	X	X	X	X	X	X	X	READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
4	functional transactions read consist sttm restart on merge 04	CS	P	F	P	P	F	P	F	F	P	P	F	F	F	P	F	P	F	F	F	F	F	F	X	X	X	X	X	X	X	X	READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
5	functional transactions read consist sttm restart on merge 04	SS	P	F	P	P	F	P	P	P	F	P	F	F	P	P	F	F	F	F	F	P	F	P	X	X	X	X	X	X	X	X	READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
6	functional transactions read consist sttm restart on update 04	CS	P	F	P	F	P	F	P	P	F	P	P	P	F	F	P	F	F	P	P	P	F	F	X	X	X	X	X	X	X	X	READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.