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

Generated 26.09.2021 18:07
Tested: FB50.   Build: 5.0.0.229;   SS: 26.09.21 14:56:02 - 26.09.21 16:29:22;   CS: 26.09.21 16:32:13 - 26.09.21 18:03:45;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 

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 5.0.0.229
2021-09-26
5.0.0.228
2021-09-23
5.0.0.220
2021-09-23
5.0.0.219
2021-09-20
5.0.0.218
2021-09-19
5.0.0.215
2021-09-17
5.0.0.212
2021-09-16
5.0.0.208
2021-09-16
5.0.0.202
2021-09-14
5.0.0.198
2021-09-12
5.0.0.197
2021-09-11
5.0.0.196
2021-09-10
5.0.0.193
2021-09-09
5.0.0.192
2021-09-08
5.0.0.187
2021-09-07
5.0.0.186
2021-09-04
5.0.0.181
2021-09-03
5.0.0.176
2021-09-02
5.0.0.172
2021-09-01
5.0.0.169
2021-08-30
5.0.0.168
2021-08-29
5.0.0.163
2021-08-27
5.0.0.158
2021-08-26
5.0.0.157
2021-08-23
5.0.0.149
2021-08-22
5.0.0.143
2021-08-21
5.0.0.142
2021-08-17
5.0.0.141
2021-08-14
5.0.0.140
2021-08-13
5.0.0.139
2021-08-12
Test TITLE
1 CS P P X P P P P P P P P P P P P P P P P P P     F     U P P P P P P P
Lot of syntax tests for COALESCE()
2 CS P P X 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
Privileges of dynamic statements in SP
3 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
Grants don't work for procedures used inside views
4 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
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
5 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
Can't create table using long username and UTF8 as attachment charset
6 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
7 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
8 CS P P X 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
Recursive stored procedure shouldnt require execute right to call itself
9 CS P P X 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
Ability to cancel waiting in lock manager
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     F     P P P P P
Ability to cancel waiting in lock manager
11 CS P P X 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
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
12 CS P P X 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
Extend syntax for ALTER USER CURRENT_USER
13 CS P P X P P P P P     F     P P P     F     P P P P P P     F         F     P     F     P P P P P P P
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
14 CS P P X 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
with caller privileges option do not work with autonomous transaction option
15 CS P P X 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
role not passed on external execute stmt
16 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
17 CS P P X P P P P P P P P P P P P P P P P     F     U     F     U P P P P P P P
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
18 SS P P P P P P P P P P P P P P P P P P P     F         F         F     P P P P P P P P
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
19 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
Duplicate tags for CREATE/ALTER USER not handled correctly
20 CS P P X 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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
21 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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
22 CS P P X P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
23 SS P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F     P P     E     P P P P P
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
24 CS P P X P P P P P P P P P P     F         F         F         F         F         F         F     U     F     U P P P P P P P
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
25 SS P P P P P P P P P P P P P     F         F         F         F         F         F         F         F         F     P P P P P P P P
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
26 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
27 SS 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
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
28 CS P P X P P P P P P     F         F     P P P P P P P P P U P U 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
29 SS P P U P P P P P P     F         F     P P P P P P P P P P P P P     E     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
30 CS P P X 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
ISQL 'SHOW DATABASE' command does not show encryption status of database
31 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
SEC$ tables and tag/attributes
32 CS P P X P P P P P P P P P P P     F     P P P     F     P U P U P P P     F     P P P
Bad optimization of some operations with views containing subqueries
33 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     E     P P P     F     P
Bad optimization of some operations with views containing subqueries
34 CS P P X P P P P P P P P P P P P P P P P     F     U     F     U P P P P P P P
Support for DROP IDENTITY clause
35 SS P P P P P P P P P P P P P P P P P P P     F         F         F     P P P P P P P P
Support for DROP IDENTITY clause
36 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
37 SS P P U P P P P P P     F         F     P P P P P P P P P P P P P     E     P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
38 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
Bugcheck on queries containing WITH LOCK clause
39 SS P P P P P P P P P     F         F     P P P P P P P P P P P P P     E     P P P P P
Bugcheck on queries containing WITH LOCK clause
40 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
Shadow file is can not be created during restore when -use_all_space option is used
41 SS P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P P P P
Shadow file is can not be created during restore when -use_all_space option is used
42 SS     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 P P P P P
Parse error when compiling a statement causes memory leak until attachment is disconnected
43 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
ALTER CURRENT USER fails with "no permission for <...> TABLE PLG$SRP" if current user: 1) has NO admin role and 2) wants to modify his own TAGS list
44 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
error read permission for BLOB field, when it is input/output procedure`s parametr
45 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
USING PLUGIN clause does not work in RECREATE USER
46 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     P
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of several) rather then separate for each of used databases
47 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
48 SS P P P P P P P P P     F         F     P P P P P P P P P P P P P P P P P P P
Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
49 CS P P X P P P P P P P P P P P P P     F     P P P P P     F     P P P P P P P
Feature CORE-6482 - System table with keywords.
50 SS P P P P P P P P P P P P P P P P     F     P P P P P     F     P     E     P P P P P
Feature CORE-6482 - System table with keywords.
51 CS P P X P P P P P P P P P P P P P P P P P P     F     U P P P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
52 SS 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
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
53 CS     F         F     X     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    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
54 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         E         F         F         F         F         F    
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
55 CS P P X P P P P P P P P     F     P P P P P P P P U P U P P P P P P P
ISQL - SHOW DATABASE
56 SS P P U 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
ISQL - SHOW DATABASE
57 CS P P X P P P P P P P P     F         F         F         F         F         F         F         F         F     U     F     U P P P P P P P
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
58 SS P P U P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F     P P P P P P P P
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
59 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
GTCS/tests/CF_ISQL_34. minimum-grant-test
60 CS P P X P P P P P P P P P P P P P P P P     F     U     F     U P P P P P P P
Check ability to update content of RDB$TYPES.
61 SS P P U P P P P P P P P P P P P P P P P     F         F         F     P P P P P P P P
Check ability to update content of RDB$TYPES.
62 CS P P X P P P P P P P P P P P P P P P P P U P U P     F     P P P P P
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
63 SS P P U 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
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
64 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
65 SS P P U P P P P P P     F         F     P P P P P P P P P P P P P P P P P P P
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
66 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
Check ability to run complex query
67 SS P P U P P P P P P     F         F     P P P P P P P P P P P P P P P P P P P
Check ability to run complex query
68 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
Compiler check. Test ability to compile source code of OLTP-EMUL test.
69 SS P P U 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
Compiler check. Test ability to compile source code of OLTP-EMUL test.
70 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
71 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
72 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
73 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
74 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
75 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
76 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
77 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
78 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
79 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
80 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
81 CS P P X P P P P P P P P P P P P P P P P P U     F     U P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
82 CS P P X P P P P P P     F         F     P P P P P P P P P U P U P P P P P P P
gbak utility: check ability to use -ZIP command switch when create backup
83 SS P P U P P P P P P     F         F     P P P P P P P P 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 5.0.0.229
2021-09-26
5.0.0.228
2021-09-23
5.0.0.220
2021-09-23
5.0.0.219
2021-09-20
5.0.0.218
2021-09-19
5.0.0.215
2021-09-17
5.0.0.212
2021-09-16
5.0.0.208
2021-09-16
5.0.0.202
2021-09-14
5.0.0.198
2021-09-12
5.0.0.197
2021-09-11
5.0.0.196
2021-09-10
5.0.0.193
2021-09-09
5.0.0.192
2021-09-08
5.0.0.187
2021-09-07
5.0.0.186
2021-09-04
5.0.0.181
2021-09-03
5.0.0.176
2021-09-02
5.0.0.172
2021-09-01
5.0.0.169
2021-08-30
5.0.0.168
2021-08-29
5.0.0.163
2021-08-27
5.0.0.158
2021-08-26
5.0.0.157
2021-08-23
5.0.0.149
2021-08-22
5.0.0.143
2021-08-21
5.0.0.142
2021-08-17
5.0.0.141
2021-08-14
5.0.0.140
2021-08-13
5.0.0.139
2021-08-12
Test TITLE
1 CS 2700 2600 2820 2910 2700 2779 2889 2700 2539 2700 2800 2789 3029 2800 2700 2629 2769 3109 3310 2819 2559 1529 0 2599 2000 2699 2690 2570 2759 2670
Lot of syntax tests for COALESCE()
2 CS 2359 2129 2240 2640 2389 2369 2309 2000 2590 2410 2429 2180 2180 2340 2359 2370 2000 2509 2269 2360 2400 2349 2649 2140 779 2540 2200 2710 2690 2209
Privileges of dynamic statements in SP
3 CS 1924 2039 2160 2089 1939 2109 1970 1960 1910 1959 1899 1880 1830 2049 1869 2000 1899 1830 2019 1809 9 1849 0 1910 1009 1950 1919 1980 1930 1689
Grants don't work for procedures used inside views
4 SS 2310 2359 2469 2000 2000 2809 2370 2359 2330 2440 2459 2759 2289 2389 2189 2000 2419 2159 2279 2200 2380 2359 2290 2199 2289 89 2490 2289 2440 2269 2270
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
5 CS 1514 1440 1000 1509 1720 2029 1660 1539 1509 1569 1630 1490 1470 1469 1529 1470 1419 1599 1559 1559 0 1480 9 1579 1259 1440 1519 1619 1680 1460
Can't create table using long username and UTF8 as attachment charset
6 CS 1710 1670 2000 1780 1710 1829 1759 2079 1650 1849 1600 1740 1909 1670 1629 1930 1720 1639 1619 1680 0 1710 9 1639 1779 1650 1680 1000 1779 1779
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
7 CS 1334 1369 1339 1420 1339 1339 1409 1330 1300 1370 1409 1319 1579 1419 1400 1309 1279 1340 1289 1319 9 1289 0 1289 1190 1460 1269 1300 1339 1309
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
8 CS 2329 2609 2329 2220 2369 2349 2580 2430 2259 2840 2279 2299 2360 2329 2000 3150 2460 2539 2339 2200 2359 2279 2259 2710 930 2179 2240 2309 2309 2069
Recursive stored procedure shouldnt require execute right to call itself
9 CS 2339 2240 2900 2659 2320 2450 2480 2410 2269 2309 2369 2319 2230 2169 2339 2270 2420 2299 2240 2370 2469 2710 2170 2240 16700 2420 2159 2480 2289 2440
Ability to cancel waiting in lock manager
10 SS 2995 3269 2130 3189 2150 2150 2000 2419 3280 3060 3480 2130 3069 3000 3120 2200 2180 2000 2029 3019 3220 1980 3209 3039 3059 17039 3189 1950 2160 2990 2059
Ability to cancel waiting in lock manager
11 CS 1829 1710 1789 1879 1870 1930 1769 1860 1759 1759 1929 1720 1839 1819 1990 1859 1759 1860 1920 1759 2019 1809 1839 1780 1210 1829 1779 2080 1850 1740
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
12 CS 2169 2269 2319 2159 2390 2220 2059 2259 2269 2019 2200 2120 2130 2150 2240 2450 2259 2090 2230 2240 2190 2170 2069 2059 889 2029 2059 2160 2169 2149
Extend syntax for ALTER USER CURRENT_USER
13 CS 1119 1169 1210 1240 1049 1230 1109 1129 1029 1059 1170 1269 1079 1090 1139 1140 1060 1100 1079 1039 1170 1109 1089 1079 1129 1179 1110 1119 1170 1170
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
14 CS 1799 1850 2090 1679 1710 1769 1930 1829 1799 1799 1740 2269 1789 2049 1700 1840 1799 1789 1790 1000 1959 1719 1850 2159 1029 1820 1690 1880 1840 1709
with caller privileges option do not work with autonomous transaction option
15 CS 1789 1729 1789 1789 1740 1950 1910 1759 1759 1819 1669 1819 1680 1680 1759 1880 2269 1759 1839 1779 1849 1859 1779 1799 929 1819 1789 1779 1759 1819
role not passed on external execute stmt
16 CS 1169 1220 1209 1230 1150 1000 1189 1269 1190 1170 1130 1110 1130 1169 1069 1159 1180 1150 1180 1049 0 1299 0 1190 1060 1130 1160 1189 1179 1130
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
17 CS 11870 11860 11930 11940 12130 12059 12210 11859 12049 11870 11850 12000 11929 11829 11879 12029 11840 11829 11919 11860 9 11890 9 11860 11869 11869 11860 11950 11910 11819
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
18 SS 11874 11960 11980 12079 11909 11919 11940 11950 12019 11909 11869 11950 11849 11919 11779 11899 11869 11859 11859 11819 11930 11849 11850 11799 11839 11840 11819 11779 11819 11880 12059
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
19 CS 1684 1429 1509 1829 1779 1930 1519 1789 1700 2190 1000 1529 1470 1920 1720 1889 1480 1990 1490 1470 0 1519 9 1380 1009 1669 1949 1730 1829 2029
Duplicate tags for CREATE/ALTER USER not handled correctly
20 CS 1779 1710 1730 1779 1000 1809 1759 1950 1809 1980 1699 1849 1670 1789 1960 1710 1779 1910 1779 1740 1720 1819 1779 1910 1490 1720 1829 1730 1870 1829
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
21 SS 1325 1419 1320 1390 1280 1439 1380 1539 1370 1300 1449 1359 1769 1369 1319 1299 1339 1400 1270 1200 1299 1230 1289 1259 1230 1400 1339 1330 1309 1269 1289
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
22 CS 1200 1450 1200 1220 1200 1229 1150 1149 1190 1170 1340 1190 1109 1190 1180 1210 1240 1240 1200 1129 1259 1190 1230 1289 1210 1190 1160 1279 1000 1180
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
23 SS 1160 1190 1190 1309 1299 1090 1270 1200 1220 1200 1089 1169 1129 1130 1470 1129 1090 1200 1160 1160 1100 1119 1160 1180 1070 0 1059 1110 1069 1059 1070
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
24 CS 1130 1200 1230 1159 1209 1100 1199 1119 1129 1220 1150 1160 1180 1100 1120 1090 1079 1070 1209 1079 0 1109 0 1120 1150 1130 1020 1099 1210 1210
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
25 SS 1115 1279 1120 1669 1190 1310 1350 1180 1200 1089 1139 1169 1069 1150 1079 1019 1149 1069 1139 1129 1059 1089 1069 1110 1000 1090 1129 990 1040 1050 1069
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
26 CS 2349 2190 2509 3220 3049 3529 3630 2609 3719 2410 2319 2529 2419 2390 2299 2279 2000 2339 2000 2420 0 2349 0 2340 2209 2310 2349 2279 2400 2269
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
27 SS 2359 2660 2350 2319 2269 2630 2380 2380 2650 2419 2389 2359 2070 2000 2130 2359 2380 2670 2289 2389 2599 2299 2210 2220 2299 2470 2380 2109 2380 2210 2290
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
28 CS 2599 2620 2289 2299 2640 2440 2000 2289 2550 2190 1939 2000 2259 2759 2599 2719 3059 3040 2420 2289 0 2609 0 2640 2970 2740 2619 2889 3190 2469
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
29 SS 2470 2640 2990 0 2549 2770 2879 2659 2840 2420 2110 2070 2509 2460 2410 2420 2539 2440 2539 2399 2389 2579 2340 2379 2390 0 2480 2509 2390 2549 2449
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
30 CS 4390 4450 4399 4379 4450 4549 4410 4369 4369 4359 4360 4329 4359 4319 4370 4449 4349 4430 4509 4509 4480 4370 4480 4379 4390 4329 4640 4529 4399 4380
ISQL 'SHOW DATABASE' command does not show encryption status of database
31 CS 1240 1400 1230 1240 1240 1190 1399 1199 1440 1210 1230 1089 1099 1390 1349 1200 1270 1309 1150 1100 0 1160 0 1340 969 1210 1320 1480 1370 1279
SEC$ tables and tag/attributes
32 CS 2599 3020 2599 2740 2629 2980 2620 2490 2700 2779 2640 2859 2470 2469 2519 2529 2580 2529 2669 2670 9 2740 9 2419 2549 2450 2570 2630 2630 2449
Bad optimization of some operations with views containing subqueries
33 SS 2359 2730 2670 2389 2450 2000 2400 2700 2299 2689 2339 2279 2700 2230 2779 2259 2269 2259 2389 2370 2350 2299 2310 2240 2379 0 2330 2359 2360 2259 2379
Bad optimization of some operations with views containing subqueries
34 CS 1299 1289 1289 1259 1309 1490 1710 1329 1269 1309 1299 1199 1379 1359 1240 1240 1379 1340 1339 1410 0 1279 0 1190 1269 1269 1289 1369 1309 1230
Support for DROP IDENTITY clause
35 SS 1274 1410 1279 1309 1380 1399 1409 1339 1349 1240 1269 1389 1269 1220 1269 1240 1160 1210 1259 1259 1340 1259 1279 1160 1279 1319 1269 1230 1210 1319 1320
Support for DROP IDENTITY clause
36 CS 11599 11119 11279 11980 12940 11110 13909 10780 10759 10689 8630 10329 10620 12539 12330 12639 11599 13440 10360 10369 0 11049 0 11530 13220 12919 13029 13049 12110 13390
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
37 SS 11519 12660 12290 0 12530 12380 13120 12439 12720 11879 9470 9560 10899 11519 11359 13759 11120 11490 11630 12019 11389 11740 11460 14160 11100 9 11259 11609 11380 11350 11190
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
38 CS 2629 2740 2660 2870 2789 2799 2740 2620 2650 2310 2429 2690 2660 2559 2530 2650 2600 2600 2759 2569 0 2599 0 2629 2569 3119 2599 2629 2779 2609
Bugcheck on queries containing WITH LOCK clause
39 SS 2739 2989 2869 2919 3089 2819 2960 2799 2939 2720 2220 2419 2680 2970 2539 2739 2569 2759 2600 2580 2650 2990 2660 2599 2649 0 2720 2740 2779 2849 2550
Bugcheck on queries containing WITH LOCK clause
40 CS 4919 4720 4930 6940 6419 6779 6680 5490 6320 4470 4440 4740 5680 5089 5259 4709 4890 4879 5149 4719 9 4860 0 4700 4909 5059 5090 4839 4720 5150
Shadow file is can not be created during restore when -use_all_space option is used
41 SS 4890 5060 4910 4870 5299 5710 5130 5109 5020 4849 4310 4200 4839 4970 4620 4759 4720 4989 4970 5180 4910 4970 4780 4480 4730 4819 4000 4649 5000 4950 4759
Shadow file is can not be created during restore when -use_all_space option is used
42 SS 4440 4519 4920 4630 4519 4559 4420 7930 4799 4659 4640 4400 4259 4370 4350 4430 4560 4309 4450 4180 4170 4410 4329 4730 4420 4450 4309 4220 4569 4240 4559
Parse error when compiling a statement causes memory leak until attachment is disconnected
43 CS 1259 1220 1240 1350 1549 1339 1369 1380 1539 1299 1180 1269 1130 1259 1000 1259 1230 1579 1340 1179 0 1000 9 1189 799 1279 1189 1519 1230 1299
ALTER CURRENT USER fails with "no permission for <...> TABLE PLG$SRP" if current user: 1) has NO admin role and 2) wants to modify his own TAGS list
44 CS 2019 2080 2159 2180 2000 2219 2159 2000 2119 2039 2089 2160 2220 2329 1980 1910 1950 2129 2019 1910 10 2370 9 1950 899 1929 1940 2059 1980 1930
error read permission for BLOB field, when it is input/output procedure`s parametr
45 CS 1429 1289 1269 1699 1560 1429 1629 1259 1470 1599 1390 1340 1299 1470 1629 1420 1879 1659 1350 1279 0 1379 0 1220 1049 1539 1379 1579 1529 1549
USING PLUGIN clause does not work in RECREATE USER
46 SS 17615 18319 18060 18149 18309 17900 18080 18309 18019 17000 17640 17819 18009 17620 17509 17399 17649 17460 17759 17779 17000 17610 17000 17160 17450 17000 17480 17190 17299 17199 17140
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of several) rather then separate for each of used databases
47 CS 3129 3839 3190 3000 3549 4039 3710 3279 3610 2849 2880 3150 3200 3169 3019 3299 2900 3259 3119 3109 9 2989 9 3089 3089 3049 3129 3009 3430 3180
Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
48 SS 3175 3320 3430 3519 3470 3259 3690 3340 3329 3079 2869 2990 3189 3149 3059 3019 3289 3170 3099 3399 3319 3059 3190 3079 3119 3009 3019 3049 3099 3299 3180
Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
49 CS 710 730 730 700 779 710 730 720 710 740 720 799 670 699 659 789 700 680 710 629 720 720 830 670 689 680 740 680 730 640
Feature CORE-6482 - System table with keywords.
50 SS 649 709 659 710 710 799 720 700 660 639 659 680 620 670 639 629 640 639 650 670 639 639 649 689 630 9 609 639 600 680 579
Feature CORE-6482 - System table with keywords.
51 CS 18220 20370 20100 19460 18389 18899 20440 17809 21029 18529 19069 18190 17509 18640 18220 18090 17820 19759 17960 19029 17440 12229 9 17889 16830 18420 18350 16110 17939 18140
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
52 SS 18284 18880 18910 21150 18759 18279 21000 18630 19000 20789 18090 16930 18920 18289 19259 18960 18089 18000 17109 18959 17339 20539 12700 18099 17920 16870 17709 17269 18379 18200 17370
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
53 CS 22980 23840 22970 22690 24200 23370 23000 22360 22890 22980 22920 23910 22799 23000 22640 23890 22210 23460 23110 22529 23610 22720 22320 22700 23240 23720 23080 23680 22290 22490
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
54 SS 22740 22869 22470 22619 22539 22529 22230 23000 22740 22509 23849 23259 22779 23150 22569 22559 22870 22349 23009 23140 22900 23009 23829 22240 22849 0 22120 23120 22289 22410 22630
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
55 CS 705 960 700 680 679 759 909 839 759 710 799 710 759 690 659 619 670 710 670 730 0 740 0 660 690 690 690 640 720 0
ISQL - SHOW DATABASE
56 SS 659 730 680 0 730 710 759 720 710 690 639 619 680 680 579 630 659 660 629 659 669 619 589 670 619 680 620 649 629 610 659
ISQL - SHOW DATABASE
57 CS 1580 1609 1550 1759 1619 1629 1600 1549 1830 1429 2140 1690 1480 1619 1580 1450 1519 1449 1990 1569 0 1730 0 1299 1550 1589 1540 1430 1680 1480
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
58 SS 1460 1830 1640 9 1529 1679 1620 1560 1699 1599 1549 1470 1450 1439 1430 1359 1000 1359 1000 2009 1549 1440 1450 1400 1399 1529 1450 1400 1480 1409 1480
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
59 CS 1894 1720 1960 1919 1809 1789 1810 1640 1980 1980 1869 1990 1660 1860 2280 2210 2040 2210 1659 1619 9 2170 0 1950 1450 1799 1660 1960 2220 2009
GTCS/tests/CF_ISQL_34. minimum-grant-test
60 CS 1740 1789 1840 1730 1660 1730 1829 2230 1730 1700 2390 2269 2220 1829 1740 1600 1869 1699 1649 1720 9 1930 9 1720 1000 1789 1759 1740 1740 1720
Check ability to update content of RDB$TYPES.
61 SS 1629 1730 1650 0 1730 1939 1830 1860 1579 1720 1619 1629 1639 1560 1580 1569 1609 1569 1549 2079 1660 1669 1539 1630 1590 1640 1559 1690 1560 1620 1539
Check ability to update content of RDB$TYPES.
62 CS 4169 3859 3910 4400 4169 4150 4279 4609 4039 4410 3919 4840 5039 3930 5159 4119 4190 4549 3839 3829 9 4769 9 4529 2010 4539 4349 4009 4039 4819
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
63 SS 3730 3929 3809 0 3930 4029 4020 4049 3730 3700 3740 3769 3819 3779 3889 3700 3490 3620 3700 3799 3589 3610 3720 3660 3970 1140 3480 3529 3980 3670 3460
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
64 CS 2770 2809 2770 2720 2709 2829 2970 2859 2789 1700 1700 3109 2900 2690 2799 2580 2830 2770 2000 2680 0 2730 0 2769 2619 2630 3000 2759 2870 3060
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
65 SS 2879 3339 3200 0 3259 3040 3000 3179 3079 2879 1900 1889 2869 3039 2769 2849 2779 2810 2920 3009 2859 2950 2850 2809 2769 3000 2820 2890 2910 2870 2879
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
66 CS 4040 3930 3930 4140 4090 4040 4230 4149 3970 1539 1410 4360 3990 4379 4329 3930 4180 4049 3839 3939 0 4159 0 3930 4430 3970 4180 3920 4049 3940
Check ability to run complex query
67 SS 4039 4259 4170 0 4170 4339 4379 4309 4309 4180 1539 1549 3970 4060 3920 3960 4039 4110 3909 4050 3829 4099 3809 3990 3859 3960 3900 3909 4099 4139 3789
Check ability to run complex query
68 CS 9384 8759 8579 9230 9609 8949 8980 9190 9839 9480 8690 10589 11039 10829 10680 9120 9289 9099 8600 8700 9 13619 0 11799 9490 10680 10079 9900 8779 10450
Compiler check. Test ability to compile source code of OLTP-EMUL test.
69 SS 8940 9129 9640 0 9039 9119 9730 8799 9429 8589 8889 8910 9199 9509 9480 8529 9360 8629 8940 8759 8909 8869 9519 8600 8970 9069 8450 8519 9040 8849 8380
Compiler check. Test ability to compile source code of OLTP-EMUL test.
70 CS 10339 10069 10029 10460 10309 10339 10640 10440 11000 9820 13700 12580 12630 10209 10210 10659 10730 10460 10579 10059 9 14480 9 10210 10329 9779 10360 10060 10409 10210
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
71 CS 86554 84270 85120 89710 85160 87110 86350 88589 95470 84140 129420 107779 102389 87869 95799 86149 83290 86299 80969 81660 0 87960 9 86759 91299 97199 89389 82869 84670 85649
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
72 CS 9774 9450 9599 9789 9779 9659 10009 10840 10440 9440 12759 12119 11410 9570 9849 9680 9769 9600 9220 9490 0 10950 9 9630 10440 10480 10859 9460 9950 9640
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
73 CS 9904 10569 9329 10009 9689 9740 9799 10740 10139 9690 13660 10599 13990 9610 9940 9619 9579 9000 9390 9269 0 11000 9 10259 10150 10519 9919 9440 9890 11659
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
74 CS 10019 9000 9759 10019 9990 10059 10289 10230 10429 9490 11490 11170 11190 9700 9769 9789 9889 9470 9400 9450 0 11629 0 10340 9670 10320 10170 9800 10029 10570
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
75 CS 9529 10269 9319 9519 10200 9529 9789 9819 9910 9390 11039 11470 10480 10320 9019 9150 9089 9200 9019 9259 9 10350 9 9529 9589 9659 9329 8889 9379 9950
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
76 CS 9940 9919 9559 9779 10009 9469 9879 10390 10640 10039 14519 12599 11620 9240 11460 9740 9599 9480 9550 9179 0 11600 0 10919 11740 9700 10529 9789 9940 11840
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
77 CS 10019 10039 9380 9609 9680 10060 10129 11470 10260 9610 11779 10519 12000 9569 9680 9970 10000 9649 10129 9610 9 10140 0 10320 10269 10130 10690 9640 9000 9810
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
78 CS 10179 11730 9569 10469 10039 10119 10330 10179 10740 10509 13400 10740 12350 9689 9569 10190 10519 10050 10059 9319 0 10909 0 10839 9920 10119 9830 9919 9000 11269
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
79 CS 10079 10740 10150 10700 11079 10640 10089 10130 10450 9589 12450 12009 11169 9790 9789 9730 9000 10139 9759 9829 0 10900 0 9549 9890 9810 9969 10079 9990 10029
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
80 CS 10590 10959 10059 10740 10460 10590 10850 11099 11319 10609 14759 12539 11240 10419 10140 10359 10690 9939 10309 10079 0 12579 0 10490 10470 10680 11049 10190 10400 10000
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
81 CS 9950 10000 9630 9940 9710 10089 10990 10299 10000 9610 12829 12640 11019 10259 9579 9950 10020 9839 9810 9909 0 11869 0 9940 9340 9450 10019 9350 10259 9950
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
82 CS 6529 6430 6700 6789 6609 7169 6670 6000 6490 6180 9069 7349 8099 6220 6129 6300 6530 6519 8000 7099 0 6529 10 6099 6539 6420 6259 6170 6730 6600
gbak utility: check ability to use -ZIP command switch when create backup
83 SS 5685 6230 5899 9 5940 5829 5879 6079 6039 5690 5340 5440 5549 6069 5550 5450 5569 5680 5919 6049 5259 5729 5559 5930 5480 5819 5629 5700 5529 5679 5440
gbak utility: check ability to use -ZIP command switch when create backup

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1291
http://tracker.firebirdsql.org/browse/core-1292
http://tracker.firebirdsql.org/browse/core-2118
http://tracker.firebirdsql.org/browse/core-2729
http://tracker.firebirdsql.org/browse/core-3242
http://tracker.firebirdsql.org/browse/core-3323
http://tracker.firebirdsql.org/browse/core-3360
http://tracker.firebirdsql.org/browse/core-3365
http://tracker.firebirdsql.org/browse/core-3554
http://tracker.firebirdsql.org/browse/core-3799
http://tracker.firebirdsql.org/browse/core-4054
http://tracker.firebirdsql.org/browse/core-4081
http://tracker.firebirdsql.org/browse/core-4292
http://tracker.firebirdsql.org/browse/core-4464
http://tracker.firebirdsql.org/browse/core-4766
http://tracker.firebirdsql.org/browse/core-4774
http://tracker.firebirdsql.org/browse/core-4848
http://tracker.firebirdsql.org/browse/core-4870
http://tracker.firebirdsql.org/browse/core-4928
http://tracker.firebirdsql.org/browse/core-501
http://tracker.firebirdsql.org/browse/core-5077
http://tracker.firebirdsql.org/browse/core-5162
http://tracker.firebirdsql.org/browse/core-5393
http://tracker.firebirdsql.org/browse/core-5431
http://tracker.firebirdsql.org/browse/core-5538
http://tracker.firebirdsql.org/browse/core-5576
http://tracker.firebirdsql.org/browse/core-5630
http://tracker.firebirdsql.org/browse/core-5646
http://tracker.firebirdsql.org/browse/core-5827
http://tracker.firebirdsql.org/browse/core-5982
http://tracker.firebirdsql.org/browse/core-6083
http://tracker.firebirdsql.org/browse/core-6182
http://tracker.firebirdsql.org/browse/core-6377
http://tracker.firebirdsql.org/browse/core-805
http://tracker.firebirdsql.org/browse/core-927
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/basic/isql/isql_01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/dml/merge_02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/gtcs/minimum-grant-test.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/syspriv/create_user_types.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/dml-privileges-sufficiency.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/eqc-136030.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/eqc-306263.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/tabloid/oltp-emul_30-compiler-check.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-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-delete-02.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-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-merge-02.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-01.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-02.fbt
https://github.com/FirebirdSQL/fbt-repository/blob/master/tests/functional/transactions/read-consist-sttm-restart-on-update-03.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
https://github.com/FirebirdSQL/firebird/issues/310
https://github.com/FirebirdSQL/firebird/issues/6220
https://github.com/FirebirdSQL/firebird/issues/6802

=== end of list ===