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 | F | F | F | 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 |
|
3 | 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 |
|
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 | Prohibit any improper mixture of explicit and implicit joins |
|
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 | Prohibit any improper mixture of explicit and implicit joins |
|
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 | Join condition fails for UTF-8 databases |
|
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 | Join condition fails for UTF-8 databases |
|
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 | Natural is used to select instead of primary key index |
|
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 | Natural is used to select instead of primary key index |
|
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 | isql should show packaged procedures and functions categorized per package |
|
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 | isql should show packaged procedures and functions categorized per package |
|
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 | PK index is not used for derived tables |
|
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 | PK index is not used for derived tables |
|
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 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
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 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
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 | Broken error handling in the case of a conversion error happened during index creation |
|
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 | Broken error handling in the case of a conversion error happened during index creation |
|
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 | DROP VIEW drops output parameters of used stored procedures |
|
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 | DROP VIEW drops output parameters of used stored procedures |
|
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 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
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 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
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 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
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 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
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 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
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 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
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 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
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 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
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 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
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 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
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 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
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 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
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 | Cannot alter the domain after migrating from older versions |
|
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 | Cannot alter the domain after migrating from older versions |
|
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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
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 | Expression index with TRIM may lead to incorrect indexed lookup |
|
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 | Expression index with TRIM may lead to incorrect indexed lookup |
|
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 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
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 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
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 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
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 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
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 | UTF8 UNICODE_CI collate can not be used in compound index |
|
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 | UTF8 UNICODE_CI collate can not be used in compound index |
|
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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
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 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
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 | "BLOB not found" error after creation/altering of the invalid trigger |
|
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 | "BLOB not found" error after creation/altering of the invalid trigger |
|
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 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
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 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
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 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
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 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
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 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
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 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
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 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
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 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
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 | Generators are set to 0 after restore |
|
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 | Generators are set to 0 after restore |
|
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 | Blob filter to translate internal debug info into text representation |
|
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 | Blob filter to translate internal debug info into text representation |
|
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 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
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 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
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 | Recurse leads to hangs/crash server |
|
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 | Recurse leads to hangs/crash server |
|
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 | [FB3] AV with "UPDATE OR INSERT" |
|
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 | [FB3] AV with "UPDATE OR INSERT" |
|
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 | Inefficient optimization (regression) |
|
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 | Inefficient optimization (regression) |
|
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 | Regression in joins on procedures |
|
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 | Regression in joins on procedures |
|
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 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
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 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
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 | DROP VIEW ignores the existing non-column dependencies |
|
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 | DROP VIEW ignores the existing non-column dependencies |
|
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 | Alter procedure allows to add the parameter with the same name |
|
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 | Alter procedure allows to add the parameter with the same name |
|
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 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
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 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
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 | Inconsistent domain's constraint validation in PSQL |
|
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 | Inconsistent domain's constraint validation in PSQL |
|
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 | Floating-point negative zero doesn't match positive zero in the index |
|
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 | Floating-point negative zero doesn't match positive zero in the index |
|
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 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
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 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
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 | CHAR(32767) present in XSQLVAR with length 32765 |
|
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 | CHAR(32767) present in XSQLVAR with length 32765 |
|
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 | Include expected and actual string lenght into error message for sqlcode -802 |
|
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 | Include expected and actual string lenght into error message for sqlcode -802 |
|
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 | TRACE: add statistics of actions that were after transaction finished |
|
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 | TRACE: add statistics of actions that were after transaction finished |
|
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 | Can insert DUPLICATE keys in UNIQUE index |
|
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 | Can insert DUPLICATE keys in UNIQUE index |
|
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 | Server crashes with access violation when inserting row into table with unique index |
|
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 | Server crashes with access violation when inserting row into table with unique index |
|
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 | computed index by substring function for long columns |
|
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 | computed index by substring function for long columns |
|
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 | Wrong warning message for ambiguous query |
|
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 | Wrong warning message for ambiguous query |
|
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 | Wrong warning message for ambiguous query |
|
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 | Wrong warning message for ambiguous query |
|
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 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
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 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
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 | IS NOT DISTINCT FROM NULL doesn't use index |
|
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 | IS NOT DISTINCT FROM NULL doesn't use index |
|
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 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
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 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
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 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
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 | WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table |
|
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 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
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 | Conversion error when using a blob as an argument for the EXCEPTION statement |
|
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 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
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 | Usage of a NATURAL JOIN with a derived table crashes the server |
|
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 | Extend the error reported for index/constraint violations to include the problematic key value |
|
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 | Extend the error reported for index/constraint violations to include the problematic key value |
|
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 | Wrong numbers in error message for decreasing char/varchar columns |
|
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 | Wrong numbers in error message for decreasing char/varchar columns |
|
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 | Derived fields may not be optimized via an index |
|
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 | Derived fields may not be optimized via an index |
|
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 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
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 | Creating self-referential FK crashes database (bug-check) whether constraint violation had place |
|
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 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
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 | Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause |
|
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 | isql doesn't know the difference between UDF's and psql-functions |
|
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 | isql doesn't know the difference between UDF's and psql-functions |
|
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 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
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 | Original table name and column name and owner missing from SQLDA for aliased column in grouped query |
|
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 | Join using RDB$DB_KEY produce NATURAL plan |
|
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 | Join using RDB$DB_KEY produce NATURAL plan |
|
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 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
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 | Creating table with computed fields containing "SELECT FIRST" produces corrupted result |
|
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 | Broken optimization for the stored dbkeys |
|
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 | Broken optimization for the stored dbkeys |
|
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 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
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 | NOT-NULL column can be used as primary key and filled with NULL-values |
|
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 | Computed by columns and position function |
|
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 | Computed by columns and position function |
|
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 | Server bugchecks or crashes on exception in calculated index |
|
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 | Server bugchecks or crashes on exception in calculated index |
|
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 | Regression: Group by fails if subselect-column is involved |
|
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 | Regression: Group by fails if subselect-column is involved |
|
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 | Bad optimization of OR predicates applied to unions |
|
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 | Bad optimization of OR predicates applied to unions |
|
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 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
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 | COMPUTED BY field is evaluated as NULL if used as an exception parameter directly |
|
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 | Expression index may be not used for derived fields or view fields |
|
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 | Expression index may be not used for derived fields or view fields |
|
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 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
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 | Metadata source becomes wrong after twice transliteration to the metadata charset |
|
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 | Metadata export with isql (option -ex) does not export functions properly |
|
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 | Metadata export with isql (option -ex) does not export functions properly |
|
150 | 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 |
|
151 | 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 | 17616 | 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 | 586 | 605 | 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 |
|
3 | SS | 375 | 390 | 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 |
|
4 | CS | 808 | 840 | 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 |
|
5 | SS | 543 | 554 | 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 |
|
6 | CS | 598 | 608 | 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 |
|
7 | 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 |
|
8 | CS | 649 | 654 | 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 |
|
9 | SS | 444 | 460 | 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 |
|
10 | CS | 596 | 604 | 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 |
|
11 | SS | 384 | 403 | 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 |
|
12 | CS | 775 | 594 | 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 |
|
13 | SS | 525 | 417 | 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 |
|
14 | CS | 589 | 603 | 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) |
|
15 | SS | 388 | 397 | 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) |
|
16 | CS | 586 | 594 | 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 |
|
17 | SS | 378 | 395 | 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 |
|
18 | CS | 787 | 611 | 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 |
|
19 | SS | 531 | 392 | 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 |
|
20 | CS | 805 | 598 | 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 |
|
21 | SS | 524 | 436 | 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 |
|
22 | CS | 801 | 601 | 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 |
|
23 | SS | 533 | 411 | 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 |
|
24 | 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 |
|
25 | SS | 402 | 413 | 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 |
|
26 | CS | 717 | 803 | 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 |
|
27 | SS | 513 | 597 | 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 |
|
28 | CS | 791 | 582 | 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 |
|
29 | SS | 524 | 387 | 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 |
|
30 | CS | 594 | 630 | 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 |
|
31 | SS | 408 | 407 | 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 |
|
32 | CS | 932 | 975 | 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 |
|
33 | SS | 623 | 636 | 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 |
|
34 | CS | 671 | 678 | 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 |
|
35 | SS | 464 | 471 | 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 |
|
36 | CS | 827 | 848 | 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 |
|
37 | SS | 570 | 580 | 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 |
|
38 | CS | 789 | 591 | 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 |
|
39 | SS | 525 | 397 | 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 |
|
40 | CS | 797 | 584 | 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 |
|
41 | SS | 534 | 395 | 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 |
|
42 | CS | 618 | 626 | 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 |
|
43 | SS | 424 | 408 | 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 |
|
44 | CS | 580 | 603 | 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 |
|
45 | SS | 384 | 403 | 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 |
|
46 | CS | 582 | 617 | 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 |
|
47 | SS | 398 | 396 | 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 |
|
48 | CS | 798 | 835 | 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 |
|
49 | SS | 544 | 567 | 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 |
|
50 | CS | 576 | 592 | 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 |
|
51 | SS | 391 | 389 | 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 |
|
52 | CS | 585 | 585 | 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 |
|
53 | SS | 397 | 407 | 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 |
|
54 | CS | 572 | 587 | 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 |
|
55 | SS | 393 | 394 | 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 |
|
56 | CS | 1034 | 1037 | 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 |
|
57 | SS | 745 | 752 | 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 |
|
58 | CS | 782 | 793 | 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 |
|
59 | SS | 527 | 545 | 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 |
|
60 | CS | 577 | 616 | 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 |
|
61 | SS | 388 | 391 | 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 |
|
62 | CS | 773 | 776 | 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 |
|
63 | SS | 549 | 560 | 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 |
|
64 | CS | 806 | 596 | 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" |
|
65 | SS | 536 | 426 | 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" |
|
66 | CS | 607 | 614 | 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) |
|
67 | SS | 397 | 429 | 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) |
|
68 | CS | 1128 | 1173 | 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 |
|
69 | SS | 812 | 830 | 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 |
|
70 | CS | 799 | 592 | 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 |
|
71 | SS | 543 | 414 | 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 |
|
72 | CS | 778 | 597 | 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 |
|
73 | SS | 528 | 420 | 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 |
|
74 | CS | 784 | 784 | 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 |
|
75 | SS | 516 | 551 | 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 |
|
76 | CS | 594 | 592 | 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" |
|
77 | SS | 406 | 411 | 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" |
|
78 | CS | 600 | 643 | 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 |
|
79 | SS | 404 | 418 | 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 |
|
80 | CS | 793 | 866 | 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 |
|
81 | SS | 538 | 562 | 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 |
|
82 | CS | 575 | 768 | 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 |
|
83 | SS | 396 | 510 | 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 |
|
84 | CS | 583 | 595 | 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 |
|
85 | SS | 386 | 395 | 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 |
|
86 | CS | 582 | 588 | 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 |
|
87 | SS | 370 | 403 | 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 |
|
88 | CS | 2932 | 2955 | 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 |
|
89 | SS | 2684 | 2693 | 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 |
|
90 | CS | 647 | 644 | 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 |
|
91 | SS | 392 | 373 | 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 |
|
92 | CS | 581 | 597 | 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 |
|
93 | SS | 396 | 401 | 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 |
|
94 | CS | 612 | 633 | 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 |
|
95 | SS | 393 | 406 | 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 |
|
96 | CS | 569 | 627 | 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 |
|
97 | SS | 374 | 400 | 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 |
|
98 | CS | 575 | 588 | 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 |
|
99 | SS | 376 | 381 | 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 |
|
100 | CS | 593 | 593 | 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 |
|
101 | SS | 380 | 409 | 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 |
|
102 | CS | 766 | 584 | 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 |
|
103 | 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 |
|
104 | CS | 1182 | 1158 | 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 |
|
105 | SS | 746 | 1015 | 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 |
|
106 | CS | 1757 | 1767 | 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 |
|
107 | SS | 969 | 841 | 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 |
|
108 | CS | 771 | 588 | 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 |
|
109 | SS | 511 | 392 | 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 |
|
110 | CS | 572 | 575 | 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 |
|
111 | SS | 368 | 392 | 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 |
|
112 | CS | 592 | 594 | 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 |
|
113 | SS | 399 | 409 | 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 |
|
114 | CS | 590 | 595 | 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 |
|
115 | SS | 381 | 416 | 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 |
|
116 | CS | 575 | 577 | 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 |
|
117 | SS | 373 | 385 | 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 |
|
118 | CS | 579 | 640 | 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 |
|
119 | SS | 382 | 410 | 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 |
|
120 | CS | 806 | 839 | 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 |
|
121 | SS | 561 | 573 | 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 |
|
122 | CS | 591 | 597 | 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 |
|
123 | SS | 382 | 415 | 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 |
|
124 | CS | 581 | 614 | 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 |
|
125 | SS | 374 | 404 | 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 |
|
126 | CS | 589 | 634 | 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 |
|
127 | SS | 399 | 408 | 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 |
|
128 | CS | 598 | 599 | 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 |
|
129 | SS | 395 | 423 | 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 |
|
130 | CS | 771 | 619 | 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 |
|
131 | SS | 525 | 387 | 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 |
|
132 | CS | 582 | 582 | 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 |
|
133 | SS | 378 | 392 | 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 |
|
134 | CS | 787 | 615 | 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 |
|
135 | SS | 524 | 391 | 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 |
|
136 | CS | 799 | 596 | 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 |
|
137 | SS | 530 | 393 | 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 |
|
138 | CS | 582 | 581 | 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 |
|
139 | SS | 366 | 383 | 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 |
|
140 | CS | 579 | 579 | 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 |
|
141 | SS | 379 | 420 | 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 |
|
142 | CS | 800 | 830 | 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 |
|
143 | SS | 538 | 544 | 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 |
|
144 | CS | 795 | 595 | 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 |
|
145 | SS | 528 | 390 | 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 |
|
146 | CS | 581 | 581 | 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 |
|
147 | SS | 382 | 392 | 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 |
|
148 | CS | 845 | 852 | 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 |
|
149 | SS | 573 | 559 | 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 |
|
150 | CS | 1558 | 1609 | 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 |
|
151 | SS | 1153 | 1208 | 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 |