Generated 11.05.2022 09:30
Tested: HQ30.   Build: 3.0.10.33587;   CS: 11.05.22 07:40:57 - 11.05.22 09:22:30;   SS: 11.05.22 06:05:08 - 11.05.22 07:38:20;
OS and hardware info:  Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 Gb 

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

Jump to LIST of unique test names from this report

NN	Test name	mode	3.0.10.33587 2022-05-11	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	3.0.8.33452 2021-05-13	3.0.8.33430 2021-04-17	3.0.8.33423 2021-03-30	3.0.8.33415 2021-03-04	3.0.8.33403 2021-01-27	3.0.8.33392 2021-01-17	3.0.7.33388 2021-01-17	3.0.7.33379 2021-01-18	Test TITLE
1	bugs core 0214 tracker	SS	F	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	P	P	Count ( DISTINCT ... ) is too slow
2	bugs core 0284 tracker	SS	P	F	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	Blob Comparison with constant
3	bugs core 0501 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	P	P	P	F	F	Lot of syntax tests for COALESCE()
4	bugs core 0501 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	P	P	P	F	F	Lot of syntax tests for COALESCE()
5	bugs core 1506 tracker	CS	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	P	P	Server crash with isc_dsql_execute_immediate and zero length string
6	bugs core 1506 tracker	SS	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	P	P	Server crash with isc_dsql_execute_immediate and zero length string
7	bugs core 1885 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	P	P	P	P	CREATE COLLATION connection lost under Posix
8	bugs core 1885 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	P	P	P	P	CREATE COLLATION connection lost under Posix
9	bugs core 2484 tracker	CS	P	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	Success message when connecting to tiny trash database file
10	bugs core 2484 tracker	SS	P	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	Success message when connecting to tiny trash database file
11	bugs core 2977 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	FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
12	bugs core 2977 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	FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
13	bugs core 4135 tracker	CS	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	P	In SS sweep blocks establishment of concurrent attachments
14	bugs core 4880 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	F	P	F	F	F	P	P	P	P	P	P	P	P	P	P	P	P	P	P	Increase speed of creating package when number of its functions more than several hundreds
15	bugs core 4880 tracker	SS	P	P	F	P	P	P	P	P	P	P	P	P	P	P	F	P	F	P	P	P	P	P	P	P	P	P	P	P	P	P	Increase speed of creating package when number of its functions more than several hundreds
16	bugs core 4928 tracker	SS	P	P	P	P	F	F	F	F	P	P	P	P	P	P	P	P	P	P	P	P	P	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
17	bugs core 4977 tracker	CS	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	P	P	P	P	Detach using Linux client takes much longer than from Windows
18	bugs core 5034 tracker	CS	P	F	P	P	P	P	P	P	P	P	P	F	P	P	P	P	P	P	F	F	P	F	P	P	P	P	P	P	P	P	At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
19	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	P	P	P	Wrong transaction can be passed to external engine
20	bugs core 5647 tracker	CS	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	X	X	X	Increase number of formats/versions of views from 255 to 32K
21	bugs core 5647 tracker	SS	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	X	X	X	Increase number of formats/versions of views from 255 to 32K
22	bugs core 5685 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	P	F	P	P	P	Sometime it is impossible to cancel\kill connection executing external query
23	bugs core 6362 tracker	CS	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	P	Better diagnostic when 'Missing security context'
24	bugs core 6362 tracker	SS	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	P	Better diagnostic when 'Missing security context'
25	bugs core 6437 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	P	P	P	F	P	gfix cannot set big value for buffers
26	bugs core 6479 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	X	X	X	X	X	COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
27	bugs core 6479 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	X	X	X	X	X	COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
28	bugs core 6487 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	FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
29	bugs core 6487 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	FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
30	bugs core 6489 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	X	X	X	X	X	User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
31	bugs core 6489 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	X	X	X	X	X	User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
32	bugs core 6494 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	X	X	X	X	X	X	Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
33	bugs core 6494 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	X	X	X	X	X	X	Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
34	bugs core 6521 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	X	X	X	X	X	X	CAST of Infinity values to FLOAT doesn't work
35	bugs core 6521 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	X	X	X	X	X	X	CAST of Infinity values to FLOAT doesn't work
36	bugs core 6527 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	X	X	X	X	X	X	Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
37	bugs core 6527 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	X	X	X	X	X	X	Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
38	bugs core 6531 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	X	X	X	X	X	X	COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
39	bugs core 6531 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	X	X	X	X	X	X	COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
40	bugs core 6532 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	X	X	X	X	X	X	Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
41	bugs core 6532 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	X	X	X	X	X	X	Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
42	bugs core 6542 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	X	X	X	X	X	X	Implementation of SUBSTRING for UTF8 character set is inefficient
43	bugs core 6542 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	X	X	X	X	X	X	Implementation of SUBSTRING for UTF8 character set is inefficient
44	bugs gh 3106 tracker	CS	X	X	X	X	X	X	X	X	X	X	X	X	X	X	F	F	F	F	F	F	F	F	F	X	X	X	X	X	X	X	Many indexed reads in a compound index with NULLs [CORE2709]
45	bugs gh 3106 tracker	SS	X	X	X	X	X	X	X	X	X	X	X	X	X	X	F	F	F	F	F	F	F	F	F	X	X	X	X	X	X	X	Many indexed reads in a compound index with NULLs [CORE2709]
46	bugs gh 3886 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	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]
47	bugs gh 3886 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	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]
48	bugs gh 5082 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	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]
49	bugs gh 5082 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	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]
50	bugs gh 5173 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	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]
51	bugs gh 5173 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	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]
52	bugs gh 6782 tracker	CS	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	X	X	X	Getting "records fetched" for functions/procedures in trace
53	bugs gh 6782 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	P	P	F	X	X	X	X	X	X	X	Getting "records fetched" for functions/procedures in trace
54	bugs gh 6854 tracker	CS	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	F	X	X	X	X	X	X	X	X	X	X	X	Crash occurs when use SIMILAR TO ...
55	bugs gh 6854 tracker	SS	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	F	X	X	X	X	X	X	X	X	X	X	X	Crash occurs when use SIMILAR TO ...
56	bugs gh 6866 tracker	CS	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	X	X	X	Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
57	bugs gh 6866 tracker	SS	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	X	X	X	Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
58	bugs gh 6987 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	DATEDIFF does not support fractional value for MILLISECOND
59	bugs gh 6987 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	DATEDIFF does not support fractional value for MILLISECOND
60	bugs gh 7031 tracker	CS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
61	bugs gh 7031 tracker	SS	P	P	P	P	P	P	P	P	P	P	P	P	F	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
62	optimizer opt inner join 03	CS	S	S	S	S	S	S	S	S	S	S	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	INNER JOIN join order
63	optimizer opt inner join 03	SS	S	S	S	S	S	S	S	S	S	S	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	INNER JOIN join order
64	optimizer opt left join 06	CS	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	LEFT OUTER JOIN with full match, but limited in ON clause
65	optimizer opt left join 06	SS	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	LEFT OUTER JOIN with full match, but limited in ON clause
66	optimizer opt left join 11	CS	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	LEFT OUTER JOIN with STARTING WITH in WHERE clause
67	optimizer opt left join 11	SS	P	P	P	P	P	P	P	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	LEFT OUTER JOIN with STARTING WITH in WHERE clause
68	build snapshot files check list	CS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	P	Check list of files in the current Firebird snapshot
69	build snapshot files check list	SS	P	P	P	P	P	P	P	P	P	P	P	P	P	P	F	F	F	F	F	F	F	P	P	P	P	P	P	P	P	P	Check list of files in the current Firebird snapshot
70	db db 25	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	Empty DB - RDB$ROLES
71	db db 25	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	Empty DB - RDB$ROLES
72	db db 26	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	Empty DB - RDB$SECURITY_CLASSES
73	db db 26	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	Empty DB - RDB$SECURITY_CLASSES
74	db db 31	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	Empty DB - RDB$USER_PRIVILEGES
75	db db 31	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	Empty DB - RDB$USER_PRIVILEGES
76	isql isql 01	CS	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	P	P	P	P	P	ISQL - SHOW DATABASE
77	isql isql 01	SS	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	P	P	P	P	P	ISQL - SHOW DATABASE
78	database create 08	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	CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
79	database create 08	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	CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
80	database create 09	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	CREATE DATABASE - Multi file DB
81	database create 09	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	CREATE DATABASE - Multi file DB
82	database create 10	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	CREATE DATABASE - Multi file DB - starting
83	database create 10	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	CREATE DATABASE - Multi file DB - starting
84	date datediff 07	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	test de la fonction datediff pour avoir le resultat en minute
85	date datediff 07	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	test de la fonction datediff pour avoir le resultat en minute
86	role create 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	F	P	P	P	P	P	CREATE ROLE
87	role create 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	F	P	P	P	P	P	CREATE ROLE

Elapsed time, milliseconds:

NN	Test name	mode	median_ms	3.0.10.33587 2022-05-11	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	3.0.8.33452 2021-05-13	3.0.8.33430 2021-04-17	3.0.8.33423 2021-03-30	3.0.8.33415 2021-03-04	3.0.8.33403 2021-01-27	3.0.8.33392 2021-01-17	3.0.7.33388 2021-01-17	3.0.7.33379 2021-01-18	Test TITLE
1	bugs core 0214 tracker	SS	4955	106460	7530	4350	5200	5290	5130	5200	5140	4950	4960	5050	5010	4820	4900	4860	4940	4650	4930	5010	4990	4920	4900	4790	4600	4710	4600	4640	6630	5850	5680	Count ( DISTINCT ... ) is too slow
2	bugs core 0284 tracker	SS	1430	2370	2530	890	1680	1800	1710	1000	1760	1440	1460	1580	1420	1400	1450	1410	1440	1430	1440	1440	1000	1450	1430	1380	1390	1420	1290	1360	1110	1100	1090	Blob Comparison with constant
3	bugs core 0501 tracker	CS	2250	2340	2420	1050	3590	2410	2340	2540	2490	2300	2310	2300	2310	2230	2200	2000	2200	2220	2180	2000	2280	2290	2230	2090	2120	2140	2270	2060	2200	2460	2160	Lot of syntax tests for COALESCE()
4	bugs core 0501 tracker	SS	1590	2260	2510	950	1890	1930	1880	1920	1900	1000	1630	1620	1590	1610	1570	1530	1590	1550	1570	1600	1590	1590	1610	1520	1550	1530	1450	1430	1490	1540	1210	Lot of syntax tests for COALESCE()
5	bugs core 1506 tracker	CS	2070	2230	2260	830	2080	2200	2150	2070	2070	2090	2100	2110	2100	2090	2060	2060	2070	2030	2060	2080	2150	2090	2040	1890	2200	1910	1830	1900	1890	1900	1000	Server crash with isc_dsql_execute_immediate and zero length string
6	bugs core 1506 tracker	SS	1390	2170	11650	760	1830	1710	1700	1960	1710	1430	1890	1420	1380	1380	1390	1350	1390	1340	1380	1480	1390	1390	1390	1340	1360	1330	1000	1340	1140	890	930	Server crash with isc_dsql_execute_immediate and zero length string
7	bugs core 1885 tracker	CS	1590	1620	1730	610	1720	1730	1000	1640	1790	1600	1600	1590	1570	1580	1610	1580	1540	1610	1560	1560	1640	1620	1610	1430	1590	1460	1630	1490	1280	1420	1390	CREATE COLLATION connection lost under Posix
8	bugs core 1885 tracker	SS	1090	1610	1440	610	1470	1400	1530	1420	1410	1120	1080	1120	1080	1110	1080	1110	1080	1100	1100	1090	1090	1110	1090	1060	1040	1050	1020	1050	870	800	0	CREATE COLLATION connection lost under Posix
9	bugs core 2484 tracker	CS	3670	3740	3000	1900	3780	3760	3810	3980	3730	3720	3710	3730	3710	3710	4120	3720	3680	3660	3690	3510	3620	3530	3410	3210	3350	3000	3290	3230	3260	3190	3070	Success message when connecting to tiny trash database file
10	bugs core 2484 tracker	SS	2580	2950	3120	1770	3160	2910	2890	3060	2930	2620	2610	2620	2590	2590	2590	2570	2590	2560	2630	2530	2530	2510	2400	2390	2440	2390	2290	2330	2060	2330	2120	Success message when connecting to tiny trash database file
11	bugs core 2977 tracker	CS	2120	2370	2180	740	2150	2280	2460	2320	2120	2150	2110	2130	2170	2100	2190	2120	2090	2110	2080	2120	2170	2170	2090	1960	2230	2820	1910	1890	1890	1920	2090	FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
12	bugs core 2977 tracker	SS	1400	1670	1920	780	1710	1810	1780	1000	1000	1480	1410	1000	1440	1420	1420	1380	1390	1380	1430	1480	1450	1400	1450	1390	1400	1390	1370	1320	1290	1030	1210	FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
13	bugs core 4135 tracker	CS	33400	33770	36730	27870	34550	33410	33700	33540	33380	33290	33870	33700	33390	34530	33340	33820	33700	33670	33540	34090	34720	33280	32400	32270	32110	31710	31440	29330	31360	31940	31680	In SS sweep blocks establishment of concurrent attachments
14	bugs core 4880 tracker	CS	27320	94190	94000	64050	103460	97290	95440	94680	85690	83710	83090	83630	27950	27020	27330	27330	27310	27180	23470	23700	23850	23680	23450	23240	23880	23540	23490	23400	24090	22930	27780	Increase speed of creating package when number of its functions more than several hundreds
15	bugs core 4880 tracker	SS	25525	87060	89810	70890	86810	87360	87930	87740	88730	77080	75910	76660	26360	25850	25000	25880	25530	25520	21550	21890	22150	22070	21960	21780	22280	22140	21830	21990	21840	22700	21170	Increase speed of creating package when number of its functions more than several hundreds
16	bugs core 4928 tracker	SS	3285	4480	4090	2150	4140	4330	4240	4240	4090	3370	3310	3360	3280	3260	3230	3350	3260	3000	3240	3300	3320	3290	3290	3060	3180	3150	3030	3040	2420	2490	2360	It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
17	bugs core 4977 tracker	CS	3620	3790	3820	1810	3760	3690	3870	3790	3700	4450	3620	4400	3850	3640	3620	3670	3600	3620	3610	3650	3680	3620	3590	3210	3270	1950	1890	1860	1780	1840	1860	Detach using Linux client takes much longer than from Windows
18	bugs core 5034 tracker	CS	39620	42060	50980	26210	47480	49140	42920	39000	42880	41780	48080	42030	51630	52320	33960	34000	36110	34420	33840	57860	58410	47560	40240	24080	29200	28530	27960	27470	27830	30310	29940	At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
19	bugs core 5645 tracker	SS	3305	3710	3710	2350	3680	4530	3000	3570	3840	3490	3340	3340	3360	3280	3260	3330	3390	3290	3350	3290	3350	3320	3260	3100	3160	3130	3020	2980	2170	2100	2000	Wrong transaction can be passed to external engine
20	bugs core 5647 tracker	CS	21140	21530	24560	27820	21550	22000	22560	22240	21520	21920	21090	21620	22000	20890	21140	20820	21010	20360	20210	20530	20720	20560	20510	5190								Increase number of formats/versions of views from 255 to 32K
21	bugs core 5647 tracker	SS	19970	20400	20470	20200	20540	20800	21010	21130	20600	20470	19970	20480	20770	19290	19860	19530	19000	19120	19030	19330	19480	19360	19310	3860								Increase number of formats/versions of views from 255 to 32K
22	bugs core 5685 tracker	CS	26040	26370	26180	23270	26140	26470	26190	26100	26080	26190	26100	26020	26070	25970	25970	26100	26030	26140	26040	26130	26130	26040	25910	25470	25620	25610	25470	25570	24940	25240	25040	Sometime it is impossible to cancel\kill connection executing external query
23	bugs core 6362 tracker	CS	4330	4540	4560	2320	4390	4480	4770	4490	4400	4340	4290	4370	5850	4310	4310	4360	5210	4270	4320	4360	4810	4320	4020	3680	3930	3930	4760	2860	2790	2900	2840	Better diagnostic when 'Missing security context'
24	bugs core 6362 tracker	SS	2790	3030	3160	1970	3230	3110	3260	3090	3220	2830	2810	2860	4700	2800	2790	2740	2770	2760	3780	2800	2760	2790	2640	2620	2570	2600	2570	1540	1380	1110	1000	Better diagnostic when 'Missing security context'
25	bugs core 6437 tracker	CS	4200	4990	4150	2850	4200	4370	4000	4260	4200	4200	4130	4140	4230	4130	4160	4100	4260	4370	4100	4260	4230	4150	4100	3940	4270	4020	5400	5470	7000	6320	5530	gfix cannot set big value for buffers
26	bugs core 6479 tracker	CS	2210	2260	2260	1080	2200	2350	2380	2840	2260	2280	2260	2000	2240	2200	2210	2200	2190	2180	2210	2290	2280	2220	2200	2000	2060	2040						COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
27	bugs core 6479 tracker	SS	1480	1700	1720	830	1760	1870	1840	1850	1760	1530	1480	1540	1440	1450	1450	1000	1450	1420	1430	1490	1490	1490	1470	1390	1470	1390						COMMENT ON USER can only apply comment on user defined by the default usermanager plugin
28	bugs core 6487 tracker	CS	1610	1680	1640	0	1640	1910	1800	1900	1620	1630	1610	1660	1630	1590	1610	1560	1580	1580	1560	1640	1640	1590	1580	1470	1540	1480	1410					FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
29	bugs core 6487 tracker	SS	1095	1370	1350	710	1390	1450	1460	1530	1390	1150	1120	1170	1070	1090	1080	1100	1080	1070	1090	1090	1110	1120	1090	1040	1060	1060	1020					FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
30	bugs core 6489 tracker	CS	3730	3930	3890	1330	4090	3970	3950	4360	3000	3870	3760	3730	3770	3730	3620	3740	3620	3650	3620	3800	3810	3710	3630	3380	3430	3480						User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
31	bugs core 6489 tracker	SS	2360	2560	2580	1160	2650	2730	2000	2740	2650	2400	2410	2430	2330	2340	2320	2360	2340	2310	2340	2360	2420	2590	2000	2230	2380	2000						User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
32	bugs core 6494 tracker	CS	1615	1690	1650	760	1680	1710	1720	1990	1620	1630	1640	1630	1610	1600	1590	1590	1570	1560	1570	1660	1620	1610	1610	1490	1550							Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
33	bugs core 6494 tracker	SS	1100	1350	1350	0	1390	1000	1590	1440	1420	1140	1100	1160	1090	1070	1080	1090	1080	1080	1070	1090	1100	1110	1090	1060	1130							Inconsistent translation "string->timestamp->string->timestamp" in dialect 1
34	bugs core 6521 tracker	CS	1610	1610	1640	640	1640	1660	1680	1670	1720	1640	1590	1670	1620	1590	1580	1590	1610	1600	1590	1640	1670	1610	1590	1470	1610							CAST of Infinity values to FLOAT doesn't work
35	bugs core 6521 tracker	SS	1115	1350	1420	630	1450	1460	1480	1420	1470	1210	1110	1130	1060	1090	1080	1440	1080	1080	1080	1090	1120	1130	1090	1050	1080							CAST of Infinity values to FLOAT doesn't work
36	bugs core 6527 tracker	CS	5465	5300	5420	2640	5550	5840	5370	5330	5660	5390	5600	5650	5510	5470	5460	5540	5000	5920	5430	5800	5470	5410	5560	5240	5160							Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
37	bugs core 6527 tracker	SS	3955	4120	4230	2520	4230	4800	4560	4280	4160	3940	3960	4050	3950	3900	3820	3980	3880	3850	3960	3920	3960	3910	3930	3820	3910							Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
38	bugs core 6531 tracker	CS	1650	1700	1640	700	1780	1760	1000	1730	1700	1700	1650	1680	1700	1640	1630	1620	1620	1660	1640	1720	1670	1650	1630	1530	1560							COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
39	bugs core 6531 tracker	SS	1160	1420	1460	690	1410	1520	1510	1490	1450	1370	1170	1200	1150	1140	1140	1130	1140	1160	1140	1140	1160	1190	1160	1090	1120							COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
40	bugs core 6532 tracker	CS	1660	1730	1720	800	2180	1730	2110	1000	1700	1710	1650	1650	1700	1650	1660	1690	1630	1600	1600	1700	1700	1660	1640	1530	1590							Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
41	bugs core 6532 tracker	SS	1145	1410	1410	690	1420	1480	1000	1440	1460	1170	1150	1200	1140	1120	1120	1170	1140	1100	1110	1140	1150	1170	1140	1090	1110							Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
42	bugs core 6542 tracker	CS	3005	5000	5100	4010	6520	4890	5000	4870	4910	4830	4820	4930	2340	2260	2240	2260	2240	2270	2000	2370	2340	2290	2230	2100	3640							Implementation of SUBSTRING for UTF8 character set is inefficient
43	bugs core 6542 tracker	SS	2375	4550	4570	4290	4400	4520	4490	4440	4460	4200	4120	4260	1550	1560	1580	1610	1570	1580	1540	1590	1670	1600	1590	1530	3080							Implementation of SUBSTRING for UTF8 character set is inefficient
44	bugs gh 3106 tracker	CS	7440															7810	7340	7360	7440	7550	7480	8000	7350	6830								Many indexed reads in a compound index with NULLs [CORE2709]
45	bugs gh 3106 tracker	SS	5650															5710	5650	5620	5630	5710	5820	5740	5410	5310								Many indexed reads in a compound index with NULLs [CORE2709]
46	bugs gh 3886 tracker	CS	1670	1670	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]
47	bugs gh 3886 tracker	SS	1400	1420	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]
48	bugs gh 5082 tracker	CS	1670	1670	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]
49	bugs gh 5082 tracker	SS	1170	1380	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]
50	bugs gh 5173 tracker	CS	1680	1700	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]
51	bugs gh 5173 tracker	SS	1380	1380	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]
52	bugs gh 6782 tracker	CS	6820	6000	6740	4650	7210	6920	6910	6880	6820	6800	6820	6720	6770	6730	6710	6610	6730	6980	6710	9690	9650	9610	9340	9120								Getting "records fetched" for functions/procedures in trace
53	bugs gh 6782 tracker	SS	5660	5660	5000	4570	5730	5870	5910	5780	5770	5930	5590	5530	5470	5450	5440	5490	5460	5430	5460	8310	8330	8410	8130	8030								Getting "records fetched" for functions/procedures in trace
54	bugs gh 6854 tracker	CS	3940	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3940												Crash occurs when use SIMILAR TO ...
55	bugs gh 6854 tracker	SS	5850	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5850												Crash occurs when use SIMILAR TO ...
56	bugs gh 6866 tracker	CS	1925	2030	1990	960	1970	1990	1980	1960	2200	1930	1890	1890	1920	1880	1870	1960	1860	1870	1840													Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
57	bugs gh 6866 tracker	SS	1340	1580	1630	870	1610	1000	1680	1680	1650	1400	1340	1410	1310	1330	1310	1330	1340	1330	1290													Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
58	bugs gh 6987 tracker	CS	1655	1620	1620	0	1640	1670	1700	1680	1660	1640	1670	1660	1650	1600																		DATEDIFF does not support fractional value for MILLISECOND
59	bugs gh 6987 tracker	SS	1370	1360	1530	640	1370	1610	1460	1420	1380	1080	1370	1150	1090	1100																		DATEDIFF does not support fractional value for MILLISECOND
60	bugs gh 7031 tracker	CS	4790	4780	4700	2530	4790	4830	4790	4710	5030	4800	4660	4000	4840	5130																		gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
61	bugs gh 7031 tracker	SS	3820	3710	4310	2470	3890	4660	3870	3820	3850	3540	3600	3590	3490	4700																		gbak -b failed with "invalid transaction handle (expecting explicit transaction start)"
62	optimizer opt inner join 03	CS	2590	0	0	0	0	0	0	0	0	0	0	2670	2830	2590	2630	2580	2630	2000	2550	2590	2550	2660	2630	2560	2530	2480	2440	2310	3160	3160	3120	INNER JOIN join order
63	optimizer opt inner join 03	SS	1895	0	0	0	0	0	0	0	0	0	0	1930	1920	1840	2000	1900	1890	1870	1810	1800	1910	1870	1940	1940	1840	1000	1740	1810	2240	2370	2170	INNER JOIN join order
64	optimizer opt left join 06	CS	2170	2180	2390	1030	2260	2480	2270	2390	2000	2230	2000	2200	2210	2170	2240	2190	2160	2170	2170	2270	2000	2220	2140	2010	2080	2070	2020	1980	2030	2290	2010	LEFT OUTER JOIN with full match, but limited in ON clause
65	optimizer opt left join 06	SS	1460	1730	1720	810	2030	1860	1880	1850	1810	1510	1480	1540	1480	1520	1450	1460	1450	1460	1450	1000	1000	1000	1470	1390	1440	1470	1360	1450	1230	1270	1170	LEFT OUTER JOIN with full match, but limited in ON clause
66	optimizer opt left join 11	CS	2165	2340	2290	960	2260	2700	2420	2320	2260	2230	2220	2200	2000	2170	2000	2000	2150	2160	2170	2000	2260	2200	2150	2010	2060	2130	2110	1920	2140	3040	2060	LEFT OUTER JOIN with STARTING WITH in WHERE clause
67	optimizer opt left join 11	SS	1465	1710	1770	820	1730	1870	1860	1780	1830	1520	1000	1550	1510	1470	1430	1470	1460	1440	1450	1480	1000	1000	1530	1420	1480	1400	1410	1430	1290	1100	1210	LEFT OUTER JOIN with STARTING WITH in WHERE clause
68	build snapshot files check list	CS	1695	1950	1830	830	2150	1810	1780	1790	2270	1730	1740	1730	1740	1690	1680	1000	1730	1700	1690	1000	1000	1700	1720	1560	1610	1570	1580	1580	1640	1530	1620	Check list of files in the current Firebird snapshot
69	build snapshot files check list	SS	1135	1550	1810	770	1820	1630	1480	1440	1820	1160	1140	1170	1140	1120	1110	1120	1090	1120	1130	1140	1170	1160	1160	1100	1100	1090	1080	1050	810	800	780	Check list of files in the current Firebird snapshot
70	db db 25	CS	1615	1640	1660	670	1620	1730	1690	1670	1640	1650	1610	1660	1610	1660	1590	1590	1580	1590	1590	1640	1660	1630	1590	1000	1740	1470	1000	2670	1320	1380	1450	Empty DB - RDB$ROLES
71	db db 25	SS	1110	1340	1360	720	1370	1530	1440	1420	1430	1170	1120	1160	1110	1090	1080	1090	1130	1080	1080	1090	1110	1170	1110	1060	1100	1080	1080	1110	820	770	840	Empty DB - RDB$ROLES
72	db db 26	CS	1715	1730	1890	900	1990	1820	1840	1820	1790	1780	1700	1740	1730	1680	1680	1720	1680	1700	1700	1760	1830	1710	1700	1590	1690	2510	1550	1920	1340	1540	1590	Empty DB - RDB$SECURITY_CLASSES
73	db db 26	SS	1200	1510	1480	0	1000	1580	1570	1570	1560	1260	1220	1000	1210	1000	1200	1200	1200	1180	1180	1220	1240	1230	1220	1150	1200	1850	1180	1180	950	890	820	Empty DB - RDB$SECURITY_CLASSES
74	db db 31	CS	1950	2260	1920	820	2020	2210	1980	1940	2040	1980	1980	1970	1950	1950	1930	1950	1910	1960	1950	1980	1980	1950	1940	1780	1850	1860	1720	1730	1520	1690	1730	Empty DB - RDB$USER_PRIVILEGES
75	db db 31	SS	1245	1530	1510	800	1610	1840	1590	1560	1000	1300	1260	1310	1270	1270	1000	1000	1230	1230	1230	1000	1270	1280	1000	1200	1270	1280	1130	1230	910	890	800	Empty DB - RDB$USER_PRIVILEGES
76	isql isql 01	CS	1615	1730	1780	640	1770	1700	1950	1670	1660	1630	1650	1640	1640	1590	1620	1580	1560	1590	1560	1630	1650	1610	1590	1460	1490	1590	1450	1620	1190	1420	1380	ISQL - SHOW DATABASE
77	isql isql 01	SS	1120	1490	1380	720	2050	1460	1440	1390	1440	1120	1130	1150	1110	1110	1090	1110	1090	1070	1070	1110	1130	1140	1120	1040	1090	1130	1200	1030	0	790	820	ISQL - SHOW DATABASE
78	database create 08	CS	2165	2310	2640	1090	2170	2270	2310	2260	2230	2230	2180	2200	2170	2130	2160	2160	2120	2110	2130	2200	2210	2210	2190	1970	2000	2000	1940	1890	2150	1940	1930	CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
79	database create 08	SS	1585	1840	1860	1020	1950	1950	1970	2030	1970	1600	1670	1640	1610	1590	1560	1570	1580	1560	1560	1570	1620	1620	1640	1520	1530	1510	1480	1470	1350	1210	1170	CREATE DATABASE - Multi file DB Checked on: 2.5.9.27126: OK, 0.750s. 3.0.5.33086: OK, 2.078s. 4.0.0.1378: OK, 8.500s.
80	database create 09	CS	2165	2300	2540	1200	2240	2280	2330	2360	2280	2000	2220	2210	2220	2190	2160	2170	2140	2140	2160	2230	2230	2220	2150	1960	2000	1980	1940	1880	1990	2000	1900	CREATE DATABASE - Multi file DB
81	database create 09	SS	1635	1920	1890	1060	1960	2200	2000	2280	2000	1680	1650	1680	1680	1630	1610	1630	1630	1600	1600	1640	1670	1670	1640	1540	1570	1560	1000	1480	1410	1200	1310	CREATE DATABASE - Multi file DB
82	database create 10	CS	2170	2270	2840	1190	2200	2280	2320	2320	2230	2210	2210	2190	2200	2170	2160	2170	2150	2180	2180	2000	2000	2230	2150	1950	2040	2030	1900	1970	1930	2160	1870	CREATE DATABASE - Multi file DB - starting
83	database create 10	SS	1630	1890	1900	970	1920	2090	1990	1920	1980	1680	1660	1000	1670	1630	1620	1640	1610	1610	1630	1620	1670	1670	1640	1560	1560	1550	1580	1470	1330	1130	1440	CREATE DATABASE - Multi file DB - starting
84	date datediff 07	CS	1610	1650	1680	1230	1640	1710	1670	1680	1640	1740	1610	1640	1640	1590	1590	1610	1620	1570	1610	1640	1640	1640	1590	1480	1600	1530	1520	1420	1350	1420	1440	test de la fonction datediff pour avoir le resultat en minute
85	date datediff 07	SS	1110	1520	1360	640	1380	1450	1430	1430	1440	1130	1110	1150	1260	1100	1110	1090	1070	1090	1080	1090	1110	1110	1090	1040	1110	1110	1020	1020	830	0	690	test de la fonction datediff pour avoir le resultat en minute
86	role create 01	CS	1610	1770	1760	840	1640	1770	2040	1920	1710	1670	1600	1640	1620	1610	1610	1590	1560	1600	1610	1670	1650	1610	1610	1000	1780	1610	1450	1520	1340	1480	1380	CREATE ROLE
87	role create 01	SS	1100	1370	1380	0	1000	1440	1440	1400	1440	1150	1120	1170	1100	1100	1070	1090	1100	1070	1090	1090	1140	1130	1110	1040	1060	1040	1030	1130	850	910	0	CREATE ROLE