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 (4 rows)
5. Has fails: tests with at least one fail for previous runs (108 rows)
[CURRENT] 6. Has runtime errors: tests with at least one runtime error for previous runs (891 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (3158 rows)
9. All tests: durations (4496 rows)
A. Skipped: tests which was intentionally excluded from execution (3 rows)

Generated 14.05.2022 09:18
Tested: FB50.   Build: 5.0.0.494;   SS: 14.05.22 06:16:26 - 14.05.22 07:44:40;   CS: 14.05.22 07:47:50 - 14.05.22 09:13:55;
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.494
2022-05-14
5.0.0.493
2022-05-12
5.0.0.492
2022-05-07
5.0.0.491
2022-05-06
5.0.0.489
2022-05-01
5.0.0.488
2022-04-25
5.0.0.487
2022-04-24
5.0.0.482
2022-04-23
5.0.0.477
2022-04-22
5.0.0.475
2022-04-16
5.0.0.472
2022-04-12
5.0.0.471
2022-04-10
5.0.0.469
2022-04-08
5.0.0.467
2022-04-07
5.0.0.459
2022-04-06
5.0.0.457
2022-04-04
5.0.0.455
2022-04-03
5.0.0.451
2022-04-02
5.0.0.448
2022-04-01
5.0.0.445
2022-03-31
5.0.0.442
2022-03-30
5.0.0.440
2022-03-29
5.0.0.439
2022-03-25
5.0.0.437
2022-03-20
5.0.0.429
2022-03-18
5.0.0.426
2022-03-11
5.0.0.425
2022-03-08
5.0.0.423
2022-03-07
5.0.0.422
2022-03-05
5.0.0.419
2022-03-04
Test TITLE
1 SS 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 P P P P P
Trigger do it wrong
2 SS 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 P P P P P
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)
3 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Automatic not null in PK columns incomplete
4 SS 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 P P P P P
Expression index regression since 2.0a3
5 SS 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 P P P P P
Invalid ROW_COUNT variable value after DELETE
6 SS 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 P P P P P
Index bug
7 SS P P P P P 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
Strange/Inconsistent query results
8 SS P P P P P 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
Dropping and recreating a table in the same txn disables PK
9 SS 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 P P P P P
bug with ALL keyword
10 SS 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 P P P P P
CREATE TABLE - no blob for external
11 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Sqlsubtype incorrect on timestamp math, constant arithmetic
12 SS 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 P P P P P
Query using VIEW with UNION causes crash
13 SS 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 P P P P P
DB crashes if trigger BU deletes own row
14 SS 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 P P P P P
trigger on view with union receive nulls
15 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
trigger with except-s on view with union
16 SS 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 P P P P P
Bugcheck 291
17 SS 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 P P P P P
Empty column names with aggregate funcs
18 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
ORDER BY works wrong with collate PT_PT
19 SS 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 P P
CHECK constraints fire twice
20 SS 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 P P P P P
SELECT...HAVING...NOT IN crashes server
21 SS P P P P P 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
DOMAINs don't register their dependency on other objects
22 SS P P P P P 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
Blob Comparison with constant
23 SS 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 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     E     P P P P P P P P P P P P P
Complex view crashes server
25 SS P P P P P 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
NULLS FIRST does not work with unions
26 SS 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 P P P P P
Garbage vs indices/constraints
27 SS 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 P P P P P
Wrong sort order when using es_ES collate
28 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
JOIN including a complex view kills the server
29 SS 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 P P P P P
Redundant evaluations in COALESCE
30 SS 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 P P P P P
ORDER BY has no effect
31 SS 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 P P P P P
Grants overwrite previous rdb$security_classes entries
32 SS 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 P P P P P
Foreign key relation VARCHAR <-> INT
33 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Lot of syntax tests for COALESCE()
34 SS P P P P P 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
Tricky role defeats basic SQL security
35 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
FIRST is applied before aggregation
36 SS 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 P P P P P
SKIP is off by one
37 SS 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 P P P P P
ORDER BY on a VIEW turns values in fields into NULL
38 SS 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 P P P P P
Token unknown in simple SELECT with GROUP BY and ORDER BY
39 SS 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 P P P P P
Grouping on derived fields processing NULL data kills IB
40 SS 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 P P
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate
41 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
accent ignoring collation for unicode
42 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Specific query crashing server
43 SS 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 P P
computed field can't be changed to non-computed using 'alter table alter column type xy'
44 SS P P P P P 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
DYN allows to set defaults for computed fields when altering a field
45 SS 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 P P P P P
Aggregates in the WHERE clause vs derived tables
46 SS 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 P P P P P
Unable to set FName, MName, LName fields in security to blank
47 SS 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 P P P P P
Containing not working correctly
48 SS 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 P P P P P
Removing a NOT NULL constraint is not visible until reconnect
49 SS 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 P P P P P
Engine crashes while trying to backup a logically corrupt db
50 SS 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 P P
Dependencies are not cleared when creation of expression index fails
51 SS 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 P P P P P
Singleton isn't respected in COMPUTED BY expressions
52 SS 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 P P P P P
The built-in BLR printer doesn't support all FB2 features
53 SS 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 P P P P P
It is impossible to take away rights on update of a column
54 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
SPs in views
55 SS 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 P P P P P
Problems with explicit cursors in unwanted states
56 SS 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 P P P P P
Garbage in plan output of complex statement
57 SS 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 P P P P P
An attempt to select DB_KEY from a procedure crashes the server
58 SS P P P P P 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
ALL predicate works incorrectly for some subqueries
59 SS P P P P P 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
Bug in DSQL parameter
60 SS 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 P P P P P
Comment in create database
61 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Bad error message when tring to create FK to non-existent table
62 SS 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 P P P P P
GSTAT does not work using the localhost connection string
63 SS 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 P P P P P
Case insensitive collation for UTF-8
64 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Make RDB$DB_KEY in outer joins return NULL when appropriate
65 SS P P P P P 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
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
66 SS P P P P P 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
Keyword AS not recognized in clause FROM
67 SS 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 P P P P P
Incorrect results when left join on subquery with constant column
68 SS P P P P P 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
context already in use (BLR error)
69 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs
70 SS 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 P P P P P
Provide mechanism to get engine version without needing to call API function
71 SS P P P P P 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
Make information available regading ODS Version and Dialect via SQL
72 SS P P P P P 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
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
73 SS 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 P P
Estonian collation in UTF8 charset
74 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
75 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Wrong single-segment ascending index on character field with NULL and empty string values
76 SS 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 P P P P P
Wrong parameter matching for self-referenced procedures
77 SS P P P P 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
A query could produce different results, depending on the presence of an index
78 SS 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 P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
79 SS 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 P P P P P
SINGULAR buggy when nulls present
80 SS P P P P 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
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
81 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     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
82 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Wrong results with GROUP BY on constants
83 SS 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 P P P P P
Crash when dealing with a string literal longer than 32K
84 SS 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 P P P P P
Recursive Query bug in FB2.1
85 SS 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 P P P P P
Cannot alter generator's comment to the same value
86 SS 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 P P P P P
AV in rse\invalidate_child_rpbs for recursive queies
87 SS 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 P P P P P
Prepare fails when having a parameter in a DSQL statement before a sub query
88 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
89 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
CHARACTER SET GBK is not installed
90 SS 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 P P P P P
isql exponential format of numbers has zero pad on windows
91 SS P P P P P 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
Symbols ignored for ES_ES_CI_AI collation
92 SS 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 P P P P P
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
93 SS 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 P P P P P
"CH" and "LL" are not separate spanish alphabet letters since 1994
94 SS 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 P P P P P
Union returns inconsistent field names
95 SS 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 P P P P P
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
96 SS 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 P P
Select Starting with :Param (Empty string) doesn't work if using index with many fields
97 SS 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 P P P P P
Long SQL statements break TCP/IP connection
98 SS 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 P P P P P
Server crash on select * from <recursive CTE>
99 SS P P P P P P P P P P P P P P P P     E     P P     F     P P P P P P P P P P
Incorrect column values with outer joins and views
100 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Incorrect timestamp arithmetic when one of operands is negative number
101 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Table columns hide destination variables of RETURNING INTO
102 SS 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 P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
103 SS 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 P P P P P
Bug with COMPUTED BY fields
104 SS 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 P P P P P
Can't create table using long username and UTF8 as attachment charset
105 SS 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 P P
Bad optimization of queries with DB_KEY
106 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Indices not used for views
107 SS P P P P P 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
RDB$DB_KEY not supported in derived tables and merge command
108 SS 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 P P P P P
Data type unknown
109 SS 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 P P P P P
NOT NULL constraint for procedure parameters and variables
110 SS 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 P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
111 SS 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 P P
Problem with view , computed field and functions
112 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
ISQL crash when converted-from-double string longer than 23 bytes
113 SS 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 P P P P P
Execute block fails within execute statement
114 SS 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 P P
Generated columns
115 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
CREATE VIEW without column list when UNION is used
116 SS P P P P P 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
Support for autonomous transactions
117 SS 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 P P
Incorrect timestamp substraction in 3 dialect when result is negative number
118 SS 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 P P P P P
Greek characters in cp1251 vs uppercasing
119 SS 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 P P P P P
Execute statement 'select ....' into new....
120 SS 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 P P
Allow usage of functions in LIST delimiter parameter
121 SS 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 P P P P P
DATEADD wrong work with NULL arguments
122 SS 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 P P
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
123 SS 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 P P
Bad XSQLVAR [NULL flags] for (2*COALESCE(NULL,NULL))
124 SS 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 P P P P P
Many new 2.1 built in functions have incorrect NULL semantics
125 SS 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 P P P P P
Adding a non-null restricted column to a populated table renders the table inconsistent
126 SS P P P P P 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
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
127 SS 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 P P
RDB$procedures generator overflow
128 SS P P P P P 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
Subquery-based predicates are not evaluated early in the join order
129 SS 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 P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
130 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
131 SS 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 P P P P P
'select ...from...where...not in (select...from...)' no results
132 SS P P P P P 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
Multiple Rows in Singleton Select not reported in a View
133 SS 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 P P
ABS() rounds NUMERIC values
134 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Server crashed or bugcheck when inserting in monitoring tables.
135 SS 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 P P P P P
Altering procedure parameters can lead to unrestorable database
136 SS 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 P P P P P
Correlated subquery is optimized badly if it depends on the union stream
137 SS 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 P P
PSQL output parameter size limited
138 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Incorrect error message (column number) if the empty SQL string is prepared
139 SS 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 P P P P P
MERGE not correctly worked with parameters in MATCHING clause
140 CS P P P P P 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
Non-privileged monitoring reports wrong attachment data
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     E     P P P P P P
Non-privileged monitoring reports wrong attachment data
142 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan
143 SS 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 P P P P P
Floor & ceiling functions give wrong results with exact numeric arguments
144 SS P P P P P 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
'There are <n> dependencies' error message shows the wrong count of dependent objects.
145 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
146 SS P P P P P 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
Expression index can be created while doing inserts into table
147 SS 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 P P P P P
Support hex numeric and string literals
148 SS P P P P P 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
Problem with COLLATE ES_ES_CI_AI
149 SS P P P P P 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
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
150 SS 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 P P P P P
Server crashes on SQL script
151 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation
152 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Ability to grant role to another role
153 SS 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 P P
AV when sorting by field, calculated using recursive CTE
154 SS 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 P P P P P
DEFAULT values are unnecessary evaluated
155 SS 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 P P P P P
Roles granting/revoking logic
156 SS P P P P P P P     F         F     P P P P P P P     E     P P P P P P P P P P P P P
CREATE COLLATION connection lost under Posix
157 SS 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 P P P P P
SHOW VIEW shows non-sense information for view fields with expressions
158 SS 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 P P
Circular dependencies between computed fields crashs the engine
159 SS 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 P P
Not valid fields in MERGE's insert clause are allowed
160 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
MON$DATABASE returns outdated transaction counters
161 SS 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 P P P P P
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.
162 SS 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 P P P P P
Custom attribute for collation to sort numbers in numeric order
163 SS 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 P P P P P
Bugcheck 291
164 SS 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 P P
Set the fixed and documented check order for WHERE clause and other conditional sentences
165 SS 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 P P P P P
Non-SYSDBA user can change FW mode of database.
166 SS 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 P P P P P
Broken foreign key handling for multi-segmented index using multi-level collations
167 SS 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 P P P P P
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
168 SS 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 P P
ALTER USER XXX INACTIVE
169 SS 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 P P P P P
Support SQL 2008 syntax for MERGE statement with DELETE extension
170 SS P P P P P 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
I/O statistics for stored procedures are not accounted in monitoring tables
171 SS 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 P P P P P
Incorrect buffer size for ORDER BY expression with system fields
172 SS 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 P P P P P
Stored procedure recursively called by calculated field fails after reconnect
173 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
174 SS 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 P P P P P
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
175 SS 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 P P P P P
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement
176 SS 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 P P
GROUP by and RDB$DB_KEY problems
177 CS 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 P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
178 SS 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 P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
179 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
RDB$DB_KEY in subselect expression incorrectly returns NULL
180 SS P P P P P 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
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
181 SS 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 P P
Query plan is missing for the long query
182 SS 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 P P
Incorrect ROW_COUNT value with indexed retrieval and subquery
183 SS P P P P P 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
Error messages after parameters substitution contains '8' characters instead of line break
184 SS 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 P P P P P
SIMILAR TO predicate hangs with "|" option
185 SS 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 P P P P P
Join of SP with view or table may fail with "No current record for fetch operation"
186 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Unexpected (wrong) results with COALESCE and GROUP BY
187 SS 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 P P
Add support for -nodbtriggers switch in gbak into services API
188 SS 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 P P P P P
Extremely slow executing a cross join of 3 tables in Firebird 2.X
189 SS 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 P P P P P
New gbak option to ignore specific tables data during the backup
190 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Nbackup as online dump
191 CS P P P P P 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
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
192 SS P P P P P 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
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
193 SS 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 P P P P P
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
194 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
gbak doesn't return error code
195 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
internal error when select upper(<blob>) from union
196 SS 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 P P P P P
GFIX causes BUGCHECK errors with non valid transaction numbers
197 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
MERGE non-standard behaviour, accepts multiple matches
198 SS 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 P P P P P
Records left in RDB$PAGES after rollback of CREATE TABLE statement
199 SS 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 P P P P P
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's
200 SS 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 P P P P P
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time
201 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
SIMILAR TO produces random results with [x-y] expressions
202 SS P P P P P 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
Incorrect result for the derived expression based on aggregate and computation
203 SS 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 P P P P P
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
204 SS P P P P 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
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
205 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
206 SS 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 P P P P P
ALTER VIEW could remove column used in stored procedure or trigger
207 SS 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 P P
ALTER VIEW doesn't clear dependencies on old views
208 SS 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 P P P P P
Server adds "NOT" at the end of default value for the TIMESTAMP field
209 SS 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 P P
CREATE USER command: Invalid error message
210 SS 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 P P P P P
Server crashes on UPDATE OR INSERT statement
211 SS P P P P P 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
Server fails when doing DROP DATABASE right after error in statistical fnction
212 SS 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 P P P P P
mon$memory_usage: Sorting memory should be reported as owned by the statement
213 SS 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 P P
Success message when connecting to tiny trash database file
214 SS 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 P P P P P
Binary shift functions give wrong results with negative shift values
215 SS P P P P P P P P P P P P P P P P     E         F     P P P P     E     P P P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
216 SS 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 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'
217 SS P P P P P 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
CI column does not group correctly with a second column
218 SS P P P P P 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
Maximum and minimum identifier length should be enforced by DSQL
219 SS 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 P P P P P
internal error [335544384]
220 SS P P P P P 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
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
221 SS P P P P P 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
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
222 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Infinity should not escape from the engine
223 SS P P P P P 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
Connection lost immediatelly after compiling procedure with RPAD system function
224 SS P P P P P 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
Unique index with a lot of NULL keys can be corrupted at level 1
225 CS 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 P P
Incorrect "string right truncation" error with NONE column and multibyte connection charset
226 SS 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 P P
Incorrect "string right truncation" error with NONE column and multibyte connection charset
227 SS 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 P P
Full outer join cannot use available indices (very slow execution)
228 SS 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 P P P P P
System triggers on view with check option are not removed
229 SS 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 P P P P P
Common table expression context could be used with parameters
230 SS 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 P P P P P
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
231 SS 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 P P P P P
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
232 SS 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 P P P P P
isql hangs when trying to show a view based on a procedure
233 SS 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 P P P P P
substring from timestamp - unexpected result
234 SS 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 P P P P P
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
235 SS 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 P P P P P
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
236 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Include client library version and protocol version in mon$attachments
237 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
AV using recursive query as subquery in SELECT list and ORDER'ing by them
238 SS 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 P P P P P
isql extracts the array dimensions after the character set name
239 SS 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 P P P P P
Problem with default value of SP parameter
240 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
241 SS 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 P P P P P
Changing sort directon in delete statement cause deletion of all records in table
242 SS P P P P P 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
Views based on procedures can't be created if the proc's output fields participate in an expression
243 SS 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 P P P P P
Unsuccessful execution' error when updating a record
244 SS 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 P P P P P
Prohibit any improper mixture of explicit and implicit joins
245 SS 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 P P P P P
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time
246 SS 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 P P P P P
Join condition fails for UTF-8 databases.
247 SS 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 P P P P P
Changing data that affects an expression index that contains references to null date fields fails
248 SS 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 P P P P P
Natural is used to select instead of primary key index
249 SS 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 P P P P P
Cannot remove user with dot in login
250 SS 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 P P P P P
View created from JOIN and LEFT JOIN doesnt order
251 SS 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 P P P P P
Outer ORDER BY clause has no effect
252 SS 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 P P P P P
EVL_expr: invalid operation (232)
253 SS 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 P P P P P
String right truncation error when char column longer than 4096 bytes compared with string constant
254 SS 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 P P P P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
255 SS P P P P P 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
isql should show packaged procedures and functions categorized per package
256 SS 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 P P P P P
Expression in a subquery may be treated as invariant and produce incorrect results
257 SS 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 P P P P P
Don't send full length of field over the wire when field is null
258 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
259 SS P P P P P 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
COLLATE expressions are applied incorrectly
260 SS 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 P P P P P
Broken error handling in the case of a conversion error happened during index creation
261 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Problem with dependencies between a procedure and a view using that procedure
262 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
"Invalid ESCAPE sequence" when connecting to the database
263 SS 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 P P P P P
DROP VIEW drops output parameters of used stored procedures
264 SS 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 P P P P P
Trace output could contain garbage data left from filtered out statements
265 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Case-sensitive character class names in SIMILAR TO
266 SS 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 P P P P P
count(*) from big table returns negative result
267 SS P P P P P 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
Incorrect ROW_COUNT value after SINGULAR condition
268 SS P P P P P 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
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
269 SS 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 P P
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
270 SS 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 P P P P P
Error in Trace plugin (use local symbols in query)
271 SS 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 P P P P P
Error on delete user "ADMIN"
272 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Add attachment's CHARACTER SET name into corresponding trace records
273 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Wrong resultset
274 SS P P P P P 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
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
275 SS 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 P P P P P
Wrong logic is used to resolve EXECUTE BLOCK parameters collations
276 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Wrong resultset
277 SS P P P P P 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
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
278 CS 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 P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
279 SS 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 P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
280 SS 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 P P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
281 SS 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 P P
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
282 SS 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 P P P P P
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
283 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
284 SS 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 P P P P P
Cannot alter the domain after migrating from older versions
285 SS 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 P P P P P
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
286 SS P P P P P 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
Partial rollback is possible for a selectable procedure modifying data
287 SS 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 P P P P P
Preserve comments for parameters after altering procedures
288 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Parameterized requests involving blob fields fails when connected using charset UTF8
289 SS 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 P P P P P
exclude_filter doesn't work for <services></section> section of the Trace facility
290 SS 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 P P P P P
Expression index with TRIM may lead to incorrect indexed lookup
291 SS 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 P P P P P
View with "subselect" column join table and not use index
292 SS P P P P P P P P P P P P P P P P     E     P P P P P     E         F         F     P P P P P
page 0 is of wrong type (expected 6, found 1)
293 SS P P P P P 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
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
294 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
ASCII_VAL() fails if argument contains multi-byte character anywhere
295 SS 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 P P P P P
Support for text BLOBs >= 32K as first argument for TRIM()
296 SS P P P P P 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
UTF8 UNICODE_CI collate can not be used in compound index
297 SS 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 P P
POSITION: Wrong result with '' if third argument present
298 SS 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 P P P P P
LIST() may overwrite last part of output with zero characters
299 SS P P P P P 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
Wrong result for RIGHT(UTF8 varchar)
300 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
301 SS 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 P P P P P
Error "context already in use" for the simple case function with a sub-select operand
302 SS 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 P P P P P
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
303 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Ability to cancel waiting in lock manager
304 SS 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 P P P P P
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)
305 SS P P P P P 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
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
306 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Extend syntax for ALTER USER CURRENT_USER
307 SS P P P P P 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
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
308 SS 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 P P P P P
Allow write operations to temporary tables in read only transactions
309 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Collation errors with [type of] <domain>, type of column
310 SS 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 P P P P P
Database trigger created as INACTIVE is active
311 SS 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 P P P P P
BOOLEAN not present in system table RDB$TYPES
312 SS 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 P P P P P
Server crashing with UTF8 blobs
313 SS 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 P P P P P
ISQL pads UTF-8 data incorrectly
314 SS 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 P P P P P
DDL operations fail after backup/restore
315 SS 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 P P P P P
LIST function wrongly concatenates binary blobs
316 SS P P P P P 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
Blob transliteration may not happen inside the union
317 SS 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 P P P P P
Altering of a TYPE OF COLUMN parameter affects the original column
318 SS 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 P P P P P
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
319 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Alter procedure allows to add the parameter with the same name
320 SS 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 P P P P P
Unquoted role names with non-ASCII characters passed in DPB are upper-cased wrongly
321 SS 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 P P P P P
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
322 SS 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 P P P P P
Aliases for the RETURNING clause
323 SS 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 P P P P P
Floating-point negative zero doesn't match positive zero in the index
324 SS P P P P P 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
GFIX returns an error after correctly shutting down a database
325 SS 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 P P P P P
CHAR(32767) present in XSQLVAR with length 32765
326 SS 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 P P P P P
Include expected and actual string lenght into error message for sqlcode -802
327 SS 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 P P P P P
Possible drop role RDB$ADMIN
328 SS 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 P P P P P
Can insert DUPLICATE keys in UNIQUE index
329 SS 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 P P
Wrong data while retrieving from CTEs (or derived tables) with same column names
330 SS 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 P P P P P
Plan returned for query with recursive CTE return wrong count of parenthesis
331 SS 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 P P
Window Function: ntile(num_buckets integer)
332 SS P P P P P 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
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
333 SS 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 P P
Window Function: frame (rows / range) clause
334 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
computed index by substring function for long columns
335 SS 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 P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
336 SS 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 P P P P P
Wrong results if the recursive query contains an embedded GROUP BY clause
337 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
338 SS 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 P P P P P
internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate
339 SS P P P P P P P P     E     P P 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
340 SS 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 P P
IS NOT DISTINCT FROM NULL doesn't use index
341 SS 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 P P P P P
GBAK fails to fix system generators while restoring
342 SS 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 P P P P P
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
343 SS P P P P P 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
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
344 SS 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 P P P P P
SIMILAR TO works wrongly
345 SS 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 P P P P P
Conversion error when using a blob as an argument for the EXCEPTION statement
346 SS 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 P P P P P
Report OS user name in MON$ATTACHMENTS
347 SS P P P P P 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
fb server die when carry out the LEFT + INNER JOIN
348 SS P P P P P 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
with caller privileges option do not work with autonomous transaction option
349 SS P P P P 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
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
350 SS 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 P P
Bad alias table choice joining CTE
351 SS 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 P P P P P
Trace API: Faulty database filter crashes server
352 SS 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 P P P P P
Server crashes on preparing empty query when trace is enabled
353 SS 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 P P P P P
Wrong numbers in error message for decreasing char/varchar columns
354 SS P P P P P 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
High memory usage when PSQL code SELECT's from stored procedure which modified some data
355 SS 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 P P P P P
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
356 SS 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 P P
Improve SIMILAR TO performance
357 SS 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 P P P P P
Bugcheck 291 (cannot find record back version) if GTT is modified concurrently using at least one read-committed read-only transaction
358 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Invalid "attempted update of read-only column" error when trying select minvalue from list with more than 255 elements
359 SS 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 P P P P P
Restore from gbak backup using service doesn't report an error
360 SS 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 P P P P P
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
361 SS 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 P P
Creating a procedure containing "case when" expression leads to a server crash
362 SS 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 P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
363 SS 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 P P
subselect with reference to outer select fails
364 SS 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 P P
Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
365 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
366 SS 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 P P P P P
"attempted update of read-only column" when trying update editable view without triggers
367 SS 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 P P P P P
Join using RDB$DB_KEY produce NATURAL plan
368 SS 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 P P
Bug in unique constraints and / or NUMERIC-SORT collation
369 SS P P P P P 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
wrong error message with recursive CTE
370 SS P P P P P 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
using a result from a procedure in a substring expression leads to server crash
371 SS 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 P P P P P
Using system domain in procedures arguments/returns cause the proc to be unchangeable
372 SS 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 P P P P P
Broken optimization for the stored dbkeys
373 SS P P P P P 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
role not passed on external execute stmt
374 SS 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 P P P P P
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
375 SS 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 P P P P P
isql does not insert boolean values correctly, always shown as False
376 SS 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 P P P P P
NOT-NULL-column can be used as primary key and filled with NULL-values
377 SS 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 P P P P P
Computed by columns and position function
378 SS 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 P P
Wrong value of expected length in the sring right truncation error
379 SS P P P P P 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
Full outer join in derived table with coalesce (iif)
380 SS 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 P P P P P
Regression: Group by fails if subselect-column is involved
381 SS 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 P P
Incorrect full join result with ROW_NUMBER() Function in CTE
382 SS 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 P P P P P
Wrong parameters order in trace output
383 SS 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 P P P P P
Bad optimization of OR predicates applied to unions
384 SS 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 P P P P P
EXECUTE BLOCK prepare fails
385 SS P P P P P 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
Metadata export with isql (option -ex) does not export functions properly
386 SS 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 P P P P P
gbak -r fails in restoring all stored procedures/functions in packages
387 SS 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 P P P P P
Error when processing an empty data set by window function, if reading indexed
388 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
In SS sweep blocks establishment of concurrent attachments
389 SS 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 P P P P P
Wrong metadata output script generate by isql / CHARACTER SETISO8859_1 sintax error
390 SS 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 P P P P P
Error "invalid stream" can be raised in some cases while matching a computed index
391 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
392 SS 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 P P P P P
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
393 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Error "context already in use (BLR error)" when preparing a query with UNION
394 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
External routines DDL in Packages wrongly report error for termination with semi-colon
395 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Parameterized exception does not accept not ASCII characters as parameter
396 SS 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 P P P P P
User can not insert records into table with column "generated by default as identity" in its DDL
397 SS 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 P P P P P
Replace the hierarchical union execution with the plain one
398 SS 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 P P P P P
Setting generator value twice in single transaction will set it to zero
399 CS 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 P P
CREATE COLLATION does not verify base collation charset
400 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
CREATE COLLATION does not verify base collation charset
401 SS P P P P P 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
Incorrect "token unknown" error when the SQL string ends with a hex number literal
402 SS 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 P P P P P
An uncommitted select of the pseudo table sec$users blocks new database connections
403 SS 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 P P P P P
Cannot create packaged routines with [VAR]CHAR parameters
404 SS 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 P P P P P
Add RESTART [WITH] clause for alter identity columns
405 SS P P P P P 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
Dropping FK on GTT crashes server
406 SS 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 P P P P P
Regression: Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
407 SS 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 P P P P P
Bidirectional cursor is not positioned by the first call of FETCH LAST
408 SS P P P P P 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
Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
409 SS P P P P P 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
Problem with creation procedure which contain adding text in DOS864 charset
410 SS 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 P P P P P
Add table name to text of validation contraint error message, to help identify error context
411 SS P P P P P 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
Parametrized queries using RDB$DB_KEY do not work
412 SS P P P P P P P     E     P P P P P P P P P     F     P P P P P P P P P P P P
Check result when joined fields are created via row_number() function
413 SS 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 P P P P P
FB3: Stored function accepts duplicate input arguments
414 SS 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 P P
Choose the best matching index for navigation
415 SS 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 P P P P P
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
416 SS P P P P P 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
Non-ASCII data in SEC$USERS is not read correctly
417 SS 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 P P P P P
Lookup (or scan) in descending index could be very inefficient for some keys
418 SS 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 P P P P P
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
419 SS 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 P P
Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
420 SS 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 P P P P P
DateAdd(): change input <amount> argument from INT to BIGINT
421 SS 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 P P P P P
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
422 SS 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 P P P P P
Engine crashes when use aggregate or window functions in recursive query (instead of producing compiling error)
423 SS 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 P P
not correct result function LAG, if OFFSET value are assigned from a table
424 SS 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 P P P P P
LAG, LEAD and NTH_VALUE raise error when the second argument is NULL
425 CS P P P P P P P P P P P P P P P P P P P P P     F         E     P P P P P P P
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
426 SS P P P P 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
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
427 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Error "no current record for fetch operation" when table inner join procedure inner join table
428 SS 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 P P
Ability to trace stored functions execution
429 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Parsing of recursive query returns error "Column does not belong to referenced table" for source that HAS such column
430 SS 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 P P
non-priviledged user can insert and update rdb$database
431 SS 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 P P P P P
Wrong result of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
432 SS 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 P P P P P
Create function/sp which references to non-existent exception <...>
433 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
434 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Preparation of erroneous DDL statement does not show the main command failed
435 CS 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 P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
436 SS P P P P P P P     E     P P P P P P P P     E     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
437 SS 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 P P P P P
Incorrect line/column information in runtime errors
438 SS 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 P P P P P
SELECT WITH LOCK may enter an infinite loop for a single record
439 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     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
440 SS 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 P P P P P
Enhancement in precision of calculations with NUMERIC/DECIMAL
441 SS 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 P P P P P
Useless extraction of generic DDL trigger
442 SS 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 P P P P P
Server crashes while sorting records longer than 128KB
443 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
444 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
445 SS 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 P P P P P
Properties of user created in Legacy_UserManager padded with space up to 10 character
446 SS 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 P P P P P
Extend the use of colon prefix for read/assignment OLD/NEW fields and assignment to variables
447 SS 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 P P
Support for different hash algorithms in HASH system function
448 SS 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 P P P P P
isql crash without connect when execute command "show version"
449 SS P P P P P 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
Allow output to trace explain plan form.
450 SS P P P P P P P     F         F     P P P P P P P     E     P P P P P P P P P P P P P
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
451 SS 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 P P P P P
Regression: NOT NULL constraint, declared in domain, does not work
452 SS 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 P P P P P
DATEADD should support fractional value for MILLISECOND
453 SS P P P P P 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
nbackup prints error messages to stdout instead stderr
454 SS 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 P P
Duplicate tags for CREATE/ALTER USER not handled correctly
455 SS 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 P P
Add DROP NOT NULL to ALTER COLUMN
456 SS P P P P P 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
FB3: CREATE USER GRANT ADMIN ROLE does not work
457 SS 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 P P P P P
Add field in SEC$USERS reflecting whether a user has RDB$ADMIN role in security database
458 SS 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 P P
gbak fails to restore database containing dependency between views and packaged functions
459 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
ISQL issues warning: "Bad debug info format" when connect to database with stored function after it`s restoring
460 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Changed data not visible in WHEN-section if exception occured inside SP that has been called from this code
461 SS P P P P P 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
Cursor references must always represent the CURRENT state of the record, without caching when this record is read
462 SS P P P P P P P     E         E     P P P P P P     F         F     P P P P P P P P P P P P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
463 SS 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 P P P P P
Index not found for RECREATE TRIGGER
464 SS 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 P P
Regression in 3.0.x: wrong handling in FOR-cursor when NOT EXISTS( select from <VIEW> ) statement is used to check results obtained from SP
465 SS 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 P P P P P
Unable delete procedure source on Firebird 3.0 Alpha 2.0
466 SS P P P P P P P P P P P P P P P     F         E     P P P P P P P P P P P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
467 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Allow to use index when GROUP BY on field which has DESCENDING index
468 SS 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 P P P P P
DDL trigger remains active after dropped
469 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     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
470 SS P P P P P 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
Wrong error at ALTER PACKAGE
471 SS 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 P P P P P
Regression: Incorrect result in subquery with aggregate
472 SS 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 P P P P P
Within linger period one can not change some database properties
473 SS 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 P P P P P
Can't create column check constraint when the column is domain based
474 SS 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 P P P P P
Rollback doesn`t undo changes when MERGE statement updates the same target rows multiple times and PLAN MERGE is used
475 SS 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 P P P P P
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
476 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
no permission for CREATE access to DATABASE (for RDB$ADMIN)
477 SS 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 P P P P P
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
478 SS 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 P P P P P
Select from mon$table_stats doesn`t work on SC and CS
479 CS 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 P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
480 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
481 SS 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 P P P P P
Regression: incorrect calculation of byte-length for view columns
482 SS 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 P P P P P
Error while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
483 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
DISTINCT vs non-DISTINCT affects the result of IN subquery
484 SS 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 P P
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
485 SS 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 P P P P P
Implement ability to validate tables and indices online (without exclusive access to database)
486 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit
487 SS 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 P P P P P
invalid request BLR at offset 361 context already in use (BLR error)
488 SS P P P P P 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
Restore of shadowed database fails using -k ("restore without shadow") switch
489 SS P P P P P 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
Prohibit an ability to issue DML or DDL statements on RDB$ tables
490 SS 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 P P P P P
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
491 SS P P P P P 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
Granted role does not work with non-ascii username
492 SS 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 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
493 SS 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 P P P P P
EXECUTE STATEMENT using BLOB parameters results in "Invalid BLOB ID" error
494 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     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)
495 SS P P P P P 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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
496 SS 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 P P P P P
CREATE USER ... TAGS ( attr = 'prefix #suffix' ): suffix will be removed from storage because of character '#' in the value of attribute
497 SS P P P P P 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
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
498 SS 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 P P
Command `SHOW TABLE` fails when the table contains field with unicode collationin its DDL
499 SS 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 P P
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
500 SS 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 P P P P P
Prohibit ability to cast timestamps that out of valid range to varchar
501 CS 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 P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
502 SS 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 P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
503 SS 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 P P P P P
Regression: List of aggregation is not checked properly
504 SS P P P P P P P P P P P P P P P     F         E     P P P P P P P P 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
505 SS 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 P P P P P
ISQL doesn`t show number of affected rows for "MERGE ... WHEN MATCHING" in case when this number surely > 0
506 SS 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 P P P P P
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
507 SS P P P P P 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
Revoke all on all from role <R> -- failed with "SQL role <R> does not exist in security database"
508 SS 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 P P P P P
SHOW GRANTS does not display info about exceptions which were granted to user
509 SS 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 P P
Server crash when preparing a query with PLAN clause at some CTE
510 SS 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 P P P P P
Infinite "similar to" matching
511 SS P P P P P 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
Increase speed of creating package when number of its functions more than several hundreds
512 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
ISQL input command (or -i option) reads large (> 64K) lines incorrectly
513 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
FBSVCMGR with `action_trace_start` prevents in 3.0 SuperServer from connecting using local protocol
514 SS 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 P P P P P
Speed up function creation and loading when there are many functions in the database
515 SS P P P P P 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
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
516 SS P P P P P 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
IIF function prevents the condition from being pushed into the union for better optimization
517 SS 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 P P P P P
Add better transaction control to isql
518 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Different collation ID for altered computed column
519 SS P P P P P 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
Dialect 1 casting date to string breaks when in the presence a domain with a check constraint
520 SS P P P P P 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
Compound ALTER TABLE statement with ADD and DROP the same check constraint fails
521 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Statistics for any system index can not be updated/recalculated
522 SS 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 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.
523 SS 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 P P
Ordering by compound index together with a range condition gives wrong results
524 SS 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 P P
Non-privileged user can implicitly count records in a restricted table
525 CS 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 P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
526 SS 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 P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
527 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Regression: ORDER BY clause on compound index may disable usage of other indices
528 SS 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 P P P P P
Report the remote port number in MON$ATTACHMENTS
529 SS 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 P P P P P
Cannot CREATE VIEW that selects from a system table, despite having all grants
530 SS 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 P P P P P
CHAR_TO_UUID on column with index throws expression evaluation not supported Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
531 SS 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 P P P P P
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
532 SS 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 P P P P P
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
533 SS P P P P 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
Lost the charset ID in selection of array element
534 SS 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 P P P P P
"Invalid BLOB ID" error
535 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Server does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator
536 SS P P P P P 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
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
537 SS P P P P P 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
ISQL extract command looses COMPUTED BY field types
538 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
ISQL extract command lose COMPUTED BY field types
539 SS 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 P P
Expression index may not be used by the optimizer if created and used in different connection charsets
540 SS 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 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
541 SS 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 P P P P P
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
542 SS P P P P P 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
Regression: LEFT JOIN incorrectly pushes COALESCE into the inner stream causing wrong results
543 SS 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 P P P P P
Unique index could be created on non-unique data
544 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Wrong error message with UNIQUE BOOLEAN field
545 SS 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 P P P P P
Allow implicit conversion between boolean and string
546 SS 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 P P P P P
Precedence problem with operator IS
547 SS 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 P P P P P
Invalid computed by definition generated by isql -x
548 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Return nonzero result code when restore fails on activating and creating deferred user index
549 SS 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 P P
ISQL -X may generate invalid GRANT USAGE statements for domains
550 SS 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 P P P P P
Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
551 SS 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 P P P P P
ISQL -x may crash while exporting an exception with message text length > 127 bytes
552 SS P P P P P 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
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
553 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P 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
554 SS P P P P P 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
Allow to enforce IPv4 or IPv6 in URL-like connection strings
555 SS 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 P P P P P
Affected rows are not counted for some update operations with views
556 SS 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 P P P P P
Nested OR conditions may lead to incorrest results
557 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
FBSVCMGR does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N)
558 SS 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 P P P P P
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
559 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Parameters with multibyte character sets allow to bypass the character limit of varchar fields
560 SS 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 P P
Validation could read after the end-of-file when handle multifile database
561 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Performance regression when bulk inserting into table with indices
562 SS 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 P P
CASCADE UPDATE fails for self-referencing FK
563 SS 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 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
564 SS P P P P P 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
User collate doesn't work with blobs
565 SS 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 P P P P P
Window Function: named window
566 SS 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 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
567 SS 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 P P P P P
Regression: could not use CASE expression with more than 255 conditions.
568 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Regression: (boolean) parameters as search condition no longer allowed
569 SS 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 P P P P P
Query cannot be executed if win1251 characters used in field aliases
570 SS P P P P P 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
BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
571 SS 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 P P
Invalid data type for negation (minus operator)
572 SS 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 P P P P P
Inconsistent column/line references when PSQL definitions return errors
573 SS P P P P P 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
Inconsistent output when retrieving the server log via Services API
574 SS 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 P P P P P
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
575 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Support for INCREMENT option in identity columns
576 SS 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 P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
577 SS 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 P P
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
578 SS 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 P P P P P
EXECUTE STATEMENT <e> when <e> starts with '--' issues -Unexpected ... column <NNN>, value <NNN> is invalid and can change randomly
579 SS 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 P P P P P
INSERT into updatable view without explicit field list failed
580 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
AV in fbclient when reading blob stored in incompatible encoding
581 SS P P P P P P P P     E     P P P P P P P P P P P P P P P P P P P P P
Provide ability to filter out info and warnings from trace log
582 SS 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 P P P P P
Available indices are not used in some cases if ORDER BY expression is a filtered one
583 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
584 SS     F         F         F         F         F         F         F         E         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F    
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
585 SS P P P P P 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
Bad performance for NULLs filtering inside a navigational index scan
586 SS P P P P P P P     E         E     P P P P P P P     E     P P P P P P P P 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
587 SS 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 P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
588 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Crash on 3.0 and 4.0 when DB contains database-level trigger
589 SS 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 P P
Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
590 SS 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 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)
591 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P 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)
592 SS 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 P P
Wrong syntax with CREATE TRIGGER ... ON <table> used with POSITION
593 SS 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 P P
3.0 error handling for SELECT WITH LOCK breaks compatibility with 2.5
594 SS 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 P P P P P
Use exception instead bugcheck for EVL_expr
595 SS P P P P P 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
No integer division possible in dialect 1
596 SS 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 P P
request synchronization error in the GBAK utility (restore)
597 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
598 SS 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 P P P P P
System function RDB$ROLE_IN_USE cannot take long role names
599 SS P P P P P 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
Add expression index name to exception message if computation failed
600 SS P P P P P 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
Gradual slowdown compilation (create, recreate or drop) of views
601 SS P P P P P 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
Part of the pages of the second level blobs is not released when deleting relations.
602 SS 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 P P P P P
Shadow file is can not be created during restore when -use_all_space option is used
603 SS 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 P P P P P
Increase number of formats/versions of views from 255 to 32K
604 SS P P P P P P P     E     P P P P P P P P     E     P P P P P P P P P P P P P
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
605 SS 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 P P P P P
Execute statement with excess parameters
606 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     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
607 SS P P P P P 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
Unique constraint not working in encrypted database on first command
608 SS P P P P P 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
Consider equivalence classes for index navigation
609 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     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
610 SS 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 P P P P P
Position function does not consider the collation for blob
611 SS P P P P P 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
Conversion from numeric literals to DECFLOAT adds precision that is not originally present
612 SS P P P P P P P P P P P P P P P P     E     P P P P P     E     P P P P P P P
Trace config with misplaced "{" lead firebird to crash
613 SS 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 P P
Field alias disapears in complex query