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)
5. Has fails: tests with at least one fail for previous runs (83 rows)
[CURRENT] 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 
Loading data. Please wait...

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

Jump to LIST of unique test names from this report

NN Test name mode 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 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 P P
cannot create procedure with long chain of else-if clauses
2 SS 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 P P P P P
Automatic not null in PK columns incomplete
3 CS P P X P P P P P P     E         E     P P P P P P P P P P P U P P P P P P P
Index bug
4 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 P P P P
Index bug
5 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 P P
Join on diffrent datatypes
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     E     P P P P P
Using where params in SUM return incorrect results
7 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 P P
Dropping and recreating a table in the same txn disables PK
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     E     P P P P P
bug with ALL keyword
9 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 P P
CREATE TABLE - no blob for external
10 SS 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 P P P P P
Expression evaluation not supported on LEFT JOIN
11 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 P P
numeric div in dialect 3 mangles data
12 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 P P
SELECT '1' UNION SELECT '12'
13 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 P P
Left joining views with null fails
14 SS 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 P P P P P
Sqlsubtype incorrect on timestamp math, constant arithmetic
15 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 P P
Query using VIEW with UNION causes crash
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     E     P P P P P
DB crashes if trigger BU deletes own row
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     E     P P P P P
trigger with except-s on view with union
18 SS 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 P P P P P
SYSDBA can grant non existent roles
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     E     P P P P P
wrong order by in table join storedproc
20 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 P P
ORDER BY works wrong with collate PT_PT
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     E     P P P P P
SELECT...HAVING...NOT IN crashes server
22 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 P P
DOMAINs don't register their dependency on other objects
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     E     P P P P P
bug #910430 ISQL and database dialect
24 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 P P
NULLS FIRST does not work with unions
25 SS 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 P P P P P
JOIN including a complex view kills the server
26 SS 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 P P P P P
Redundant evaluations in COALESCE
27 SS 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 P P P P P
Lot of syntax tests for COALESCE()
28 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 P P
Inconsistent results using STARTING WITH and COALESCE
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     E     P P P P P
Tricky role defeats basic SQL security
30 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 P P
FIRST is applied before aggregation
31 SS P P P P P P P P P P P P P P P P P P P P P P P P     E     P P P P P
SKIP is off by one
32 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 P P
Blob Type 1 compatibility with VarChar
33 SS 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 P P P P P
Compress Data over the Network
34 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Easy metadata extract improvements
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     E     P P P P P
Privileges of dynamic statements in SP
36 SS 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 P P P P P
accent ignoring collation for unicode
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     E     P P P P P
Specific query crashing server
38 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 P P
substring(current_user from 4) fails
39 SS 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 P P P P P
Containing not working correctly
40 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Engine crashes while trying to backup a logically corrupt db
41 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 P P
Dependencies are not cleared when creation of expression index fails
42 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 P P
Problems with explicit cursors in unwanted states
43 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 P P
Server crash on violation of NOT NULL constraint
44 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 P P
ALL predicate works incorrectly for some subqueries
45 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 P P
Grants don't work for procedures used inside views
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     E     P P P P P
Bug in DSQL parameter
47 SS 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 P P P P P
Comment in create database
48 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 P P
GSTAT does not work using the localhost connection string
49 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 P P
Case insensitive collation for UTF-8
50 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 P P
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
51 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     E     P P P P P
select with FIRST and LEFT JOIN needs excess SORT in plan
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     E     P P P P P
context already in use (BLR error)
53 SS 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 P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs
54 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
55 SS P P P P P P P P P     E         E     P P P P P P P P P P     E     P P P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
56 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     E     P P P P P
Provide mechanism to get engine version without needing to call API function
57 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 P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
58 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 P P
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
59 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     E     P P P P P
Wrong parameter matching for self-referenced procedures
60 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 P P
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
61 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
62 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 P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
63 SS 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 P P P P P
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
64 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 P P
Error msg "Could not find UNIQUE INDEX" when in fact one is present
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     E     P P P P P
UNION vs UTF8 literals : arithmetic exception is thrown
66 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 P P
Cannot alter generator's comment to the same value
67 SS 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 P P P P P
Error conversion error from string " " using outer join on int64 and int fields
68 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 P P
Symbols ignored for ES_ES_CI_AI collation
69 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 P P
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
70 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     E     P P P P P
Union returns inconsistent field names
71 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 P P
Long SQL statements break TCP/IP connection
72 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 P P
Wrong SELECT query results using index to evaluate >= condition
73 SS 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 P P P P P
LIST() function seems not work if used twice or more in a query
74 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 P P
Server crash on select * from <recursive CTE>
75 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     E     P P P P P
Incorrect column values with outer joins and views
76 SS 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 P P P P P
Incorrect column values with outer joins and derived tables
77 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 P P
Problem with DISTINCT and insensitive collations
78 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     E     P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
79 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 P P
Can't create table using long username and UTF8 as attachment charset
80 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 P P
Bad optimization of queries with DB_KEY
81 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     E     P P P P P
Indices not used for views
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     E     P P P P P
Data type unknown
83 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     E     P P P P P
NOT NULL constraint for procedure parameters and variables
84 SS 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 P P P P P
Error "Identifier ... is too long using multiple (nested) derived tables
85 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     E     P P P P P
size of alias name in a table
86 CS P P X P P P P P P     E         E     P P P P P P P P P P P U P P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
87 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 P P P P
Charset transliterations don't work with EXECUTE STATEMENT
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     E     P P P P P
Index operations for global temporary tables are not visible for the active connection
89 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 P P
Too large numbers cause positive infinity to be inserted into database
90 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 P P
ISQL crash when converted-from-double string longer than 23 bytes
91 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 P P
French insensitive collation FR_FR_CI_AI
92 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 P P
Invalid parameter type when using it in CHAR_LENGTH function
93 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 P P
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
94 SS 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 P P P P P
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read
95 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 P P
Wrong current timestamp evaluation for selectable procedures
96 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     E     P P P P P
Greek characters in cp1251 vs uppercasing
97 SS 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 P P P P P
Outer joins don't work properly with the MON$ tables
98 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     E     P P P P P
Execute statement 'select ....' into new....
99 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 P P
Allow usage of functions in LIST delimiter parameter
100 SS 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 P P P P P
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query
101 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     E     P P P P P
Make optimizer to consider ORDER BY optimization when making decision about join order
102 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 P P
DATEADD wrong work with NULL arguments
103 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 P P
POSITION(string_exp1, string_exp2 [, start])
104 SS 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 P P P P P
Inconsistent DATEDIFF behaviour
105 SS 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 P P P P P
Computed field + index not working in WHERE
106 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     E     P P P P P
Functions DATEDIFF does not work in dialect 1
107 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 P P
RDB$procedures generator overflow
108 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 P P
Subquery-based predicates are not evaluated early in the join order
109 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 P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
110 SS 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 P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
111 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 P P
AV when all statements are cancelled
112 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 P P
Multiple Rows in Singleton Select not reported in a View
113 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 P P
ABS() rounds NUMERIC values
114 SS 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 P P P P P
Server crashed or bugcheck when inserting in monitoring tables.
115 SS 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 P P P P P
Altering procedure parameters can lead to unrestorable database
116 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 P P
Bugcheck 232 (invalid operation) for an aggregated query
117 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 P P
Ability to insert child record if parent record is locked but foreign key target unchanged
118 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 P P
Incorrect error message (column number) if the empty SQL string is prepared
119 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     E     P P P P P
Non-privileged monitoring reports wrong attachment data
120 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 P P
Non-privileged monitoring reports wrong attachment data
121 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 P P
AV when recursive query used MERGE JOIN in execution plan
122 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 P P
'There are <n> dependencies' error message shows the wrong count of dependent objects.
123 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 P P
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
124 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 P P
Bug in create/alter Database trigger (with Russian comment)
125 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 P P
Expression index can be created while doing inserts into table
126 SS 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 P P P P P
DDL statement with AUTODDL ON won't show statistics
127 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     E     P P P P P
Include information about context variables into the monitoring tables
128 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Results of a join with different collations depend on the execution plan
129 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 P P P P
Results of a join with different collations depend on the execution plan
130 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 P P
Problem with COLLATE ES_ES_CI_AI
131 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 P P
ISQL crashes when fetching data for a column having alias longer than 30 characters
132 SS 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 P P P P P
Consistency check when subquery is ordered by aggregate function from other context
133 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 P P
AV at prepare of query with unused parametrized CTE
134 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 P P
Maximum key size using PXW_CSY collation
135 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     E     P P P P P
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
136 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 P P
Index is not used for some date/time expressions in dialect 1
137 SS 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 P P P P P
Ability to grant role to another role
138 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     E     P P P P P
Roles granting/revoking logic
139 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 P P
Error on script with current_date
140 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 P P
CREATE COLLATION connection lost under Posix
141 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 P P
Circular dependencies between computed fields crashs the engine
142 SS 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 P P P P P
MON$DATABASE returns outdated transaction counters
143 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 P P
GROUP BY RAND() returns infinite rows
144 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     E     P P P P P
Non-SYSDBA user can change FW mode of database.
145 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     E     P P P P P
Broken foreign key handling for multi-segmented index using multi-level collations
146 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
147 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     E     P P P P P
SUBSTRING with regular expression (SIMILAR TO) capability
148 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     E     P P P P P
NOT NULL procedure parameters
149 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 P P
I/O statistics for stored procedures are not accounted in monitoring tables
150 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 P P
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
151 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 P P
don't work subquery in COALESCE
152 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 P P
ALTER VIEW WITH CHECK OPTION crashes the engin
153 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     E     P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins
154 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
155 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 P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
156 SS 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 P P P P P
RDB$DB_KEY in subselect expression incorrectly returns NULL
157 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 P P
View over global temporary table
158 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 P P
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
159 SS 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 P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
160 SS 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 P P P P P
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
161 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     E     P P P P P
Join of SP with view or table may fail with "No current record for fetch operation"
162 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 P P
Unexpected (wrong) results with COALESCE and GROUP BY
163 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     E     P P P P P
New gbak option to ignore specific tables data during the backup
164 SS 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 P P P P P
Nbackup as online dump
165 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 P P
Problem with column names with Accents and triggers
166 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     E     P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
167 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 P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
168 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
169 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     E     P P P P P
gbak doesn't return error code
170 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
'...exception...string right truncation' when alter view with join
171 SS 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 P P P P P
MERGE non-standard behaviour, accepts multiple matches
172 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 P P
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
173 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     E     P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
174 SS 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 P P P P P
Make mon$statement_id value constant among monitoring snapshots
175 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 P P
Incomplete API information values
176 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 P P
SIMILAR TO produces random results with [x-y] expressions
177 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 P P
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
178 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 P P
Too long column name for select alias should be rejected
179 SS 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 P P P P P
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
180 SS 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 P P P P P
Wrong matching of SIMILAR TO expression with brackets
181 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 P P
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
182 SS 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 P P P P P
AV preparing a query with aggregate over derived table
183 SS 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 P P P P P
Parsing error in EXECUTE STATEMENT with named parameters
184 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 P P
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
185 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 P P
Server crashes on UPDATE OR INSERT statement
186 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 P P
Server fails when doing DROP DATABASE right after error in statistical fnction
187 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 P P
Binary shift functions give wrong results with negative shift values
188 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 P P
Built-in trigonometric functions can produce NaN and Infinity
189 SS 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 P P P P P
Tricky index names can defeat the parsing logic when generating a human readable plan
190 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 P P
Wrong processing a SP parameters with arrays
191 SS 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 P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
192 SS 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 P P P P P
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
193 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 P P
Maximum and minimum identifier length should be enforced by DSQL
194 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 P P
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
195 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 P P
Infinity should not escape from the engine
196 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 P P
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
197 SS 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 P P P P P
Silent truncation when using utf8 parameters and utf8 client character set encoding
198 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 P P
SELECT WITH LOCK with no fields are accessed clears the data
199 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 P P
Write note into log when automatic sweep is started
200 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 P P
System triggers on view with check option are not removed
201 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
202 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     E     P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
203 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 P P
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
204 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 P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
205 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 P P
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
206 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     E     P P P P P
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
207 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 P P
Include client library version and protocol version in mon$attachments
208 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 P P
Make rdb$system_flag not null
209 SS 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 P P P P P
isql extracts the array dimensions after the character set name
210 SS 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 P P P P P
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
211 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 P P
Views based on procedures can't be created if the proc's output fields participate in an expression
212 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 P P
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
213 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 P P
Natural is used to select instead of primary key index
214 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 P P
View created from JOIN and LEFT JOIN doesnt order
215 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 P P
Query with "NOT IN <subselect from view>" fails
216 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     E     P P P P P
A memory corruption cause incorrect query evaluation and may crash the server
217 CS P P X P P P P P P     E         E     P P P P P P P P P P P U P P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
218 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 P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
219 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     E     P P P P P
Expression in a subquery may be treated as invariant and produce incorrect results
220 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 P P
Don't send full length of field over the wire when field is null
221 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 P P
Unable to catch exceptions that are thrown inside a dynamic builded execute block.
222 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 P P
PK index is not used for derived tables
223 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 P P
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
224 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 P P
Character set used in constants is not registered as dependency
225 SS 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 P P P P P
Problem with dependencies between a procedure and a view using that procedure
226 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 P P
"Invalid ESCAPE sequence" when connecting to the database
227 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 P P
Wrong field position after ALTER POSITION
228 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 P P
Trace output could contain garbage data left from filtered out statements
229 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 P P
count(*) from big table returns negative result
230 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 P P
Error in Trace plugin (use local symbols in query)
231 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 P P
Concurrent transaction number not reported if lock timeout occurs
232 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     E     P P P P P
Error on delete user "ADMIN"
233 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 P P
Add attachment's CHARACTER SET name into corresponding trace records
234 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 P P
Wrong resultset
235 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 P P
Wrong resultset
236 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 P P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
237 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 P P
New generators are created with wrong value when more than 32K generators was previously created
238 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 P P
Using both the procedure name and alias inside an explicit plan crashes the server
239 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     E     P P P P P
Foreign key cascade with SET DEFAULT uses the default value of the moment of the FK creation
240 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
241 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 P P P P
Better performance for (table.field = :param or :param = -1) in where clause
242 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 P P
Incorrect LEFT JOIN result using table and derived constant subquery
243 SS 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 P P P P P
ROW_COUNT is not cleared before the singleton INSERT statement
244 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 P P
Parameters doesn't work with NOT IN from a selectable procedure
245 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 P P
Updating blob field cause server crash with ACCESS_VIOLATION exception
246 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 P P
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
247 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 P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
248 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Preserve comments for parameters after altering procedures
249 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 P P
Parameterized requests involving blob fields fails when connected using charset UTF8
250 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 P P
View with "subselect" column join table and not use index
251 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     E     P P P P P
ALTER VIEW with not matched columns in declaration and selection crashs the server
252 SS 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 P P P P P
page 0 is of wrong type (expected 6, found 1)
253 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 P P
ATAN2 returns incorrect value for (0, 0)
254 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
255 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 P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
256 SS 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 P P P P P
String truncation occurs when selecting from a view containing NOT IN inside
257 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 P P
ASCII_VAL() fails if argument contains multi-byte character anywhere
258 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 P P
RIGHT() fails with multibyte text blobs > 1024 chars
259 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 P P
OVERLAY() fails when used with text BLOBs containing multi-byte chars
260 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 P P
Recursive stored procedure shouldnt require execute right to call itself
261 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
SUBSTRING on long blobs truncates result to 32767 if third argument not present
262 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Wrong result for RIGHT(UTF8 varchar)
263 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     E     P P P P P
Wrong result for RIGHT(UTF8 varchar)
264 CS P P X P P P P P P     E         E     P P P P P P P P P P P U P P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
265 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 P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
266 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 P P
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
267 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     E     P P P P P
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
268 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
RDB$GET_CONTEXT and between in view
269 SS P P P P P P P P P     E         E     P P P P P P P P P P     E     P P P P P P P P
RDB$GET_CONTEXT and between in view
270 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 P P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
271 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     E     P P P P P
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
272 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 P P
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
273 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 P P
Wrong comparsion of DATE and TIMESTAMP if index is used
274 SS 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 P P P P P
Generators are set to 0 after restore
275 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 P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
276 SS 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 P P P P P
Cursors should ignore changes made by the same statement
277 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 P P
Extend syntax for ALTER USER CURRENT_USER
278 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 P P
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
279 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     E     P P P P P
GRANT ADMIN ROLE not accepted
280 SS 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 P P P P P
Collation errors with [type of] <domain>, type of column
281 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 P P
[FB3] Wrong RDB$PARAMETER_MECHANISM
282 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Lateral derived tables
283 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 P P P P
Lateral derived tables
284 SS 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 P P P P P
Allow conversion from/to BLOBs and others types in the API functions (XSQLVAR or blr messages)
285 SS 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 P P P P P
Inefficient optimization (regression)
286 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Regression in joins on procedures
287 SS P P U P P P P P P     E         E     P P P P P P P P P P P P P     E     P P P P P
Regression in joins on procedures
288 SS 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 P P P P P
Parameters inside the CAST function are described as not nullable
289 SS 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 P P P P P
ASCII_VAL raises error instead of return 0 for empty strings
290 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 P P
Blob transliteration may not happen inside the union
291 SS 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 P P P P P
Altering of a TYPE OF COLUMN parameter affects the original column
292 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 P P
ALTER VIEW crashes the server if the new version has an artificial (aggregate or union) stream at the position of a regular context in the older version
293 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 P P
Alter procedure allows to add the parameter with the same name
294 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 P P
Unquoted role names with non-ASCII characters passed in DPB are upper-cased wrongly
295 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     E     P P P P P
Server crash with built in function LPAD with string as second parameter
296 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     E     P P P P P
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
297 SS 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 P P P P P
Inconsistent domain's constraint validation in PSQL
298 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Aliases for the RETURNING clause
299 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 P P
GFIX returns an error after correctly shutting down a database
300 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     E     P P P P P
Database corruption after end of session : page xxx is of wrong type expected 4 found 7
301 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 P P
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
302 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
AV in engine when preparing query against dropping table
303 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     E     P P P P P
AV in engine when preparing query against dropping table
304 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     E     P P P P P
CHAR(32767) present in XSQLVAR with length 32765
305 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Can not drop table when computed field depends on later created another field
306 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 P P
Include expected and actual string lenght into error message for sqlcode -802
307 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 P P
TRACE: add statistics of actions that were after transaction finished
308 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     E     P P P P P
Can insert DUPLICATE keys in UNIQUE index
309 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 P P
Wrong data while retrieving from CTEs (or derived tables) with same column names
310 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     E     P P P P P
Window Function: cume_dist()
311 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 P P
Window Function: ntile(num_buckets integer)
312 SS 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 P P P P P
computed index by substring function for long columns
313 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
314 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 P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
315 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     E     P P P P P
Missing constraint name in foreign key error message in FB 2.1.4
316 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 P P
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
317 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
String truncation error when selecting from a VIEW with UNION inside
318 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     E     P P P P P
String truncation error when selecting from a VIEW with UNION inside
319 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 P P
IS NOT DISTINCT FROM NULL doesn't use index
320 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 P P
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
321 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 P P
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
322 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 P P
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
323 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 P P
SELECT using IN list with 153 or more elements causes crash
324 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 P P
with caller privileges option do not work with autonomous transaction option
325 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 P P
Provide ability to return all columns using RETURNING (eg RETURNING *)
326 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Bad alias table choice joining CTE
327 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     E     P P P P P
Bad alias table choice joining CTE
328 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Server crashes on preparing empty query when trace is enabled
329 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     E     P P P P P
Wrong numbers in error message for decreasing char/varchar columns
330 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 P P
High memory usage when PSQL code SELECT's from stored procedure which modified some data
331 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Improve SIMILAR TO performance
332 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 P P P P
Improve SIMILAR TO performance
333 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 P P
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
334 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     E     P P P P P
DeActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
335 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     E     P P P P P
Restore from gbak backup using service doesn't report an error
336 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 P P
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
337 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
338 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     E     P P P P P
Creating a procedure containing "case when" expression leads to a server crash
339 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
340 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 P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
341 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
subselect with reference to outer select fails
342 SS P P U P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
subselect with reference to outer select fails
343 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 P P
Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
344 SS 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 P P P P P
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
345 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     E     P P P P P
Parametrized execute statement fails
346 SS 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 P P P P P
Error message "index unexpectedly deleted" in database trigger on commit transaction
347 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 P P
wrong error message with recursive CTE
348 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 P P
role not passed on external execute stmt
349 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 P P
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
350 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     E     P P P P P
NOT-NULL-column can be used as primary key and filled with NULL-values
351 SS 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 P P P P P
Constant columns getting empty value with subselect from procedure
352 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
353 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 P P
Wrong value of expected length in the sring right truncation error
354 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 P P
Full outer join in derived table with coalesce (iif)
355 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 P P
Bad optimization of OR predicates applied to unions
356 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 P P
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
357 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 P P
In SS sweep blocks establishment of concurrent attachments
358 SS 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 P P P P P
Wrong metadata output script generate by isql / CHARACTER SETISO8859_1 sintax error
359 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Error "invalid stream" can be raised in some cases while matching a computed index
360 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 P P
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
361 SS 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 P P P P P
New permission types are not displayed by ISQL
362 SS 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 P P P P P
External routines DDL in Packages wrongly report error for termination with semi-colon
363 SS 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 P P P P P
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
364 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     E     P P P P P
Regression: LIKE with escape does not work
365 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     E     P P P P P
User can not insert records into table with column "generated by default as identity" in its DDL
366 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 P P
Creating external function (udf) to not existing dll - and then procedure with it - crash server
367 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 P P
Executing empty EXECUTE BLOCK with NotNull output parameter raised error
368 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 P P
Add optional START WITH clause to identity columns
369 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     E     P P P P P
An uncommitted select of the pseudo table sec$users blocks new database connections
370 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
An uncommitted select of the pseudo table sec$users blocks new database connections
371 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 P P
Regression: Computed field returns null value inside BI trigger
372 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 P P
ISQL -x does not output the START WITH clause of generators/sequences
373 SS 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 P P P P P
Preserve comments for output parameters after altering procedures
374 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 P P
Dropping FK on GTT crashes server
375 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 P P
GTT should not reference permanent relation
376 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 P P
Add database owner to mon$database
377 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 P P
Regression: Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
378 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 P P
Bidirectional cursor is not positioned by the first call of FETCH LAST
379 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 P P
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
380 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 P P
Problem with creation procedure which contain adding text in DOS864 charset
381 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 P P
Regression: Wrong boundary for minimum value for BIGINT/DECIMAL(18)
382 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 P P
Check result when joined fields are created via row_number() function
383 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 P P
Error in case of subquery with windowed function + where <field> IN(select ...)
384 SS 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 P P P P P
Engine crashs in case of re-creation of an erratic package body
385 SS 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 P P P P P
Error on create table with "CHARACTER SET DOS775" field
386 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 P P
Choose the best matching index for navigation
387 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 P P
Regression: NOT-null field from derived table became NULL when is referred outside DT
388 SS 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 P P P P P
Inappropriate self-reference of column when using "with check option" with extract(...)
389 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 P P
Non-ASCII data in SEC$USERS is not read correctly
390 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 P P
DateAdd(): change input <amount> argument from INT to BIGINT
391 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 P P
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
392 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 P P
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
393 SS 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 P P P P P
Keyword SET should not be required in ALTER USER statement
394 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 P P
Error "no current record for fetch operation" when table inner join procedure inner join table
395 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 P P
Ability to trace stored functions execution
396 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 P P
SELECT from derived table which contains GROUP BY on field with literal value returns wrong result
397 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Wrong result of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
398 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Create function/sp which references to non-existent exception <...>
399 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 P P
Truncation error when using EXECUTE STATEMENT with a blob
400 SS 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 P P P P P
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
401 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
402 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     E     P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
403 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     E     P P P P P
ISQL truncates blob when reading an empty segment
404 SS 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 P P P P P
Report more details for "object in use" errors
405 SS 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 P P P P P
Provide ability to specify extra-long name of log when doing gbak to avoid "attempt to store 256 bytes in a clumplet" message
406 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     E     P P P P P
Enhancement in precision of calculations with NUMERIC/DECIMAL
407 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
gbak: cannot commit index ; primary key with german umlaut
408 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 P P P P
gbak: cannot commit index ; primary key with german umlaut
409 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 P P
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
410 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
411 SS P P P P P P P P P     E         E     P P P P P P P P P P     E     P P P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
412 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 P P
Properties of user created in Legacy_UserManager padded with space up to 10 character
413 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
414 SS 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 P P P P P
Regression: NOT NULL constraint, declared in domain, does not work
415 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 P P
Expressions containing some built-in functions may be badly optimized
416 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 P P
nbackup prints error messages to stdout instead stderr
417 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     E     P P P P P
Duplicate tags for CREATE/ALTER USER not handled correctly
418 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 P P
Add DROP NOT NULL to ALTER COLUMN
419 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 P P
gbak fails to restore database containing dependency between views and packaged functions
420 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 P P
Message "Modifying function <F> which is currently in use" when running script with AUTODDL=OFF and <F> is called from INTERNAL function declared in other unit
421 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 P P
Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
422 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 P P
Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
423 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 P P
Changed data not visible in WHEN-section if exception occured inside SP that has been called from this code
424 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 P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
425 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Index not found for RECREATE TRIGGER
426 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     E     P P P P P
Unable delete procedure source on Firebird 3.0 Alpha 2.0
427 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 P P
Allow to use index when GROUP BY on field which has DESCENDING index
428 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 P P
DB_KEY based join of two tables may be ineffective
429 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 P P
Server does not accept the right plan
430 SS 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 P P P P P
FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
431 SS 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 P P P P P
Change type of returning value of CHAR_LENGTH, BIT_LENGTH and OCTET_LENGTH of BLOBs to bigint
432 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 P P
EXECUTE STATEMENT rise varchar char_length() size
433 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 P P
Regression: SP "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work
434 CS P P X P P P P P P     E         E     P P P P P P P P P P P U P P P P P P P
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
435 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 P P P P
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
436 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     E     P P P P P
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
437 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 P P
no permission for CREATE access to DATABASE (for RDB$ADMIN)
438 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
439 SS P P U P P P P P P     E         E     P P P P P P P P P P P P P     E     P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
440 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     E     P P P P P
Error while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
441 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 P P
DISTINCT vs non-DISTINCT affects the result of IN subquery
442 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 P P
CTE Aliases ('Column unknown' when recursive CTE contain join with *alias* rather than table name)
443 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     E     P P P P P
ISQL pads blob columns wrongly when the column alias has more than 17 characters
444 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 P P
Add a flag to mon$database helping to decide what type of security database is used - default, self or other
445 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 P P
Prohibit an ability to issue DML or DDL statements on RDB$ tables
446 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 P P
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
447 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 P P
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code at offset 15, encountered 255"
448 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     E     P P P P P
ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
449 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 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
450 SS 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 P P P P P
Can not restore in FB 3.0 SuperServer from .fbk which source .fdb was created on 2.5.4 and moved to READ-ONLY before backed up
451 SS 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 P P P P P
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
452 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 P P
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
453 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
454 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 P P
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
455 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 P P
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
456 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
457 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 P P P P
Regression: MIN/MAX with a join ignores possible index navigation
458 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 P P
Regression: List of aggregation is not checked properly
459 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 P P
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
460 SS 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 P P P P P
Make ISQL display character set when sqlda_display is on
461 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     E     P P P P P
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
462 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     E     P P P P P
Altering a trigger indicating other table than the original does not reflect the change
463 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     E     P P
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
464 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 P P
Increase speed of creating package when number of its functions more than several hundreds
465 CS P P X P P P P P P P P P P P P P P P P P P P     E     P P P P P P P
FBSVCMGR with `action_trace_start` prevents in 3.0 SuperServer from connecting using local protocol
466 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     E     P P P P P
Speed up function creation and loading when there are many functions in the database
467 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     E     P P P P P
MERGE / HASH JOINs produce incorrect results when VARCHAR join keys differ only by trailing spaces
468 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 P P
Add ability to track domains rename in DDL triggers
469 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 P P
IIF function prevents the condition from being pushed into the union for better optimization
470 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
471 SS 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 P P P P P
Different collation ID for altered computed column
472 SS 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 P P P P P
View/subselect with "union" does not use computed index
473 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 P P
Statistics for any system index can not be updated/recalculated
474 SS 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 P P P P P
The package procedure with value by default isn't called if this parameter isn't specified.
475 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     E     P P P P P
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
476 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 P P
Detach using Linux client takes much longer than from Windows
477 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 P P
Ordering by compound index together with a range condition gives wrong results
478 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 P P
Non-privileged user can implicitly count records in a restricted table
479 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 P P
Server crashes during GC when DELETE is executed after adding new referencing column
480 CS P P X P P P P P P     E         E     P P P P P P P P P P P P P P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
481 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     E     P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
482 SS 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 P P P P P
Regression: ORDER BY clause on compound index may disable usage of other indices
483 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 P P
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
484 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 P P
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
485 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 P P
ISQL 'SHOW DATABASE' command does not show encryption status of database
486 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 P P
Server does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator
487 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 P P
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
488 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 P P
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
489 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 P P
ISQL extract command looses COMPUTED BY field types
490 SS 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 P P P P P
ISQL extract command lose COMPUTED BY field types
491 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     E     P P P P P
False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
492 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 P P
Support autocommit mode in SET TRANSACTION statement
493 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 P P
Expression index may not be used by the optimizer if created and used in different connection charsets
494 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 P P
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
495 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 P P
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
496 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 P P
Unique index could be created on non-unique data
497 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     E     P P P P P
SEC$ tables and tag/attributes
498 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     E     P P P P P
HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
499 SS 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 P P P P P
Wrong error message with UNIQUE BOOLEAN field
500 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Allow implicit conversion between boolean and string
501 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     E     P P P P P
Invalid computed by definition generated by isql -x
502 SS 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 P P P P P
Return nonzero result code when restore fails on activating and creating deferred user index
503 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 P P
ISQL -x may crash while exporting an exception with message text length > 127 bytes
504 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 P P
ISQL -X: double quotes are missed for COLLATE <C> of CREATE DOMAIN statement when <C> is from any non-ascii charset
505 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     E     P P P P P
Authentication end with first plugin that has the user but auth fails; should continue with next plugin
506 SS 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 P P P P P
EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
507 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 P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
508 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 P P
Affected rows are not counted for some update operations with views
509 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 P P
String truncation error while selecting from MON$ tables if some user-defined context variable exceeds 255 bytes in length
510 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 P P
Nested OR conditions may lead to incorrest results
511 SS 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 P P P P P
FBTRACEMGR should understand 'role <name>' command switch (needed to explicitly connect with role with 'TRACE_ANY_ATTACHMENT' privilege)
512 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     E     P P P P P
FBSVCMGR does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N)
513 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 P P
Parameters with multibyte character sets allow to bypass the character limit of varchar fields
514 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 P P
Error messages differ when regular user tries to RESTORE database, depending on his default role and (perhaps) system privilege USE_GBAK_UTILITY
515 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Validation could read after the end-of-file when handle multifile database
516 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 P P P P
Validation could read after the end-of-file when handle multifile database
517 SS 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 P P P P P
Performance regression when bulk inserting into table with indices
518 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 P P
CASCADE UPDATE fails for self-referencing FK
519 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
520 SS P P P P P P P P P     E         E     P P P P P P P P P P     E     P P P P P P P P
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
521 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 P P
Data type unknown error with LIST
522 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     E     P P P P P
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
523 SS 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 P P P P P
Malformed string error when using cyrilic symbols and x'0d0a' in exception
524 CS P P X P P P P P P     E         E     P P P P P P P P P U P U P P P P P P P
Database gets partially corrupted in the "no-reserve" mode
525 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 P P P P
Database gets partially corrupted in the "no-reserve" mode
526 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     E     P P P P P
Trace session leads FB 4.0 to hang after 2nd launch of trivial .sql script. Neither attach to any database nor regular restart of FB service can be done.
527 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 P P
Regression: The subquery in the insert list expressions ignore the changes made earlier in the same executable block.
528 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
529 SS 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 P P P P P
Regression: could not use CASE expression with more than 255 conditions.
530 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 P P
Regression: (boolean) parameters as search condition no longer allowed
531 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 P P
Dependencies in Package not recognised
532 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 P P
Query cannot be executed if win1251 characters used in field aliases
533 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
534 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 P P
Invalid data type for negation (minus operator)
535 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     E     P P P P P
Inconsistent column/line references when PSQL definitions return errors
536 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     E     P P P P P
Performance degradation in FB 3.0.2 compared to FB 2.5.7
537 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 P P
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
538 SS 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 P P P P P
Support for INCREMENT option in identity columns
539 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     E     P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
540 SS P P     E     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
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
541 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     E     P P P P P
EXECUTE STATEMENT <e> when <e> starts with '--' issues -Unexpected ... column <NNN>, value <NNN> is invalid and can change randomly
542 SS 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 P P P P P
Support DEFAULT context value in INSERT, UPDATE, MERGE and UPDATE OR INSERT statements
543 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 P P
Support GENERATED ALWAYS identity columns and OVERRIDE clause
544 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     E     P P P P P
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
545 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 P P
Provide ability to filter out info and warnings from trace log
546 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 P P
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
547 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 P P
Bad performance for NULLs filtering inside a navigational index scan
548 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 P P
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
549 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
550 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 P P
Crash on 3.0 and 4.0 when DB contains database-level trigger
551 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 P P
Connections compressed and encrypted in MON$ATTACHMENTS table
552 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
553 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     E     P P P P P
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
554 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 P P
Use exception instead bugcheck for EVL_expr
555 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 P P
Direct system table modifications are not completely prohibited
556 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 P P
ISQL incorrectly pads UNICODE_FSS/UTF8 columns when they use a collation
557 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
558 SS 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 P P P P P
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
559 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 P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
560 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 P P
Invalid blob id when add a new blob column of type text and update another field
561 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 P P
Gradual slowdown compilation (create, recreate or drop) of views
562 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 P P
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
563 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 P P
Execute statement with excess parameters
564 SS 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 P P P P P
Regression in 3.0+: message CTE 'X' has cyclic dependencies appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query
565 SS 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 P P P P P
Allow unused Common Table Expressions
566 SS 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 P P P P P
Error "no current record for fetch operation" is raised while deleting record from MON$ATTACHMENTS using ORDER BY clause
567 SS 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 P P P P P
Sometime it is impossible to cancel\kill connection executing external query
568 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 P P
Store precision of DECFLOAT in RDB$FIELDS
569 CS P P X P P P P P P P P P P P P P P P P P     E     P U P P P P P P P
Trace config with misplaced "{" lead firebird to crash
570 SS 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 P P P P P
Trace config with misplaced "{" lead firebird to crash
571 SS 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 P P P P P
Begin and end of physical backup in the same transaction could crash engine
572 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 P P
Field alias disapears in complex query
573 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 P P
Reject non-constant date/time/timestamp literals
574 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 P P
FB >= 3 crashes when restoring backup made by FB 2.5.
575 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     E     P P P P P
When requesting the subtype of a NUMERIC or DECIMAL column with precision in [19, 34] using isc_info_sql_sub_type, it always returns 0, instead of 1 for NUMERIC and 2 for DECIMAL.
576 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     E     P P P P P
User can grant usage privilege by himself
577 SS 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 P P P P P
Date-time parsing is very weak
578 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 P P
No error if the GRANT target object does not exist
579 SS 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 P P P P P
Regression: FB crashes when trying to recreate table that is in use by DML
580 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 P P
Implement FILTER-clause for aggregate functions (introduced in SQL:2003). This syntax allows for filtering before aggregation.
581 SS 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 P P P P P
User who is allowed to manage other users must have this ability WITHOUT need to grant him RDB$ADMIN role
582 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 P P
Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete
583 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 P P
gstat may produce faulty report about presence of some none-encrypted pages in database
584 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 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
585 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 P P
Server crashes on preparing empty query when trace is enabled
586 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Ignor of reference privilege
587 SS 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 P P P P P
No permission for SELECT access to BLOB field if a TABLE is accessed using VIEW
588 SS 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 P P P P P
Wrong handling of failures of TRANSACTION START trigger
589 SS 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 P P P P P
"Malformed string" instead of key value in PK violation error message
590 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 P P
Very poor "similar to" performance
591 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 P P
Incorrect caching of the subquery result (procedure call) in independent queries
592 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 P P
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
593 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 P P
Initial global mapping from srp plugin does not work
594 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
SQL SECURITY DEFINER context is not properly evaluated for monitoring tables
595 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 P P
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
596 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 P P
Enhance dynamic libraries loading related error messages
597 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 P P
Bugcheck 165 (cannot find tip page) // Classic and SuperClassic only
598 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 P P
Firebird crashes, related to Bugcheck 165 (cannot find tip page)
599 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 P P
Built-in cryptographic functions
600 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 P P
Handling FP overflow in double precision value when converting from decfloat.
601 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 P P
error read permission for BLOB field, when it is input/output procedure`s parametr
602 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 P P
Pool of external connections
603 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 P P
Trace could not work correctly with quoted file names in trace configurations
604 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     E     P P P P P
RDB$GET_TRANSACTION_CN works different in Super and Classic
605 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 P P
FB4 unable to overwrite older ods database
606 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 P P
SUBSTRING(CURRENT_TIMESTAMP) does not work
607 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 P P
The original time zone should be set to the current time zone at routine invocation
608 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 P P
Srp user manager sporadically creates users which can not attach
609 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 P P
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
610 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 P P
Random crash 64bit fb_inet_server. Possible collation issue
611 SS 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 P P P P P
Change behavior of skipped and repeated wall times within time zones
612 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     E     P P P P P
Server hangs when compiling big package with error
613 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     E     P P P P P
USING PLUGIN clause does not work in RECREATE USER
614 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 P P
CREATE SEQUENCE START WITH has wrong initial value
615 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 P P
Problem with casting within UNION
616 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 P P
"SIMILAR TO" hangs when processing parenthesis
617 SS 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 P P P P P
BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
618 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     E     P P P P P
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
619 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 P P
Changing FLOAT to a SQL standard compliant FLOAT datatype
620 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     E     P P P P P
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
621 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 P P
Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...')
622 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 P P
Server crashes when it run SQL
623 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 P P
Inconsistent behavior regarding visibility of master record on detail inserts
624 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 P P
Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers
625 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 P P
substring similar - extra characters in the result for non latin characters
626 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 P P
"No current record for fetch operation" with queries with aggregated subselect
627 SS P P P P P P P P P P P P P P P P P P P P P     E     P P     E     P P P P P
Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation"
628 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     E     P P P P P
Some (wrong ?) parameters of ENCRYPT() leads FB to crash
629 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 P P
Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call
630 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     E     P P P P P
VARCHAR of insufficient length used for set bind of decfloat to varchar
631 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 P P
request size limit exceeded when selecting from a table with large number of indicies
632 SS 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 P P P P P
Add support for special (inf/nan) values when sorting DECFLOAT values
633 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     E     P P P P P
isc_info_svc_user_dbpath always returns alias of main security database
634 SS 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 P P P P P
Performance problem when using SRP plugin
635 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     E     P P P P P
DECFLOAT: subtraction Num1 - Num2 leads to "Decimal float overflow" if Num2 is specified in scientific notation and less than max double ( 1.7976931348623157e308 )
636 SS 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 P P P P P
Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND
637 SS P P P P P P P P P P P P P P P P P