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

Generated 30.06.2022 17:38
Tested: HQ30.   Build: 3.0.10.33601;   SS: 30.06.22 15:19:44 - 30.06.22 16:18:57;   CS: 30.06.22 16:21:46 - 30.06.22 17:29:29;
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...

Outcomes for the whole set of tests in the last 30 runs:
NN Test name mode 3.0.10.33601
2022-06-30
3.0.10.33587
2022-06-01
3.0.10.33580
2022-04-30
3.0.10.33577
2022-04-24
3.0.10.33570
2022-04-16
3.0.10.33569
2022-02-25
3.0.9.33561
2022-02-22
3.0.9.33560
2022-02-11
3.0.9.33556
2022-02-09
3.0.9.33548
2022-01-07
3.0.8.33540
2021-12-20
3.0.8.33533
2021-12-01
3.0.8.33528
2021-11-08
3.0.8.33501
2021-11-06
3.0.8.33490
2021-09-17
3.0.8.33489
2021-08-10
3.0.8.33488
2021-08-07
3.0.8.33487
2021-07-31
3.0.8.33471
2021-07-26
3.0.8.33470
2021-06-02
3.0.8.33468
2021-05-29
3.0.8.33452
2021-05-06
3.0.8.33430
2021-04-21
3.0.8.33423
2021-03-30
3.0.8.33415
2021-03-04
3.0.8.33403
2021-02-08
3.0.8.33392
2022-06-21
X X X
Test TITLE
1 ALL 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 X X X
FBserver shutsdown when a user password is attempted to be modified to a empty string
2 CS 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 X X X
Incorrect value returned with execute statement calculation
3 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Incorrect value returned with execute statement calculation
4 CS 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 X X X
Navigation vs IS NULL vs compound index
5 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Navigation vs IS NULL vs compound index
6 ALL 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 X X X
Trigger do it wrong
7 ALL 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 X X X
Navigation vs IS NULL vs compound index
8 ALL 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 X X X
cannot create procedure with long chain of else-if clauses
9 ALL 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 X X X
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)
10 ALL 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 X X X
WHERE CURRENT OF doesn't work
11 ALL 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 X X X
Automatic not null in PK columns incomplete
12 ALL 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 X X X
Sequence of commands crash FB server
13 ALL 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 X X X
Expression index regression since 2.0a3
14 ALL 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 X X X
Invalid ROW_COUNT variable value after DELETE
15 ALL 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 X X X
Query with not in (select) returns wrong result
16 ALL 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 X X X
Index bug
17 ALL 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 X X X
Join on diffrent datatypes
18 ALL 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 X X X
Using where params in SUM return incorrect results
19 ALL 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 X X X
Recreate and self-referencing indexes
20 ALL 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 X X X
Strange/Inconsistent query results
21 ALL 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 X X X
JOIN the same table - problem with alias names
22 ALL 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 X X X
Dropping and recreating a table in the same txn disables PK
23 ALL 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 X X X
bug with ALL keyword
24 ALL 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 X X X
CREATE TABLE - no blob for external
25 ALL 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 X X X
Expression evaluation not supported on LEFT JOIN
26 ALL 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 X X X
numeric div in dialect 3 mangles data
27 ALL 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 X X X
index breaks = ANY result
28 ALL 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 X X X
Using where params in SUM return incorrect results
29 ALL 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 X X X
SELECT '1' UNION SELECT '12'
30 ALL 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 X X X
Left joining views with null fails
31 ALL 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 X X X
Sqlsubtype incorrect on timestamp math, constant arithmetic
32 ALL 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 X X X
Query using VIEW with UNION causes crash
33 ALL 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 X X X
cannot specify PLAN in UPDATE statement
34 ALL 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 X X X
DB crashes if trigger BU deletes own row
35 ALL 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 X X X
trigger on view with union receive nulls
36 CS 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 X X X
trigger with except-s on view with union
37 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     E     X X X
trigger with except-s on view with union
38 CS 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 X X X
Bugcheck 291
39 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     E     X X X
Bugcheck 291
40 ALL 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 X X X
SYSDBA can grant non existent roles
41 ALL 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 X X X
wrong order by in table join storedproc
42 ALL 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 X X X
Empty column names with aggregate funcs
43 CS 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 X X X
ORDER BY works wrong with collate PT_PT
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 P P     E     X X X
ORDER BY works wrong with collate PT_PT
45 ALL 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 X X X
CREATE VIEW ignores PLAN
46 ALL 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 X X X
CHECK constraints fire twice
47 ALL 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 X X X
CS server crash altering SP in 2 connect
48 ALL 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 X X X
SELECT...HAVING...NOT IN crashes server
49 CS 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 X X X
Count ( DISTINCT ... ) is too slow
50 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Count ( DISTINCT ... ) is too slow
51 ALL 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 X X X
Too many grants lose privileges
52 CS 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 X X X
ALTER TABLE altering to VARCHAR
53 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
ALTER TABLE altering to VARCHAR
54 ALL 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 X X X
DOMAINs don't register their dependency on other objects
55 ALL 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 X X X
Blob Comparison with constant
56 ALL 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 X X X
bug #585624 IB server stalled by simple script
57 CS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
ANY user can drop procedures, generators, exceptions.
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 P P     F     X X X
ANY user can drop procedures, generators, exceptions.
59 ALL 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 X X X
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream
60 ALL 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 X X X
DateTime math imprecision
61 CS 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 X X X
bug #910430 ISQL and database dialect
62 SS 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         E     X X X
bug #910430 ISQL and database dialect
63 ALL 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 X X X
Complex view crashes server
64 ALL 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 X X X
NULLS FIRST does not work with unions
65 ALL 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 X X X
Garbage vs indices/constraints
66 ALL 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 X X X
Wrong sort order when using es_ES collate
67 ALL 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 X X X
JOIN including a complex view kills the server
68 ALL 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 X X X
Redundant evaluations in COALESCE
69 ALL 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 X X X
ORDER BY has no effect
70 ALL 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 X X X
Grants overwrite previous rdb$security_classes entries
71 ALL 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 X X X
Foreign key relation VARCHAR <-> INT
72 ALL 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 X X X
Lot of syntax tests for COALESCE()
73 ALL 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 X X X
ambiguous statements return unpredictable results
74 ALL 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 X X X
Permissions are checked case-insensitively
75 ALL 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 X X X
Inconsistent results using STARTING WITH and COALESCE
76 ALL 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 X X X
before triggers are firing after checks
77 ALL 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 X X X
Tricky role defeats basic SQL security
78 ALL 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 X X X
FIRST is applied before aggregation
79 ALL 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 X X X
SKIP is off by one
80 ALL 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 X X X
ORDER BY on a VIEW turns values in fields into NULL
81 ALL 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 X X X
Token unknown in simple SELECT with GROUP BY and ORDER BY
82 ALL 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 X X X
Grouping on derived fields processing NULL data kills IB
83 ALL 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 X X X
Blob Type 1 compatibility with VarChar
84 ALL 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 X X X
User Account maintanance in SQL
85 CS 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 X X X
Compress Data over the Network
86 SS 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 X X X
Compress Data over the Network
87 ALL 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 X X X
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate
88 ALL 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 X X X
Alter view
89 CS 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 X X X
Easy metadata extract improvements
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 P     E     P X X X
Easy metadata extract improvements
91 ALL 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 X X X
Privileges of dynamic statements in SP
92 ALL 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 X X X
accent ignoring collation for unicode
93 ALL 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 X X X
Specific query crashing server
94 ALL 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 X X X
computed field can't be changed to non-computed using 'alter table alter column type xy'
95 ALL 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 X X X
DYN allows to set defaults for computed fields when altering a field
96 CS 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 X X X
Field can be used multiple times in multi-segment index definition
97 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Field can be used multiple times in multi-segment index definition
98 ALL 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 X X X
substring(current_user from 4) fails
99 ALL 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 X X X
Aggregates in the WHERE clause vs derived tables
100 ALL 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 X X X
Unable to set FName, MName, LName fields in security to blank
101 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Containing not working correctly
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 P     F     P X X X
Containing not working correctly
103 ALL 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 X X X
Server crash when using UDF
104 ALL 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 X X X
Removing a NOT NULL constraint is not visible until reconnect
105 ALL 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 X X X
Engine crashes while trying to backup a logically corrupt db
106 ALL 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 X X X
Incorrect handling of null within view - returns 0
107 ALL 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 X X X
problem when dropping column that is a primary key
108 CS 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 X X X
Dependencies are not cleared when creation of expression index fails
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 P P     E     X X X
Dependencies are not cleared when creation of expression index fails
110 CS 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 X X X
Singleton isn't respected in COMPUTED BY expressions
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 P P     E     X X X
Singleton isn't respected in COMPUTED BY expressions
112 ALL 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 X X X
The built-in BLR printer doesn't support all FB2 features
113 ALL 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 X X X
It is impossible to take away rights on update of a column
114 ALL 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 X X X
SPs in views
115 ALL 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 X X X
DDL - object in use
116 ALL 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 X X X
SUBSTRING with NULL offset or length don't return NULL
117 ALL 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 X X X
Problems with explicit cursors in unwanted states
118 ALL 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 X X X
New value of column is accessable before update
119 ALL 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 X X X
Server crash on violation of NOT NULL constraint
120 ALL 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 X X X
Garbage in plan output of complex statement
121 ALL 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 X X X
An attempt to select DB_KEY from a procedure crashes the server
122 ALL 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 X X X
ALL predicate works incorrectly for some subqueries
123 ALL 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 X X X
Grants don't work for procedures used inside views
124 ALL 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 X X X
Bug in DSQL parameter
125 ALL 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 X X X
Comment in create database
126 CS 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 X X X
Bad error message when tring to create FK to non-existent table
127 SS 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     X X X
Bad error message when tring to create FK to non-existent table
128 ALL 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 X X X
AV when blob is used in expression index
129 CS 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 X X X
GSTAT does not work using the localhost connection string
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 P     E     P X X X
GSTAT does not work using the localhost connection string
131 ALL 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 X X X
Many aggregate functions within a single select list may cause a server crash
132 ALL 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 X X X
SQL with incorrect characters (outside the ASCII range) may be processed wrongly
133 ALL 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 X X X
Case insensitive collation for UTF-8
134 ALL 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 X X X
Make RDB$DB_KEY in outer joins return NULL when appropriate
135 CS P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
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 X X P X X X
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
137 ALL 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 X X X
select with FIRST and LEFT JOIN needs excess SORT in plan
138 ALL 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 X X X
Keyword AS not recognized in clause FROM
139 ALL 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 X X X
Incorrect results when left join on subquery with constant column
140 ALL 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 X X X
bad handling of /*/ comments in ISQL
141 ALL 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 X X X
context already in use (BLR error)
142 ALL 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 X X X
DISTINCT vs NULLS LAST clause: wrong order of NULLs
143 ALL 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 X X X
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
144 ALL 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 X X X
Restoring RDB$BASE_FIELD for expression
145 ALL 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 X X X
Local buffer overrun in DYN_error() that takes down the server
146 ALL 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 X X X
Provide mechanism to get engine version without needing to call API function
147 ALL 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 X X X
Make information available regading ODS Version and Dialect via SQL
148 ALL 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 X X X
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
149 CS 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 X X X
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
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 P P     E     X X X
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
151 ALL 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 X X X
like doesn't work for computed values (at least in a view)
152 ALL 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 X X X
extend retutnning support added in ver 2 in update record of table and in updateble view
153 ALL 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 X X X
Wrong single-segment ascending index on character field with NULL and empty string values
154 ALL 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 X X X
Wrong parameter matching for self-referenced procedures
155 ALL 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 X X X
A query could produce different results, depending on the presence of an index
156 ALL 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 X X X
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
157 ALL 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 X X X
Server hangs eating CPU and performs huge I/O copying different codepage fields
158 ALL 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 X X X
SINGULAR buggy when nulls present
159 CS 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 X X X
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
160 SS 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 X X X
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
161 CS 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 X X X
View with equally named source fields not faisible
162 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
View with equally named source fields not faisible
163 ALL 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 X X X
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
164 ALL 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 X X X
Wrong ordering with views, distinct, left join and order by
165 ALL 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 X X X
Error msg "Could not find UNIQUE INDEX" when in fact one is present
166 ALL 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 X X X
Support BETWEEN predicate for select expressions
167 CS 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 X X X
Wrong results with GROUP BY on constants
168 SS 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     X X X
Wrong results with GROUP BY on constants
169 ALL 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 X X X
Crash when dealing with a string literal longer than 32K
170 ALL 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 X X X
Remove or extend limit of command text length (64K)
171 CS 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 X X X
Conversion from string to number is not standard compliant
172 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
Conversion from string to number is not standard compliant
173 ALL 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 X X X
Recursive Query bug in FB2.1
174 ALL 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 X X X
UNION vs UTF8 literals : arithmetic exception is thrown
175 ALL 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 X X X
Bad optimization -- <procedure> left join <subquery> (or <view>)
176 ALL 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 X X X
Cannot alter generator's comment to the same value
177 ALL 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 X X X
Server locks up while attempting to commit a deletion of an expression index
178 ALL 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 X X X
AV in rse\invalidate_child_rpbs for recursive queies
179 CS 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 X X X
Every user can view server log using services API
180 SS 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 X X X
Every user can view server log using services API
181 ALL 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 X X X
Error conversion error from string " " using outer join on int64 and int fields
182 ALL 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 X X X
cannot erase a table with check constraints referencing more than a single columns
183 ALL 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 X X X
Activating index change "STARTING" working as "LIKE" in join condition
184 ALL 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 X X X
Prepare fails when having a parameter in a DSQL statement before a sub query
185 ALL 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 X X X
Problem altering numeric field type
186 CS 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 X X X
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
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 P P     E     X X X
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
188 ALL 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 X X X
CHARACTER SET GBK is not installed
189 ALL 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 X X X
isql exponential format of numbers has zero pad on windows
190 ALL 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 X X X
Symbols ignored for ES_ES_CI_AI collation
191 ALL 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 X X X
Expression index based on computed fields
192 ALL 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 X X X
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
193 ALL 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 X X X
"CH" and "LL" are not separate spanish alphabet letters since 1994
194 ALL 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 X X X
Union returns inconsistent field names
195 ALL 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 X X X
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
196 ALL 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 X X X
Select Starting with :Param (Empty string) doesn't work if using index with many fields
197 ALL 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 X X X
Long SQL statements break TCP/IP connection
198 CS 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 X X X
CURRENT OF support views
199 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
CURRENT OF support views
200 ALL 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 X X X
Wrong SELECT query results using index to evaluate >= condition
201 ALL 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 X X X
LIST() function seems not work if used twice or more in a query
202 ALL 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 X X X
Server crash on select * from <recursive CTE>
203 ALL 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 X X X
Incorrect column values with outer joins and views
204 ALL 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 X X X
Incorrect column values with outer joins and derived tables
205 CS P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
Incorrect timestamp arithmetic when one of operands is negative number
206 SS P P P P P P P P P P P P P P P P P P P P P P P P X X P X X X
Incorrect timestamp arithmetic when one of operands is negative number
207 CS 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 X X X
Full shutdown mode doesn't work on Classic if there are other connections to the database
208 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
Full shutdown mode doesn't work on Classic if there are other connections to the database
209 ALL 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 X X X
LIST(DISTINCT) concatenate VARCHAR values as CHAR
210 ALL 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 X X X
Problem with DISTINCT and insensitive collations
211 ALL 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 X X X
String truncation error when concatenating _UTF8 string onto extract(year result
212 ALL 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 X X X
Table columns hide destination variables of RETURNING INTO
213 ALL 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 X X X
GSec incorrectly processes some switches
214 ALL 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 X X X
Small bug with default value for domains in PSQL
215 ALL 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 X X X
Ceation of invalid procedures/triggers allowed
216 ALL 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 X X X
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
217 ALL 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 X X X
Bug with COMPUTED BY fields
218 ALL 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 X X X
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
219 ALL 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 X X X
Can't create table using long username and UTF8 as attachment charset
220 CS 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 X X X
Bad optimization of queries with DB_KEY
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 P P     E     X X X
Bad optimization of queries with DB_KEY
222 ALL 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 X X X
Indices not used for views
223 ALL 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 X X X
A remote attacker can check, if a file is present in the system, running firebird server
224 ALL 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 X X X
RDB$DB_KEY not supported in derived tables and merge command
225 ALL 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 X X X
Data type unknown
226 ALL 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 X X X
NOT NULL constraint for procedure parameters and variables
227 ALL 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 X X X
Error "Identifier ... is too long using multiple (nested) derived tables
228 ALL 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 X X X
size of alias name in a table
229 ALL 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 X X X
Charset transliterations don't work with EXECUTE STATEMENT
230 ALL 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 X X X
Joins with NULL RDB$DB_KEY crash the server
231 ALL 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 X X X
Problem with view , computed field and functions
232 ALL 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 X X X
Bug with a simple case and a subquery
233 ALL 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 X X X
lpad and rpad with two columns not working
234 CS P P P P P P P P P P P P P P P P P P P P P P P P X     E     P X X X
Unexpected "cannot transliterate" error
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 X     E     P X X X
Unexpected "cannot transliterate" error
236 ALL 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 X X X
TYPE OF COLUMN in PSQL
237 ALL 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 X X X
Index operations for global temporary tables are not visible for the active connection
238 ALL 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 X X X
Too large numbers cause positive infinity to be inserted into database
239 ALL 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 X X X
ISQL crash when converted-from-double string longer than 23 bytes
240 CS 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 X X X
French insensitive collation FR_FR_CI_AI
241 SS 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 X X X
French insensitive collation FR_FR_CI_AI
242 ALL 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 X X X
Execute block fails within execute statement
243 ALL 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 X X X
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
244 ALL 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 X X X
Add an ability to change role without reconnecting to database.
245 CS P P P P P P P P P P P P P P P P P P P P P P P P X     F     P X X X
Domain names and charset issues
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 X     F     P X X X
Domain names and charset issues
247 ALL 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 X X X
Invalid parameter type when using it in CHAR_LENGTH function
248 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
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 P     F     P X X X
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
250 ALL 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 X X X
Generated columns
251 ALL 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 X X X
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read
252 ALL 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 X X X
Few problems with domains's check constraints
253 ALL 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 X X X
Global temporary table instance may pick up not all indices
254 ALL 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 X X X
CREATE VIEW without column list when UNION is used
255 ALL 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 X X X
Support for autonomous transactions
256 ALL 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 X X X
Wrong current timestamp evaluation for selectable procedures
257 ALL 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 X X X
Incorrect timestamp substraction in 3 dialect when result is negative number
258 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Greek characters in cp1251 vs uppercasing
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 P     F     P X X X
Greek characters in cp1251 vs uppercasing
260 ALL 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 X X X
Collation not propagated between record formats
261 ALL 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 X X X
Incorrect result with EXECUTE STATEMENT and VARCHAR columns
262 ALL 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 X X X
Outer joins don't work properly with the MON$ tables
263 ALL 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 X X X
Execute statement 'select ....' into new....
264 ALL 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 X X X
Using RDB$DB_KEY in where section while selecting from a procedure crashes the server
265 CS 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 X X X
Allow usage of functions in LIST delimiter parameter
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 P P     E     X X X
Allow usage of functions in LIST delimiter parameter
267 ALL 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 X X X
ALTER mechanism for computed fields
268 ALL 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 X X X
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query
269 ALL 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 X X X
Make optimizer to consider ORDER BY optimization when making decision about join order
270 ALL 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 X X X
DATEADD wrong work with NULL arguments
271 ALL 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 X X X
BLOB isn't compatible with [VAR]CHAR in COALESCE
272 ALL 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 X X X
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
273 CS P P P P P P P P P P P     F     P P P P P P P P P P P P P P     F     X X X
Server crash with isc_dsql_execute_immediate and zero length string
274 SS P P P P P P P P P P P     F     P     E     P P P P P P P P P P P P     E     X X X
Server crash with isc_dsql_execute_immediate and zero length string
275 ALL 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 X X X
Conversion from double to varchar insert trailing spaces
276 ALL 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 X X X
Bad XSQLVAR [NULL flags] for (2*COALESCE(NULL,NULL))
277 ALL 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 X X X
POSITION(string_exp1, string_exp2 [, start])
278 ALL 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 X X X
Connection lost running script
279 ALL 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 X X X
Many new 2.1 built in functions have incorrect NULL semantics
280 ALL 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 X X X
Adding a non-null restricted column to a populated table renders the table inconsistent
281 ALL 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 X X X
Inconsistent DATEDIFF behaviour
282 ALL 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 X X X
Computed field + index not working in WHERE
283 ALL 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 X X X
Functions DATEDIFF does not work in dialect 1
284 ALL 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 X X X
JOIN on first record of ordered derived table returns wrong record
285 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
286 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
287 CS P P P P P P P P P P P P P P P P P P P P P S S S S S P X X X
RDB$procedures generator overflow
288 SS P P P P P P P P P P P P P P P P P P P P P S S S S S     E     X X X
RDB$procedures generator overflow
289 ALL 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 X X X
Subquery-based predicates are not evaluated early in the join order
290 ALL 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 X X X
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
291 ALL 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 X X X
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
292 ALL 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 X X X
AV when all statements are cancelled
293 ALL 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 X X X
select ... where ... <> ALL (select ... join ...) bug
294 ALL 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 X X X
'select ...from...where...not in (select...from...)' no results
295 ALL 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 X X X
Dropping NOT NULL contranint doesn'have the desired effect
296 ALL 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 X X X
NULLIF crashes when first parameter is constant empty string
297 ALL 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 X X X
Multiple Rows in Singleton Select not reported in a View
298 CS 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 X X X
ABS() rounds NUMERIC values
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 P P     E     X X X
ABS() rounds NUMERIC values
300 ALL 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 X X X
Server crashed or bugcheck when inserting in monitoring tables.
301 ALL 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 X X X
Bugcheck 232 (invalid operation) for an aggregated query
302 ALL 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 X X X
Ability to insert child record if parent record is locked but foreign key target unchanged
303 ALL 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 X X X
Correlated subquery is optimized badly if it depends on the union stream
304 ALL 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 X X X
PSQL output parameter size limited
305 ALL 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 X X X
Some aggregate functions does NOT support NULL-constant in 3-d dialect
306 ALL 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 X X X
Incorrect error message (column number) if the empty SQL string is prepared
307 ALL 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 X X X
MERGE not correctly worked with parameters in MATCHING clause
308 ALL 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 X X X
Create or Alter view
309 ALL 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 X X X
Non-privileged monitoring reports wrong attachment data
310 ALL 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 X X X
AV when recursive query used MERGE JOIN in execution plan
311 ALL 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 X X X
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
312 ALL 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 X X X
Ability to format UUID from char(16) OCTETS to human readable form and vice versa
313 ALL 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 X X X
Floor & ceiling functions give wrong results with exact numeric arguments
314 ALL 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 X X X
'There are <n> dependencies' error message shows the wrong count of dependent objects.
315 ALL 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 X X X
arithmetic exception, numeric overflow, or string truncation in utf8 tables
316 CS 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 X X X
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
317 SS 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     X X X
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
318 ALL 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 X X X
Bug in create/alter Database trigger (with Russian comment)
319 ALL 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 X X X
Buffer overflow in conversion
320 ALL 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 X X X
Incorrect "key size exceeds implementation restriction for index" error
321 ALL 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 X X X
Wrong variable initialization in recursive procedures
322 ALL 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 X X X
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
323 CS 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 X X X
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
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 P     E     P X X X
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
325 ALL 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 X X X
Bug in SET DEFAULT statement
326 CS 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 X X X
Expression index can be created while doing inserts into table
327 SS 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 X X X
Expression index can be created while doing inserts into table
328 ALL 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 X X X
DDL statement with AUTODDL ON won't show statistics
329 ALL 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 X X X
Include information about context variables into the monitoring tables
330 ALL 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 X X X
Results of a join with different collations depend on the execution plan
331 CS 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 X X X
Support hex numeric and string literals
332 SS 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 X X X
Support hex numeric and string literals
333 ALL 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 X X X
Problem with COLLATE ES_ES_CI_AI
334 ALL 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 X X X
ISQL crashes when fetching data for a column having alias longer than 30 characters
335 ALL 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 X X X
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
336 ALL 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 X X X
Consistency check when subquery is ordered by aggregate function from other context
337 ALL 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 X X X
AV at prepare of query with unused parametrized CTE
338 ALL 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 X X X
Server crashes on SQL script
339 ALL 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 X X X
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers
340 ALL 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 X X X
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING
341 CS 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 X X X
Maximum key size using PXW_CSY collation
342 SS 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     X X X
Maximum key size using PXW_CSY collation
343 ALL 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 X X X
Usernames with '.' character
344 ALL 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 X X X
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
345 ALL 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 X X X
Index is not used for some date/time expressions in dialect 1
346 CS 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 X X X
Error with ABS in dialect 1
347 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Error with ABS in dialect 1
348 ALL 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 X X X
Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints
349 ALL 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 X X X
Procedure text is stored truncated in system tables if any variable have default value
350 ALL 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 X X X
AV when sorting by field, calculated using recursive CTE
351 ALL 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 X X X
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
352 ALL 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 X X X
DEFAULT values are unnecessary evaluated
353 CS 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 X X X
Some standard calls show server installation directory to regular users
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 P     E     P X X X
Some standard calls show server installation directory to regular users
355 ALL 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 X X X
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
356 ALL 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 X X X
Arithmetic overflow or division by zero has occurred. in MAX function
357 CS 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 X X X
BLR error on restore database with computed by Field
358 SS 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 X X X
BLR error on restore database with computed by Field
359 ALL 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 X X X
Roles granting/revoking logic
360 ALL 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 X X X
Error on script with current_date
361 CS P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P X X X
CREATE COLLATION connection lost under Posix
362 SS P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P X X X
CREATE COLLATION connection lost under Posix
363 ALL 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 X X X
SHOW VIEW shows non-sense information for view fields with expressions
364 CS 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 X X X
Circular dependencies between computed fields crashs the engine
365 SS 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     X X X
Circular dependencies between computed fields crashs the engine
366 ALL 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 X X X
Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies
367 ALL 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 X X X
Not valid fields in MERGE's insert clause are allowed
368 ALL 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 X X X
MON$DATABASE returns outdated transaction counters
369 CS 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 X X X
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
370 SS P P P P P P P P P P P P P P P P P P P P P P P P     E         E     P X X X
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
371 ALL 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 X X X
SIMILAR TO character classes are incorrectly recognized
372 ALL 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 X X X
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.
373 ALL 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 X X X
GROUP BY RAND() returns infinite rows
374 ALL 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 X X X
Custom attribute for collation to sort numbers in numeric order
375 ALL 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 X X X
Bugcheck 291
376 ALL 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 X X X
Incorrect extraction of MILLISECONDs
377 ALL 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 X X X
Set the fixed and documented check order for WHERE clause and other conditional sentences
378 ALL 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 X X X
Non-SYSDBA user can change FW mode of database.
379 ALL 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 X X X
Altering domains name drops dependencies using the domain
380 ALL 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 X X X
UTF8 UNICODE_CI collate can?t be used in foreing key constraint
381 CS 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 X X X
bad BLR -- invalid stream for union select
382 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
bad BLR -- invalid stream for union select
383 ALL 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 X X X
Broken foreign key handling for multi-segmented index using multi-level collations
384 ALL P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
TimeStamp in the every line output gbak.exe utility
385 ALL 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 X X X
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
386 CS 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 X X X
ALTER USER XXX INACTIVE
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 P     E     P X X X
ALTER USER XXX INACTIVE
388 ALL 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 X X X
Support SQL 2008 syntax for MERGE statement with DELETE extension
389 ALL 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 X X X
SUBSTRING with regular expression (SIMILAR TO) capability
390 ALL 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 X X X
NOT NULL procedure parameters
391 ALL 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 X X X
I/O statistics for stored procedures are not accounted in monitoring tables
392 ALL 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 X X X
Only one client can access a readonly database
393 ALL 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 X X X
UTF-8 conversion error (string truncation)
394 ALL 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 X X X
"EXECUTE BLOCK" statement does not support "CREATE USER"
395 ALL 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 X X X
Problem with a read-only marked database
396 ALL 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 X X X
Incorrect buffer size for ORDER BY expression with system fields
397 CS 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 X X X
Null in the first record in a condition on rdb$db_key
398 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
Null in the first record in a condition on rdb$db_key
399 CS 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 X     F     X X X
Stored procedure recursively called by calculated field fails after reconnect
400 SS 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 X     F     X X X
Stored procedure recursively called by calculated field fails after reconnect
401 ALL 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 X X X
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
402 ALL 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 X X X
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
403 ALL 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 X X X
Domain-level CHECK constraints wrongly process NULL values
404 ALL 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 X X X
update or insert with gen_id() with wrong generator value
405 ALL 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 X X X
connection lost to database when used AUTONOMOUS TRANSACTION
406 ALL 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 X X X
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
407 ALL 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 X X X
don't work subquery in COALESCE
408 ALL 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 X X X
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement
409 ALL 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 X X X
ALTER VIEW WITH CHECK OPTION crashes the engin
410 ALL 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 X X X
GROUP by and RDB$DB_KEY problems
411 ALL 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 X X X
Comparision with IN and subquery with RDB$DB_KEY returns wrong result
412 ALL 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 X X X
Incorrect VIEW expansion when RDB$DB_KEY is used in view body
413 CS 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 X X X
Expression indexes bug: incorrect result for the inverted boolean
414 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Expression indexes bug: incorrect result for the inverted boolean
415 ALL 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 X X X
Parts of RDB$DB_KEY of views may be inverted when using outer joins
416 ALL 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 X X X
Suboptimal join plan if there are selective non-indexed predicates involved
417 ALL 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 X X X
RDB$DB_KEY in subselect expression incorrectly returns NULL
418 ALL 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 X X X
View over global temporary table
419 ALL 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 X X X
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
420 CS 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 X X X
Query plan is missing for the long query
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 P     E     P X X X
Query plan is missing for the long query
422 ALL 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 X X X
Incorrect ROW_COUNT value with indexed retrieval and subquery
423 ALL 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 X X X
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
424 ALL 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 X X X
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
425 ALL 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 X X X
Error messages after parameters substitution contains '8' characters instead of line break
426 ALL 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 X X X
SIMILAR TO predicate hangs with "|" option
427 ALL 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 X X X
Join of SP with view or table may fail with "No current record for fetch operation"
428 ALL 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 X X X
error in operator "and" in as clausule where
429 CS 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 X X X
Unexpected (wrong) results with COALESCE and GROUP BY
430 SS 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     X X X
Unexpected (wrong) results with COALESCE and GROUP BY
431 CS 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 X X X
Add support for -nodbtriggers switch in gbak into services API
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 P     E     P X X X
Add support for -nodbtriggers switch in gbak into services API
433 ALL 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 X X X
Extremely slow executing a cross join of 3 tables in Firebird 2.X
434 ALL 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 X X X
RDB$VIEW_RELATIONS is not cleaned when altering a view
435 ALL 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 X X X
constraints on sp output parameters are checked even when the sp returns zero rows
436 CS 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 X X X
New gbak option to ignore specific tables data during the backup
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 P     E     P X X X
New gbak option to ignore specific tables data during the backup
438 CS 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 X X X
Offset value for SUBSTRING from BLOB more than 32767 makes exception
439 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
Offset value for SUBSTRING from BLOB more than 32767 makes exception
440 CS 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 X X X
GROUP BY concatenation with empty string
441 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
GROUP BY concatenation with empty string
442 CS 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 X X X
Problem with column names with Accents and triggers
443 SS 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 X X X
Problem with column names with Accents and triggers
444 ALL 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 X X X
Implement domain check of input parameters of execute block
445 ALL 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 X X X
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
446 ALL 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 X X X
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
447 CS 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 X X X
gbak doesn't return error code
448 SS 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 X X X
gbak doesn't return error code
449 ALL 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 X X X
EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction
450 ALL 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 X X X
'...exception...string right truncation' when alter view with join
451 ALL 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 X X X
internal Firebird consistency check when alter dependent procedures
452 CS 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 X X X
internal error when select upper(<blob>) from union
453 SS 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     X X X
internal error when select upper(<blob>) from union
454 ALL 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 X X X
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults
455 ALL 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 X X X
Grouping by function doesn't work properly
456 ALL 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 X X X
GFIX causes BUGCHECK errors with non valid transaction numbers
457 ALL 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 X X X
Records left in RDB$PAGES after rollback of CREATE TABLE statement
458 ALL 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 X X X
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
459 ALL 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 X X X
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
460 ALL 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 X X X
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's
461 ALL 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 X X X
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time
462 ALL 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 X X X
Include PLAN in mon$statements
463 ALL 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 X X X
Make mon$statement_id value constant among monitoring snapshots
464 CS 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 X X X
Incomplete API information values
465 SS 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 X X X
Incomplete API information values
466 ALL 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 X X X
SIMILAR TO produces random results with [x-y] expressions
467 ALL 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 X X X
Firebird float support does not conform to Interbase spec
468 ALL 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 X X X
select * from (select cast(.... returns null
469 CS 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 X X X
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE
470 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE
471 ALL 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 X X X
Incorrect result for the derived expression based on aggregate and computation
472 ALL 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 X X X
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
473 ALL 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 X X X
Too long column name for select alias should be rejected
474 ALL 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 X X X
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
475 ALL 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 X X X
Logical multibyte maximum string length is not respected when assigning numbers
476 ALL 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 X X X
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
477 ALL 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 X X X
ALTER TRIGGER / PROCEDURE wrong error message
478 ALL 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 X X X
ALTER VIEW could remove column used in stored procedure or trigger
479 ALL 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 X X X
Wrong matching of SIMILAR TO expression with brackets
480 ALL 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 X X X
If you drop two different indexes within the same transaction, you get database corruption
481 CS 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 X X X
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
482 SS 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 X X X
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
483 ALL 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 X X X
AV preparing a query with aggregate over derived table
484 ALL 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 X X X
Parsing error in EXECUTE STATEMENT with named parameters
485 ALL 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 X X X
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
486 ALL 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 X X X
Alter table not respecting collation
487 ALL 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 X X X
ALTER VIEW doesn't clear dependencies on old views
488 ALL 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 X X X
Server adds "NOT" at the end of default value for the TIMESTAMP field
489 ALL 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 X X X
String values in error messages are not converted to connection charset
490 ALL 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 X X X
CREATE USER command: Invalid error message
491 ALL 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 X X X
Server crashes on UPDATE OR INSERT statement
492 ALL 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 X X X
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.
493 ALL 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 X X X
Server fails when doing DROP DATABASE right after error in statistical fnction
494 ALL 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 X X X
UNICODE_CI internal gds software consistency check
495 CS 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 X X X
External table data not visible to other sessions in Classic
496 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
External table data not visible to other sessions in Classic
497 CS 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 X X X
mon$memory_usage: Sorting memory should be reported as owned by the statement
498 SS 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 X X X
mon$memory_usage: Sorting memory should be reported as owned by the statement
499 CS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
Success message when connecting to tiny trash database file
500 SS P P P P P P P P P P P P P P P P P P P P P P P P P P     F     X X X
Success message when connecting to tiny trash database file
501 CS X X X X X X X X X X X X X X X X X X X X X X X X X     E     X X X X
Append the IP address of the remote host to error messages in firebird.log for TCP connections
502 SS X X X X X X X X X X X X X X X X X X X X X X X X X     E     X X X X
Append the IP address of the remote host to error messages in firebird.log for TCP connections
503 ALL 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 X X X
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
504 ALL 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 X X X
Binary shift functions give wrong results with negative shift values
505 ALL 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 X X X
Built-in trigonometric functions can produce NaN and Infinity
506 ALL 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 X X X
Tricky index names can defeat the parsing logic when generating a human readable plan
507 ALL 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 X X X
Wrong processing a SP parameters with arrays
508 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
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 P     F     P X X X
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
510 ALL 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 X X X
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
511 ALL 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 X X X
CI column does not group correctly with a second column
512 ALL 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 X X X
Maximum and minimum identifier length should be enforced by DSQL
513 ALL 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 X X X
internal error [335544384]
514 ALL 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 X X X
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
515 ALL 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 X X X
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
516 ALL 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 X X X
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
517 ALL 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 X X X
Infinity should not escape from the engine
518 ALL 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 X X X
Infinity from UDF should be trapped by the engine
519 ALL 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 X X X
Wrong results for CASE used together with GROUP BY
520 ALL 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 X X X
Attachments using NONE charset may cause reads from MON$ tables to fail
521 ALL 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 X X X
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
522 ALL 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 X X X
Introducer (_charset) problems with monitoring and persistent modules
523 ALL 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 X X X
Connection lost immediatelly after compiling procedure with RPAD system function
524 ALL 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 X X X
Silent truncation when using utf8 parameters and utf8 client character set encoding
525 ALL 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 X X X
Invalid BLOB ID when working with monitoring tables
526 ALL 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 X X X
SELECT WITH LOCK with no fields are accessed clears the data
527 ALL 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 X X X
Unique index with a lot of NULL keys can be corrupted at level 1
528 ALL 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 X X X
Incorrect "string right truncation" error with NONE column and multibyte connection charset
529 CS 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 X X X
COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match
530 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match
531 CS 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 X X X
Write note into log when automatic sweep is started
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 P     E     P X X X
Write note into log when automatic sweep is started
533 ALL 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 X X X
Full outer join cannot use available indices (very slow execution)
534 ALL 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 X X X
System triggers on view with check option are not removed
535 ALL 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 X X X
Support the "? in (SELECT some_col FROM some_table)" subqueries
536 ALL 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 X X X
Common table expression context could be used with parameters
537 ALL 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 X X X
Do not print "invalid request BLR" for par.cpp errors with valid BLR
538 ALL 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 X X X
Wrong evaluation result with divide and unary plus\minus operations
539 ALL 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 X X X
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
540 ALL 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 X X X
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
541 CS 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 X X X
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
542 SS 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 X X X
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
543 ALL 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 X X X
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
544 ALL 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 X X X
Recursive EXECUTE STATEMENT works wrong
545 ALL 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 X X X
isql hangs when trying to show a view based on a procedure
546 ALL 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 X X X
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
547 ALL 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 X X X
SIMILAR TO works wrongly
548 ALL 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 X X X
substring from timestamp - unexpected result
549 ALL 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 X X X
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
550 ALL 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 X X X
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
551 ALL 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 X X X
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
552 CS 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 X X X
Include client library version and protocol version in mon$attachments
553 SS 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     X X X
Include client library version and protocol version in mon$attachments
554 CS 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 X X X
AV using recursive query as subquery in SELECT list and ORDER'ing by them
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 P P     E     X X X
AV using recursive query as subquery in SELECT list and ORDER'ing by them
556 ALL 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 X X X
Make rdb$system_flag not null
557 CS 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 X X X
isql extracts the array dimensions after the character set name
558 SS 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 X X X
isql extracts the array dimensions after the character set name
559 ALL 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 X X X
DB_KEY is always zero for external tables
560 ALL 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 X X X
Problem with default value of SP parameter
561 ALL 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 X X X
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
562 ALL 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 X X X
Changing sort directon in delete statement cause deletion of all records in table
563 ALL 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 X X X
Problems with COMMENT ON and strings using introducer (charset)
564 ALL 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 X X X
Views based on procedures can't be created if the proc's output fields participate in an expression
565 ALL 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 X X X
Unsuccessful execution' error when updating a record
566 ALL 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 X X X
Prohibit any improper mixture of explicit and implicit joins
567 ALL 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 X X X
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time
568 ALL 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 X X X
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
569 ALL 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 X X X
Join condition fails for UTF-8 databases.
570 ALL 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 X X X
isql shouldn't display db and user name when extracting a script
571 ALL 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 X X X
Changing data that affects an expression index that contains references to null date fields fails
572 ALL 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 X X X
Natural is used to select instead of primary key index
573 CS 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 X X X
Cannot remove user with dot in login
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 P     E     P X X X
Cannot remove user with dot in login
575 ALL 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 X X X
View created from JOIN and LEFT JOIN doesnt order
576 ALL 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 X X X
Outer ORDER BY clause has no effect
577 ALL 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 X X X
EVL_expr: invalid operation (232)
578 ALL 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 X X X
String right truncation error when char column longer than 4096 bytes compared with string constant
579 CS 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 X X X
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
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 P     E     P X X X
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
581 ALL 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 X X X
isql should show packaged procedures and functions categorized per package
582 ALL 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 X X X
Query with "NOT IN <subselect from view>" fails
583 ALL 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 X X X
A memory corruption cause incorrect query evaluation and may crash the server
584 ALL 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 X X X
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
585 ALL 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 X X X
Expression in a subquery may be treated as invariant and produce incorrect results
586 ALL 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 X X X
Don't send full length of field over the wire when field is null
587 ALL 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 X X X
Unable to catch exceptions that are thrown inside a dynamic builded execute block.
588 ALL 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 X X X
PK index is not used for derived tables
589 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
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 P     F         E     X X X
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
591 ALL 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 X X X
COLLATE expressions are applied incorrectly
592 ALL 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 X X X
Broken error handling in the case of a conversion error happened during index creation
593 ALL 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 X X X
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
594 ALL 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 X X X
Character set used in constants is not registered as dependency
595 ALL 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 X X X
Problem with dependencies between a procedure and a view using that procedure
596 ALL 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 X X X
"Invalid ESCAPE sequence" when connecting to the database
597 ALL 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 X X X
DROP VIEW drops output parameters of used stored procedures
598 ALL 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 X X X
Wrong field position after ALTER POSITION
599 CS 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 X X X
Trace output could contain garbage data left from filtered out statements
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 P     E     P X X X
Trace output could contain garbage data left from filtered out statements
601 ALL 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 X X X
parsing error recursive query with two recursive parts
602 CS 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 X X X
Case-sensitive character class names in SIMILAR TO
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 P P     E     X X X
Case-sensitive character class names in SIMILAR TO
604 ALL 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 X X X
count(*) from big table returns negative result
605 ALL 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 X X X
Incorrect ROW_COUNT value after SINGULAR condition
606 ALL S S S S S S S S S S S S S S S S S S S S S S S S S S S X X X
Wrong results or unexpected errors while sorting a large data set
607 ALL 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 X X X
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
608 ALL 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 X X X
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
609 ALL 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 X X X
Unexpected "Invalid SIMILAR TO pattern" error
610 CS P P P P P P P P P P P P P P P P P P P P P P     F     P P P     F     X X X
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
611 SS P P P P P P P P P P P P P P P P P P P P P P     F     P P P     F     X X X
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
612 CS 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 X X X
Error in Trace plugin (use local symbols in query)
613 SS 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 X X X
Error in Trace plugin (use local symbols in query)
614 ALL 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 X X X
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
615 CS 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 X X X
Concurrent transaction number not reported if lock timeout occurs
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         E     P X X X
Concurrent transaction number not reported if lock timeout occurs
617 ALL 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 X X X
Error on delete user "ADMIN"
618 ALL 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 X X X
Procedure suspend check may cause restore to fail
619 CS 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 X X X
Add attachment's CHARACTER SET name into corresponding trace records
620 SS 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 X X X
Add attachment's CHARACTER SET name into corresponding trace records
621 ALL 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 X X X
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
622 ALL 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 X X X
Error "no current record for fetch operation" after ALTER VIEW
623 ALL 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 X X X
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
624 ALL 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 X X X
Wrong resultset
625 ALL 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 X X X
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
626 ALL 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 X X X
Wrong logic is used to resolve EXECUTE BLOCK parameters collations
627 CS 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 X X X
Wrong resultset
628 SS 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     X X X
Wrong resultset
629 ALL 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 X X X
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
630 ALL 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 X X X
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
631 ALL 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 X X X
Allow the usage of blobs in COMPUTED BY expressions
632 ALL P P P P P P P P P P P P P P P P P P P P P S S S S S P X X X
New generators are created with wrong value when more than 32K generators was previously created
633 ALL 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 X X X
Using both the procedure name and alias inside an explicit plan crashes the server
634 ALL 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 X X X
Better performance for (table.field = :param or :param = -1) in where clause
635 ALL 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 X X X
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
636 ALL 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 X X X
Incorrect LEFT JOIN result using table and derived constant subquery
637 ALL 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 X X X
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
638 ALL 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 X X X
ROW_COUNT is not cleared before the singleton INSERT statement
639 ALL 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 X X X
Parameters doesn't work with NOT IN from a selectable procedure
640 ALL 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 X X X
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
641 ALL 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 X X X
Updating blob field cause server crash with ACCESS_VIOLATION exception
642 ALL 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 X X X
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
643 ALL 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 X X X
Cannot alter the domain after migrating from older versions
644 ALL 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 X X X
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
645 CS P P P P P P P P P P P P P P P P P P P P P P P P X     E     P X X X
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
646 SS P P P P P P P P P P P P P P P P P P P P P P P P X     E     P X X X
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
647 ALL 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 X X X
Partial rollback is possible for a selectable procedure modifying data
648 ALL 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 X X X
Preserve comments for parameters after altering procedures
649 ALL 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 X X X
The last column in a view is returning as a null value even when it's not
650 ALL 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 X X X
Parameterized requests involving blob fields fails when connected using charset UTF8
651 ALL P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
exclude_filter doesn't work for <services></section> section of the Trace facility
652 ALL 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 X X X
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join
653 ALL 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 X X X
Expression index with TRIM may lead to incorrect indexed lookup
654 ALL 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 X X X
View with "subselect" column join table and not use index
655 ALL 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 X X X
ALTER VIEW with not matched columns in declaration and selection crashs the server
656 CS 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 X X X
page 0 is of wrong type (expected 6, found 1)
657 SS 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 X X X
page 0 is of wrong type (expected 6, found 1)
658 ALL 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 X X X
ATAN2 returns incorrect value for (0, 0)
659 ALL 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 X X X
Constraint violation error of CAST is not raised inside views
660 ALL 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 X X X
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
661 ALL 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 X X X
String truncation occurs when selecting from a view containing NOT IN inside
662 ALL 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 X X X
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
663 CS 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 X X X
ASCII_VAL() fails if argument contains multi-byte character anywhere
664 SS 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     X X X
ASCII_VAL() fails if argument contains multi-byte character anywhere
665 ALL 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 X X X
RIGHT() fails with multibyte text blobs > 1024 chars
666 ALL 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 X X X
OVERLAY() fails when used with text BLOBs containing multi-byte chars
667 ALL 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 X X X
LIKE, STARTING and CONTAINING fail if second operand >= 32K
668 ALL 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 X X X
Support for text BLOBs >= 32K as first argument for TRIM()
669 ALL 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 X X X
Makes GEN_UUID return a compliant RFC-4122 UUID
670 ALL 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 X X X
UTF8 UNICODE_CI collate can not be used in compound index
671 ALL 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 X X X
Recursive stored procedure shouldnt require execute right to call itself
672 ALL 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 X X X
POSITION: Wrong result with '' if third argument present
673 ALL 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 X X X
SUBSTRING on long blobs truncates result to 32767 if third argument not present
674 ALL 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 X X X
The server could crash using views with GROUP BY
675 ALL 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 X X X
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
676 ALL 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 X X X
LIST() may overwrite last part of output with zero characters
677 ALL 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 X X X
Wrong result for RIGHT(UTF8 varchar)
678 ALL 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 X X X
EXECUTE STATEMENT parses the SQL text using wrong charset
679 ALL 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 X X X
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
680 ALL 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 X X X
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
681 ALL 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 X X X
Error "context already in use" for the simple case function with a sub-select operand
682 ALL 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 X X X
Distinct aggregates return wrong (duplicated) data
683 ALL 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 X X X
"BLOB not found" error after creation/altering of the invalid trigger
684 ALL 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 X X X
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
685 ALL 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 X X X
RDB$GET_CONTEXT and between in view
686 ALL 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 X X X
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
687 ALL 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 X X X
Sub-optimal join plan when the slave table depends on the master one via the OR predicate
688 ALL 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 X X X
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
689 CS P P P P P P P     F     P P P P P P P P P P P P P P P P P     E     P X X X
Ability to cancel waiting in lock manager
690 SS 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         E     X X X
Ability to cancel waiting in lock manager
691 CS 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 X X X
Client writes error messages into firebird.log when database is shutted down
692 SS 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 X X X
Client writes error messages into firebird.log when database is shutted down
693 CS 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 X X X
Server crashes while recreating the table with a NULL -> NOT NULL change
694 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
Server crashes while recreating the table with a NULL -> NOT NULL change
695 ALL 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 X X X
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
696 ALL 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 X X X
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
697 ALL 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 X X X
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)
698 ALL 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 X X X
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
699 CS 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 X X X
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB
700 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB
701 ALL 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 X X X
Wrong comparsion of DATE and TIMESTAMP if index is used
702 ALL 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 X X X
Generators are set to 0 after restore
703 ALL 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 X X X
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
704 ALL 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 X X X
Cursors should ignore changes made by the same statement
705 ALL 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 X X X
Cursors should ignore changes made by the same statement
706 ALL 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 X X X
Blob filter to translate internal debug info into text representation
707 CS 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 X X X
Extend syntax for ALTER USER CURRENT_USER
708 SS 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     X X X
Extend syntax for ALTER USER CURRENT_USER
709 ALL 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 X X X
It is possible to store string with lenght 31 chars into column varchar(25)
710 ALL 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 X X X
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
711 ALL 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 X X X
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
712 ALL 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 X X X
GRANT ADMIN ROLE not accepted
713 ALL 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 X X X
Allow write operations to temporary tables in read only transactions
714 ALL 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 X X X
Collation errors with [type of] <domain>, type of column
715 CS 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 X X X
Improve diagnostics of internal trace errors
716 SS 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 X X X
Improve diagnostics of internal trace errors
717 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Inserting K?se into a CHARACTER SET ASCII column succeeds
718 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Inserting K?se into a CHARACTER SET ASCII column succeeds
719 ALL 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 X X X
Database trigger created as INACTIVE is active
720 ALL 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 X X X
Recurse leads to hangs/crash server
721 ALL 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 X X X
BOOLEAN not present in system table RDB$TYPES
722 CS 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 X X X
[FB3] AV with "UPDATE OR INSERT"
723 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
[FB3] AV with "UPDATE OR INSERT"
724 ALL 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 X X X
[FB3] Wrong RDB$PARAMETER_MECHANISM
725 ALL 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 X X X
Server crashing with UTF8 blobs
726 ALL 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 X X X
ISQL pads UTF-8 data incorrectly
727 ALL 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 X X X
Allow conversion from/to BLOBs and others types in the API functions (XSQLVAR or blr messages)
728 ALL 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 X X X
Collation is not installed with icu > 4.2
729 ALL 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 X X X
Inefficient optimization (regression)
730 ALL 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 X X X
Added not null timestamp col with default causes error on select of old null records
731 ALL 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 X X X
DDL operations fail after backup/restore
732 ALL 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 X X X
Regression in joins on procedures
733 ALL 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 X X X
Parameters inside the CAST function are described as not nullable
734 ALL 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 X X X
LIST function wrongly concatenates binary blobs
735 ALL 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 X X X
ASCII_VAL raises error instead of return 0 for empty strings
736 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Blob transliteration may not happen inside the union
737 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Blob transliteration may not happen inside the union
738 CS 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 X X X
Concurrency problem when using named cursors
739 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Concurrency problem when using named cursors
740 ALL 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 X X X
Altering of a TYPE OF COLUMN parameter affects the original column
741 ALL 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 X X X
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
742 ALL 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 X X X
DROP VIEW ignores the existing non-column dependencies
743 ALL 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 X X X
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
744 ALL 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 X X X
Alter procedure allows to add the parameter with the same name
745 ALL P P P P P P P P P P P P P P P P P P P P P P X X X X P X X X
Unquoted role names with non-ASCII characters passed in DPB are upper-cased wrongly
746 ALL 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 X X X
Server crash with built in function LPAD with string as second parameter
747 ALL 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 X X X
SIMILAR TO: False matches on descending ranges
748 ALL 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 X X X
Support for WHEN SQLSTATE
749 ALL 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 X X X
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
750 CS 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 X X X
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
751 SS 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 X X X
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
752 ALL 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 X X X
Inconsistent domain's constraint validation in PSQL
753 ALL 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 X X X
Aliases for the RETURNING clause
754 ALL 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 X X X
Floating-point negative zero doesn't match positive zero in the index
755 ALL 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 X X X
GFIX returns an error after correctly shutting down a database
756 ALL 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 X X X
Database corruption after end of session : page xxx is of wrong type expected 4 found 7
757 ALL 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 X X X
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
758 CS P P P P P P P P P P P     F     P P P P     F     P     F         F     P P P     F     P P P X X X
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
759 SS 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 X X X
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
760 ALL 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 X X X
AV in engine when preparing query against dropping table
761 ALL 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 X X X
CHAR(32767) present in XSQLVAR with length 32765
762 ALL 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 X X X
Can not drop table when computed field depends on later created another field
763 ALL 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 X X X
Include expected and actual string lenght into error message for sqlcode -802
764 CS 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 X X X
TRACE: add statistics of actions that were after transaction finished
765 SS 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 X X X
TRACE: add statistics of actions that were after transaction finished
766 ALL 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 X X X
Possible drop role RDB$ADMIN
767 ALL 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 X X X
Incorrect TEXT BLOB charset transliteration on VIEW with trigger
768 ALL 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 X X X
Can insert DUPLICATE keys in UNIQUE index
769 CS 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 X X X
Wrong data while retrieving from CTEs (or derived tables) with same column names
770 SS 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     X X X
Wrong data while retrieving from CTEs (or derived tables) with same column names
771 CS 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 X X X
Plan returned for query with recursive CTE return wrong count of parenthesis
772 SS 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 X X X
Plan returned for query with recursive CTE return wrong count of parenthesis
773 ALL 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 X X X
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
774 ALL 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 X X X
Server crashes with access violation when inserting row into table with unique index
775 ALL 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 X X X
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
776 CS 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 X X X
recreation of collation for utf8 from unicode with option NUMERIC-SORT=1 leads to FB death
777 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P X X X
recreation of collation for utf8 from unicode with option NUMERIC-SORT=1 leads to FB death
778 CS 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 X X X
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
779 SS 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 X X X
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
780 ALL 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 X X X
computed index by substring function for long columns
781 ALL 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 X X X
CREATE INDEX considers NULL and empty string being the same in compound indices
782 ALL 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 X X X
Wrong results if the recursive query contains an embedded GROUP BY clause
783 ALL 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 X X X
Wrong warning message for ambiguous query
784 ALL 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 X X X
Wrong warning message for ambiguous query
785 ALL 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 X X X
Missing constraint name in foreign key error message in FB 2.1.4
786 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P P X X X
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
787 SS P P P P P P P P P P P P P P P P P P P     F         F     P P P P P     E     X X X
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
788 ALL 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 X X X
internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate
789 CS 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 X X X
String truncation error when selecting from a VIEW with UNION inside
790 SS 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     X X X
String truncation error when selecting from a VIEW with UNION inside
791 CS 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 X X X
IS NOT DISTINCT FROM NULL doesn't use index
792 SS 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     X X X
IS NOT DISTINCT FROM NULL doesn't use index
793 CS 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 X X X
Segfault when closing attachment to database
794 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P     E     P X X X
Segfault when closing attachment to database
795 ALL 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 X X X
GBAK fails to fix system generators while restoring
796 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
797 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
798 ALL 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 X X X
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
799 ALL 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 X X X
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
800 ALL 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 X X X
SELECT using IN list with 153 or more elements causes crash
801 ALL 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 X X X
The trigger together with the operator MERGE if in a condition of connection ON contains new is not compiled
802 ALL 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 X X X
SIMILAR TO works wrongly
803 ALL 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 X X X
Conversion error when using a blob as an argument for the EXCEPTION statement
804 ALL 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 X X X
Conversion error from string when using GROUP BY
805 ALL 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 X X X
Report OS user name in MON$ATTACHMENTS
806 ALL 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 X X X
fb server die when carry out the LEFT + INNER JOIN
807 ALL 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 X X X
with caller privileges option do not work with autonomous transaction option
808 ALL 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 X X X
Warnings could be put twice in status-vector
809 ALL 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 X X X
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
810 ALL 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 X X X
Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection
811 ALL 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 X X X
isql: zero divide + coredump when use "-pag 0" command switch & set heading on inside .sql script
812 ALL 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 X X X
RDB$TYPES contain duplicate character sets
813 ALL 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 X X X
Bad alias table choice joining CTE
814 ALL 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 X X X
Usage of a NATURAL JOIN with a derived table crashes the server
815 ALL 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 X X X
Trace API: Faulty database filter crashes server
816 ALL 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 X X X
Computed column appears in non-existant rows of left join
817 ALL 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 X X X
Extend the error reported for index/constraint violations to include the problematic key value
818 CS 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 X X X
Ambiguous field name in the trigger when it does a select from the table
819 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Ambiguous field name in the trigger when it does a select from the table
820 CS 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 X X X
Server crashes on preparing empty query when trace is enabled
821 SS 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 X X X
Server crashes on preparing empty query when trace is enabled
822 ALL 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 X X X
Wrong numbers in error message for decreasing char/varchar columns
823 ALL 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 X X X
High memory usage when PSQL code SELECT's from stored procedure which modified some data
824 ALL 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 X X X
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
825 ALL 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 X X X
Derived fields may not be optimized via an index
826 ALL 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 X X X
Bugcheck 291 (cannot find record back version) if GTT is modified concurrently using at least one read-committed read-only transaction
827 ALL 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 X X X
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
828 CS 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 X X X
Invalid "attempted update of read-only column" error when trying select minvalue from list with more than 255 elements
829 SS 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     X X X
Invalid "attempted update of read-only column" error when trying select minvalue from list with more than 255 elements
830 CS 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 X X X
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
831 SS 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 X X X
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
832 ALL 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 X X X
DeActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
833 ALL 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 X X X
Restore from gbak backup using service doesn't report an error
834 ALL 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 X X X
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
835 ALL 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 X X X
Repeat Temporary Table access from ReadOnly Transaction and ReadWrite transaction causes Internal Firebird consistency check (cannot find record back version (291), file: vio.cpp line: 4905)
836 ALL 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 X X X
isql doesn't know the difference between UDF's and psql-functions
837 ALL 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 X X X
It is not possible to create a ddl-trigger with "any DDL statement" clause
838 CS 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 X X X
Creating a procedure containing "case when" expression leads to a server crash
839 SS 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     X X X
Creating a procedure containing "case when" expression leads to a server crash
840 ALL 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 X X X
Creating a stored procedure with an "update or insert" statement with MATCHING fails
841 ALL 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 X X X
subselect with reference to outer select fails
842 CS 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 X X X
Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
843 SS 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     X X X
Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
844 ALL 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 X X X
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
845 CS 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 X X X
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
846 SS 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         E     X X X
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
847 ALL 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 X X X
"attempted update of read-only column" when trying update editable view without triggers
848 ALL 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 X X X
No records in the table rdb$dependencies for ddl trigger
849 ALL 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 X X X
Join using RDB$DB_KEY produce NATURAL plan
850 ALL 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 X X X
Parametrized execute statement fails
851 ALL 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 X X X
Bug in unique constraints and / or NUMERIC-SORT collation
852 ALL 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 X X X
Error message "index unexpectedly deleted" in database trigger on commit transaction
853 ALL 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 X X X
wrong error message with recursive CTE
854 ALL 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 X X X
using a result from a procedure in a substring expression leads to server crash
855 ALL 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 X X X
Using system domain in procedures arguments/returns cause the proc to be unchangeable
856 ALL 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 X X X
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
857 ALL 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 X X X
Bugcheck or database corruption when attempting to store long incompressible data into a table
858 ALL 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 X X X
Broken optimization for the stored dbkeys
859 ALL 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 X X X
role not passed on external execute stmt
860 CS 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 X X X
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
861 SS 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 X X X
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
862 ALL 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 X X X
isql does not insert boolean values correctly, always shown as False
863 ALL 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 X X X
Creating external function (udf) to not existing dll - and then procedure with it - crash server
864 ALL 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 X X X
create package fails on creating header as soon as there is at least 1 procedure name
865 ALL 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 X X X
NOT-NULL-column can be used as primary key and filled with NULL-values
866 ALL 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 X X X
Constant columns getting empty value with subselect from procedure
867 ALL 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 X X X
Computed by columns and position function
868 ALL 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 X X X
Server bugchecks or crashes on exception in calculated index
869 ALL 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 X X X
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
870 CS 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 X X X
Wrong value of expected length in the sring right truncation error
871 SS 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     X X X
Wrong value of expected length in the sring right truncation error
872 ALL 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 X X X
Full outer join in derived table with coalesce (iif)
873 ALL 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 X X X
Regression: Group by fails if subselect-column is involved
874 ALL 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 X X X
Incorrect full join result with ROW_NUMBER() Function in CTE
875 ALL 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 X X X
Server crashes while converting an overscaled numeric to a string
876 CS 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 X X X
Wrong parameters order in trace output
877 SS 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 X X X
Wrong parameters order in trace output
878 ALL 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 X X X
Bad optimization of OR predicates applied to unions
879 ALL 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 X X X
wrong resultset (subquery + derived table + union)
880 ALL 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 X X X
Regression: Server crashes when executing sql query "delete from mytable order by id desc rows 2"
881 ALL 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 X X X
EXECUTE BLOCK prepare fails
882 CS 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 X X X
SIMILAR TO does not work with x-prefixed literals
883 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
SIMILAR TO does not work with x-prefixed literals
884 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
EXECUTE BLOCK execution cause server crash
885 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
EXECUTE BLOCK execution cause server crash
886 ALL 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 X X X
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
887 ALL 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 X X X
Expression index may be not used for derived fields or view fields
888 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Metadata source becomes wrong after twice transliteration to the metadata charset
889 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Metadata source becomes wrong after twice transliteration to the metadata charset
890 ALL 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 X X X
Metadata export with isql (option -ex) does not export functions properly
891 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
892 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
893 ALL 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 X X X
Using COLLATE UNICODE_CI_AI in WHERE clause (not indexed) is extremely slow
894 CS 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 X X X
gbak -r fails in restoring all stored procedures/functions in packages
895 SS 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 X X X
gbak -r fails in restoring all stored procedures/functions in packages
896 ALL 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 X X X
Server crashes instead of reporting the error "key size exceeds implementation restriction"
897 ALL 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 X X X
Error when processing an empty data set by window function, if reading indexed
898 CS 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 X X X
In SS sweep blocks establishment of concurrent attachments
899 SS 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 X X X
In SS sweep blocks establishment of concurrent attachments
900 ALL 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 X X X
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
901 ALL 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 X X X
Wrong metadata output script generate by isql / CHARACTER SETISO8859_1 sintax error
902 ALL 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 X X X
Error "invalid stream" can be raised in some cases while matching a computed index
903 ALL 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 X X X
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
904 ALL 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 X X X
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
905 ALL 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 X X X
Error "context already in use (BLR error)" when preparing a query with UNION
906 ALL 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 X X X
New permission types are not displayed by ISQL
907 ALL 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 X X X
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
908 ALL 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 X X X
Regression: LIKE with escape does not work
909 ALL 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 X X X
Parameterized exception does not accept not ASCII characters as parameter
910 ALL 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 X X X
User can not insert records into table with column "generated by default as identity" in its DDL
911 ALL 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 X X X
Owner name is missing for generators/exceptions restored from a backup
912 ALL 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 X X X
Replace the hierarchical union execution with the plain one
913 ALL 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 X X X
Creating external function (udf) to not existing dll - and then procedure with it - crash server
914 ALL 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 X X X
Setting generator value twice in single transaction will set it to zero
915 ALL 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 X X X
Problem with some boolean expressions not being allowed
916 CS 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 X X X
CREATE COLLATION does not verify base collation charset
917 SS 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     X X X
CREATE COLLATION does not verify base collation charset
918 ALL 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 X X X
Executing empty EXECUTE BLOCK with NotNull output parameter raised error
919 ALL 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 X X X
Incorrect "token unknown" error when the SQL string ends with a hex number literal
920 ALL 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 X X X
Add optional START WITH clause to identity columns
921 ALL 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 X X X
An uncommitted select of the pseudo table sec$users blocks new database connections
922 ALL 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 X X X
Regression: Computed field returns null value inside BI trigger
923 ALL 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 X X X
Cannot create packaged routines with [VAR]CHAR parameters
924 ALL 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 X X X
Error when compiling the procedure containing the statement if (x = (select ...))
925 ALL 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 X X X
ISQL -x does not output the START WITH clause of generators/sequences
926 ALL 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 X X X
Add RESTART [WITH] clause for alter identity columns
927 ALL 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 X X X
Preserve comments for output parameters after altering procedures
928 ALL 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 X X X
Dropping FK on GTT crashes server
929 ALL 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 X X X
GTT should not reference permanent relation
930 ALL 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 X X X
Memory leak with TRIGGER ON TRANSACTION COMMIT
931 CS 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 X X X
Add database owner to mon$database
932 SS 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 X X X
Add database owner to mon$database
933 ALL P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
Database replace through services API fails
934 ALL 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 X X X
Regression: Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
935 ALL 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 X X X
Bidirectional cursor is not positioned by the first call of FETCH LAST
936 ALL 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 X X X
In PSQL modules with declared cursors engine could assign value to the wrong variable
937 ALL 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 X X X
Error with IF (subfunc()) when subfunc returns a boolean
938 CS 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 X X X
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
939 SS 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 X X X
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
940 ALL 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 X X X
Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
941 ALL 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 X X X
Problem with creation procedure which contain adding text in DOS864 charset
942 ALL 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 X X X
Delete "where current of" cursor fails for tables with newly added fields
943 ALL 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 X X X
Add table name to text of validation contraint error message, to help identify error context
944 ALL 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 X X X
Parametrized queries using RDB$DB_KEY do not work
945 ALL 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 X X X
Regression: Wrong boundary for minimum value for BIGINT/DECIMAL(18)
946 ALL 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 X X X
Check result when joined fields are created via row_number() function
947 ALL 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 X X X
Context parsing error with derived tables and CASE functions
948 ALL 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 X X X
Wrong output when field with result of windowed function is used in query with useless WHERE 0=0 and GROUP BY clause
949 ALL 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 X X X
Error in case of subquery with windowed function + where <field> IN(select ...)
950 ALL 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 X X X
Engine crashs in case of re-creation of an erratic package body
951 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Error on create table with "CHARACTER SET DOS775" field
952 SS P P P P P P P P P P P P P P P P P P P P P P P P P     F     P X X X
Error on create table with "CHARACTER SET DOS775" field
953 ALL 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 X X X
FB3: Stored function accepts duplicate input arguments
954 CS 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 X X X
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
955 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
956 CS 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 X X X
Choose the best matching index for navigation
957 SS 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     X X X
Choose the best matching index for navigation
958 ALL 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 X X X
Regression: NOT-null field from derived table became NULL when is referred outside DT
959 CS 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 X X X
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
960 SS 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 X X X
Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
961 ALL P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
962 ALL 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 X X X
Inappropriate self-reference of column when using "with check option" with extract(...)
963 ALL 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 X X X
Non-ASCII data in SEC$USERS is not read correctly
964 ALL 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 X X X
Lookup (or scan) in descending index could be very inefficient for some keys
965 ALL 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 X X X
### ADDITIONAL TEST ### Lookup (or scan) in descending index could be very inefficient for some keys
966 ALL 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 X X X
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
967 ALL 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 X X X
Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
968 ALL 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 X X X
DateAdd(): change input <amount> argument from INT to BIGINT
969 ALL 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 X X X
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
970 ALL 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 X X X
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
971 CS 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 X X X
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
972 SS 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 X X X
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
973 ALL 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 X X X
Regression: ISQL does not destroy the SQL statement
974 ALL 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 X X X
Engine crashes when use aggregate or window functions in recursive query (instead of producing compiling error)
975 ALL 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 X X X
Keyword SET should not be required in ALTER USER statement
976 ALL 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 X X X
not correct result function LAG, if OFFSET value are assigned from a table
977 ALL 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 X X X
LAG, LEAD and NTH_VALUE raise error when the second argument is NULL
978 CS     F     P P P     F     P     F     P P P P P P P P P P P P P P P P P P     E     P X X X
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
979 SS 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 X X X
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
980 ALL 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 X X X
Non-privileged user can delete records from RDB$SECURITY_CLASSES table
981 CS 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 X X X
Error "no current record for fetch operation" when table inner join procedure inner join table
982 SS 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     X X X
Error "no current record for fetch operation" when table inner join procedure inner join table
983 CS 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 X X X
Ability to trace stored functions execution
984 SS 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         E     X X X
Ability to trace stored functions execution
985 ALL 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 X X X
Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
986 ALL 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 X X X
Incorrect default value when adding a new column
987 ALL 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 X X X
Parsing of recursive query returns error "Column does not belong to referenced table" for source that HAS such column
988 ALL 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 X X X
non-priviledged user can insert and update rdb$database
989 ALL 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 X X X
SELECT from derived table which contains GROUP BY on field with literal value returns wrong result
990 ALL 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 X X X
Equality predicate distribution does not work for some complex queries
991 ALL 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 X X X
Wrong result of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
992 ALL 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 X X X
BUGCHECK(177) for MERGE with multiple matches
993 ALL 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 X X X
Create function/sp which references to non-existent exception <...>
994 ALL 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 X X X
Duplicate names in package are not checked
995 ALL 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 X X X
Truncation error when using EXECUTE STATEMENT with a blob
996 ALL 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 X X X
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
997 ALL P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
Preparation of erroneous DDL statement does not show the main command failed
998 ALL 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 X X X
Poor performance of explicit cursors containing correlated subqueries in the select list
999 CS 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 X X X
ISQL truncates blob when reading an empty segment
1000 SS 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 X X X
ISQL truncates blob when reading an empty segment
1001 ALL 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 X X X
Incorrect line/column information in runtime errors
1002 ALL 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 X X X
User savepoints are not released on commit
1003 ALL 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 X X X
Report more details for "object in use" errors
1004 ALL 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 X X X
SELECT WITH LOCK may enter an infinite loop for a single record
1005 ALL 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 X X X
incorrect result query if it is execute through "execute statement"
1006 ALL 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 X X X
Provide ability to specify extra-long name of log when doing gbak to avoid "attempt to store 256 bytes in a clumplet" message
1007 ALL 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 X X X
Allow referencing cursors as record variables in PSQL
1008 ALL 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 X X X
Useless extraction of generic DDL trigger
1009 ALL 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 X X X
gbak: cannot commit index ; primary key with german umlaut
1010 ALL 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 X X X
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
1011 ALL 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 X X X
Server crashes while sorting records longer than 128KB
1012 ALL 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 X X X
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
1013 ALL 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 X X X
User-collations based on UNICODE are not upgrade to newer ICU version on restore
1014 ALL 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 X X X
Properties of user created in Legacy_UserManager padded with space up to 10 character
1015 ALL 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 X X X
Extend the use of colon prefix for read/assignment OLD/NEW fields and assignment to variables
1016 ALL 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 X X X
isql crash without connect when execute command "show version"
1017 ALL 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 X X X
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
1018 CS 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 X X X
Allow output to trace explain plan form.
1019 SS 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 X X X
Allow output to trace explain plan form.
1020 ALL 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 X X X
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
1021 ALL 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 X X X
Regression: NOT NULL constraint, declared in domain, does not work
1022 ALL 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 X X X
DATEADD should support fractional value for MILLISECOND
1023 ALL 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 X X X
Expressions containing some built-in functions may be badly optimized
1024 ALL 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 X X X
nbackup prints error messages to stdout instead stderr
1025 ALL 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 X X X
Duplicate tags for CREATE/ALTER USER not handled correctly
1026 ALL 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 X X X
Add DROP NOT NULL to ALTER COLUMN
1027 ALL 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 X X X
FB3: CREATE USER GRANT ADMIN ROLE does not work
1028 ALL 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 X X X
Add field in SEC$USERS reflecting whether a user has RDB$ADMIN role in security database
1029 CS 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 X X X
gbak fails to restore database containing dependency between views and packaged functions
1030 SS 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     X X X
gbak fails to restore database containing dependency between views and packaged functions
1031 ALL P P P P P P P P P P P P P P P P P P P P P P P X X X P X X X
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
1032 ALL 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 X X X
Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
1033 ALL 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 X X X
Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
1034 ALL 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 X X X
ISQL issues warning: "Bad debug info format" when connect to database with stored function after it`s restoring
1035 ALL 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 X X X
Description (COMMENT ON) for package procedures and functions, and its parameters
1036 ALL 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 X X X
Maintain package body after ALTER/RECREATE PACKAGE
1037 ALL 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 X X X
Cursor references must always represent the CURRENT state of the record, without caching when this record is read
1038 CS 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 X X X
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
1039 SS 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     X X X
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
1040 ALL 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 X X X
Index not found for RECREATE TRIGGER
1041 ALL 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 X X X
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
1042 ALL 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 X X X
FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
1043 ALL 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 X X X
ISQL command SHOW USERS display only me
1044 ALL 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 X X X
Unable delete procedure source on Firebird 3.0 Alpha 2.0
1045 ALL 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 X X X
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
1046 ALL 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 X X X
DB_KEY based join of two tables may be ineffective
1047 ALL 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 X X X
Server does not accept the right plan
1048 ALL 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 X X X
Allow hiding source code of procedures and triggers in FB 3
1049 ALL 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 X X X
DDL trigger remains active after dropped
1050 ALL 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 X X X
FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
1051 ALL 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 X X X
BUGCHECK(183) when use cursor with "order by ID+0" and "for update with lock"
1052 ALL 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 X X X
Incorrect size of the output parameter/argument when execute block, procedure or function use system field in metadata charset
1053 ALL 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 X X X
BIN_SHL and BIN_SHR does not work in Dialect 1
1054 ALL 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 X X X
Wrong error at ALTER PACKAGE
1055 ALL 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 X X X
Regression: Incorrect result in subquery with aggregate
1056 CS 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 X X X
Regression: Incorrect result in subquery with aggregate
1057 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P     E     X X X
Regression: Incorrect result in subquery with aggregate
1058 ALL 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 X X X
Within linger period one can not change some database properties
1059 ALL 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 X X X
Can't create column check constraint when the column is domain based
1060 ALL 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 X X X
Change type of returning value of CHAR_LENGTH, BIT_LENGTH and OCTET_LENGTH of BLOBs to bigint
1061 ALL 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 X X X
REPLACE function works incorrectly with multibyte charsets
1062 ALL 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 X X X
EXECUTE STATEMENT rise varchar char_length() size
1063 ALL 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 X X X
Add support for having more than one UserManager in firebird.conf and use them from SQL
1064 ALL 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 X X X
Rollback doesn`t undo changes when MERGE statement updates the same target rows multiple times and PLAN MERGE is used
1065 ALL 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 X X X
Regression: Trigger with UPDATE OR INSERT statement and IIF() not working as expected
1066 ALL 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 X X X
Regression: SP "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work
1067 ALL 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 X X X
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
1068 ALL 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 X X X
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
1069 CS 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 X X X
no permission for CREATE access to DATABASE (for RDB$ADMIN)
1070 SS 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     X X X
no permission for CREATE access to DATABASE (for RDB$ADMIN)
1071 ALL 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 X X X
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
1072 ALL 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 X X X
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 }
1073 ALL 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 X X X
Select from mon$table_stats doesn`t work on SC and CS
1074 ALL 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 X X X
Computed index based on a computed column stores NULL for all its keys
1075 ALL 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 X X X
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
1076 ALL 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 X X X
Regression: incorrect calculation of byte-length for view columns
1077 ALL 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 X X X
Error while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
1078 ALL 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 X X X
DISTINCT vs non-DISTINCT affects the result of IN subquery
1079 ALL 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 X X X
CTE Aliases ('Column unknown' when recursive CTE contain join with *alias* rather than table name)
1080 ALL 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 X X X
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
1081 ALL 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 X X X
Regression: Join order in v3 is less optimal than in v2.x
1082 ALL 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 X X X
ISQL pads blob columns wrongly when the column alias has more than 17 characters
1083 CS 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 X X X
Implement ability to validate tables and indices online (without exclusive access to database)
1084 SS 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 X X X
Implement ability to validate tables and indices online (without exclusive access to database)
1085 ALL 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 X X X
Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit
1086 ALL 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 X X X
invalid request BLR at offset 361 context already in use (BLR error)
1087 ALL 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 X X X
"BLOB not found" error at rollback after insert into table with expression index
1088 ALL 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 X X X
Restore of shadowed database fails using -k ("restore without shadow") switch
1089 ALL 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 X X X
Message "Statement failed, SQLSTATE = 00000 + unknown ISC error 0" appears when issuing REVOKE ALL ON ALL FROM <existing_user>
1090 ALL 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 X X X
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
1091 ALL 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 X X X
Add a flag to mon$database helping to decide what type of security database is used - default, self or other
1092 CS P P P P P P P P P P P P P P P P P P P     F         F     P P P P     E     P X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
1093 SS P P P P P P P P P P P P P P P P P P P     F