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 | P | P | P | 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 |
|
103 | 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 | 17657 | 18033 | 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 | 597 | 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 | 394 | 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 | 820 | 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 | 549 | 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 | 637 | 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 | 407 | 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 | 687 | 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 | 442 | 454 | 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 | 603 | 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 | 397 | 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 | 592 | 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 | 392 | 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 | 599 | 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 | 622 | 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 | 587 | 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 | 390 | 556 | 1373 | 566 | 558 | 563 | 548 | 563 | 611 | 559 | 563 | 555 | 577 | 560 | 545 | 503 | 518 | 512 | 517 | 531 | 518 | 501 | 501 | 518 | 505 | 524 | 512 | 521 | 532 | 516 | DROP VIEW drops output parameters of used stored procedures |
|
20 | CS | 805 | 601 | 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 | 390 | 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 | 629 | 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 | 397 | 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 | 675 | 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 | 409 | 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 | 798 | 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 | 599 | 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 | 599 | 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 | 628 | 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 | 412 | 420 | 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 | 925 | 933 | 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 | 644 | 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 | 699 | 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 | 488 | 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 | 840 | 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 | 571 | 581 | 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 | 592 | 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 | 585 | 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 | 398 | 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 | 624 | 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 | 414 | 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 | 596 | 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 | 393 | 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 | 622 | 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 | 397 | 393 | 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 | 794 | 791 | 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 | 558 | 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 | 586 | 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 | 384 | 376 | 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 | 589 | 592 | 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 | 396 | 395 | 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 | 619 | 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 | 390 | 389 | 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 | 1098 | 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 | 748 | 757 | 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 | 787 | 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 | 523 | 519 | 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 | 602 | 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 | 389 | 394 | 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 | 788 | 829 | 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 | 562 | 610 | 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 | 602 | 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 | 409 | 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 | 650 | 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 | 407 | 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 | 1174 | 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 | 816 | 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 | 591 | 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 | 390 | 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 | 614 | 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 | 391 | 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 | 785 | 797 | 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 | 540 | 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 | 595 | 594 | 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 | 405 | 390 | 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 | 610 | 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 | 417 | 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 | 836 | 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 | 549 | 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 | 702 | 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 | 395 | 394 | 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 | 594 | 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 | 590 | 599 | 593 | 630 | 605 | 596 | 597 | 585 | 598 | 591 | 594 | 590 | 591 | 598 | 592 | 545 | 551 | 541 | 544 | 549 | 575 | 551 | 567 | 551 | 549 | 575 | 539 | 569 | 541 | 580 | Include expected and actual string lenght into error message for sqlcode -802 |
|
87 | SS | 370 | 394 | 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 | 2928 | 2925 | 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 | 2701 | 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 | 646 | 642 | 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 | 360 | 427 | 438 | 436 | 438 | 440 | 437 | 441 | 440 | 440 | 446 | 424 | 442 | 570 | 380 | 392 | 397 | 391 | 390 | 388 | 390 | 375 | 378 | 392 | 391 | 393 | 392 | 387 | 378 | 388 | Can insert DUPLICATE keys in UNIQUE index |
|
92 | CS | 581 | 596 | 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 | 389 | 386 | 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 | 614 | 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 | 404 | 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 | 584 | 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 | 390 | 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 | 580 | 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 | 377 | 388 | 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 | 595 | 606 | 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 | 391 | 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 | 1558 | 1618 | 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 |
|
103 | SS | 1153 | 1212 | 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 |