0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (15 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 (4 rows)
5. Has fails: tests with at least one fail for previous runs (68 rows)
[CURRENT] 6. Has runtime errors: tests with at least one runtime error for previous runs (88 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (2225 rows)
9. All tests: durations (4278 rows)
A. Skipped: tests which was intentionally excluded from execution (8 rows)

Generated 02.12.2020 12:14 on host "IBSURGEON-2008":

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

Jump to LIST of unique test names from this report

NN Test name mode 4.0.0.2287
2020-12-02
4.0.0.2285
2020-12-01
4.0.0.2281
2020-11-30
4.0.0.2280
2020-11-29
4.0.0.2276
2020-11-26
4.0.0.2272
2020-11-21
4.0.0.2271
2020-11-20
4.0.0.2269
2020-11-18
4.0.0.2267
2020-11-17
4.0.0.2265
2020-11-14
4.0.0.2260
2020-11-13
4.0.0.2250
2020-11-11
4.0.0.2249
2020-11-09
4.0.0.2248
2020-11-07
4.0.0.2247
2020-11-05
4.0.0.2244
2020-11-04
4.0.0.2243
2020-11-02
4.0.0.2242
2020-10-30
4.0.0.2241
2020-10-29
4.0.0.2240
2020-10-28
4.0.0.2238
2020-10-27
4.0.0.2235
2020-10-24
4.0.0.2234
2020-10-23
4.0.0.2232
2020-10-22
4.0.0.2229
2020-10-21
4.0.0.2228
2020-10-19
4.0.0.2226
2020-10-15
4.0.0.2225
2020-10-11
4.0.0.2224
2020-10-10
4.0.0.2223
2020-10-09
Test TITLE
1 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
2 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Support hex numeric and string literals
4 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Support hex numeric and string literals
5 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gbak doesn't return error code
6 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gbak doesn't return error code
7 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Write note into log when automatic sweep is started
8 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Write note into log when automatic sweep is started
9 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
10 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
11 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
12 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
13 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
14 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
15 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Make it possible to restore compressed .nbk files without explicitly decompressing them
16 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Make it possible to restore compressed .nbk files without explicitly decompressing them
17 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Prohibit an ability to issue DML or DDL statements on RDB$ tables
18 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Prohibit an ability to issue DML or DDL statements on RDB$ tables
19 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
20 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
21 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
grant create database to ROLE does not work: "no permission for CREATE access to DATABASE ..."
22 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
grant create database to ROLE does not work: "no permission for CREATE access to DATABASE ..."
23 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
24 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
25 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
26 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
27 CS P P P P P P P P P P     F     P P P P     E         E         E         E     P P P P P P P P P P P
Wrong transaction can be passed to external engine
28 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Wrong transaction can be passed to external engine
29 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Allow the use of management statements in PSQL blocks: check only TRUSTED ROLE
30 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Allow the use of management statements in PSQL blocks: check only TRUSTED ROLE
31 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Firebird crashes ...
32 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Firebird crashes ...
33 CS P P P P P P P P P P     F     P P P P     E         E         E         E     P P P P P P P P P P P
External engine trigger crashing server if table have computed field
34 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
External engine trigger crashing server if table have computed field
35 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Permissions for create or alter statements are not checked
36 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Permissions for create or alter statements are not checked
37 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
38 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
39 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of several) rather then separate for each of used databases
40 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of several) rather then separate for each of used databases
41 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Grant lost in security.db after backup/restore cycle
42 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Grant lost in security.db after backup/restore cycle
43 CS P P P P     F     P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected)
44 SS P P P P     F     P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected)
45 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Wrong dependencies of stored function on view after backup and restore
46 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Wrong dependencies of stored function on view after backup and restore
47 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
A number of errors when database name is longer than 255 symbols
48 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
A number of errors when database name is longer than 255 symbols
49 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Signature mismatch when creating package body on identical packaged procedure header
50 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Signature mismatch when creating package body on identical packaged procedure header
51 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch
52 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch
53 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
fbsvcmgr can not decode information buffer returned by gfix list limbo service
54 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
fbsvcmgr can not decode information buffer returned by gfix list limbo service
55 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
56 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
57 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Allow usage of time zone displacement in config DefaultTimeZone
58 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Allow usage of time zone displacement in config DefaultTimeZone
59 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
FB crashes on attempt to create table with number of fields greater than 5460
60 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
FB crashes on attempt to create table with number of fields greater than 5460
61 CS P P P P P P     E     X X X X X X X X X X X X X X X X X X X X X X X
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
62 SS P P P P P P     E     X X X X X X X X X X X X X X X X X X X X X X X
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
63 CS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-03-d. Test for external table with field of SMALLINT datatype
64 SS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-03-d. Test for external table with field of SMALLINT datatype
65 CS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-04-d. Test for external table with field of INTEGER datatype
66 SS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-04-d. Test for external table with field of INTEGER datatype
67 CS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-04-d-bigint. Test for external table with field of BIGINT datatype
68 SS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-04-d-bigint. Test for external table with field of BIGINT datatype
69 CS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-04-d-int128. Test for external table with field of INT128 datatype
70 SS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-04-d-int128. Test for external table with field of INT128 datatype
71 CS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
72 SS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
73 CS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-09-d. Test for external table with field of DATE datatype
74 SS P P P P P P P P P P P P P P P     E         E         E     X X X X X X X X X X X X
GTCS/tests/external-file-09-d. Test for external table with field of DATE datatype
75 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges.
76 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges.
77 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
78 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
79 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
80 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
81 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
82 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
83 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
84 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
85 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
86 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
87 CS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gbak utility: check ability to use -ZIP command switch when create backup
88 SS P P P P P P P P P P P P P P P     E         E         E         E     P P P P P P P P P P P
gbak utility: check ability to use -ZIP command switch when create backup

Elapsed time, milliseconds:
NN Test name mode median_ms 4.0.0.2287
2020-12-02
4.0.0.2285
2020-12-01
4.0.0.2281
2020-11-30
4.0.0.2280
2020-11-29
4.0.0.2276
2020-11-26
4.0.0.2272
2020-11-21
4.0.0.2271
2020-11-20
4.0.0.2269
2020-11-18
4.0.0.2267
2020-11-17
4.0.0.2265
2020-11-14
4.0.0.2260
2020-11-13
4.0.0.2250
2020-11-11
4.0.0.2249
2020-11-09
4.0.0.2248
2020-11-07
4.0.0.2247
2020-11-05
4.0.0.2244
2020-11-04
4.0.0.2243
2020-11-02
4.0.0.2242
2020-10-30
4.0.0.2241
2020-10-29
4.0.0.2240
2020-10-28
4.0.0.2238
2020-10-27
4.0.0.2235
2020-10-24
4.0.0.2234
2020-10-23
4.0.0.2232
2020-10-22
4.0.0.2229
2020-10-21
4.0.0.2228
2020-10-19
4.0.0.2226
2020-10-15
4.0.0.2225
2020-10-11
4.0.0.2224
2020-10-10
4.0.0.2223
2020-10-09
Test TITLE
1 CS 7314 7180 7000 7219 7140 5919 7339 7609 7329 7909 7559 8279 7430 7720 7069 7410 1859 1809 1859 1940 7120 7379 7089 7300 7389 7490 7009 7289 7420 7350 7469
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
2 SS 6274 6109 6149 6119 6120 6720 6309 6609 6480 6549 6720 6420 6380 6000 6450 6119 2059 1690 1690 1690 6450 6000 6210 6289 6469 6360 6420 6379 6259 6160 6189
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 CS 1990 1990 2019 2000 2000 1519 2119 2139 2000 2150 2009 2019 2029 1990 1889 2049 1460 1450 1579 1490 1940 2089 1950 2099 1970 1990 2000 1920 1990 1920 1939
Support hex numeric and string literals
4 SS 1690 1680 1710 1679 1710 1690 1799 1789 1740 1690 1699 1700 1679 1730 1769 1680 1120 1130 1119 1129 1690 1730 1650 1759 1699 1680 1649 1710 1630 1629 1680
Support hex numeric and string literals
5 CS 4574 4129 4599 4150 4140 3130 4390 4669 4549 4730 4579 4890 4649 4649 4710 4430 1829 1829 1789 2220 4660 4859 4759 4570 4630 4740 4339 4670 4569 4670 4319
gbak doesn't return error code
6 SS 3444 3190 3280 3530 3190 3519 3440 3409 3589 3799 3619 3440 3610 3569 3710 3549 1639 1629 1650 1630 3640 3359 3360 3349 3449 3369 3789 3619 3549 3470 3389
gbak doesn't return error code
7 CS 11390 10559 10149 10200 10130 9000 12659 11419 12399 12870 12840 10819 11869 11400 11129 11509 1409 1420 1350 1340 11909 12230 12480 11589 11099 11759 11380 11940 11950 10910 10789
Write note into log when automatic sweep is started
8 SS 10609 10140 9960 9950 9970 9620 10829 10369 10879 10599 10619 11589 10409 11060 11440 11880 1090 1089 1150 1099 10579 10619 11049 13139 10850 10359 11300 12180 10809 10460 12119
Write note into log when automatic sweep is started
9 CS 8570 4400 4660 4429 4480 6140 9349 10779 10319 11169 10970 11000 4000 4440 9079 4610 1349 1410 1359 1359 9310 8650 11000 4340 8490 10329 9950 10000 12539 10000 4649
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
10 SS 5049 4829 4870 4920 4850 8990 4899 9069 5089 5889 5009 4849 4870 6770 6519 6669 1099 1509 1079 1109 6990 9200 9130 4980 8220 4840 4970 8679 6539 9370 7530
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
11 CS 6584 6309 6310 6529 6549 5730 6849 6629 6650 6599 6759 6659 6599 6230 6829 7000 1000 1840 1799 1940 6569 6220 6460 6910 7310 6870 6600 6950 6550 6549 6790
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
12 SS 6000 6259 5950 5929 6000 6059 6210 5940 6000 5990 6000 6360 6279 6269 5870 6200 1660 1879 1639 1589 6309 6389 6320 6000 5950 5850 6269 5930 6000 6239 5890
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
13 CS 27394 27089 26000 26549 26519 27000 27309 27799 28000 29139 28240 27299 28570 28170 27740 26980 2640 2630 2960 2669 28140 26980 28049 27190 28180 28029 28370 27230 27480 27740 27839
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
14 SS 29079 28530 27869 27799 27809 409190 28810 29049 28979 28730 29230 29769 29629 29279 29039 27980 2170 2170 2210 2109 29230 29279 29110 29119 29190 28389 30110 29869 29310 30429 29400
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
15 CS 9150 8000 8690 9060 8920 7139 9329 9599 9559 9230 9480 9670 9110 9190 9269 9339 1699 1530 1430 1659 9700 9109 9370 8980 9549 9370 9379 9279 8690 8989 8740
Make it possible to restore compressed .nbk files without explicitly decompressing them
16 SS 7230 6650 7299 7080 6990 7779 7539 7899 7890 7579 7519 7870 7419 7230 6990 7230 1259 1220 1279 1259 6879 7179 7110 7440 7389 7230 7359 6700 7130 7420 7000
Make it possible to restore compressed .nbk files without explicitly decompressing them
17 CS 13390 13080 13089 13119 12990 14039 13740 13410 13230 19160 14050 13589 13309 13720 13620 13689 1899 2099 2159 1890 13670 13370 14370 13369 15730 13669 14049 13759 12809 13159 13000
Prohibit an ability to issue DML or DDL statements on RDB$ tables
18 SS 12069 11860 11920 11900 12000 12779 12129 12180 12049 12240 12559 12579 11910 12529 12570 12700 1889 1670 1599 1880 14109 11930 12000 16450 12089 11910 12269 11769 12270 12380 11859
Prohibit an ability to issue DML or DDL statements on RDB$ tables
19 CS 2659 2649 2639 2620 2670 1849 3009 2680 2710 2700 2729 2769 3169 2819 2619 2859 1479 1759 1460 1670 2569 2769 2609 2790 2549 2820 2920 2909 2220 2220 2240
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
20 SS 1830 1829 1890 1830 1880 2049 1879 1890 2039 1900 1859 2140 1889 1849 1839 1820 1589 1119 1120 1130 1829 1819 1799 1830 1789 1789 1809 1789 1980 1950 1789
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
21 CS 7440 7580 7519 7459 7399 5740 7430 8100 8059 7759 7789 8110 7680 7840 7769 7319 1570 1539 1460 1459 7450 7230 7660 7419 7419 8039 7630 7320 7259 7020 7160
grant create database to ROLE does not work: "no permission for CREATE access to DATABASE ..."
22 SS 5685 5519 5570 5559 5559 6200 6000 5789 5759 5000 5980 5859 5700 5710 5730 5819 1110 1149 1099 1119 5739 5620 5579 5690 5639 5000 5589 5730 5720 5850 5680
grant create database to ROLE does not work: "no permission for CREATE access to DATABASE ..."
23 CS 4599 4620 4629 4589 4539 3830 4759 4910 4900 4970 4000 4590 4829 4569 4740 4529 1759 1859 1869 1840 4530 4879 4460 4609 4859 4809 4730 4960 4000 4739 4569
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
24 SS 3154 3180 3160 3159 3130 4410 3460 3150 3169 3129 3420 3520 3170 3069 3039 3269 1629 1819 1629 1579 3490 3130 3299 3120 3119 3120 3450 3149 3259 3200 3140
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
25 CS 18674 18339 18369 17990 17890 15740 20159 19690 19470 19660 19440 19329 19299 18930 19079 19619 2420 2200 2079 2190 18519 22139 18450 18589 18730 18619 21509 18789 18230 18730 18460
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
26 SS 17170 16199 16200 16329 16359 17529 17360 17409 16940 17550 17480 17400 17639 17259 17200 16509 1970 1960 1900 1869 17220 17100 17330 17289 17350 17089 17599 17399 17019 17140 17039
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
27 CS 3325 3299 3589 3299 3259 2769 3350 3310 3450 3390 3330 6039 3509 3369 3349 3389 1490 1519 1450 1460 3269 3269 3160 3410 3439 3000 3450 3350 3289 3349 3320
Wrong transaction can be passed to external engine
28 SS 3059 3059 3079 3089 3079 3329 3420 3150 3079 3059 3029 3350 2970 3059 3269 3009 1130 1129 1119 1120 3029 3049 3080 3079 3080 3009 3100 2990 3009 3009 3019
Wrong transaction can be passed to external engine
29 CS 5064 4720 4639 4240 4269 3600 5849 5470 5490 5829 5000 5259 4960 5359 4810 5670 1819 1920 2339 2409 5459 5129 4939 5360 5849 5769 5269 5140 4759 4630 5519
Allow the use of management statements in PSQL blocks: check only TRUSTED ROLE
30 SS 3559 3360 3309 3180 3269 3940 3579 3539 3950 3529 3699 3569 3550 3740 3910 3859 1629 1580 1629 2000 3389 3700 3420 3970 3830 3769 3420 4070 3830 3370 4049
Allow the use of management statements in PSQL blocks: check only TRUSTED ROLE
31 CS 4529 4490 4529 4549 4510 3980 4880 4529 4529 4539 4559 4689 4650 4830 4799 4439 1799 1819 1789 1790 4380 4390 4370 4390 4319 4659 4529 5019 4650 4569 4740
Firebird crashes ...
32 SS 3599 3569 3600 3569 3629 4610 3640 3599 3960 3849 3980 3630 3600 3960 3549 3859 1589 1590 1640 1639 3830 3470 3649 3450 3000 3769 3769 3480 3540 3480 3580
Firebird crashes ...
33 CS 2965 2930 2960 2960 2980 2490 3060 3019 2970 3000 3000 4220 3119 3039 3060 3009 1490 1539 1470 1470 2960 2950 2930 2930 2890 2990 2970 3059 2879 2829 2979
External engine trigger crashing server if table have computed field
34 SS 2670 2730 2670 2620 2649 2850 2789 2740 2789 2720 2700 2740 2679 2730 2689 2619 1109 1110 1150 1129 2620 2710 3029 2599 2700 2620 2609 2670 2649 2519 2530
External engine trigger crashing server if table have computed field
35 CS 3349 3380 3350 3349 3330 2459 3430 3399 3380 3379 3410 3349 3490 3379 3389 3349 1490 1509 1490 1429 3279 3339 3350 3359 3359 3410 3340 3350 3019 2920 3240
Permissions for create or alter statements are not checked
36 SS 2639 2679 2639 2599 2599 2740 2779 2720 2640 2930 2640 2730 2650 2700 2710 2549 1110 1139 1099 1120 2620 2560 2549 2639 2570 2549 2569 2650 2650 2639 2599
Permissions for create or alter statements are not checked
37 CS 6529 6490 6519 6000 6509 5990 6529 7189 6639 6560 6599 6470 6550 6529 6679 6529 1910 1930 1920 1810 6529 6559 6509 6619 6470 6569 6569 6529 6730 6509 6419
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
38 SS 6194 6280 6000 6190 6160 6220 6210 6220 6299 6259 6209 6190 6240 6190 6199 6120 1659 1700 1660 1710 6000 6240 6140 6210 6120 6119 6210 6209 6219 6240 6130
Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids
39 CS 22034 22009 22009 22019 21890 20019 22230 21859 22369 22589 22479 22380 22099 22140 21000 22110 1809 1849 1789 1769 22220 22119 22220 22089 22220 22000 22109 22029 22039 22020 22009
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of several) rather then separate for each of used databases
40 SS 20584 20319 20720 20400 20319 21299 20480 21059 20779 20680 20930 20710 20910 20559 20430 20430 1680 1629 1710 1640 20539 20420 20779 20659 20480 20950 20729 20769 20869 20609 20330
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of several) rather then separate for each of used databases
41 CS 8009 7639 7000 7519 7569 6789 8470 8109 8200 8099 8080 8009 7980 8279 7590 8029 1689 1529 1859 1420 8149 7910 8269 8319 8030 8079 8400 8339 8009 7769 7630
Grant lost in security.db after backup/restore cycle
42 SS 7194 6740 6000 6759 6819 7619 7550 7170 7279 7220 7679 7690 7590 7000 7309 7370 1109 1120 1089 1130 7019 6940 7420 7909 7210 7350 7009 7070 7179 7259 7319
Grant lost in security.db after backup/restore cycle
43 CS 1799 1800 1799 1809 1790 1440 1810 1779 1819 1830 1819 1779 2069 1800 1000 1810 1509 1710 1460 1429 1799 1779 1789 1790 1809 1759 1809 1830 1819 1799 1769
Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected)
44 SS 1444 1439 1450 1490 1440 1759 1480 1000 1460 1450 1480 1459 1449 1420 1440 1449 1099 1129 1090 1129 1430 1419 1469 1470 1399 1439 1429 1460 1440 1449 1470
Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected)
45 CS 3730 3710 3730 3730 3690 3079 4070 3739 3809 4090 3000 3670 3950 3649 3629 3980 1470 1869 1459 1420 3779 3909 4149 3679 3829 3620 4110 3730 4079 3740 4140
Wrong dependencies of stored function on view after backup and restore
46 SS 3384 3349 3369 3380 3459 3799 3390 3549 3720 3349 3419 3599 3440 3259 3389 3340 1099 1120 1090 1129 3339 3320 3490 3400 3740 3730 3360 3349 3350 3440 3400
Wrong dependencies of stored function on view after backup and restore
47 CS 13869 13330 13370 13419 13319 11149 14900 14299 13990 13819 14389 14179 13869 13900 13879 14230 1960 1000 1460 1909 13970 13649 13680 13980 13960 13629 14180 14520 13910 13870 13509
A number of errors when database name is longer than 255 symbols
48 SS 11514 11039 11170 11130 11040 11809 12169 11680 11779 11470 11710 11599 11519 11639 11000 11669 1099 1130 1470 1129 11440 11470 11700 11399 11809 12000 11639 11509 11579 11480 11680
A number of errors when database name is longer than 255 symbols
49 CS 4119 4129 4129 4110 4100 3430 4279 4180 4209 4170 4180 4230 4130 4150 4270 4170 1829 1940 2169 1840 4180 4039 3959 4060 4110 3990 4099 4099 4339 4129 4019
Signature mismatch when creating package body on identical packaged procedure header
50 SS 3814 3779 3859 3920 3799 3970 3890 3819 3839 3839 4009 3910 3909 3809 3730 3860 1610 1659 1669 1680 3769 3799 3829 3810 3820 3909 3809 3789 3769 3869 3799
Signature mismatch when creating package body on identical packaged procedure header
51 CS 4364 4230 4000 4279 4319 3579 4600 4610 4580 4289 4660 4650 6769 4589 4190 4660 1830 1900 1869 1850 4350 4180 4609 4859 4509 4449 4430 4289 4710 4379 4000
gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch
52 SS 3889 3759 3740 3789 3779 4090 4049 3920 4100 3730 4029 4230 4089 3720 3620 3870 1769 1650 1990 1650 3960 3779 3909 3870 4019 4069 3710 3940 4069 4240 3910
gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch
53 CS 19415 6269 6190 5770 5839 21059 22920 26330 19430 24869 17809 25190 24519 23120 26929 24460 1650 1519 1439 1570 27049 19400 18519 26269 20169 8759 25779 17470 10579 27779 8970
fbsvcmgr can not decode information buffer returned by gfix list limbo service
54 SS 13699 5900 5849 5960 5960 23890 15849 16740 14449 10000 13889 18240 14880 13539 14410 13920 1110 1400 1129 1269 8700 15490 16569 15319 8289 18690 8860 13860 8289 18019 7740
fbsvcmgr can not decode information buffer returned by gfix list limbo service
55 CS 4574 4379 4340 4369 4389 4049 4620 4580 4569 4850 4620 5979 5039 4950 4569 4940 1759 1850 1860 1950 4660 4579 4690 4900 4590 4519 4559 4549 4859 4599 4559
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
56 SS 4115 3930 3960 3980 3980 4349 5210 4109 4360 4670 4120 4230 4609 4160 4120 4170 1610 1630 1939 1819 4089 4909 4150 4130 4109 4109 4109 4289 4109 4529 4110
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
57 CS 3870 3759 3779 3809 3000 2950 4039 4000 3839 4019 4139 3950 4069 3819 3920 3940 1470 1509 1480 1469 4319 3769 3809 3980 3850 3960 3779 3980 3890 4099 4120
Allow usage of time zone displacement in config DefaultTimeZone
58 SS 3379 3279 3339 3290 3229 3410 3420 3430 3460 3400 3430 3329 3369 3440 3210 3460 1180 1120 1119 1099 3779 3390 3230 3529 3399 3450 3359 3990 3559 3279 3350
Allow usage of time zone displacement in config DefaultTimeZone
59 CS 25630 24799 24919 24940 24900 24849 26659 25569 25440 26079 25680 25889 26879 26490 26159 25620 2009 1859 1789 1799 25440 26299 26850 26220 25350 25480 26019 26130 25940 25950 25640
FB crashes on attempt to create table with number of fields greater than 5460
60 SS 24579 24350 24559 24389 24269 25039 24720 25039 25029 25390 25690 25329 24130 25539 25169 25139 1639 1879 1810 1589 24310 24000 24169 24410 24209 25329 24909 24470 24799 24599 25720
FB crashes on attempt to create table with number of fields greater than 5460
61 CS 2339 2370 2339 2340 2329 1709 2390 9
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
62 SS 1870 1910 1829 1870 1880 1879 1859 9
Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
63 CS 2969 2960 2960 2980 2940 2559 2979 2980 2979 3009 2980 2930 3140 3000 2960 3300 1819 2119 1740
GTCS/tests/external-file-03-d. Test for external table with field of SMALLINT datatype
64 SS 2734 2799 2779 2720 2710 2860 2729 2759 2740 3449 2740 2000 2740 2970 2720 2669 1700 1640 1580
GTCS/tests/external-file-03-d. Test for external table with field of SMALLINT datatype
65 CS 2970 2959 2980 2960 2940 2559 2980 2990 2919 2990 2980 3220 2960 3290 3140 2980 2079 2200 1789
GTCS/tests/external-file-04-d. Test for external table with field of INTEGER datatype
66 SS 2735 2000 2730 2000 2720 2809 2789 2730 2759 2759 3120 3019 2730 2779 2740 2779 1980 1630 1689
GTCS/tests/external-file-04-d. Test for external table with field of INTEGER datatype
67 CS 2975 2980 2970 2960 2950 2590 2970 2980 3009 2980 2980 2940 2990 2980 3279 3019 1850 1829 1000
GTCS/tests/external-file-04-d-bigint. Test for external table with field of BIGINT datatype
68 SS 2730 2720 2760 2000 2000 2839 2730 2730 2000 2780 2809 2769 2720 3049 2789 2890 1640 1649 1609
GTCS/tests/external-file-04-d-bigint. Test for external table with field of BIGINT datatype
69 CS 2960 2960 2959 2960 2959 2849 3220 3150 3260 3039 3279 3069 2950 2979 2959 3119 1819 1890 1789
GTCS/tests/external-file-04-d-int128. Test for external table with field of INT128 datatype
70 SS 2715 2710 2709 2000 2730 2960 2720 2720 2000 2730 2730 2000 2759 2730 2720 2670 1639 1720 1590
GTCS/tests/external-file-04-d-int128. Test for external table with field of INT128 datatype
71 CS 2975 2960 2960 3170 2950 2930 3600 3309 2920 3259 3139 2919 3000 3329 2990 3329 1799 1869 2000
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
72 SS 2730 2730 2730 2000 2740 2819 2730 2740 2740 2789 2740 2000 2000 2730 2740 2679 1630 1629 1600
GTCS/tests/external-file-06-d. Test for external table with field of DOUBLE PRECISION datatype
73 CS 2975 2960 2970 2959 2980 2579 3240 2980 3039 3340 3080 3010 2980 2970 3190 2950 2110 2289 1799
GTCS/tests/external-file-09-d. Test for external table with field of DATE datatype
74 SS 2724 2730 2769 2720 2720 2800 2000 2730 2000 2779 2990 2000 2729 2740 3150 2680 1629 2110 1589
GTCS/tests/external-file-09-d. Test for external table with field of DATE datatype
75 CS 4974 4950 4950 5049 4990 4909 5299 5019 4960 5009 4899 5020 5230 5000 5089 4990 2230 1950 1880 1869 4869 4969 4980 4960 4890 4980 5190 4950 4959 5450 5279
Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges.
76 SS 4639 4559 4660 4619 4659 4669 4920 4609 4629 4769 4930 4919 4629 4860 4900 4690 1650 2029 1880 1639 4629 4529 4640 4639 4639 4000 4669 4959 4639 4529 4660
Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges.
77 CS 18709 11099 11420 11120 11339 17869 17450 24090 21279 22759 19980 15269 18899 18849 17420 19039 1000 1820 4110 5259 21549 17000 22039 20120 23169 24720 25159 19980 22440 15580 18569
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
78 SS 16369 9240 9410 9389 9160 19019 11779 15950 16789 14869 25380 19170 17269 20450 17319 14349 2390 1670 1580 1579 14619 15850 18850 17059 21130 13839 21450 21429 19220 21640 18039
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
79 CS 227039 79390 80190 80210 78920 236090 228779 225299 235830 222049 213399 214380 246940 244170 247450 219850 1000 1829 1779 1779 247470 260349 262430 236009 251680 242119 253480 235809 222839 106899 229170
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
80 SS 210110 66169 63919 65770 63849 213970 213230 172570 207009 219620 262859 212220 202880 216049 202550 173539 2049 1659 1589 1590 208000 253000 225889 248930 204589 276170 252430 280519 256319 233579 243030
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
81 CS 14124 10349 9700 9930 9730 10569 16269 16549 11119 13990 15900 14259 18420 16970 12950 13839 1000 1829 1740 1000 21019 14319 16200 14360 17910 16099 15769 13340 16589 14860 13769
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
82 SS 11200 8269 8129 8269 8269 13340 13259 10740 13539 16099 15259 11660 10359 8639 9000 8859 1590 1640 1640 2119 16609 22000 12320 23370 8299 14539 14490 8440 15019 11830 19509
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
83 CS 15679 10099 10150 9779 9819 11019 15169 16579 16610 16599 16660 17259 17099 18470 17950 16549 4119 1829 1799 1759 17039 15850 12509 11480 15509 16259 14100 16740 15920 11799 17879
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
84 SS 11634 8180 8060 8359 8279 14400 11670 8000 14009 13559 18559 23759 11339 12610 10349 14000 1599 1000 1610 1799 14609 21569 20269 17950 10600 10290 11599 19450 11959 9460 13430
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
85 CS 15604 9730 9769 9769 9769 13889 16839 13030 16319 20000 16480 15509 11119 21769 18159 14629 3779 2309 3710 3289 15700 16650 12960 17419 19119 19139 16469 16870 17109 13539 17670
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
86 SS 11730 8860 8299 8819 8000 13230 12039 9130 12460 10000 12269 14139 14650 12000 12590 10529 1590 2579 2090 1599 16560 24099 10220 13819 11090 12870 14310 19759 8459 11460 13079
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
87 CS 7429 6970 6950 6950 6990 6410 7880 7900 7399 7000 7829 7590 7690 8049 7529 8059 1960 1940 1880 1869 7649 7789 7059 7549 7109 7560 7350 7460 7529 7509 7240
gbak utility: check ability to use -ZIP command switch when create backup
88 SS 6849 6410 6349 6349 6450 7029 6990 6860 6960 6700 6970 6970 6849 7580 7049 6490 1700 2009 1660 2039 7079 6789 6710 6520 6850 6849 7029 6759 7279 6870 7960
gbak utility: check ability to use -ZIP command switch when create backup

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1725
http://tracker.firebirdsql.org/browse/core-1760
http://tracker.firebirdsql.org/browse/core-2251
http://tracker.firebirdsql.org/browse/core-2668
http://tracker.firebirdsql.org/browse/core-2879
http://tracker.firebirdsql.org/browse/core-3977
http://tracker.firebirdsql.org/browse/core-4236
http://tracker.firebirdsql.org/browse/core-4462
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-4766
http://tracker.firebirdsql.org/browse/core-4821
http://tracker.firebirdsql.org/browse/core-5364
http://tracker.firebirdsql.org/browse/core-5538
http://tracker.firebirdsql.org/browse/core-5645
http://tracker.firebirdsql.org/browse/core-5887
http://tracker.firebirdsql.org/browse/core-5936
http://tracker.firebirdsql.org/browse/core-5972
http://tracker.firebirdsql.org/browse/core-6078
http://tracker.firebirdsql.org/browse/core-6095
http://tracker.firebirdsql.org/browse/core-6182
http://tracker.firebirdsql.org/browse/core-6208
http://tracker.firebirdsql.org/browse/core-6211
http://tracker.firebirdsql.org/browse/core-6233
http://tracker.firebirdsql.org/browse/core-6248
http://tracker.firebirdsql.org/browse/core-6250
http://tracker.firebirdsql.org/browse/core-6264
http://tracker.firebirdsql.org/browse/core-6309
http://tracker.firebirdsql.org/browse/core-6329
http://tracker.firebirdsql.org/browse/core-6395
http://tracker.firebirdsql.org/browse/core-6411
http://tracker.firebirdsql.org/browse/core-6440
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-03-d.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-04-d-bigint.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-04-d-int128.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-04-d.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-06-d.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/external-file-09-d.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/syspriv/trace_any_attachment.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-merge-deny-multiple-matches.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-max-limit.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-delete-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-merge-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-04.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/util/gbak_zip.fbt

=== end of list ===