win-3x fb-errors-map

0. Total results for each kind of outcome and server mode
[CURRENT] 1. ERRORS MAP: distribution of Firebird errors which occured during runs (14 rows)
2. FRESH FAILS: tests which failed for LAST execution only (0 rows)
3. FRESH ERRORS: tests which raised run-time error for LAST execution only (0 rows)
4. STILL FAILS: tests which fail for at least two last runs (1 rows)
5. Has fails: tests with at least one fail for previous runs (44 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (4 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (1966 rows)
9. All tests: durations (3874 rows)
A. Skipped: tests which was intentionally excluded from execution (5 rows)

Generated 01.10.2022 13:40
Tested: HQ30. Build: 3.0.11.33631; CS: 01.10.22 12:54:46 - 01.10.22 13:38:53; SS: 01.10.22 12:16:24 - 01.10.22 12:53:16;
OS and hardware info: Windows 10 10.0.19041 ; logical CPUs: 8 ; total memory: 31.7 Gb

Standard Firebird errors during runs

NN FB-related errors Test name mode 3.0.11.33631
2022-10-01 3.0.11.33622
2022-09-10 3.0.11.33621
2022-09-07 3.0.11.33620
2022-09-05 3.0.11.33618
2022-08-23 3.0.11.33616
2022-08-17 3.0.11.33612
2022-07-31 3.0.10.33601
2022-07-17 3.0.10.33587
2022-06-04 3.0.10.33580
2022-04-30 3.0.10.33577
2022-04-25 3.0.10.33570
2022-04-17 3.0.10.33569
2022-02-25 3.0.9.33561
2022-02-22 3.0.9.33560
2022-02-13 3.0.9.33556
2022-02-09 3.0.9.33548
2022-01-12 3.0.8.33540
2021-12-20 3.0.8.33533
2021-12-01 3.0.8.33528
2021-11-08 3.0.8.33501
2021-10-31 3.0.8.33490
2021-09-22 3.0.8.33489
2021-08-10 3.0.8.33488
2021-08-07 3.0.8.33487
2021-07-31 3.0.8.33475
2021-07-20 3.0.8.33472
2021-06-18 3.0.8.33471
2021-06-09 3.0.8.33470
2021-06-02 3.0.8.33468
2021-05-29
Test TITLE

1 SQLERR 340 : cannot create index; no_meta_update; idx_create_err
bugs gh 3886

tracker
CS 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 X X
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]

2 SQLERR 340 : cannot create index; no_meta_update; idx_create_err
bugs gh 3886

tracker
SS 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 X X
recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]

3 SQLERR 340 : cannot create index; no_meta_update; idx_create_err
bugs gh 5082

tracker
CS 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 X X
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]

4 SQLERR 340 : cannot create index; no_meta_update; idx_create_err
bugs gh 5082

tracker
SS 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 X X
Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]

5 SQLERR 340 : cannot create index; no_meta_update; idx_create_err
bugs gh 5173

tracker
CS 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 X X
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]

6 SQLERR 340 : cannot create index; no_meta_update; idx_create_err
bugs gh 5173

tracker
SS 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 X X
Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]

7 lock_timeout; obj_in_use
bugs core 5645

tracker
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
Wrong transaction can be passed to external engine

8 net_read_err; net_write_err
bugs gh 6854

tracker
CS S S S S S S S S S S S S S S S S S S S S S S S S S S     F     X X X
Crash occurs when use SIMILAR TO ...

9 net_read_err; net_write_err
bugs gh 6854

tracker
SS S S S S S S S S S S S S S S S S S S S S S S S S S S     F     X X X
Crash occurs when use SIMILAR TO ...

10 sec_context; net_read_err
bugs core 6362

tracker
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
Better diagnostic when 'Missing security context'

11 sec_context; net_read_err
bugs core 6362

tracker
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
Better diagnostic when 'Missing security context'

12 sqlerr
bugs core 6108

tracker
CS     E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters

13 sqlerr
bugs core 6108

tracker
SS     E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E         E
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters

14 udf_name
bugs gh 6782

tracker
SS 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 P     F         F     P P
Getting "records fetched" for functions/procedures in trace

List of tests in this report:

http://tracker.firebirdsql.org/browse/core-5645
http://tracker.firebirdsql.org/browse/core-6108
http://tracker.firebirdsql.org/browse/core-6362
https://github.com/FirebirdSQL/firebird/issues/3886
https://github.com/FirebirdSQL/firebird/issues/5082
https://github.com/FirebirdSQL/firebird/issues/5173
https://github.com/FirebirdSQL/firebird/issues/6782
https://github.com/FirebirdSQL/firebird/issues/6854

=== end of list ===

NN	FB-related errors	Test name	mode	3.0.11.33631 2022-10-01	3.0.11.33622 2022-09-10	3.0.11.33621 2022-09-07	3.0.11.33620 2022-09-05	3.0.11.33618 2022-08-23	3.0.11.33616 2022-08-17	3.0.11.33612 2022-07-31	3.0.10.33601 2022-07-17	3.0.10.33587 2022-06-04	3.0.10.33580 2022-04-30	3.0.10.33577 2022-04-25	3.0.10.33570 2022-04-17	3.0.10.33569 2022-02-25	3.0.9.33561 2022-02-22	3.0.9.33560 2022-02-13	3.0.9.33556 2022-02-09	3.0.9.33548 2022-01-12	3.0.8.33540 2021-12-20	3.0.8.33533 2021-12-01	3.0.8.33528 2021-11-08	3.0.8.33501 2021-10-31	3.0.8.33490 2021-09-22	3.0.8.33489 2021-08-10	3.0.8.33488 2021-08-07	3.0.8.33487 2021-07-31	3.0.8.33475 2021-07-20	3.0.8.33472 2021-06-18	3.0.8.33471 2021-06-09	3.0.8.33470 2021-06-02	3.0.8.33468 2021-05-29	Test TITLE
1	SQLERR 340 : cannot create index; no_meta_update; idx_create_err	bugs gh 3886 tracker	CS	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	X	X	recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
2	SQLERR 340 : cannot create index; no_meta_update; idx_create_err	bugs gh 3886 tracker	SS	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	X	X	recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
3	SQLERR 340 : cannot create index; no_meta_update; idx_create_err	bugs gh 5082 tracker	CS	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	X	X	Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
4	SQLERR 340 : cannot create index; no_meta_update; idx_create_err	bugs gh 5082 tracker	SS	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	X	X	Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
5	SQLERR 340 : cannot create index; no_meta_update; idx_create_err	bugs gh 5173 tracker	CS	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	X	X	Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
6	SQLERR 340 : cannot create index; no_meta_update; idx_create_err	bugs gh 5173 tracker	SS	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	X	X	Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
7	lock_timeout; obj_in_use	bugs core 5645 tracker	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	Wrong transaction can be passed to external engine
8	net_read_err; net_write_err	bugs gh 6854 tracker	CS	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	F	X	X	X	Crash occurs when use SIMILAR TO ...
9	net_read_err; net_write_err	bugs gh 6854 tracker	SS	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	F	X	X	X	Crash occurs when use SIMILAR TO ...
10	sec_context; net_read_err	bugs core 6362 tracker	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	Better diagnostic when 'Missing security context'
11	sec_context; net_read_err	bugs core 6362 tracker	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	Better diagnostic when 'Missing security context'
12	sqlerr	bugs core 6108 tracker	CS	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
13	sqlerr	bugs core 6108 tracker	SS	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
14	udf_name	bugs gh 6782 tracker	SS	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	P	F	F	P	P	Getting "records fetched" for functions/procedures in trace