NN | Test name | mode |
6.0.0.881
|
6.0.0.877
|
6.0.0.876
|
6.0.0.863
|
6.0.0.858
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
6.0.0.753
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
2 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
3 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit any improper mixture of explicit and implicit joins |
|
4 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit any improper mixture of explicit and implicit joins |
|
5 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Join condition fails for UTF-8 databases |
|
6 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Join condition fails for UTF-8 databases |
|
7 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Natural is used to select instead of primary key index |
|
8 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Natural is used to select instead of primary key index |
|
9 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | isql should show packaged procedures and functions categorized per package |
|
10 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | isql should show packaged procedures and functions categorized per package |
|
11 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | PK index is not used for derived tables |
|
12 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | PK index is not used for derived tables |
|
13 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
14 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
15 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Broken error handling in the case of a conversion error happened during index creation |
|
16 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Broken error handling in the case of a conversion error happened during index creation |
|
17 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW drops output parameters of used stored procedures |
|
18 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW drops output parameters of used stored procedures |
|
19 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
20 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
21 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
22 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
23 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
24 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
25 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
26 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
27 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Using both the procedure name and alias inside an explicit plan crashes the server |
|
28 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Using both the procedure name and alias inside an explicit plan crashes the server |
|
29 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
30 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
31 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cannot alter the domain after migrating from older versions |
|
32 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cannot alter the domain after migrating from older versions |
|
33 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
34 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
35 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Expression index with TRIM may lead to incorrect indexed lookup |
|
36 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Expression index with TRIM may lead to incorrect indexed lookup |
|
37 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
38 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
39 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
40 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
41 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | UTF8 UNICODE_CI collate can not be used in compound index |
|
42 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | UTF8 UNICODE_CI collate can not be used in compound index |
|
43 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
44 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
45 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | "BLOB not found" error after creation/altering of the invalid trigger |
|
46 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | "BLOB not found" error after creation/altering of the invalid trigger |
|
47 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
48 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
49 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
50 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
51 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
52 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
53 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
54 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
55 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Generators are set to 0 after restore |
|
56 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Generators are set to 0 after restore |
|
57 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Blob filter to translate internal debug info into text representation |
|
58 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Blob filter to translate internal debug info into text representation |
|
59 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
60 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
61 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Recurse leads to hangs/crash server |
|
62 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Recurse leads to hangs/crash server |
|
63 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | [FB3] AV with "UPDATE OR INSERT" |
|
64 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | [FB3] AV with "UPDATE OR INSERT" |
|
65 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inefficient optimization (regression) |
|
66 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inefficient optimization (regression) |
|
67 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression in joins on procedures |
|
68 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression in joins on procedures |
|
69 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Altering of a TYPE OF COLUMN parameter affects the original column |
|
70 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Altering of a TYPE OF COLUMN parameter affects the original column |
|
71 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW ignores the existing non-column dependencies |
|
72 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW ignores the existing non-column dependencies |
|
73 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Alter procedure allows to add the parameter with the same name |
|
74 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Alter procedure allows to add the parameter with the same name |
|
75 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
76 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
77 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistent domain's constraint validation in PSQL |
|
78 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistent domain's constraint validation in PSQL |
|
79 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Floating-point negative zero doesn't match positive zero in the index |
|
80 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Floating-point negative zero doesn't match positive zero in the index |
|
81 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
82 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
83 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CHAR(32767) present in XSQLVAR with length 32765 |
|
84 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CHAR(32767) present in XSQLVAR with length 32765 |
|
85 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Include expected and actual string lenght into error message for sqlcode -802 |
|
86 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Include expected and actual string lenght into error message for sqlcode -802 |
|
87 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | TRACE: add statistics of actions that were after transaction finished |
|
88 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | TRACE: add statistics of actions that were after transaction finished |
|
89 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Can insert DUPLICATE keys in UNIQUE index |
|
90 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Can insert DUPLICATE keys in UNIQUE index |
|
91 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server crashes with access violation when inserting row into table with unique index |
|
92 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server crashes with access violation when inserting row into table with unique index |
|
93 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | computed index by substring function for long columns |
|
94 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | computed index by substring function for long columns |
|
95 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
96 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
97 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
98 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
99 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Missing constraint name in foreign key error message in FB 2.1.4 |
|
100 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Missing constraint name in foreign key error message in FB 2.1.4 |
|
101 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | IS NOT DISTINCT FROM NULL doesn't use index |
|
102 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | IS NOT DISTINCT FROM NULL doesn't use index |
|
103 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
104 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
105 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
106 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
107 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
108 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
109 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Usage of a NATURAL JOIN with a derived table crashes the server |
|
110 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Usage of a NATURAL JOIN with a derived table crashes the server |
|
111 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Extend the error reported for index/constraint violations to include the problematic key value |
|
112 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Extend the error reported for index/constraint violations to include the problematic key value |
|
113 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong numbers in error message for decreasing char/varchar columns |
|
114 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong numbers in error message for decreasing char/varchar columns |
|
115 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Derived fields may not be optimized via an index |
|
116 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Derived fields may not be optimized via an index |
|
117 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
118 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
119 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
120 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
121 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | isql doesn't know the difference between UDF's and psql-functions |
|
122 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | isql doesn't know the difference between UDF's and psql-functions |
|
123 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
124 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
125 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Join using RDB$DB_KEY produce NATURAL plan |
|
126 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Join using RDB$DB_KEY produce NATURAL plan |
|
127 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
128 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
129 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Broken optimization for the stored dbkeys |
|
130 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Broken optimization for the stored dbkeys |
|
131 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | NOT-NULL column can be used as primary key and filled with NULL-values |
|
132 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | NOT-NULL column can be used as primary key and filled with NULL-values |
|
133 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Computed by columns and position function |
|
134 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Computed by columns and position function |
|
135 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server bugchecks or crashes on exception in calculated index |
|
136 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server bugchecks or crashes on exception in calculated index |
|
137 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Group by fails if subselect-column is involved |
|
138 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Group by fails if subselect-column is involved |
|
139 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bad optimization of OR predicates applied to unions |
|
140 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bad optimization of OR predicates applied to unions |
|
141 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
142 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
143 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Expression index may be not used for derived fields or view fields |
|
144 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Expression index may be not used for derived fields or view fields |
|
145 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
146 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
147 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Metadata export with isql (option -ex) does not export functions properly |
|
148 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Metadata export with isql (option -ex) does not export functions properly |
|
149 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
150 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
151 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | New permission types are not displayed by ISQL |
|
152 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | New permission types are not displayed by ISQL |
|
153 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
154 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
155 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | The parameterized exception does not accept not ASCII characters as parameter |
|
156 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | The parameterized exception does not accept not ASCII characters as parameter |
|
157 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Replace the hierarchical union execution with the plain one |
|
158 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Replace the hierarchical union execution with the plain one |
|
159 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cannot create packaged routines with [VAR]CHAR parameters |
|
160 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cannot create packaged routines with [VAR]CHAR parameters |
|
161 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ISQL -x does not output the START WITH clause of generators/sequences |
|
162 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ISQL -x does not output the START WITH clause of generators/sequences |
|
163 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Preserve comments for output parameters after altering procedures |
|
164 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Preserve comments for output parameters after altering procedures |
|
165 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | GTT should not reference permanent relation |
|
166 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | GTT should not reference permanent relation |
|
167 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problem with creation procedure which contain adding text in DOS864 charset |
|
168 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problem with creation procedure which contain adding text in DOS864 charset |
|
169 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Add table name to text of validation contraint error message, to help identify error context |
|
170 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Add table name to text of validation contraint error message, to help identify error context |
|
171 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Context parsing error with derived tables and CASE functions |
|
172 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Context parsing error with derived tables and CASE functions |
|
173 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error on create table with "CHARACTER SET DOS775" field |
|
174 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error on create table with "CHARACTER SET DOS775" field |
|
175 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB3: Stored function accepts duplicate input arguments |
|
176 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB3: Stored function accepts duplicate input arguments |
|
177 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
178 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
179 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Choose the best matching index for navigation |
|
180 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Choose the best matching index for navigation |
|
181 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
182 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
183 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
184 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
185 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
186 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
187 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
188 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
189 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
190 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
191 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | non-priviledged user can insert and update rdb$database |
|
192 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | non-priviledged user can insert and update rdb$database |
|
193 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Equality predicate distribution does not work for some complex queries |
|
194 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Equality predicate distribution does not work for some complex queries |
|
195 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Create function/sp which references to non-existent exception <...> |
|
196 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Create function/sp which references to non-existent exception <...> |
|
197 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Duplicate names in package are not checked |
|
198 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Duplicate names in package are not checked |
|
199 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Preparation of erroneous DDL statement does not show the main command failed |
|
200 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Preparation of erroneous DDL statement does not show the main command failed |
|
201 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
202 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
203 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Incorrect line/column information in runtime errors |
|
204 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Incorrect line/column information in runtime errors |
|
205 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Report more details for "object in use" errors |
|
206 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Report more details for "object in use" errors |
|
207 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow referencing cursors as record variables in PSQL |
|
208 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow referencing cursors as record variables in PSQL |
|
209 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Useless extraction of generic DDL trigger |
|
210 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Useless extraction of generic DDL trigger |
|
211 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
212 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
213 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow output to trace explain plan form. |
|
214 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow output to trace explain plan form. |
|
215 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: NOT NULL constraint, declared in domain, does not work |
|
216 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: NOT NULL constraint, declared in domain, does not work |
|
217 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
218 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
219 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | gbak fails to restore database containing dependency between views and packaged functions |
|
220 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | gbak fails to restore database containing dependency between views and packaged functions |
|
221 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
222 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
223 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
224 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
225 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | New gbak option to enable encryption during restore |
|
226 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | New gbak option to enable encryption during restore |
|
227 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
228 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
229 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow to use index when GROUP BY on field which has DESCENDING index |
|
230 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow to use index when GROUP BY on field which has DESCENDING index |
|
231 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DB_KEY based join of two tables may be ineffective |
|
232 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DB_KEY based join of two tables may be ineffective |
|
233 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server does not accept the right plan |
|
234 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server does not accept the right plan |
|
235 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DDL trigger remains active after dropped |
|
236 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DDL trigger remains active after dropped |
|
237 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
238 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
239 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
240 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
241 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Can't create column check constraint when the column is domain based |
|
242 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Can't create column check constraint when the column is domain based |
NN | Test name | mode | median_ms |
6.0.0.881
|
6.0.0.877
|
6.0.0.876
|
6.0.0.863
|
6.0.0.858
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
6.0.0.753
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1051 | 987 | 1099 | 606 | 937 | 1088 | 615 | 1053 | 665 | 1070 | 709 | 625 | 646 | 678 | 1130 | 1045 | 1252 | 1076 | 1078 | 1161 | 1040 | 1152 | 678 | 612 | 602 | 1088 | 1102 | 1239 | 1049 | 1148 | 1259 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
2 | SS | 436 | 425 | 473 | 436 | 398 | 407 | 459 | 388 | 445 | 518 | 369 | 440 | 453 | 431 | 436 | 457 | 402 | 456 | 458 | 425 | 429 | 391 | 413 | 441 | 447 | 438 | 426 | 413 | 359 | 488 | 444 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
3 | CS | 1272 | 1357 | 1306 | 1249 | 1257 | 835 | 739 | 1131 | 864 | 1348 | 778 | 808 | 851 | 767 | 1401 | 1327 | 1424 | 1288 | 1235 | 1387 | 1123 | 1307 | 909 | 813 | 802 | 1454 | 1373 | 1518 | 1389 | 1497 | 1363 | Prohibit any improper mixture of explicit and implicit joins |
|
4 | SS | 572 | 613 | 564 | 583 | 554 | 544 | 667 | 518 | 564 | 532 | 534 | 530 | 561 | 550 | 551 | 582 | 574 | 589 | 623 | 578 | 598 | 586 | 595 | 542 | 558 | 509 | 585 | 570 | 602 | 591 | 608 | Prohibit any improper mixture of explicit and implicit joins |
|
5 | CS | 1068 | 674 | 859 | 1027 | 1092 | 691 | 692 | 620 | 703 | 1105 | 608 | 645 | 597 | 608 | 1080 | 1092 | 1076 | 1080 | 1061 | 1164 | 957 | 1108 | 760 | 1165 | 818 | 1211 | 1137 | 1205 | 1167 | 1115 | 1365 | Join condition fails for UTF-8 databases |
|
6 | SS | 464 | 499 | 451 | 447 | 434 | 432 | 453 | 447 | 468 | 534 | 446 | 462 | 451 | 441 | 500 | 486 | 467 | 456 | 438 | 522 | 523 | 471 | 438 | 469 | 470 | 413 | 513 | 470 | 441 | 485 | 546 | Join condition fails for UTF-8 databases |
|
7 | CS | 1199 | 705 | 762 | 1293 | 1244 | 734 | 663 | 1326 | 857 | 1181 | 680 | 925 | 711 | 787 | 718 | 1301 | 1533 | 1016 | 1267 | 1322 | 1214 | 1346 | 824 | 1185 | 679 | 1263 | 1353 | 1345 | 1293 | 1334 | 1299 | Natural is used to select instead of primary key index |
|
8 | SS | 546 | 553 | 462 | 493 | 476 | 528 | 746 | 552 | 576 | 607 | 496 | 569 | 504 | 558 | 558 | 526 | 540 | 582 | 564 | 552 | 621 | 547 | 554 | 524 | 515 | 540 | 522 | 545 | 508 | 591 | 514 | Natural is used to select instead of primary key index |
|
9 | CS | 1042 | 1142 | 1087 | 981 | 1044 | 635 | 671 | 1234 | 671 | 1167 | 656 | 627 | 624 | 647 | 1077 | 1110 | 1034 | 1074 | 1033 | 1065 | 904 | 1076 | 756 | 1122 | 645 | 1121 | 1041 | 1100 | 1056 | 1012 | 1182 | isql should show packaged procedures and functions categorized per package |
|
10 | SS | 441 | 464 | 395 | 471 | 429 | 449 | 472 | 474 | 457 | 441 | 472 | 471 | 436 | 406 | 416 | 446 | 467 | 438 | 422 | 429 | 495 | 461 | 415 | 468 | 465 | 409 | 431 | 425 | 425 | 441 | 433 | isql should show packaged procedures and functions categorized per package |
|
11 | CS | 1257 | 669 | 1276 | 1322 | 1291 | 810 | 811 | 1374 | 789 | 1252 | 758 | 803 | 957 | 888 | 1225 | 1387 | 1339 | 1092 | 1196 | 1382 | 1285 | 858 | 929 | 1278 | 751 | 1400 | 1301 | 1381 | 1262 | 1324 | 1409 | PK index is not used for derived tables |
|
12 | SS | 535 | 409 | 505 | 491 | 537 | 531 | 522 | 586 | 531 | 530 | 540 | 552 | 540 | 684 | 527 | 532 | 552 | 592 | 522 | 573 | 583 | 523 | 485 | 560 | 497 | 522 | 537 | 553 | 534 | 536 | 593 | PK index is not used for derived tables |
|
13 | CS | 1052 | 672 | 1193 | 1164 | 1053 | 683 | 667 | 1237 | 679 | 1052 | 644 | 649 | 628 | 630 | 1143 | 1058 | 1116 | 1020 | 1013 | 1069 | 849 | 1163 | 771 | 1092 | 682 | 1159 | 1090 | 1154 | 987 | 1292 | 1175 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
14 | SS | 429 | 469 | 418 | 389 | 413 | 469 | 484 | 392 | 438 | 436 | 402 | 471 | 403 | 432 | 373 | 385 | 438 | 455 | 422 | 427 | 413 | 505 | 433 | 427 | 412 | 471 | 446 | 437 | 399 | 419 | 439 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
15 | CS | 1001 | 584 | 1014 | 1066 | 1024 | 1091 | 591 | 928 | 793 | 1081 | 572 | 660 | 590 | 647 | 1048 | 1069 | 910 | 958 | 1064 | 1114 | 612 | 950 | 716 | 988 | 632 | 1085 | 1060 | 1165 | 1172 | 1201 | 1132 | Broken error handling in the case of a conversion error happened during index creation |
|
16 | SS | 416 | 365 | 427 | 418 | 395 | 399 | 438 | 447 | 461 | 464 | 407 | 445 | 480 | 436 | 408 | 373 | 391 | 466 | 399 | 422 | 468 | 403 | 424 | 399 | 448 | 414 | 404 | 408 | 422 | 392 | 379 | Broken error handling in the case of a conversion error happened during index creation |
|
17 | CS | 1261 | 1194 | 1254 | 756 | 1256 | 1099 | 751 | 1383 | 1700 | 1355 | 865 | 789 | 788 | 712 | 1528 | 1266 | 1314 | 1086 | 1157 | 1365 | 786 | 1272 | 870 | 1356 | 758 | 1370 | 1269 | 1325 | 1300 | 1312 | 1318 | DROP VIEW drops output parameters of used stored procedures |
|
18 | SS | 538 | 447 | 512 | 532 | 536 | 512 | 546 | 495 | 592 | 631 | 540 | 570 | 583 | 547 | 529 | 521 | 558 | 559 | 526 | 507 | 574 | 536 | 492 | 583 | 570 | 540 | 537 | 522 | 574 | 504 | 588 | DROP VIEW drops output parameters of used stored procedures |
|
19 | CS | 1294 | 644 | 1239 | 906 | 740 | 781 | 1320 | 769 | 868 | 791 | 900 | 1412 | 954 | 725 | 1562 | 1522 | 1434 | 1304 | 1602 | 882 | 1444 | 1356 | 806 | 756 | 1433 | 1409 | 1437 | 1398 | 1285 | 1412 | 1386 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
20 | SS | 554 | 452 | 452 | 648 | 516 | 555 | 574 | 553 | 486 | 623 | 556 | 622 | 578 | 557 | 559 | 534 | 579 | 541 | 573 | 587 | 561 | 603 | 509 | 541 | 557 | 494 | 533 | 497 | 463 | 511 | 540 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
21 | CS | 1113 | 688 | 855 | 733 | 715 | 710 | 1423 | 767 | 838 | 804 | 799 | 1364 | 819 | 782 | 1359 | 1008 | 1428 | 1357 | 1212 | 1413 | 872 | 1300 | 952 | 1462 | 1015 | 1353 | 1303 | 1375 | 1388 | 1483 | 1444 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
22 | SS | 571 | 447 | 570 | 553 | 599 | 569 | 626 | 620 | 572 | 616 | 578 | 596 | 600 | 571 | 567 | 566 | 571 | 619 | 614 | 561 | 582 | 586 | 477 | 577 | 597 | 555 | 524 | 496 | 530 | 536 | 516 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
23 | CS | 1222 | 720 | 676 | 875 | 716 | 681 | 1229 | 671 | 835 | 670 | 726 | 1288 | 813 | 729 | 1131 | 1225 | 1219 | 1311 | 1320 | 1402 | 1301 | 1317 | 773 | 1312 | 1243 | 1268 | 1303 | 1350 | 1380 | 1385 | 1215 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
24 | SS | 546 | 538 | 500 | 536 | 502 | 569 | 572 | 613 | 528 | 539 | 550 | 583 | 614 | 544 | 545 | 532 | 538 | 521 | 567 | 544 | 561 | 489 | 554 | 542 | 593 | 602 | 557 | 572 | 533 | 547 | 548 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
25 | CS | 1413 | 959 | 765 | 824 | 704 | 787 | 1470 | 771 | 863 | 986 | 782 | 1760 | 838 | 832 | 1419 | 1597 | 1436 | 1592 | 1673 | 1902 | 1491 | 1664 | 1107 | 1629 | 1078 | 1732 | 1360 | 1714 | 1407 | 1576 | 1533 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
26 | SS | 876 | 904 | 645 | 708 | 692 | 762 | 893 | 813 | 837 | 903 | 722 | 909 | 785 | 884 | 874 | 906 | 899 | 852 | 921 | 845 | 921 | 844 | 939 | 988 | 879 | 869 | 882 | 893 | 806 | 904 | 827 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
27 | CS | 1271 | 605 | 1315 | 1358 | 1236 | 1218 | 719 | 1269 | 776 | 929 | 738 | 804 | 1315 | 788 | 1260 | 1338 | 1383 | 1304 | 1558 | 1361 | 1302 | 1516 | 867 | 1335 | 1247 | 793 | 1309 | 1205 | 1315 | 1274 | 1366 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
28 | SS | 537 | 431 | 430 | 538 | 531 | 482 | 576 | 495 | 561 | 621 | 504 | 558 | 602 | 565 | 511 | 539 | 561 | 532 | 553 | 509 | 598 | 498 | 527 | 573 | 555 | 517 | 522 | 537 | 538 | 580 | 499 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
29 | CS | 1093 | 1248 | 602 | 1142 | 591 | 1014 | 647 | 1106 | 688 | 813 | 601 | 826 | 934 | 670 | 1085 | 1143 | 1181 | 1192 | 1241 | 1079 | 1097 | 1212 | 720 | 1144 | 1233 | 1209 | 1066 | 1185 | 1128 | 1089 | 1180 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
30 | SS | 465 | 512 | 421 | 457 | 430 | 397 | 443 | 498 | 491 | 492 | 485 | 439 | 456 | 531 | 467 | 439 | 470 | 463 | 455 | 476 | 502 | 482 | 419 | 435 | 435 | 476 | 515 | 514 | 502 | 464 | 338 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
31 | CS | 1639 | 1703 | 1592 | 1634 | 1157 | 1663 | 1786 | 1642 | 2038 | 1334 | 916 | 1744 | 973 | 1730 | 1735 | 1694 | 1703 | 966 | 1499 | 1439 | 1536 | 1922 | 1074 | 1825 | 1762 | 1513 | 1928 | 1635 | 1637 | 1615 | 1819 | Cannot alter the domain after migrating from older versions |
|
32 | SS | 733 | 775 | 701 | 685 | 732 | 734 | 813 | 737 | 785 | 805 | 690 | 679 | 794 | 785 | 676 | 766 | 836 | 742 | 706 | 711 | 757 | 745 | 717 | 787 | 673 | 679 | 640 | 722 | 748 | 716 | 714 | Cannot alter the domain after migrating from older versions |
|
33 | CS | 1351 | 1295 | 1363 | 1266 | 1296 | 1424 | 1427 | 1189 | 1571 | 853 | 729 | 1430 | 739 | 1222 | 1348 | 1252 | 1446 | 801 | 1568 | 1511 | 1527 | 1358 | 855 | 1386 | 1404 | 1321 | 1109 | 1669 | 1380 | 1355 | 1290 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
34 | SS | 602 | 599 | 572 | 522 | 564 | 545 | 561 | 576 | 601 | 653 | 689 | 567 | 603 | 639 | 568 | 602 | 630 | 636 | 659 | 654 | 651 | 718 | 676 | 647 | 596 | 565 | 604 | 638 | 564 | 622 | 575 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
35 | CS | 1438 | 1518 | 832 | 1398 | 1507 | 1478 | 796 | 1395 | 1575 | 1153 | 820 | 846 | 1001 | 803 | 1576 | 1470 | 1589 | 1441 | 1760 | 1852 | 1306 | 1448 | 1069 | 1530 | 1435 | 1329 | 846 | 1490 | 1342 | 1618 | 1524 | Expression index with TRIM may lead to incorrect indexed lookup |
|
36 | SS | 661 | 614 | 624 | 604 | 625 | 564 | 647 | 599 | 656 | 773 | 664 | 672 | 691 | 649 | 636 | 711 | 671 | 704 | 773 | 702 | 679 | 677 | 639 | 636 | 716 | 701 | 625 | 676 | 638 | 659 | 676 | Expression index with TRIM may lead to incorrect indexed lookup |
|
37 | CS | 1289 | 1083 | 748 | 1353 | 1199 | 1313 | 951 | 1263 | 1335 | 845 | 761 | 947 | 945 | 752 | 1465 | 1275 | 1509 | 1443 | 1388 | 1675 | 1374 | 1193 | 888 | 1276 | 1302 | 1447 | 801 | 1332 | 1345 | 1356 | 1464 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
38 | SS | 548 | 376 | 541 | 500 | 493 | 479 | 525 | 590 | 599 | 558 | 592 | 567 | 603 | 586 | 534 | 559 | 518 | 581 | 590 | 553 | 536 | 519 | 514 | 572 | 550 | 547 | 482 | 577 | 501 | 569 | 539 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
39 | CS | 1311 | 1229 | 748 | 1266 | 1372 | 1376 | 739 | 1351 | 1299 | 946 | 749 | 819 | 947 | 1341 | 1637 | 1297 | 1382 | 1351 | 1553 | 1647 | 1364 | 833 | 841 | 1420 | 1366 | 1385 | 837 | 780 | 1389 | 1323 | 1269 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
40 | SS | 551 | 424 | 488 | 546 | 558 | 542 | 607 | 537 | 598 | 572 | 544 | 569 | 591 | 576 | 602 | 538 | 579 | 525 | 596 | 573 | 613 | 540 | 547 | 534 | 575 | 554 | 534 | 506 | 548 | 578 | 517 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
41 | CS | 1188 | 1179 | 690 | 1181 | 1151 | 1206 | 691 | 1196 | 1246 | 760 | 697 | 763 | 804 | 1263 | 1292 | 1314 | 1376 | 1286 | 1352 | 1382 | 1351 | 1285 | 818 | 1293 | 1332 | 881 | 757 | 702 | 1168 | 1281 | 1171 | UTF8 UNICODE_CI collate can not be used in compound index |
|
42 | SS | 469 | 452 | 452 | 430 | 470 | 448 | 485 | 577 | 562 | 464 | 505 | 468 | 541 | 485 | 467 | 464 | 527 | 489 | 583 | 453 | 476 | 487 | 490 | 459 | 428 | 426 | 420 | 449 | 471 | 508 | 463 | UTF8 UNICODE_CI collate can not be used in compound index |
|
43 | CS | 1041 | 1149 | 586 | 1012 | 936 | 1044 | 574 | 736 | 1109 | 681 | 617 | 639 | 736 | 1113 | 1187 | 1166 | 1149 | 1210 | 1210 | 1278 | 1206 | 1015 | 699 | 1075 | 1039 | 1105 | 1148 | 685 | 662 | 990 | 1261 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
44 | SS | 426 | 421 | 426 | 426 | 379 | 372 | 441 | 437 | 470 | 479 | 453 | 382 | 426 | 407 | 419 | 386 | 409 | 457 | 464 | 444 | 463 | 406 | 466 | 422 | 408 | 462 | 412 | 412 | 443 | 406 | 455 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
45 | CS | 1065 | 1090 | 645 | 1217 | 1012 | 1043 | 544 | 661 | 1309 | 825 | 677 | 638 | 749 | 1139 | 1114 | 1172 | 1352 | 1100 | 1236 | 1078 | 1211 | 1035 | 666 | 1072 | 1067 | 1063 | 602 | 1056 | 605 | 1095 | 1220 | "BLOB not found" error after creation/altering of the invalid trigger |
|
46 | SS | 425 | 452 | 456 | 353 | 401 | 441 | 493 | 402 | 469 | 487 | 426 | 394 | 417 | 420 | 418 | 403 | 394 | 446 | 417 | 442 | 425 | 415 | 432 | 444 | 404 | 404 | 428 | 449 | 477 | 420 | 428 | "BLOB not found" error after creation/altering of the invalid trigger |
|
47 | CS | 1278 | 1390 | 768 | 890 | 1200 | 900 | 751 | 788 | 1494 | 969 | 796 | 791 | 922 | 1300 | 1362 | 1281 | 1324 | 1366 | 1497 | 1662 | 1342 | 1276 | 821 | 787 | 1332 | 1488 | 1399 | 1339 | 795 | 813 | 1355 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
48 | SS | 558 | 515 | 516 | 489 | 513 | 533 | 599 | 558 | 610 | 666 | 566 | 582 | 566 | 548 | 524 | 558 | 559 | 602 | 594 | 588 | 568 | 536 | 536 | 520 | 524 | 466 | 562 | 549 | 520 | 575 | 575 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
49 | CS | 967 | 977 | 564 | 611 | 957 | 585 | 602 | 684 | 1080 | 765 | 642 | 636 | 700 | 1096 | 1177 | 1060 | 1293 | 999 | 1224 | 981 | 1430 | 1032 | 632 | 575 | 956 | 1052 | 1152 | 1060 | 590 | 594 | 1017 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
50 | SS | 402 | 370 | 386 | 375 | 360 | 404 | 406 | 399 | 430 | 411 | 432 | 420 | 429 | 432 | 349 | 421 | 400 | 395 | 389 | 434 | 450 | 382 | 393 | 376 | 370 | 410 | 423 | 414 | 436 | 373 | 358 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
51 | CS | 1064 | 1237 | 664 | 599 | 1083 | 582 | 739 | 638 | 1137 | 758 | 910 | 602 | 692 | 1151 | 1104 | 1152 | 1074 | 1158 | 1555 | 1134 | 1051 | 1054 | 627 | 1081 | 1078 | 1162 | 1037 | 1086 | 1114 | 574 | 625 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
52 | SS | 425 | 393 | 360 | 443 | 425 | 409 | 472 | 408 | 462 | 500 | 435 | 429 | 423 | 397 | 405 | 414 | 441 | 426 | 421 | 478 | 472 | 503 | 423 | 448 | 414 | 407 | 450 | 462 | 421 | 382 | 449 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
53 | CS | 1021 | 1093 | 680 | 604 | 1030 | 699 | 734 | 579 | 1076 | 727 | 569 | 641 | 628 | 1092 | 988 | 1025 | 1152 | 1069 | 1225 | 1095 | 1090 | 1070 | 652 | 1087 | 1087 | 1017 | 961 | 1192 | 998 | 1078 | 654 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
54 | SS | 410 | 375 | 452 | 372 | 418 | 426 | 460 | 458 | 453 | 483 | 408 | 465 | 402 | 396 | 411 | 426 | 415 | 420 | 384 | 415 | 474 | 409 | 409 | 386 | 405 | 361 | 385 | 396 | 418 | 409 | 368 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
55 | CS | 1676 | 1626 | 998 | 1008 | 1982 | 1028 | 995 | 1064 | 1880 | 1317 | 972 | 1078 | 1181 | 1969 | 1733 | 1717 | 2003 | 1880 | 2100 | 1748 | 1963 | 1755 | 1120 | 1653 | 1719 | 1682 | 1596 | 1778 | 952 | 1671 | 1687 | Generators are set to 0 after restore |
|
56 | SS | 815 | 822 | 866 | 860 | 846 | 737 | 832 | 815 | 913 | 987 | 799 | 826 | 837 | 859 | 770 | 779 | 778 | 777 | 772 | 855 | 846 | 733 | 761 | 816 | 828 | 726 | 808 | 720 | 749 | 755 | 823 | Generators are set to 0 after restore |
|
57 | CS | 1277 | 774 | 792 | 715 | 1351 | 706 | 785 | 781 | 1388 | 968 | 765 | 883 | 839 | 1182 | 1270 | 1364 | 1372 | 1328 | 1629 | 1450 | 1339 | 1217 | 856 | 1296 | 1390 | 1367 | 1407 | 1252 | 1405 | 1284 | 1365 | Blob filter to translate internal debug info into text representation |
|
58 | SS | 529 | 565 | 538 | 518 | 533 | 462 | 565 | 529 | 514 | 557 | 516 | 592 | 573 | 524 | 529 | 529 | 542 | 522 | 511 | 585 | 548 | 555 | 543 | 511 | 571 | 521 | 501 | 509 | 516 | 529 | 489 | Blob filter to translate internal debug info into text representation |
|
59 | CS | 1041 | 666 | 561 | 658 | 1009 | 648 | 1127 | 656 | 1148 | 745 | 573 | 590 | 732 | 1154 | 1044 | 1055 | 1134 | 1049 | 1185 | 1178 | 1036 | 1038 | 623 | 1135 | 1064 | 1063 | 647 | 1156 | 1073 | 565 | 1074 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
60 | SS | 414 | 490 | 387 | 469 | 398 | 367 | 494 | 407 | 415 | 497 | 407 | 564 | 414 | 383 | 437 | 405 | 413 | 410 | 481 | 457 | 474 | 462 | 420 | 404 | 434 | 377 | 390 | 414 | 385 | 454 | 391 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
61 | CS | 1396 | 848 | 879 | 844 | 1391 | 828 | 937 | 865 | 1701 | 950 | 919 | 1872 | 1055 | 1748 | 1612 | 1263 | 1618 | 1482 | 1750 | 1472 | 1510 | 1492 | 979 | 1319 | 1470 | 1544 | 922 | 1402 | 1245 | 1416 | 1471 | Recurse leads to hangs/crash server |
|
62 | SS | 691 | 696 | 721 | 688 | 661 | 744 | 764 | 813 | 829 | 708 | 690 | 768 | 715 | 714 | 689 | 644 | 664 | 708 | 669 | 694 | 656 | 704 | 666 | 693 | 679 | 663 | 692 | 686 | 660 | 657 | 663 | Recurse leads to hangs/crash server |
|
63 | CS | 1282 | 610 | 751 | 711 | 1287 | 767 | 762 | 1151 | 874 | 889 | 848 | 1520 | 870 | 1283 | 1496 | 1341 | 1371 | 1298 | 1456 | 1421 | 1400 | 1415 | 822 | 1281 | 1393 | 1272 | 756 | 746 | 1312 | 1365 | 1335 | [FB3] AV with "UPDATE OR INSERT" |
|
64 | SS | 552 | 491 | 535 | 519 | 547 | 541 | 583 | 534 | 634 | 538 | 554 | 579 | 539 | 569 | 585 | 566 | 571 | 649 | 601 | 509 | 532 | 614 | 563 | 573 | 573 | 533 | 534 | 544 | 550 | 524 | 565 | [FB3] AV with "UPDATE OR INSERT" |
|
65 | CS | 1111 | 633 | 605 | 1167 | 1014 | 1132 | 1165 | 615 | 682 | 854 | 618 | 1235 | 809 | 1116 | 1165 | 1167 | 1107 | 1197 | 1217 | 1139 | 957 | 1200 | 684 | 1242 | 659 | 867 | 1231 | 672 | 1167 | 1087 | 1351 | Inefficient optimization (regression) |
|
66 | SS | 485 | 537 | 475 | 476 | 435 | 447 | 475 | 550 | 514 | 508 | 459 | 424 | 554 | 519 | 448 | 495 | 490 | 475 | 484 | 498 | 456 | 565 | 486 | 467 | 489 | 396 | 490 | 471 | 463 | 508 | 541 | Inefficient optimization (regression) |
|
67 | CS | 1845 | 1200 | 1120 | 1149 | 1102 | 1170 | 1757 | 1133 | 1206 | 1803 | 1184 | 2548 | 1659 | 2045 | 2820 | 2621 | 2102 | 2787 | 2747 | 3459 | 1995 | 2483 | 1756 | 1872 | 1755 | 1335 | 2704 | 1818 | 2027 | 2282 | 2391 | Regression in joins on procedures |
|
68 | SS | 1477 | 1569 | 1487 | 1175 | 1148 | 1340 | 1377 | 1403 | 1543 | 1378 | 1183 | 1268 | 1415 | 1403 | 1442 | 1644 | 1586 | 1562 | 1652 | 1526 | 1567 | 1656 | 1579 | 1477 | 1478 | 1436 | 1453 | 1486 | 1587 | 1455 | 1656 | Regression in joins on procedures |
|
69 | CS | 1281 | 689 | 702 | 686 | 716 | 803 | 1249 | 750 | 797 | 987 | 893 | 1556 | 1045 | 1313 | 1259 | 1303 | 1388 | 1384 | 1342 | 1596 | 1428 | 1327 | 836 | 1336 | 1413 | 826 | 1548 | 1340 | 778 | 1361 | 1451 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
70 | SS | 554 | 430 | 525 | 524 | 544 | 495 | 555 | 556 | 573 | 620 | 604 | 545 | 568 | 555 | 589 | 569 | 586 | 616 | 601 | 538 | 596 | 586 | 529 | 553 | 470 | 549 | 541 | 479 | 536 | 541 | 572 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
71 | CS | 1264 | 674 | 727 | 722 | 1237 | 723 | 1291 | 697 | 753 | 989 | 732 | 1567 | 879 | 1384 | 1374 | 1350 | 1357 | 1319 | 1426 | 1433 | 1384 | 1363 | 837 | 1401 | 1378 | 715 | 1265 | 1415 | 806 | 1255 | 1264 | DROP VIEW ignores the existing non-column dependencies |
|
72 | SS | 549 | 447 | 499 | 572 | 526 | 490 | 598 | 556 | 612 | 549 | 523 | 551 | 621 | 565 | 498 | 533 | 552 | 605 | 563 | 582 | 524 | 533 | 510 | 520 | 550 | 532 | 550 | 531 | 569 | 526 | 562 | DROP VIEW ignores the existing non-column dependencies |
|
73 | CS | 1272 | 767 | 699 | 1245 | 1229 | 930 | 1327 | 741 | 785 | 998 | 771 | 1541 | 961 | 1297 | 1368 | 1349 | 1354 | 1388 | 1476 | 1461 | 1296 | 1348 | 815 | 1294 | 1251 | 848 | 736 | 1307 | 1147 | 1296 | 1315 | Alter procedure allows to add the parameter with the same name |
|
74 | SS | 544 | 519 | 516 | 454 | 470 | 534 | 577 | 525 | 569 | 549 | 513 | 589 | 549 | 544 | 536 | 496 | 564 | 567 | 561 | 605 | 593 | 522 | 511 | 546 | 582 | 555 | 544 | 567 | 521 | 539 | 528 | Alter procedure allows to add the parameter with the same name |
|
75 | CS | 943 | 624 | 595 | 569 | 949 | 607 | 1038 | 674 | 607 | 695 | 624 | 1376 | 732 | 558 | 978 | 1019 | 1215 | 1073 | 1118 | 1184 | 1227 | 1132 | 633 | 1019 | 1251 | 588 | 646 | 984 | 1071 | 742 | 938 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
76 | SS | 439 | 382 | 401 | 367 | 413 | 388 | 491 | 452 | 469 | 411 | 439 | 445 | 472 | 423 | 420 | 413 | 439 | 441 | 452 | 414 | 519 | 433 | 435 | 409 | 448 | 458 | 423 | 460 | 457 | 466 | 448 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
77 | CS | 1104 | 644 | 673 | 623 | 1213 | 682 | 1217 | 650 | 680 | 718 | 787 | 1227 | 811 | 1112 | 1216 | 1139 | 1179 | 1128 | 1306 | 1294 | 1222 | 1220 | 757 | 1246 | 1156 | 705 | 669 | 894 | 1160 | 1097 | 726 | Inconsistent domain's constraint validation in PSQL |
|
78 | SS | 496 | 504 | 457 | 465 | 481 | 441 | 508 | 490 | 560 | 524 | 473 | 515 | 525 | 561 | 467 | 497 | 483 | 467 | 514 | 513 | 581 | 483 | 526 | 496 | 491 | 451 | 509 | 523 | 489 | 528 | 489 | Inconsistent domain's constraint validation in PSQL |
|
79 | CS | 1280 | 1115 | 1407 | 743 | 1273 | 812 | 1345 | 709 | 855 | 897 | 767 | 1459 | 885 | 1380 | 1272 | 1388 | 1356 | 1388 | 1558 | 1545 | 1430 | 1456 | 883 | 1240 | 1287 | 774 | 1384 | 772 | 1377 | 1288 | 859 | Floating-point negative zero doesn't match positive zero in the index |
|
80 | SS | 543 | 632 | 511 | 528 | 542 | 542 | 581 | 543 | 633 | 562 | 581 | 532 | 578 | 569 | 571 | 501 | 605 | 522 | 524 | 544 | 622 | 516 | 518 | 590 | 598 | 526 | 524 | 548 | 516 | 596 | 529 | Floating-point negative zero doesn't match positive zero in the index |
|
81 | CS | 993 | 840 | 1039 | 558 | 991 | 576 | 977 | 598 | 633 | 711 | 586 | 1096 | 660 | 995 | 1155 | 1047 | 1080 | 1116 | 1201 | 1079 | 1110 | 1091 | 694 | 1027 | 1063 | 661 | 964 | 1029 | 929 | 979 | 1158 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
82 | SS | 398 | 434 | 363 | 369 | 355 | 356 | 401 | 395 | 441 | 487 | 376 | 449 | 433 | 417 | 363 | 381 | 408 | 411 | 409 | 404 | 390 | 398 | 467 | 375 | 398 | 344 | 401 | 388 | 383 | 426 | 393 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
83 | CS | 1250 | 778 | 1370 | 879 | 913 | 767 | 1220 | 775 | 804 | 916 | 779 | 1408 | 946 | 936 | 1367 | 1392 | 1266 | 1437 | 1436 | 1492 | 1532 | 1265 | 834 | 1325 | 1538 | 787 | 1360 | 816 | 1235 | 1408 | 1442 | CHAR(32767) present in XSQLVAR with length 32765 |
|
84 | SS | 605 | 591 | 616 | 528 | 533 | 523 | 586 | 562 | 620 | 632 | 614 | 605 | 606 | 565 | 572 | 556 | 623 | 645 | 584 | 567 | 641 | 705 | 653 | 556 | 618 | 569 | 605 | 623 | 624 | 584 | 691 | CHAR(32767) present in XSQLVAR with length 32765 |
|
85 | CS | 1042 | 647 | 941 | 611 | 1038 | 607 | 981 | 558 | 613 | 705 | 567 | 1185 | 719 | 1267 | 1127 | 1178 | 1033 | 1096 | 1185 | 1270 | 1156 | 1068 | 681 | 1140 | 1046 | 617 | 1023 | 1103 | 1102 | 1066 | 1147 | Include expected and actual string lenght into error message for sqlcode -802 |
|
86 | SS | 429 | 436 | 387 | 357 | 408 | 407 | 467 | 392 | 432 | 431 | 419 | 434 | 448 | 450 | 448 | 421 | 433 | 493 | 385 | 428 | 435 | 443 | 353 | 377 | 425 | 376 | 405 | 444 | 460 | 476 | 382 | Include expected and actual string lenght into error message for sqlcode -802 |
|
87 | CS | 3964 | 3045 | 4459 | 3026 | 4235 | 2926 | 3426 | 2893 | 2963 | 3094 | 3121 | 4522 | 3059 | 4504 | 3444 | 4543 | 4567 | 4340 | 3991 | 4708 | 4589 | 3531 | 3094 | 4477 | 4447 | 3066 | 3938 | 4573 | 3127 | 4661 | 4563 | TRACE: add statistics of actions that were after transaction finished |
|
88 | SS | 2732 | 2795 | 2709 | 2737 | 2669 | 2699 | 2753 | 2717 | 2816 | 2724 | 2772 | 2695 | 2762 | 2770 | 2677 | 2773 | 2730 | 2796 | 2693 | 2692 | 2785 | 2746 | 2641 | 2764 | 2730 | 2734 | 2766 | 2678 | 2704 | 2704 | 2785 | TRACE: add statistics of actions that were after transaction finished |
|
89 | CS | 1208 | 1242 | 1258 | 703 | 878 | 670 | 1125 | 653 | 1196 | 882 | 1048 | 1354 | 878 | 702 | 1278 | 1221 | 1260 | 1348 | 1415 | 1350 | 1229 | 1165 | 811 | 1190 | 1310 | 747 | 1343 | 1365 | 833 | 1226 | 1274 | Can insert DUPLICATE keys in UNIQUE index |
|
90 | SS | 477 | 463 | 399 | 434 | 421 | 506 | 460 | 482 | 436 | 482 | 509 | 527 | 498 | 529 | 449 | 480 | 445 | 435 | 466 | 478 | 522 | 476 | 433 | 498 | 534 | 429 | 399 | 459 | 489 | 499 | 484 | Can insert DUPLICATE keys in UNIQUE index |
|
91 | CS | 1057 | 660 | 1092 | 596 | 998 | 616 | 1092 | 611 | 605 | 673 | 633 | 1001 | 787 | 1041 | 1045 | 1177 | 1094 | 1120 | 1140 | 1303 | 1091 | 1069 | 723 | 1188 | 1253 | 819 | 1282 | 1102 | 1103 | 696 | 1116 | Server crashes with access violation when inserting row into table with unique index |
|
92 | SS | 432 | 456 | 414 | 494 | 402 | 368 | 464 | 458 | 409 | 435 | 397 | 490 | 471 | 387 | 451 | 405 | 393 | 475 | 392 | 484 | 459 | 454 | 430 | 395 | 425 | 428 | 415 | 397 | 443 | 445 | 446 | Server crashes with access violation when inserting row into table with unique index |
|
93 | CS | 1115 | 637 | 1224 | 1159 | 965 | 616 | 1059 | 832 | 635 | 707 | 1130 | 1449 | 894 | 974 | 1233 | 1216 | 1375 | 1230 | 1291 | 1323 | 1240 | 1048 | 819 | 1236 | 1100 | 773 | 1259 | 1235 | 1222 | 1052 | 686 | computed index by substring function for long columns |
|
94 | SS | 453 | 461 | 462 | 446 | 471 | 437 | 479 | 436 | 497 | 467 | 423 | 525 | 502 | 521 | 427 | 449 | 478 | 482 | 456 | 445 | 426 | 546 | 442 | 451 | 448 | 447 | 438 | 513 | 425 | 424 | 522 | computed index by substring function for long columns |
|
95 | CS | 1037 | 595 | 957 | 983 | 1068 | 1035 | 988 | 560 | 1117 | 749 | 610 | 1150 | 713 | 1039 | 1118 | 984 | 1115 | 1058 | 1168 | 1283 | 1047 | 1125 | 694 | 1129 | 1222 | 645 | 647 | 994 | 1061 | 586 | 1120 | Wrong warning message for ambiguous query |
|
96 | SS | 422 | 429 | 438 | 394 | 349 | 376 | 458 | 436 | 420 | 470 | 535 | 592 | 679 | 396 | 432 | 415 | 367 | 365 | 371 | 434 | 447 | 422 | 386 | 455 | 453 | 396 | 381 | 345 | 370 | 438 | 423 | Wrong warning message for ambiguous query |
|
97 | CS | 1019 | 622 | 1027 | 1051 | 1067 | 926 | 1014 | 594 | 782 | 708 | 645 | 1383 | 715 | 1029 | 1105 | 952 | 1165 | 1036 | 1219 | 1069 | 1120 | 1116 | 664 | 1024 | 1058 | 626 | 595 | 1012 | 1012 | 787 | 1047 | Wrong warning message for ambiguous query |
|
98 | SS | 401 | 386 | 353 | 381 | 378 | 421 | 409 | 430 | 435 | 441 | 350 | 418 | 454 | 456 | 425 | 396 | 360 | 350 | 398 | 457 | 390 | 401 | 390 | 340 | 400 | 408 | 426 | 408 | 402 | 441 | 395 | Wrong warning message for ambiguous query |
|
99 | CS | 1056 | 638 | 1085 | 1061 | 918 | 1037 | 1009 | 669 | 718 | 700 | 564 | 1188 | 785 | 772 | 1016 | 1273 | 1127 | 1156 | 1187 | 1172 | 1126 | 1162 | 723 | 1059 | 1053 | 572 | 635 | 1091 | 1104 | 1076 | 1119 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
100 | SS | 433 | 507 | 405 | 413 | 402 | 398 | 457 | 400 | 524 | 429 | 490 | 425 | 438 | 509 | 417 | 450 | 450 | 468 | 410 | 453 | 480 | 441 | 407 | 410 | 459 | 407 | 449 | 429 | 419 | 424 | 459 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
101 | CS | 1210 | 598 | 1372 | 716 | 773 | 772 | 1224 | 792 | 794 | 903 | 828 | 834 | 798 | 1369 | 1339 | 1304 | 1392 | 1292 | 1351 | 1439 | 1327 | 1336 | 915 | 1197 | 1274 | 867 | 847 | 805 | 1240 | 1228 | 1293 | IS NOT DISTINCT FROM NULL doesn't use index |
|
102 | SS | 545 | 408 | 529 | 507 | 478 | 677 | 588 | 548 | 572 | 524 | 473 | 639 | 582 | 601 | 550 | 540 | 506 | 531 | 550 | 568 | 583 | 512 | 516 | 571 | 558 | 555 | 542 | 497 | 521 | 528 | 560 | IS NOT DISTINCT FROM NULL doesn't use index |
|
103 | CS | 2210 | 1246 | 2203 | 2413 | 1307 | 2465 | 2214 | 2496 | 1456 | 1542 | 1311 | 1456 | 1530 | 1385 | 2311 | 2432 | 2258 | 2255 | 2490 | 2628 | 2224 | 2221 | 1499 | 2357 | 2207 | 1439 | 1456 | 1536 | 2191 | 2380 | 2400 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
104 | SS | 874 | 932 | 811 | 826 | 819 | 895 | 1008 | 923 | 962 | 893 | 805 | 890 | 942 | 881 | 826 | 857 | 896 | 845 | 819 | 958 | 929 | 786 | 844 | 978 | 914 | 846 | 896 | 801 | 835 | 850 | 868 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
105 | CS | 3354 | 2024 | 3262 | 3598 | 1812 | 3343 | 3374 | 3364 | 1968 | 2368 | 1864 | 2191 | 2182 | 1861 | 3344 | 3758 | 3634 | 3489 | 3717 | 3668 | 3401 | 3426 | 2238 | 3479 | 3622 | 2185 | 1968 | 2103 | 3556 | 3779 | 3642 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
106 | SS | 1305 | 1264 | 1108 | 1270 | 1154 | 1223 | 1399 | 1185 | 1406 | 1391 | 1169 | 1309 | 1356 | 1381 | 1327 | 1226 | 1321 | 1389 | 1419 | 1326 | 1265 | 1217 | 1287 | 1314 | 1193 | 1301 | 1320 | 1219 | 1247 | 1360 | 1312 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
107 | CS | 1251 | 991 | 1316 | 1322 | 722 | 1258 | 1293 | 1289 | 724 | 907 | 800 | 808 | 908 | 795 | 1185 | 1276 | 1289 | 1244 | 1368 | 1454 | 1347 | 1299 | 809 | 1348 | 1286 | 867 | 737 | 772 | 1191 | 1347 | 1396 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
108 | SS | 529 | 430 | 487 | 446 | 476 | 513 | 532 | 505 | 567 | 601 | 558 | 556 | 557 | 503 | 490 | 492 | 552 | 586 | 548 | 505 | 570 | 556 | 564 | 506 | 521 | 538 | 501 | 564 | 549 | 527 | 486 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
109 | CS | 999 | 634 | 1063 | 1129 | 686 | 1109 | 666 | 1016 | 594 | 738 | 684 | 591 | 717 | 581 | 1011 | 1062 | 1145 | 987 | 1098 | 1268 | 1027 | 1068 | 731 | 1066 | 1135 | 740 | 624 | 576 | 685 | 1094 | 1093 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
110 | SS | 401 | 416 | 395 | 366 | 409 | 408 | 428 | 367 | 486 | 375 | 411 | 368 | 457 | 405 | 393 | 430 | 400 | 402 | 421 | 367 | 455 | 392 | 398 | 402 | 387 | 361 | 411 | 396 | 442 | 398 | 401 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
111 | CS | 1022 | 624 | 954 | 1104 | 793 | 1023 | 658 | 1108 | 1049 | 693 | 1156 | 666 | 726 | 627 | 1021 | 1225 | 1200 | 1099 | 1093 | 1233 | 1111 | 1065 | 754 | 1027 | 1109 | 739 | 626 | 616 | 644 | 635 | 1280 | Extend the error reported for index/constraint violations to include the problematic key value |
|
112 | SS | 463 | 472 | 441 | 458 | 461 | 465 | 471 | 416 | 501 | 555 | 510 | 447 | 507 | 480 | 456 | 488 | 461 | 496 | 407 | 450 | 461 | 423 | 478 | 489 | 448 | 377 | 456 | 490 | 416 | 488 | 484 | Extend the error reported for index/constraint violations to include the problematic key value |
|
113 | CS | 850 | 608 | 1108 | 1107 | 755 | 1052 | 1104 | 977 | 554 | 734 | 596 | 623 | 756 | 699 | 945 | 1048 | 1148 | 1017 | 1216 | 1341 | 1220 | 1103 | 715 | 1032 | 1122 | 737 | 652 | 621 | 610 | 670 | 722 | Wrong numbers in error message for decreasing char/varchar columns |
|
114 | SS | 430 | 459 | 444 | 432 | 401 | 461 | 408 | 456 | 513 | 431 | 442 | 461 | 490 | 399 | 441 | 417 | 426 | 425 | 391 | 407 | 430 | 469 | 412 | 429 | 449 | 393 | 405 | 447 | 365 | 419 | 435 | Wrong numbers in error message for decreasing char/varchar columns |
|
115 | CS | 851 | 603 | 944 | 1127 | 758 | 1025 | 1003 | 967 | 622 | 640 | 613 | 630 | 738 | 600 | 1007 | 1049 | 1058 | 1054 | 1142 | 1324 | 1105 | 1060 | 620 | 1011 | 959 | 660 | 643 | 574 | 613 | 625 | 715 | Derived fields may not be optimized via an index |
|
116 | SS | 402 | 442 | 377 | 421 | 429 | 376 | 438 | 402 | 473 | 415 | 418 | 396 | 369 | 385 | 406 | 455 | 399 | 427 | 359 | 384 | 401 | 387 | 393 | 425 | 389 | 407 | 392 | 446 | 349 | 421 | 402 | Derived fields may not be optimized via an index |
|
117 | CS | 888 | 1161 | 583 | 697 | 616 | 988 | 788 | 1069 | 1037 | 767 | 1081 | 609 | 712 | 757 | 1136 | 1036 | 1063 | 1181 | 1220 | 1059 | 1140 | 1090 | 787 | 1029 | 1162 | 675 | 698 | 785 | 644 | 618 | 613 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
118 | SS | 434 | 455 | 464 | 388 | 395 | 408 | 440 | 406 | 459 | 500 | 453 | 441 | 492 | 416 | 350 | 462 | 385 | 423 | 400 | 419 | 443 | 434 | 414 | 507 | 428 | 441 | 481 | 427 | 491 | 435 | 410 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
119 | CS | 1290 | 1396 | 923 | 955 | 979 | 1320 | 828 | 1260 | 1480 | 975 | 1362 | 1492 | 899 | 972 | 1527 | 1413 | 1474 | 1478 | 1466 | 1655 | 1384 | 1461 | 958 | 1528 | 1512 | 922 | 867 | 778 | 802 | 827 | 834 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
120 | SS | 606 | 633 | 525 | 642 | 516 | 582 | 596 | 590 | 634 | 617 | 611 | 646 | 681 | 554 | 631 | 546 | 633 | 621 | 643 | 575 | 595 | 701 | 594 | 687 | 624 | 522 | 557 | 602 | 537 | 602 | 654 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
121 | CS | 1020 | 1105 | 705 | 728 | 736 | 1061 | 650 | 1099 | 1138 | 746 | 1020 | 1160 | 749 | 701 | 1164 | 1021 | 1166 | 1157 | 1166 | 1129 | 1089 | 1120 | 731 | 1311 | 1058 | 728 | 650 | 646 | 728 | 601 | 671 | isql doesn't know the difference between UDF's and psql-functions |
|
122 | SS | 453 | 465 | 398 | 429 | 454 | 437 | 470 | 443 | 452 | 551 | 437 | 420 | 448 | 484 | 399 | 458 | 476 | 485 | 458 | 430 | 444 | 431 | 417 | 474 | 473 | 500 | 476 | 451 | 365 | 455 | 464 | isql doesn't know the difference between UDF's and psql-functions |
|
123 | CS | 987 | 1137 | 552 | 632 | 679 | 1015 | 1066 | 1002 | 1112 | 637 | 973 | 1080 | 719 | 670 | 1212 | 1172 | 1189 | 1124 | 1129 | 1211 | 1111 | 1089 | 676 | 1056 | 954 | 650 | 636 | 652 | 579 | 623 | 661 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
124 | SS | 412 | 469 | 432 | 374 | 456 | 381 | 447 | 401 | 432 | 413 | 472 | 362 | 403 | 516 | 417 | 432 | 366 | 370 | 380 | 387 | 429 | 379 | 402 | 412 | 384 | 435 | 440 | 429 | 349 | 394 | 435 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
125 | CS | 1033 | 1176 | 621 | 793 | 739 | 1123 | 576 | 1030 | 1231 | 701 | 1178 | 1082 | 670 | 711 | 1037 | 1124 | 1173 | 1143 | 1218 | 1350 | 1257 | 1130 | 685 | 1138 | 1088 | 696 | 612 | 627 | 632 | 657 | 677 | Join using RDB$DB_KEY produce NATURAL plan |
|
126 | SS | 450 | 449 | 405 | 409 | 382 | 498 | 450 | 508 | 464 | 653 | 450 | 471 | 432 | 460 | 392 | 436 | 419 | 451 | 479 | 482 | 420 | 481 | 431 | 473 | 485 | 428 | 454 | 461 | 423 | 436 | 472 | Join using RDB$DB_KEY produce NATURAL plan |
|
127 | CS | 1060 | 1179 | 574 | 641 | 703 | 1080 | 804 | 1156 | 1101 | 739 | 1104 | 1176 | 788 | 773 | 1030 | 1041 | 1084 | 1185 | 1222 | 1336 | 1221 | 1169 | 746 | 1135 | 1132 | 1227 | 692 | 672 | 648 | 740 | 617 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
128 | SS | 442 | 462 | 399 | 378 | 408 | 425 | 442 | 737 | 653 | 458 | 411 | 473 | 457 | 448 | 437 | 435 | 428 | 442 | 492 | 494 | 411 | 471 | 433 | 410 | 443 | 432 | 486 | 502 | 420 | 425 | 449 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
129 | CS | 1192 | 1106 | 896 | 802 | 899 | 1239 | 1165 | 1250 | 1381 | 880 | 1220 | 1160 | 871 | 862 | 1337 | 1283 | 1385 | 1407 | 1485 | 1462 | 1422 | 1348 | 887 | 1266 | 1405 | 1348 | 787 | 718 | 757 | 789 | 768 | Broken optimization for the stored dbkeys |
|
130 | SS | 554 | 450 | 595 | 521 | 515 | 517 | 574 | 499 | 606 | 511 | 567 | 609 | 519 | 527 | 509 | 485 | 520 | 586 | 584 | 511 | 543 | 481 | 743 | 710 | 759 | 647 | 774 | 703 | 587 | 535 | 566 | Broken optimization for the stored dbkeys |
|
131 | CS | 985 | 1176 | 583 | 603 | 690 | 966 | 578 | 987 | 1111 | 680 | 983 | 1219 | 747 | 705 | 1075 | 1141 | 1160 | 1133 | 1125 | 1190 | 1164 | 1154 | 724 | 987 | 1060 | 1137 | 632 | 648 | 600 | 626 | 645 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
132 | SS | 425 | 445 | 403 | 404 | 364 | 433 | 493 | 406 | 442 | 462 | 489 | 479 | 426 | 408 | 433 | 377 | 396 | 408 | 426 | 398 | 442 | 424 | 434 | 393 | 442 | 437 | 398 | 406 | 414 | 425 | 457 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
133 | CS | 1242 | 1097 | 751 | 757 | 919 | 1339 | 1308 | 1223 | 1323 | 878 | 1292 | 1038 | 873 | 820 | 1302 | 1388 | 1433 | 1284 | 1323 | 1417 | 1315 | 1361 | 806 | 1264 | 1261 | 1276 | 730 | 824 | 775 | 708 | 784 | Computed by columns and position function |
|
134 | SS | 544 | 443 | 491 | 510 | 498 | 540 | 573 | 465 | 584 | 563 | 515 | 498 | 578 | 566 | 552 | 514 | 570 | 539 | 586 | 550 | 543 | 537 | 594 | 538 | 529 | 530 | 564 | 545 | 549 | 701 | 668 | Computed by columns and position function |
|
135 | CS | 1231 | 1088 | 768 | 812 | 890 | 1306 | 1328 | 1207 | 1297 | 856 | 1273 | 785 | 894 | 864 | 1452 | 1368 | 1351 | 1304 | 1493 | 1369 | 1336 | 1256 | 841 | 1296 | 1323 | 1363 | 709 | 817 | 825 | 732 | 761 | Server bugchecks or crashes on exception in calculated index |
|
136 | SS | 539 | 472 | 495 | 523 | 481 | 573 | 591 | 576 | 547 | 586 | 555 | 556 | 528 | 537 | 520 | 521 | 561 | 571 | 516 | 517 | 571 | 541 | 545 | 524 | 551 | 528 | 593 | 519 | 559 | 524 | 492 | Server bugchecks or crashes on exception in calculated index |
|
137 | CS | 975 | 1011 | 565 | 587 | 718 | 1044 | 840 | 952 | 998 | 699 | 1097 | 642 | 676 | 692 | 1020 | 1059 | 1190 | 1140 | 1055 | 1219 | 1049 | 1005 | 678 | 1179 | 1151 | 1145 | 617 | 601 | 583 | 584 | 640 | Regression: Group by fails if subselect-column is involved |
|
138 | SS | 407 | 419 | 394 | 424 | 376 | 400 | 412 | 369 | 449 | 430 | 432 | 396 | 402 | 388 | 450 | 400 | 389 | 412 | 431 | 424 | 403 | 359 | 446 | 382 | 391 | 395 | 437 | 431 | 415 | 402 | 441 | Regression: Group by fails if subselect-column is involved |
|
139 | CS | 714 | 1175 | 661 | 578 | 684 | 635 | 624 | 637 | 1167 | 692 | 589 | 965 | 675 | 736 | 1204 | 1013 | 1100 | 1027 | 1180 | 1128 | 1039 | 1147 | 672 | 927 | 1011 | 1057 | 626 | 621 | 683 | 590 | 671 | Bad optimization of OR predicates applied to unions |
|
140 | SS | 401 | 370 | 402 | 427 | 396 | 347 | 402 | 432 | 481 | 435 | 419 | 456 | 416 | 395 | 396 | 401 | 383 | 393 | 420 | 426 | 398 | 391 | 437 | 399 | 390 | 365 | 377 | 408 | 397 | 436 | 414 | Bad optimization of OR predicates applied to unions |
|
141 | CS | 1076 | 1365 | 748 | 926 | 857 | 744 | 797 | 1237 | 1318 | 857 | 809 | 1139 | 951 | 1014 | 1352 | 1501 | 1332 | 1278 | 1359 | 1400 | 1403 | 1391 | 955 | 1333 | 1192 | 1414 | 784 | 764 | 789 | 731 | 774 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
142 | SS | 576 | 583 | 523 | 539 | 544 | 587 | 565 | 579 | 638 | 676 | 546 | 625 | 590 | 513 | 574 | 585 | 551 | 565 | 579 | 646 | 549 | 515 | 599 | 556 | 557 | 526 | 603 | 587 | 496 | 611 | 593 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
143 | CS | 962 | 1004 | 705 | 772 | 826 | 713 | 860 | 1239 | 1282 | 848 | 748 | 1273 | 897 | 920 | 1427 | 1328 | 1503 | 1282 | 1346 | 1522 | 1314 | 1241 | 843 | 1367 | 1377 | 1290 | 723 | 820 | 743 | 886 | 801 | Expression index may be not used for derived fields or view fields |
|
144 | SS | 530 | 445 | 496 | 487 | 519 | 504 | 608 | 522 | 566 | 528 | 583 | 553 | 576 | 540 | 526 | 500 | 531 | 560 | 502 | 581 | 557 | 510 | 585 | 558 | 498 | 530 | 544 | 577 | 512 | 569 | 507 | Expression index may be not used for derived fields or view fields |
|
145 | CS | 901 | 1036 | 597 | 653 | 796 | 691 | 659 | 1044 | 1011 | 625 | 655 | 1174 | 695 | 753 | 1260 | 1071 | 1216 | 1084 | 1177 | 1243 | 1103 | 1116 | 720 | 1058 | 1006 | 1164 | 624 | 591 | 641 | 626 | 624 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
146 | SS | 409 | 435 | 411 | 376 | 378 | 396 | 453 | 408 | 473 | 479 | 411 | 437 | 386 | 432 | 455 | 424 | 395 | 391 | 397 | 448 | 407 | 419 | 427 | 387 | 469 | 349 | 407 | 377 | 355 | 430 | 402 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
147 | CS | 1359 | 1519 | 767 | 862 | 1031 | 1386 | 793 | 1400 | 1417 | 931 | 890 | 1510 | 962 | 966 | 1432 | 1431 | 1582 | 1439 | 1456 | 1490 | 1332 | 1473 | 1081 | 1584 | 1406 | 1535 | 861 | 776 | 838 | 859 | 875 | Metadata export with isql (option -ex) does not export functions properly |
|
148 | SS | 606 | 603 | 586 | 565 | 543 | 555 | 676 | 615 | 692 | 671 | 588 | 655 | 662 | 638 | 599 | 606 | 662 | 605 | 626 | 642 | 596 | 588 | 607 | 583 | 591 | 601 | 639 | 632 | 580 | 616 | 624 | Metadata export with isql (option -ex) does not export functions properly |
|
149 | CS | 1118 | 1251 | 769 | 770 | 861 | 936 | 690 | 999 | 1174 | 670 | 671 | 727 | 715 | 617 | 1361 | 1587 | 1389 | 1557 | 1615 | 1551 | 1721 | 1482 | 1063 | 1388 | 1503 | 1364 | 1679 | 1020 | 1398 | 822 | 801 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
150 | SS | 578 | 585 | 528 | 640 | 566 | 441 | 424 | 431 | 406 | 431 | 430 | 375 | 443 | 429 | 554 | 584 | 621 | 619 | 575 | 663 | 602 | 590 | 576 | 655 | 600 | 608 | 630 | 567 | 614 | 581 | 648 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
151 | CS | 1062 | 674 | 639 | 638 | 702 | 1165 | 881 | 1139 | 1014 | 876 | 677 | 830 | 734 | 777 | 1124 | 1177 | 1151 | 1221 | 1207 | 1328 | 1128 | 1171 | 826 | 1110 | 1128 | 994 | 1195 | 1202 | 680 | 1140 | 682 | New permission types are not displayed by ISQL |
|
152 | SS | 457 | 529 | 446 | 496 | 417 | 482 | 457 | 473 | 614 | 509 | 548 | 513 | 454 | 496 | 475 | 464 | 454 | 457 | 456 | 460 | 449 | 498 | 433 | 418 | 412 | 423 | 446 | 405 | 429 | 443 | 503 | New permission types are not displayed by ISQL |
|
153 | CS | 819 | 705 | 582 | 599 | 738 | 807 | 728 | 844 | 623 | 717 | 603 | 746 | 747 | 729 | 1074 | 1107 | 997 | 1017 | 1177 | 1075 | 1019 | 1106 | 695 | 1057 | 1127 | 831 | 1124 | 1071 | 573 | 1023 | 638 | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
154 | SS | 404 | 456 | 378 | 440 | 387 | 393 | 456 | 486 | 458 | 383 | 387 | 395 | 451 | 460 | 397 | 402 | 413 | 393 | 416 | 418 | 464 | 376 | 401 | 427 | 399 | 365 | 396 | 411 | 408 | 396 | 406 | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
155 | CS | 1191 | 803 | 711 | 714 | 1142 | 1238 | 1095 | 1384 | 812 | 855 | 921 | 916 | 856 | 801 | 1404 | 1391 | 1420 | 1305 | 1525 | 1553 | 1488 | 1431 | 968 | 1356 | 1410 | 1183 | 1461 | 1347 | 774 | 830 | 1200 | The parameterized exception does not accept not ASCII characters as parameter |
|
156 | SS | 560 | 618 | 555 | 507 | 543 | 541 | 601 | 555 | 605 | 587 | 561 | 559 | 574 | 531 | 526 | 457 | 490 | 558 | 549 | 572 | 580 | 575 | 565 | 528 | 543 | 517 | 573 | 602 | 584 | 605 | 582 | The parameterized exception does not accept not ASCII characters as parameter |
|
157 | CS | 1518 | 1334 | 1168 | 1066 | 1362 | 1834 | 1416 | 1419 | 1195 | 1261 | 1243 | 1270 | 1357 | 1363 | 1837 | 1944 | 2196 | 2062 | 2432 | 2171 | 2060 | 2080 | 1395 | 1897 | 2059 | 1900 | 2118 | 1780 | 1165 | 1268 | 1617 | Replace the hierarchical union execution with the plain one |
|
158 | SS | 1000 | 461 | 893 | 973 | 950 | 881 | 972 | 935 | 1010 | 1062 | 922 | 967 | 1007 | 929 | 1031 | 954 | 1030 | 1005 | 1024 | 1028 | 1058 | 1180 | 997 | 979 | 1024 | 1003 | 947 | 1081 | 1041 | 916 | 1034 | Replace the hierarchical union execution with the plain one |
|
159 | CS | 985 | 1054 | 591 | 621 | 738 | 910 | 703 | 610 | 723 | 753 | 626 | 636 | 747 | 737 | 1003 | 1064 | 1240 | 1043 | 1229 | 1069 | 1142 | 1265 | 711 | 1106 | 1020 | 1030 | 1089 | 1118 | 968 | 1016 | 654 | Cannot create packaged routines with [VAR]CHAR parameters |
|
160 | SS | 413 | 446 | 408 | 330 | 389 | 329 | 458 | 413 | 470 | 446 | 465 | 433 | 455 | 413 | 385 | 398 | 419 | 467 | 394 | 460 | 451 | 406 | 373 | 437 | 376 | 371 | 401 | 394 | 432 | 402 | 449 | Cannot create packaged routines with [VAR]CHAR parameters |
|
161 | CS | 1297 | 1309 | 814 | 930 | 999 | 841 | 977 | 773 | 897 | 1073 | 818 | 979 | 1034 | 1017 | 1416 | 1294 | 1526 | 1411 | 1601 | 1449 | 1308 | 1426 | 1009 | 1378 | 1447 | 1424 | 1501 | 1545 | 1400 | 1300 | 830 | ISQL -x does not output the START WITH clause of generators/sequences |
|
162 | SS | 612 | 581 | 681 | 559 | 603 | 545 | 675 | 581 | 662 | 605 | 615 | 632 | 645 | 584 | 702 | 629 | 609 | 651 | 678 | 660 | 604 | 647 | 639 | 631 | 644 | 601 | 605 | 569 | 559 | 548 | 602 | ISQL -x does not output the START WITH clause of generators/sequences |
|
163 | CS | 1057 | 1277 | 676 | 606 | 867 | 688 | 972 | 844 | 824 | 852 | 680 | 879 | 782 | 832 | 1227 | 1114 | 1232 | 1139 | 1327 | 1369 | 1169 | 1348 | 898 | 1181 | 1311 | 1001 | 1328 | 1291 | 1243 | 1185 | 736 | Preserve comments for output parameters after altering procedures |
|
164 | SS | 530 | 449 | 482 | 458 | 504 | 489 | 547 | 522 | 593 | 592 | 546 | 566 | 491 | 494 | 539 | 522 | 509 | 554 | 573 | 564 | 532 | 533 | 599 | 612 | 502 | 421 | 567 | 536 | 529 | 478 | 490 | Preserve comments for output parameters after altering procedures |
|
165 | CS | 920 | 869 | 609 | 588 | 787 | 596 | 738 | 606 | 673 | 773 | 639 | 781 | 733 | 714 | 650 | 1020 | 1107 | 1025 | 1144 | 1075 | 1095 | 1139 | 728 | 971 | 1051 | 1142 | 1219 | 1182 | 1093 | 1071 | 1203 | GTT should not reference permanent relation |
|
166 | SS | 429 | 438 | 429 | 413 | 405 | 388 | 481 | 415 | 429 | 444 | 451 | 432 | 435 | 392 | 429 | 421 | 396 | 488 | 440 | 428 | 474 | 442 | 423 | 459 | 424 | 377 | 453 | 447 | 416 | 389 | 478 | GTT should not reference permanent relation |
|
167 | CS | 939 | 698 | 985 | 553 | 720 | 564 | 739 | 766 | 768 | 705 | 599 | 692 | 631 | 656 | 1089 | 1126 | 1203 | 1079 | 1112 | 1068 | 1060 | 1084 | 724 | 1184 | 1121 | 976 | 902 | 813 | 1086 | 1144 | 1105 | Problem with creation procedure which contain adding text in DOS864 charset |
|
168 | SS | 410 | 411 | 392 | 367 | 416 | 409 | 406 | 406 | 451 | 481 | 422 | 435 | 394 | 466 | 403 | 372 | 398 | 407 | 442 | 448 | 416 | 446 | 445 | 366 | 423 | 417 | 415 | 392 | 409 | 400 | 402 | Problem with creation procedure which contain adding text in DOS864 charset |
|
169 | CS | 1318 | 1364 | 1323 | 722 | 952 | 797 | 1038 | 891 | 1412 | 866 | 704 | 1008 | 907 | 871 | 1227 | 1451 | 1379 | 1345 | 1501 | 1451 | 1469 | 1377 | 985 | 1320 | 1463 | 873 | 1316 | 1201 | 1363 | 1411 | 1323 | Add table name to text of validation contraint error message, to help identify error context |
|
170 | SS | 567 | 587 | 529 | 483 | 511 | 563 | 588 | 615 | 665 | 555 | 549 | 576 | 643 | 523 | 580 | 536 | 568 | 497 | 625 | 601 | 587 | 588 | 567 | 603 | 612 | 515 | 589 | 549 | 541 | 563 | 564 | Add table name to text of validation contraint error message, to help identify error context |
|
171 | CS | 1035 | 1032 | 1006 | 727 | 673 | 679 | 783 | 766 | 796 | 717 | 532 | 753 | 660 | 665 | 1098 | 1068 | 1069 | 1134 | 1211 | 1133 | 1108 | 1110 | 722 | 1062 | 1039 | 1085 | 1094 | 973 | 1099 | 1056 | 1098 | Context parsing error with derived tables and CASE functions |
|
172 | SS | 411 | 414 | 398 | 422 | 418 | 436 | 413 | 424 | 473 | 453 | 407 | 355 | 423 | 409 | 391 | 347 | 403 | 452 | 420 | 440 | 426 | 454 | 362 | 372 | 392 | 380 | 409 | 370 | 445 | 361 | 359 | Context parsing error with derived tables and CASE functions |
|
173 | CS | 1048 | 1119 | 1185 | 686 | 660 | 769 | 774 | 691 | 845 | 737 | 567 | 714 | 730 | 668 | 1112 | 1168 | 1168 | 1015 | 1289 | 1060 | 1060 | 1090 | 711 | 1139 | 1177 | 1168 | 1007 | 1036 | 1074 | 1107 | 1077 | Error on create table with "CHARACTER SET DOS775" field |
|
174 | SS | 437 | 441 | 438 | 421 | 425 | 401 | 455 | 471 | 466 | 472 | 419 | 437 | 416 | 462 | 458 | 443 | 399 | 477 | 411 | 443 | 512 | 413 | 441 | 405 | 470 | 423 | 454 | 373 | 414 | 415 | 429 | Error on create table with "CHARACTER SET DOS775" field |
|
175 | CS | 997 | 929 | 1033 | 595 | 707 | 721 | 676 | 746 | 911 | 661 | 554 | 696 | 709 | 668 | 1036 | 1036 | 1099 | 1132 | 1559 | 1095 | 1082 | 1121 | 724 | 1080 | 1094 | 1175 | 937 | 961 | 1105 | 1039 | 1093 | FB3: Stored function accepts duplicate input arguments |
|
176 | SS | 405 | 435 | 386 | 411 | 398 | 411 | 433 | 383 | 505 | 392 | 378 | 422 | 416 | 376 | 400 | 353 | 415 | 410 | 362 | 411 | 423 | 395 | 382 | 420 | 446 | 403 | 404 | 367 | 406 | 402 | 426 | FB3: Stored function accepts duplicate input arguments |
|
177 | CS | 1020 | 1151 | 1107 | 619 | 748 | 811 | 718 | 761 | 1116 | 692 | 544 | 740 | 658 | 693 | 1017 | 1136 | 1024 | 1230 | 1308 | 1057 | 1209 | 1187 | 814 | 1107 | 1044 | 1181 | 884 | 886 | 1012 | 1079 | 1220 | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
178 | SS | 430 | 462 | 425 | 414 | 409 | 422 | 453 | 454 | 497 | 493 | 412 | 411 | 470 | 428 | 399 | 443 | 408 | 450 | 428 | 457 | 433 | 421 | 394 | 382 | 438 | 397 | 451 | 420 | 443 | 476 | 433 | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
179 | CS | 1344 | 1250 | 1416 | 789 | 930 | 998 | 912 | 903 | 1388 | 910 | 804 | 926 | 990 | 945 | 1543 | 1432 | 1427 | 1617 | 1495 | 1668 | 1465 | 1449 | 995 | 1522 | 1368 | 1496 | 1320 | 1114 | 1300 | 1372 | 1462 | Choose the best matching index for navigation |
|
180 | SS | 596 | 509 | 536 | 567 | 593 | 588 | 629 | 611 | 664 | 627 | 605 | 645 | 556 | 560 | 578 | 542 | 599 | 625 | 637 | 652 | 554 | 559 | 616 | 633 | 550 | 555 | 692 | 591 | 608 | 636 | 577 | Choose the best matching index for navigation |
|
181 | CS | 942 | 659 | 1087 | 613 | 779 | 739 | 799 | 781 | 773 | 694 | 606 | 762 | 770 | 777 | 1000 | 572 | 1259 | 1080 | 1333 | 1203 | 1212 | 1041 | 735 | 1062 | 1124 | 1168 | 1015 | 942 | 942 | 1003 | 1201 | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
182 | SS | 456 | 468 | 387 | 444 | 385 | 387 | 486 | 427 | 484 | 531 | 457 | 425 | 509 | 465 | 443 | 411 | 478 | 443 | 463 | 480 | 427 | 414 | 485 | 456 | 437 | 464 | 488 | 457 | 388 | 454 | 456 | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
183 | CS | 1266 | 659 | 1336 | 948 | 957 | 991 | 985 | 1040 | 807 | 883 | 1289 | 890 | 933 | 897 | 1360 | 785 | 1412 | 1415 | 1616 | 1471 | 1328 | 1259 | 921 | 1350 | 1428 | 1358 | 1296 | 1274 | 1178 | 1324 | 1373 | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
184 | SS | 573 | 474 | 518 | 564 | 519 | 575 | 660 | 625 | 653 | 610 | 605 | 593 | 574 | 603 | 631 | 511 | 512 | 597 | 508 | 561 | 596 | 539 | 544 | 572 | 560 | 489 | 625 | 573 | 558 | 608 | 585 | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
185 | CS | 1284 | 777 | 1360 | 1356 | 922 | 1047 | 928 | 932 | 782 | 931 | 1335 | 1007 | 903 | 890 | 1316 | 888 | 1460 | 1385 | 1496 | 1505 | 1312 | 1420 | 950 | 1349 | 1355 | 1462 | 1173 | 1169 | 1257 | 1357 | 1395 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
186 | SS | 579 | 577 | 528 | 539 | 557 | 592 | 616 | 554 | 617 | 632 | 648 | 603 | 600 | 593 | 539 | 554 | 581 | 591 | 583 | 599 | 618 | 555 | 592 | 574 | 537 | 555 | 576 | 572 | 530 | 550 | 614 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
187 | CS | 2379 | 2122 | 3371 | 1904 | 2142 | 2184 | 2190 | 2140 | 2295 | 2177 | 3300 | 2327 | 2269 | 2253 | 2080 | 3441 | 3303 | 3391 | 3405 | 3595 | 3454 | 3781 | 2296 | 3244 | 3462 | 3540 | 2032 | 2431 | 1784 | 3075 | 3257 | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
188 | SS | 1255 | 1257 | 1091 | 1131 | 1138 | 1181 | 1404 | 1200 | 1415 | 1295 | 1226 | 1357 | 1400 | 1209 | 1222 | 1240 | 1246 | 1278 | 1238 | 1300 | 1243 | 1251 | 1280 | 1287 | 1291 | 1253 | 1198 | 1265 | 1258 | 1260 | 1262 | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
189 | CS | 960 | 728 | 1118 | 1075 | 689 | 833 | 764 | 680 | 753 | 749 | 598 | 759 | 695 | 727 | 565 | 930 | 1061 | 1022 | 1253 | 1194 | 1078 | 1045 | 724 | 1017 | 1134 | 1140 | 1216 | 1197 | 1078 | 602 | 990 | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
190 | SS | 425 | 406 | 456 | 376 | 392 | 359 | 454 | 409 | 420 | 432 | 413 | 432 | 480 | 470 | 424 | 426 | 458 | 388 | 376 | 460 | 461 | 435 | 472 | 419 | 388 | 399 | 423 | 458 | 449 | 445 | 421 | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
191 | CS | 1557 | 1500 | 2207 | 1544 | 1392 | 1632 | 1557 | 1471 | 1558 | 1397 | 1168 | 1544 | 1460 | 1448 | 1286 | 2210 | 2439 | 2339 | 2385 | 2422 | 1517 | 2477 | 1548 | 2227 | 2398 | 2446 | 2621 | 2527 | 1577 | 1358 | 1403 | non-priviledged user can insert and update rdb$database |
|
192 | SS | 836 | 910 | 817 | 707 | 775 | 836 | 944 | 837 | 976 | 909 | 844 | 897 | 825 | 853 | 827 | 828 | 791 | 866 | 843 | 907 | 944 | 797 | 800 | 758 | 882 | 787 | 802 | 834 | 726 | 846 | 890 | non-priviledged user can insert and update rdb$database |
|
193 | CS | 730 | 660 | 991 | 569 | 630 | 662 | 764 | 730 | 686 | 659 | 590 | 730 | 688 | 675 | 636 | 1086 | 1212 | 1077 | 1059 | 1068 | 609 | 1069 | 682 | 1075 | 1025 | 940 | 1017 | 1051 | 780 | 666 | 592 | Equality predicate distribution does not work for some complex queries |
|
194 | SS | 410 | 444 | 424 | 352 | 390 | 404 | 499 | 410 | 509 | 406 | 389 | 397 | 440 | 409 | 411 | 412 | 446 | 366 | 414 | 422 | 449 | 405 | 417 | 382 | 420 | 382 | 386 | 440 | 443 | 399 | 390 | Equality predicate distribution does not work for some complex queries |
|
195 | CS | 755 | 740 | 1049 | 676 | 675 | 824 | 756 | 755 | 742 | 631 | 620 | 709 | 755 | 698 | 573 | 1232 | 1010 | 1091 | 1112 | 1045 | 651 | 1088 | 648 | 1083 | 984 | 660 | 1184 | 995 | 1115 | 992 | 642 | Create function/sp which references to non-existent exception <...> |
|
196 | SS | 422 | 434 | 405 | 396 | 370 | 396 | 431 | 421 | 473 | 450 | 478 | 423 | 451 | 443 | 410 | 406 | 374 | 430 | 423 | 468 | 508 | 389 | 383 | 377 | 377 | 456 | 412 | 417 | 391 | 440 | 434 | Create function/sp which references to non-existent exception <...> |
|
197 | CS | 771 | 655 | 951 | 612 | 603 | 668 | 781 | 717 | 762 | 641 | 673 | 735 | 733 | 687 | 579 | 1220 | 1077 | 1192 | 1132 | 1082 | 615 | 1016 | 688 | 1066 | 1072 | 835 | 1150 | 1083 | 1038 | 1004 | 664 | Duplicate names in package are not checked |
|
198 | SS | 414 | 434 | 356 | 375 | 456 | 371 | 420 | 450 | 456 | 425 | 395 | 391 | 414 | 482 | 393 | 415 | 454 | 435 | 408 | 412 | 424 | 430 | 383 | 398 | 370 | 435 | 414 | 432 | 374 | 394 | 406 | Duplicate names in package are not checked |
|
199 | CS | 894 | 770 | 612 | 650 | 656 | 766 | 818 | 803 | 751 | 754 | 1203 | 694 | 770 | 751 | 717 | 1284 | 1084 | 1134 | 1185 | 1100 | 651 | 1164 | 760 | 970 | 1080 | 1365 | 1105 | 1144 | 1103 | 1049 | 1254 | Preparation of erroneous DDL statement does not show the main command failed |
|
200 | SS | 432 | 416 | 453 | 432 | 403 | 378 | 482 | 442 | 482 | 477 | 433 | 437 | 476 | 507 | 419 | 457 | 506 | 466 | 413 | 395 | 430 | 368 | 419 | 444 | 456 | 427 | 423 | 423 | 397 | 504 | 430 | Preparation of erroneous DDL statement does not show the main command failed |
|
201 | CS | 3094 | 2723 | 2136 | 2147 | 2565 | 2621 | 2555 | 2697 | 2717 | 2798 | 3102 | 2686 | 2778 | 2675 | 2535 | 4335 | 4207 | 3558 | 4695 | 4264 | 2251 | 3978 | 3087 | 3951 | 4352 | 3707 | 4452 | 4236 | 4437 | 3721 | 4022 | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
202 | SS | 2350 | 2235 | 1957 | 2094 | 2121 | 2108 | 2302 | 2102 | 2322 | 2195 | 2287 | 2191 | 2348 | 2344 | 2400 | 2545 | 2547 | 2534 | 2616 | 2531 | 2352 | 2614 | 2538 | 2529 | 2509 | 2396 | 2293 | 2300 | 2387 | 2436 | 2539 | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
203 | CS | 745 | 701 | 745 | 580 | 696 | 694 | 699 | 767 | 737 | 601 | 626 | 680 | 799 | 746 | 613 | 641 | 1131 | 1157 | 1068 | 1148 | 639 | 1148 | 703 | 1061 | 1237 | 969 | 1061 | 1040 | 1068 | 909 | 640 | Incorrect line/column information in runtime errors |
|
204 | SS | 424 | 382 | 382 | 446 | 379 | 391 | 429 | 448 | 473 | 405 | 441 | 439 | 418 | 439 | 409 | 446 | 380 | 350 | 436 | 481 | 428 | 407 | 377 | 449 | 452 | 449 | 423 | 410 | 425 | 417 | 357 | Incorrect line/column information in runtime errors |
|
205 | CS | 5636 | 4865 | 6742 | 3863 | 4481 | 4936 | 5106 | 4675 | 4913 | 4502 | 4145 | 4883 | 4828 | 4609 | 3912 | 5382 | 7421 | 6981 | 7666 | 7690 | 5891 | 7764 | 4900 | 7319 | 7299 | 7572 | 7854 | 7330 | 7404 | 7343 | 8690 | Report more details for "object in use" errors |
|
206 | SS | 2108 | 2096 | 1998 | 1908 | 2018 | 2060 | 2106 | 2137 | 2299 | 1898 | 2204 | 2049 | 2240 | 2112 | 2126 | 2185 | 2154 | 2117 | 2111 | 2066 | 2087 | 2026 | 2046 | 2100 | 2093 | 2111 | 2357 | 2190 | 2178 | 2357 | 2063 | Report more details for "object in use" errors |
|
207 | CS | 1089 | 807 | 1336 | 928 | 823 | 997 | 1025 | 1144 | 886 | 921 | 919 | 926 | 1034 | 874 | 727 | 1404 | 769 | 823 | 1428 | 1460 | 1376 | 1370 | 977 | 1451 | 1264 | 1561 | 1360 | 1429 | 1273 | 1285 | 1532 | Allow referencing cursors as record variables in PSQL |
|
208 | SS | 570 | 460 | 516 | 560 | 512 | 537 | 609 | 554 | 625 | 630 | 669 | 572 | 704 | 572 | 569 | 549 | 559 | 594 | 513 | 595 | 579 | 606 | 550 | 565 | 603 | 589 | 524 | 608 | 569 | 587 | 529 | Allow referencing cursors as record variables in PSQL |
|
209 | CS | 779 | 770 | 1023 | 679 | 628 | 775 | 741 | 783 | 753 | 656 | 599 | 701 | 702 | 738 | 602 | 990 | 595 | 611 | 1080 | 1140 | 890 | 1176 | 759 | 1024 | 1114 | 1208 | 1086 | 1115 | 1101 | 1075 | 1278 | Useless extraction of generic DDL trigger |
|
210 | SS | 405 | 404 | 413 | 397 | 326 | 350 | 399 | 432 | 439 | 436 | 434 | 408 | 383 | 364 | 438 | 413 | 400 | 398 | 384 | 447 | 432 | 390 | 401 | 406 | 388 | 415 | 421 | 415 | 367 | 391 | 442 | Useless extraction of generic DDL trigger |
|
211 | CS | 968 | 966 | 1032 | 915 | 806 | 945 | 898 | 950 | 892 | 906 | 857 | 970 | 952 | 856 | 797 | 1323 | 784 | 966 | 1526 | 1444 | 1355 | 1345 | 896 | 1425 | 1412 | 1376 | 1574 | 1402 | 1298 | 1243 | 1437 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
212 | SS | 573 | 589 | 484 | 503 | 516 | 563 | 592 | 536 | 616 | 518 | 542 | 653 | 584 | 608 | 609 | 588 | 555 | 599 | 526 | 573 | 553 | 610 | 521 | 587 | 580 | 575 | 573 | 566 | 572 | 595 | 537 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
213 | CS | 3276 | 3164 | 4436 | 3091 | 2969 | 3102 | 3041 | 3084 | 3052 | 2946 | 3036 | 3093 | 3095 | 2978 | 2986 | 3662 | 2924 | 3388 | 3574 | 4498 | 4607 | 3767 | 3076 | 4338 | 4463 | 4496 | 3717 | 4410 | 4550 | 4489 | 4598 | Allow output to trace explain plan form. |
|
214 | SS | 2703 | 2703 | 2754 | 2679 | 2704 | 2652 | 2745 | 2655 | 2726 | 2769 | 2673 | 2676 | 2693 | 2720 | 2684 | 2672 | 2687 | 2721 | 2693 | 2653 | 2701 | 2717 | 2727 | 2708 | 2717 | 2704 | 2704 | 2673 | 2699 | 2725 | 2730 | Allow output to trace explain plan form. |
|
215 | CS | 998 | 940 | 1282 | 912 | 837 | 905 | 892 | 963 | 1034 | 829 | 920 | 909 | 904 | 797 | 796 | 1332 | 1356 | 1388 | 790 | 1388 | 1342 | 824 | 933 | 1303 | 1256 | 1434 | 1359 | 1379 | 1255 | 1332 | 1384 | Regression: NOT NULL constraint, declared in domain, does not work |
|
216 | SS | 543 | 514 | 519 | 515 | 541 | 456 | 579 | 534 | 547 | 556 | 538 | 532 | 501 | 586 | 524 | 553 | 554 | 572 | 505 | 554 | 577 | 564 | 546 | 537 | 539 | 519 | 558 | 514 | 562 | 563 | 564 | Regression: NOT NULL constraint, declared in domain, does not work |
|
217 | CS | 3158 | 3049 | 3786 | 2965 | 2924 | 3189 | 2766 | 3190 | 3063 | 2882 | 3037 | 3127 | 3024 | 2889 | 2461 | 4001 | 4162 | 4220 | 2659 | 4697 | 4335 | 2542 | 2942 | 4347 | 4187 | 4371 | 4979 | 2960 | 4164 | 4069 | 4893 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
218 | SS | 1782 | 1913 | 1650 | 1778 | 1803 | 1635 | 1739 | 1759 | 2028 | 1876 | 1860 | 1877 | 1912 | 1909 | 1790 | 1741 | 1618 | 1676 | 1686 | 1716 | 1666 | 1643 | 1715 | 1819 | 1733 | 1807 | 1874 | 1818 | 1786 | 1817 | 1684 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
219 | CS | 1649 | 1732 | 1673 | 1347 | 1380 | 1443 | 1483 | 1406 | 1455 | 1482 | 1626 | 1562 | 1519 | 1421 | 1164 | 2105 | 2157 | 2202 | 2011 | 2130 | 2057 | 2116 | 1386 | 1181 | 2408 | 1965 | 1445 | 2109 | 1788 | 2072 | 2055 | gbak fails to restore database containing dependency between views and packaged functions |
|
220 | SS | 1022 | 1154 | 1076 | 1020 | 1061 | 1090 | 980 | 1084 | 1149 | 1237 | 1113 | 1130 | 1131 | 1055 | 1006 | 1064 | 977 | 998 | 1014 | 1095 | 999 | 1025 | 962 | 1046 | 925 | 923 | 997 | 926 | 915 | 1009 | 978 | gbak fails to restore database containing dependency between views and packaged functions |
|
221 | CS | 756 | 687 | 686 | 800 | 742 | 695 | 760 | 708 | 768 | 670 | 753 | 720 | 671 | 681 | 656 | 1043 | 1142 | 918 | 1116 | 1258 | 752 | 1116 | 724 | 667 | 1065 | 1120 | 1164 | 1236 | 587 | 1020 | 1061 | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
222 | SS | 428 | 445 | 391 | 441 | 401 | 421 | 462 | 393 | 480 | 475 | 452 | 464 | 443 | 425 | 438 | 419 | 417 | 437 | 422 | 400 | 402 | 436 | 370 | 405 | 481 | 436 | 402 | 392 | 427 | 454 | 429 | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
223 | CS | 722 | 728 | 570 | 689 | 659 | 766 | 659 | 707 | 672 | 700 | 721 | 681 | 645 | 724 | 652 | 1052 | 1087 | 1024 | 687 | 1234 | 613 | 689 | 758 | 616 | 1298 | 1093 | 1196 | 1029 | 972 | 965 | 1140 | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
224 | SS | 397 | 425 | 393 | 371 | 412 | 362 | 394 | 425 | 455 | 470 | 443 | 421 | 373 | 426 | 412 | 383 | 367 | 393 | 495 | 400 | 410 | 340 | 396 | 408 | 409 | 388 | 388 | 373 | 391 | 378 | 399 | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
225 | CS | 3717 | 2714 | 11791 | 12194 | 2588 | 2966 | 2681 | 2965 | 2739 | 2646 | 2849 | 2704 | 2752 | 2750 | 2643 | 3809 | 3923 | 3829 | 3916 | 3994 | 4125 | 3974 | 2632 | 3232 | 4014 | 4114 | 4158 | 3998 | 3716 | 3883 | 3718 | New gbak option to enable encryption during restore |
|
226 | SS | 1811 | 1845 | 11341 | 11316 | 1653 | 1808 | 1918 | 1809 | 1918 | 2056 | 1779 | 1892 | 2027 | 1879 | 1813 | 1835 | 1695 | 1865 | 1703 | 1821 | 1769 | 1840 | 1721 | 1909 | 1724 | 1718 | 1793 | 1700 | 1582 | 1724 | 1747 | New gbak option to enable encryption during restore |
|
227 | CS | 994 | 704 | 757 | 755 | 706 | 717 | 657 | 855 | 751 | 651 | 839 | 723 | 763 | 673 | 962 | 1060 | 1225 | 1069 | 1129 | 1189 | 1028 | 1128 | 744 | 1027 | 1433 | 1116 | 1391 | 1143 | 1128 | 1157 | 1165 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
228 | SS | 440 | 466 | 452 | 418 | 440 | 327 | 423 | 503 | 440 | 504 | 462 | 468 | 415 | 461 | 495 | 442 | 438 | 461 | 427 | 434 | 494 | 381 | 459 | 472 | 425 | 389 | 441 | 440 | 426 | 420 | 427 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
229 | CS | 920 | 720 | 647 | 801 | 734 | 715 | 710 | 725 | 708 | 708 | 788 | 653 | 775 | 697 | 661 | 1104 | 1043 | 1010 | 1100 | 1080 | 1100 | 1048 | 830 | 1119 | 1181 | 1108 | 1213 | 1060 | 1080 | 1067 | 1147 | Allow to use index when GROUP BY on field which has DESCENDING index |
|
230 | SS | 421 | 439 | 380 | 364 | 387 | 359 | 414 | 397 | 426 | 515 | 424 | 471 | 507 | 455 | 393 | 447 | 433 | 431 | 472 | 426 | 419 | 398 | 411 | 437 | 419 | 469 | 387 | 389 | 407 | 462 | 417 | Allow to use index when GROUP BY on field which has DESCENDING index |
|
231 | CS | 1085 | 880 | 892 | 905 | 891 | 916 | 850 | 834 | 906 | 871 | 838 | 853 | 833 | 939 | 863 | 1231 | 1260 | 1356 | 1432 | 1420 | 1427 | 1322 | 898 | 1382 | 1414 | 1411 | 1510 | 1356 | 1388 | 1305 | 1424 | DB_KEY based join of two tables may be ineffective |
|
232 | SS | 546 | 588 | 488 | 577 | 521 | 525 | 618 | 482 | 558 | 591 | 479 | 593 | 547 | 589 | 468 | 518 | 517 | 523 | 530 | 578 | 588 | 567 | 569 | 546 | 555 | 557 | 533 | 537 | 546 | 520 | 509 | DB_KEY based join of two tables may be ineffective |
|
233 | CS | 873 | 704 | 700 | 670 | 690 | 712 | 740 | 734 | 702 | 683 | 644 | 697 | 701 | 673 | 807 | 939 | 1121 | 994 | 1164 | 1076 | 1101 | 1199 | 714 | 1038 | 1147 | 1129 | 1184 | 1028 | 1031 | 1196 | 1077 | Server does not accept the right plan |
|
234 | SS | 437 | 438 | 437 | 400 | 496 | 440 | 499 | 433 | 452 | 468 | 438 | 443 | 468 | 412 | 400 | 405 | 413 | 473 | 455 | 458 | 437 | 424 | 416 | 450 | 424 | 416 | 392 | 440 | 414 | 400 | 408 | Server does not accept the right plan |
|
235 | CS | 789 | 711 | 662 | 784 | 733 | 707 | 795 | 710 | 729 | 703 | 752 | 735 | 723 | 697 | 939 | 628 | 1139 | 699 | 1248 | 1140 | 1187 | 1044 | 775 | 981 | 1090 | 1140 | 1117 | 1184 | 1157 | 1173 | 971 | DDL trigger remains active after dropped |
|
236 | SS | 431 | 442 | 406 | 371 | 389 | 448 | 401 | 420 | 437 | 483 | 444 | 424 | 478 | 431 | 431 | 434 | 407 | 410 | 404 | 491 | 404 | 466 | 361 | 458 | 362 | 359 | 434 | 420 | 447 | 458 | 453 | DDL trigger remains active after dropped |
|
237 | CS | 1021 | 702 | 976 | 1045 | 911 | 948 | 957 | 972 | 929 | 899 | 1028 | 1014 | 924 | 883 | 1243 | 835 | 1585 | 848 | 1473 | 1507 | 1529 | 1488 | 975 | 1448 | 1536 | 1514 | 1443 | 1587 | 1348 | 1384 | 926 | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
238 | SS | 600 | 447 | 539 | 489 | 584 | 590 | 649 | 561 | 600 | 573 | 643 | 600 | 637 | 574 | 568 | 572 | 561 | 650 | 589 | 679 | 639 | 616 | 620 | 574 | 630 | 612 | 601 | 607 | 567 | 608 | 654 | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
239 | CS | 791 | 724 | 678 | 753 | 620 | 703 | 711 | 710 | 713 | 653 | 812 | 740 | 637 | 758 | 1163 | 678 | 642 | 931 | 1130 | 1133 | 1057 | 1252 | 770 | 889 | 1196 | 1163 | 1264 | 1180 | 1147 | 1071 | 1305 | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
240 | SS | 430 | 439 | 399 | 398 | 386 | 391 | 467 | 452 | 450 | 497 | 406 | 418 | 422 | 450 | 444 | 398 | 442 | 442 | 436 | 378 | 456 | 464 | 402 | 437 | 428 | 400 | 433 | 421 | 360 | 395 | 446 | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
241 | CS | 796 | 669 | 813 | 708 | 670 | 772 | 685 | 703 | 780 | 677 | 713 | 746 | 733 | 840 | 1189 | 607 | 765 | 638 | 1100 | 1141 | 1173 | 1099 | 727 | 1104 | 1245 | 1261 | 1133 | 1243 | 1170 | 1031 | 1164 | Can't create column check constraint when the column is domain based |
|
242 | SS | 423 | 417 | 418 | 376 | 374 | 387 | 396 | 436 | 467 | 418 | 464 | 409 | 456 | 461 | 459 | 408 | 460 | 455 | 430 | 407 | 455 | 416 | 433 | 368 | 432 | 369 | 441 | 420 | 427 | 440 | 385 | Can't create column check constraint when the column is domain based |