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

Generated 26.09.2021 20:11
Tested: FB50.   Build: 5.0.0.229;   SS: 26.09.21 15:47:36 - 26.09.21 18:02:57;   CS: 26.09.21 18:04:35 - 26.09.21 20:09:37;
OS and hardware info:  Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 Gb 
Loading data. Please wait...

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-22
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-15
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-08-31
5.0.0.169
2021-08-29
5.0.0.168
2021-08-28
5.0.0.163
2021-08-27
5.0.0.161
2021-08-26
5.0.0.158
2021-08-25
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-19
5.0.0.141
2021-08-14
5.0.0.140
2021-08-13
Test TITLE
1 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
Lot of syntax tests for COALESCE()
2 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
Lot of syntax tests for COALESCE()
3 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Privileges of dynamic statements in SP
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 P P     F         F     P P
Privileges of dynamic statements in SP
5 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Grants don't work for procedures used inside views
6 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Grants don't work for procedures used inside views
7 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Can't create table using long username and UTF8 as attachment charset
8 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Can't create table using long username and UTF8 as attachment charset
9 CS P P P P P P P P P     E         E     P P P P P P P P P P X P P P P     F         F     P P
Suboptimal join plan if there are selective non-indexed predicates involved
10 SS P P P P P P P P P     E         E     P P P P P P P P P P P P P P P     F         F     P P
Suboptimal join plan if there are selective non-indexed predicates involved
11 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
12 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
13 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Error messages after parameters substitution contains '8' characters instead of line break
14 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Error messages after parameters substitution contains '8' characters instead of line break
15 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
16 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
17 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
18 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Recursive stored procedure shouldnt require execute right to call itself
19 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Recursive stored procedure shouldnt require execute right to call itself
20 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Ability to cancel waiting in lock manager
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 P P     F         F     P P
Ability to cancel waiting in lock manager
22 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
23 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
24 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Extend syntax for ALTER USER CURRENT_USER
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 P P     F         F     P P
Extend syntax for ALTER USER CURRENT_USER
26 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
with caller privileges option do not work with autonomous transaction option
27 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
with caller privileges option do not work with autonomous transaction option
28 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
role not passed on external execute stmt
29 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
role not passed on external execute stmt
30 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
31 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
32 CS P P P P P P P P P P P P P P P P P P P     F         F     X     F     P P P P P P P
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
33 SS P P P P P P P P P P P P P P P P P P P     F         F         F         F     P P P P P P P
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
34 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Duplicate tags for CREATE/ALTER USER not handled correctly
35 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Duplicate tags for CREATE/ALTER USER not handled correctly
36 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
37 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
38 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
39 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
40 CS P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F     X     F     P P P P P P P
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
41 SS P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
42 CS P P P P P P P P P P P P P     F         F         F         F         F         F         F         F     X     F     P P P P P P P
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
43 SS P P P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F     P P P P P P P
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
44 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
45 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
46 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
47 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
48 CS P P P P P P P P P     F         F     P P P P P P P P P P X 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
49 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
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
50 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
51 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
SEC$ tables and tag/attributes
52 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
SEC$ tables and tag/attributes
53 CS P P P P P P P P P P P P P P P P P P P     F         F     X     F     P P P P P P P
Support for DROP IDENTITY clause
54 SS P P P P P P P P P P P P P P P P P P P     F         F         F         F     P P P P P P P
Support for DROP IDENTITY clause
55 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
56 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
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
57 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
Bugcheck on queries containing WITH LOCK clause
58 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
Bugcheck on queries containing WITH LOCK clause
59 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
Shadow file is can not be created during restore when -use_all_space option is used
60 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
61 CS P P P P P P P P P P P P P P P P P P P P P X P P P P P P P     F    
SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.
62 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     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
63 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     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
64 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
error read permission for BLOB field, when it is input/output procedure`s parametr
65 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
error read permission for BLOB field, when it is input/output procedure`s parametr
66 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
USING PLUGIN clause does not work in RECREATE USER
67 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
USING PLUGIN clause does not work in RECREATE USER
68 CS P P P P P P P P P     F         F     P P P P P P P P P P X 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)
69 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)
70 CS P P P P P P P P P P P P P P P P     F     P P P P X     F         F     P P P P P P
Feature CORE-6482 - System table with keywords.
71 SS P P P P P P P P P P P P P P P P     F     P P P P P     F         F     P P P P P P
Feature CORE-6482 - System table with keywords.
72 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
73 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
74 SS P P     F     X X X X X X X X X X X X X X X X X X X X X X X X X X X
Lack of proper clean up after failure to initialize shared memory
75 CS P P P P P P     F     P P P P P P P P P P P P P P X P P P P P P P P
Check list of files in the current Firebird snapshot
76 SS 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 P P
Check list of files in the current Firebird snapshot
77 CS P P P P P P P P P P P     F     P P P P P P P P P X P P P P P P P P
ISQL - SHOW DATABASE
78 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
ISQL - SHOW DATABASE
79 CS P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F     X     F     P P P P P P P
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
80 SS P P P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F     P P P P P P P
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
81 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
GTCS/tests/CF_ISQL_34. minimum-grant-test
82 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
GTCS/tests/CF_ISQL_34. minimum-grant-test
83 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
DDL-triggers must fire only on master DB.
84 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
DDL-triggers must fire only on master DB.
85 CS P P P P P P P P P P P P P P P P P P P     F         F     X     F     P P P P P P P
Check ability to update content of RDB$TYPES.
86 SS P P P P P P P P P P P P P P P P P P P     F         F         F         F     P P P P P P P
Check ability to update content of RDB$TYPES.
87 CS P P P P P P P P P P P P P P P P P P P P P X P P P P     F         F     P P
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
88 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P P
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
89 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
90 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
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
91 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
Check ability to run complex query
92 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
Check ability to run complex query
93 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
Check ability to create database with total length of path and file name about maximal allowed limit in Windows
94 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
Check ability to create database with total length of path and file name about maximal allowed limit in Windows
95 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
Compiler check. Test ability to compile source code of OLTP-EMUL test.
96 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
Compiler check. Test ability to compile source code of OLTP-EMUL test.
97 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
98 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
99 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
100 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
101 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
102 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
103 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
104 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
105 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
106 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
107 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
108 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
109 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
110 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
111 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
112 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
113 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
114 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
115 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
116 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
117 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
118 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
119 CS P P P P P P P P P P P P P P P P P P P P P X     F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
120 SS P P P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
121 CS P P P P P P P P P     F         F     P P P P P P P P P P X P P P P P P P P
gbak utility: check ability to use -ZIP command switch when create backup
122 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
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-22
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-15
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-08-31
5.0.0.169
2021-08-29
5.0.0.168
2021-08-28
5.0.0.163
2021-08-27
5.0.0.161
2021-08-26
5.0.0.158
2021-08-25
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-19
5.0.0.141
2021-08-14
5.0.0.140
2021-08-13
Test TITLE
1 CS 2230 2289 2000 2210 2289 2210 2280 2279 2230 2259 2230 2210 2239 2230 2349 2000 2259 2279 2289 2200 2209 2180 4029 2220 2210 2210 2229 2240 2220 2220
Lot of syntax tests for COALESCE()
2 SS 2480 2460 2450 2480 2450 2480 2490 2000 2480 2539 2569 2450 2470 2480 2450 2480 2510 2490 2460 2470 2460 2569 15759 5870 2480 2480 2480 2430 2469 2480 2479
Lot of syntax tests for COALESCE()
3 CS 1980 1980 2000 2000 1980 1980 1990 1990 2039 1960 1979 1980 1970 2040 1980 1990 1980 1980 2000 1970 1970 1960 1970 1969 2050 1980 2660 2910 1960 1980
Privileges of dynamic statements in SP
4 SS 1980 1990 1969 1949 1970 2009 1949 1980 1980 1980 2030 1950 1980 2000 1990 2000 2000 1960 2009 1980 1980 1980 2039 1950 2000 1980 2000 14680 10019 1979 2029
Privileges of dynamic statements in SP
5 CS 2529 2509 2529 2509 2519 2509 2569 2579 2589 2529 2609 2000 2529 2540 2460 2539 2539 2539 2509 2470 2460 2559 2000 2529 2530 2529 2909 2949 2480 2450
Grants don't work for procedures used inside views
6 SS 2864 2809 2829 2839 2879 2790 2839 2850 2859 2849 2929 2889 2840 2850 2869 2869 2870 2889 2929 2890 2839 2870 2850 2809 2870 2820 2850 3179 3279 2889 2879
Grants don't work for procedures used inside views
7 CS 2559 2599 2659 2559 2559 2569 2700 2550 2539 2569 2579 2559 2620 3080 2509 2549 2549 2540 2519 2600 2490 2519 2579 2549 2519 2519 3230 4960 2480 2480
Can't create table using long username and UTF8 as attachment charset
8 SS 2839 2859 2839 2799 2839 2830 2840 2829 2820 2829 2860 2839 2869 2819 2819 2850 2840 2900 2890 2859 2869 2830 2839 2839 2839 2839 2900 3150 3119 2840 2839
Can't create table using long username and UTF8 as attachment charset
9 CS 2899 2900 2929 2899 2829 2839 2980 2870 2819 2819 800 779 2890 2880 2970 3009 2980 2820 2960 3370 3389 3000 2870 2839 2960 2970 5000 5380 2859 2840
Suboptimal join plan if there are selective non-indexed predicates involved
10 SS 3349 3339 3419 3309 3349 3349 3380 3359 3369 3319 929 890 3350 3350 3339 3290 3369 3299 3289 3299 3360 3289 3329 3339 3309 3349 3350 4120 4180 3359 3369
Suboptimal join plan if there are selective non-indexed predicates involved
11 CS 2100 2130 2090 2119 2089 2090 2140 2090 2089 2089 2080 2119 2090 2089 2090 2079 2089 2090 2130 2110 2119 2119 3710 2109 2140 2120 2130 2140 2090 2100
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
12 SS 2399 2400 2420 2380 2400 2400 2399 2400 2399 2390 2400 2370 2409 2440 2400 2389 2380 2369 2399 2389 2430 2370 3399 3309 2369 2420 2400 2370 2370 2410 2390
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
13 CS 1599 1610 1599 1610 1590 1569 1599 1599 1580 1580 1599 1650 1589 1599 1619 1600 1589 1569 1590 1579 1619 1620 1609 1609 1610 1589 2370 2419 1569 1589
Error messages after parameters substitution contains '8' characters instead of line break
14 SS 1809 1829 1799 1789 1789 1849 1799 1809 1829 1790 1789 1809 1789 1799 1810 1809 1820 1809 1779 1789 1809 1870 1809 1809 1839 1789 1790 2690 2740 1799 1820
Error messages after parameters substitution contains '8' characters instead of line break
15 CS 2359 2320 2359 2360 2360 2389 2400 2350 2350 2360 2359 2349 2369 2350 2359 2350 2350 2350 2320 2379 2369 2389 2359 2359 2340 2360 4460 4230 2379 2369
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
16 SS 2440 2429 2450 2420 2439 2440 2399 2449 2450 2449 2449 2369 2440 2439 2450 2420 2449 2429 2430 2440 2430 2449 2450 2400 2460 2470 2419 3190 3210 2430 2480
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
17 SS 6789 6329 6470 6400 6379 6440 7019 7440 6540 6400 7519 6880 6829 6439 6370 6539 6799 7580 6580 7440 6440 6960 6899 6880 6420 6779 7299 7069 7019 6709 6799
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
18 CS 3090 3100 3090 2980 3120 3089 3089 3039 3140 3029 3090 3039 3100 3079 3009 3080 3009 3109 3109 3100 3039 3070 3079 3180 3099 3119 4140 3479 3029 3159
Recursive stored procedure shouldnt require execute right to call itself
19 SS 3480 3000 3509 3509 3480 3470 3459 3400 3480 3470 3480 3539 3450 3490 3470 3440 3480 3480 3480 3430 3409 3400 3480 3440 3480 3459 3480 3730 3789 3480 3000
Recursive stored procedure shouldnt require execute right to call itself
20 CS 5210 5070 5160 5000 5269 5400 5390 5269 5360 4880 5349 5079 5269 5069 5149 5289 5179 5289 5180 5269 5210 5240 5390 5200 5000 5159 21099 20960 5199 5149
Ability to cancel waiting in lock manager
21 SS 6149 6149 6160 6109 6160 6149 6140 6519 6190 6130 6130 6220 6159 6149 6130 6149 6079 6069 6169 6129 6049 6019 6140 6139 6240 6190 6210 20400 20350 6129 6159
Ability to cancel waiting in lock manager
22 CS 3000 3009 3009 3019 2979 2980 3080 2910 3009 2930 3000 2920 3009 3009 2980 2920 3000 3009 3009 2980 2930 2960 2980 3000 3049 3009 3390 3259 2949 3009
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
23 SS 3420 3559 3389 3420 3449 3429 3379 3330 3420 3400 3400 3480 3430 3460 3410 3450 3360 3419 3400 3450 3399 3339 3400 3419 3420 3439 3449 3720 3710 3439 3450
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
24 CS 3599 3619 3599 3619 3460 3599 3590 3529 3649 3930 3659 3509 3650 3650 3000 3509 3600 3640 3600 3620 3389 3549 3619 3609 3519 3620 3000 3400 3530 3590
Extend syntax for ALTER USER CURRENT_USER
25 SS 3985 4009 3960 4000 3970 3990 3980 3839 3990 3960 4019 4009 3990 3990 4000 4009 3930 3990 3960 4000 3910 3990 3959 3950 3960 3970 3990 3760 3000 3950 3990
Extend syntax for ALTER USER CURRENT_USER
26 CS 2269 2309 2279 2000 2240 2309 2240 2240 2289 2220 2299 2259 2280 2299 2240 2279 2000 2000 2269 2279 2240 2269 2289 2259 2280 2260 4700 3000 2259 2240
with caller privileges option do not work with autonomous transaction option
27 SS 2464 2460 2480 2460 2469 2470 2449 2460 2480 2449 2000 2460 2460 2460 2430 2460 2459 2480 2480 2469 2469 2490 2480 2449 2470 2460 2479 3299 3290 2450 2490
with caller privileges option do not work with autonomous transaction option
28 CS 2319 2309 2390 2289 2310 2339 2549 2299 2309 2289 2339 2319 2319 2339 2300 2329 2319 2330 2339 2320 2419 2309 2360 2299 2319 2319 3960 4090 2300 2300
role not passed on external execute stmt
29 SS 2464 2460 2469 2420 2460 2449 2450 2470 2460 2480 2000 2460 2470 2450 2459 2480 2430 2440 2469 2460 2480 2470 2470 2470 2469 2449 2519 3289 3269 2440 2470
role not passed on external execute stmt
30 CS 2090 2109 2069 2079 2090 2100 2070 2099 2080 2070 2089 2089 2099 2080 2090 2079 2099 2069 2090 2089 2070 2080 3879 2039 2140 2120 2090 2109 2100 2090
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
31 SS 2374 2380 2380 2319 2359 2379 2390 2430 2349 2360 2390 2370 2379 2359 2389 2369 2329 2369 2379 2389 2370 2379 3309 3269 2379 2349 2370 2319 2339 2370 2410
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
32 CS 13630 13619 13590 13619 13680 13539 13690 13730 13539 13680 13000 13630 13650 13609 13700 13700 13539 13599 13679 13619 13589 13600 13599 13700 13700 13710 13700 13629 13660 13710
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
33 SS 13450 13380 13509 13509 13450 13460 13460 13470 13470 13380 13429 13380 13470 13450 13379 13390 13430 13559 13430 13549 13390 13420 13490 13509 13439 13440 13440 13419 13589 13929 13569
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
34 CS 1889 1889 1969 1890 1879 1950 1889 1900 1890 1890 1879 1869 1880 1870 1880 1870 1869 1889 1870 1869 1959 1879 1889 1919 1870 1859 4019 2670 1920 1849
Duplicate tags for CREATE/ALTER USER not handled correctly
35 SS 1980 1969 2150 2309 1980 2309 2390 1950 1970 1960 1970 1980 2009 1950 1960 1970 1929 1940 2259 1940 1950 2389 2000 2220 1970 1940 2419 2640 3019 2000 1990
Duplicate tags for CREATE/ALTER USER not handled correctly
36 CS 2220 2219 2230 2000 2200 2210 2230 2220 2220 2230 2220 2140 2230 2649 2279 2230 2210 2220 2210 2210 2210 2230 2240 2229 2199 2289 3700 3059 2210 2230
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
37 SS 2409 2410 2389 2390 2379 2410 2450 2410 2409 2420 2420 2410 2430 2400 2400 2380 2439 2379 2450 2370 2359 2460 2400 2490 2399 2399 2400 3399 3319 2399 2430
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
38 CS 3480 3480 3490 3529 3450 3480 3559 3440 3509 3450 3579 3469 3460 3470 3450 3559 3470 3460 3439 3509 3900 3509 3410 3460 3400 3480 5360 4959 3490 3509
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
39 SS 2634 2589 2759 2680 2630 2809 2670 2670 2619 2569 2639 2619 2640 2660 2609 2569 2680 2620 2650 2529 2590 2569 2669 2649 2629 2589 2589 4399 4349 2630 2650
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
40 CS 2079 2079 2079 2069 2069 2069 2079 2120 2109 2099 2070 2089 2089 2079 2089 2109 2069 2069 2059 2070 2069 2069 2069 2120 2109 2089 2180 2190 2080 2099
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
41 SS 2360 2370 2350 2369 2420 2379 2369 2369 2370 2379 2349 2349 2419 2370 2350 2340 2370 2349 2450 2329 2330 2349 2370 2359 2360 2360 2370 2339 2309 2339 2339
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
42 CS 2090 2150 2130 2090 2099 2090 2090 2110 2069 2089 2099 2109 2120 2079 2139 2090 2099 2140 2040 2089 2099 2090 2080 2089 2080 2069 2090 2070 2129 2089
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
43 SS 2369 2360 2369 2380 2410 2359 2359 2389 2369 2360 2389 2329 2369 2370 2370 2339 2390 2339 2369 2329 2370 2339 2339 2370 2390 2390 2390 2320 2309 2370 2369
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
44 CS 2200 2279 2220 2180 2240 2199 2210 2210 2230 2170 2210 2230 2199 2220 2189 2220 2190 2200 2140 2000 2170 2189 2000 2230 2220 2259 2160 2200 2230 2150
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
45 SS 2460 2480 2480 2449 2449 2789 2690 2450 2450 2460 2460 2420 2450 2470 2460 2430 2450 2529 2479 2440 2559 2440 2490 2490 2450 2470 2470 2460 2399 2479 2480
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
46 CS 4240 4059 4149 4230 4210 4439 4240 4240 4200 4089 4339 4490 4100 4180 4269 4699 4139 4289 4309 4650 4569 5099 4119 4200 4230 4140 6940 6059 4320 4089
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
47 SS 5024 4630 5090 5109 5269 5240 5079 5270 5100 5349 4890 4590 4839 5119 4709 4519 4799 4649 5160 4469 4819 5080 4809 4869 5019 5079 5029 5089 5069 4740 4600
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
48 CS 4629 4639 4619 4640 4640 4629 4639 4630 4710 4650 4100 4000 4609 4650 4610 4539 4600 4680 4700 4630 4559 4619 4629 4600 4650 4639 4609 4620 4519 4619
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
49 SS 5399 5370 5440 5460 5449 5370 5369 5380 5380 5410 4850 4759 5449 5430 5369 5380 5360 5350 5410 5509 5380 5490 5410 5409 5440 5680 5389 5319 5350 5430 5509
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
50 CS 15360 15869 15230 15279 15990 15349 14800 15390 15360 15039 16710 15490 15050 15980 15130 14759 15210 15490 15109 16000 15109 15409 15490 15380 16630 15350 48119 42799 14779 15279
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
51 CS 1809 1820 1799 1790 1809 1820 1820 1769 1789 1769 1809 1790 1799 1809 1779 1799 1809 1809 1790 1810 1830 1779 1789 1829 1810 1819 2420 2319 1839 1799
SEC$ tables and tag/attributes
52 SS 1894 1890 1900 1879 1899 1860 1890 1890 1869 1890 1920 1900 1940 1899 1889 1880 1879 1889 1890 1900 1900 1920 1889 1980 1900 1899 1879 2789 2720 1890 1919
SEC$ tables and tag/attributes
53 CS 2089 2089 2069 2060 2059 2120 2120 2120 2050 2090 2089 2120 2039 2110 2039 2090 2119 2069 2089 2090 2089 2069 2089 2039 2069 2089 2090 2100 2089 2080
Support for DROP IDENTITY clause
54 SS 2370 2360 2390 2370 2349 2359 2350 2369 2370 2419 2409 2349 2370 2400 2379 2390 2370 2369 2320 2329 2409 2390 2369 2400 2350 2370 2400 2350 2330 2340 2449
Support for DROP IDENTITY clause
55 CS 18659 18849 18319 18640 18309 18740 18709 18689 18130 18659 15289 15770 18160 18160 18720 18799 18000 19179 18840 18180 18740 19000 18160 18390 18819 18690 19710 18630 18639 18799
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
56 SS 21779 21849 21779 21409 21779 21870 21859 21859 21759 21779 18029 18210 21809 21879 21809 21720 21000 21769 21309 21439 21759 22089 21730 21670 22000 21890 21909 21860 21920 21299 21960
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
57 CS 5879 5940 5759 5890 5759 5819 5850 5859 6109 6240 5579 5720 5720 5000 6130 5960 5729 5879 5850 5740 5799 5880 5000 5939 5899 5880 5930 6300 5929 5929
Bugcheck on queries containing WITH LOCK clause
58 SS 6099 6080 6110 6060 6140 6099 6109 6220 6090 6129 5700 5759 6159 6069 6069 6079 6200 6170 6029 5970 6169 6149 6099 6159 6129 6129 6079 6089 6049 6029 6099
Bugcheck on queries containing WITH LOCK clause
59 CS 5029 5149 4960 5100 4960 4929 5039 5099 4930 5089 4450 4509 4920 4930 5059 5079 4930 5070 5070 4970 5039 5019 4949 5069 5070 5000 5079 5060 5029 5000
Shadow file is can not be created during restore when -use_all_space option is used
60 SS 5799 5849 5809 5669 5799 5819 5759 5809 5829 5789 5259 5240 5799 5799 5860 5819 5799 5769 5789 5679 5879 5819 5769 5809 5820 5769 5810 5759 5710 5660 5819
Shadow file is can not be created during restore when -use_all_space option is used
61 CS 3720 3759 3730 3740 3000 3709 3809 3730 3700 3000 3690 4070 3700 3720 3730 3730 3720 3720 3800 3690 3000 3000 3000 3730 3730 3710 3740 3709 3799 3740
SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.
62 CS 2569 2569 2569 2590 2609 2620 2549 2579 2590 2519 2550 2599 2509 2589 2650 2519 2589 2529 2599 2529 2540 2569 2529 2720 2569 2640 4589 4519 2549 2550
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
63 SS 2884 2870 2869 2829 2870 2890 2869 2880 2919 2900 2880 2869 2920 2870 2839 2910 2889 2920 2829 2830 2889 2889 2850 2900 2940 2899 2889 3220 3180 2830 2839
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
64 CS 2980 2910 2980 3079 2980 2980 3000 3000 3009 3059 3009 2980 2980 2960 3029 2980 3009 2960 2920 2990 2970 2970 2980 3059 2990 3000 5369 4680 2960 2969
error read permission for BLOB field, when it is input/output procedure`s parametr
65 SS 3449 3450 3450 3389 3460 3509 3440 3640 3480 3440 3430 3480 3480 3369 3369 3460 3389 3460 3380 3369 3490 3000 3450 3440 3449 3470 3430 3759 3730 3389 3379
error read permission for BLOB field, when it is input/output procedure`s parametr
66 CS 2980 2960 2980 2970 2970 2980 2969 2990 3000 2980 2959 2980 2990 2960 2960 2990 2980 3000 2899 2980 2979 3029 2980 2980 2919 2980 3900 4769 2969 2969
USING PLUGIN clause does not work in RECREATE USER
67 SS 3429 3420 3419 3420 3420 3430 3409 3430 3430 3419 3410 3399 3449 3410 3370 3440 3440 3449 3390 3429 3429 3410 3410 3370 3450 3430 3519 3670 3730 3430 3430
USING PLUGIN clause does not work in RECREATE USER
68 CS 5460 5480 5419 5519 5529 5519 6060 5440 5490 5369 4990 4980 5480 5549 5430 5460 5490 5490 5460 5430 5950 5440 5449 5490 5419 5480 5549 5440 5440 5400
Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
69 SS 5684 5710 5740 5730 5690 5660 5700 5690 5630 5000 5190 5190 5569 5679 5680 5730 5690 5690 5670 5709 5689 5819 5609 5649 5660 5700 5680 5659 5669 5759 5709
Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
70 CS 1629 1630 1600 1600 1609 1619 1619 1640 1609 1640 1629 1620 1629 1599 1669 1670 1610 1640 1649 1640 1620 1650 1599 1619 1630 1670 1600 1649 1659 1639
Feature CORE-6482 - System table with keywords.
71 SS 1839 1840 1809 1819 1849 1820 1810 1840 1819 1840 1839 1859 1829 1840 1840 1839 1829 1819 1839 1820 1860 1889 1819 1820 1840 1829 1829 1819 1840 1839 1890
Feature CORE-6482 - System table with keywords.
72 CS 8490 8000 8000 8000 8490 8470 8000 8490 8569 8519 8450 8549 8480 8460 8519 8570 8519 8579 8490 8480 8000 8579 8450 8599 8529 8490 8459 8440 8519 8530
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
73 SS 8950 8890 8870 8909 9329 8889 8829 8920 8950 9000 8890 8910 9039 9050 8960 8930 9119 8980 8950 8970 9079 8969 8960 8930 8950 8909 9329 8809 8940 8940 9329
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966]
74 SS 15720 15610 15720 2006309
Lack of proper clean up after failure to initialize shared memory
75 CS 1670 1669 1679 1670 1669 1669 1670 1670 1670 1690 1670 1680 1690 1670 1690 1720 1660 1670 1670 1670 1669 1670 1690 1690 1670 1669 2409 1700 1680 1689
Check list of files in the current Firebird snapshot
76 SS 1859 1820 1840 2179 1840 2000 2110 1829 1849 1840 1809 1969 1870 1850 1839 1849 1849 1860 2059 1839 1850 2049 2059 1980 1859 1820 2029 1990 1980 1869 1859
Check list of files in the current Firebird snapshot
77 CS 1609 1610 1619 1609 1599 1599 1629 1620 1600 1620 1599 1759 1650 1620 1589 1589 1609 1590 1590 1609 1589 1569 1669 1609 1629 1600 1610 1609 1629 1609
ISQL - SHOW DATABASE
78 SS 1829 1909 1849 1819 1839 1829 1820 1819 1849 1819 1810 1860 1820 1930 1829 1839 1839 1800 1820 1840 1800 1820 1810 1779 1830 1819 1829 1839 1809 1839 1829
ISQL - SHOW DATABASE
79 CS 2109 2070 2090 2110 2150 2099 2140 2109 2110 2120 2140 2090 2069 2059 2100 2109 2109 2139 2120 2120 2089 2120 2119 2099 2140 2120 2060 2310 2099 2099
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
80 SS 2405 2379 2390 2390 2420 2410 2379 2419 2400 2419 2390 2450 2380 2529 2410 2420 2400 2470 2380 2420 2390 2410 2350 2389 2369 2360 2419 2369 2410 2450 2450
merge STATEMENT can have only one RETURNING which must be after all WHEN sub-statements.
81 CS 2970 2920 2930 3029 3000 2930 3050 2899 2930 3009 3080 2920 2920 2990 2980 2930 2930 3009 2960 2960 3029 2950 3009 2960 2970 3090 4230 4710 3009 2920
GTCS/tests/CF_ISQL_34. minimum-grant-test
82 SS 3435 3700 3460 3369 3369 3450 3450 3370 3380 3430 3490 3409 3370 3000 3430 3359 3440 3470 3450 3450 3450 3379 3450 3470 3389 3349 3490 3369 3379 3480 3460
GTCS/tests/CF_ISQL_34. minimum-grant-test
83 CS 52129 52529 52839 53200 51480 52140 51720 50109 51620 53149 51339 52210 50719 51440 51309 52730 51669 50529 53789 51299 53870 52269 53039 52129 52870 51400 7089 6039 53210 53259
DDL-triggers must fire only on master DB.
84 SS 54769 54290 54869 53819 53929 56519 55980 54910 54759 54529 55889 54470 55879 52930 54579 55009 55359 54699 57359 54600 53960 57050 55990 55470 54689 54849 55179 4799 4789 54780 53429
DDL-triggers must fire only on master DB.
85 CS 2529 2549 2539 2509 2529 2509 2509 2529 2549 2529 2519 2000 2509 2580 2549 2559 2559 2539 2530 2509 2519 2539 2589 2509 2490 2640 2529 2519 2529 2529
Check ability to update content of RDB$TYPES.
86 SS 2909 2920 2900 2919 2920 2899 2899 2909 2939 2900 2870 2920 2909 3149 2870 2899 2900 2900 2909 2900 2930 2919 2889 2869 3000 2919 2909 2900 2899 2930 2920
Check ability to update content of RDB$TYPES.
87 CS 5929 5940 5509 6370 5730 5779 6289 5919 5960 5960 5900 5690 5929 5740 5759 5740 5959 5660 5960 5929 5970 5930 5730 5940 5970 5979 4380 5149 5720 5940
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
88 SS 6685 6660 6759 6509 6630 6720 6730 6740 6640 6699 6690 6669 6670 6659 6669 6649 6670 6720 6720 6690 6700 6680 6709 6720 6720 6670 6670 4319 4350 6710 6720
Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege.
89 CS 4629 4629 4600 4609 4599 4679 4620 4600 4600 4679 3539 3579 4600 4609 4630 4629 4650 4700 4639 5100 5150 5150 4599 4650 4619 4690 5079 5080 4619 4599
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
90 SS 5514 5539 5519 5420 5449 5529 5470 5519 5479 5520 4430 4320 5420 5990 5460 5490 5649 5630 5509 5569 5660 5519 5480 5519 5509 5509 5589 5460 5699 5589 5469
Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause.
91 CS 6310 6360 6360 6509 6269 6269 6299 6320 6310 6349 3610 3659 6289 6470 6289 6300 6379 6339 6349 6769 6769 6000 6240 6210 6259 6359 6839 6800 6259 6289
Check ability to run complex query
92 SS 7004 7000 7009 7130 7049 7039 7019 6990 7049 6990 4430 4289 7029 7599 6980 6990 7000 6969 7079 7130 7000 7050 6990 6990 7069 7049 6940 6890 6910 7029 7009
Check ability to run complex query
93 CS 23619 23899 23609 23480 23369 23629 23819 23609 23920 23879 23039 23069 23589 23519 23429 23470 24049 24069 23490 23940 23990 23640 23680 23880 23419 23619 24759 23509 23759 23480
Check ability to create database with total length of path and file name about maximal allowed limit in Windows
94 SS 24439 24789 24409 24469 24509 24539 26789 24350 24309 24490 23780 24039 26740 24960 24170 24370 24190 24069 24359 24559 24379 24559 24470 24410 24569 24379 24210 24370 24539 24620 24610
Check ability to create database with total length of path and file name about maximal allowed limit in Windows
95 CS 3699 3680 3689 3650 3720 3720 3710 3699 3690 3699 3700 3620 3710 3690 3720 3690 3670 3700 3679 3669 3719 3710 4279 3650 3700 3700 3700 3680 3740 3000
Compiler check. Test ability to compile source code of OLTP-EMUL test.
96 SS 4079 4049 4049 4090 4069 4039 4049 4120 4109 4079 4130 3970 4009 4889 4020 4070 4069 4069 4200 4039 4079 4149 5019 5150 4089 4119 4079 4000 3980 4129 4119
Compiler check. Test ability to compile source code of OLTP-EMUL test.
97 CS 10809 10819 10990 11009 10730 11000 10450 10980 10950 10920 10569 10359 10329 10230 10390 10950 10710 10470 10970 10630 10920 10730 12060 10890 10980 10679 10220 10930 10640 10809
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
98 SS 9809 9799 9690 9789 9830 9890 9000 9660 9730 9890 9509 9000 9730 9970 9970 9850 9650 9720 9809 9859 9829 9870 10359 10529 9850 9810 9809 9670 9690 9920 9000
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
99 CS 65509 64660 65460 65990 64779 66130 65700 64659 66559 67649 65200 64380 65779 66110 65629 66439 65210 64509 64569 67720 64599 63990 78000 66269 65820 65509 65849 63720 63149 64080
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
100 SS 57714 57180 59299 56700 58460 57859 56930 55829 58190 58099 55210 55960 57610 59629 59639 56759 57789 55729 57880 57190 57360 58009 62599 61559 57639 58229 56269 57159 58779 56919 59440
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
101 CS 9960 10240 9859 10099 10350 9859 10279 9990 9960 10240 9720 9710 10360 10299 9809 10200 9549 9960 9830 10599 9920 9799 11649 9920 10289 10430 9920 9839 9910 9960
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
102 SS 9705 9649 9780 9690 9669 9640 9839 9740 9549 9700 9619 9639 9740 9789 9930 9710 9559 9460 9740 9000 9559 9000 10330 10589 9769 9700 9740 9620 10109 9890 9920
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
103 CS 10200 10139 10000 10309 10190 10860 10279 10150 10289 10470 10200 10039 9689 10579 9810 10330 10180 10470 10449 10029 9670 9700 11330 9939 10269 9960 10309 9859 10539 10289
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
104 SS 10019 9680 10279 9980 9670 9639 10330 10099 10279 10700 9550 11090 9789 10450 9630 10119 9610 9539 9700 10279 10059 10589 10990 10310 10100 9700 11039 9629 9660 9940 9779
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
105 CS 10240 10350 10470 9980 9850 10319 10340 9890 9869 10240 10050 9740 9810 10289 10079 10180 9830 10260 10330 10779 10269 10319 11079 9909 10280 9700 10319 9900 9870 10240
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
106 SS 9759 9599 9000 9740 9629 9690 9809 9799 10309 9000 9529 9680 10270 9980 11230 9730 10170 9480 9779 10000 9660 9710 10490 10329 9609 9680 9700 10200 10460 9889 10019
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
107 CS 9910 9809 10309 9859 9949 10109 10299 10189 9829 10039 10220 9650 9909 9910 10000 9859 9779 9819 9839 10269 9920 9900 11190 10000 9779 10200 10200 9769 9889 9789
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
108 SS 9730 9640 10620 9759 9720 9700 9810 9720 9670 9910 9569 10170 9719 9740 9000 9769 9669 9490 9570 9810 9680 9759 10319 10480 9660 9779 9890 10039 9659 9789 9700
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
109 CS 10199 10079 10220 10160 9810 10240 10200 9970 10300 10330 10199 10439 10200 10419 10140 10220 9919 9419 10039 10259 9789 10220 10910 9820 10309 9460 10279 9480 9920 9899
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
110 SS 9725 10730 9890 9000 9690 9629 9720 9730 9000 10329 9620 9629 9830 9929 9599 9680 9600 9700 9699 9699 10209 10269 10519 11009 9809 10670 9859 9630 9519 9850 9970
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
111 CS 10220 10230 10340 10000 10000 10170 10000 10039 10329 10379 9470 10669 10030 10289 10220 10100 9849 10300 10240 10209 9799 10280 11000 10130 10470 10369 10240 10139 9929 10369
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
112 SS 9789 9960 10009 10470 9689 9670 9890 9650 9809 10029 10159 9680 9819 9799 9609 9620 9620 9490 9579 9700 9719 9660 10480 10399 9779 10490 9590 9620 10039 9990 10399
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
113 CS 10090 10339 10459 9920 10039 9919 10299 10220 10329 9950 10170 10420 10489 9850 9779 10319 9810 10000 10390 10070 10000 9949 11460 9950 9839 10240 10289 10289 10090 9860
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
114 SS 9789 9680 9799 10309 9810 10529 9730 9769 9649 9730 9550 9609 9960 9779 10440 10299 10269 9480 9710 9799 9720 9969 11450 11029 9779 9759 10419 9519 9640 9970 9860
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
115 CS 10200 10360 9850 10220 9820 10200 10309 9829 9960 10390 9980 10329 9440 10399 9840 10279 9619 10309 10279 9960 9890 10269 11309 10229 10460 9859 9879 9960 9949 10219
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
116 SS 9715 10129 9840 9720 9599 9710 9000 9829 9770 9690 9699 9570 9779 9890 9670 9640 9639 9470 9000 9669 10230 9700 9919 10640 10889 9720 9700 9730 9649 10060 9859
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
117 CS 10039 9460 10000 10039 9990 9940 10390 10480 9960 9980 10359 9590 10000 9940 10049 10309 10390 9859 9700 10379 10209 9950 11190 10240 9890 10040 10259 10279 10310 9970
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
118 SS 9860 10200 9740 10309 9779 9759 10139 10289 10189 9779 9560 9819 9759 11079 10470 9639 10000 9910 9720 9890 9740 10190 10559 10450 9780 9799 9830 9639 9580 9969 11000
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
119 CS 10079 10399 9879 10309 10000 10279 10189 9950 10389 10359 9799 10259 9970 10329 9859 10279 9689 9950 9919 9940 9740 10000 12009 10230 10279 10409 9830 9930 10079 10330
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
120 SS 9700 9660 9669 9710 9650 9799 9670 10080 9759 9609 9609 9620 9710 9820 9000 9670 10230 10069 9639 9690 9720 9809 10449 10259 10299 9690 9579 9640 9639 9870 10059
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
121 CS 10200 10200 10670 10339 10220 10240 10799 9840 10740 10660 9970 10090 10000 10430 10009 10279 9990 10379 10410 10470 10050 10119 10240 10140 10620 10170 9829 10079 9980 10190
gbak utility: check ability to use -ZIP command switch when create backup
122 SS 8629 8569 8720 8580 8630 8559 8569 8600 8799 8779 8180 8330 8629 8930 8480 8800 8539 8550 9580 8529 8629 8659 8759 8529 8639 8560 8720 8640 8609 8690 8809
gbak utility: check ability to use -ZIP command switch when create backup

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1292
http://tracker.firebirdsql.org/browse/core-2078
http://tracker.firebirdsql.org/browse/core-2118
http://tracker.firebirdsql.org/browse/core-2140
http://tracker.firebirdsql.org/browse/core-2729
http://tracker.firebirdsql.org/browse/core-2879
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-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-4747
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-4882
http://tracker.firebirdsql.org/browse/core-4928
http://tracker.firebirdsql.org/browse/core-501
http://tracker.firebirdsql.org/browse/core-5087
http://tracker.firebirdsql.org/browse/core-5162
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-5664
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-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/build/snapshot-files-check-list.fbt
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/replication/ddl-triggers-must-not-fire-on-replica.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/max-path-length.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/6976

=== end of list ===