0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (0 rows)
2. FRESH FAILS: tests which failed for LAST execution only (0 rows)
3. FRESH ERRORS: tests which raised run-time error for LAST execution only (0 rows)
4. STILL FAILS: tests which fail for at least two last runs (0 rows)
5. Has fails: tests with at least one fail for previous runs (27 rows)
[CURRENT] 6. Has runtime errors: tests with at least one runtime error for previous runs (498 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
8. All tests: outcomes (4442 rows)
9. All tests: durations (4453 rows)
A. Skipped: tests which was intentionally excluded from execution (6 rows)

Generated 26.09.2021 21:17
Tested: FB40.   Build: 4.0.1.2618;   SS: 26.09.21 18:10:18 - 26.09.21 19:40:30;   CS: 26.09.21 19:43:28 - 26.09.21 21:14:07;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
Loading data. Please wait...

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

Jump to LIST of unique test names from this report

NN Test name mode 4.0.1.2618
2021-09-26
4.0.1.2613
2021-09-21
4.0.1.2606
2021-09-20
4.0.1.2605
2021-09-19
4.0.1.2604
2021-09-17
4.0.1.2602
2021-09-16
4.0.1.2592
2021-09-16
4.0.1.2588
2021-09-14
4.0.1.2587
2021-09-10
4.0.1.2586
2021-09-09
4.0.1.2585
2021-09-08
4.0.1.2584
2021-09-07
4.0.1.2580
2021-09-04
4.0.1.2579
2021-09-02
4.0.1.2578
2021-09-01
4.0.1.2577
2021-08-31
4.0.1.2574
2021-08-29
4.0.1.2573
2021-08-27
4.0.1.2571
2021-08-20
4.0.1.2570
2021-08-14
4.0.1.2569
2021-08-13
4.0.1.2568
2021-08-12
4.0.1.2567
2021-08-10
4.0.1.2565
2021-08-09
4.0.1.2564
2021-08-08
4.0.1.2563
2021-08-07
4.0.1.2558
2021-08-05
4.0.1.2556
2021-08-03
4.0.1.2555
2021-08-01
4.0.1.2554
2021-07-31
Test TITLE
1 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index
2 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Join on diffrent datatypes
3 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Using where params in SUM return incorrect results
4 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Recreate and self-referencing indexes
5 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Dropping and recreating a table in the same txn disables PK
6 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
bug with ALL keyword
7 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
numeric div in dialect 3 mangles data
8 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SELECT '1' UNION SELECT '12'
9 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Left joining views with null fails
10 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
trigger with except-s on view with union
11 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY works wrong with collate PT_PT
12 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SELECT...HAVING...NOT IN crashes server
13 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
DOMAINs don't register their dependency on other objects
14 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
bug #910430 ISQL and database dialect
15 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
NULLS FIRST does not work with unions
16 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent results using STARTING WITH and COALESCE
17 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Tricky role defeats basic SQL security
18 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
FIRST is applied before aggregation
19 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Blob Type 1 compatibility with VarChar
20 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Privileges of dynamic statements in SP
21 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Engine crashes while trying to backup a logically corrupt db
22 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Dependencies are not cleared when creation of expression index fails
23 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problems with explicit cursors in unwanted states
24 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crash on violation of NOT NULL constraint
25 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Grants don't work for procedures used inside views
26 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bug in DSQL parameter
27 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Case insensitive collation for UTF-8
28 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
29 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
select with FIRST and LEFT JOIN needs excess SORT in plan
30 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
context already in use (BLR error)
31 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Provide mechanism to get engine version without needing to call API function
32 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
33 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
34 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong parameter matching for self-referenced procedures
35 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
36 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error msg "Could not find UNIQUE INDEX" when in fact one is present
37 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
UNION vs UTF8 literals : arithmetic exception is thrown
38 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Symbols ignored for ES_ES_CI_AI collation
39 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Expression index based on computed fields
40 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
41 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Union returns inconsistent field names
42 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection
43 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong SELECT query results using index to evaluate >= condition
44 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and views
45 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problem with DISTINCT and insensitive collations
46 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
47 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Can't create table using long username and UTF8 as attachment charset
48 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization of queries with DB_KEY
49 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Indices not used for views
50 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
NOT NULL constraint for procedure parameters and variables
51 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
size of alias name in a table
52 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Index operations for global temporary tables are not visible for the active connection
53 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Too large numbers cause positive infinity to be inserted into database
54 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL crash when converted-from-double string longer than 23 bytes
55 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI
56 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Invalid parameter type when using it in CHAR_LENGTH function
57 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
58 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong current timestamp evaluation for selectable procedures
59 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Greek characters in cp1251 vs uppercasing
60 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Execute statement 'select ....' into new....
61 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Allow usage of functions in LIST delimiter parameter
62 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Make optimizer to consider ORDER BY optimization when making decision about join order
63 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])
64 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Functions DATEDIFF does not work in dialect 1
65 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
JOIN on first record of ordered derived table returns wrong record
66 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
RDB$procedures generator overflow
67 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order
68 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
69 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
AV when all statements are cancelled
70 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Multiple Rows in Singleton Select not reported in a View
71 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ABS() rounds NUMERIC values
72 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 232 (invalid operation) for an aggregated query
73 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Ability to insert child record if parent record is locked but foreign key target unchanged
74 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect error message (column number) if the empty SQL string is prepared
75 CS P P P P P     E     P P P P P P P P P P X P P P P P P P P P P P P P
Non-privileged monitoring reports wrong attachment data
76 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Non-privileged monitoring reports wrong attachment data
77 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan
78 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
'There are <n> dependencies' error message shows the wrong count of dependent objects.
79 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
arithmetic exception, numeric overflow, or string truncation in utf8 tables
80 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
81 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bug in create/alter Database trigger (with Russian comment)
82 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Expression index can be created while doing inserts into table
83 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Include information about context variables into the monitoring tables
84 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problem with COLLATE ES_ES_CI_AI
85 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL crashes when fetching data for a column having alias longer than 30 characters
86 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
AV at prepare of query with unused parametrized CTE
87 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation
88 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
89 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Index is not used for some date/time expressions in dialect 1
90 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
BLR error on restore database with computed by Field
91 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Roles granting/revoking logic
92 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error on script with current_date
93 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Circular dependencies between computed fields crashs the engine
94 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GROUP BY RAND() returns infinite rows
95 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Non-SYSDBA user can change FW mode of database.
96 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Broken foreign key handling for multi-segmented index using multi-level collations
97 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
TimeStamp in the every line output gbak.exe utility
98 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
99 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING with regular expression (SIMILAR TO) capability
100 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
NOT NULL procedure parameters
101 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
I/O statistics for stored procedures are not accounted in monitoring tables
102 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
103 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
104 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Domain-level CHECK constraints wrongly process NULL values
105 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
update or insert with gen_id() with wrong generator value
106 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
don't work subquery in COALESCE
107 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW WITH CHECK OPTION crashes the engin
108 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins
109 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
View over global temporary table
110 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
111 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Join of SP with view or table may fail with "No current record for fetch operation"
112 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected (wrong) results with COALESCE and GROUP BY
113 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
New gbak option to ignore specific tables data during the backup
114 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problem with column names with Accents and triggers
115 CS P P P P P     E     P P P P P P P P P P X P P P P P P P P P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
116 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
117 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
118 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gbak doesn't return error code
119 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
120 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
121 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incomplete API information values
122 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO produces random results with [x-y] expressions
123 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
124 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Too long column name for select alias should be rejected
125 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
126 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
127 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on UPDATE OR INSERT statement
128 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server fails when doing DROP DATABASE right after error in statistical fnction
129 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
UNICODE_CI internal gds software consistency check
130 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Binary shift functions give wrong results with negative shift values
131 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Built-in trigonometric functions can produce NaN and Infinity
132 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong processing a SP parameters with arrays
133 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Maximum and minimum identifier length should be enforced by DSQL
134 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
135 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Infinity should not escape from the engine
136 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
137 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SELECT WITH LOCK with no fields are accessed clears the data
138 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Write note into log when automatic sweep is started
139 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
System triggers on view with check option are not removed
140 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
141 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
142 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
143 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
144 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
145 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Include client library version and protocol version in mon$attachments
146 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Make rdb$system_flag not null
147 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Views based on procedures can't be created if the proc's output fields participate in an expression
148 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
149 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Natural is used to select instead of primary key index
150 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Query with "NOT IN <subselect from view>" fails
151 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
A memory corruption cause incorrect query evaluation and may crash the server
152 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Expression in a subquery may be treated as invariant and produce incorrect results
153 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Unable to catch exceptions that are thrown inside a dynamic builded execute block.
154 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
PK index is not used for derived tables
155 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
156 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Character set used in constants is not registered as dependency
157 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
"Invalid ESCAPE sequence" when connecting to the database
158 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION
159 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Trace output could contain garbage data left from filtered out statements
160 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
count(*) from big table returns negative result
161 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Concurrent transaction number not reported if lock timeout occurs
162 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error on delete user "ADMIN"
163 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Procedure suspend check may cause restore to fail
164 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Add attachment's CHARACTER SET name into corresponding trace records
165 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong resultset
166 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
New generators are created with wrong value when more than 32K generators was previously created
167 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Using both the procedure name and alias inside an explicit plan crashes the server
168 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Foreign key cascade with SET DEFAULT uses the default value of the moment of the FK creation
169 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect LEFT JOIN result using table and derived constant subquery
170 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Parameters doesn't work with NOT IN from a selectable procedure
171 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Updating blob field cause server crash with ACCESS_VIOLATION exception
172 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
173 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
174 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Preserve comments for parameters after altering procedures
175 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
View with "subselect" column join table and not use index
176 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW with not matched columns in declaration and selection crashs the server
177 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ATAN2 returns incorrect value for (0, 0)
178 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ASCII_VAL() fails if argument contains multi-byte character anywhere
179 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
RIGHT() fails with multibyte text blobs > 1024 chars
180 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
OVERLAY() fails when used with text BLOBs containing multi-byte chars
181 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Recursive stored procedure shouldnt require execute right to call itself
182 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
"BLOB not found" error after creation/altering of the invalid trigger
183 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
184 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
185 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
186 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
187 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong comparsion of DATE and TIMESTAMP if index is used
188 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
189 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Extend syntax for ALTER USER CURRENT_USER
190 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
191 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GRANT ADMIN ROLE not accepted
192 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression in joins on procedures
193 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Blob transliteration may not happen inside the union
194 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW crashes the server if the new version has an artificial (aggregate or union) stream at the position of a regular context in the older version
195 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Unquoted role names with non-ASCII characters passed in DPB are upper-cased wrongly
196 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crash with built in function LPAD with string as second parameter
197 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
198 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Aliases for the RETURNING clause
199 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GFIX returns an error after correctly shutting down a database
200 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Database corruption after end of session : page xxx is of wrong type expected 4 found 7
201 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
202 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
AV in engine when preparing query against dropping table
203 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CHAR(32767) present in XSQLVAR with length 32765
204 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Can not drop table when computed field depends on later created another field
205 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Include expected and actual string lenght into error message for sqlcode -802
206 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
TRACE: add statistics of actions that were after transaction finished
207 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Can insert DUPLICATE keys in UNIQUE index
208 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong data while retrieving from CTEs (or derived tables) with same column names
209 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: cume_dist()
210 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: ntile(num_buckets integer)
211 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Missing constraint name in foreign key error message in FB 2.1.4
212 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
213 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
String truncation error when selecting from a VIEW with UNION inside
214 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
IS NOT DISTINCT FROM NULL doesn't use index
215 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
216 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
217 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
218 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SELECT using IN list with 153 or more elements causes crash
219 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
with caller privileges option do not work with autonomous transaction option
220 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Provide ability to return all columns using RETURNING (eg RETURNING *)
221 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bad alias table choice joining CTE
222 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on preparing empty query when trace is enabled
223 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong numbers in error message for decreasing char/varchar columns
224 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
High memory usage when PSQL code SELECT's from stored procedure which modified some data
225 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
226 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
DeActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
227 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Restore from gbak backup using service doesn't report an error
228 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
229 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
230 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
231 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Parametrized execute statement fails
232 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
wrong error message with recursive CTE
233 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
role not passed on external execute stmt
234 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
NOT-NULL-column can be used as primary key and filled with NULL-values
235 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong value of expected length in the sring right truncation error
236 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Full outer join in derived table with coalesce (iif)
237 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization of OR predicates applied to unions
238 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
In SS sweep blocks establishment of concurrent attachments
239 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "invalid stream" can be raised in some cases while matching a computed index
240 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: LIKE with escape does not work
241 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
User can not insert records into table with column "generated by default as identity" in its DDL
242 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Creating external function (udf) to not existing dll - and then procedure with it - crash server
243 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Executing empty EXECUTE BLOCK with NotNull output parameter raised error
244 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Add optional START WITH clause to identity columns
245 CS P P P P P     E     P P P P P P P P P P X P P P P P P P P P P P P P
An uncommitted select of the pseudo table sec$users blocks new database connections
246 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
An uncommitted select of the pseudo table sec$users blocks new database connections
247 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Computed field returns null value inside BI trigger
248 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL -x does not output the START WITH clause of generators/sequences
249 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Dropping FK on GTT crashes server
250 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTT should not reference permanent relation
251 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Add database owner to mon$database
252 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
253 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bidirectional cursor is not positioned by the first call of FETCH LAST
254 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
255 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problem with creation procedure which contain adding text in DOS864 charset
256 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Wrong boundary for minimum value for BIGINT/DECIMAL(18)
257 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Check result when joined fields are created via row_number() function
258 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error in case of subquery with windowed function + where <field> IN(select ...)
259 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Choose the best matching index for navigation
260 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: NOT-null field from derived table became NULL when is referred outside DT
261 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Non-ASCII data in SEC$USERS is not read correctly
262 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
263 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
264 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current record for fetch operation" when table inner join procedure inner join table
265 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Ability to trace stored functions execution
266 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SELECT from derived table which contains GROUP BY on field with literal value returns wrong result
267 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong result of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
268 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Create function/sp which references to non-existent exception <...>
269 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Truncation error when using EXECUTE STATEMENT with a blob
270 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
271 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL truncates blob when reading an empty segment
272 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Enhancement in precision of calculations with NUMERIC/DECIMAL
273 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
274 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Can`t create two collations with different names if autoddl OFF in FB 2.5.3
275 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Expressions containing some built-in functions may be badly optimized
276 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
nbackup prints error messages to stdout instead stderr
277 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Duplicate tags for CREATE/ALTER USER not handled correctly
278 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Add DROP NOT NULL to ALTER COLUMN
279 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gbak fails to restore database containing dependency between views and packaged functions
280 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Message "Modifying function <F> which is currently in use" when running script with AUTODDL=OFF and <F> is called from INTERNAL function declared in other unit
281 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
282 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
283 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Changed data not visible in WHEN-section if exception occured inside SP that has been called from this code
284 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
285 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Index not found for RECREATE TRIGGER
286 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Unable delete procedure source on Firebird 3.0 Alpha 2.0
287 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Allow to use index when GROUP BY on field which has DESCENDING index
288 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server does not accept the right plan
289 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE STATEMENT rise varchar char_length() size
290 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: SP "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work
291 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
292 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
no permission for CREATE access to DATABASE (for RDB$ADMIN)
293 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
294 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
295 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
DISTINCT vs non-DISTINCT affects the result of IN subquery
296 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CTE Aliases ('Column unknown' when recursive CTE contain join with *alias* rather than table name)
297 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL pads blob columns wrongly when the column alias has more than 17 characters
298 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Add a flag to mon$database helping to decide what type of security database is used - default, self or other
299 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Prohibit an ability to issue DML or DDL statements on RDB$ tables
300 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
301 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code at offset 15, encountered 255"
302 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
303 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
304 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
305 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
306 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
307 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
308 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
309 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
310 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Altering a trigger indicating other table than the original does not reflect the change
311 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
312 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Increase speed of creating package when number of its functions more than several hundreds
313 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Speed up function creation and loading when there are many functions in the database
314 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
MERGE / HASH JOINs produce incorrect results when VARCHAR join keys differ only by trailing spaces
315 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
IIF function prevents the condition from being pushed into the union for better optimization
316 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
317 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Statistics for any system index can not be updated/recalculated
318 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
319 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Detach using Linux client takes much longer than from Windows
320 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Ordering by compound index together with a range condition gives wrong results
321 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Non-privileged user can implicitly count records in a restricted table
322 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes during GC when DELETE is executed after adding new referencing column
323 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
324 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Connecting to service with invalid servicename yields incorrect error message
325 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
326 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
327 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
328 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P     F     P P P P
ISQL 'SHOW DATABASE' command does not show encryption status of database
329 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator
330 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
331 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
332 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL extract command looses COMPUTED BY field types
333 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
334 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Support autocommit mode in SET TRANSACTION statement
335 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Expression index may not be used by the optimizer if created and used in different connection charsets
336 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
337 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
338 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
create trigger fails with ambiguous field name between table B and table A error
339 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
[CREATE OR] ALTER USER statement: clause PASSWORD (if present) must be always specified just after USER
340 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SEC$ tables and tag/attributes
341 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
342 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Allow implicit conversion between boolean and string
343 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Wrong sequence of savepoints may be produced by selectable procedure
344 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Invalid computed by definition generated by isql -x
345 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL -X: double quotes are missed for COLLATE <C> of CREATE DOMAIN statement when <C> is from any non-ascii charset
346 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Authentication end with first plugin that has the user but auth fails; should continue with next plugin
347 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
348 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
String truncation error while selecting from MON$ tables if some user-defined context variable exceeds 255 bytes in length
349 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Nested OR conditions may lead to incorrest results
350 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
FBSVCMGR does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N)
351 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error messages differ when regular user tries to RESTORE database, depending on his default role and (perhaps) system privilege USE_GBAK_UTILITY
352 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CASCADE UPDATE fails for self-referencing FK
353 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Data type unknown error with LIST
354 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
355 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Trace session leads FB 4.0 to hang after 2nd launch of trivial .sql script. Neither attach to any database nor regular restart of FB service can be done.
356 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: The subquery in the insert list expressions ignore the changes made earlier in the same executable block.
357 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
358 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Query cannot be executed if win1251 characters used in field aliases
359 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization of some operations with views containing subqueries
360 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Invalid data type for negation (minus operator)
361 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent column/line references when PSQL definitions return errors
362 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Performance degradation in FB 3.0.2 compared to FB 2.5.7
363 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
364 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
365 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE STATEMENT <e> when <e> starts with '--' issues -Unexpected ... column <NNN>, value <NNN> is invalid and can change randomly
366 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Support GENERATED ALWAYS identity columns and OVERRIDE clause
367 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
368 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Provide ability to filter out info and warnings from trace log
369 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING startposition smaller than 1 should be allowed
370 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
371 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bad performance for NULLs filtering inside a navigational index scan
372 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
373 CS P P P P P P P P P P P P P P P P X P P P P P P P     E         E         E     P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
374 SS P P P P P     E     P P P P P P P P P P P P P P P P P P     E         E         E     P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
375 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Crash on 3.0 and 4.0 when DB contains database-level trigger
376 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Connections compressed and encrypted in MON$ATTACHMENTS table
377 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
378 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
379 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Direct system table modifications are not completely prohibited
380 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL incorrectly pads UNICODE_FSS/UTF8 columns when they use a collation
381 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck on queries containing WITH LOCK clause
382 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
383 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Invalid blob id when add a new blob column of type text and update another field
384 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Gradual slowdown compilation (create, recreate or drop) of views
385 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
386 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Store precision of DECFLOAT in RDB$FIELDS
387 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Field alias disapears in complex query
388 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Reject non-constant date/time/timestamp literals
389 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
When requesting the subtype of a NUMERIC or DECIMAL column with precision in [19, 34] using isc_info_sql_sub_type, it always returns 0, instead of 1 for NUMERIC and 2 for DECIMAL.
390 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect error message in iSQL when trying to create database with wrong password
391 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
User can grant usage privilege by himself
392 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
No error if the GRANT target object does not exist
393 SS P P P P P P P P P P P P P P P P P     E     P P P P P P P P P P P P
Error returned from DbCryptPlugin::setKey() is not shown
394 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gstat may produce faulty report about presence of some none-encrypted pages in database
395 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER CURRENT USER fails with "no permission for <...> TABLE PLG$SRP" if current user: 1) has NO admin role and 2) wants to modify his own TAGS list
396 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on preparing empty query when trace is enabled
397 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Ignor of reference privilege
398 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Very poor "similar to" performance
399 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect caching of the subquery result (procedure call) in independent queries
400 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
401 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Initial global mapping from srp plugin does not work
402 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SQL SECURITY DEFINER context is not properly evaluated for monitoring tables
403 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
404 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Enhance dynamic libraries loading related error messages
405 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 165 (cannot find tip page) // Classic and SuperClassic only
406 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Firebird crashes, related to Bugcheck 165 (cannot find tip page)
407 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
408 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Handling FP overflow in double precision value when converting from decfloat.
409 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
error read permission for BLOB field, when it is input/output procedure`s parametr
410 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Trace could not work correctly with quoted file names in trace configurations
411 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
RDB$GET_TRANSACTION_CN works different in Super and Classic
412 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
FB4 unable to overwrite older ods database
413 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING(CURRENT_TIMESTAMP) does not work
414 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
The original time zone should be set to the current time zone at routine invocation
415 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Srp user manager sporadically creates users which can not attach
416 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
417 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Builtin functions converting binary string to hexadecimal representation and vice versa
418 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Random crash 64bit fb_inet_server. Possible collation issue
419 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Server hangs when compiling big package with error
420 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
USING PLUGIN clause does not work in RECREATE USER
421 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE SEQUENCE START WITH has wrong initial value
422 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problem with casting within UNION
423 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
424 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
425 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...')
426 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent behavior regarding visibility of master record on detail inserts
427 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
substring similar - extra characters in the result for non latin characters
428 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
"No current record for fetch operation" with queries with aggregated subselect
429 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation"
430 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Some (wrong ?) parameters of ENCRYPT() leads FB to crash
431 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call
432 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
VARCHAR of insufficient length used for set bind of decfloat to varchar
433 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
request size limit exceeded when selecting from a table with large number of indicies
434 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
isc_info_svc_user_dbpath always returns alias of main security database
435 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
DECFLOAT: subtraction Num1 - Num2 leads to "Decimal float overflow" if Num2 is specified in scientific notation and less than max double ( 1.7976931348623157e308 )
436 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Problem with too many number of columns in resultset.
437 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML
438 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction
439 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
SHOW DOMAIN/TABLE does not display character set of system objects
440 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Hex number used at end of statement (e.g. CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions
441 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
FB4 Beta 2 may still be using the current date for TIME WITH TIME ZONE and extended wire protocol.
442 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Make explicit basic type for high precision numerics - INT128
443 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ROUND() does not allow second argument >=1 when its first argument is more than MAX_BIGINT / 10
444 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Adding NOT NULL column with DEFAULT value may cause default values to update when selecting or have the wrong charset
445 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table
446 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ISQL: bad headers when text columns has >= 80 characters
447 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Provide ability to see in the trace log actions related to session management (e.g. ALTER SESSION RESET)
448 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: can not get statistics for selected table(s) via services, get "found unknown switch" error
449 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Provide same results for date arithmetics when date is changed by values near +/-max(bigint)
450 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
451 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current record for fetch operation" when sorting by a international string
452 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
453 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Hash join cannot match records using some TIME ZONE / DECFLOAT keys
454 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Implementation of SUBSTRING for UTF8 character set is inefficient
455 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters [CORE5255]
456 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
DECRYPT() must return BLOB if its first argument is blob, otherwise returnted datatype must be VARCHAR with charset NONE
457 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
assertion in tomcrypt when key length for rc4 too small
458 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
assertion in tomcrypt when key length for rc4 too small
459 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Integer hex-literals: support for INT128
460 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Correct error message for DROP VIEW
461 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Segfault using "commit retaining" with GTT
462 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Deleting multiple rows from a view with triggers may cause triggers to fire just once
463 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
464 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Indexed STARTING WITH execution is very slow with UNICODE collation
465 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
466 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
error no permision occurred while ALTER USER SET TAGS on snapshot build WI-V3.0.8.33482
467 SS P P P P P     E     P P P P P X X X X X X X X X X X X X X X X X X X
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
468 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN - DROP DEFAULT
469 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN - Alter domain that doesn't exists
470 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - FLOAT
471 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - TIME
472 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - DECIMAL ARRAY
473 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - NUMERIC
474 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - CHARACTER
475 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - NATIONAL CHARACTER
476 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - BLOB (seglen,subtype)
477 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE DOMAIN - CHECK
478 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
computed-fields-02
479 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
computed-fields-04
480 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
computed-fields-06
481 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
computed-fields-07
482 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTCS/tests/external-file-04-d-int128. Test for external table with field of INT128 datatype
483 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-01
484 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-05
485 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-06
486 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-07
487 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-14
488 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-17
489 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTCS/tests/SELECT_DELETE_ISQL. Test for select from SP that deletes record after its output.
490 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTCS/tests/CF_ISQL_34. minimum-grant-test
491 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTCS/tests/REF_INT.7.ISQL ; ref-integ-inactive-pk-index. Index that is used for PRIMARY KEY should not be avail for INACTIVE.
492 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTCS/tests/FB_SQL_WINDOW_FUNC_02 - set of miscelaneous tests for verification of windowed functions.
493 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
GTCS/tests/FB_SQL_WINDOW_FUNC_05 - set of miscelaneous tests for verification of windowed functions.
494 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER TABLE - ADD column (test2)
495 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
ALTER TABLE - ALTER - TO
496 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table
497 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE TABLE - constraints
498 SS P P P P P     E     P P P P P P P P P P P P P P P P P P P P P P P P
CREATE TABLE - unknown datatype (domain)

Elapsed time, milliseconds:
NN Test name mode median_ms 4.0.1.2618
2021-09-26
4.0.1.2613
2021-09-21
4.0.1.2606
2021-09-20
4.0.1.2605
2021-09-19
4.0.1.2604
2021-09-17
4.0.1.2602
2021-09-16
4.0.1.2592
2021-09-16
4.0.1.2588
2021-09-14
4.0.1.2587
2021-09-10
4.0.1.2586
2021-09-09
4.0.1.2585
2021-09-08
4.0.1.2584
2021-09-07
4.0.1.2580
2021-09-04
4.0.1.2579
2021-09-02
4.0.1.2578
2021-09-01
4.0.1.2577
2021-08-31
4.0.1.2574
2021-08-29
4.0.1.2573
2021-08-27
4.0.1.2571
2021-08-20
4.0.1.2570
2021-08-14
4.0.1.2569
2021-08-13
4.0.1.2568
2021-08-12
4.0.1.2567
2021-08-10
4.0.1.2565
2021-08-09
4.0.1.2564
2021-08-08
4.0.1.2563
2021-08-07
4.0.1.2558
2021-08-05
4.0.1.2556
2021-08-03
4.0.1.2555
2021-08-01
4.0.1.2554
2021-07-31
Test TITLE
1 SS 2000 2140 2399 2089 2080 1950 9 1960 2000 1870 1940 1940 2039 2039 1910 2109 2019 1889 2129 1869 1969 2000 2000 2059 2009 2009 2960 1930 1869 1950 1890
Navigation vs IS NULL vs compound index
2 SS 1639 1720 1650 1629 1720 1660 9 1900 1690 1630 1649 1680 1660 1620 1539 1639 1640 2009 1559 1799 1629 1519 1580 1579 1689 1590 1569 1000 1489 1639 1890
Join on diffrent datatypes
3 SS 1430 1470 1610 1380 1529 1400 9 1509 1549 1470 1369 1470 1000 1519 1480 1460 1410 1450 1529 1389 1599 1390 1430 1350 1460 1380 1430 1410 1409 1400 1390
Using where params in SUM return incorrect results
4 SS 1980 2200 2899 1980 2230 2109 9 2019 2060 2099 1919 2049 1990 1980 1929 2289 1970 1900 1979 1900 2019 2069 1890 1960 1970 1940 2420 1920 1870 2069 1849
Recreate and self-referencing indexes
5 SS 1719 1849 1649 1759 1660 1660 9 1839 1759 1669 1970 1880 1710 1630 1980 1720 1000 1580 1719 2049 1900 1639 1819 1759 1670 1680 1759 1700 1629 1740 1730
Dropping and recreating a table in the same txn disables PK
6 SS 1150 1230 1230 1000 1129 1159 9 1259 1190 1090 1190 1289 1150 1130 1209 1240 1080 1079 1170 1049 1089 1139 1129 1000 1180 1110 1199 1179 1089 1180 1150
bug with ALL keyword
7 SS 640 670 740 690 660 700 0 630 679 630 589 630 649 630 660 670 640 670 640 599 680 700 629 620 600 619 680 610 579 620 690
numeric div in dialect 3 mangles data
8 SS 1079 1119 1109 1129 1089 1230 9 1019 1090 1019 1019 1090 1009 1049 1040 990 1059 1059 1089 990 1089 1090 1089 1039 1120 1069 1389 1019 1190 1140 1040
SELECT '1' UNION SELECT '12'
9 SS 1774 1860 1780 1759 1829 1789 9 2190 2240 1769 1759 1719 1000 1759 1829 2230 1909 1860 1789 1730 1759 1820 1880 1709 2000 1720 1809 1000 1000 1759 1730
Left joining views with null fails
10 SS 1279 1409 1309 1339 1279 1420 9 1240 1539 1279 1319 1359 1369 1219 1509 1210 1319 1240 1349 1269 1240 1240 1320 1319 1230 1279 1319 1230 1200 1180 1270
trigger with except-s on view with union
11 SS 1489 1560 1579 1509 1529 1710 9 1519 1569 1539 1450 1759 1470 1459 1640 1000 1379 1440 1430 1390 1509 1389 1509 1839 1430 1389 1540 1000 1409 1430 1529
ORDER BY works wrong with collate PT_PT
12 SS 630 680 670 710 679 730 0 840 590 619 630 630 610 619 640 650 640 579 609 549 640 589 629 660 609 609 630 650 589 579 620
SELECT...HAVING...NOT IN crashes server
13 SS 1389 1369 1440 1000 1450 1460 9 1490 1610 1349 1450 1000 1350 1529 1319 1340 1340 1369 1519 1410 1359 1379 1339 1360 1439 1519 1590 1400 1369 1480 1419
DOMAINs don't register their dependency on other objects
14 SS 1144 1170 1180 1180 1180 1150 9 1210 1240 1130 1149 1170 1139 1090 1070 1140 1069 1170 1309 1180 1190 1289 1210 1119 1109 1109 1120 1099 1079 1130 1099
bug #910430 ISQL and database dialect
15 SS 1144 1140 1170 1170 1150 1159 9 1100 1200 1300 1359 1099 1120 1169 1150 1000 1109 1050 1139 1099 1180 1100 1170 1169 1119 1149 1139 1170 1109 1109 1210
NULLS FIRST does not work with unions
16 SS 990 1029 1059 1009 1000 1030 0 960 1090 1029 990 1029 1039 990 950 899 930 1109 1039 970 949 970 960 1090 960 950 1180 970 920 929 1019
Inconsistent results using STARTING WITH and COALESCE
17 SS 1549 1549 1609 1519 1629 1610 9 1519 1649 1529 1579 1609 1440 1549 1469 1580 1589 1429 1519 1580 1519 1519 1769 1510 1549 1580 1579 1509 1430 1589 1589
Tricky role defeats basic SQL security
18 SS 1349 1579 1390 1399 1349 1289 0 1480 1589 1559 1319 1309 1340 1350 1320 1359 1310 1269 1509 1299 1300 1349 1379 1369 1380 1339 1479 1240 1440 1329 1309
FIRST is applied before aggregation
19 SS 1154 1210 1180 1109 1000 1160 9 1210 1000 1179 1160 1169 1190 1159 1190 1159 1109 1129 1170 1089 1150 1119 1150 1159 1210 1079 1150 1190 1079 1089 1120
Blob Type 1 compatibility with VarChar
20 SS 1800 1880 2000 1990 1799 1879 0 1910 1799 1740 1869 2000 1859 1869 1730 1799 1000 1970 1740 1769 1720 1899 1720 1940 2009 1759 2579 1769 1800 1789 1799
Privileges of dynamic statements in SP
21 SS 629 720 759 660 0 659 9 660 680 570 579 619 629 609 589 740 629 640 630 659 609 599 629 590 700 630 660 660 629 579 629
Engine crashes while trying to backup a logically corrupt db
22 SS 1119 1160 1139 1339 1089 1390 9 1069 1000 1069 1089 1129 1119 1179 1119 1120 1119 1079 1609 1070 1099 1149 1330 1070 1139 1120 1120 1090 1049 1109 1259
Dependencies are not cleared when creation of expression index fails
23 SS 1589 1660 1740 1680 1599 1670 9 1630 1700 1480 1690 1589 1559 1529 1639 1599 1599 1539 1000 1000 1580 1549 1589 1690 1460 1639 1570 1630 1400 1490 1570
Problems with explicit cursors in unwanted states
24 SS 1834 1799 1979 1900 1829 1950 9 2009 1830 1819 1889 1839 2019 1869 1980 1819 1720 1829 1799 1930 1869 1769 1680 1829 2079 1979 1860 1889 1829 1829 1819
Server crash on violation of NOT NULL constraint
25 SS 1730 1720 1920 1730 1890 1819 0 1880 2039 1940 1779 1860 1820 1840 1700 1650 1730 1740 1000 1769 1579 1729 1690 1680 1769 1000 1720 1740 1720 1000 1700
Grants don't work for procedures used inside views
26 SS 1299 1369 1279 1289 1339 1369 0 1269 1369 1340 1439 1319 1479 1269 1269 1210 1520 1220 1260 1359 1299 1259 1270 1289 1230 1239 1319 1329 1220 1310 1299
Bug in DSQL parameter
27 SS 1190 1220 1410 1219 1160 1190 0 1200 1190 1169 1279 1370 1190 1139 1190 1279 1089 1130 1169 1170 1160 1120 1259 1529 1329 1109 1260 1150 1150 1089 1000
Case insensitive collation for UTF-8
28 SS 4120 4269 3970 4130 4099 4230 0 3900 4110 4269 4799 4120 4040 4120 4459 3909 3960 4029 4370 4119 4189 3949 4079 4099 4259 4019 4529 4159 3869 4170 4170
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
29 SS 1819 1880 2000 1809 1769 1899 9 1789 2029 1720 1830 1829 1849 1759 1900 1779 1829 1799 1719 1870 1839 1759 1879 1730 1880 1000 1689 1850 1649 1690 1869
select with FIRST and LEFT JOIN needs excess SORT in plan
30 SS 1139 1160 1149 1199 1200 1190 0 1119 1180 1279 1200 1139 1000 1069 1050 1110 1130 1040 1130 1050 1099 1160 1269 1150 1079 1140 1240 1150 1110 1059 1110
context already in use (BLR error)
31 SS 629 620 0 769 630 629 0 790 589 629 609 629 620 639 630 679 589 569 619 579 650 629 630 680 670 640 700 650 609 639 619
Provide mechanism to get engine version without needing to call API function
32 SS 1274 1220 1380 1460 1349 1259 9 1410 1299 1000 1269 1000 1289 1220 1269 1279 1299 1230 1309 1259 1349 1269 1319 1000 1299 1400 1640 1220 1000 1279 1259
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
33 SS 1274 1339 1439 1230 1349 1319 9 1320 1330 1309 1170 1269 1240 1279 1220 1369 1309 1389 1200 1190 1270 1230 1220 1340 1370 1269 1349 1259 1130 1329 1150
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
34 SS 1119 1229 1220 1160 1129 1109 9 1000 1090 1230 1170 1119 1129 1119 1129 1180 1009 990 1079 1149 1119 1079 1139 1120 1099 1119 1119 1190 1080 1019 1080
Wrong parameter matching for self-referenced procedures
35 SS 940 1049 1040 939 1029 990 0 990 1059 890 930 899 940 930 950 980 950 970 980 940 909 869 1000 920 939 919 950 930 920 919 930
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
36 SS 1319 1330 1390 1400 1329 1379 0 1430 1340 1299 1309 1259 1160 1300 1269 1319 1460 1319 1320 1230 1349 1290 1319 1349 1580 1339 1669 1299 1300 1259 1000
Error msg "Could not find UNIQUE INDEX" when in fact one is present
37 SS 650 660 660 659 680 680 0 669 689 590 630 620 650 610 659 620 590 630 629 599 700 660 589 660 690 670 629 680 569 640 630
UNION vs UTF8 literals : arithmetic exception is thrown
38 SS 1539 1670 1589 1530 1699 1569 0 1650 1869 1529 1670 1490 1470 1460 1519 1000 1539 1450 1509 1490 1529 1590 1869 1000 1659 1640 1609 1660 1519 1559 1529
Symbols ignored for ES_ES_CI_AI collation
39 SS 1720 1720 2569 1819 1890 1930 9 2079 1870 1699 1609 1789 1720 1610 1769 1740 2000 1620 1720 1649 1819 1700 1720 1700 1740 1690 2490 1720 1710 1670 1690
Expression index based on computed fields
40 SS 1029 1139 1130 1069 1029 1000 0 1029 1039 1100 1049 1040 1029 980 1009 1039 1019 960 1119 1009 1110 1039 960 1039 1059 1000 1029 1039 929 970 1000
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
41 SS 1284 1409 1289 1360 1350 1329 9 1570 1000 1259 1389 1230 1000 1379 1000 1280 1279 1380 1339 1200 1359 1000 1410 1360 1279 1259 1400 1220 1259 1180 1339
Union returns inconsistent field names
42 SS 700 809 0 710 730 650 9 720 660 640 710 689 819 700 700 710 700 629 700 649 670 670 680 779 740 640 689 700 690 660 789
Long SQL statements break TCP/IP connection
43 SS 2979 2889 2950 3069 2830 2980 9 3359 3190 2769 2950 2980 3069 3140 2919 3019 2900 2820 3159 3009 2930 3140 3160 2990 3220 2879 3349 2950 2979 2929 2710
Wrong SELECT query results using index to evaluate >= condition
44 SS 1444 1490 1000 1430 1509 1509 9 1480 1450 1000 1579 1389 1329 1460 1660 2430 1490 1509 1470 1329 1359 1430 1000 1359 1430 1509 1469 1329 1439 1379 1609
Incorrect column values with outer joins and views
45 SS 1120 1120 1180 1099 1359 1180 0 1169 1329 1079 1039 1029 1289 1099 1150 1159 1150 1079 1109 1089 1069 1200 1149 1139 1139 1029 1100 1049 1059 1019 1189
Problem with DISTINCT and insensitive collations
46 SS 1229 1200 1289 1360 1269 1229 9 1220 1220 1230 1220 1179 1230 1180 1349 1379 1230 1300 1000 1760 1209 1190 1230 1279 1259 1210 1399 1180 1109 1160 1269
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
47 SS 1365 1379 1460 1380 1390 1350 659 1490 1419 1440 1460 1359 1339 1370 1360 1509 1329 1339 1310 1240 1360 1329 1000 1370 1339 1339 1390 1470 1459 1339 1410
Can't create table using long username and UTF8 as attachment charset
48 SS 619 640 710 629 620 700 9 650 689 589 600 670 619 600 600 689 579 610 639 610 569 629 679 649 609 609 630 609 570 610 620
Bad optimization of queries with DB_KEY
49 SS 1474 1529 1450 1470 1419 1490 9 1659 1520 1480 1519 1460 1560 1480 1470 1529 1359 1420 1420 1480 1409 1400 1519 1460 1459 1559 1519 1490 1470 1379 1479
Indices not used for views
50 SS 920 1109 980 920 919 920 0 1009 909 920 880 930 910 920 919 920 1029 920 930 849 1000 960 970 940 890 879 940 869 889 950 990
NOT NULL constraint for procedure parameters and variables
51 SS 1140 1240 1230 1140 1140 1099 0 1099 1120 1029 1179 1150 1180 1100 1210 1109 1119 1190 1190 1200 1160 1130 1150 1120 1200 1170 1130 1000 1309 1109 1099
size of alias name in a table
52 SS 2000 1940 1960 2279 2060 1940 0 2070 2029 1970 1920 2159 2160 2099 1949 1950 1950 1970 1850 2110 2000 2000 1970 1980 2159 2050 2690 2060 1889 1909 2009
Index operations for global temporary tables are not visible for the active connection
53 SS 1130 1170 1309 1130 1090 1299 9 1140 1169 1099 1110 1180 1170 1079 1140 1210 1109 1160 1110 1160 1120 1099 1129 1059 1200 1180 1000 1190 1070 1130 1079
Too large numbers cause positive infinity to be inserted into database
54 SS 629 700 680 620 630 640 9 640 789 660 639 589 629 609 599 630 599 629 639 580 629 579 630 619 680 600 640 630 580 569 630
ISQL crash when converted-from-double string longer than 23 bytes
55 SS 1519 1529 1539 1000 1730 1579 9 1740 1650 1360 1549 1400 1589 1589 1480 1509 1430 1669 1480 1529 1460 1399 1429 1529 1710 1540 1410 1590 1439 1390 1490
French insensitive collation FR_FR_CI_AI
56 SS 630 650 730 630 630 630 0 630 769 580 700 599 620 650 639 630 610 629 679 559 720 669 660 669 569 590 710 639 600 599 640
Invalid parameter type when using it in CHAR_LENGTH function
57 SS 1304 1240 1329 1410 1480 1279 9 1349 1450 1299 1329 1289 1329 1339 1339 1149 1169 1419 1259 1330 1180 1270 1240 1240 1309 1459 1539 1339 1169 1220 1200
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
58 SS 1434 1620 1399 1430 1430 1509 9 1450 1579 1389 1460 1440 1459 1439 1470 1399 1519 1449 1380 1409 1370 1349 1540 1449 1579 1380 1399 1390 1380 1400 1509
Wrong current timestamp evaluation for selectable procedures
59 SS 1410 1519 1480 1400 1460 1480 0 1680 1290 1460 1319 1329 1419 1409 1410 1419 1000 1389 1360 1309 1449 1369 1380 1420 1409 1410 1419 1360 1309 1509 1559
Greek characters in cp1251 vs uppercasing
60 SS 1349 1279 1370 1490 1289 1410 9 1349 1240 1400 1369 1319 1319 1299 1349 1420 1269 1390 1600 1339 1340 1350 1419 1480 1330 1329 1559 1359 1329 1299 1349
Execute statement 'select ....' into new....
61 SS 1180 1000 1230 1319 1399 1269 0 1000 1219 1269 1289 1339 1000 1150 1160 1130 1180 1190 1169 1160 1139 1200 1149 1119 1240 1180 1159 1150 1180 1170 1220
Allow usage of functions in LIST delimiter parameter
62 SS 5359 5339 5509 5649 5400 5360 9 5860 6679 5200 5330 5319 5809 5569 5289 5460 5360 5330 5579 5000 5490 5339 5709 5319 5269 5359 5000 5690 5019 5509 5330
Make optimizer to consider ORDER BY optimization when making decision about join order
63 SS 630 630 720 669 710 700 0 660 779 610 629 569 580 650 609 600 720 590 629 690 609 609 619 630 599 700 759 599 619 660 650
POSITION(string_exp1, string_exp2 [, start])
64 SS 659 710 680 720 710 690 0 0 649 629 650 660 620 649 649 610 720 590 659 619 690 639 690 799 630 609 690 679 669 600 679
Functions DATEDIFF does not work in dialect 1
65 SS 1240 1000 1230 1289 1269 1430 0 1240 1410 1289 1150 1210 1279 1190 1139 1240 1269 1240 1200 1000 1190 1280 1389 1200 1259 1240 1430 1230 1149 1210 1309
JOIN on first record of ordered derived table returns wrong record
66 SS 115570 129240 125339 120160 120989 124970 9 120029 138780 115590 122899 114569 114539 112649 115069 116990 116759 111389 115140 109579 113120 115890 122340 115550 115070 112000 120700 119779 109949 109069 114589
RDB$procedures generator overflow
67 SS 1185 1230 1269 1240 1269 1000 9 1199 1289 1230 1259 1180 1129 1159 1210 1160 1289 1170 1150 1140 1440 1150 1160 1000 1259 1129 1159 1259 1140 1190 1210
Subquery-based predicates are not evaluated early in the join order
68 SS 1074 1119 1180 1079 1119 1089 9 1070 1329 1049 1090 1000 1140 1119 1029 1099 1069 1240 1039 1059 1049 1160 1060 1130 1130 1099 1049 1029 1019 1000 1019
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
69 SS 2954 2789 2240 2059 3039 2420 9 2890 2809 2849 2720 3559 3029 3440 2789 2769 3299 3120 2860 3019 3420 3529 3240 2799 3009 3009 2900 3329 3120 3440 2630
AV when all statements are cancelled
70 SS 1529 1000 1680 1529 1569 1660 9 1529 1679 1460 1569 1460 1440 1799 1559 1000 1589 1440 1529 1509 1639 1559 1659 1529 1789 1529 1519 1530 1480 1640 1000
Multiple Rows in Singleton Select not reported in a View
71 SS 639 689 670 650 650 640 0 690 730 680 620 610 620 610 650 649 619 589 590 589 600 600 669 639 640 639 609 639 600 630 599
ABS() rounds NUMERIC values
72 SS 1294 1259 1349 1270 1339 1259 9 1290 1380 1289 1329 1289 1349 1269 1259 1259 1299 1349 1290 1299 1359 1240 1240 1319 1349 1299 1310 1589 1279 1210 1309
Bugcheck 232 (invalid operation) for an aggregated query
73 SS 1799 1709 1970 1789 1779 1839 0 1910 2319 1700 1850 1920 1869 1840 1759 2020 1759 1820 1789 1799 1719 1729 1680 1720 1890 1740 1869 1890 1900 1789 1799
Ability to insert child record if parent record is locked but foreign key target unchanged
74 SS 924 960 1040 989 909 959 9 1019 960 880 900 900 869 939 1070 880 980 960 910 869 929 889 930 900 960 940 920 920 879 869 1100
Incorrect error message (column number) if the empty SQL string is prepared
75 CS 2039 2029 2019 2099 1950 2079 819 2210 2110 2029 2220 2259 2009 1990 2099 1980 2079 1889 1930 2229 2090 2139 1900 2039 1909 2309 2120 1900 1950 2079
Non-privileged monitoring reports wrong attachment data
76 SS 1490 1479 1669 1480 1549 1480 630 1590 1519 1460 1540 1710 1539 1490 1440 1589 1470 1419 1490 1420 1579 1579 1490 1490 1419 1450 1649 1880 1430 1529 1000
Non-privileged monitoring reports wrong attachment data
77 SS 1304 1380 1380 1369 1309 1370 9 1420 1310 1659 1490 1319 1389 1259 1279 1290 1289 1259 1319 1279 1350 1299 1370 1349 1299 1259 1299 1230 1000 1240 1000
AV when recursive query used MERGE JOIN in execution plan
78 SS 1824 2240 1919 1819 1829 2039 9 1740 1830 1849 2220 1849 1950 1809 1829 1740 1859 1669 1839 1959 1799 1759 1689 1860 1000 1789 1890 1779 1710 1740 1720
'There are <n> dependencies' error message shows the wrong count of dependent objects.
79 SS 1210 1279 1370 1210 1269 1400 0 1220 1259 1000 1199 1140 1220 1210 1159 1220 1200 1280 1210 1190 1269 1170 1319 1200 1179 1119 1470 1210 1170 1170 1139
arithmetic exception, numeric overflow, or string truncation in utf8 tables
80 SS 869 900 1000 920 940 899 0 910 910 819 920 840 900 790 879 899 809 839 870 849 859 839 819 779 909 840 859 859 829 869 899
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
81 SS 1119 1119 1240 1220 1000 1269 9 1119 1379 1069 1079 1100 1130 1180 1179 1170 1049 1270 1220 1159 1230 1179 1330 1089 1059 1080 1070 1079 1069 1009 1050
Bug in create/alter Database trigger (with Russian comment)
82 SS 36590 37509 37930 37859 37410 36779 9 36819 36490 35809 36990 36009 35930 36839 35839 35849 35930 37029 36710 36819 36400 36839 36690 36210 36220 36079 35980 36470 37180 36269 36710
Expression index can be created while doing inserts into table
83 SS 659 730 769 680 690 700 9 699 630 649 609 660 650 619 610 660 650 660 639 620 639 639 680 660 610 659 669 680 700 620 679
Include information about context variables into the monitoring tables
84 SS 1089 1059 1159 1000 1240 1269 0 1049 1200 1120 1150 1009 1139 1090 1110 1029 1129 1009 1019 1289 1100 1089 1220 1079 1049 1080 1080 1049 1049 1069 1100
Problem with COLLATE ES_ES_CI_AI
85 SS 810 819 860 849 799 800 9 859 910 769 0 870 789 0 809 730 789 789 799 0 829 839 820 819 810 769 849 799 829 720 829
ISQL crashes when fetching data for a column having alias longer than 30 characters
86 SS 949 969 1019 970 1000 990 9 910 1080 890 869 909 990 940 1120 940 909 980 1029 870 950 950 920 980 960 1210 949 900 910 880 880
AV at prepare of query with unused parametrized CTE
87 SS 1089 1099 1100 1049 1070 1049 0 1019 1049 1269 1059 1060 1100 1089 1130 1120 1090 1120 1089 1000 1129 1149 1060 1129 1089 960 1079 1119 1000 1170 1029
Maximum key size using PXW_CSY collation
88 SS 1130 1240 1399 1179 1090 1589 0 1189 1080 1069 1160 1179 1140 1069 1159 1089 1080 1099 1089 1110 1240 1059 1240 1089 1100 1150 1130 1140 1100 1070 1159
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
89 SS 4660 4000 4549 4740 5340 5210 0 4970 17339 4410 4730 4610 4589 4700 4470 4740 4669 4379 4410 4640 4480 4769 4710 4630 4730 4460 6139 4490 4460 4660 4869
Index is not used for some date/time expressions in dialect 1
90 SS 3240 3440 3480 3289 3289 3359 0 3329 3440 3210 3309 3170 3599 3209 3190 3259 3000 3149 3240 3190 3339 3170 3230 3230 3470 3220 3580 3220 3210 3309 3190
BLR error on restore database with computed by Field
91 SS 2124 2340 2419 2149 2099 2160 9 2539 2200 2320 2029 2140 2079 2269 2109 2100 2090 2090 2149 2110 2019 2119 2189 2130 2029 2069 2180 2139 2159 2119 2079
Roles granting/revoking logic
92 SS 1094 1000 1129 1199 1049 1150 9 1119 1079 1160 1130 1099 1039 1170 1170 1069 1119 1070 1079 1120 1090 1079 1160 1139 1079 1109 1090 1089 1049 1069 1109
Error on script with current_date
93 SS 1464 1509 1460 1430 1690 1509 9 1449 1509 1359 1450 1000 1699 1420 1400 1459 1509 1440 1549 1430 1460 1469 1649 1490 1410 1529 1529 1509 1399 1480 1699
Circular dependencies between computed fields crashs the engine
94 SS 629 599 670 630 619 599 0 629 650 610 630 619 629 630 629 610 609 599 680 579 620 640 619 630 620 620 700 700 640 559 630
GROUP BY RAND() returns infinite rows
95 SS 955 1029 1019 1089 939 970 9 1119 940 960 910 980 950 970 929 1009 930 980 980 940 980 920 929 1000 920 910 940 960 940 960 950
Non-SYSDBA user can change FW mode of database.
96 SS 1549 1549 1559 1559 1519 1559 9 1550 1509 1610 1560 1599 1839 1609 1569 1700 1430 1480 1650 1439 1519 1529 1579 1480 1549 1540 1460 1519 1509 1640 1560
Broken foreign key handling for multi-segmented index using multi-level collations
97 SS 2480 2579 2629 2790 2629 2519 0 2000 2680 2409 2509 2480 2460 2400 2430 2460 2470 2539 2460 2410 2569 2490 2480 2539 2519 2460 2620 2450 2470 2480 2529
TimeStamp in the every line output gbak.exe utility
98 SS 630 680 629 640 619 660 0 649 720 630 660 639 640 639 640 619 599 580 659 590 599 619 619 640 629 609 650 660 610 600 599
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
99 SS 830 869 890 820 860 880 9 910 789 849 869 789 809 809 810 810 799 789 849 809 850 759 840 910 809 960 869 900 799 850 799
SUBSTRING with regular expression (SIMILAR TO) capability
100 SS 1019 1080 1119 990 1079 1059 0 1059 1100 1090 950 1000 1029 950 1019 1099 1019 1069 970 990 1019 1009 970 990 1090 950 1090 1019 1009 1000 1099
NOT NULL procedure parameters
101 SS 6140 6600 6440 6529 6019 6000 0 6140 6529 7200 6060 5620 6450 7220 5930 6049 7140 5600 6480 6339 6200 6019 5859 6289 5910 5769 6350 6129 5740 6100 6299
I/O statistics for stored procedures are not accounted in monitoring tables
102 SS 809 919 940 890 909 879 0 860 849 769 869 830 0 759 839 740 799 740 849 740 789 809 759 849 810 740 769 759 0 759 809
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
103 SS 630 730 680 759 650 740 0 609 700 630 700 589 769 609 620 630 620 619 579 600 630 589 670 649 670 630 699 599 620 609 630
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
104 SS 1084 1079 1160 1099 1109 1039 9 1099 1239 1130 1190 1150 1099 1049 1129 1090 1049 1049 1069 1059 1099 1039 1030 1109 1079 1000 1380 1079 1059 1159 1069
Domain-level CHECK constraints wrongly process NULL values
105 SS 1539 1599 1900 1529 1569 1640 0 1720 1609 1420 1590 1480 1479 1610 1540 1480 1519 1559 1550 1480 1700 1519 1539 1480 1539 1440 1980 1480 1529 1480 1410
update or insert with gen_id() with wrong generator value
106 SS 1539 1549 1610 1600 1529 1619 9 1700 1730 1000 1759 1490 1509 1000 1490 1440 1589 1529 1430 1599 1590 1400 1560 1589 1480 1589 1620 1509 1450 1519 1609
don't work subquery in COALESCE
107 SS 1099 1099 1129 1120 1129 1159 0 1119 1180 1049 1369 1179 1059 1089 1049 1099 1069 1039 1159 1069 1110 1129 1059 1080 1069 1049 1090 1130 1019 1100 1090
ALTER VIEW WITH CHECK OPTION crashes the engin
108 SS 1450 1470 1579 1449 1630 1529 0 1580 1329 1400 1410 1430 1629 1480 1490 1430 1359 1470 1380 1430 1470 1450 1410 1599 1409 1559 1470 1680 1389 1429 1420
Parts of RDB$DB_KEY of views may be inverted when using outer joins
109 SS 1440 1470 1439 1480 1429 1600 0 1730 1490 1370 1529 1519 1390 1440 1360 1369 1669 1410 1509 1340 1360 1589 1349 1480 1369 1390 1880 1519 1380 1440 1480
View over global temporary table
110 SS 1269 1289 1360 1279 1450 1359 0 1000 1400 1159 1370 1000 1000 1230 1370 1240 1000 1210 1279 1240 1630 1210 1309 1289 1380 1230 1220 1269 1180 1229 1279
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
111 SS 1375 1449 1700 1349 1380 1370 9 1460 1309 1470 1369 1359 1370 1519 1440 1369 1579 1330 1410 1279 1509 1490 1480 1370 1400 1320 1349 1309 1579 1349 1389
Join of SP with view or table may fail with "No current record for fetch operation"
112 SS 960 1149 1000 960 960 960 9 1059 1039 970 950 970 1069 940 960 900 950 950 1019 970 990 1189 960 990 970 920 950 1009 909 960 940
Unexpected (wrong) results with COALESCE and GROUP BY
113 SS 3740 3710 4019 3809 3740 3829 0 4170 3650 3680 3629 4119 3670 3819 3670 3990 3609 3559 3780 3420 3610 3779 3789 3740 3589 3759 3960 3629 3640 3430 3830
New gbak option to ignore specific tables data during the backup
114 SS 1144 1000 1210 1150 1160 1299 9 1179 1210 1139 1240 1080 1150 1089 1129 1150 1169 1050 1190 1059 1210 1089 1119 1149 1160 1089 1120 1089 1099 1140 1170
Problem with column names with Accents and triggers
115 CS 1930 1880 2079 1930 1980 1920 860 1920 2009 1970 1889 1759 2130 2099 2309 1970 1950 2000 1900 2220 1880 1880 1960 1890 1889 1850 2009 1779 1859 2000
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
116 SS 1235 1259 1430 1369 1209 1259 9 1359 1380 1210 1289 1269 1349 1240 1299 1200 1240 1170 1210 1160 1179 1210 1210 1269 1230 1310 1199 1210 1259 1180 1170
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
117 SS 1009 980 1140 1080 1029 1069 9 1019 1049 900 1009 1009 1009 980 1000 1019 990 1070 1000 1009 1029 1079 1019 1319 970 970 1050 1000 950 990 1039
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
118 SS 1529 1660 1789 1589 1600 1599 0 1700 1490 1490 1539 1460 1569 1519 1539 1549 1519 1489 1470 1480 1539 1539 1529 1509 1460 1579 1579 1519 1470 1480 1000
gbak doesn't return error code
119 SS 1549 1729 1629 1549 1810 1829 0 1559 1650 1450 1599 1000 1579 1480 1480 1650 1709 1439 1519 1549 1000 1579 1519 1519 1539 1559 1509 1619 1000 1450 1389
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
120 SS 1215 1269 1419 1400 1240 1309 9 1289 1220 1200 1259 1200 1200 1000 1220 1220 1210 1210 1230 1150 1170 1200 1190 1000 1279 1000 1270 1300 1230 1000 1170
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
1