NN | Test name | mode |
6.0.0.881
|
6.0.0.877
|
6.0.0.876
|
6.0.0.863
|
6.0.0.858
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
6.0.0.753
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
2 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
3 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit any improper mixture of explicit and implicit joins |
|
4 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit any improper mixture of explicit and implicit joins |
|
5 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Join condition fails for UTF-8 databases |
|
6 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Join condition fails for UTF-8 databases |
|
7 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Natural is used to select instead of primary key index |
|
8 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Natural is used to select instead of primary key index |
|
9 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | isql should show packaged procedures and functions categorized per package |
|
10 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | isql should show packaged procedures and functions categorized per package |
|
11 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | PK index is not used for derived tables |
|
12 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | PK index is not used for derived tables |
|
13 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
14 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
15 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Broken error handling in the case of a conversion error happened during index creation |
|
16 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Broken error handling in the case of a conversion error happened during index creation |
|
17 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW drops output parameters of used stored procedures |
|
18 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW drops output parameters of used stored procedures |
|
19 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
20 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
21 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
22 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
23 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
24 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
25 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
26 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
27 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Using both the procedure name and alias inside an explicit plan crashes the server |
|
28 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Using both the procedure name and alias inside an explicit plan crashes the server |
|
29 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
30 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
31 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cannot alter the domain after migrating from older versions |
|
32 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cannot alter the domain after migrating from older versions |
|
33 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
34 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
35 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Expression index with TRIM may lead to incorrect indexed lookup |
|
36 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Expression index with TRIM may lead to incorrect indexed lookup |
|
37 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
38 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
39 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
40 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
41 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | UTF8 UNICODE_CI collate can not be used in compound index |
|
42 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | UTF8 UNICODE_CI collate can not be used in compound index |
|
43 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
44 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
45 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | "BLOB not found" error after creation/altering of the invalid trigger |
|
46 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | "BLOB not found" error after creation/altering of the invalid trigger |
|
47 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
48 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
49 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
50 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
51 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
52 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
53 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
54 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
55 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Generators are set to 0 after restore |
|
56 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Generators are set to 0 after restore |
|
57 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Blob filter to translate internal debug info into text representation |
|
58 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Blob filter to translate internal debug info into text representation |
|
59 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
60 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
61 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Recurse leads to hangs/crash server |
|
62 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Recurse leads to hangs/crash server |
|
63 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | [FB3] AV with "UPDATE OR INSERT" |
|
64 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | [FB3] AV with "UPDATE OR INSERT" |
|
65 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inefficient optimization (regression) |
|
66 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inefficient optimization (regression) |
|
67 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression in joins on procedures |
|
68 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression in joins on procedures |
|
69 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Altering of a TYPE OF COLUMN parameter affects the original column |
|
70 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Altering of a TYPE OF COLUMN parameter affects the original column |
|
71 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW ignores the existing non-column dependencies |
|
72 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP VIEW ignores the existing non-column dependencies |
|
73 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Alter procedure allows to add the parameter with the same name |
|
74 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Alter procedure allows to add the parameter with the same name |
|
75 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
76 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
77 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistent domain's constraint validation in PSQL |
|
78 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistent domain's constraint validation in PSQL |
|
79 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Floating-point negative zero doesn't match positive zero in the index |
|
80 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Floating-point negative zero doesn't match positive zero in the index |
|
81 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
82 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
83 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CHAR(32767) present in XSQLVAR with length 32765 |
|
84 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | CHAR(32767) present in XSQLVAR with length 32765 |
|
85 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Include expected and actual string lenght into error message for sqlcode -802 |
|
86 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Include expected and actual string lenght into error message for sqlcode -802 |
|
87 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | TRACE: add statistics of actions that were after transaction finished |
|
88 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | TRACE: add statistics of actions that were after transaction finished |
|
89 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Can insert DUPLICATE keys in UNIQUE index |
|
90 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Can insert DUPLICATE keys in UNIQUE index |
|
91 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server crashes with access violation when inserting row into table with unique index |
|
92 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Server crashes with access violation when inserting row into table with unique index |
|
93 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | computed index by substring function for long columns |
|
94 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | computed index by substring function for long columns |
|
95 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
96 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
97 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
98 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong warning message for ambiguous query |
|
99 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Missing constraint name in foreign key error message in FB 2.1.4 |
|
100 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Missing constraint name in foreign key error message in FB 2.1.4 |
NN | Test name | mode | median_ms |
6.0.0.881
|
6.0.0.877
|
6.0.0.876
|
6.0.0.863
|
6.0.0.858
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
6.0.0.753
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1061 | 1079 | 1099 | 606 | 937 | 1088 | 615 | 1053 | 665 | 1070 | 709 | 625 | 646 | 678 | 1130 | 1045 | 1252 | 1076 | 1078 | 1161 | 1040 | 1152 | 678 | 612 | 602 | 1088 | 1102 | 1239 | 1049 | 1148 | 1259 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
2 | SS | 436 | 418 | 473 | 436 | 398 | 407 | 459 | 388 | 445 | 518 | 369 | 440 | 453 | 431 | 436 | 457 | 402 | 456 | 458 | 425 | 429 | 391 | 413 | 441 | 447 | 438 | 426 | 413 | 359 | 488 | 444 | Views based on procedures can't be created if the proc's output fields participate in an expression |
|
3 | CS | 1272 | 1354 | 1306 | 1249 | 1257 | 835 | 739 | 1131 | 864 | 1348 | 778 | 808 | 851 | 767 | 1401 | 1327 | 1424 | 1288 | 1235 | 1387 | 1123 | 1307 | 909 | 813 | 802 | 1454 | 1373 | 1518 | 1389 | 1497 | 1363 | Prohibit any improper mixture of explicit and implicit joins |
|
4 | SS | 567 | 527 | 564 | 583 | 554 | 544 | 667 | 518 | 564 | 532 | 534 | 530 | 561 | 550 | 551 | 582 | 574 | 589 | 623 | 578 | 598 | 586 | 595 | 542 | 558 | 509 | 585 | 570 | 602 | 591 | 608 | Prohibit any improper mixture of explicit and implicit joins |
|
5 | CS | 1074 | 1072 | 859 | 1027 | 1092 | 691 | 692 | 620 | 703 | 1105 | 608 | 645 | 597 | 608 | 1080 | 1092 | 1076 | 1080 | 1061 | 1164 | 957 | 1108 | 760 | 1165 | 818 | 1211 | 1137 | 1205 | 1167 | 1115 | 1365 | Join condition fails for UTF-8 databases |
|
6 | SS | 459 | 435 | 451 | 447 | 434 | 432 | 453 | 447 | 468 | 534 | 446 | 462 | 451 | 441 | 500 | 486 | 467 | 456 | 438 | 522 | 523 | 471 | 438 | 469 | 470 | 413 | 513 | 470 | 441 | 485 | 546 | Join condition fails for UTF-8 databases |
|
7 | CS | 1229 | 1259 | 762 | 1293 | 1244 | 734 | 663 | 1326 | 857 | 1181 | 680 | 925 | 711 | 787 | 718 | 1301 | 1533 | 1016 | 1267 | 1322 | 1214 | 1346 | 824 | 1185 | 679 | 1263 | 1353 | 1345 | 1293 | 1334 | 1299 | Natural is used to select instead of primary key index |
|
8 | SS | 542 | 515 | 462 | 493 | 476 | 528 | 746 | 552 | 576 | 607 | 496 | 569 | 504 | 558 | 558 | 526 | 540 | 582 | 564 | 552 | 621 | 547 | 554 | 524 | 515 | 540 | 522 | 545 | 508 | 591 | 514 | Natural is used to select instead of primary key index |
|
9 | CS | 1037 | 1033 | 1087 | 981 | 1044 | 635 | 671 | 1234 | 671 | 1167 | 656 | 627 | 624 | 647 | 1077 | 1110 | 1034 | 1074 | 1033 | 1065 | 904 | 1076 | 756 | 1122 | 645 | 1121 | 1041 | 1100 | 1056 | 1012 | 1182 | isql should show packaged procedures and functions categorized per package |
|
10 | SS | 439 | 398 | 395 | 471 | 429 | 449 | 472 | 474 | 457 | 441 | 472 | 471 | 436 | 406 | 416 | 446 | 467 | 438 | 422 | 429 | 495 | 461 | 415 | 468 | 465 | 409 | 431 | 425 | 425 | 441 | 433 | isql should show packaged procedures and functions categorized per package |
|
11 | CS | 1257 | 1068 | 1276 | 1322 | 1291 | 810 | 811 | 1374 | 789 | 1252 | 758 | 803 | 957 | 888 | 1225 | 1387 | 1339 | 1092 | 1196 | 1382 | 1285 | 858 | 929 | 1278 | 751 | 1400 | 1301 | 1381 | 1262 | 1324 | 1409 | PK index is not used for derived tables |
|
12 | SS | 535 | 461 | 505 | 491 | 537 | 531 | 522 | 586 | 531 | 530 | 540 | 552 | 540 | 684 | 527 | 532 | 552 | 592 | 522 | 573 | 583 | 523 | 485 | 560 | 497 | 522 | 537 | 553 | 534 | 536 | 593 | PK index is not used for derived tables |
|
13 | CS | 1052 | 978 | 1193 | 1164 | 1053 | 683 | 667 | 1237 | 679 | 1052 | 644 | 649 | 628 | 630 | 1143 | 1058 | 1116 | 1020 | 1013 | 1069 | 849 | 1163 | 771 | 1092 | 682 | 1159 | 1090 | 1154 | 987 | 1292 | 1175 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
14 | SS | 429 | 462 | 418 | 389 | 413 | 469 | 484 | 392 | 438 | 436 | 402 | 471 | 403 | 432 | 373 | 385 | 438 | 455 | 422 | 427 | 413 | 505 | 433 | 427 | 412 | 471 | 446 | 437 | 399 | 419 | 439 | Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1) |
|
15 | CS | 1019 | 1152 | 1014 | 1066 | 1024 | 1091 | 591 | 928 | 793 | 1081 | 572 | 660 | 590 | 647 | 1048 | 1069 | 910 | 958 | 1064 | 1114 | 612 | 950 | 716 | 988 | 632 | 1085 | 1060 | 1165 | 1172 | 1201 | 1132 | Broken error handling in the case of a conversion error happened during index creation |
|
16 | SS | 416 | 409 | 427 | 418 | 395 | 399 | 438 | 447 | 461 | 464 | 407 | 445 | 480 | 436 | 408 | 373 | 391 | 466 | 399 | 422 | 468 | 403 | 424 | 399 | 448 | 414 | 404 | 408 | 422 | 392 | 379 | Broken error handling in the case of a conversion error happened during index creation |
|
17 | CS | 1261 | 944 | 1254 | 756 | 1256 | 1099 | 751 | 1383 | 1700 | 1355 | 865 | 789 | 788 | 712 | 1528 | 1266 | 1314 | 1086 | 1157 | 1365 | 786 | 1272 | 870 | 1356 | 758 | 1370 | 1269 | 1325 | 1300 | 1312 | 1318 | DROP VIEW drops output parameters of used stored procedures |
|
18 | SS | 538 | 403 | 512 | 532 | 536 | 512 | 546 | 495 | 592 | 631 | 540 | 570 | 583 | 547 | 529 | 521 | 558 | 559 | 526 | 507 | 574 | 536 | 492 | 583 | 570 | 540 | 537 | 522 | 574 | 504 | 588 | DROP VIEW drops output parameters of used stored procedures |
|
19 | CS | 1294 | 615 | 1239 | 906 | 740 | 781 | 1320 | 769 | 868 | 791 | 900 | 1412 | 954 | 725 | 1562 | 1522 | 1434 | 1304 | 1602 | 882 | 1444 | 1356 | 806 | 756 | 1433 | 1409 | 1437 | 1398 | 1285 | 1412 | 1386 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
20 | SS | 554 | 370 | 452 | 648 | 516 | 555 | 574 | 553 | 486 | 623 | 556 | 622 | 578 | 557 | 559 | 534 | 579 | 541 | 573 | 587 | 561 | 603 | 509 | 541 | 557 | 494 | 533 | 497 | 463 | 511 | 540 | The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well |
|
21 | CS | 1140 | 1069 | 855 | 733 | 715 | 710 | 1423 | 767 | 838 | 804 | 799 | 1364 | 819 | 782 | 1359 | 1008 | 1428 | 1357 | 1212 | 1413 | 872 | 1300 | 952 | 1462 | 1015 | 1353 | 1303 | 1375 | 1388 | 1483 | 1444 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
22 | SS | 571 | 432 | 570 | 553 | 599 | 569 | 626 | 620 | 572 | 616 | 578 | 596 | 600 | 571 | 567 | 566 | 571 | 619 | 614 | 561 | 582 | 586 | 477 | 577 | 597 | 555 | 524 | 496 | 530 | 536 | 516 | Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler |
|
23 | CS | 1222 | 749 | 676 | 875 | 716 | 681 | 1229 | 671 | 835 | 670 | 726 | 1288 | 813 | 729 | 1131 | 1225 | 1219 | 1311 | 1320 | 1402 | 1301 | 1317 | 773 | 1312 | 1243 | 1268 | 1303 | 1350 | 1380 | 1385 | 1215 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
24 | SS | 546 | 504 | 500 | 536 | 502 | 569 | 572 | 613 | 528 | 539 | 550 | 583 | 614 | 544 | 545 | 532 | 538 | 521 | 567 | 544 | 561 | 489 | 554 | 542 | 593 | 602 | 557 | 572 | 533 | 547 | 548 | Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used |
|
25 | CS | 1413 | 953 | 765 | 824 | 704 | 787 | 1470 | 771 | 863 | 986 | 782 | 1760 | 838 | 832 | 1419 | 1597 | 1436 | 1592 | 1673 | 1902 | 1491 | 1664 | 1107 | 1629 | 1078 | 1732 | 1360 | 1714 | 1407 | 1576 | 1533 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
26 | SS | 871 | 811 | 645 | 708 | 692 | 762 | 893 | 813 | 837 | 903 | 722 | 909 | 785 | 884 | 874 | 906 | 899 | 852 | 921 | 845 | 921 | 844 | 939 | 988 | 879 | 869 | 882 | 893 | 806 | 904 | 827 | Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued |
|
27 | CS | 1271 | 568 | 1315 | 1358 | 1236 | 1218 | 719 | 1269 | 776 | 929 | 738 | 804 | 1315 | 788 | 1260 | 1338 | 1383 | 1304 | 1558 | 1361 | 1302 | 1516 | 867 | 1335 | 1247 | 793 | 1309 | 1205 | 1315 | 1274 | 1366 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
28 | SS | 537 | 385 | 430 | 538 | 531 | 482 | 576 | 495 | 561 | 621 | 504 | 558 | 602 | 565 | 511 | 539 | 561 | 532 | 553 | 509 | 598 | 498 | 527 | 573 | 555 | 517 | 522 | 537 | 538 | 580 | 499 | Using both the procedure name and alias inside an explicit plan crashes the server |
|
29 | CS | 1087 | 588 | 602 | 1142 | 591 | 1014 | 647 | 1106 | 688 | 813 | 601 | 826 | 934 | 670 | 1085 | 1143 | 1181 | 1192 | 1241 | 1079 | 1097 | 1212 | 720 | 1144 | 1233 | 1209 | 1066 | 1185 | 1128 | 1089 | 1180 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
30 | SS | 463 | 458 | 421 | 457 | 430 | 397 | 443 | 498 | 491 | 492 | 485 | 439 | 456 | 531 | 467 | 439 | 470 | 463 | 455 | 476 | 502 | 482 | 419 | 435 | 435 | 476 | 515 | 514 | 502 | 464 | 338 | Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL |
|
31 | CS | 1636 | 920 | 1592 | 1634 | 1157 | 1663 | 1786 | 1642 | 2038 | 1334 | 916 | 1744 | 973 | 1730 | 1735 | 1694 | 1703 | 966 | 1499 | 1439 | 1536 | 1922 | 1074 | 1825 | 1762 | 1513 | 1928 | 1635 | 1637 | 1615 | 1819 | Cannot alter the domain after migrating from older versions |
|
32 | SS | 733 | 759 | 701 | 685 | 732 | 734 | 813 | 737 | 785 | 805 | 690 | 679 | 794 | 785 | 676 | 766 | 836 | 742 | 706 | 711 | 757 | 745 | 717 | 787 | 673 | 679 | 640 | 722 | 748 | 716 | 714 | Cannot alter the domain after migrating from older versions |
|
33 | CS | 1351 | 664 | 1363 | 1266 | 1296 | 1424 | 1427 | 1189 | 1571 | 853 | 729 | 1430 | 739 | 1222 | 1348 | 1252 | 1446 | 801 | 1568 | 1511 | 1527 | 1358 | 855 | 1386 | 1404 | 1321 | 1109 | 1669 | 1380 | 1355 | 1290 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
34 | SS | 602 | 546 | 572 | 522 | 564 | 545 | 561 | 576 | 601 | 653 | 689 | 567 | 603 | 639 | 568 | 602 | 630 | 636 | 659 | 654 | 651 | 718 | 676 | 647 | 596 | 565 | 604 | 638 | 564 | 622 | 575 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
35 | CS | 1416 | 793 | 832 | 1398 | 1507 | 1478 | 796 | 1395 | 1575 | 1153 | 820 | 846 | 1001 | 803 | 1576 | 1470 | 1589 | 1441 | 1760 | 1852 | 1306 | 1448 | 1069 | 1530 | 1435 | 1329 | 846 | 1490 | 1342 | 1618 | 1524 | Expression index with TRIM may lead to incorrect indexed lookup |
|
36 | SS | 661 | 618 | 624 | 604 | 625 | 564 | 647 | 599 | 656 | 773 | 664 | 672 | 691 | 649 | 636 | 711 | 671 | 704 | 773 | 702 | 679 | 677 | 639 | 636 | 716 | 701 | 625 | 676 | 638 | 659 | 676 | Expression index with TRIM may lead to incorrect indexed lookup |
|
37 | CS | 1289 | 565 | 748 | 1353 | 1199 | 1313 | 951 | 1263 | 1335 | 845 | 761 | 947 | 945 | 752 | 1465 | 1275 | 1509 | 1443 | 1388 | 1675 | 1374 | 1193 | 888 | 1276 | 1302 | 1447 | 801 | 1332 | 1345 | 1356 | 1464 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
38 | SS | 548 | 369 | 541 | 500 | 493 | 479 | 525 | 590 | 599 | 558 | 592 | 567 | 603 | 586 | 534 | 559 | 518 | 581 | 590 | 553 | 536 | 519 | 514 | 572 | 550 | 547 | 482 | 577 | 501 | 569 | 539 | ALTER VIEW with not matched columns in declaration and selection crashes the server |
|
39 | CS | 1311 | 682 | 748 | 1266 | 1372 | 1376 | 739 | 1351 | 1299 | 946 | 749 | 819 | 947 | 1341 | 1637 | 1297 | 1382 | 1351 | 1553 | 1647 | 1364 | 833 | 841 | 1420 | 1366 | 1385 | 837 | 780 | 1389 | 1323 | 1269 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
40 | SS | 551 | 374 | 488 | 546 | 558 | 542 | 607 | 537 | 598 | 572 | 544 | 569 | 591 | 576 | 602 | 538 | 579 | 525 | 596 | 573 | 613 | 540 | 547 | 534 | 575 | 554 | 534 | 506 | 548 | 578 | 517 | View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE |
|
41 | CS | 1188 | 661 | 690 | 1181 | 1151 | 1206 | 691 | 1196 | 1246 | 760 | 697 | 763 | 804 | 1263 | 1292 | 1314 | 1376 | 1286 | 1352 | 1382 | 1351 | 1285 | 818 | 1293 | 1332 | 881 | 757 | 702 | 1168 | 1281 | 1171 | UTF8 UNICODE_CI collate can not be used in compound index |
|
42 | SS | 469 | 426 | 452 | 430 | 470 | 448 | 485 | 577 | 562 | 464 | 505 | 468 | 541 | 485 | 467 | 464 | 527 | 489 | 583 | 453 | 476 | 487 | 490 | 459 | 428 | 426 | 420 | 449 | 471 | 508 | 463 | UTF8 UNICODE_CI collate can not be used in compound index |
|
43 | CS | 1027 | 612 | 586 | 1012 | 936 | 1044 | 574 | 736 | 1109 | 681 | 617 | 639 | 736 | 1113 | 1187 | 1166 | 1149 | 1210 | 1210 | 1278 | 1206 | 1015 | 699 | 1075 | 1039 | 1105 | 1148 | 685 | 662 | 990 | 1261 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
44 | SS | 426 | 368 | 426 | 426 | 379 | 372 | 441 | 437 | 470 | 479 | 453 | 382 | 426 | 407 | 419 | 386 | 409 | 457 | 464 | 444 | 463 | 406 | 466 | 422 | 408 | 462 | 412 | 412 | 443 | 406 | 455 | BAD PLAN with using LEFT OUTER JOIN in SUBSELECT |
|
45 | CS | 1059 | 553 | 645 | 1217 | 1012 | 1043 | 544 | 661 | 1309 | 825 | 677 | 638 | 749 | 1139 | 1114 | 1172 | 1352 | 1100 | 1236 | 1078 | 1211 | 1035 | 666 | 1072 | 1067 | 1063 | 602 | 1056 | 605 | 1095 | 1220 | "BLOB not found" error after creation/altering of the invalid trigger |
|
46 | SS | 422 | 413 | 456 | 353 | 401 | 441 | 493 | 402 | 469 | 487 | 426 | 394 | 417 | 420 | 418 | 403 | 394 | 446 | 417 | 442 | 425 | 415 | 432 | 444 | 404 | 404 | 428 | 449 | 477 | 420 | 428 | "BLOB not found" error after creation/altering of the invalid trigger |
|
47 | CS | 1238 | 689 | 768 | 890 | 1200 | 900 | 751 | 788 | 1494 | 969 | 796 | 791 | 922 | 1300 | 1362 | 1281 | 1324 | 1366 | 1497 | 1662 | 1342 | 1276 | 821 | 787 | 1332 | 1488 | 1399 | 1339 | 795 | 813 | 1355 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
48 | SS | 558 | 574 | 516 | 489 | 513 | 533 | 599 | 558 | 610 | 666 | 566 | 582 | 566 | 548 | 524 | 558 | 559 | 602 | 594 | 588 | 568 | 536 | 536 | 520 | 524 | 466 | 562 | 549 | 520 | 575 | 575 | Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause |
|
49 | CS | 956 | 570 | 564 | 611 | 957 | 585 | 602 | 684 | 1080 | 765 | 642 | 636 | 700 | 1096 | 1177 | 1060 | 1293 | 999 | 1224 | 981 | 1430 | 1032 | 632 | 575 | 956 | 1052 | 1152 | 1060 | 590 | 594 | 1017 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
50 | SS | 405 | 426 | 386 | 375 | 360 | 404 | 406 | 399 | 430 | 411 | 432 | 420 | 429 | 432 | 349 | 421 | 400 | 395 | 389 | 434 | 450 | 382 | 393 | 376 | 370 | 410 | 423 | 414 | 436 | 373 | 358 | Sub-optimal join plan when the slave table depends on the master via the "OR" predicate |
|
51 | CS | 1052 | 593 | 664 | 599 | 1083 | 582 | 739 | 638 | 1137 | 758 | 910 | 602 | 692 | 1151 | 1104 | 1152 | 1074 | 1158 | 1555 | 1134 | 1051 | 1054 | 627 | 1081 | 1078 | 1162 | 1037 | 1086 | 1114 | 574 | 625 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
52 | SS | 425 | 369 | 360 | 443 | 425 | 409 | 472 | 408 | 462 | 500 | 435 | 429 | 423 | 397 | 405 | 414 | 441 | 426 | 421 | 478 | 472 | 503 | 423 | 448 | 414 | 407 | 450 | 462 | 421 | 382 | 449 | Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE |
|
53 | CS | 1007 | 549 | 680 | 604 | 1030 | 699 | 734 | 579 | 1076 | 727 | 569 | 641 | 628 | 1092 | 988 | 1025 | 1152 | 1069 | 1225 | 1095 | 1090 | 1070 | 652 | 1087 | 1087 | 1017 | 961 | 1192 | 998 | 1078 | 654 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
54 | SS | 410 | 338 | 452 | 372 | 418 | 426 | 460 | 458 | 453 | 483 | 408 | 465 | 402 | 396 | 411 | 426 | 415 | 420 | 384 | 415 | 474 | 409 | 409 | 386 | 405 | 361 | 385 | 396 | 418 | 409 | 368 | Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB |
|
55 | CS | 1676 | 929 | 998 | 1008 | 1982 | 1028 | 995 | 1064 | 1880 | 1317 | 972 | 1078 | 1181 | 1969 | 1733 | 1717 | 2003 | 1880 | 2100 | 1748 | 1963 | 1755 | 1120 | 1653 | 1719 | 1682 | 1596 | 1778 | 952 | 1671 | 1687 | Generators are set to 0 after restore |
|
56 | SS | 811 | 710 | 866 | 860 | 846 | 737 | 832 | 815 | 913 | 987 | 799 | 826 | 837 | 859 | 770 | 779 | 778 | 777 | 772 | 855 | 846 | 733 | 761 | 816 | 828 | 726 | 808 | 720 | 749 | 755 | 823 | Generators are set to 0 after restore |
|
57 | CS | 1277 | 759 | 792 | 715 | 1351 | 706 | 785 | 781 | 1388 | 968 | 765 | 883 | 839 | 1182 | 1270 | 1364 | 1372 | 1328 | 1629 | 1450 | 1339 | 1217 | 856 | 1296 | 1390 | 1367 | 1407 | 1252 | 1405 | 1284 | 1365 | Blob filter to translate internal debug info into text representation |
|
58 | SS | 529 | 534 | 538 | 518 | 533 | 462 | 565 | 529 | 514 | 557 | 516 | 592 | 573 | 524 | 529 | 529 | 542 | 522 | 511 | 585 | 548 | 555 | 543 | 511 | 571 | 521 | 501 | 509 | 516 | 529 | 489 | Blob filter to translate internal debug info into text representation |
|
59 | CS | 1041 | 646 | 561 | 658 | 1009 | 648 | 1127 | 656 | 1148 | 745 | 573 | 590 | 732 | 1154 | 1044 | 1055 | 1134 | 1049 | 1185 | 1178 | 1036 | 1038 | 623 | 1135 | 1064 | 1063 | 647 | 1156 | 1073 | 565 | 1074 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
60 | SS | 413 | 379 | 387 | 469 | 398 | 367 | 494 | 407 | 415 | 497 | 407 | 564 | 414 | 383 | 437 | 405 | 413 | 410 | 481 | 457 | 474 | 462 | 420 | 404 | 434 | 377 | 390 | 414 | 385 | 454 | 391 | Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector |
|
61 | CS | 1396 | 768 | 879 | 844 | 1391 | 828 | 937 | 865 | 1701 | 950 | 919 | 1872 | 1055 | 1748 | 1612 | 1263 | 1618 | 1482 | 1750 | 1472 | 1510 | 1492 | 979 | 1319 | 1470 | 1544 | 922 | 1402 | 1245 | 1416 | 1471 | Recurse leads to hangs/crash server |
|
62 | SS | 689 | 556 | 721 | 688 | 661 | 744 | 764 | 813 | 829 | 708 | 690 | 768 | 715 | 714 | 689 | 644 | 664 | 708 | 669 | 694 | 656 | 704 | 666 | 693 | 679 | 663 | 692 | 686 | 660 | 657 | 663 | Recurse leads to hangs/crash server |
|
63 | CS | 1282 | 649 | 751 | 711 | 1287 | 767 | 762 | 1151 | 874 | 889 | 848 | 1520 | 870 | 1283 | 1496 | 1341 | 1371 | 1298 | 1456 | 1421 | 1400 | 1415 | 822 | 1281 | 1393 | 1272 | 756 | 746 | 1312 | 1365 | 1335 | [FB3] AV with "UPDATE OR INSERT" |
|
64 | SS | 552 | 459 | 535 | 519 | 547 | 541 | 583 | 534 | 634 | 538 | 554 | 579 | 539 | 569 | 585 | 566 | 571 | 649 | 601 | 509 | 532 | 614 | 563 | 573 | 573 | 533 | 534 | 544 | 550 | 524 | 565 | [FB3] AV with "UPDATE OR INSERT" |
|
65 | CS | 1124 | 1175 | 605 | 1167 | 1014 | 1132 | 1165 | 615 | 682 | 854 | 618 | 1235 | 809 | 1116 | 1165 | 1167 | 1107 | 1197 | 1217 | 1139 | 957 | 1200 | 684 | 1242 | 659 | 867 | 1231 | 672 | 1167 | 1087 | 1351 | Inefficient optimization (regression) |
|
66 | SS | 480 | 421 | 475 | 476 | 435 | 447 | 475 | 550 | 514 | 508 | 459 | 424 | 554 | 519 | 448 | 495 | 490 | 475 | 484 | 498 | 456 | 565 | 486 | 467 | 489 | 396 | 490 | 471 | 463 | 508 | 541 | Inefficient optimization (regression) |
|
67 | CS | 1845 | 1703 | 1120 | 1149 | 1102 | 1170 | 1757 | 1133 | 1206 | 1803 | 1184 | 2548 | 1659 | 2045 | 2820 | 2621 | 2102 | 2787 | 2747 | 3459 | 1995 | 2483 | 1756 | 1872 | 1755 | 1335 | 2704 | 1818 | 2027 | 2282 | 2391 | Regression in joins on procedures |
|
68 | SS | 1466 | 1157 | 1487 | 1175 | 1148 | 1340 | 1377 | 1403 | 1543 | 1378 | 1183 | 1268 | 1415 | 1403 | 1442 | 1644 | 1586 | 1562 | 1652 | 1526 | 1567 | 1656 | 1579 | 1477 | 1478 | 1436 | 1453 | 1486 | 1587 | 1455 | 1656 | Regression in joins on procedures |
|
69 | CS | 1281 | 1072 | 702 | 686 | 716 | 803 | 1249 | 750 | 797 | 987 | 893 | 1556 | 1045 | 1313 | 1259 | 1303 | 1388 | 1384 | 1342 | 1596 | 1428 | 1327 | 836 | 1336 | 1413 | 826 | 1548 | 1340 | 778 | 1361 | 1451 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
70 | SS | 554 | 473 | 525 | 524 | 544 | 495 | 555 | 556 | 573 | 620 | 604 | 545 | 568 | 555 | 589 | 569 | 586 | 616 | 601 | 538 | 596 | 586 | 529 | 553 | 470 | 549 | 541 | 479 | 536 | 541 | 572 | Altering of a TYPE OF COLUMN parameter affects the original column |
|
71 | CS | 1264 | 1090 | 727 | 722 | 1237 | 723 | 1291 | 697 | 753 | 989 | 732 | 1567 | 879 | 1384 | 1374 | 1350 | 1357 | 1319 | 1426 | 1433 | 1384 | 1363 | 837 | 1401 | 1378 | 715 | 1265 | 1415 | 806 | 1255 | 1264 | DROP VIEW ignores the existing non-column dependencies |
|
72 | SS | 549 | 428 | 499 | 572 | 526 | 490 | 598 | 556 | 612 | 549 | 523 | 551 | 621 | 565 | 498 | 533 | 552 | 605 | 563 | 582 | 524 | 533 | 510 | 520 | 550 | 532 | 550 | 531 | 569 | 526 | 562 | DROP VIEW ignores the existing non-column dependencies |
|
73 | CS | 1295 | 1320 | 699 | 1245 | 1229 | 930 | 1327 | 741 | 785 | 998 | 771 | 1541 | 961 | 1297 | 1368 | 1349 | 1354 | 1388 | 1476 | 1461 | 1296 | 1348 | 815 | 1294 | 1251 | 848 | 736 | 1307 | 1147 | 1296 | 1315 | Alter procedure allows to add the parameter with the same name |
|
74 | SS | 544 | 502 | 516 | 454 | 470 | 534 | 577 | 525 | 569 | 549 | 513 | 589 | 549 | 544 | 536 | 496 | 564 | 567 | 561 | 605 | 593 | 522 | 511 | 546 | 582 | 555 | 544 | 567 | 521 | 539 | 528 | Alter procedure allows to add the parameter with the same name |
|
75 | CS | 963 | 1023 | 595 | 569 | 949 | 607 | 1038 | 674 | 607 | 695 | 624 | 1376 | 732 | 558 | 978 | 1019 | 1215 | 1073 | 1118 | 1184 | 1227 | 1132 | 633 | 1019 | 1251 | 588 | 646 | 984 | 1071 | 742 | 938 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
76 | SS | 439 | 389 | 401 | 367 | 413 | 388 | 491 | 452 | 469 | 411 | 439 | 445 | 472 | 423 | 420 | 413 | 439 | 441 | 452 | 414 | 519 | 433 | 435 | 409 | 448 | 458 | 423 | 460 | 457 | 466 | 448 | BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" |
|
77 | CS | 1120 | 1153 | 673 | 623 | 1213 | 682 | 1217 | 650 | 680 | 718 | 787 | 1227 | 811 | 1112 | 1216 | 1139 | 1179 | 1128 | 1306 | 1294 | 1222 | 1220 | 757 | 1246 | 1156 | 705 | 669 | 894 | 1160 | 1097 | 726 | Inconsistent domain's constraint validation in PSQL |
|
78 | SS | 493 | 481 | 457 | 465 | 481 | 441 | 508 | 490 | 560 | 524 | 473 | 515 | 525 | 561 | 467 | 497 | 483 | 467 | 514 | 513 | 581 | 483 | 526 | 496 | 491 | 451 | 509 | 523 | 489 | 528 | 489 | Inconsistent domain's constraint validation in PSQL |
|
79 | CS | 1280 | 1227 | 1407 | 743 | 1273 | 812 | 1345 | 709 | 855 | 897 | 767 | 1459 | 885 | 1380 | 1272 | 1388 | 1356 | 1388 | 1558 | 1545 | 1430 | 1456 | 883 | 1240 | 1287 | 774 | 1384 | 772 | 1377 | 1288 | 859 | Floating-point negative zero doesn't match positive zero in the index |
|
80 | SS | 543 | 552 | 511 | 528 | 542 | 542 | 581 | 543 | 633 | 562 | 581 | 532 | 578 | 569 | 571 | 501 | 605 | 522 | 524 | 544 | 622 | 516 | 518 | 590 | 598 | 526 | 524 | 548 | 516 | 596 | 529 | Floating-point negative zero doesn't match positive zero in the index |
|
81 | CS | 1011 | 1055 | 1039 | 558 | 991 | 576 | 977 | 598 | 633 | 711 | 586 | 1096 | 660 | 995 | 1155 | 1047 | 1080 | 1116 | 1201 | 1079 | 1110 | 1091 | 694 | 1027 | 1063 | 661 | 964 | 1029 | 929 | 979 | 1158 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
82 | SS | 397 | 396 | 363 | 369 | 355 | 356 | 401 | 395 | 441 | 487 | 376 | 449 | 433 | 417 | 363 | 381 | 408 | 411 | 409 | 404 | 390 | 398 | 467 | 375 | 398 | 344 | 401 | 388 | 383 | 426 | 393 | Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types |
|
83 | CS | 1250 | 1227 | 1370 | 879 | 913 | 767 | 1220 | 775 | 804 | 916 | 779 | 1408 | 946 | 936 | 1367 | 1392 | 1266 | 1437 | 1436 | 1492 | 1532 | 1265 | 834 | 1325 | 1538 | 787 | 1360 | 816 | 1235 | 1408 | 1442 | CHAR(32767) present in XSQLVAR with length 32765 |
|
84 | SS | 605 | 582 | 616 | 528 | 533 | 523 | 586 | 562 | 620 | 632 | 614 | 605 | 606 | 565 | 572 | 556 | 623 | 645 | 584 | 567 | 641 | 705 | 653 | 556 | 618 | 569 | 605 | 623 | 624 | 584 | 691 | CHAR(32767) present in XSQLVAR with length 32765 |
|
85 | CS | 1056 | 1072 | 941 | 611 | 1038 | 607 | 981 | 558 | 613 | 705 | 567 | 1185 | 719 | 1267 | 1127 | 1178 | 1033 | 1096 | 1185 | 1270 | 1156 | 1068 | 681 | 1140 | 1046 | 617 | 1023 | 1103 | 1102 | 1066 | 1147 | Include expected and actual string lenght into error message for sqlcode -802 |
|
86 | SS | 429 | 447 | 387 | 357 | 408 | 407 | 467 | 392 | 432 | 431 | 419 | 434 | 448 | 450 | 448 | 421 | 433 | 493 | 385 | 428 | 435 | 443 | 353 | 377 | 425 | 376 | 405 | 444 | 460 | 476 | 382 | Include expected and actual string lenght into error message for sqlcode -802 |
|
87 | CS | 4113 | 4304 | 4459 | 3026 | 4235 | 2926 | 3426 | 2893 | 2963 | 3094 | 3121 | 4522 | 3059 | 4504 | 3444 | 4543 | 4567 | 4340 | 3991 | 4708 | 4589 | 3531 | 3094 | 4477 | 4447 | 3066 | 3938 | 4573 | 3127 | 4661 | 4563 | TRACE: add statistics of actions that were after transaction finished |
|
88 | SS | 2730 | 2722 | 2709 | 2737 | 2669 | 2699 | 2753 | 2717 | 2816 | 2724 | 2772 | 2695 | 2762 | 2770 | 2677 | 2773 | 2730 | 2796 | 2693 | 2692 | 2785 | 2746 | 2641 | 2764 | 2730 | 2734 | 2766 | 2678 | 2704 | 2704 | 2785 | TRACE: add statistics of actions that were after transaction finished |
|
89 | CS | 1193 | 1170 | 1258 | 703 | 878 | 670 | 1125 | 653 | 1196 | 882 | 1048 | 1354 | 878 | 702 | 1278 | 1221 | 1260 | 1348 | 1415 | 1350 | 1229 | 1165 | 811 | 1190 | 1310 | 747 | 1343 | 1365 | 833 | 1226 | 1274 | Can insert DUPLICATE keys in UNIQUE index |
|
90 | SS | 477 | 374 | 399 | 434 | 421 | 506 | 460 | 482 | 436 | 482 | 509 | 527 | 498 | 529 | 449 | 480 | 445 | 435 | 466 | 478 | 522 | 476 | 433 | 498 | 534 | 429 | 399 | 459 | 489 | 499 | 484 | Can insert DUPLICATE keys in UNIQUE index |
|
91 | CS | 1057 | 997 | 1092 | 596 | 998 | 616 | 1092 | 611 | 605 | 673 | 633 | 1001 | 787 | 1041 | 1045 | 1177 | 1094 | 1120 | 1140 | 1303 | 1091 | 1069 | 723 | 1188 | 1253 | 819 | 1282 | 1102 | 1103 | 696 | 1116 | Server crashes with access violation when inserting row into table with unique index |
|
92 | SS | 429 | 386 | 414 | 494 | 402 | 368 | 464 | 458 | 409 | 435 | 397 | 490 | 471 | 387 | 451 | 405 | 393 | 475 | 392 | 484 | 459 | 454 | 430 | 395 | 425 | 428 | 415 | 397 | 443 | 445 | 446 | Server crashes with access violation when inserting row into table with unique index |
|
93 | CS | 1115 | 1086 | 1224 | 1159 | 965 | 616 | 1059 | 832 | 635 | 707 | 1130 | 1449 | 894 | 974 | 1233 | 1216 | 1375 | 1230 | 1291 | 1323 | 1240 | 1048 | 819 | 1236 | 1100 | 773 | 1259 | 1235 | 1222 | 1052 | 686 | computed index by substring function for long columns |
|
94 | SS | 451 | 452 | 462 | 446 | 471 | 437 | 479 | 436 | 497 | 467 | 423 | 525 | 502 | 521 | 427 | 449 | 478 | 482 | 456 | 445 | 426 | 546 | 442 | 451 | 448 | 447 | 438 | 513 | 425 | 424 | 522 | computed index by substring function for long columns |
|
95 | CS | 1037 | 1007 | 957 | 983 | 1068 | 1035 | 988 | 560 | 1117 | 749 | 610 | 1150 | 713 | 1039 | 1118 | 984 | 1115 | 1058 | 1168 | 1283 | 1047 | 1125 | 694 | 1129 | 1222 | 645 | 647 | 994 | 1061 | 586 | 1120 | Wrong warning message for ambiguous query |
|
96 | SS | 421 | 375 | 438 | 394 | 349 | 376 | 458 | 436 | 420 | 470 | 535 | 592 | 679 | 396 | 432 | 415 | 367 | 365 | 371 | 434 | 447 | 422 | 386 | 455 | 453 | 396 | 381 | 345 | 370 | 438 | 423 | Wrong warning message for ambiguous query |
|
97 | CS | 1025 | 1033 | 1027 | 1051 | 1067 | 926 | 1014 | 594 | 782 | 708 | 645 | 1383 | 715 | 1029 | 1105 | 952 | 1165 | 1036 | 1219 | 1069 | 1120 | 1116 | 664 | 1024 | 1058 | 626 | 595 | 1012 | 1012 | 787 | 1047 | Wrong warning message for ambiguous query |
|
98 | SS | 401 | 370 | 353 | 381 | 378 | 421 | 409 | 430 | 435 | 441 | 350 | 418 | 454 | 456 | 425 | 396 | 360 | 350 | 398 | 457 | 390 | 401 | 390 | 340 | 400 | 408 | 426 | 408 | 402 | 441 | 395 | Wrong warning message for ambiguous query |
|
99 | CS | 1056 | 1049 | 1085 | 1061 | 918 | 1037 | 1009 | 669 | 718 | 700 | 564 | 1188 | 785 | 772 | 1016 | 1273 | 1127 | 1156 | 1187 | 1172 | 1126 | 1162 | 723 | 1059 | 1053 | 572 | 635 | 1091 | 1104 | 1076 | 1119 | Missing constraint name in foreign key error message in FB 2.1.4 |
|
100 | SS | 429 | 396 | 405 | 413 | 402 | 398 | 457 | 400 | 524 | 429 | 490 | 425 | 438 | 509 | 417 | 450 | 450 | 468 | 410 | 453 | 480 | 441 | 407 | 410 | 459 | 407 | 449 | 429 | 419 | 424 | 459 | Missing constraint name in foreign key error message in FB 2.1.4 |