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.858
|
6.0.0.854
|
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.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
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | Count (DISTINCT ...) is too slow |
|
2 | CS | P | F | F | E | E | E | E | E | E | E | E | E | E | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan |
|
3 | SS | P | F | F | E | E | E | E | E | E | E | E | E | E | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan |
|
4 | CS | P | F | 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 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
5 | SS | P | F | 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 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
6 | CS | P | F | 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 | Prohibit any improper mixture of explicit and implicit joins |
|
7 | SS | P | F | 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 | Prohibit any improper mixture of explicit and implicit joins |
|
8 | CS | P | F | 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 | Join condition fails for UTF-8 databases |
|
9 | SS | P | F | 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 | Join condition fails for UTF-8 databases |
|
10 | CS | P | F | 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 | Natural is used to select instead of primary key index |
|
11 | SS | P | F | 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 | Natural is used to select instead of primary key index |
|
12 | CS | P | F | 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 | isql should show packaged procedures and functions categorized per package |
|
13 | SS | P | F | 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 | isql should show packaged procedures and functions categorized per package |
|
14 | CS | P | F | 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 | PK index is not used for derived tables |
|
15 | SS | P | F | 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 | PK index is not used for derived tables |
|
16 | CS | P | F | 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 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
17 | SS | P | F | 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 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
18 | CS | P | F | 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 | Broken error handling in the case of a conversion error happened during index creation |
|
19 | SS | P | F | 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 | Broken error handling in the case of a conversion error happened during index creation |
|
20 | CS | P | F | 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 | DROP VIEW drops output parameters of used stored procedures |
|
21 | SS | P | F | 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 | DROP VIEW drops output parameters of used stored procedures |
|
22 | CS | P | F | 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 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
23 | SS | P | F | 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 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
24 | CS | P | F | 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 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
25 | SS | P | F | 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 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
26 | CS | P | F | 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 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
27 | SS | P | F | 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 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
28 | CS | P | F | 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 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
29 | SS | P | F | 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 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
30 | CS | P | F | 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 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
31 | SS | P | F | 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 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
32 | CS | P | F | 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 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
33 | SS | P | F | 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 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
34 | CS | P | F | 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 | Cannot alter the domain after migrating from older versions |
|
35 | SS | P | F | 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 | Cannot alter the domain after migrating from older versions |
|
36 | CS | P | F | 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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
37 | SS | P | F | 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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
38 | CS | P | F | 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 | Expression index with TRIM may lead to incorrect indexed lookup |
|
39 | SS | P | F | 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 | Expression index with TRIM may lead to incorrect indexed lookup |
|
40 | CS | P | F | 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 | Index is not used when view has "subselect" column |
|
41 | SS | P | F | 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 | Index is not used when view has "subselect" column |
|
42 | CS | P | F | 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 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
43 | SS | P | F | 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 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
44 | CS | P | F | 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 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
45 | SS | P | F | 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 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
46 | CS | P | F | 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 | UTF8 UNICODE_CI collate can not be used in compound index |
|
47 | SS | P | F | 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 | UTF8 UNICODE_CI collate can not be used in compound index |
|
48 | CS | P | F | 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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
49 | SS | P | F | 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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
50 | CS | P | F | 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 | "BLOB not found" error after creation/altering of the invalid trigger |
|
51 | SS | P | F | 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 | "BLOB not found" error after creation/altering of the invalid trigger |
|
52 | CS | P | F | 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 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
53 | SS | P | F | 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 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
54 | CS | P | F | 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 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
55 | SS | P | F | 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 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
56 | CS | P | F | 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 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
57 | SS | P | F | 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 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
58 | CS | P | F | 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 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
59 | SS | P | F | 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 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
60 | CS | P | F | 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 | Generators are set to 0 after restore |
|
61 | SS | P | F | 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 | Generators are set to 0 after restore |
|
62 | CS | P | F | 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 | Blob filter to translate internal debug info into text representation |
|
63 | SS | P | F | 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 | Blob filter to translate internal debug info into text representation |
|
64 | CS | P | F | 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 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
65 | SS | P | F | 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 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
66 | CS | P | F | 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 | Recurse leads to hangs/crash server |
|
67 | SS | P | F | 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 | Recurse leads to hangs/crash server |
|
68 | CS | P | F | 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 | [FB3] AV with "UPDATE OR INSERT" |
|
69 | SS | P | F | 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 | [FB3] AV with "UPDATE OR INSERT" |
|
70 | CS | P | F | 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 | Inefficient optimization (regression) |
|
71 | SS | P | F | 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 | Inefficient optimization (regression) |
|
72 | CS | P | F | 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 | Regression in joins on procedures |
|
73 | SS | P | F | 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 | Regression in joins on procedures |
|
74 | CS | P | F | 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 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
75 | SS | P | F | 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 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
76 | CS | P | F | 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 | DROP VIEW ignores the existing non-column dependencies |
|
77 | SS | P | F | 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 | DROP VIEW ignores the existing non-column dependencies |
|
78 | CS | P | F | 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 | Alter procedure allows to add the parameter with the same name |
|
79 | SS | P | F | 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 | Alter procedure allows to add the parameter with the same name |
|
80 | CS | P | F | 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 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
81 | SS | P | F | 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 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
82 | CS | P | F | 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 | Inconsistent domain's constraint validation in PSQL |
|
83 | SS | P | F | 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 | Inconsistent domain's constraint validation in PSQL |
|
84 | CS | P | F | 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 | Floating-point negative zero doesn't match positive zero in the index |
|
85 | SS | P | F | 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 | Floating-point negative zero doesn't match positive zero in the index |
|
86 | CS | P | F | 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 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
87 | SS | P | F | 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 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
88 | CS | P | F | 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 | CHAR(32767) present in XSQLVAR with length 32765 |
|
89 | SS | P | F | 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 | CHAR(32767) present in XSQLVAR with length 32765 |
|
90 | CS | P | F | 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 | Include expected and actual string lenght into error message for sqlcode -802 |
|
91 | SS | P | F | 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 | Include expected and actual string lenght into error message for sqlcode -802 |
|
92 | CS | P | F | 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 | TRACE: add statistics of actions that were after transaction finished |
|
93 | SS | P | F | 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 | TRACE: add statistics of actions that were after transaction finished |
|
94 | CS | P | F | 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 | Can insert DUPLICATE keys in UNIQUE index |
|
95 | SS | P | F | 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 | Can insert DUPLICATE keys in UNIQUE index |
|
96 | CS | P | F | 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 | Server crashes with access violation when inserting row into table with unique index |
|
97 | SS | P | F | 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 | Server crashes with access violation when inserting row into table with unique index |
|
98 | CS | P | F | 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 | computed index by substring function for long columns |
|
99 | SS | P | F | 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 | computed index by substring function for long columns |
|
100 | CS | P | F | 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 | Wrong warning message for ambiguous query |
|
101 | SS | P | F | 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 | Wrong warning message for ambiguous query |
|
102 | CS | P | F | 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 | Wrong warning message for ambiguous query |
|
103 | SS | P | F | 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 | Wrong warning message for ambiguous query |
|
104 | CS | P | F | 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 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
105 | SS | P | F | 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 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
106 | CS | P | F | 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 | IS NOT DISTINCT FROM NULL doesn't use index |
|
107 | SS | P | F | 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 | IS NOT DISTINCT FROM NULL doesn't use index |
|
108 | CS | P | F | 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 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
109 | SS | P | F | 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 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
110 | CS | P | F | 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 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
111 | SS | P | F | 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 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
112 | CS | P | F | 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 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
113 | SS | P | F | 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 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
114 | CS | P | F | 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 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
115 | SS | P | F | 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 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
116 | CS | P | F | 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 | Extend the error reported for index/constraint violations to include the problematic key value |
|
117 | SS | P | F | 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 | Extend the error reported for index/constraint violations to include the problematic key value |
|
118 | CS | P | F | 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 | Wrong numbers in error message for decreasing char/varchar columns |
|
119 | SS | P | F | 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 | Wrong numbers in error message for decreasing char/varchar columns |
|
120 | CS | P | F | 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 | Derived fields may not be optimized via an index |
|
121 | SS | P | F | 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 | Derived fields may not be optimized via an index |
|
122 | CS | P | F | 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 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
123 | SS | P | F | 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 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
124 | CS | P | F | 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 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
125 | SS | P | F | 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 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
126 | CS | P | F | 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 | isql doesn't know the difference between UDF's and psql-functions |
|
127 | SS | P | F | 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 | isql doesn't know the difference between UDF's and psql-functions |
|
128 | CS | P | F | 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 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
129 | SS | P | F | 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 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
130 | CS | P | F | 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 | Join using RDB$DB_KEY produce NATURAL plan |
|
131 | SS | P | F | 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 | Join using RDB$DB_KEY produce NATURAL plan |
|
132 | CS | P | F | 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 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
133 | SS | P | F | 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 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
134 | CS | P | F | 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 | Broken optimization for the stored dbkeys |
|
135 | SS | P | F | 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 | Broken optimization for the stored dbkeys |
|
136 | CS | P | F | 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 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
137 | SS | P | F | 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 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
138 | CS | P | F | 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 | Computed by columns and position function |
|
139 | SS | P | F | 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 | Computed by columns and position function |
|
140 | CS | P | F | 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 | Server bugchecks or crashes on exception in calculated index |
|
141 | SS | P | F | 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 | Server bugchecks or crashes on exception in calculated index |
|
142 | CS | P | F | 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 | Regression: Group by fails if subselect-column is involved |
|
143 | SS | P | F | 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 | Regression: Group by fails if subselect-column is involved |
|
144 | CS | P | F | 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 | Bad optimization of OR predicates applied to unions |
|
145 | SS | P | F | 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 | Bad optimization of OR predicates applied to unions |
|
146 | CS | P | F | 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 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
147 | SS | P | F | 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 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
148 | CS | P | F | 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 | Expression index may be not used for derived fields or view fields |
|
149 | SS | P | F | 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 | Expression index may be not used for derived fields or view fields |
|
150 | CS | P | F | 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 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
151 | SS | P | F | 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 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
152 | CS | P | F | 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 | Metadata export with isql (option -ex) does not export functions properly |
|
153 | SS | P | F | 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 | Metadata export with isql (option -ex) does not export functions properly |
|
154 | CS | P | F | 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 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
155 | SS | P | F | 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 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
156 | CS | P | F | 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 | New permission types are not displayed by ISQL |
|
157 | SS | P | F | 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 | New permission types are not displayed by ISQL |
|
158 | CS | P | F | 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 | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
159 | SS | P | F | 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 | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
160 | CS | P | F | 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 | The parameterized exception does not accept not ASCII characters as parameter |
|
161 | SS | P | F | 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 | The parameterized exception does not accept not ASCII characters as parameter |
|
162 | CS | P | F | 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 | Replace the hierarchical union execution with the plain one |
|
163 | SS | P | F | 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 | Replace the hierarchical union execution with the plain one |
|
164 | CS | P | F | 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 | Cannot create packaged routines with [VAR]CHAR parameters |
|
165 | SS | P | F | 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 | Cannot create packaged routines with [VAR]CHAR parameters |
|
166 | CS | P | F | 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 | ISQL -x does not output the START WITH clause of generators/sequences |
|
167 | SS | P | F | 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 | ISQL -x does not output the START WITH clause of generators/sequences |
|
168 | CS | P | F | 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 | Preserve comments for output parameters after altering procedures |
|
169 | SS | P | F | 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 | Preserve comments for output parameters after altering procedures |
|
170 | CS | P | F | 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 | GTT should not reference permanent relation |
|
171 | SS | P | F | 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 | GTT should not reference permanent relation |
|
172 | CS | P | F | 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 | Problem with creation procedure which contain adding text in DOS864 charset |
|
173 | SS | P | F | 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 | Problem with creation procedure which contain adding text in DOS864 charset |
|
174 | CS | P | F | 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 | Add table name to text of validation contraint error message, to help identify error context |
|
175 | SS | P | F | 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 | Add table name to text of validation contraint error message, to help identify error context |
|
176 | CS | P | F | 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 | Context parsing error with derived tables and CASE functions |
|
177 | SS | P | F | 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 | Context parsing error with derived tables and CASE functions |
|
178 | CS | P | F | 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 | Error on create table with "CHARACTER SET DOS775" field |
|
179 | SS | P | F | 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 | Error on create table with "CHARACTER SET DOS775" field |
|
180 | CS | P | F | 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 | FB3: Stored function accepts duplicate input arguments |
|
181 | SS | P | F | 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 | FB3: Stored function accepts duplicate input arguments |
|
182 | CS | P | F | 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 | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
183 | SS | P | F | 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 | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
184 | CS | P | F | 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 | Choose the best matching index for navigation |
|
185 | SS | P | F | 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 | Choose the best matching index for navigation |
|
186 | CS | P | F | 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 | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
187 | SS | P | F | 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 | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
188 | CS | P | F | 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 | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
189 | SS | P | F | 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 | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
190 | CS | P | F | 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 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
191 | SS | P | F | 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 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
192 | CS | P | F | 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 | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
193 | SS | P | F | 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 | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
194 | CS | P | F | 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 | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
195 | SS | P | F | 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 | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
196 | CS | P | F | 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 | non-priviledged user can insert and update rdb$database |
|
197 | SS | P | F | 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 | non-priviledged user can insert and update rdb$database |
|
198 | CS | P | F | 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 | Equality predicate distribution does not work for some complex queries |
|
199 | SS | P | F | 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 | Equality predicate distribution does not work for some complex queries |
|
200 | CS | P | F | 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 | Create function/sp which references to non-existent exception <...> |
|
201 | SS | P | F | 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 | Create function/sp which references to non-existent exception <...> |
|
202 | CS | P | F | 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 | Duplicate names in package are not checked |
|
203 | SS | P | F | 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 | Duplicate names in package are not checked |
|
204 | CS | P | F | 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 | Preparation of erroneous DDL statement does not show the main command failed |
|
205 | SS | P | F | 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 | Preparation of erroneous DDL statement does not show the main command failed |
|
206 | CS | P | F | 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 | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
207 | SS | P | F | 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 | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
208 | CS | P | F | 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 | Incorrect line/column information in runtime errors |
|
209 | SS | P | F | 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 | Incorrect line/column information in runtime errors |
|
210 | CS | P | F | 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 | Report more details for "object in use" errors |
|
211 | SS | P | F | 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 | Report more details for "object in use" errors |
|
212 | CS | P | F | 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 | Allow referencing cursors as record variables in PSQL |
|
213 | SS | P | F | 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 | Allow referencing cursors as record variables in PSQL |
|
214 | CS | P | F | 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 | Useless extraction of generic DDL trigger |
|
215 | SS | P | F | 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 | Useless extraction of generic DDL trigger |
|
216 | CS | P | F | 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 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
217 | SS | P | F | 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 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
218 | CS | P | F | 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 | Allow output to trace explain plan form. |
|
219 | SS | P | F | 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 | Allow output to trace explain plan form. |
|
220 | CS | P | F | 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 | Regression: NOT NULL constraint, declared in domain, does not work |
|
221 | SS | P | F | 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 | Regression: NOT NULL constraint, declared in domain, does not work |
|
222 | CS | P | F | 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 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
223 | SS | P | F | 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 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
224 | CS | P | F | 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 | gbak fails to restore database containing dependency between views and packaged functions |
|
225 | SS | P | F | 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 | gbak fails to restore database containing dependency between views and packaged functions |
|
226 | CS | P | F | 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 | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
227 | SS | P | F | 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 | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
228 | CS | P | F | 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 | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
229 | SS | P | F | 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 | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
230 | CS | P | F | 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 | New gbak option to enable encryption during restore |
|
231 | SS | P | F | 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 | New gbak option to enable encryption during restore |
|
232 | CS | P | F | 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 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
233 | SS | P | F | 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 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
234 | CS | P | F | 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 | Allow to use index when GROUP BY on field which has DESCENDING index |
|
235 | SS | P | F | 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 | Allow to use index when GROUP BY on field which has DESCENDING index |
|
236 | CS | P | F | 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 | DB_KEY based join of two tables may be ineffective |
|
237 | SS | P | F | 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 | DB_KEY based join of two tables may be ineffective |
|
238 | CS | P | F | 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 | Server does not accept the right plan |
|
239 | SS | P | F | 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 | Server does not accept the right plan |
|
240 | CS | P | F | 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 | DDL trigger remains active after dropped |
|
241 | SS | P | F | 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 | DDL trigger remains active after dropped |
|
242 | CS | P | F | 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 | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
243 | SS | P | F | 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 | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
244 | CS | P | F | 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 | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
245 | SS | P | F | 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 | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
246 | CS | P | F | 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 | Can't create column check constraint when the column is domain based |
|
247 | SS | P | F | 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 | Can't create column check constraint when the column is domain based |
|
248 | CS | P | F | 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 | Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.") |
|
249 | SS | P | F | 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 | Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.") |
|
250 | CS | P | F | 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 | Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N } |
|
251 | SS | P | F | 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 | Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N } |
|
252 | CS | P | F | 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 | Regression: computed index based on a computed column stores NULL for all its keys |
|
253 | SS | P | F | 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 | Regression: computed index based on a computed column stores NULL for all its keys |
|
254 | CS | P | F | 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 | "Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table |
|
255 | SS | P | F | 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 | "Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table |
|
256 | CS | P | F | 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 | Regression: Join order in v3 is less optimal than in v2.x |
|
257 | SS | P | F | 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 | Regression: Join order in v3 is less optimal than in v2.x |
|
258 | CS | P | F | 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 | Implement ability to validate tables and indices online (without exclusive access to database) |
|
259 | SS | P | F | 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 | Implement ability to validate tables and indices online (without exclusive access to database) |
|
260 | CS | P | F | 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 | Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs |
|
261 | SS | P | F | 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 | Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs |
|
262 | CS | P | F | 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 | Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR |
|
263 | SS | P | F | 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 | Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR |
|
264 | CS | P | F | 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 | Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists) |
|
265 | SS | P | F | 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 | Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists) |
|
266 | CS | P | F | 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 | Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..." |
|
267 | SS | P | F | 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 | Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..." |
|
268 | CS | P | F | 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 | ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used |
|
269 | SS | P | F | 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 | ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used |
|
270 | CS | P | F | 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 | Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles) |
|
271 | SS | P | F | 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 | Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles) |
|
272 | CS | P | F | 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 | Parameterized exception: wrong output when number of arguments greater than 7 |
|
273 | SS | P | F | 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 | Parameterized exception: wrong output when number of arguments greater than 7 |
|
274 | CS | P | F | 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 | AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role |
|
275 | SS | P | F | 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 | AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role |
|
276 | CS | P | F | 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 | Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns |
|
277 | SS | P | F | 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 | Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns |
|
278 | CS | P | F | 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 | Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL |
|
279 | SS | P | F | 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 | Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL |
|
280 | CS | P | F | 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 | Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters |
|
281 | SS | P | F | 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 | Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters |
|
282 | CS | P | F | 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 | Regression: generators can be seen/modified by unprivileged users |
|
283 | SS | P | F | 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 | Regression: generators can be seen/modified by unprivileged users |
|
284 | CS | P | F | 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 | Regression: List of aggregation is not checked properly |
|
285 | SS | P | F | 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 | Regression: List of aggregation is not checked properly |
|
286 | CS | P | F | 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 | HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations |
|
287 | SS | P | F | 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 | HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations |
|
288 | CS | P | F | 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 | Make user names behave according to SQL identifiers rules |
|
289 | SS | P | F | 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 | Make user names behave according to SQL identifiers rules |
|
290 | CS | P | F | 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 | EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck |
|
291 | SS | P | F | 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 | EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck |
|
292 | CS | P | F | 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 | Make ISQL display character set when sqlda_display is on |
|
293 | SS | P | F | 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 | Make ISQL display character set when sqlda_display is on |
|
294 | CS | P | F | 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 | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
295 | SS | P | F | 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 | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
296 | CS | P | F | 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 | SHOW GRANTS does not display info about exceptions which were granted to user |
|
297 | SS | P | F | 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 | SHOW GRANTS does not display info about exceptions which were granted to user |
|
298 | CS | P | F | 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 | Altering a trigger indicating other table than the original does not reflect the change |
|
299 | SS | P | F | 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 | Altering a trigger indicating other table than the original does not reflect the change |
|
300 | CS | P | F | 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 | Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672" |
|
301 | SS | P | F | 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 | Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672" |
|
302 | CS | P | F | 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 | Crash on pasring of script containing `execute block` with lot of nested begin..end statements |
|
303 | SS | P | F | 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 | Crash on pasring of script containing `execute block` with lot of nested begin..end statements |
|
304 | CS | P | F | 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 | Invalid internal BLR filter conversion |
|
305 | SS | P | F | 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 | Invalid internal BLR filter conversion |
|
306 | CS | P | F | 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 | ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*' |
|
307 | SS | P | F | 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 | ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*' |
|
308 | CS | P | F | 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 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
309 | SS | P | F | 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 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
310 | CS | P | F | 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 | IIF function prevents the condition from being pushed into the union for better optimization |
|
311 | SS | P | F | 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 | IIF function prevents the condition from being pushed into the union for better optimization |
|
312 | CS | P | F | 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 | Add label about deterministic flag for stored function in SHOW and extract commands |
|
313 | SS | P | F | 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 | Add label about deterministic flag for stored function in SHOW and extract commands |
|
314 | CS | P | F | 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 | Operator REVOKE can modify rights granted to system tables at DB creation time |
|
315 | SS | P | F | 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 | Operator REVOKE can modify rights granted to system tables at DB creation time |
|
316 | CS | P | F | 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 | Non-privileged user can implicitly count records in a restricted table |
|
317 | SS | P | F | 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 | Non-privileged user can implicitly count records in a restricted table |
|
318 | CS | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Restore of encrypted backup of database with SQL dialect 1 fails |
|
319 | SS | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Restore of encrypted backup of database with SQL dialect 1 fails |
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.858
|
6.0.0.854
|
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.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
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | 17656 | 17334 | 18471 | 43018 | 17628 | 17353 | 17350 | 17966 | 17874 | 17656 | 17539 | 17454 | 17664 | 17824 | 17772 | 17658 | 18107 | 17539 | 17657 | 17626 | 17705 | 17683 | 17286 | 18185 | 17489 | 17382 | 17799 | 17343 | 17332 | 18053 | 17286 | Count (DISTINCT ...) is too slow |
|
2 | CS | 1304 | 1438 | 1476 | 1449 | 511 | 494 | 503 | 520 | 520 | 507 | 498 | 490 | 510 | 518 | 501 | 1310 | 1318 | 1316 | 1381 | 1312 | 1316 | 1305 | 1330 | 1295 | 1326 | 1303 | 1308 | 1297 | 1336 | 1315 | 1282 | Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan |
|
3 | SS | 981 | 1321 | 1152 | 1162 | 407 | 409 | 384 | 404 | 728 | 895 | 694 | 385 | 641 | 387 | 436 | 1009 | 1209 | 983 | 1025 | 1264 | 977 | 1358 | 993 | 971 | 1032 | 975 | 980 | 1020 | 1006 | 1007 | 1046 | Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan |
|
4 | CS | 586 | 619 | 642 | 585 | 654 | 615 | 595 | 596 | 595 | 597 | 594 | 588 | 598 | 588 | 626 | 580 | 567 | 542 | 566 | 582 | 572 | 574 | 599 | 592 | 544 | 548 | 572 | 539 | 548 | 554 | 570 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
5 | SS | 375 | 387 | 408 | 2713 | 420 | 404 | 409 | 397 | 411 | 400 | 402 | 408 | 416 | 405 | 406 | 372 | 373 | 357 | 362 | 373 | 364 | 359 | 377 | 369 | 367 | 362 | 366 | 362 | 364 | 359 | 361 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
6 | CS | 808 | 828 | 851 | 816 | 855 | 841 | 813 | 815 | 821 | 842 | 818 | 834 | 876 | 828 | 848 | 814 | 753 | 804 | 754 | 754 | 766 | 784 | 768 | 753 | 764 | 750 | 752 | 752 | 756 | 753 | 752 | Prohibit any improper mixture of explicit and implicit joins |
|
7 | SS | 539 | 540 | 564 | 3296 | 576 | 548 | 580 | 781 | 987 | 1066 | 1009 | 556 | 998 | 564 | 622 | 502 | 538 | 512 | 516 | 527 | 558 | 519 | 505 | 497 | 512 | 528 | 529 | 503 | 517 | 533 | 533 | Prohibit any improper mixture of explicit and implicit joins |
|
8 | CS | 598 | 635 | 604 | 603 | 683 | 613 | 614 | 639 | 649 | 617 | 602 | 635 | 636 | 602 | 597 | 571 | 580 | 558 | 559 | 575 | 554 | 586 | 599 | 590 | 578 | 556 | 569 | 569 | 565 | 561 | 618 | Join condition fails for UTF-8 databases |
|
9 | SS | 402 | 410 | 425 | 1700 | 419 | 420 | 416 | 425 | 421 | 435 | 425 | 424 | 442 | 421 | 711 | 403 | 374 | 376 | 391 | 374 | 377 | 376 | 382 | 379 | 391 | 401 | 377 | 378 | 384 | 373 | 374 | Join condition fails for UTF-8 databases |
|
10 | CS | 649 | 686 | 674 | 701 | 702 | 669 | 662 | 664 | 662 | 662 | 689 | 657 | 666 | 652 | 686 | 611 | 616 | 615 | 605 | 647 | 620 | 612 | 612 | 598 | 611 | 608 | 644 | 605 | 617 | 609 | 651 | Natural is used to select instead of primary key index |
|
11 | SS | 443 | 455 | 465 | 1201 | 462 | 475 | 485 | 482 | 934 | 474 | 465 | 468 | 883 | 486 | 501 | 422 | 428 | 418 | 420 | 422 | 431 | 426 | 427 | 423 | 428 | 458 | 423 | 425 | 429 | 431 | 430 | Natural is used to select instead of primary key index |
|
12 | CS | 592 | 590 | 607 | 625 | 641 | 599 | 611 | 601 | 630 | 599 | 606 | 630 | 653 | 677 | 641 | 604 | 561 | 557 | 591 | 562 | 553 | 552 | 594 | 581 | 588 | 560 | 563 | 584 | 586 | 557 | 551 | isql should show packaged procedures and functions categorized per package |
|
13 | SS | 384 | 409 | 443 | 1306 | 419 | 429 | 666 | 424 | 425 | 463 | 417 | 421 | 432 | 423 | 429 | 359 | 382 | 373 | 375 | 374 | 386 | 382 | 375 | 367 | 371 | 359 | 372 | 359 | 377 | 366 | 372 | isql should show packaged procedures and functions categorized per package |
|
14 | CS | 775 | 586 | 819 | 809 | 850 | 819 | 795 | 834 | 800 | 821 | 840 | 797 | 808 | 797 | 792 | 778 | 767 | 764 | 771 | 753 | 772 | 755 | 754 | 768 | 771 | 756 | 784 | 746 | 753 | 743 | 740 | PK index is not used for derived tables |
|
15 | SS | 525 | 391 | 581 | 1963 | 546 | 544 | 556 | 562 | 561 | 586 | 546 | 543 | 591 | 570 | 837 | 520 | 500 | 498 | 515 | 530 | 512 | 517 | 519 | 497 | 533 | 502 | 516 | 503 | 506 | 519 | 507 | PK index is not used for derived tables |
|
16 | CS | 589 | 592 | 633 | 598 | 625 | 592 | 594 | 622 | 597 | 630 | 598 | 585 | 641 | 603 | 602 | 638 | 608 | 585 | 585 | 585 | 547 | 556 | 586 | 569 | 583 | 587 | 560 | 549 | 562 | 545 | 548 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
17 | SS | 386 | 394 | 417 | 1654 | 409 | 417 | 423 | 408 | 410 | 418 | 403 | 405 | 412 | 418 | 399 | 361 | 367 | 358 | 374 | 376 | 361 | 369 | 357 | 360 | 399 | 360 | 378 | 376 | 378 | 377 | 379 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
18 | CS | 586 | 633 | 640 | 585 | 620 | 635 | 594 | 607 | 625 | 592 | 588 | 591 | 600 | 603 | 592 | 547 | 598 | 539 | 546 | 547 | 553 | 541 | 545 | 532 | 548 | 545 | 561 | 550 | 550 | 590 | 549 | Broken error handling in the case of a conversion error happened during index creation |
|
19 | SS | 378 | 390 | 412 | 1689 | 403 | 407 | 418 | 409 | 406 | 404 | 404 | 400 | 400 | 402 | 411 | 363 | 359 | 361 | 362 | 360 | 375 | 377 | 362 | 359 | 370 | 367 | 356 | 362 | 372 | 375 | 379 | Broken error handling in the case of a conversion error happened during index creation |
|
20 | CS | 787 | 594 | 822 | 798 | 828 | 819 | 816 | 818 | 806 | 835 | 836 | 807 | 826 | 815 | 788 | 782 | 749 | 788 | 750 | 749 | 755 | 750 | 757 | 781 | 766 | 786 | 784 | 785 | 800 | 749 | 739 | DROP VIEW drops output parameters of used stored procedures |
|
21 | SS | 531 | 390 | 556 | 1373 | 566 | 558 | 563 | 548 | 563 | 611 | 559 | 563 | 555 | 577 | 560 | 545 | 503 | 518 | 512 | 517 | 531 | 518 | 501 | 501 | 518 | 505 | 524 | 512 | 521 | 532 | 516 | DROP VIEW drops output parameters of used stored procedures |
|
22 | CS | 805 | 631 | 809 | 835 | 918 | 815 | 810 | 827 | 812 | 814 | 815 | 819 | 864 | 809 | 810 | 771 | 787 | 764 | 803 | 797 | 807 | 765 | 776 | 768 | 789 | 793 | 765 | 775 | 1051 | 764 | 743 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
23 | SS | 524 | 393 | 565 | 559 | 604 | 567 | 591 | 855 | 569 | 727 | 850 | 550 | 773 | 569 | 1128 | 506 | 523 | 522 | 523 | 522 | 523 | 522 | 519 | 522 | 519 | 519 | 523 | 525 | 522 | 525 | 520 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
24 | CS | 801 | 603 | 874 | 816 | 855 | 821 | 828 | 823 | 825 | 821 | 822 | 808 | 883 | 818 | 807 | 804 | 773 | 765 | 811 | 760 | 754 | 749 | 780 | 758 | 776 | 798 | 783 | 784 | 757 | 748 | 783 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
25 | SS | 533 | 402 | 562 | 788 | 568 | 569 | 587 | 566 | 561 | 561 | 574 | 558 | 610 | 597 | 589 | 533 | 517 | 526 | 527 | 519 | 529 | 528 | 515 | 522 | 533 | 525 | 534 | 525 | 517 | 525 | 519 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
26 | CS | 609 | 612 | 621 | 642 | 653 | 628 | 607 | 615 | 647 | 645 | 632 | 613 | 630 | 611 | 620 | 587 | 569 | 603 | 663 | 573 | 605 | 596 | 563 | 560 | 578 | 616 | 591 | 558 | 570 | 566 | 576 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
27 | SS | 398 | 401 | 439 | 459 | 429 | 442 | 428 | 429 | 430 | 808 | 437 | 438 | 429 | 433 | 428 | 393 | 394 | 391 | 388 | 389 | 381 | 380 | 378 | 395 | 410 | 373 | 378 | 379 | 379 | 380 | 382 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
28 | CS | 717 | 830 | 758 | 717 | 763 | 718 | 749 | 756 | 748 | 749 | 710 | 718 | 749 | 744 | 759 | 727 | 708 | 675 | 734 | 666 | 655 | 667 | 662 | 682 | 674 | 670 | 680 | 679 | 779 | 657 | 669 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
29 | SS | 513 | 831 | 537 | 683 | 544 | 543 | 540 | 544 | 553 | 537 | 531 | 524 | 700 | 530 | 534 | 499 | 503 | 658 | 486 | 483 | 477 | 482 | 472 | 479 | 490 | 472 | 492 | 470 | 492 | 489 | 485 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
30 | CS | 791 | 646 | 802 | 793 | 829 | 833 | 826 | 812 | 839 | 833 | 847 | 789 | 857 | 833 | 823 | 770 | 748 | 752 | 801 | 750 | 758 | 761 | 748 | 753 | 756 | 762 | 749 | 800 | 745 | 813 | 749 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
31 | SS | 524 | 396 | 547 | 600 | 539 | 552 | 568 | 540 | 550 | 552 | 544 | 552 | 539 | 566 | 544 | 522 | 507 | 506 | 521 | 495 | 545 | 497 | 506 | 508 | 526 | 520 | 509 | 508 | 508 | 490 | 491 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
32 | CS | 594 | 608 | 639 | 600 | 641 | 615 | 610 | 633 | 635 | 607 | 608 | 605 | 656 | 671 | 609 | 575 | 566 | 560 | 614 | 586 | 567 | 554 | 589 | 549 | 555 | 569 | 546 | 579 | 555 | 545 | 552 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
33 | SS | 406 | 403 | 417 | 558 | 426 | 428 | 420 | 418 | 418 | 428 | 418 | 414 | 419 | 443 | 424 | 811 | 378 | 368 | 379 | 363 | 410 | 376 | 398 | 377 | 366 | 385 | 361 | 377 | 378 | 379 | 376 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
34 | CS | 932 | 960 | 966 | 984 | 1088 | 1009 | 979 | 963 | 946 | 980 | 949 | 967 | 958 | 1028 | 996 | 890 | 918 | 883 | 915 | 880 | 898 | 886 | 877 | 882 | 911 | 949 | 878 | 883 | 881 | 878 | 896 | Cannot alter the domain after migrating from older versions |
|
35 | SS | 623 | 642 | 639 | 701 | 641 | 653 | 647 | 626 | 663 | 650 | 652 | 647 | 649 | 652 | 651 | 621 | 602 | 594 | 597 | 582 | 639 | 590 | 592 | 577 | 598 | 585 | 593 | 576 | 587 | 584 | 583 | Cannot alter the domain after migrating from older versions |
|
36 | CS | 671 | 958 | 683 | 687 | 729 | 720 | 684 | 691 | 684 | 678 | 691 | 711 | 713 | 690 | 740 | 626 | 640 | 637 | 697 | 628 | 634 | 634 | 630 | 628 | 636 | 662 | 664 | 625 | 665 | 644 | 630 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
37 | SS | 464 | 517 | 493 | 572 | 491 | 497 | 492 | 495 | 536 | 504 | 486 | 515 | 497 | 486 | 479 | 466 | 456 | 449 | 449 | 455 | 463 | 443 | 442 | 441 | 442 | 440 | 439 | 444 | 440 | 445 | 452 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
38 | CS | 827 | 850 | 843 | 853 | 888 | 858 | 844 | 853 | 859 | 848 | 876 | 842 | 843 | 869 | 850 | 807 | 812 | 802 | 831 | 815 | 797 | 821 | 824 | 820 | 817 | 819 | 787 | 805 | 804 | 801 | 794 | Expression index with TRIM may lead to incorrect indexed lookup |
|
39 | SS | 571 | 594 | 593 | 608 | 591 | 591 | 593 | 598 | 595 | 620 | 608 | 596 | 669 | 792 | 592 | 548 | 561 | 543 | 553 | 548 | 582 | 543 | 547 | 549 | 554 | 560 | 560 | 553 | 550 | 543 | 548 | Expression index with TRIM may lead to incorrect indexed lookup |
|
40 | CS | 793 | 592 | 840 | 814 | 852 | 815 | 815 | 851 | 796 | 847 | 813 | 801 | 868 | 821 | 826 | 774 | 829 | 742 | 799 | 769 | 751 | 768 | 790 | 746 | 754 | 753 | 769 | 754 | 756 | 767 | 753 | Index is not used when view has "subselect" column |
|
41 | SS | 517 | 405 | 559 | 617 | 559 | 560 | 548 | 543 | 559 | 553 | 564 | 552 | 738 | 564 | 545 | 500 | 510 | 500 | 510 | 506 | 536 | 503 | 501 | 499 | 521 | 506 | 513 | 500 | 506 | 501 | 506 | Index is not used when view has "subselect" column |
|
42 | CS | 789 | 598 | 821 | 827 | 848 | 817 | 827 | 836 | 812 | 819 | 839 | 789 | 850 | 803 | 814 | 835 | 785 | 786 | 793 | 744 | 751 | 749 | 759 | 780 | 757 | 789 | 749 | 733 | 738 | 747 | 778 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
43 | SS | 525 | 408 | 561 | 573 | 550 | 567 | 562 | 565 | 559 | 561 | 546 | 559 | 589 | 557 | 549 | 526 | 503 | 515 | 512 | 516 | 549 | 510 | 490 | 505 | 510 | 514 | 525 | 519 | 519 | 508 | 520 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
44 | CS | 797 | 590 | 819 | 798 | 853 | 815 | 804 | 822 | 804 | 852 | 810 | 798 | 828 | 842 | 825 | 766 | 776 | 770 | 828 | 765 | 796 | 794 | 795 | 785 | 758 | 812 | 752 | 772 | 797 | 752 | 758 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
45 | SS | 534 | 403 | 551 | 568 | 576 | 564 | 555 | 556 | 563 | 569 | 734 | 539 | 774 | 556 | 743 | 517 | 520 | 536 | 515 | 518 | 533 | 516 | 508 | 512 | 508 | 519 | 522 | 515 | 522 | 535 | 516 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
46 | CS | 618 | 627 | 676 | 657 | 654 | 627 | 664 | 664 | 630 | 660 | 623 | 618 | 623 | 627 | 618 | 623 | 592 | 611 | 607 | 566 | 606 | 580 | 582 | 602 | 581 | 585 | 670 | 610 | 578 | 602 | 580 | UTF8 UNICODE_CI collate can not be used in compound index |
|
47 | SS | 425 | 438 | 438 | 451 | 455 | 430 | 450 | 440 | 426 | 437 | 824 | 425 | 435 | 424 | 722 | 738 | 392 | 399 | 388 | 393 | 427 | 393 | 388 | 392 | 393 | 392 | 394 | 393 | 396 | 427 | 388 | UTF8 UNICODE_CI collate can not be used in compound index |
|
48 | CS | 580 | 592 | 599 | 596 | 630 | 590 | 596 | 678 | 592 | 594 | 594 | 599 | 597 | 630 | 626 | 548 | 577 | 557 | 578 | 550 | 544 | 548 | 546 | 536 | 553 | 545 | 576 | 547 | 583 | 547 | 573 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
49 | SS | 383 | 386 | 404 | 1331 | 406 | 406 | 419 | 404 | 404 | 436 | 408 | 401 | 404 | 419 | 441 | 380 | 359 | 370 | 353 | 369 | 388 | 363 | 367 | 359 | 359 | 365 | 361 | 367 | 366 | 365 | 361 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
50 | CS | 582 | 592 | 586 | 590 | 619 | 590 | 599 | 611 | 627 | 595 | 596 | 593 | 592 | 628 | 606 | 556 | 585 | 546 | 553 | 576 | 541 | 546 | 543 | 567 | 552 | 576 | 556 | 541 | 580 | 549 | 548 | "BLOB not found" error after creation/altering of the invalid trigger |
|
51 | SS | 397 | 386 | 407 | 1363 | 401 | 410 | 408 | 401 | 401 | 408 | 400 | 404 | 436 | 414 | 410 | 358 | 361 | 438 | 825 | 355 | 394 | 358 | 356 | 359 | 357 | 365 | 367 | 362 | 358 | 362 | 366 | "BLOB not found" error after creation/altering of the invalid trigger |
|
52 | CS | 798 | 824 | 807 | 798 | 856 | 812 | 843 | 846 | 836 | 835 | 856 | 798 | 843 | 834 | 829 | 832 | 764 | 751 | 753 | 762 | 759 | 763 | 749 | 833 | 753 | 758 | 756 | 752 | 750 | 791 | 756 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
53 | SS | 544 | 565 | 558 | 913 | 574 | 572 | 571 | 568 | 563 | 576 | 585 | 559 | 556 | 1033 | 571 | 523 | 533 | 513 | 499 | 513 | 548 | 534 | 517 | 503 | 503 | 502 | 506 | 518 | 541 | 502 | 498 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
54 | CS | 576 | 583 | 580 | 579 | 618 | 600 | 602 | 596 | 583 | 588 | 589 | 621 | 628 | 595 | 578 | 543 | 544 | 540 | 568 | 550 | 537 | 543 | 545 | 576 | 544 | 542 | 537 | 576 | 550 | 542 | 530 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
55 | SS | 388 | 383 | 393 | 608 | 406 | 402 | 394 | 404 | 412 | 402 | 399 | 406 | 406 | 408 | 396 | 361 | 373 | 363 | 365 | 348 | 395 | 352 | 360 | 356 | 361 | 363 | 360 | 420 | 356 | 344 | 346 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
56 | CS | 589 | 597 | 636 | 592 | 634 | 606 | 594 | 618 | 601 | 627 | 594 | 592 | 597 | 607 | 616 | 574 | 549 | 586 | 541 | 556 | 585 | 618 | 562 | 548 | 553 | 554 | 547 | 552 | 545 | 546 | 543 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
57 | SS | 393 | 389 | 407 | 608 | 406 | 414 | 413 | 405 | 418 | 424 | 407 | 402 | 808 | 407 | 562 | 397 | 362 | 380 | 370 | 360 | 397 | 359 | 357 | 364 | 360 | 362 | 371 | 377 | 359 | 361 | 366 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
58 | CS | 572 | 580 | 585 | 623 | 616 | 641 | 596 | 616 | 616 | 578 | 589 | 618 | 639 | 593 | 591 | 575 | 562 | 570 | 552 | 564 | 540 | 534 | 537 | 526 | 553 | 565 | 549 | 565 | 546 | 538 | 539 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
59 | SS | 388 | 385 | 412 | 537 | 402 | 409 | 403 | 454 | 405 | 402 | 436 | 411 | 434 | 419 | 437 | 360 | 360 | 392 | 357 | 358 | 394 | 358 | 360 | 358 | 360 | 363 | 361 | 361 | 363 | 356 | 341 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
60 | CS | 1034 | 1034 | 1070 | 1120 | 1091 | 1052 | 1090 | 1080 | 1042 | 1078 | 1046 | 1034 | 1074 | 1107 | 1058 | 959 | 949 | 998 | 957 | 947 | 953 | 947 | 1034 | 962 | 1018 | 1048 | 940 | 941 | 965 | 964 | 935 | Generators are set to 0 after restore |
|
61 | SS | 755 | 772 | 793 | 1011 | 785 | 808 | 783 | 781 | 776 | 812 | 779 | 780 | 985 | 791 | 777 | 714 | 719 | 1003 | 690 | 692 | 739 | 683 | 678 | 693 | 692 | 704 | 706 | 715 | 708 | 692 | 692 | Generators are set to 0 after restore |
|
62 | CS | 782 | 815 | 826 | 796 | 813 | 883 | 839 | 797 | 786 | 822 | 793 | 787 | 831 | 788 | 821 | 743 | 750 | 771 | 747 | 779 | 746 | 744 | 815 | 734 | 753 | 766 | 744 | 775 | 750 | 741 | 749 | Blob filter to translate internal debug info into text representation |
|
63 | SS | 527 | 533 | 543 | 694 | 546 | 559 | 560 | 560 | 565 | 551 | 527 | 545 | 648 | 619 | 541 | 501 | 505 | 720 | 499 | 497 | 527 | 501 | 502 | 490 | 504 | 504 | 506 | 513 | 503 | 500 | 506 | Blob filter to translate internal debug info into text representation |
|
64 | CS | 577 | 591 | 595 | 619 | 615 | 597 | 627 | 601 | 622 | 600 | 584 | 619 | 626 | 621 | 610 | 537 | 571 | 551 | 547 | 619 | 549 | 548 | 541 | 540 | 544 | 553 | 553 | 544 | 548 | 559 | 538 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
65 | SS | 388 | 392 | 401 | 2516 | 406 | 412 | 403 | 564 | 581 | 416 | 586 | 405 | 416 | 585 | 605 | 366 | 365 | 358 | 370 | 362 | 385 | 355 | 362 | 359 | 359 | 360 | 413 | 380 | 363 | 367 | 364 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
66 | CS | 770 | 760 | 968 | 851 | 859 | 854 | 846 | 853 | 842 | 851 | 857 | 852 | 840 | 851 | 838 | 733 | 806 | 733 | 771 | 727 | 732 | 736 | 728 | 718 | 770 | 735 | 735 | 752 | 731 | 720 | 731 | Recurse leads to hangs/crash server |
|
67 | SS | 547 | 555 | 601 | 825 | 605 | 620 | 616 | 618 | 618 | 621 | 661 | 602 | 684 | 663 | 640 | 539 | 518 | 535 | 514 | 531 | 517 | 586 | 506 | 521 | 532 | 537 | 534 | 513 | 517 | 520 | 518 | Recurse leads to hangs/crash server |
|
68 | CS | 806 | 646 | 823 | 819 | 843 | 830 | 848 | 822 | 817 | 818 | 842 | 843 | 830 | 819 | 845 | 789 | 774 | 781 | 750 | 777 | 809 | 819 | 755 | 754 | 763 | 804 | 749 | 757 | 751 | 747 | 744 | [FB3] AV with "UPDATE OR INSERT" |
|
69 | SS | 536 | 408 | 567 | 626 | 582 | 583 | 567 | 583 | 579 | 585 | 568 | 565 | 583 | 569 | 565 | 516 | 530 | 501 | 519 | 552 | 525 | 543 | 526 | 504 | 521 | 513 | 504 | 502 | 525 | 513 | 503 | [FB3] AV with "UPDATE OR INSERT" |
|
70 | CS | 607 | 617 | 648 | 648 | 639 | 629 | 614 | 618 | 614 | 651 | 674 | 609 | 657 | 611 | 646 | 633 | 605 | 565 | 563 | 571 | 569 | 564 | 567 | 562 | 566 | 563 | 559 | 564 | 588 | 564 | 564 | Inefficient optimization (regression) |
|
71 | SS | 397 | 433 | 432 | 440 | 419 | 452 | 448 | 584 | 438 | 430 | 423 | 441 | 439 | 436 | 426 | 380 | 380 | 383 | 391 | 369 | 372 | 380 | 372 | 394 | 373 | 387 | 374 | 374 | 400 | 376 | 376 | Inefficient optimization (regression) |
|
72 | CS | 1128 | 1203 | 1170 | 1130 | 1193 | 1149 | 1175 | 1175 | 1146 | 1172 | 1199 | 1142 | 1143 | 1193 | 1166 | 1122 | 1116 | 1095 | 1084 | 1095 | 1153 | 1127 | 1099 | 1087 | 1118 | 1110 | 1085 | 1088 | 1096 | 1098 | 1072 | Regression in joins on procedures |
|
73 | SS | 812 | 1301 | 813 | 902 | 814 | 830 | 814 | 811 | 854 | 825 | 827 | 827 | 1339 | 817 | 825 | 766 | 816 | 765 | 769 | 788 | 765 | 763 | 754 | 844 | 771 | 790 | 753 | 756 | 801 | 776 | 765 | Regression in joins on procedures |
|
74 | CS | 799 | 598 | 808 | 815 | 837 | 819 | 807 | 805 | 828 | 811 | 803 | 826 | 831 | 805 | 855 | 788 | 814 | 758 | 805 | 778 | 769 | 795 | 747 | 745 | 767 | 771 | 760 | 754 | 794 | 744 | 759 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
75 | SS | 543 | 408 | 558 | 583 | 558 | 551 | 557 | 560 | 556 | 558 | 569 | 557 | 560 | 559 | 564 | 515 | 517 | 515 | 517 | 518 | 526 | 549 | 516 | 532 | 517 | 515 | 538 | 524 | 549 | 521 | 511 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
76 | CS | 778 | 617 | 811 | 836 | 838 | 830 | 820 | 821 | 814 | 793 | 820 | 828 | 832 | 828 | 834 | 818 | 761 | 744 | 746 | 743 | 751 | 756 | 763 | 743 | 815 | 755 | 758 | 747 | 754 | 755 | 752 | DROP VIEW ignores the existing non-column dependencies |
|
77 | SS | 528 | 414 | 561 | 596 | 560 | 564 | 635 | 547 | 563 | 571 | 561 | 555 | 572 | 558 | 549 | 500 | 506 | 533 | 577 | 514 | 515 | 511 | 500 | 519 | 497 | 518 | 516 | 522 | 524 | 524 | 500 | DROP VIEW ignores the existing non-column dependencies |
|
78 | CS | 785 | 1277 | 827 | 784 | 837 | 862 | 796 | 794 | 802 | 807 | 787 | 840 | 816 | 837 | 801 | 799 | 762 | 744 | 788 | 755 | 747 | 756 | 735 | 755 | 758 | 745 | 750 | 758 | 738 | 754 | 743 | Alter procedure allows to add the parameter with the same name |
|
79 | SS | 516 | 544 | 549 | 617 | 544 | 550 | 549 | 556 | 542 | 560 | 545 | 544 | 586 | 563 | 558 | 501 | 501 | 497 | 502 | 509 | 509 | 500 | 499 | 500 | 506 | 496 | 517 | 516 | 503 | 497 | 504 | Alter procedure allows to add the parameter with the same name |
|
80 | CS | 596 | 602 | 617 | 599 | 635 | 602 | 607 | 609 | 605 | 631 | 596 | 602 | 596 | 603 | 602 | 608 | 571 | 582 | 614 | 576 | 542 | 568 | 584 | 588 | 564 | 550 | 555 | 577 | 563 | 551 | 572 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
81 | SS | 406 | 410 | 404 | 414 | 410 | 410 | 403 | 732 | 406 | 405 | 411 | 479 | 453 | 406 | 409 | 98 | 359 | 431 | 376 | 544 | 559 | 381 | 365 | 364 | 373 | 367 | 407 | 500 | 378 | 358 | 363 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
82 | CS | 600 | 615 | 648 | 614 | 647 | 631 | 649 | 621 | 619 | 642 | 611 | 622 | 638 | 644 | 669 | 609 | 573 | 574 | 568 | 561 | 579 | 581 | 563 | 573 | 591 | 575 | 567 | 568 | 575 | 568 | 562 | Inconsistent domain's constraint validation in PSQL |
|
83 | SS | 404 | 423 | 429 | 463 | 437 | 433 | 434 | 435 | 435 | 447 | 441 | 447 | 436 | 438 | 437 | 386 | 389 | 385 | 390 | 389 | 395 | 376 | 404 | 374 | 386 | 395 | 387 | 404 | 393 | 388 | 390 | Inconsistent domain's constraint validation in PSQL |
|
84 | CS | 793 | 842 | 860 | 813 | 847 | 839 | 812 | 823 | 848 | 855 | 817 | 813 | 815 | 825 | 875 | 754 | 798 | 783 | 765 | 746 | 751 | 777 | 749 | 748 | 788 | 754 | 786 | 751 | 765 | 749 | 767 | Floating-point negative zero doesn't match positive zero in the index |
|
85 | SS | 538 | 552 | 554 | 594 | 569 | 548 | 561 | 567 | 583 | 558 | 563 | 591 | 561 | 580 | 574 | 518 | 522 | 518 | 522 | 534 | 533 | 523 | 540 | 509 | 510 | 536 | 514 | 507 | 501 | 519 | 527 | Floating-point negative zero doesn't match positive zero in the index |
|
86 | CS | 575 | 580 | 581 | 586 | 621 | 597 | 614 | 618 | 585 | 612 | 618 | 577 | 583 | 620 | 609 | 554 | 569 | 529 | 561 | 573 | 551 | 543 | 534 | 580 | 571 | 535 | 566 | 529 | 542 | 537 | 538 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
87 | SS | 395 | 387 | 409 | 396 | 391 | 402 | 401 | 406 | 422 | 406 | 408 | 420 | 410 | 408 | 396 | 545 | 395 | 357 | 360 | 362 | 417 | 358 | 375 | 362 | 359 | 409 | 364 | 357 | 362 | 365 | 347 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
88 | CS | 583 | 598 | 628 | 622 | 621 | 625 | 605 | 627 | 603 | 601 | 595 | 621 | 611 | 633 | 586 | 581 | 580 | 586 | 552 | 546 | 554 | 575 | 554 | 571 | 555 | 555 | 546 | 535 | 563 | 560 | 569 | CHAR(32767) present in XSQLVAR with length 32765 |
|
89 | SS | 386 | 437 | 409 | 417 | 422 | 411 | 410 | 718 | 443 | 416 | 684 | 417 | 840 | 684 | 422 | 361 | 363 | 359 | 369 | 371 | 360 | 374 | 379 | 362 | 394 | 364 | 358 | 361 | 374 | 363 | 362 | CHAR(32767) present in XSQLVAR with length 32765 |
|
90 | CS | 582 | 590 | 599 | 593 | 630 | 605 | 596 | 597 | 585 | 598 | 591 | 594 | 590 | 591 | 598 | 592 | 545 | 551 | 541 | 544 | 549 | 575 | 551 | 567 | 551 | 549 | 575 | 539 | 569 | 541 | 580 | Include expected and actual string lenght into error message for sqlcode -802 |
|
91 | SS | 370 | 402 | 410 | 408 | 405 | 402 | 405 | 423 | 413 | 405 | 407 | 404 | 421 | 410 | 410 | 359 | 364 | 374 | 358 | 360 | 354 | 355 | 362 | 364 | 359 | 359 | 360 | 362 | 362 | 366 | 360 | Include expected and actual string lenght into error message for sqlcode -802 |
|
92 | CS | 2932 | 2970 | 3243 | 2922 | 2938 | 2949 | 2983 | 3217 | 2943 | 2953 | 2944 | 2931 | 3395 | 2948 | 2935 | 2955 | 2933 | 2881 | 2911 | 2874 | 2879 | 2874 | 2934 | 2899 | 2907 | 2866 | 2856 | 2912 | 2893 | 2865 | 2906 | TRACE: add statistics of actions that were after transaction finished |
|
93 | SS | 2684 | 2911 | 2692 | 2738 | 2707 | 2703 | 2726 | 2708 | 2735 | 2782 | 2704 | 2715 | 2824 | 2862 | 2718 | 2669 | 2672 | 3007 | 2669 | 2666 | 2673 | 2653 | 2656 | 2660 | 2669 | 2660 | 2672 | 2677 | 2654 | 2662 | 2663 | TRACE: add statistics of actions that were after transaction finished |
|
94 | CS | 651 | 671 | 668 | 652 | 678 | 682 | 672 | 667 | 668 | 691 | 681 | 675 | 659 | 682 | 688 | 616 | 650 | 609 | 610 | 627 | 609 | 615 | 620 | 781 | 627 | 619 | 620 | 609 | 613 | 604 | 607 | Can insert DUPLICATE keys in UNIQUE index |
|
95 | SS | 392 | 360 | 427 | 438 | 436 | 438 | 440 | 437 | 441 | 440 | 440 | 446 | 424 | 442 | 570 | 380 | 392 | 397 | 391 | 390 | 388 | 390 | 375 | 378 | 392 | 391 | 393 | 392 | 387 | 378 | 388 | Can insert DUPLICATE keys in UNIQUE index |
|
96 | CS | 581 | 595 | 585 | 600 | 601 | 594 | 604 | 636 | 596 | 636 | 638 | 596 | 652 | 598 | 600 | 580 | 550 | 557 | 546 | 582 | 581 | 554 | 542 | 547 | 558 | 541 | 554 | 576 | 572 | 572 | 540 | Server crashes with access violation when inserting row into table with unique index |
|
97 | SS | 397 | 403 | 404 | 423 | 402 | 416 | 406 | 449 | 419 | 406 | 408 | 412 | 414 | 405 | 406 | 364 | 359 | 364 | 372 | 361 | 367 | 485 | 368 | 392 | 371 | 383 | 375 | 364 | 360 | 366 | 362 | Server crashes with access violation when inserting row into table with unique index |
|
98 | CS | 612 | 636 | 625 | 615 | 647 | 624 | 654 | 621 | 617 | 632 | 630 | 713 | 669 | 675 | 648 | 598 | 622 | 564 | 571 | 610 | 600 | 565 | 578 | 565 | 573 | 579 | 574 | 573 | 569 | 566 | 572 | computed index by substring function for long columns |
|
99 | SS | 393 | 413 | 416 | 688 | 432 | 419 | 423 | 464 | 435 | 600 | 418 | 433 | 419 | 430 | 437 | 378 | 378 | 387 | 399 | 379 | 376 | 387 | 380 | 368 | 380 | 372 | 382 | 387 | 382 | 388 | 373 | computed index by substring function for long columns |
|
100 | CS | 569 | 589 | 582 | 582 | 587 | 601 | 589 | 589 | 587 | 623 | 618 | 610 | 580 | 588 | 631 | 569 | 546 | 540 | 537 | 552 | 534 | 556 | 546 | 532 | 545 | 547 | 541 | 552 | 570 | 532 | 537 | Wrong warning message for ambiguous query |
|
101 | SS | 374 | 391 | 402 | 408 | 420 | 393 | 403 | 803 | 672 | 400 | 402 | 397 | 727 | 410 | 409 | 359 | 371 | 358 | 359 | 351 | 365 | 357 | 365 | 361 | 361 | 378 | 364 | 360 | 362 | 358 | 360 | Wrong warning message for ambiguous query |
|
102 | CS | 575 | 579 | 594 | 583 | 611 | 596 | 617 | 620 | 585 | 595 | 584 | 623 | 605 | 591 | 578 | 568 | 598 | 541 | 543 | 544 | 537 | 548 | 566 | 536 | 572 | 549 | 541 | 548 | 573 | 540 | 542 | Wrong warning message for ambiguous query |
|
103 | SS | 377 | 391 | 393 | 406 | 402 | 429 | 408 | 400 | 397 | 405 | 405 | 406 | 414 | 407 | 413 | 357 | 360 | 365 | 360 | 362 | 350 | 371 | 355 | 346 | 370 | 359 | 357 | 357 | 357 | 383 | 361 | Wrong warning message for ambiguous query |
|
104 | CS | 595 | 598 | 597 | 614 | 642 | 632 | 600 | 648 | 630 | 607 | 626 | 600 | 667 | 627 | 593 | 604 | 587 | 547 | 551 | 585 | 556 | 613 | 561 | 550 | 545 | 555 | 546 | 548 | 548 | 582 | 550 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
105 | SS | 380 | 411 | 409 | 415 | 415 | 420 | 440 | 416 | 434 | 421 | 407 | 428 | 413 | 407 | 422 | 360 | 379 | 369 | 374 | 371 | 381 | 367 | 357 | 364 | 377 | 377 | 377 | 356 | 375 | 372 | 372 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
106 | CS | 768 | 1012 | 844 | 878 | 842 | 862 | 828 | 834 | 829 | 827 | 795 | 832 | 784 | 838 | 799 | 766 | 745 | 770 | 745 | 745 | 751 | 754 | 755 | 767 | 755 | 749 | 744 | 749 | 743 | 752 | 746 | IS NOT DISTINCT FROM NULL doesn't use index |
|
107 | SS | 519 | 408 | 548 | 558 | 555 | 542 | 552 | 583 | 536 | 569 | 577 | 538 | 541 | 539 | 543 | 516 | 523 | 503 | 502 | 519 | 516 | 519 | 497 | 497 | 499 | 506 | 504 | 504 | 514 | 520 | 499 | IS NOT DISTINCT FROM NULL doesn't use index |
|
108 | CS | 1182 | 1133 | 1231 | 1221 | 1264 | 1229 | 1218 | 1259 | 1297 | 1252 | 1221 | 1247 | 1254 | 1276 | 1235 | 1175 | 1130 | 1190 | 1125 | 1139 | 1144 | 1118 | 1192 | 1136 | 1139 | 1164 | 1159 | 1121 | 1124 | 1109 | 1125 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
109 | SS | 725 | 696 | 760 | 931 | 782 | 1221 | 807 | 745 | 1140 | 771 | 748 | 770 | 760 | 759 | 784 | 863 | 693 | 667 | 689 | 666 | 667 | 666 | 670 | 684 | 671 | 695 | 686 | 685 | 706 | 871 | 671 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
110 | CS | 1748 | 1746 | 1808 | 1789 | 1783 | 1789 | 1798 | 1784 | 1850 | 1792 | 1784 | 1783 | 1810 | 1793 | 1783 | 1708 | 1719 | 1735 | 1675 | 1702 | 1657 | 1658 | 1751 | 1677 | 1658 | 1723 | 1686 | 1763 | 1682 | 1685 | 1696 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
111 | SS | 969 | 849 | 1021 | 1040 | 1047 | 1037 | 1108 | 1028 | 1033 | 1075 | 1030 | 1060 | 1041 | 1053 | 1037 | 956 | 953 | 941 | 982 | 936 | 940 | 943 | 941 | 915 | 939 | 946 | 954 | 952 | 1148 | 944 | 950 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
112 | CS | 771 | 614 | 795 | 831 | 839 | 783 | 793 | 795 | 796 | 955 | 939 | 958 | 1004 | 986 | 976 | 757 | 739 | 744 | 732 | 783 | 1059 | 760 | 741 | 757 | 754 | 748 | 751 | 749 | 754 | 733 | 747 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
113 | SS | 511 | 390 | 528 | 573 | 714 | 555 | 548 | 533 | 825 | 596 | 557 | 561 | 561 | 563 | 550 | 505 | 648 | 503 | 504 | 505 | 502 | 501 | 502 | 484 | 502 | 516 | 507 | 497 | 503 | 500 | 503 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
114 | CS | 572 | 582 | 583 | 588 | 615 | 580 | 581 | 591 | 578 | 591 | 633 | 593 | 586 | 578 | 580 | 555 | 555 | 563 | 574 | 538 | 545 | 541 | 550 | 530 | 561 | 552 | 571 | 569 | 540 | 552 | 533 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
115 | SS | 368 | 380 | 426 | 407 | 395 | 401 | 407 | 388 | 400 | 403 | 405 | 388 | 397 | 414 | 394 | 364 | 359 | 356 | 359 | 359 | 360 | 366 | 356 | 359 | 362 | 371 | 362 | 363 | 361 | 357 | 349 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
116 | CS | 593 | 602 | 599 | 633 | 649 | 611 | 640 | 617 | 620 | 625 | 612 | 634 | 596 | 609 | 603 | 564 | 546 | 560 | 563 | 545 | 549 | 590 | 609 | 547 | 573 | 560 | 554 | 590 | 551 | 551 | 562 | Extend the error reported for index/constraint violations to include the problematic key value |
|
117 | SS | 397 | 402 | 409 | 428 | 428 | 420 | 425 | 407 | 418 | 420 | 415 | 435 | 424 | 423 | 420 | 379 | 380 | 372 | 374 | 392 | 376 | 360 | 376 | 369 | 374 | 408 | 374 | 379 | 378 | 372 | 380 | Extend the error reported for index/constraint violations to include the problematic key value |
|
118 | CS | 589 | 590 | 604 | 604 | 627 | 605 | 652 | 637 | 634 | 627 | 604 | 598 | 665 | 631 | 643 | 555 | 573 | 555 | 561 | 546 | 589 | 585 | 559 | 570 | 563 | 573 | 571 | 553 | 552 | 592 | 555 | Wrong numbers in error message for decreasing char/varchar columns |
|
119 | SS | 381 | 407 | 408 | 449 | 407 | 419 | 417 | 411 | 415 | 424 | 404 | 407 | 422 | 413 | 425 | 365 | 363 | 363 | 375 | 362 | 375 | 376 | 365 | 359 | 382 | 366 | 363 | 377 | 381 | 366 | 367 | Wrong numbers in error message for decreasing char/varchar columns |
|
120 | CS | 576 | 610 | 640 | 591 | 619 | 627 | 618 | 595 | 615 | 582 | 595 | 592 | 620 | 579 | 615 | 547 | 568 | 539 | 550 | 546 | 591 | 567 | 573 | 538 | 544 | 540 | 534 | 549 | 543 | 535 | 520 | Derived fields may not be optimized via an index |
|
121 | SS | 373 | 397 | 390 | 405 | 402 | 410 | 395 | 856 | 583 | 402 | 391 | 405 | 607 | 418 | 404 | 367 | 359 | 355 | 358 | 363 | 360 | 358 | 363 | 342 | 349 | 363 | 358 | 359 | 379 | 358 | 360 | Derived fields may not be optimized via an index |
|
122 | CS | 579 | 593 | 588 | 624 | 603 | 635 | 606 | 623 | 597 | 630 | 624 | 590 | 616 | 662 | 608 | 598 | 553 | 553 | 560 | 548 | 550 | 570 | 552 | 539 | 555 | 551 | 546 | 555 | 555 | 547 | 549 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
123 | SS | 382 | 407 | 417 | 413 | 547 | 416 | 416 | 408 | 416 | 432 | 416 | 412 | 416 | 413 | 428 | 355 | 382 | 374 | 382 | 369 | 375 | 371 | 360 | 363 | 371 | 359 | 366 | 373 | 372 | 368 | 375 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
124 | CS | 806 | 864 | 831 | 828 | 865 | 823 | 828 | 836 | 836 | 909 | 818 | 827 | 860 | 829 | 841 | 784 | 790 | 802 | 804 | 784 | 798 | 791 | 788 | 771 | 765 | 788 | 792 | 809 | 775 | 790 | 763 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
125 | SS | 556 | 558 | 579 | 586 | 586 | 579 | 583 | 584 | 584 | 580 | 588 | 586 | 575 | 571 | 597 | 535 | 537 | 541 | 526 | 540 | 544 | 541 | 540 | 545 | 539 | 534 | 533 | 547 | 554 | 568 | 524 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
126 | CS | 591 | 618 | 601 | 600 | 644 | 598 | 610 | 619 | 611 | 610 | 602 | 600 | 601 | 633 | 605 | 587 | 557 | 556 | 595 | 547 | 554 | 581 | 555 | 569 | 582 | 564 | 556 | 575 | 586 | 551 | 547 | isql doesn't know the difference between UDF's and psql-functions |
|
127 | SS | 382 | 390 | 416 | 450 | 422 | 440 | 432 | 424 | 432 | 467 | 419 | 424 | 428 | 437 | 460 | 371 | 365 | 361 | 356 | 356 | 371 | 361 | 370 | 374 | 372 | 375 | 374 | 371 | 389 | 371 | 374 | isql doesn't know the difference between UDF's and psql-functions |
|
128 | CS | 581 | 583 | 617 | 585 | 614 | 593 | 618 | 584 | 597 | 583 | 591 | 658 | 589 | 633 | 593 | 591 | 556 | 542 | 541 | 550 | 548 | 580 | 571 | 568 | 552 | 575 | 548 | 553 | 561 | 532 | 534 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
129 | SS | 374 | 392 | 426 | 413 | 403 | 409 | 398 | 405 | 423 | 403 | 444 | 427 | 416 | 407 | 407 | 363 | 360 | 362 | 358 | 367 | 370 | 353 | 361 | 362 | 363 | 363 | 353 | 379 | 363 | 356 | 361 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
130 | CS | 589 | 599 | 644 | 602 | 641 | 605 | 617 | 601 | 603 | 606 | 608 | 600 | 596 | 656 | 600 | 572 | 571 | 563 | 560 | 565 | 560 | 563 | 568 | 583 | 565 | 558 | 563 | 561 | 567 | 557 | 601 | Join using RDB$DB_KEY produce NATURAL plan |
|
131 | SS | 399 | 428 | 421 | 432 | 417 | 419 | 426 | 636 | 446 | 433 | 727 | 432 | 423 | 417 | 422 | 380 | 378 | 370 | 376 | 377 | 375 | 404 | 375 | 371 | 375 | 376 | 395 | 392 | 383 | 375 | 379 | Join using RDB$DB_KEY produce NATURAL plan |
|
132 | CS | 601 | 605 | 639 | 624 | 631 | 638 | 665 | 608 | 622 | 609 | 635 | 607 | 670 | 609 | 630 | 562 | 563 | 552 | 565 | 553 | 557 | 563 | 566 | 598 | 795 | 591 | 565 | 555 | 563 | 586 | 546 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
133 | SS | 395 | 399 | 408 | 415 | 423 | 419 | 422 | 414 | 879 | 423 | 420 | 417 | 432 | 421 | 420 | 397 | 377 | 371 | 388 | 379 | 376 | 376 | 372 | 377 | 374 | 394 | 363 | 379 | 377 | 374 | 368 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
134 | CS | 771 | 616 | 825 | 868 | 822 | 892 | 847 | 839 | 799 | 825 | 837 | 790 | 837 | 849 | 784 | 781 | 759 | 746 | 756 | 756 | 756 | 737 | 745 | 762 | 914 | 751 | 756 | 758 | 750 | 760 | 759 | Broken optimization for the stored dbkeys |
|
135 | SS | 525 | 391 | 553 | 543 | 543 | 554 | 549 | 544 | 978 | 559 | 590 | 539 | 581 | 546 | 579 | 522 | 506 | 492 | 527 | 505 | 538 | 499 | 498 | 491 | 498 | 523 | 518 | 516 | 518 | 492 | 500 | Broken optimization for the stored dbkeys |
|
136 | CS | 581 | 580 | 595 | 590 | 642 | 624 | 629 | 588 | 597 | 601 | 599 | 618 | 595 | 641 | 622 | 542 | 553 | 546 | 551 | 571 | 548 | 578 | 583 | 535 | 601 | 540 | 543 | 540 | 541 | 544 | 576 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
137 | SS | 378 | 391 | 411 | 405 | 395 | 402 | 402 | 391 | 403 | 406 | 401 | 401 | 405 | 400 | 407 | 361 | 362 | 367 | 357 | 378 | 375 | 367 | 379 | 361 | 359 | 377 | 360 | 355 | 368 | 363 | 361 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
138 | CS | 787 | 584 | 818 | 812 | 852 | 836 | 801 | 814 | 830 | 792 | 835 | 799 | 801 | 855 | 787 | 755 | 817 | 747 | 755 | 748 | 755 | 765 | 738 | 733 | 1321 | 762 | 747 | 788 | 773 | 736 | 743 | Computed by columns and position function |
|
139 | SS | 524 | 392 | 546 | 545 | 562 | 541 | 562 | 1001 | 993 | 549 | 567 | 567 | 551 | 1017 | 1002 | 519 | 520 | 500 | 497 | 505 | 526 | 516 | 523 | 509 | 519 | 503 | 528 | 499 | 517 | 503 | 503 | Computed by columns and position function |
|
140 | CS | 799 | 597 | 799 | 807 | 847 | 844 | 842 | 848 | 836 | 847 | 817 | 799 | 812 | 831 | 832 | 775 | 755 | 796 | 749 | 801 | 751 | 818 | 792 | 742 | 1368 | 757 | 769 | 760 | 756 | 754 | 753 | Server bugchecks or crashes on exception in calculated index |
|
141 | SS | 530 | 397 | 562 | 565 | 568 | 545 | 562 | 577 | 567 | 568 | 563 | 567 | 551 | 571 | 569 | 505 | 511 | 507 | 504 | 505 | 560 | 498 | 548 | 500 | 505 | 515 | 500 | 500 | 504 | 503 | 499 | Server bugchecks or crashes on exception in calculated index |
|
142 | CS | 583 | 584 | 622 | 588 | 594 | 584 | 597 | 588 | 636 | 575 | 585 | 623 | 584 | 598 | 606 | 553 | 569 | 542 | 544 | 548 | 567 | 573 | 536 | 525 | 940 | 595 | 570 | 541 | 569 | 583 | 526 | Regression: Group by fails if subselect-column is involved |
|
143 | SS | 366 | 375 | 408 | 410 | 416 | 405 | 411 | 810 | 415 | 405 | 408 | 391 | 405 | 405 | 440 | 365 | 363 | 364 | 360 | 358 | 358 | 358 | 360 | 356 | 353 | 359 | 358 | 363 | 361 | 366 | 366 | Regression: Group by fails if subselect-column is involved |
|
144 | CS | 580 | 581 | 806 | 584 | 636 | 592 | 582 | 600 | 593 | 582 | 580 | 589 | 681 | 632 | 590 | 533 | 543 | 577 | 549 | 595 | 547 | 534 | 556 | 550 | 928 | 544 | 574 | 571 | 567 | 575 | 536 | Bad optimization of OR predicates applied to unions |
|
145 | SS | 379 | 392 | 392 | 394 | 392 | 404 | 406 | 403 | 405 | 405 | 421 | 391 | 419 | 407 | 412 | 361 | 386 | 360 | 362 | 361 | 353 | 361 | 360 | 352 | 372 | 347 | 357 | 353 | 359 | 367 | 359 | Bad optimization of OR predicates applied to unions |
|
146 | CS | 798 | 796 | 801 | 803 | 856 | 804 | 801 | 802 | 838 | 800 | 859 | 797 | 803 | 816 | 872 | 793 | 816 | 760 | 758 | 785 | 764 | 773 | 753 | 752 | 1369 | 759 | 757 | 755 | 765 | 837 | 763 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
147 | SS | 532 | 530 | 592 | 573 | 580 | 552 | 553 | 569 | 564 | 569 | 578 | 549 | 580 | 560 | 672 | 533 | 532 | 532 | 883 | 522 | 513 | 530 | 501 | 505 | 509 | 514 | 508 | 518 | 511 | 511 | 503 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
148 | CS | 795 | 619 | 815 | 810 | 803 | 826 | 817 | 837 | 817 | 833 | 871 | 815 | 881 | 833 | 787 | 805 | 750 | 743 | 756 | 776 | 757 | 746 | 772 | 749 | 1324 | 805 | 754 | 753 | 758 | 765 | 761 | Expression index may be not used for derived fields or view fields |
|
149 | SS | 528 | 396 | 554 | 569 | 542 | 540 | 562 | 555 | 558 | 533 | 566 | 553 | 837 | 552 | 707 | 505 | 528 | 500 | 505 | 507 | 502 | 512 | 506 | 504 | 528 | 504 | 519 | 509 | 530 | 513 | 505 | Expression index may be not used for derived fields or view fields |
|
150 | CS | 584 | 588 | 582 | 614 | 602 | 588 | 588 | 615 | 592 | 604 | 626 | 606 | 592 | 621 | 620 | 587 | 574 | 543 | 542 | 544 | 550 | 552 | 546 | 537 | 924 | 543 | 548 | 537 | 553 | 578 | 546 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
151 | SS | 382 | 391 | 407 | 410 | 394 | 420 | 401 | 409 | 404 | 408 | 455 | 415 | 422 | 399 | 414 | 389 | 362 | 357 | 363 | 365 | 364 | 375 | 357 | 359 | 362 | 361 | 352 | 354 | 366 | 359 | 358 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
152 | CS | 843 | 833 | 849 | 842 | 883 | 870 | 862 | 857 | 844 | 865 | 876 | 871 | 846 | 885 | 860 | 780 | 851 | 814 | 789 | 780 | 787 | 792 | 788 | 799 | 1478 | 783 | 788 | 797 | 777 | 847 | 786 | Metadata export with isql (option -ex) does not export functions properly |
|
153 | SS | 573 | 565 | 572 | 587 | 574 | 578 | 807 | 589 | 585 | 591 | 596 | 578 | 583 | 586 | 592 | 540 | 537 | 691 | 531 | 535 | 545 | 576 | 529 | 546 | 543 | 532 | 536 | 540 | 583 | 535 | 517 | Metadata export with isql (option -ex) does not export functions properly |
|
154 | CS | 784 | 833 | 849 | 847 | 877 | 862 | 592 | 598 | 622 | 620 | 625 | 620 | 595 | 607 | 592 | 841 | 786 | 778 | 837 | 778 | 787 | 786 | 783 | 780 | 1183 | 782 | 799 | 812 | 798 | 780 | 800 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
155 | SS | 532 | 561 | 617 | 588 | 580 | 581 | 398 | 407 | 404 | 409 | 471 | 397 | 424 | 439 | 418 | 530 | 534 | 522 | 543 | 531 | 530 | 531 | 531 | 539 | 538 | 538 | 533 | 541 | 550 | 535 | 537 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
156 | CS | 589 | 650 | 629 | 624 | 652 | 628 | 627 | 657 | 611 | 652 | 619 | 616 | 633 | 617 | 646 | 575 | 577 | 562 | 593 | 579 | 563 | 567 | 569 | 563 | 585 | 581 | 564 | 564 | 563 | 573 | 575 | New permission types are not displayed by ISQL |
|
157 | SS | 391 | 408 | 429 | 428 | 422 | 433 | 428 | 434 | 439 | 445 | 463 | 441 | 419 | 424 | 425 | 381 | 393 | 371 | 377 | 390 | 374 | 369 | 373 | 370 | 378 | 376 | 376 | 374 | 377 | 379 | 374 | New permission types are not displayed by ISQL |
|
158 | CS | 580 | 625 | 619 | 589 | 634 | 619 | 599 | 635 | 626 | 598 | 597 | 581 | 594 | 612 | 624 | 564 | 551 | 544 | 601 | 551 | 551 | 543 | 570 | 540 | 557 | 570 | 544 | 539 | 545 | 540 | 579 | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
159 | SS | 379 | 388 | 416 | 439 | 412 | 408 | 407 | 406 | 409 | 407 | 415 | 396 | 421 | 410 | 424 | 370 | 360 | 363 | 359 | 357 | 364 | 362 | 355 | 358 | 359 | 362 | 368 | 357 | 359 | 412 | 366 | RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE |
|
160 | CS | 804 | 837 | 854 | 815 | 848 | 806 | 813 | 856 | 813 | 828 | 806 | 823 | 820 | 806 | 836 | 825 | 762 | 781 | 766 | 764 | 802 | 776 | 758 | 770 | 790 | 782 | 749 | 753 | 778 | 743 | 773 | The parameterized exception does not accept not ASCII characters as parameter |
|
161 | SS | 544 | 547 | 565 | 634 | 558 | 566 | 567 | 559 | 559 | 731 | 590 | 560 | 564 | 562 | 763 | 520 | 546 | 517 | 520 | 516 | 539 | 530 | 517 | 516 | 519 | 516 | 543 | 518 | 521 | 520 | 521 | The parameterized exception does not accept not ASCII characters as parameter |
|
162 | CS | 1051 | 677 | 1117 | 1086 | 1107 | 1115 | 1138 | 1062 | 1084 | 1120 | 1111 | 1107 | 1130 | 1102 | 1070 | 1110 | 1035 | 1014 | 1017 | 1036 | 1021 | 1050 | 1027 | 1052 | 1050 | 1038 | 1017 | 1026 | 1019 | 1022 | 1022 | Replace the hierarchical union execution with the plain one |
|
163 | SS | 800 | 444 | 806 | 940 | 837 | 826 | 820 | 834 | 840 | 817 | 836 | 818 | 846 | 813 | 849 | 800 | 801 | 783 | 786 | 776 | 801 | 778 | 762 | 783 | 792 | 782 | 782 | 768 | 774 | 774 | 776 | Replace the hierarchical union execution with the plain one |
|
164 | CS | 576 | 613 | 596 | 583 | 635 | 606 | 599 | 599 | 597 | 594 | 597 | 616 | 594 | 585 | 608 | 556 | 540 | 542 | 553 | 574 | 548 | 548 | 579 | 548 | 544 | 573 | 561 | 550 | 555 | 550 | 551 | Cannot create packaged routines with [VAR]CHAR parameters |
|
165 | SS | 377 | 413 | 411 | 420 | 411 | 421 | 404 | 408 | 403 | 424 | 439 | 409 | 409 | 444 | 434 | 364 | 353 | 364 | 358 | 360 | 371 | 371 | 362 | 375 | 364 | 359 | 356 | 358 | 380 | 361 | 357 | Cannot create packaged routines with [VAR]CHAR parameters |
|
166 | CS | 810 | 839 | 853 | 870 | 851 | 833 | 831 | 868 | 874 | 869 | 848 | 878 | 882 | 875 | 819 | 801 | 831 | 785 | 782 | 787 | 777 | 783 | 787 | 785 | 778 | 791 | 797 | 772 | 774 | 769 | 767 | ISQL -x does not output the START WITH clause of generators/sequences |
|
167 | SS | 551 | 558 | 814 | 582 | 575 | 563 | 579 | 561 | 572 | 559 | 562 | 582 | 575 | 576 | 582 | 535 | 544 | 524 | 523 | 537 | 532 | 534 | 533 | 577 | 527 | 532 | 535 | 539 | 536 | 520 | 536 | ISQL -x does not output the START WITH clause of generators/sequences |
|
168 | CS | 621 | 632 | 644 | 632 | 678 | 649 | 683 | 668 | 649 | 635 | 633 | 709 | 630 | 638 | 684 | 581 | 613 | 610 | 617 | 587 | 579 | 582 | 580 | 584 | 588 | 615 | 626 | 581 | 589 | 584 | 576 | Preserve comments for output parameters after altering procedures |
|
169 | SS | 402 | 427 | 446 | 454 | 453 | 444 | 450 | 441 | 444 | 435 | 452 | 443 | 437 | 453 | 455 | 384 | 406 | 393 | 393 | 398 | 388 | 392 | 389 | 395 | 389 | 392 | 395 | 378 | 389 | 393 | 391 | Preserve comments for output parameters after altering procedures |
|
170 | CS | 593 | 621 | 600 | 600 | 626 | 595 | 632 | 607 | 600 | 594 | 594 | 641 | 669 | 644 | 602 | 568 | 551 | 553 | 574 | 551 | 600 | 582 | 580 | 582 | 556 | 561 | 552 | 542 | 592 | 570 | 550 | GTT should not reference permanent relation |
|
171 | SS | 386 | 392 | 406 | 405 | 403 | 420 | 411 | 404 | 410 | 414 | 409 | 406 | 412 | 403 | 428 | 374 | 370 | 374 | 358 | 361 | 359 | 373 | 380 | 358 | 379 | 361 | 371 | 414 | 356 | 374 | 358 | GTT should not reference permanent relation |
|
172 | CS | 584 | 597 | 644 | 581 | 645 | 636 | 621 | 600 | 603 | 600 | 584 | 588 | 684 | 636 | 584 | 546 | 550 | 547 | 571 | 552 | 551 | 597 | 571 | 591 | 565 | 583 | 563 | 550 | 589 | 548 | 552 | Problem with creation procedure which contain adding text in DOS864 charset |
|
173 | SS | 377 | 390 | 410 | 417 | 401 | 400 | 400 | 410 | 422 | 397 | 408 | 416 | 416 | 399 | 407 | 363 | 375 | 358 | 360 | 373 | 355 | 365 | 358 | 368 | 364 | 379 | 364 | 356 | 361 | 361 | 361 | Problem with creation procedure which contain adding text in DOS864 charset |
|
174 | CS | 808 | 834 | 822 | 821 | 840 | 857 | 823 | 849 | 815 | 826 | 810 | 837 | 831 | 824 | 837 | 807 | 752 | 757 | 761 | 770 | 790 | 758 | 819 | 760 | 797 | 770 | 752 | 755 | 755 | 748 | 744 | Add table name to text of validation contraint error message, to help identify error context |
|
175 | SS | 542 | 534 | 556 | 583 | 564 | 568 | 583 | 556 | 590 | 576 | 559 | 581 | 561 | 571 | 594 | 520 | 522 | 499 | 517 | 499 | 525 | 522 | 519 | 544 | 532 | 583 | 515 | 529 | 541 | 515 | 518 | Add table name to text of validation contraint error message, to help identify error context |
|
176 | CS | 575 | 610 | 616 | 582 | 589 | 585 | 592 | 615 | 593 | 612 | 612 | 580 | 612 | 615 | 579 | 546 | 537 | 571 | 533 | 592 | 552 | 544 | 562 | 567 | 564 | 548 | 572 | 535 | 531 | 531 | 564 | Context parsing error with derived tables and CASE functions |
|
177 | SS | 378 | 391 | 398 | 407 | 404 | 410 | 421 | 408 | 398 | 404 | 405 | 404 | 407 | 399 | 415 | 359 | 365 | 356 | 357 | 361 | 357 | 345 | 356 | 362 | 347 | 396 | 359 | 360 | 364 | 364 | 361 | Context parsing error with derived tables and CASE functions |
|
178 | CS | 592 | 596 | 623 | 594 | 617 | 618 | 599 | 596 | 612 | 618 | 611 | 595 | 591 | 635 | 597 | 554 | 559 | 611 | 565 | 615 | 583 | 582 | 574 | 545 | 554 | 552 | 547 | 571 | 546 | 546 | 576 | Error on create table with "CHARACTER SET DOS775" field |
|
179 | SS | 389 | 407 | 417 | 430 | 419 | 414 | 407 | 407 | 421 | 406 | 408 | 419 | 497 | 420 | 410 | 361 | 370 | 362 | 360 | 364 | 362 | 378 | 360 | 362 | 372 | 401 | 364 | 374 | 362 | 362 | 367 | Error on create table with "CHARACTER SET DOS775" field |
|
180 | CS | 578 | 579 | 578 | 616 | 673 | 588 | 596 | 618 | 590 | 589 | 590 | 611 | 590 | 593 | 583 | 591 | 539 | 543 | 539 | 578 | 538 | 537 | 612 | 534 | 548 | 551 | 534 | 543 | 533 | 533 | 542 | FB3: Stored function accepts duplicate input arguments |
|
181 | SS | 375 | 415 | 415 | 414 | 406 | 408 | 408 | 407 | 398 | 395 | 417 | 388 | 418 | 406 | 394 | 357 | 363 | 353 | 358 | 360 | 346 | 355 | 362 | 359 | 374 | 377 | 363 | 365 | 361 | 363 | 357 | FB3: Stored function accepts duplicate input arguments |
|
182 | CS | 585 | 617 | 596 | 585 | 604 | 628 | 627 | 601 | 626 | 593 | 612 | 588 | 640 | 650 | 578 | 558 | 597 | 546 | 546 | 571 | 564 | 583 | 587 | 534 | 555 | 586 | 539 | 578 | 572 | 548 | 568 | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
183 | SS | 389 | 407 | 400 | 407 | 417 | 418 | 406 | 400 | 400 | 402 | 429 | 403 | 428 | 418 | 420 | 356 | 370 | 360 | 359 | 381 | 358 | 356 | 356 | 362 | 364 | 386 | 381 | 379 | 360 | 364 | 393 | FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed |
|
184 | CS | 808 | 707 | 825 | 814 | 859 | 840 | 828 | 863 | 851 | 820 | 922 | 827 | 869 | 848 | 881 | 772 | 854 | 778 | 763 | 773 | 766 | 776 | 844 | 753 | 771 | 777 | 803 | 785 | 766 | 776 | 779 | Choose the best matching index for navigation |
|
185 | SS | 552 | 466 | 569 | 586 | 586 | 589 | 583 | 581 | 583 | 571 | 597 | 554 | 583 | 587 | 599 | 550 | 539 | 560 | 521 | 515 | 536 | 539 | 522 | 522 | 519 | 555 | 523 | 538 | 530 | 516 | 515 | Choose the best matching index for navigation |
|
186 | CS | 588 | 627 | 595 | 599 | 628 | 636 | 606 | 604 | 600 | 638 | 609 | 606 | 622 | 619 | 620 | 587 | 581 | 558 | 589 | 582 | 552 | 570 | 562 | 554 | 554 | 565 | 581 | 548 | 559 | 552 | 547 | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
187 | SS | 403 | 412 | 416 | 428 | 429 | 452 | 447 | 687 | 432 | 434 | 433 | 412 | 431 | 419 | 492 | 372 | 374 | 370 | 371 | 374 | 408 | 372 | 374 | 377 | 377 | 399 | 381 | 376 | 371 | 362 | 358 | Engine crashes when attempt to REcreate table with FK after syntax error before such recreating |
|
188 | CS | 777 | 598 | 873 | 827 | 869 | 820 | 857 | 848 | 819 | 819 | 812 | 833 | 800 | 841 | 892 | 772 | 776 | 764 | 781 | 768 | 763 | 767 | 759 | 778 | 774 | 768 | 770 | 769 | 767 | 767 | 765 | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
189 | SS | 541 | 411 | 565 | 560 | 592 | 573 | 591 | 557 | 577 | 574 | 590 | 567 | 604 | 593 | 612 | 520 | 534 | 544 | 513 | 516 | 539 | 530 | 532 | 514 | 516 | 559 | 510 | 514 | 530 | 518 | 514 | Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers |
|
190 | CS | 788 | 684 | 830 | 817 | 864 | 829 | 856 | 864 | 809 | 854 | 811 | 805 | 839 | 849 | 850 | 790 | 769 | 766 | 771 | 767 | 763 | 766 | 771 | 764 | 765 | 789 | 772 | 767 | 755 | 788 | 765 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
191 | SS | 532 | 456 | 566 | 573 | 551 | 564 | 583 | 564 | 568 | 564 | 586 | 564 | 593 | 579 | 580 | 516 | 518 | 514 | 528 | 522 | 531 | 509 | 534 | 503 | 520 | 557 | 513 | 520 | 517 | 517 | 521 | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
|
192 | CS | 1668 | 1734 | 1759 | 1760 | 1769 | 1770 | 1735 | 1762 | 1784 | 1742 | 1731 | 1791 | 1850 | 1792 | 1747 | 1675 | 1622 | 1621 | 1624 | 1610 | 1629 | 1635 | 1606 | 1609 | 1654 | 1623 | 1661 | 1612 | 1621 | 1603 | 1608 | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
193 | SS | 1014 | 1042 | 1026 | 1049 | 1043 | 1031 | 1031 | 1040 | 1039 | 1052 | 1287 | 1053 | 1070 | 1032 | 1053 | 1003 | 946 | 949 | 954 | 940 | 942 | 944 | 935 | 937 | 954 | 1057 | 944 | 972 | 953 | 1003 | 934 | Non-privileged user can delete records from RDB$SECURITY_CLASSES table |
|
194 | CS | 593 | 611 | 629 | 602 | 643 | 616 | 630 | 600 | 605 | 590 | 630 | 690 | 644 | 604 | 624 | 550 | 547 | 544 | 554 | 554 | 554 | 560 | 547 | 539 | 596 | 587 | 550 | 546 | 648 | 570 | 544 | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
195 | SS | 381 | 394 | 442 | 441 | 410 | 402 | 416 | 413 | 407 | 410 | 561 | 412 | 425 | 441 | 414 | 360 | 372 | 375 | 375 | 365 | 365 | 358 | 360 | 363 | 376 | 386 | 374 | 373 | 373 | 361 | 358 | Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) |
|
196 | CS | 1159 | 1191 | 1192 | 1261 | 1236 | 1240 | 1260 | 1195 | 1209 | 1215 | 1204 | 1198 | 1209 | 1189 | 1207 | 1116 | 1151 | 1114 | 1101 | 1100 | 1131 | 1096 | 1116 | 1167 | 1126 | 1137 | 1103 | 1111 | 1132 | 1104 | 1123 | non-priviledged user can insert and update rdb$database |
|
197 | SS | 722 | 721 | 722 | 752 | 726 | 725 | 728 | 736 | 733 | 744 | 945 | 783 | 743 | 1100 | 821 | 680 | 691 | 671 | 675 | 690 | 674 | 674 | 712 | 697 | 673 | 726 | 669 | 706 | 722 | 890 | 673 | non-priviledged user can insert and update rdb$database |
|
198 | CS | 578 | 583 | 584 | 642 | 610 | 617 | 609 | 583 | 591 | 596 | 618 | 583 | 601 | 619 | 586 | 561 | 570 | 547 | 537 | 538 | 570 | 572 | 531 | 597 | 549 | 550 | 570 | 542 | 533 | 573 | 540 | Equality predicate distribution does not work for some complex queries |
|
199 | SS | 383 | 392 | 403 | 418 | 388 | 408 | 412 | 401 | 404 | 405 | 876 | 409 | 413 | 413 | 391 | 368 | 378 | 368 | 362 | 360 | 357 | 365 | 357 | 363 | 355 | 398 | 365 | 375 | 361 | 361 | 361 | Equality predicate distribution does not work for some complex queries |
|
200 | CS | 573 | 596 | 622 | 619 | 638 | 627 | 623 | 590 | 596 | 628 | 617 | 588 | 601 | 620 | 610 | 547 | 558 | 545 | 568 | 539 | 554 | 548 | 562 | 566 | 546 | 541 | 549 | 544 | 572 | 575 | 545 | Create function/sp which references to non-existent exception <...> |
|
201 | SS | 395 | 388 | 408 | 439 | 412 | 407 | 409 | 404 | 408 | 457 | 533 | 406 | 639 | 427 | 499 | 359 | 363 | 391 | 357 | 572 | 368 | 390 | 364 | 365 | 378 | 400 | 361 | 376 | 362 | 370 | 354 | Create function/sp which references to non-existent exception <...> |
|
202 | CS | 572 | 570 | 598 | 608 | 614 | 583 | 591 | 587 | 612 | 615 | 617 | 615 | 588 | 636 | 581 | 544 | 573 | 543 | 572 | 565 | 544 | 538 | 573 | 549 | 547 | 537 | 535 | 532 | 544 | 537 | 537 | Duplicate names in package are not checked |
|
203 | SS | 377 | 378 | 396 | 404 | 397 | 402 | 404 | 402 | 406 | 398 | 503 | 403 | 396 | 420 | 409 | 377 | 362 | 363 | 359 | 351 | 364 | 364 | 359 | 358 | 365 | 379 | 362 | 373 | 374 | 363 | 364 | Duplicate names in package are not checked |
|
204 | CS | 587 | 594 | 598 | 594 | 626 | 597 | 605 | 601 | 598 | 593 | 595 | 595 | 698 | 697 | 611 | 615 | 561 | 561 | 566 | 581 | 542 | 545 | 551 | 544 | 582 | 547 | 548 | 549 | 544 | 549 | 545 | Preparation of erroneous DDL statement does not show the main command failed |
|
205 | SS | 402 | 386 | 405 | 419 | 417 | 424 | 407 | 421 | 417 | 416 | 440 | 406 | 426 | 411 | 414 | 581 | 369 | 361 | 357 | 399 | 371 | 366 | 361 | 369 | 394 | 423 | 379 | 354 | 377 | 358 | 360 | Preparation of erroneous DDL statement does not show the main command failed |
|
206 | CS | 1844 | 1906 | 1902 | 1903 | 1922 | 1942 | 1887 | 1914 | 1968 | 1910 | 1910 | 1897 | 1957 | 1988 | 1903 | 1797 | 1862 | 1826 | 1795 | 1786 | 1815 | 1813 | 1814 | 1796 | 1819 | 1808 | 1781 | 1820 | 1779 | 1812 | 1808 | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
207 | SS | 1476 | 1480 | 1506 | 1494 | 1517 | 1512 | 1499 | 1932 | 1489 | 1510 | 1629 | 1487 | 1575 | 1573 | 1542 | 1438 | 1459 | 1438 | 1446 | 1429 | 1464 | 1450 | 1406 | 1394 | 1477 | 1476 | 1442 | 1456 | 1414 | 1419 | 1414 | Poor performance of explicit cursors containing correlated subqueries in the select list |
|
208 | CS | 583 | 585 | 583 | 623 | 643 | 618 | 603 | 599 | 621 | 622 | 585 | 584 | 627 | 595 | 595 | 555 | 570 | 570 | 562 | 550 | 583 | 583 | 548 | 574 | 565 | 547 | 547 | 547 | 553 | 565 | 546 | Incorrect line/column information in runtime errors |
|
209 | SS | 379 | 395 | 398 | 406 | 397 | 475 | 404 | 403 | 409 | 402 | 406 | 411 | 403 | 399 | 402 | 365 | 357 | 357 | 371 | 362 | 360 | 355 | 359 | 358 | 359 | 385 | 361 | 373 | 360 | 361 | 364 | Incorrect line/column information in runtime errors |
|
210 | CS | 3293 | 3308 | 3347 | 3355 | 3517 | 3428 | 3386 | 3399 | 3421 | 3353 | 3397 | 3349 | 3678 | 3458 | 3439 | 3176 | 3246 | 3128 | 3110 | 3097 | 3114 | 3248 | 3110 | 3062 | 3337 | 3278 | 3121 | 3096 | 3090 | 3077 | 3110 | Report more details for "object in use" errors |
|
211 | SS | 1287 | 1325 | 1354 | 1370 | 1373 | 1447 | 1600 | 1493 | 1368 | 1381 | 1412 | 1350 | 1391 | 1390 | 1387 | 1228 | 1280 | 1244 | 1227 | 1232 | 1241 | 1229 | 1235 | 1231 | 1248 | 1295 | 1260 | 1234 | 1240 | 1234 | 1222 | Report more details for "object in use" errors |
|
212 | CS | 805 | 605 | 814 | 813 | 835 | 810 | 843 | 863 | 849 | 853 | 826 | 851 | 843 | 842 | 816 | 828 | 759 | 811 | 756 | 783 | 752 | 754 | 763 | 748 | 801 | 770 | 754 | 755 | 763 | 752 | 754 | Allow referencing cursors as record variables in PSQL |
|
213 | SS | 538 | 405 | 562 | 583 | 575 | 565 | 572 | 577 | 572 | 563 | 579 | 574 | 573 | 548 | 555 | 509 | 513 | 524 | 544 | 531 | 513 | 519 | 510 | 498 | 517 | 560 | 530 | 508 | 521 | 532 | 503 | Allow referencing cursors as record variables in PSQL |
|
214 | CS | 573 | 580 | 586 | 591 | 604 | 587 | 602 | 620 | 582 | 591 | 624 | 582 | 619 | 635 | 585 | 539 | 567 | 574 | 544 | 563 | 567 | 563 | 566 | 541 | 546 | 553 | 548 | 545 | 572 | 549 | 567 | Useless extraction of generic DDL trigger |
|
215 | SS | 383 | 388 | 394 | 399 | 399 | 402 | 405 | 402 | 406 | 393 | 407 | 401 | 405 | 405 | 395 | 366 | 389 | 361 | 357 | 360 | 362 | 365 | 359 | 364 | 363 | 378 | 354 | 361 | 357 | 364 | 362 | Useless extraction of generic DDL trigger |
|
216 | CS | 797 | 792 | 838 | 797 | 848 | 840 | 805 | 838 | 804 | 842 | 798 | 839 | 842 | 818 | 843 | 751 | 759 | 767 | 768 | 769 | 751 | 747 | 800 | 754 | 770 | 770 | 759 | 772 | 802 | 825 | 783 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
217 | SS | 531 | 540 | 645 | 574 | 556 | 567 | 565 | 572 | 562 | 580 | 586 | 545 | 562 | 569 | 566 | 518 | 512 | 512 | 523 | 515 | 503 | 517 | 504 | 506 | 504 | 547 | 516 | 508 | 508 | 505 | 509 | Positioned UPDATE statement prohibits index usage for the subsequent cursor field references |
|
218 | CS | 2919 | 2902 | 2923 | 2942 | 2938 | 2932 | 2946 | 2932 | 2931 | 2958 | 2915 | 2910 | 2927 | 2968 | 2986 | 2894 | 2909 | 2878 | 3080 | 2876 | 3446 | 2879 | 2916 | 2896 | 2886 | 2867 | 2967 | 2877 | 2932 | 2887 | 2901 | Allow output to trace explain plan form. |
|
219 | SS | 2674 | 2683 | 2776 | 2703 | 2704 | 2699 | 2688 | 2685 | 2695 | 2708 | 2706 | 2685 | 2683 | 2682 | 2687 | 2659 | 2661 | 2644 | 2653 | 2647 | 2652 | 2649 | 2656 | 2662 | 2666 | 2715 | 2651 | 2653 | 2652 | 2639 | 2645 | Allow output to trace explain plan form. |
|
220 | CS | 782 | 831 | 812 | 832 | 836 | 831 | 801 | 800 | 787 | 826 | 828 | 794 | 830 | 840 | 860 | 799 | 759 | 748 | 754 | 754 | 752 | 741 | 756 | 751 | 743 | 752 | 766 | 772 | 778 | 752 | 751 | Regression: NOT NULL constraint, declared in domain, does not work |
|
221 | SS | 535 | 537 | 663 | 571 | 548 | 569 | 560 | 560 | 568 | 578 | 599 | 563 | 543 | 550 | 564 | 507 | 507 | 504 | 523 | 508 | 511 | 499 | 536 | 496 | 503 | 534 | 507 | 511 | 503 | 502 | 500 | Regression: NOT NULL constraint, declared in domain, does not work |
|
222 | CS | 1999 | 2259 | 2146 | 2146 | 2166 | 2157 | 2152 | 2147 | 2171 | 2135 | 2141 | 2145 | 2154 | 2231 | 2127 | 1956 | 1964 | 1979 | 1990 | 1916 | 1921 | 1981 | 1917 | 1912 | 1965 | 1977 | 1976 | 1970 | 1964 | 1937 | 2009 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
223 | SS | 1234 | 1292 | 1542 | 1330 | 1314 | 1358 | 1547 | 1336 | 1323 | 1461 | 1315 | 1290 | 1352 | 1304 | 1507 | 1163 | 1159 | 1148 | 1137 | 1138 | 1146 | 1153 | 1130 | 1129 | 1207 | 1262 | 1164 | 1167 | 1157 | 1167 | 1161 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
224 | CS | 1092 | 1203 | 1183 | 1247 | 1211 | 1221 | 1179 | 1192 | 1242 | 1181 | 1190 | 1180 | 1213 | 1254 | 1204 | 1104 | 1062 | 1027 | 1063 | 1037 | 1042 | 1022 | 1023 | 1017 | 1015 | 1016 | 1009 | 1031 | 1054 | 1036 | 1081 | gbak fails to restore database containing dependency between views and packaged functions |
|
225 | SS | 807 | 886 | 1071 | 961 | 951 | 957 | 943 | 921 | 941 | 910 | 947 | 926 | 943 | 935 | 1323 | 792 | 749 | 775 | 773 | 769 | 772 | 788 | 766 | 743 | 758 | 818 | 796 | 770 | 772 | 770 | 781 | gbak fails to restore database containing dependency between views and packaged functions |
|
226 | CS | 579 | 592 | 599 | 591 | 624 | 596 | 592 | 593 | 593 | 596 | 625 | 657 | 621 | 600 | 623 | 548 | 569 | 544 | 544 | 548 | 583 | 575 | 550 | 539 | 562 | 549 | 547 | 576 | 551 | 540 | 547 | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
227 | SS | 393 | 395 | 517 | 421 | 407 | 427 | 414 | 557 | 411 | 574 | 567 | 410 | 406 | 413 | 412 | 370 | 376 | 366 | 363 | 372 | 373 | 360 | 365 | 361 | 360 | 385 | 391 | 408 | 356 | 361 | 357 | OR/IN predicates for RDB$DBKEY lead to NATURAL plan |
|
228 | CS | 569 | 582 | 582 | 624 | 597 | 607 | 590 | 590 | 587 | 588 | 601 | 665 | 586 | 610 | 589 | 546 | 546 | 546 | 549 | 533 | 568 | 533 | 568 | 567 | 547 | 541 | 559 | 570 | 537 | 543 | 566 | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
229 | SS | 389 | 395 | 502 | 412 | 399 | 417 | 408 | 401 | 401 | 491 | 401 | 405 | 433 | 405 | 404 | 383 | 362 | 405 | 376 | 380 | 357 | 361 | 349 | 356 | 364 | 371 | 366 | 362 | 365 | 358 | 363 | FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval |
|
230 | CS | 2186 | 2300 | 12840 | 12807 | 2344 | 2496 | 2344 | 2366 | 2378 | 2366 | 2348 | 2347 | 2377 | 2403 | 2381 | 2191 | 2126 | 2146 | 2176 | 2165 | 2133 | 2160 | 2141 | 2123 | 2169 | 2162 | 2153 | 2158 | 2182 | 2148 | 2117 | New gbak option to enable encryption during restore |
|
231 | SS | 1686 | 1645 | 12410 | 12726 | 1686 | 2045 | 2048 | 1656 | 2069 | 2071 | 1686 | 2061 | 2068 | 2047 | 2060 | 1533 | 2000 | 1522 | 1521 | 1544 | 1992 | 1514 | 1992 | 2046 | 1521 | 1619 | 1519 | 1492 | 1546 | 1505 | 1483 | New gbak option to enable encryption during restore |
|
232 | CS | 592 | 598 | 593 | 631 | 636 | 613 | 656 | 628 | 598 | 592 | 599 | 599 | 642 | 602 | 597 | 576 | 607 | 554 | 565 | 558 | 553 | 554 | 582 | 558 | 578 | 551 | 542 | 554 | 614 | 581 | 555 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
233 | SS | 389 | 401 | 481 | 417 | 420 | 413 | 412 | 423 | 448 | 524 | 411 | 406 | 420 | 437 | 415 | 366 | 362 | 374 | 364 | 375 | 365 | 364 | 365 | 360 | 376 | 400 | 379 | 366 | 361 | 369 | 363 | Allow hash/merge joins for non-field (dbkey or derived expression) equalities |
|
234 | CS | 589 | 593 | 591 | 628 | 649 | 650 | 601 | 608 | 592 | 609 | 624 | 604 | 623 | 642 | 598 | 602 | 552 | 576 | 558 | 555 | 552 | 545 | 565 | 549 | 588 | 584 | 558 | 541 | 579 | 563 | 547 | Allow to use index when GROUP BY on field which has DESCENDING index |
|
235 | SS | 385 | 390 | 422 | 412 | 414 | 410 | 421 | 400 | 427 | 518 | 415 | 404 | 411 | 413 | 412 | 379 | 381 | 361 | 360 | 364 | 373 | 364 | 358 | 363 | 374 | 399 | 373 | 357 | 364 | 378 | 362 | Allow to use index when GROUP BY on field which has DESCENDING index |
|
236 | CS | 788 | 811 | 839 | 837 | 841 | 816 | 834 | 819 | 810 | 852 | 800 | 841 | 824 | 868 | 820 | 764 | 752 | 741 | 743 | 785 | 745 | 791 | 756 | 747 | 761 | 751 | 754 | 752 | 767 | 746 | 746 | DB_KEY based join of two tables may be ineffective |
|
237 | SS | 537 | 548 | 683 | 551 | 550 | 555 | 576 | 554 | 561 | 655 | 591 | 550 | 592 | 563 | 560 | 519 | 498 | 526 | 500 | 504 | 500 | 502 | 504 | 506 | 499 | 552 | 503 | 504 | 509 | 501 | 504 | DB_KEY based join of two tables may be ineffective |
|
238 | CS | 590 | 619 | 588 | 604 | 639 | 593 | 616 | 598 | 596 | 599 | 645 | 593 | 633 | 653 | 624 | 541 | 549 | 546 | 551 | 551 | 592 | 584 | 546 | 567 | 584 | 609 | 559 | 550 | 588 | 573 | 568 | Server does not accept the right plan |
|
239 | SS | 384 | 405 | 489 | 431 | 410 | 419 | 411 | 399 | 427 | 463 | 412 | 447 | 446 | 408 | 417 | 370 | 360 | 366 | 363 | 363 | 375 | 361 | 360 | 360 | 373 | 393 | 357 | 364 | 374 | 361 | 361 | Server does not accept the right plan |
|
240 | CS | 586 | 624 | 597 | 599 | 623 | 634 | 635 | 605 | 582 | 591 | 584 | 594 | 602 | 621 | 586 | 602 | 594 | 552 | 559 | 541 | 548 | 541 | 579 | 571 | 587 | 542 | 570 | 565 | 623 | 569 | 581 | DDL trigger remains active after dropped |
|
241 | SS | 392 | 392 | 539 | 423 | 417 | 403 | 415 | 404 | 426 | 446 | 416 | 428 | 441 | 403 | 407 | 356 | 401 | 363 | 356 | 375 | 371 | 371 | 360 | 362 | 364 | 392 | 379 | 363 | 364 | 362 | 385 | DDL trigger remains active after dropped |
|
242 | CS | 802 | 616 | 810 | 830 | 847 | 835 | 845 | 829 | 846 | 817 | 814 | 814 | 810 | 924 | 830 | 789 | 771 | 778 | 769 | 772 | 789 | 785 | 784 | 810 | 774 | 785 | 793 | 794 | 823 | 772 | 788 | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
243 | SS | 541 | 411 | 664 | 580 | 559 | 573 | 592 | 561 | 653 | 765 | 587 | 586 | 579 | 588 | 562 | 530 | 535 | 532 | 517 | 536 | 528 | 538 | 520 | 522 | 527 | 572 | 528 | 529 | 533 | 532 | 545 | FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN |
|
244 | CS | 576 | 585 | 589 | 602 | 639 | 596 | 588 | 622 | 609 | 617 | 597 | 608 | 624 | 642 | 599 | 553 | 542 | 556 | 556 | 574 | 544 | 540 | 545 | 578 | 555 | 545 | 555 | 547 | 555 | 550 | 569 | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
245 | SS | 396 | 388 | 452 | 406 | 402 | 407 | 406 | 411 | 413 | 545 | 409 | 432 | 427 | 412 | 412 | 361 | 360 | 354 | 360 | 388 | 368 | 382 | 358 | 360 | 361 | 406 | 400 | 368 | 365 | 362 | 392 | Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments |
|
246 | CS | 574 | 591 | 628 | 596 | 672 | 601 | 601 | 593 | 657 | 600 | 597 | 621 | 646 | 590 | 590 | 575 | 573 | 545 | 550 | 550 | 539 | 547 | 544 | 544 | 545 | 554 | 543 | 547 | 572 | 572 | 547 | Can't create column check constraint when the column is domain based |
|
247 | SS | 387 | 386 | 460 | 397 | 402 | 416 | 421 | 400 | 396 | 504 | 413 | 409 | 400 | 411 | 397 | 371 | 368 | 370 | 377 | 385 | 366 | 368 | 354 | 356 | 370 | 388 | 400 | 369 | 357 | 371 | 358 | Can't create column check constraint when the column is domain based |
|
248 | CS | 906 | 946 | 938 | 985 | 950 | 938 | 935 | 938 | 937 | 939 | 953 | 920 | 992 | 955 | 920 | 883 | 887 | 853 | 853 | 858 | 856 | 945 | 848 | 838 | 857 | 867 | 845 | 892 | 878 | 881 | 844 | Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.") |
|
249 | SS | 639 | 652 | 707 | 672 | 677 | 673 | 676 | 679 | 679 | 859 | 668 | 671 | 686 | 665 | 697 | 618 | 616 | 620 | 609 | 613 | 615 | 620 | 620 | 614 | 623 | 702 | 621 | 627 | 612 | 621 | 618 | Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.") |
|
250 | CS | 594 | 602 | 592 | 638 | 624 | 602 | 607 | 635 | 598 | 650 | 601 | 601 | 604 | 640 | 640 | 576 | 597 | 572 | 543 | 546 | 585 | 557 | 580 | 552 | 545 | 608 | 553 | 559 | 584 | 555 | 547 | Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N } |
|
251 | SS | 388 | 398 | 471 | 434 | 414 | 417 | 420 | 426 | 417 | 516 | 425 | 414 | 423 | 422 | 420 | 375 | 372 | 376 | 364 | 378 | 361 | 373 | 362 | 378 | 360 | 400 | 375 | 376 | 362 | 374 | 378 | Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N } |
|
252 | CS | 794 | 834 | 847 | 799 | 856 | 844 | 802 | 831 | 847 | 838 | 903 | 817 | 835 | 822 | 845 | 765 | 749 | 808 | 763 | 759 | 759 | 766 | 748 | 743 | 789 | 764 | 748 | 751 | 755 | 764 | 759 | Regression: computed index based on a computed column stores NULL for all its keys |
|
253 | SS | 563 | 535 | 592 | 595 | 590 | 571 | 569 | 582 | 1040 | 673 | 562 | 544 | 1022 | 1040 | 1052 | 509 | 519 | 510 | 543 | 533 | 516 | 513 | 498 | 497 | 521 | 565 | 683 | 666 | 675 | 517 | 501 | Regression: computed index based on a computed column stores NULL for all its keys |
|
254 | CS | 583 | 583 | 617 | 587 | 611 | 594 | 600 | 584 | 607 | 589 | 593 | 623 | 641 | 593 | 630 | 543 | 560 | 549 | 568 | 613 | 547 | 542 | 560 | 548 | 553 | 557 | 551 | 563 | 584 | 545 | 534 | "Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table |
|
255 | SS | 392 | 391 | 482 | 405 | 401 | 406 | 418 | 409 | 785 | 498 | 416 | 409 | 418 | 835 | 394 | 395 | 366 | 358 | 372 | 373 | 361 | 366 | 362 | 355 | 358 | 397 | 379 | 372 | 357 | 378 | 363 | "Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table |
|
256 | CS | 3193 | 3201 | 3173 | 3567 | 3220 | 3213 | 3201 | 3249 | 3238 | 3177 | 3205 | 3189 | 3260 | 3193 | 3208 | 3140 | 3399 | 3291 | 3193 | 3191 | 3136 | 3206 | 3166 | 3158 | 3133 | 3189 | 3102 | 3416 | 3128 | 3116 | 3112 | Regression: Join order in v3 is less optimal than in v2.x |
|
257 | SS | 2865 | 2844 | 3622 | 2904 | 2879 | 2900 | 3073 | 2873 | 2888 | 4159 | 3066 | 2866 | 2943 | 2943 | 2863 | 3014 | 2842 | 2846 | 2851 | 2836 | 2941 | 2830 | 2803 | 2797 | 2819 | 2864 | 2842 | 2828 | 2823 | 2826 | 2923 | Regression: Join order in v3 is less optimal than in v2.x |
|
258 | CS | 4835 | 4856 | 4856 | 4887 | 4876 | 4879 | 4862 | 4861 | 4851 | 4869 | 4866 | 4874 | 4880 | 4897 | 4907 | 4819 | 4820 | 4811 | 4808 | 4812 | 4801 | 4806 | 4817 | 4785 | 4875 | 4816 | 4810 | 4798 | 4820 | 4817 | 4812 | Implement ability to validate tables and indices online (without exclusive access to database) |
|
259 | SS | 4559 | 4585 | 4717 | 4595 | 4592 | 4604 | 4592 | 4790 | 4585 | 4627 | 4744 | 4579 | 4566 | 4596 | 5116 | 4548 | 4543 | 4527 | 4516 | 4533 | 4535 | 4524 | 4539 | 4531 | 4542 | 4556 | 4532 | 4530 | 4563 | 4529 | 4537 | Implement ability to validate tables and indices online (without exclusive access to database) |
|
260 | CS | 637 | 650 | 669 | 681 | 681 | 705 | 655 | 747 | 686 | 660 | 661 | 646 | 670 | 658 | 695 | 629 | 634 | 591 | 604 | 633 | 640 | 629 | 608 | 620 | 611 | 609 | 605 | 597 | 604 | 622 | 596 | Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs |
|
261 | SS | 431 | 466 | 635 | 486 | 470 | 468 | 506 | 480 | 477 | 475 | 484 | 463 | 479 | 467 | 463 | 406 | 418 | 419 | 420 | 407 | 422 | 421 | 438 | 407 | 421 | 423 | 424 | 419 | 408 | 405 | 402 | Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs |
|
262 | CS | 605 | 605 | 613 | 651 | 653 | 653 | 618 | 618 | 649 | 646 | 649 | 653 | 629 | 607 | 648 | 652 | 588 | 605 | 590 | 563 | 561 | 560 | 565 | 594 | 558 | 565 | 592 | 562 | 596 | 559 | 570 | Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR |
|
263 | SS | 400 | 408 | 511 | 416 | 437 | 460 | 459 | 427 | 450 | 441 | 490 | 430 | 445 | 423 | 433 | 375 | 385 | 378 | 377 | 377 | 372 | 387 | 374 | 408 | 369 | 380 | 377 | 382 | 393 | 375 | 376 | Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR |
|
264 | CS | 590 | 619 | 599 | 609 | 635 | 597 | 606 | 601 | 601 | 600 | 597 | 615 | 644 | 626 | 592 | 588 | 584 | 581 | 612 | 549 | 546 | 552 | 543 | 579 | 587 | 582 | 580 | 549 | 578 | 549 | 574 | Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists) |
|
265 | SS | 378 | 393 | 461 | 408 | 402 | 423 | 437 | 416 | 422 | 421 | 463 | 419 | 417 | 430 | 411 | 365 | 359 | 374 | 363 | 376 | 358 | 375 | 362 | 358 | 363 | 362 | 361 | 368 | 380 | 365 | 358 | Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists) |
|
266 | CS | 592 | 591 | 644 | 646 | 653 | 636 | 630 | 593 | 601 | 596 | 597 | 653 | 637 | 610 | 635 | 584 | 559 | 547 | 558 | 556 | 556 | 548 | 588 | 542 | 543 | 555 | 594 | 552 | 548 | 546 | 602 | Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..." |
|
267 | SS | 380 | 392 | 509 | 415 | 403 | 414 | 427 | 412 | 411 | 402 | 440 | 400 | 434 | 423 | 401 | 375 | 382 | 373 | 370 | 378 | 364 | 370 | 376 | 361 | 361 | 378 | 375 | 362 | 374 | 374 | 360 | Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..." |
|
268 | CS | 594 | 608 | 617 | 616 | 652 | 615 | 612 | 646 | 608 | 603 | 642 | 613 | 617 | 639 | 634 | 602 | 562 | 551 | 563 | 562 | 569 | 552 | 560 | 562 | 587 | 585 | 554 | 567 | 563 | 582 | 559 | ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used |
|
269 | SS | 385 | 408 | 452 | 420 | 415 | 435 | 441 | 421 | 418 | 419 | 469 | 419 | 438 | 437 | 424 | 369 | 374 | 380 | 369 | 384 | 370 | 376 | 378 | 366 | 375 | 377 | 380 | 379 | 386 | 377 | 362 | ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used |
|
270 | CS | 667 | 673 | 681 | 675 | 718 | 721 | 689 | 685 | 711 | 712 | 708 | 691 | 750 | 724 | 705 | 623 | 639 | 625 | 656 | 633 | 751 | 653 | 661 | 626 | 659 | 639 | 631 | 623 | 623 | 633 | 624 | Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles) |
|
271 | SS | 426 | 449 | 592 | 455 | 467 | 456 | 486 | 904 | 466 | 923 | 909 | 465 | 454 | 888 | 980 | 414 | 409 | 414 | 411 | 412 | 411 | 421 | 410 | 431 | 411 | 409 | 405 | 409 | 417 | 413 | 416 | Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles) |
|
272 | CS | 561 | 598 | 617 | 619 | 620 | 628 | 589 | 597 | 587 | 589 | 590 | 590 | 592 | 591 | 627 | 552 | 570 | 552 | 548 | 547 | 541 | 535 | 548 | 541 | 545 | 541 | 540 | 542 | 540 | 538 | 542 | Parameterized exception: wrong output when number of arguments greater than 7 |
|
273 | SS | 402 | 383 | 462 | 419 | 391 | 400 | 439 | 414 | 401 | 413 | 428 | 405 | 435 | 418 | 404 | 372 | 360 | 364 | 460 | 364 | 355 | 571 | 362 | 369 | 609 | 361 | 365 | 360 | 372 | 607 | 446 | Parameterized exception: wrong output when number of arguments greater than 7 |
|
274 | CS | 686 | 722 | 723 | 730 | 750 | 759 | 808 | 719 | 722 | 722 | 732 | 746 | 803 | 722 | 757 | 666 | 674 | 677 | 653 | 657 | 654 | 669 | 681 | 651 | 659 | 666 | 681 | 647 | 692 | 654 | 659 | AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role |
|
275 | SS | 405 | 427 | 606 | 434 | 456 | 441 | 456 | 452 | 444 | 450 | 466 | 445 | 433 | 482 | 468 | 384 | 387 | 388 | 378 | 375 | 400 | 394 | 387 | 392 | 398 | 380 | 389 | 378 | 378 | 411 | 380 | AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role |
|
276 | CS | 585 | 587 | 637 | 596 | 640 | 646 | 595 | 586 | 599 | 609 | 587 | 604 | 596 | 653 | 624 | 600 | 565 | 576 | 543 | 552 | 554 | 585 | 556 | 546 | 553 | 552 | 567 | 577 | 545 | 556 | 542 | Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns |
|
277 | SS | 392 | 397 | 409 | 414 | 408 | 422 | 437 | 396 | 416 | 418 | 437 | 407 | 412 | 415 | 447 | 363 | 382 | 375 | 379 | 377 | 361 | 384 | 364 | 362 | 365 | 389 | 366 | 364 | 366 | 359 | 408 | Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns |
|
278 | CS | 590 | 601 | 591 | 595 | 627 | 600 | 605 | 600 | 596 | 624 | 625 | 600 | 598 | 591 | 593 | 576 | 547 | 554 | 546 | 557 | 560 | 609 | 555 | 571 | 543 | 555 | 590 | 551 | 541 | 553 | 548 | Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL |
|
279 | SS | 399 | 408 | 406 | 404 | 404 | 415 | 429 | 409 | 406 | 405 | 423 | 402 | 401 | 424 | 415 | 374 | 362 | 418 | 373 | 374 | 364 | 358 | 362 | 366 | 363 | 397 | 372 | 360 | 365 | 360 | 363 | Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL |
|
280 | CS | 594 | 597 | 608 | 617 | 650 | 663 | 652 | 618 | 618 | 623 | 643 | 643 | 664 | 640 | 639 | 560 | 551 | 558 | 558 | 559 | 592 | 621 | 582 | 558 | 576 | 566 | 569 | 584 | 588 | 552 | 584 | Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters |
|
281 | SS | 408 | 413 | 429 | 428 | 434 | 440 | 452 | 430 | 425 | 441 | 464 | 429 | 444 | 430 | 433 | 373 | 374 | 435 | 371 | 377 | 385 | 375 | 373 | 374 | 378 | 404 | 377 | 379 | 370 | 376 | 374 | Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters |
|
282 | CS | 2767 | 2848 | 2906 | 2863 | 2869 | 2890 | 2870 | 2881 | 2855 | 2845 | 2877 | 2836 | 2917 | 2888 | 2882 | 2728 | 2736 | 2766 | 2667 | 2658 | 2683 | 2677 | 2665 | 2768 | 2696 | 2746 | 2720 | 2669 | 2689 | 2651 | 2665 | Regression: generators can be seen/modified by unprivileged users |
|
283 | SS | 1627 | 1646 | 1628 | 1661 | 1647 | 1686 | 1803 | 1631 | 1698 | 1662 | 1807 | 1627 | 1702 | 1677 | 1656 | 1525 | 1529 | 1627 | 1528 | 1537 | 1510 | 1540 | 1502 | 1489 | 1542 | 1715 | 1552 | 1522 | 1525 | 1528 | 3237 | Regression: generators can be seen/modified by unprivileged users |
|
284 | CS | 568 | 576 | 614 | 591 | 636 | 588 | 597 | 596 | 587 | 581 | 594 | 575 | 619 | 621 | 616 | 544 | 545 | 551 | 534 | 548 | 540 | 540 | 567 | 538 | 540 | 569 | 537 | 565 | 537 | 534 | 541 | Regression: List of aggregation is not checked properly |
|
285 | SS | 377 | 377 | 394 | 393 | 403 | 396 | 438 | 394 | 397 | 406 | 427 | 401 | 421 | 400 | 406 | 366 | 364 | 370 | 360 | 363 | 362 | 378 | 352 | 352 | 363 | 366 | 366 | 365 | 363 | 349 | 494 | Regression: List of aggregation is not checked properly |
|
286 | CS | 670 | 677 | 784 | 795 | 793 | 782 | 774 | 773 | 772 | 770 | 792 | 782 | 802 | 815 | 811 | 677 | 651 | 645 | 626 | 643 | 630 | 617 | 654 | 616 | 626 | 641 | 630 | 663 | 641 | 654 | 625 | HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations |
|
287 | SS | 468 | 476 | 572 | 581 | 574 | 574 | 588 | 568 | 612 | 579 | 599 | 564 | 570 | 584 | 589 | 460 | 442 | 438 | 435 | 438 | 446 | 442 | 445 | 444 | 443 | 460 | 451 | 448 | 443 | 441 | 656 | HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations |
|
288 | CS | 2384 | 2453 | 2434 | 2470 | 2487 | 2492 | 2486 | 2455 | 2456 | 2431 | 2446 | 2426 | 2519 | 2444 | 2584 | 2341 | 2402 | 2366 | 2304 | 2367 | 2294 | 2295 | 2310 | 2281 | 2318 | 2301 | 2310 | 2326 | 2337 | 2272 | 2314 | Make user names behave according to SQL identifiers rules |
|
289 | SS | 1399 | 1385 | 1390 | 1412 | 1401 | 1410 | 1976 | 1404 | 1423 | 1644 | 1518 | 1408 | 1398 | 1429 | 1422 | 1311 | 1354 | 1453 | 1323 | 1342 | 1315 | 1333 | 1359 | 1303 | 1323 | 1791 | 1726 | 1440 | 1338 | 1300 | 1332 | Make user names behave according to SQL identifiers rules |
|
290 | CS | 606 | 645 | 612 | 608 | 647 | 621 | 648 | 614 | 615 | 616 | 610 | 643 | 609 | 619 | 636 | 605 | 578 | 567 | 565 | 617 | 554 | 567 | 564 | 555 | 566 | 573 | 570 | 581 | 571 | 585 | 554 | EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck |
|
291 | SS | 415 | 414 | 440 | 420 | 431 | 417 | 468 | 434 | 438 | 421 | 451 | 431 | 424 | 441 | 424 | 418 | 379 | 459 | 372 | 376 | 373 | 370 | 374 | 378 | 376 | 404 | 382 | 409 | 375 | 377 | 375 | EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck |
|
292 | CS | 587 | 593 | 609 | 608 | 636 | 607 | 604 | 612 | 603 | 612 | 602 | 605 | 627 | 652 | 658 | 586 | 588 | 539 | 542 | 559 | 561 | 548 | 555 | 555 | 559 | 582 | 543 | 559 | 569 | 576 | 554 | Make ISQL display character set when sqlda_display is on |
|
293 | SS | 392 | 390 | 426 | 410 | 420 | 420 | 431 | 420 | 411 | 425 | 442 | 438 | 425 | 436 | 418 | 372 | 377 | 387 | 372 | 365 | 363 | 367 | 367 | 359 | 360 | 395 | 368 | 372 | 372 | 372 | 408 | Make ISQL display character set when sqlda_display is on |
|
294 | CS | 1552 | 1565 | 1573 | 1579 | 1625 | 1616 | 1611 | 1626 | 1615 | 1590 | 1594 | 1573 | 1632 | 1608 | 1620 | 1488 | 1474 | 1479 | 1470 | 1471 | 1474 | 1466 | 1558 | 1443 | 1487 | 1471 | 1465 | 1546 | 1499 | 1464 | 1458 | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
295 | SS | 948 | 950 | 1037 | 963 | 964 | 960 | 1038 | 971 | 956 | 964 | 1035 | 961 | 960 | 999 | 947 | 892 | 870 | 940 | 889 | 899 | 870 | 876 | 859 | 853 | 885 | 960 | 890 | 886 | 899 | 898 | 1203 | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
296 | CS | 1123 | 1129 | 1133 | 1156 | 1151 | 1136 | 1140 | 1194 | 1127 | 1139 | 1127 | 1136 | 1142 | 1144 | 1148 | 1119 | 1114 | 1061 | 1053 | 1066 | 1075 | 1066 | 1128 | 1059 | 1044 | 1046 | 1081 | 1106 | 1065 | 1039 | 1049 | SHOW GRANTS does not display info about exceptions which were granted to user |
|
297 | SS | 704 | 708 | 743 | 725 | 703 | 705 | 765 | 777 | 699 | 714 | 762 | 719 | 715 | 708 | 754 | 636 | 650 | 674 | 655 | 644 | 644 | 644 | 631 | 645 | 642 | 729 | 651 | 663 | 675 | 733 | 809 | SHOW GRANTS does not display info about exceptions which were granted to user |
|
298 | CS | 603 | 609 | 629 | 602 | 634 | 639 | 644 | 647 | 612 | 611 | 609 | 614 | 666 | 666 | 664 | 564 | 586 | 565 | 605 | 561 | 708 | 567 | 564 | 545 | 560 | 563 | 559 | 558 | 557 | 552 | 550 | Altering a trigger indicating other table than the original does not reflect the change |
|
299 | SS | 410 | 407 | 429 | 423 | 415 | 424 | 452 | 423 | 419 | 419 | 457 | 447 | 419 | 428 | 440 | 383 | 379 | 379 | 372 | 368 | 375 | 393 | 367 | 363 | 377 | 407 | 372 | 414 | 379 | 376 | 509 | Altering a trigger indicating other table than the original does not reflect the change |
|
300 | CS | 6690 | 6690 | 6715 | 6704 | 6728 | 6697 | 6690 | 6736 | 6719 | 6752 | 6710 | 6758 | 6710 | 6725 | 6718 | 6649 | 6638 | 6728 | 6656 | 6629 | 6736 | 6678 | 6625 | 6607 | 6635 | 6635 | 6659 | 6629 | 6615 | 6650 | 6604 | Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672" |
|
301 | SS | 6447 | 6442 | 6447 | 6459 | 6474 | 6456 | 6715 | 6981 | 6449 | 6478 | 7054 | 6455 | 6443 | 6447 | 6478 | 6415 | 6409 | 6457 | 6411 | 6411 | 6421 | 6412 | 6412 | 6443 | 6411 | 6844 | 6708 | 6404 | 6413 | 6423 | 6542 | Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672" |
|
302 | CS | 599 | 643 | 604 | 633 | 641 | 604 | 686 | 607 | 608 | 637 | 631 | 636 | 635 | 620 | 595 | 564 | 558 | 606 | 549 | 590 | 587 | 622 | 556 | 548 | 587 | 558 | 564 | 547 | 548 | 576 | 586 | Crash on pasring of script containing `execute block` with lot of nested begin..end statements |
|
303 | SS | 394 | 407 | 419 | 420 | 425 | 423 | 432 | 424 | 429 | 421 | 441 | 423 | 641 | 433 | 406 | 393 | 360 | 377 | 368 | 364 | 372 | 366 | 374 | 371 | 365 | 395 | 370 | 376 | 361 | 364 | 366 | Crash on pasring of script containing `execute block` with lot of nested begin..end statements |
|
304 | CS | 591 | 610 | 593 | 619 | 619 | 621 | 715 | 629 | 626 | 586 | 634 | 603 | 624 | 619 | 620 | 549 | 548 | 576 | 570 | 577 | 590 | 593 | 543 | 566 | 550 | 542 | 597 | 577 | 558 | 538 | 543 | Invalid internal BLR filter conversion |
|
305 | SS | 386 | 397 | 398 | 408 | 401 | 423 | 449 | 407 | 401 | 404 | 440 | 407 | 413 | 415 | 417 | 366 | 368 | 355 | 375 | 357 | 367 | 364 | 356 | 366 | 361 | 405 | 356 | 367 | 353 | 357 | 350 | Invalid internal BLR filter conversion |
|
306 | CS | 587 | 596 | 629 | 619 | 631 | 610 | 672 | 588 | 603 | 592 | 627 | 587 | 611 | 598 | 628 | 583 | 553 | 543 | 543 | 549 | 570 | 571 | 547 | 535 | 593 | 546 | 710 | 538 | 542 | 540 | 539 | ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*' |
|
307 | SS | 380 | 387 | 416 | 405 | 408 | 392 | 438 | 403 | 410 | 406 | 433 | 403 | 403 | 417 | 410 | 365 | 356 | 373 | 364 | 373 | 376 | 358 | 363 | 375 | 377 | 384 | 374 | 360 | 359 | 362 | 360 | ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*' |
|
308 | CS | 798 | 720 | 807 | 887 | 852 | 836 | 900 | 825 | 824 | 855 | 839 | 843 | 860 | 850 | 820 | 775 | 778 | 764 | 760 | 789 | 788 | 818 | 765 | 771 | 785 | 766 | 846 | 762 | 782 | 769 | 753 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
309 | SS | 544 | 454 | 779 | 563 | 566 | 567 | 624 | 572 | 575 | 564 | 614 | 568 | 578 | 560 | 576 | 515 | 521 | 510 | 513 | 518 | 535 | 516 | 514 | 518 | 514 | 554 | 507 | 584 | 518 | 515 | 508 | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
|
310 | CS | 2946 | 3001 | 2958 | 3000 | 2948 | 2997 | 3037 | 2980 | 2987 | 2939 | 2959 | 2948 | 2976 | 2948 | 2948 | 2929 | 2902 | 2903 | 2912 | 2884 | 2977 | 2944 | 2932 | 2881 | 2891 | 2887 | 3141 | 2883 | 2924 | 2935 | 2884 | IIF function prevents the condition from being pushed into the union for better optimization |
|
311 | SS | 2712 | 2716 | 2740 | 2743 | 2725 | 2720 | 2815 | 2721 | 2743 | 2754 | 2757 | 2733 | 2724 | 2751 | 2731 | 2930 | 2694 | 2696 | 2690 | 2680 | 2691 | 2692 | 2673 | 2686 | 2683 | 2687 | 2674 | 2709 | 2688 | 2672 | 2689 | IIF function prevents the condition from being pushed into the union for better optimization |
|
312 | CS | 591 | 588 | 603 | 596 | 638 | 599 | 680 | 602 | 627 | 587 | 625 | 595 | 625 | 637 | 609 | 541 | 578 | 543 | 555 | 549 | 617 | 617 | 543 | 568 | 548 | 547 | 939 | 540 | 577 | 540 | 576 | Add label about deterministic flag for stored function in SHOW and extract commands |
|
313 | SS | 397 | 387 | 422 | 426 | 428 | 405 | 458 | 414 | 410 | 421 | 434 | 411 | 410 | 434 | 414 | 357 | 443 | 368 | 452 | 362 | 361 | 368 | 354 | 362 | 378 | 389 | 364 | 362 | 360 | 372 | 363 | Add label about deterministic flag for stored function in SHOW and extract commands |
|
314 | CS | 1185 | 1201 | 1197 | 1239 | 1270 | 1216 | 1306 | 1217 | 1203 | 1197 | 1186 | 1200 | 1185 | 1223 | 1234 | 1123 | 1120 | 1111 | 1124 | 1140 | 1209 | 1171 | 1143 | 1149 | 1119 | 1147 | 1242 | 1114 | 1162 | 1108 | 1143 | Operator REVOKE can modify rights granted to system tables at DB creation time |
|
315 | SS | 730 | 730 | 1087 | 748 | 772 | 733 | 737 | 779 | 778 | 744 | 810 | 776 | 747 | 740 | 730 | 690 | 668 | 683 | 667 | 667 | 674 | 675 | 668 | 671 | 671 | 747 | 678 | 675 | 714 | 848 | 664 | Operator REVOKE can modify rights granted to system tables at DB creation time |
|
316 | CS | 1202 | 1232 | 1212 | 1214 | 1278 | 1214 | 1313 | 1253 | 1209 | 1206 | 1210 | 1210 | 1257 | 1251 | 1252 | 1186 | 1181 | 1122 | 1131 | 1124 | 1198 | 1123 | 1116 | 1138 | 1126 | 1144 | 1206 | 1120 | 1146 | 1122 | 1117 | Non-privileged user can implicitly count records in a restricted table |
|
317 | SS | 720 | 723 | 756 | 760 | 744 | 736 | 753 | 742 | 803 | 741 | 749 | 747 | 777 | 777 | 749 | 717 | 697 | 694 | 689 | 684 | 688 | 672 | 698 | 668 | 687 | 733 | 687 | 686 | 704 | 674 | 675 | Non-privileged user can implicitly count records in a restricted table |
|
318 | CS | 1558 | 1615 | 12423 | 12380 | 1627 | 1636 | 1651 | 1650 | 1621 | 1624 | 1632 | 1611 | 1656 | 1629 | 1661 | 1550 | 1567 | 1523 | 1524 | 1540 | 1527 | 1526 | 1522 | 1519 | 1541 | 1532 | 1526 | 1529 | 1528 | 1518 | 1517 | Restore of encrypted backup of database with SQL dialect 1 fails |
|
319 | SS | 1153 | 1207 | 12009 | 11930 | 1257 | 1174 | 1190 | 1195 | 1214 | 1189 | 1208 | 1184 | 1224 | 1189 | 1204 | 1113 | 1100 | 1105 | 1102 | 1095 | 1119 | 1115 | 1100 | 1106 | 1132 | 1104 | 1317 | 1128 | 1104 | 1106 | 1099 | Restore of encrypted backup of database with SQL dialect 1 fails |