Generated 05.02.2023 08:42
Tested: HQ30.   Build: 3.0.11.33657;   SS: 05.02.23 07:20:13 - 05.02.23 07:56:36;   CS: 05.02.23 07:58:01 - 05.02.23 08:41:24;
OS and hardware info:  Windows 10 10.0.19041 ; logical CPUs: 8 ; total memory: 31.7 Gb 

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

NN	Test name	mode	3.0.11.33657 2023-02-05	3.0.11.33648 2023-01-18	3.0.11.33646 2022-12-07	3.0.11.33639 2022-11-25	3.0.11.33636 2022-10-29	3.0.11.33631 2022-10-20	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	Test TITLE
1	bugs core 0284 tracker	SS	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	P	F	P	P	P	Blob Comparison with constant
2	bugs core 1506 tracker	CS	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	Server crash with isc_dsql_execute_immediate and zero length string
3	bugs core 1506 tracker	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	Server crash with isc_dsql_execute_immediate and zero length string
4	bugs core 2484 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	Success message when connecting to tiny trash database file
5	bugs core 2484 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	Success message when connecting to tiny trash database file
6	bugs core 3658 tracker	CS	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	P	FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
7	bugs core 4135 tracker	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	P	P	P	P	P	In SS sweep blocks establishment of concurrent attachments
8	bugs core 4880 tracker	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	P	F	F	F	P	Increase speed of creating package when number of its functions more than several hundreds
9	bugs core 4880 tracker	SS	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	P	F	P	F	Increase speed of creating package when number of its functions more than several hundreds
10	bugs core 4928 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	P	P	P	P	P	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
11	bugs core 4977 tracker	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	Detach using Linux client takes much longer than from Windows
12	bugs core 5034 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	P	P	P	P	P	P	P	P	P	F	P	P	P	P	P	At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
13	bugs core 5645 tracker	SS	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	F	F	F	F	F	Wrong transaction can be passed to external engine
14	bugs core 6362 tracker	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	P	P	P	P	P	Better diagnostic when 'Missing security context'
15	bugs core 6362 tracker	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	P	P	P	P	P	Better diagnostic when 'Missing security context'
16	bugs gh 3106 tracker	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	F	F	F	Many indexed reads in a compound index with NULLs [CORE2709]
17	bugs gh 3106 tracker	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	F	F	F	Many indexed reads in a compound index with NULLs [CORE2709]
18	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	P	P	P	P	P	F	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]
19	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	P	P	P	P	P	F	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]
20	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	P	P	P	P	P	F	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]
21	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	P	P	P	P	P	F	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]
22	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	P	P	P	P	P	F	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]
23	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	P	P	P	P	P	F	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]
24	bugs gh 6782 tracker	SS	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	P	Getting "records fetched" for functions/procedures in trace
25	bugs gh 6987 tracker	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	F	X	X	X	X	DATEDIFF does not support fractional value for MILLISECOND
26	bugs gh 6987 tracker	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	F	X	X	X	X	DATEDIFF does not support fractional value for MILLISECOND
27	bugs gh 7031 tracker	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	F	X	X	X	X	gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
28	bugs gh 7031 tracker	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	F	X	X	X	X	gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
29	optimizer opt inner join 03	CS	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	F	F	F	F	F	F	F	INNER JOIN join order
30	optimizer opt inner join 03	SS	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	F	F	F	F	F	F	F	INNER JOIN join order
31	optimizer opt left join 06	CS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	LEFT OUTER JOIN with full match, but limited in ON clause
32	optimizer opt left join 06	SS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	LEFT OUTER JOIN with full match, but limited in ON clause
33	optimizer opt left join 11	CS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	LEFT OUTER JOIN with STARTING WITH in WHERE clause
34	optimizer opt left join 11	SS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	LEFT OUTER JOIN with STARTING WITH in WHERE clause
35	build snapshot files check list	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	F	F	F	Check list of files in the current Firebird snapshot
36	build snapshot files check list	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	F	F	F	Check list of files in the current Firebird snapshot
37	isql isql 01	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	ISQL - SHOW DATABASE
38	isql isql 01	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	F	P	P	P	ISQL - SHOW DATABASE
39	date datediff 07	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	F	P	P	P	P	test de la fonction datediff pour avoir le resultat en minute
40	date datediff 07	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	F	P	P	P	P	test de la fonction datediff pour avoir le resultat en minute

Elapsed time, milliseconds:

NN	Test name	mode	median_ms	3.0.11.33657 2023-02-05	3.0.11.33648 2023-01-18	3.0.11.33646 2022-12-07	3.0.11.33639 2022-11-25	3.0.11.33636 2022-10-29	3.0.11.33631 2022-10-20	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	Test TITLE
1	bugs core 0284 tracker	SS	1200	560	590	620	590	570	590	450	440	460	450	460	450	460	1720	2530	890	1680	1800	1710	1000	1760	1440	1460	1580	1420	1400	1450	1410	1440	1430	Blob Comparison with constant
2	bugs core 1506 tracker	CS	2045	670	660	710	710	770	760	650	660	650	670	720	670	640	2200	2260	830	2080	2200	2150	2070	2070	2090	2100	2110	2100	2090	2060	2060	2070	2030	Server crash with isc_dsql_execute_immediate and zero length string
3	bugs core 1506 tracker	SS	1345	470	480	480	470	480	490	400	410	440	410	420	420	400	1680	11650	760	1830	1710	1700	1960	1710	1430	1890	1420	1380	1380	1390	1350	1390	1340	Server crash with isc_dsql_execute_immediate and zero length string
4	bugs core 2484 tracker	CS	3330	1820	1760	1790	1790	2640	1860	1740	1740	1860	1870	1780	1930	1730	3710	3000	1900	3780	3760	3810	3980	3730	3720	3710	3730	3710	3710	4120	3720	3680	3660	Success message when connecting to tiny trash database file
5	bugs core 2484 tracker	SS	2565	1490	1520	1520	1490	1530	1000	1440	1460	1610	1600	1620	1470	1410	2920	3120	1770	3160	2910	2890	3060	2930	2620	2610	2620	2590	2590	2590	2570	2590	2560	Success message when connecting to tiny trash database file
6	bugs core 3658 tracker	CS	6715	5050	5030	5080	5160	5150	5130	4920	4910	4890	4890	5120	4930	4860	6820	7050	5030	6790	6880	6930	6960	6770	6810	6880	6920	6890	6720	6740	6720	6710	6760	FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
7	bugs core 4135 tracker	CS	33315	21540	21640	21620	21580	23280	22480	21830	21320	21670	21600	21540	21740	20000	34490	36730	27870	34550	33410	33700	33540	33380	33290	33870	33700	33390	34530	33340	33820	33700	33670	In SS sweep blocks establishment of concurrent attachments
8	bugs core 4880 tracker	CS	37285	35000	35530	35900	35980	37290	37280	35450	36850	37010	39000	40700	41280	35690	94160	94000	64050	103460	97290	95440	94680	85690	83710	83090	83630	27950	27020	27330	27330	27310	27180	Increase speed of creating package when number of its functions more than several hundreds
9	bugs core 4880 tracker	SS	36440	36000	33950	39260	34310	34740	33920	36890	34280	36820	36060	45210	34000	35700	87460	89810	70890	86810	87360	87930	87740	88730	77080	75910	76660	26360	25850	25000	25880	25530	25520	Increase speed of creating package when number of its functions more than several hundreds
10	bugs core 4928 tracker	SS	3115	1270	1000	1410	1000	1320	1310	1010	1010	1020	1030	1270	1030	1030	4180	4090	2150	4140	4330	4240	4240	4090	3370	3310	3360	3280	3260	3230	3350	3260	3000	It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
11	bugs core 4977 tracker	CS	3610	1740	1860	1770	1880	1840	1790	1680	1700	1730	1680	1720	1710	1640	3680	3820	1810	3760	3690	3870	3790	3700	4450	3620	4400	3850	3640	3620	3670	3600	3620	Detach using Linux client takes much longer than from Windows
12	bugs core 5034 tracker	CS	33980	18890	18090	18690	17320	18890	15190	13020	17780	13220	18210	13140	17610	18140	37330	50980	26210	47480	49140	42920	39000	42880	41780	48080	42030	51630	52320	33960	34000	36110	34420	At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
13	bugs core 5645 tracker	SS	3130	990	1840	1860	1850	1850	1890	1810	1770	1720	1760	1730	1000	2200	3700	3710	2350	3680	4530	3000	3570	3840	3490	3340	3340	3360	3280	3260	3330	3390	3290	Wrong transaction can be passed to external engine
14	bugs core 6362 tracker	CS	4280	2190	2240	2310	2210	2260	2390	1980	2050	2140	2100	2050	2140	2110	4480	4560	2320	4390	4480	4770	4490	4400	4340	4290	4370	5850	4310	4310	4360	5210	4270	Better diagnostic when 'Missing security context'
15	bugs core 6362 tracker	SS	2750	1790	1810	1790	1780	2100	1810	1550	1590	1560	1540	1620	1580	1530	3070	3160	1970	3230	3110	3260	3090	3220	2830	2810	2860	4700	2800	2790	2740	2770	2760	Better diagnostic when 'Missing security context'
16	bugs gh 3106 tracker	CS	7360																												7810	7340	7360	Many indexed reads in a compound index with NULLs [CORE2709]
17	bugs gh 3106 tracker	SS	5650																												5710	5650	5620	Many indexed reads in a compound index with NULLs [CORE2709]
18	bugs gh 3886 tracker	CS	725	570	580	630	620	680	670	570	570	560	570	610	590	580	1690	1780	770	2440	1700	1770	1700	1660	1670	1660	1700	1670	1630					recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
19	bugs gh 3886 tracker	SS	575	430	450	450	440	460	470	390	380	380	380	380	390	380	1450	1400	680	1420	1480	1480	1450	1480	1200	1160	1200	1120	1140					recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
20	bugs gh 5082 tracker	CS	665	600	610	590	630	660	660	570	560	570	580	600	590	540	1730	1680	670	1870	1690	1820	1930	1650	1670	1600	1660	1650	1650					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]
21	bugs gh 5082 tracker	SS	610	430	440	440	430	450	440	370	370	370	370	380	370	360	1440	1380	770	1410	1550	1000	1410	1450	1170	1140	1170	1110	1110					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]
22	bugs gh 5173 tracker	CS	690	560	600	650	640	670	670	570	570	580	580	590	590	580	1690	1720	710	2060	1000	1780	1730	1660	1680	1670	1670	1670	1690					Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
23	bugs gh 5173 tracker	SS	570	460	450	470	440	460	460	370	370	370	380	380	400	380	1440	1380	670	1430	1480	1540	1510	1480	1200	1180	1200	1150	1120					Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
24	bugs gh 6782 tracker	SS	5215	4050	4020	4090	4030	4110	4060	3810	4240	3850	3800	3950	3860	3000	5740	5000	4570	5730	5870	5910	5780	5770	5930	5590	5530	5470	5450	5440	5490	5460	5430	Getting "records fetched" for functions/procedures in trace
25	bugs gh 6987 tracker	CS	640	570	600	610	600	640	640	590	550	560	580	620	570	550	1640	1620	0	1640	1670	1700	1680	1660	1640	1670	1660	1650	1600					DATEDIFF does not support fractional value for MILLISECOND
26	bugs gh 6987 tracker	SS	550	460	440	440	420	450	420	360	360	360	410	360	360	360	1400	1530	640	1370	1610	1460	1420	1380	1080	1370	1150	1090	1100					DATEDIFF does not support fractional value for MILLISECOND
27	bugs gh 7031 tracker	CS	2225	1000	1000	1790	1790	1920	1830	1790	1670	1790	1680	1830	1720	1630	4600	4700	2530	4790	4830	4790	4710	5030	4800	4660	4000	4840	5130					gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
28	bugs gh 7031 tracker	SS	1990	1410	1510	1400	1380	1490	1410	1260	1000	1000	1400	1280	1280	1240	3770	4310	2470	3890	4660	3870	3820	3850	3540	3600	3590	3490	4700					gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
29	optimizer opt inner join 03	CS	2630	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2670	2830	2590	2630	2580	2630	2000	INNER JOIN join order
30	optimizer opt inner join 03	SS	1900	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1930	1920	1840	2000	1900	1890	1870	INNER JOIN join order
31	optimizer opt left join 06	CS	2000	770	850	860	830	890	900	770	710	730	720	0	730	700	2350	2390	1030	2260	2480	2270	2390	2000	2230	2000	2200	2210	2170	2240	2190	2160	2170	LEFT OUTER JOIN with full match, but limited in ON clause
32	optimizer opt left join 06	SS	1450	600	580	610	590	600	610	480	470	470	520	490	490	470	1780	1720	810	2030	1860	1880	1850	1810	1510	1480	1540	1480	1520	1450	1460	1450	1460	LEFT OUTER JOIN with full match, but limited in ON clause
33	optimizer opt left join 11	CS	2000	780	840	850	830	880	940	730	710	720	730	760	0	710	2340	2290	960	2260	2700	2420	2320	2260	2230	2220	2200	2000	2170	2000	2000	2150	2160	LEFT OUTER JOIN with STARTING WITH in WHERE clause
34	optimizer opt left join 11	SS	1430	620	600	610	610	610	620	490	470	480	520	490	0	480	1790	1770	820	1730	1870	1860	1780	1830	1520	1000	1550	1510	1470	1430	1470	1460	1440	LEFT OUTER JOIN with STARTING WITH in WHERE clause
35	build snapshot files check list	CS	1340	550	570	630	660	700	650	610	620	630	620	630	640	600	1840	1830	830	2150	1810	1780	1790	2270	1730	1740	1730	1740	1690	1680	1000	1730	1700	Check list of files in the current Firebird snapshot
36	build snapshot files check list	SS	1100	370	370	400	360	380	380	390	370	360	370	400	380	360	1420	1810	770	1820	1630	1480	1440	1820	1160	1140	1170	1140	1120	1110	1120	1090	1120	Check list of files in the current Firebird snapshot
37	isql isql 01	CS	1570	580	560	630	620	660	660	560	600	560	550	560	580	550	1640	1780	640	1770	1700	1950	1670	1660	1630	1650	1640	1640	1590	1620	1580	1560	1590	ISQL - SHOW DATABASE
38	isql isql 01	SS	1080	430	430	440	420	420	470	360	370	360	360	370	370	360	1420	1380	720	2050	1460	1440	1390	1440	1120	1130	1150	1110	1110	1090	1110	1090	1070	ISQL - SHOW DATABASE
39	date datediff 07	CS	1580	570	580	600	610	640	650	590	550	580	560	580	580	550	1690	1680	1230	1640	1710	1670	1680	1640	1740	1610	1640	1640	1590	1590	1610	1620	1570	test de la fonction datediff pour avoir le resultat en minute
40	date datediff 07	SS	1080	430	420	430	410	440	440	360	360	370	370	510	380	360	1390	1360	640	1380	1450	1430	1430	1440	1130	1110	1150	1260	1100	1110	1090	1070	1090	test de la fonction datediff pour avoir le resultat en minute

List of tests in this report: