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