NN | Test name | mode |
6.0.0.892
|
6.0.0.889
|
6.0.0.884
|
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
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 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 | Index bug |
|
2 | 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 | Index bug |
|
3 | 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 | Blob comparison with constant |
|
4 | 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 | Blob comparison with constant |
|
5 | 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 | ORDER BY on a VIEW turns values in fields into NULL |
|
6 | 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 | ORDER BY on a VIEW turns values in fields into NULL |
|
7 | 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 | Incorrect handling of null within view - returns 0 |
|
8 | 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 | Incorrect handling of null within view - returns 0 |
|
9 | 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 | New value of column is accessable before update |
|
10 | 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 | New value of column is accessable before update |
|
11 | 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 | Incorrect results when left join on subquery with constant column |
|
12 | 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 | Incorrect results when left join on subquery with constant column |
|
13 | 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 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
14 | 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 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
15 | 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 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
16 | 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 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
17 | 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 | Estonian collation in UTF8 charset |
|
18 | 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 | Estonian collation in UTF8 charset |
|
19 | 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 | LIKE doesn't work for computed values (at least in a view) |
|
20 | 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 | LIKE doesn't work for computed values (at least in a view) |
|
21 | 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 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
22 | 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 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
23 | 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 | Long SQL statements break TCP/IP connection |
|
24 | 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 | Long SQL statements break TCP/IP connection |
|
25 | 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 | LIST() function seems not work if used twice or more in a query |
|
26 | 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 | LIST() function seems not work if used twice or more in a query |
|
27 | 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 | Incorrect column values with outer joins and views |
|
28 | 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 | Incorrect column values with outer joins and views |
|
29 | 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 | Incorrect column values with outer joins and derived tables |
|
30 | 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 | Incorrect column values with outer joins and derived tables |
|
31 | 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 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
32 | 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 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
33 | 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 | Joins with NULL RDB$DB_KEY crash the server |
|
34 | 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 | Joins with NULL RDB$DB_KEY crash the server |
|
35 | 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 | French insensitive collation FR_FR_CI_AI |
|
36 | 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 | French insensitive collation FR_FR_CI_AI |
|
37 | 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 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
38 | 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 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
39 | 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 | Collation not propagated between record formats |
|
40 | 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 | Collation not propagated between record formats |
|
41 | 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 | DATEADD wrong work with NULL arguments |
|
42 | 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 | DATEADD wrong work with NULL arguments |
|
43 | 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 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
44 | 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 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
45 | 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 | POSITION(string_exp1, string_exp2 [, start]) |
|
46 | 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 | POSITION(string_exp1, string_exp2 [, start]) |
|
47 | 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 | JOIN on first record of ordered derived table returns wrong record |
|
48 | 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 | JOIN on first record of ordered derived table returns wrong record |
|
49 | 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 | ABS() rounds NUMERIC values |
|
50 | 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 | ABS() rounds NUMERIC values |
|
51 | 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 | MERGE not correctly worked with parameters in MATCHING clause |
|
52 | 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 | MERGE not correctly worked with parameters in MATCHING clause |
|
53 | 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 | AV when recursive query used MERGE JOIN in execution plan |
|
54 | 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 | AV when recursive query used MERGE JOIN in execution plan |
|
55 | 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 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
56 | 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 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
57 | 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 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
58 | 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 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
59 | 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 | Wrong variable initialization in recursive procedures |
|
60 | 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 | Wrong variable initialization in recursive procedures |
|
61 | 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 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
62 | 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 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
63 | 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 | Consistency check when subquery is ordered by aggregate function from other context |
|
64 | 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 | Consistency check when subquery is ordered by aggregate function from other context |
|
65 | 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 | DEFAULT values are unnecessary evaluated |
|
66 | 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 | DEFAULT values are unnecessary evaluated |
|
67 | 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 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
68 | 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 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
69 | 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 | Null in the first record in a condition on rdb$db_key |
|
70 | 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 | Null in the first record in a condition on rdb$db_key |
|
71 | 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 | update or insert with gen_id() with wrong generator value |
|
72 | 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 | update or insert with gen_id() with wrong generator value |
|
73 | 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 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
74 | 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 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
75 | 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 | GROUP by and RDB$DB_KEY problems |
|
76 | 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 | GROUP by and RDB$DB_KEY problems |
|
77 | 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 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
78 | 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 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
79 | 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 | Grouping by function doesn't work properly |
|
80 | 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 | Grouping by function doesn't work properly |
|
81 | 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 | Firebird float support does not conform to Interbase spec |
|
82 | 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 | Firebird float support does not conform to Interbase spec |
|
83 | 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 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
84 | 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 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
85 | 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 | Outer ORDER BY clause has no effect |
|
86 | 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 | Outer ORDER BY clause has no effect |
|
87 | 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 | Wrong field position after ALTER POSITION |
|
88 | 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 | Wrong field position after ALTER POSITION |
|
89 | 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 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
90 | 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 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
91 | 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 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
92 | 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 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
93 | 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 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
94 | 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 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
95 | 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 | Lateral derived tables |
|
96 | 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 | Lateral derived tables |
|
97 | 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 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
98 | 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 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
99 | 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 | Window Function: frame (rows / range) clause |
|
100 | 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 | Window Function: frame (rows / range) clause |
|
101 | 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 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
102 | 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 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
103 | 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 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
104 | 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 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
105 | 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 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
106 | 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 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
107 | 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 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
108 | 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 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
109 | 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 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
110 | 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 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
111 | 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 | Parametrized queries using RDB$DB_KEY do not work |
|
112 | 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 | Parametrized queries using RDB$DB_KEY do not work |
|
113 | 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 | Wrong result of join when joined fields are created via row_number() function |
|
114 | 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 | Wrong result of join when joined fields are created via row_number() function |
|
115 | 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 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
116 | 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 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
117 | 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 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
118 | 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 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
119 | 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 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
120 | 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 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
121 | 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 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
122 | 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 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
123 | 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 | SEC$ tables and tag/attributes |
|
124 | 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 | SEC$ tables and tag/attributes |
|
125 | 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 | Window Function: named window |
|
126 | 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 | Window Function: named window |
|
127 | 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 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
128 | 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 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
129 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unique constraint not working in encrypted database on first command |
|
130 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unique constraint not working in encrypted database on first command |
|
131 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow unused Common Table Expressions |
|
132 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow unused Common Table Expressions |
|
133 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Consider equivalence classes for index navigation |
|
134 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Consider equivalence classes for index navigation |
|
135 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Invalid parameters of gds transaction in ISQL |
|
136 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Invalid parameters of gds transaction in ISQL |
|
137 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals |
|
138 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals |
|
139 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | User can grant usage privilege by himself |
|
140 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | User can grant usage privilege by himself |
|
141 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | No error if the GRANT target object does not exist |
|
142 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | No error if the GRANT target object does not exist |
|
143 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) |
|
144 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) |
|
145 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete |
|
146 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete |
|
147 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ignor of reference privilege |
|
148 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ignor of reference privilege |
|
149 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong handling of failures of TRANSACTION START trigger |
|
150 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong handling of failures of TRANSACTION START trigger |
|
151 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | There is no check of existance generator and exception when privileges are granted |
|
152 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | There is no check of existance generator and exception when privileges are granted |
|
153 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | GRANT OPTION is not checked for new object |
|
154 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | GRANT OPTION is not checked for new object |
|
155 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx |
|
156 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx |
|
157 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation" |
|
158 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation" |
|
159 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistencies with PSQL FUNCTION vs UDF |
|
160 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Inconsistencies with PSQL FUNCTION vs UDF |
|
161 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
162 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
163 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Built-in cryptographic functions |
|
164 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Built-in cryptographic functions |
|
165 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | External engine trigger crashing server if table have computed field |
|
166 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | External engine trigger crashing server if table have computed field |
|
167 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Segfault when using expression index with complex expression |
|
168 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Segfault when using expression index with complex expression |
|
169 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
170 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
171 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ISQL issues with increased identifier length |
|
172 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ISQL issues with increased identifier length |
|
173 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Builtin functions converting binary string to hexadecimal representation and vice versa |
|
174 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Builtin functions converting binary string to hexadecimal representation and vice versa |
|
175 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Random crash 64bit fb_inet_server. Possible collation issue |
|
176 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Random crash 64bit fb_inet_server. Possible collation issue |
|
177 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Permissions for create or alter statements are not checked |
|
178 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Permissions for create or alter statements are not checked |
|
179 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | SUBSTRING of non-text/-blob is described to return NONE character set in DSQL |
|
180 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | SUBSTRING of non-text/-blob is described to return NONE character set in DSQL |
|
181 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problems with long object names (> 255 bytes) |
|
182 | SS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problems with long object names (> 255 bytes) |
|
183 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | "No current record for fetch operation" with queries with aggregated subselect |
|
184 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field |
|
185 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND |
|
186 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML |
|
187 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Efficient table scans for DBKEY-based range conditions |
|
188 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | SQL-level replication management |
|
189 | 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 | Incorrect query result when using named window |
|
190 | 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 | Incorrect query result when using named window |
|
191 | 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 | Unexpected results after creating partial index |
|
192 | 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 | Unexpected results after creating partial index |
|
193 | 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 | Simple derived table |
|
194 | 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 | Simple derived table |
|
195 | 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 | Unnamed (no relation alias) derived table |
|
196 | 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 | Unnamed (no relation alias) derived table |
|
197 | 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 | Explicit column names for derived table |
|
198 | 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 | Explicit column names for derived table |
|
199 | 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 | Outer reference to upper scope-level is allowed |
|
200 | 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 | Outer reference to upper scope-level is allowed |
|
201 | 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 | Outer reference to upper scope-level is allowed |
|
202 | 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 | Outer reference to upper scope-level is allowed |
|
203 | 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 | Outer reference to upper scope-level is allowed |
|
204 | 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 | Outer reference to upper scope-level is allowed |
|
205 | 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 | FIRST / SKIP inside derived table |
|
206 | 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 | FIRST / SKIP inside derived table |
|
207 | 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 | UNION inside derived table |
|
208 | 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 | UNION inside derived table |
|
209 | 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 | Simple derived table with aggregate inside |
|
210 | 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 | Simple derived table with aggregate inside |
|
211 | 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 | Aggregate inside derived table |
|
212 | 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 | Aggregate inside derived table |
|
213 | 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 | Aggregate inside derived table |
|
214 | 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 | Aggregate inside derived table |
|
215 | 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 | Sub-select inside derived table |
|
216 | 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 | Sub-select inside derived table |
|
217 | 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 | Sub-select inside derived table |
|
218 | 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 | Sub-select inside derived table |
|
219 | 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 | Implicit derived table by IN predicate |
|
220 | 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 | Implicit derived table by IN predicate |
|
221 | 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 | Derived table outer reference (triggers) |
|
222 | 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 | Derived table outer reference (triggers) |
|
223 | 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 | Non-Recursive CTEs |
|
224 | 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 | Non-Recursive CTEs |
|
225 | 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 | Recursive CTEs |
|
226 | 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 | Recursive CTEs |
|
227 | 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 | MERGE statement |
|
228 | 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 | MERGE statement |
|
229 | 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 | Computed fields |
|
230 | 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 | Computed fields |
|
231 | 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 | gtcs-proc-isql-11 |
|
232 | 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 | gtcs-proc-isql-11 |
|
233 | 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 | gtcs-proc-isql-15 |
|
234 | 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 | gtcs-proc-isql-15 |
|
235 | 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 | gtcs-proc-isql-16 |
|
236 | 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 | gtcs-proc-isql-16 |
|
237 | 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 | Test for select from SP that deletes record after its output |
|
238 | 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 | Test for select from SP that deletes record after its output |
|
239 | 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 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
240 | 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 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
241 | 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 | COUNT |
|
242 | 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 | COUNT |
|
243 | 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 | EXTRACT(WEEK FROM DATE) |
|
244 | 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 | EXTRACT(WEEK FROM DATE) |
|
245 | 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 | TRUNC( <number> [, <number> ] ) |
|
246 | 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 | TRUNC( <number> [, <number> ] ) |
|
247 | 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 | POSITION( <string> IN <string> ) |
|
248 | 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 | POSITION( <string> IN <string> ) |
|
249 | 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 | Test for TRUNC function |
|
250 | 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 | Test for TRUNC function |
|
251 | 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 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
252 | 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 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
253 | 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 | External Connections Pool, functionality test 01 |
|
254 | 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 | External Connections Pool, functionality test 01 |
|
255 | 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 | Common SQL. Check correctness of the results |
|
256 | 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 | Common SQL. Check correctness of the results |
|
257 | 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 | Common SQL. Check correctness of the results |
|
258 | 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 | Common SQL. Check correctness of the results |
|
259 | 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 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
260 | 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 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
261 | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
262 | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
263 | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
264 | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
265 | 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 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
266 | 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 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
267 | 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 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
268 | 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 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
269 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
270 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
271 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
272 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
273 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
274 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
275 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
276 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
277 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
278 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
279 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
280 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
281 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
282 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
283 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
284 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
285 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
286 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
287 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
288 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
289 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
290 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
291 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
292 | 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 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
293 | 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 | CREATE VIEW |
|
294 | 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 | CREATE VIEW |
NN | Test name | mode | median_ms |
6.0.0.892
|
6.0.0.889
|
6.0.0.884
|
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
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1664 | 1757 | 2154 | 2089 | 1853 | 1823 | 946 | 1618 | 1699 | 1542 | 1030 | 1318 | 1030 | 1028 | 1144 | 1020 | 998 | 1633 | 1875 | 1867 | 1887 | 1799 | 1824 | 1085 | 1752 | 1169 | 1670 | 1371 | 1711 | 1659 | 1828 | Index bug |
|
2 | SS | 766 | 720 | 1048 | 936 | 676 | 724 | 811 | 783 | 851 | 699 | 809 | 748 | 861 | 762 | 725 | 860 | 861 | 724 | 770 | 800 | 751 | 848 | 747 | 754 | 654 | 798 | 714 | 806 | 637 | 683 | 781 | Index bug |
|
3 | CS | 1273 | 1350 | 911 | 1237 | 902 | 811 | 1198 | 745 | 765 | 763 | 1303 | 787 | 779 | 1316 | 1298 | 752 | 746 | 1243 | 1293 | 1456 | 1442 | 1444 | 1529 | 1345 | 1253 | 908 | 1456 | 1344 | 1382 | 1475 | 1481 | Blob comparison with constant |
|
4 | SS | 529 | 601 | 559 | 503 | 521 | 537 | 531 | 472 | 544 | 496 | 598 | 529 | 630 | 472 | 540 | 503 | 514 | 498 | 468 | 521 | 530 | 601 | 513 | 505 | 540 | 530 | 552 | 579 | 518 | 560 | 502 | Blob comparison with constant |
|
5 | CS | 1056 | 967 | 663 | 609 | 795 | 608 | 1055 | 689 | 643 | 747 | 1158 | 636 | 571 | 1123 | 1159 | 597 | 1100 | 1178 | 1094 | 1171 | 1243 | 1204 | 1118 | 1142 | 1104 | 725 | 1057 | 1075 | 676 | 623 | 1180 | ORDER BY on a VIEW turns values in fields into NULL |
|
6 | SS | 448 | 397 | 453 | 484 | 469 | 425 | 485 | 413 | 464 | 432 | 408 | 478 | 475 | 410 | 443 | 386 | 472 | 472 | 457 | 459 | 403 | 490 | 499 | 409 | 412 | 429 | 496 | 436 | 474 | 372 | 442 | ORDER BY on a VIEW turns values in fields into NULL |
|
7 | CS | 1304 | 785 | 1341 | 812 | 1332 | 707 | 1289 | 1395 | 690 | 1308 | 726 | 708 | 839 | 779 | 760 | 1355 | 1352 | 1321 | 1388 | 1396 | 1428 | 1433 | 1460 | 1277 | 1301 | 843 | 1332 | 1325 | 794 | 755 | 1357 | Incorrect handling of null within view - returns 0 |
|
8 | SS | 535 | 567 | 547 | 555 | 500 | 482 | 512 | 513 | 568 | 551 | 509 | 534 | 536 | 450 | 601 | 515 | 563 | 486 | 515 | 529 | 494 | 537 | 585 | 553 | 500 | 566 | 484 | 562 | 562 | 544 | 522 | Incorrect handling of null within view - returns 0 |
|
9 | CS | 1061 | 747 | 1340 | 829 | 777 | 768 | 1207 | 1269 | 742 | 1366 | 765 | 757 | 741 | 841 | 779 | 776 | 1343 | 1333 | 1293 | 1374 | 1362 | 1334 | 1391 | 1445 | 1483 | 894 | 1329 | 1224 | 916 | 851 | 866 | New value of column is accessable before update |
|
10 | SS | 544 | 499 | 545 | 536 | 515 | 528 | 672 | 544 | 560 | 566 | 562 | 591 | 610 | 506 | 565 | 537 | 595 | 576 | 490 | 545 | 560 | 572 | 525 | 548 | 508 | 542 | 540 | 573 | 531 | 523 | 505 | New value of column is accessable before update |
|
11 | CS | 1270 | 756 | 1322 | 1353 | 1427 | 693 | 706 | 1305 | 729 | 1396 | 736 | 736 | 1264 | 783 | 754 | 1231 | 1277 | 1301 | 1154 | 1410 | 1341 | 1530 | 1308 | 1345 | 1532 | 867 | 1349 | 1377 | 1199 | 780 | 782 | Incorrect results when left join on subquery with constant column |
|
12 | SS | 542 | 542 | 545 | 526 | 569 | 482 | 499 | 511 | 542 | 520 | 566 | 553 | 583 | 486 | 573 | 533 | 548 | 539 | 549 | 526 | 542 | 542 | 548 | 498 | 521 | 525 | 558 | 547 | 550 | 525 | 553 | Incorrect results when left join on subquery with constant column |
|
13 | CS | 1227 | 723 | 1332 | 832 | 1285 | 731 | 812 | 1192 | 765 | 1189 | 736 | 811 | 1265 | 1044 | 1199 | 1255 | 1259 | 1297 | 1269 | 1285 | 1350 | 1382 | 1408 | 1383 | 1353 | 848 | 1361 | 1287 | 1173 | 851 | 903 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
14 | SS | 541 | 493 | 581 | 500 | 546 | 455 | 477 | 547 | 544 | 550 | 532 | 548 | 582 | 556 | 539 | 515 | 550 | 487 | 509 | 523 | 525 | 531 | 550 | 539 | 548 | 538 | 575 | 561 | 568 | 534 | 554 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
15 | CS | 1240 | 705 | 1213 | 850 | 1290 | 753 | 727 | 1330 | 989 | 1303 | 754 | 792 | 1301 | 776 | 744 | 1425 | 1302 | 1267 | 1211 | 1225 | 1315 | 1451 | 1897 | 1255 | 1280 | 833 | 1389 | 1408 | 1297 | 879 | 767 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
16 | SS | 529 | 596 | 529 | 483 | 513 | 517 | 571 | 527 | 592 | 575 | 511 | 544 | 558 | 480 | 530 | 522 | 528 | 513 | 536 | 503 | 555 | 565 | 562 | 550 | 536 | 542 | 544 | 516 | 524 | 510 | 508 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
17 | CS | 1179 | 717 | 1997 | 1490 | 1389 | 703 | 698 | 1211 | 1249 | 1227 | 789 | 724 | 1009 | 934 | 659 | 1255 | 881 | 1376 | 1130 | 1318 | 1371 | 1269 | 2040 | 1148 | 1272 | 907 | 1366 | 1253 | 1098 | 958 | 764 | Estonian collation in UTF8 charset |
|
18 | SS | 539 | 536 | 1035 | 877 | 545 | 496 | 492 | 495 | 564 | 534 | 540 | 521 | 555 | 553 | 542 | 519 | 476 | 538 | 519 | 539 | 518 | 638 | 546 | 579 | 552 | 576 | 523 | 553 | 558 | 491 | 446 | Estonian collation in UTF8 charset |
|
19 | CS | 1219 | 744 | 1315 | 777 | 1350 | 765 | 813 | 1199 | 1098 | 1189 | 713 | 915 | 1215 | 1005 | 744 | 1230 | 1273 | 1307 | 1356 | 1223 | 1391 | 1321 | 1480 | 1420 | 1427 | 851 | 1392 | 1283 | 1323 | 915 | 778 | LIKE doesn't work for computed values (at least in a view) |
|
20 | SS | 540 | 581 | 574 | 501 | 516 | 520 | 498 | 518 | 557 | 608 | 542 | 525 | 582 | 516 | 552 | 549 | 514 | 544 | 537 | 529 | 532 | 528 | 599 | 492 | 522 | 538 | 570 | 577 | 562 | 549 | 552 | LIKE doesn't work for computed values (at least in a view) |
|
21 | CS | 1089 | 872 | 1254 | 635 | 1047 | 1099 | 1054 | 1013 | 609 | 1000 | 564 | 1172 | 1093 | 711 | 1208 | 1102 | 1129 | 1185 | 1094 | 1132 | 1086 | 995 | 1178 | 1413 | 1133 | 788 | 1201 | 1199 | 664 | 952 | 1023 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
22 | SS | 436 | 409 | 443 | 404 | 408 | 457 | 474 | 436 | 436 | 448 | 395 | 455 | 436 | 425 | 456 | 433 | 476 | 457 | 446 | 382 | 401 | 470 | 445 | 433 | 385 | 473 | 421 | 405 | 413 | 445 | 457 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
23 | CS | 1155 | 1206 | 1046 | 716 | 1114 | 1167 | 1127 | 973 | 618 | 1189 | 1169 | 1232 | 1197 | 743 | 1199 | 1132 | 757 | 1130 | 1189 | 1252 | 1151 | 1249 | 1193 | 1164 | 1192 | 757 | 1160 | 1135 | 671 | 1133 | 1252 | Long SQL statements break TCP/IP connection |
|
24 | SS | 486 | 455 | 504 | 509 | 457 | 509 | 391 | 466 | 517 | 428 | 505 | 529 | 511 | 452 | 500 | 450 | 455 | 494 | 552 | 488 | 455 | 433 | 508 | 520 | 474 | 480 | 472 | 462 | 485 | 492 | 518 | Long SQL statements break TCP/IP connection |
|
25 | CS | 1278 | 1345 | 723 | 783 | 1052 | 1291 | 1236 | 735 | 813 | 1357 | 1465 | 1479 | 1241 | 1024 | 744 | 1387 | 722 | 1334 | 1282 | 1516 | 1323 | 1376 | 1410 | 1321 | 1241 | 872 | 1338 | 1274 | 954 | 1292 | 1265 | LIST() function seems not work if used twice or more in a query |
|
26 | SS | 537 | 498 | 537 | 518 | 509 | 451 | 479 | 540 | 508 | 531 | 510 | 548 | 593 | 569 | 517 | 496 | 560 | 501 | 556 | 553 | 503 | 550 | 553 | 492 | 556 | 542 | 551 | 571 | 556 | 537 | 524 | LIST() function seems not work if used twice or more in a query |
|
27 | CS | 1308 | 1208 | 809 | 812 | 856 | 1231 | 1283 | 733 | 1323 | 777 | 1420 | 1235 | 1334 | 1420 | 785 | 1223 | 729 | 1400 | 1351 | 1375 | 1388 | 1468 | 1352 | 1444 | 1407 | 940 | 1293 | 1343 | 784 | 1350 | 1333 | Incorrect column values with outer joins and views |
|
28 | SS | 544 | 537 | 606 | 476 | 590 | 477 | 542 | 523 | 580 | 528 | 560 | 553 | 572 | 530 | 540 | 578 | 603 | 534 | 545 | 553 | 494 | 575 | 544 | 574 | 501 | 497 | 539 | 559 | 587 | 542 | 566 | Incorrect column values with outer joins and views |
|
29 | CS | 1263 | 1109 | 771 | 840 | 805 | 1287 | 1287 | 936 | 1214 | 764 | 1401 | 1262 | 1240 | 1295 | 776 | 1264 | 763 | 1413 | 1350 | 1451 | 1281 | 1420 | 1429 | 1381 | 1321 | 951 | 1195 | 1316 | 747 | 1477 | 1204 | Incorrect column values with outer joins and derived tables |
|
30 | SS | 520 | 508 | 533 | 510 | 601 | 512 | 587 | 476 | 551 | 559 | 517 | 569 | 520 | 501 | 484 | 529 | 525 | 523 | 530 | 514 | 594 | 500 | 572 | 520 | 514 | 485 | 514 | 534 | 547 | 496 | 510 | Incorrect column values with outer joins and derived tables |
|
31 | CS | 1239 | 1217 | 1237 | 756 | 893 | 1147 | 1241 | 1318 | 731 | 691 | 1227 | 1331 | 1370 | 754 | 1497 | 787 | 741 | 1231 | 1361 | 1396 | 1412 | 1473 | 1350 | 1456 | 1312 | 854 | 1308 | 1254 | 825 | 750 | 1307 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
32 | SS | 540 | 478 | 514 | 605 | 466 | 566 | 527 | 551 | 599 | 580 | 484 | 540 | 576 | 492 | 621 | 542 | 579 | 498 | 546 | 513 | 481 | 509 | 578 | 560 | 608 | 516 | 510 | 547 | 523 | 540 | 539 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
33 | CS | 1237 | 828 | 792 | 809 | 872 | 1304 | 1240 | 758 | 1223 | 1291 | 900 | 940 | 1234 | 1487 | 1367 | 783 | 798 | 1257 | 1506 | 1414 | 1372 | 1449 | 1396 | 1274 | 1249 | 943 | 1311 | 1344 | 995 | 776 | 905 | Joins with NULL RDB$DB_KEY crash the server |
|
34 | SS | 541 | 539 | 539 | 582 | 553 | 469 | 473 | 530 | 541 | 612 | 584 | 603 | 554 | 524 | 542 | 552 | 565 | 529 | 552 | 604 | 558 | 537 | 503 | 562 | 559 | 503 | 502 | 536 | 573 | 523 | 468 | Joins with NULL RDB$DB_KEY crash the server |
|
35 | CS | 1041 | 696 | 1046 | 641 | 635 | 1038 | 990 | 690 | 1092 | 1146 | 669 | 601 | 1133 | 1351 | 1105 | 678 | 616 | 1152 | 1041 | 1343 | 1088 | 1191 | 1274 | 1251 | 1155 | 789 | 1042 | 1043 | 679 | 610 | 596 | French insensitive collation FR_FR_CI_AI |
|
36 | SS | 450 | 384 | 490 | 399 | 394 | 468 | 448 | 429 | 445 | 510 | 460 | 511 | 474 | 442 | 465 | 438 | 437 | 482 | 477 | 478 | 386 | 455 | 407 | 427 | 482 | 451 | 489 | 449 | 414 | 470 | 430 | French insensitive collation FR_FR_CI_AI |
|
37 | CS | 1192 | 770 | 805 | 768 | 770 | 1310 | 1298 | 687 | 1322 | 1017 | 780 | 751 | 1183 | 1314 | 1202 | 778 | 757 | 1288 | 1359 | 1724 | 1486 | 1473 | 1346 | 1397 | 1384 | 980 | 1296 | 1250 | 868 | 863 | 816 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
38 | SS | 550 | 607 | 604 | 596 | 520 | 491 | 515 | 491 | 496 | 518 | 518 | 568 | 583 | 511 | 567 | 520 | 548 | 561 | 527 | 508 | 592 | 552 | 498 | 563 | 559 | 525 | 566 | 527 | 597 | 568 | 566 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
39 | CS | 1233 | 808 | 746 | 773 | 793 | 1245 | 1222 | 792 | 1344 | 1280 | 803 | 842 | 718 | 1375 | 1354 | 759 | 708 | 1336 | 1325 | 1392 | 1198 | 1598 | 1425 | 1377 | 1582 | 838 | 1461 | 1304 | 1361 | 801 | 828 | Collation not propagated between record formats |
|
40 | SS | 552 | 499 | 486 | 574 | 527 | 461 | 553 | 485 | 509 | 600 | 512 | 608 | 553 | 553 | 609 | 496 | 530 | 508 | 553 | 552 | 577 | 560 | 575 | 595 | 566 | 530 | 524 | 522 | 562 | 498 | 580 | Collation not propagated between record formats |
|
41 | CS | 1008 | 717 | 1045 | 584 | 587 | 1037 | 1039 | 981 | 889 | 896 | 566 | 600 | 749 | 1070 | 1040 | 572 | 567 | 1105 | 1136 | 1149 | 1116 | 1114 | 1076 | 1076 | 1057 | 667 | 995 | 1117 | 1021 | 671 | 639 | DATEADD wrong work with NULL arguments |
|
42 | SS | 406 | 383 | 412 | 348 | 411 | 382 | 406 | 436 | 456 | 411 | 368 | 451 | 375 | 382 | 445 | 395 | 412 | 430 | 378 | 404 | 407 | 438 | 440 | 414 | 355 | 383 | 417 | 382 | 354 | 398 | 413 | DATEADD wrong work with NULL arguments |
|
43 | CS | 1041 | 604 | 1168 | 543 | 619 | 938 | 980 | 977 | 1043 | 1116 | 592 | 606 | 695 | 1133 | 1111 | 574 | 593 | 1097 | 1132 | 1170 | 1134 | 1186 | 1099 | 1133 | 1050 | 697 | 1102 | 1039 | 1092 | 611 | 676 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
44 | SS | 398 | 384 | 443 | 363 | 407 | 389 | 435 | 413 | 410 | 399 | 362 | 426 | 407 | 438 | 438 | 462 | 436 | 394 | 376 | 380 | 392 | 404 | 426 | 398 | 361 | 393 | 433 | 330 | 383 | 383 | 371 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
45 | CS | 1030 | 606 | 1063 | 601 | 654 | 543 | 1055 | 1000 | 1042 | 1038 | 575 | 648 | 588 | 1021 | 1035 | 567 | 652 | 1108 | 1035 | 1108 | 1134 | 1176 | 1141 | 1065 | 1063 | 691 | 1025 | 1240 | 1142 | 594 | 607 | POSITION(string_exp1, string_exp2 [, start]) |
|
46 | SS | 397 | 504 | 382 | 390 | 376 | 331 | 426 | 402 | 392 | 370 | 398 | 403 | 439 | 400 | 372 | 382 | 410 | 378 | 392 | 369 | 388 | 407 | 428 | 417 | 389 | 341 | 396 | 400 | 427 | 401 | 417 | POSITION(string_exp1, string_exp2 [, start]) |
|
47 | CS | 1251 | 719 | 1463 | 739 | 764 | 708 | 1345 | 671 | 1246 | 1291 | 777 | 845 | 873 | 1326 | 1274 | 748 | 700 | 843 | 1283 | 1477 | 1319 | 1392 | 1349 | 1436 | 1326 | 884 | 1256 | 1291 | 1357 | 812 | 959 | JOIN on first record of ordered derived table returns wrong record |
|
48 | SS | 547 | 537 | 529 | 544 | 568 | 503 | 513 | 496 | 507 | 552 | 515 | 567 | 595 | 493 | 577 | 504 | 553 | 542 | 521 | 538 | 574 | 600 | 576 | 642 | 557 | 564 | 561 | 538 | 543 | 551 | 555 | JOIN on first record of ordered derived table returns wrong record |
|
49 | CS | 689 | 623 | 1011 | 685 | 1091 | 1020 | 652 | 1129 | 561 | 635 | 1053 | 617 | 1092 | 570 | 582 | 1068 | 568 | 598 | 627 | 679 | 1014 | 600 | 1138 | 878 | 1063 | 670 | 553 | 1231 | 693 | 1111 | 1094 | ABS() rounds NUMERIC values |
|
50 | SS | 400 | 378 | 468 | 387 | 421 | 385 | 352 | 383 | 382 | 405 | 439 | 384 | 417 | 384 | 410 | 385 | 455 | 461 | 377 | 376 | 494 | 404 | 433 | 401 | 388 | 392 | 404 | 399 | 427 | 392 | 434 | ABS() rounds NUMERIC values |
|
51 | CS | 1020 | 1116 | 1083 | 823 | 1104 | 1073 | 569 | 991 | 580 | 577 | 1049 | 757 | 1059 | 564 | 672 | 1053 | 561 | 702 | 614 | 1129 | 1079 | 654 | 699 | 641 | 1064 | 729 | 1111 | 1367 | 1168 | 1077 | 1056 | MERGE not correctly worked with parameters in MATCHING clause |
|
52 | SS | 430 | 422 | 446 | 411 | 493 | 394 | 414 | 393 | 359 | 443 | 449 | 472 | 525 | 415 | 409 | 551 | 432 | 429 | 462 | 410 | 431 | 485 | 425 | 456 | 435 | 353 | 461 | 404 | 408 | 455 | 419 | MERGE not correctly worked with parameters in MATCHING clause |
|
53 | CS | 1293 | 1336 | 1430 | 978 | 1377 | 1375 | 891 | 1268 | 806 | 785 | 1289 | 787 | 1394 | 804 | 779 | 1633 | 813 | 796 | 808 | 1396 | 1298 | 1553 | 1497 | 1004 | 1351 | 881 | 1460 | 1499 | 1272 | 1456 | 1522 | AV when recursive query used MERGE JOIN in execution plan |
|
54 | SS | 572 | 508 | 593 | 523 | 581 | 551 | 543 | 545 | 547 | 572 | 560 | 631 | 640 | 606 | 597 | 709 | 464 | 568 | 559 | 572 | 625 | 587 | 586 | 570 | 597 | 585 | 627 | 531 | 548 | 590 | 570 | AV when recursive query used MERGE JOIN in execution plan |
|
55 | CS | 1220 | 996 | 1282 | 893 | 1379 | 1243 | 904 | 1248 | 799 | 744 | 1173 | 749 | 1267 | 916 | 735 | 1218 | 732 | 799 | 752 | 1223 | 1288 | 1348 | 1571 | 761 | 1299 | 841 | 1281 | 1339 | 1321 | 1479 | 1392 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
56 | SS | 525 | 522 | 587 | 486 | 574 | 483 | 524 | 475 | 545 | 520 | 491 | 537 | 562 | 527 | 493 | 586 | 565 | 511 | 532 | 485 | 534 | 479 | 538 | 567 | 565 | 553 | 502 | 471 | 503 | 503 | 555 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
57 | CS | 996 | 1181 | 997 | 728 | 1131 | 948 | 569 | 940 | 548 | 576 | 561 | 634 | 995 | 827 | 565 | 1036 | 577 | 601 | 747 | 1100 | 1000 | 1207 | 1135 | 1054 | 1176 | 761 | 1078 | 1277 | 1048 | 1110 | 1136 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
58 | SS | 399 | 432 | 433 | 339 | 396 | 348 | 412 | 375 | 357 | 395 | 437 | 406 | 400 | 331 | 412 | 413 | 376 | 346 | 357 | 426 | 423 | 454 | 425 | 423 | 356 | 427 | 317 | 391 | 436 | 399 | 386 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
59 | CS | 901 | 819 | 1048 | 729 | 1048 | 1051 | 601 | 552 | 608 | 639 | 568 | 632 | 983 | 728 | 590 | 1104 | 611 | 638 | 613 | 647 | 1017 | 1332 | 1223 | 1042 | 1088 | 637 | 1111 | 1343 | 1078 | 1075 | 1260 | Wrong variable initialization in recursive procedures |
|
60 | SS | 433 | 403 | 486 | 388 | 435 | 392 | 433 | 396 | 417 | 397 | 369 | 433 | 468 | 361 | 508 | 476 | 435 | 433 | 449 | 446 | 422 | 451 | 479 | 476 | 422 | 440 | 420 | 393 | 445 | 430 | 393 | Wrong variable initialization in recursive procedures |
|
61 | CS | 895 | 759 | 758 | 910 | 1272 | 774 | 704 | 814 | 700 | 811 | 783 | 785 | 1272 | 701 | 1139 | 1392 | 1129 | 786 | 795 | 1261 | 1426 | 881 | 1432 | 1352 | 830 | 873 | 1404 | 1381 | 1436 | 1423 | 1324 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
62 | SS | 529 | 518 | 548 | 581 | 576 | 470 | 498 | 491 | 477 | 555 | 514 | 546 | 568 | 558 | 555 | 530 | 544 | 526 | 552 | 521 | 584 | 475 | 553 | 533 | 500 | 563 | 515 | 516 | 528 | 499 | 509 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
63 | CS | 847 | 827 | 704 | 970 | 1236 | 747 | 789 | 844 | 808 | 842 | 804 | 845 | 1297 | 748 | 746 | 1057 | 1261 | 801 | 784 | 795 | 1315 | 845 | 1393 | 1347 | 849 | 866 | 1388 | 1398 | 1402 | 1383 | 1307 | Consistency check when subquery is ordered by aggregate function from other context |
|
64 | SS | 525 | 496 | 541 | 605 | 532 | 501 | 460 | 522 | 514 | 559 | 523 | 576 | 523 | 509 | 592 | 564 | 552 | 510 | 473 | 527 | 561 | 520 | 557 | 547 | 520 | 567 | 521 | 521 | 556 | 519 | 546 | Consistency check when subquery is ordered by aggregate function from other context |
|
65 | CS | 803 | 753 | 1212 | 870 | 732 | 785 | 759 | 787 | 672 | 784 | 791 | 744 | 1272 | 710 | 1383 | 757 | 1275 | 752 | 727 | 1312 | 808 | 1447 | 798 | 774 | 1290 | 857 | 1293 | 1101 | 1270 | 1490 | 829 | DEFAULT values are unnecessary evaluated |
|
66 | SS | 527 | 503 | 571 | 489 | 567 | 529 | 512 | 489 | 559 | 488 | 557 | 574 | 568 | 517 | 595 | 501 | 534 | 501 | 527 | 546 | 518 | 522 | 527 | 580 | 487 | 572 | 520 | 506 | 501 | 545 | 570 | DEFAULT values are unnecessary evaluated |
|
67 | CS | 691 | 630 | 646 | 667 | 659 | 608 | 693 | 679 | 1076 | 596 | 634 | 618 | 568 | 1064 | 1184 | 608 | 640 | 722 | 651 | 635 | 1098 | 725 | 913 | 689 | 1067 | 755 | 1163 | 1036 | 1147 | 1214 | 1221 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
68 | SS | 458 | 436 | 496 | 401 | 526 | 481 | 399 | 483 | 400 | 434 | 462 | 465 | 398 | 477 | 492 | 451 | 474 | 466 | 471 | 432 | 470 | 484 | 422 | 476 | 433 | 455 | 473 | 442 | 449 | 405 | 441 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
69 | CS | 901 | 808 | 1315 | 897 | 1515 | 767 | 696 | 1082 | 1332 | 811 | 720 | 790 | 905 | 1355 | 1313 | 818 | 772 | 1322 | 798 | 752 | 798 | 802 | 1377 | 727 | 1459 | 873 | 1054 | 1466 | 1337 | 1332 | 1270 | Null in the first record in a condition on rdb$db_key |
|
70 | SS | 538 | 497 | 585 | 522 | 550 | 502 | 562 | 537 | 458 | 555 | 469 | 540 | 512 | 578 | 563 | 521 | 532 | 563 | 539 | 522 | 549 | 527 | 572 | 557 | 560 | 492 | 534 | 541 | 514 | 495 | 556 | Null in the first record in a condition on rdb$db_key |
|
71 | CS | 918 | 771 | 764 | 904 | 789 | 731 | 773 | 1209 | 1232 | 733 | 772 | 743 | 906 | 1346 | 1421 | 788 | 801 | 1418 | 738 | 922 | 966 | 789 | 1507 | 914 | 1353 | 948 | 965 | 1338 | 1555 | 1450 | 1449 | update or insert with gen_id() with wrong generator value |
|
72 | SS | 557 | 521 | 584 | 608 | 606 | 538 | 638 | 536 | 579 | 613 | 563 | 524 | 598 | 546 | 546 | 647 | 596 | 568 | 546 | 553 | 568 | 574 | 559 | 548 | 535 | 569 | 546 | 505 | 556 | 548 | 525 | update or insert with gen_id() with wrong generator value |
|
73 | CS | 860 | 728 | 720 | 853 | 753 | 783 | 787 | 931 | 1261 | 779 | 763 | 742 | 794 | 1294 | 1251 | 877 | 776 | 1265 | 933 | 821 | 784 | 832 | 1479 | 802 | 1315 | 868 | 1021 | 1288 | 1247 | 1414 | 1297 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
74 | SS | 531 | 521 | 553 | 468 | 589 | 478 | 517 | 505 | 500 | 544 | 573 | 516 | 522 | 491 | 559 | 563 | 499 | 538 | 554 | 545 | 558 | 486 | 538 | 503 | 520 | 559 | 565 | 527 | 554 | 512 | 536 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
75 | CS | 880 | 699 | 895 | 908 | 779 | 715 | 709 | 1315 | 1288 | 750 | 694 | 809 | 735 | 1338 | 1350 | 980 | 733 | 1227 | 782 | 764 | 817 | 829 | 1439 | 852 | 865 | 921 | 1493 | 1228 | 1330 | 1371 | 1404 | GROUP by and RDB$DB_KEY problems |
|
76 | SS | 530 | 563 | 541 | 540 | 529 | 489 | 504 | 527 | 517 | 544 | 537 | 534 | 524 | 540 | 576 | 522 | 535 | 563 | 547 | 498 | 515 | 528 | 519 | 539 | 531 | 545 | 549 | 529 | 510 | 488 | 476 | GROUP by and RDB$DB_KEY problems |
|
77 | CS | 928 | 837 | 843 | 1009 | 1432 | 780 | 1324 | 1324 | 876 | 792 | 753 | 1304 | 744 | 1364 | 1351 | 825 | 847 | 1393 | 722 | 752 | 842 | 847 | 1380 | 803 | 970 | 886 | 1517 | 1311 | 1294 | 1381 | 1312 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
78 | SS | 550 | 485 | 568 | 548 | 615 | 532 | 506 | 535 | 570 | 549 | 570 | 550 | 590 | 561 | 502 | 514 | 538 | 495 | 555 | 599 | 568 | 516 | 575 | 590 | 568 | 502 | 561 | 529 | 555 | 510 | 550 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
79 | CS | 832 | 1179 | 848 | 890 | 834 | 755 | 1220 | 712 | 802 | 788 | 781 | 1362 | 736 | 1324 | 798 | 1344 | 831 | 1181 | 1280 | 782 | 763 | 888 | 827 | 816 | 752 | 846 | 820 | 746 | 1378 | 1364 | 1290 | Grouping by function doesn't work properly |
|
80 | SS | 529 | 489 | 481 | 544 | 533 | 522 | 504 | 487 | 509 | 518 | 490 | 566 | 526 | 557 | 618 | 565 | 618 | 543 | 482 | 550 | 512 | 544 | 498 | 580 | 547 | 524 | 574 | 563 | 526 | 493 | 542 | Grouping by function doesn't work properly |
|
81 | CS | 877 | 1303 | 893 | 856 | 747 | 718 | 1248 | 666 | 890 | 753 | 1260 | 1290 | 777 | 1265 | 1370 | 739 | 711 | 1031 | 1251 | 804 | 768 | 1143 | 741 | 766 | 865 | 788 | 734 | 1048 | 1367 | 1393 | 1491 | Firebird float support does not conform to Interbase spec |
|
82 | SS | 516 | 526 | 536 | 493 | 571 | 455 | 500 | 478 | 471 | 525 | 529 | 553 | 490 | 465 | 560 | 531 | 485 | 513 | 522 | 575 | 560 | 518 | 515 | 540 | 514 | 491 | 530 | 552 | 470 | 513 | 474 | Firebird float support does not conform to Interbase spec |
|
83 | CS | 775 | 936 | 693 | 618 | 1115 | 565 | 982 | 949 | 616 | 585 | 1092 | 601 | 1008 | 701 | 587 | 624 | 583 | 1009 | 1090 | 680 | 1337 | 1121 | 672 | 849 | 1160 | 700 | 549 | 689 | 1035 | 1144 | 1102 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
84 | SS | 410 | 473 | 416 | 443 | 440 | 372 | 333 | 359 | 362 | 434 | 369 | 430 | 452 | 431 | 413 | 375 | 349 | 424 | 424 | 411 | 367 | 438 | 435 | 410 | 388 | 398 | 377 | 399 | 447 | 409 | 401 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
85 | CS | 1185 | 783 | 1042 | 1028 | 859 | 760 | 1475 | 1412 | 778 | 800 | 1474 | 938 | 1371 | 840 | 822 | 902 | 864 | 1508 | 1547 | 1675 | 1167 | 1216 | 1564 | 1204 | 1308 | 919 | 1440 | 872 | 1596 | 1440 | 1668 | Outer ORDER BY clause has no effect |
|
86 | SS | 676 | 584 | 731 | 699 | 697 | 577 | 579 | 592 | 603 | 698 | 536 | 750 | 723 | 690 | 676 | 703 | 649 | 651 | 710 | 676 | 633 | 698 | 664 | 717 | 677 | 670 | 677 | 723 | 626 | 625 | 683 | Outer ORDER BY clause has no effect |
|
87 | CS | 1234 | 759 | 913 | 851 | 1250 | 1236 | 755 | 1446 | 1469 | 850 | 1233 | 1583 | 1315 | 808 | 797 | 828 | 776 | 1520 | 1349 | 1384 | 1057 | 1268 | 1491 | 890 | 1188 | 883 | 1403 | 888 | 1425 | 1524 | 1420 | Wrong field position after ALTER POSITION |
|
88 | SS | 590 | 535 | 608 | 607 | 575 | 583 | 550 | 572 | 582 | 612 | 557 | 612 | 606 | 596 | 566 | 672 | 549 | 537 | 640 | 615 | 625 | 606 | 598 | 609 | 644 | 542 | 584 | 563 | 577 | 561 | 620 | Wrong field position after ALTER POSITION |
|
89 | CS | 1091 | 1097 | 229309 | 229984 | 624 | 982 | 639 | 672 | 580 | 1095 | 633 | 646 | 1205 | 667 | 1142 | 653 | 880 | 1136 | 1102 | 1074 | 1205 | 1212 | 801 | 1170 | 1206 | 705 | 948 | 1088 | 1204 | 1153 | 1204 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
90 | SS | 461 | 421 | 238768 | 232930 | 427 | 413 | 397 | 347 | 372 | 459 | 495 | 470 | 463 | 463 | 526 | 528 | 448 | 417 | 426 | 505 | 432 | 497 | 492 | 508 | 472 | 448 | 498 | 428 | 458 | 394 | 501 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
91 | CS | 1072 | 1368 | 866 | 932 | 824 | 780 | 735 | 768 | 697 | 1312 | 728 | 928 | 860 | 744 | 1377 | 768 | 766 | 1344 | 1283 | 1417 | 1315 | 1504 | 1383 | 763 | 1329 | 926 | 1292 | 1213 | 1373 | 1353 | 1346 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
92 | SS | 539 | 502 | 559 | 477 | 591 | 512 | 566 | 484 | 550 | 607 | 544 | 506 | 537 | 524 | 554 | 571 | 586 | 532 | 508 | 550 | 518 | 575 | 600 | 540 | 571 | 537 | 485 | 504 | 538 | 588 | 536 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
93 | CS | 1249 | 766 | 880 | 856 | 1361 | 736 | 1238 | 747 | 1206 | 745 | 1310 | 843 | 839 | 749 | 810 | 805 | 793 | 1272 | 1384 | 1368 | 1333 | 1378 | 1369 | 1349 | 1536 | 938 | 1308 | 1553 | 1260 | 1336 | 1310 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
94 | SS | 543 | 514 | 551 | 473 | 544 | 436 | 513 | 533 | 474 | 563 | 537 | 560 | 572 | 533 | 542 | 536 | 600 | 555 | 496 | 504 | 550 | 537 | 545 | 581 | 557 | 557 | 598 | 512 | 546 | 507 | 566 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
95 | CS | 2429 | 1914 | 2436 | 2422 | 1852 | 1686 | 1748 | 3102 | 1813 | 2507 | 1752 | 2377 | 2343 | 1625 | 3648 | 2376 | 2955 | 3199 | 2657 | 2884 | 3123 | 2773 | 2416 | 2972 | 2643 | 1892 | 2647 | 2488 | 1661 | 2999 | 1644 | Lateral derived tables |
|
96 | SS | 1774 | 1813 | 1938 | 2015 | 2085 | 1808 | 1536 | 1755 | 1628 | 1874 | 1934 | 1950 | 1914 | 1682 | 1932 | 2203 | 2041 | 1741 | 1698 | 1695 | 1864 | 1741 | 1682 | 1769 | 1644 | 1808 | 1665 | 1714 | 1738 | 1706 | 1779 | Lateral derived tables |
|
97 | CS | 1377 | 864 | 1068 | 1061 | 924 | 1482 | 811 | 1277 | 831 | 1478 | 1012 | 875 | 1054 | 849 | 1699 | 1021 | 1127 | 1535 | 1501 | 1654 | 1537 | 1726 | 1733 | 1638 | 1531 | 1078 | 1624 | 1693 | 995 | 1570 | 1680 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
98 | SS | 728 | 638 | 713 | 801 | 756 | 660 | 688 | 641 | 708 | 726 | 689 | 752 | 758 | 708 | 713 | 775 | 668 | 729 | 714 | 795 | 727 | 713 | 761 | 806 | 734 | 782 | 793 | 738 | 654 | 782 | 734 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
99 | CS | 1323 | 792 | 928 | 1041 | 870 | 1318 | 784 | 1094 | 808 | 1343 | 1254 | 872 | 991 | 764 | 1450 | 979 | 1397 | 1457 | 1536 | 1449 | 1412 | 1616 | 1431 | 1435 | 1341 | 1071 | 1424 | 1433 | 957 | 1328 | 1406 | Window Function: frame (rows / range) clause |
|
100 | SS | 632 | 603 | 612 | 633 | 692 | 629 | 584 | 564 | 602 | 656 | 656 | 616 | 606 | 568 | 614 | 674 | 691 | 676 | 659 | 702 | 632 | 576 | 667 | 703 | 670 | 626 | 673 | 685 | 629 | 710 | 625 | Window Function: frame (rows / range) clause |
|
101 | CS | 1083 | 732 | 934 | 816 | 894 | 1251 | 1355 | 925 | 1239 | 1213 | 1229 | 756 | 912 | 697 | 788 | 872 | 759 | 1648 | 1477 | 1378 | 1260 | 1439 | 1455 | 1276 | 1396 | 954 | 1305 | 1345 | 863 | 732 | 767 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
102 | SS | 561 | 504 | 556 | 524 | 563 | 499 | 520 | 491 | 517 | 594 | 560 | 564 | 582 | 576 | 564 | 601 | 511 | 539 | 553 | 596 | 598 | 642 | 595 | 598 | 584 | 538 | 563 | 549 | 521 | 523 | 571 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
103 | CS | 947 | 736 | 772 | 742 | 633 | 587 | 634 | 760 | 1042 | 789 | 1089 | 1112 | 816 | 655 | 694 | 746 | 771 | 1088 | 1056 | 1037 | 1064 | 1203 | 1221 | 1358 | 1092 | 779 | 1091 | 1043 | 858 | 1086 | 1046 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
104 | SS | 424 | 386 | 481 | 430 | 439 | 440 | 377 | 404 | 425 | 468 | 443 | 487 | 450 | 400 | 422 | 464 | 421 | 434 | 423 | 394 | 401 | 422 | 472 | 498 | 445 | 400 | 384 | 419 | 356 | 483 | 387 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
105 | CS | 1088 | 838 | 982 | 938 | 743 | 727 | 729 | 940 | 1292 | 898 | 990 | 1384 | 916 | 785 | 861 | 878 | 871 | 1352 | 1279 | 1340 | 1301 | 1496 | 1452 | 1564 | 1278 | 969 | 1244 | 1288 | 1187 | 1416 | 1348 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
106 | SS | 534 | 504 | 498 | 503 | 607 | 469 | 498 | 541 | 526 | 568 | 562 | 605 | 526 | 568 | 521 | 568 | 637 | 551 | 522 | 539 | 530 | 546 | 542 | 551 | 486 | 512 | 550 | 568 | 464 | 502 | 513 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
107 | CS | 914 | 777 | 910 | 876 | 1107 | 764 | 726 | 850 | 757 | 883 | 751 | 1368 | 828 | 730 | 873 | 932 | 835 | 861 | 1269 | 1294 | 1215 | 1372 | 1375 | 1249 | 1353 | 919 | 1230 | 1315 | 859 | 1278 | 1335 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
108 | SS | 536 | 500 | 538 | 549 | 582 | 580 | 493 | 448 | 538 | 570 | 514 | 555 | 522 | 488 | 548 | 546 | 572 | 541 | 504 | 558 | 525 | 535 | 545 | 612 | 525 | 511 | 534 | 563 | 525 | 509 | 523 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
109 | CS | 966 | 986 | 655 | 710 | 983 | 1060 | 564 | 779 | 698 | 834 | 685 | 949 | 705 | 568 | 717 | 646 | 631 | 985 | 1118 | 1090 | 1186 | 1125 | 1136 | 1158 | 1049 | 700 | 1097 | 1096 | 1174 | 939 | 1048 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
110 | SS | 407 | 339 | 388 | 379 | 432 | 346 | 379 | 356 | 404 | 413 | 398 | 485 | 461 | 417 | 469 | 381 | 402 | 416 | 409 | 389 | 405 | 411 | 487 | 435 | 412 | 421 | 431 | 395 | 438 | 386 | 406 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
111 | CS | 901 | 573 | 702 | 676 | 1073 | 1072 | 594 | 662 | 745 | 752 | 687 | 1100 | 666 | 564 | 752 | 770 | 728 | 1032 | 1088 | 1289 | 1116 | 1068 | 1180 | 1165 | 1059 | 675 | 1136 | 1207 | 701 | 1112 | 1072 | Parametrized queries using RDB$DB_KEY do not work |
|
112 | SS | 442 | 384 | 455 | 451 | 443 | 433 | 388 | 351 | 393 | 476 | 439 | 481 | 481 | 421 | 421 | 463 | 480 | 394 | 460 | 450 | 417 | 410 | 465 | 493 | 441 | 428 | 483 | 449 | 425 | 511 | 431 | Parametrized queries using RDB$DB_KEY do not work |
|
113 | CS | 1341 | 856 | 1060 | 1080 | 1344 | 1338 | 942 | 976 | 962 | 1021 | 1130 | 1385 | 1022 | 864 | 1108 | 1052 | 1042 | 1477 | 1473 | 1723 | 1596 | 1676 | 1608 | 1508 | 1671 | 1076 | 1471 | 1527 | 1748 | 1631 | 1611 | Wrong result of join when joined fields are created via row_number() function |
|
114 | SS | 723 | 702 | 693 | 762 | 739 | 631 | 606 | 648 | 575 | 686 | 749 | 766 | 685 | 711 | 711 | 723 | 723 | 806 | 744 | 714 | 759 | 773 | 791 | 756 | 718 | 792 | 657 | 751 | 692 | 777 | 784 | Wrong result of join when joined fields are created via row_number() function |
|
115 | CS | 1858 | 2488 | 1892 | 1797 | 1866 | 2470 | 1665 | 1542 | 1971 | 1760 | 1883 | 1851 | 1744 | 1774 | 1720 | 1755 | 1803 | 1399 | 1910 | 1662 | 2625 | 1571 | 2813 | 2511 | 1539 | 1768 | 2487 | 2769 | 2675 | 3061 | 2787 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
116 | SS | 1041 | 895 | 1061 | 988 | 1071 | 959 | 977 | 907 | 1026 | 1093 | 1079 | 1046 | 1046 | 1002 | 1146 | 1104 | 1032 | 1100 | 978 | 1041 | 1056 | 1047 | 1044 | 1043 | 984 | 908 | 1105 | 945 | 1007 | 1016 | 1041 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
117 | CS | 945 | 1241 | 815 | 886 | 945 | 789 | 867 | 914 | 951 | 945 | 897 | 889 | 879 | 939 | 926 | 928 | 847 | 1007 | 1255 | 1308 | 1200 | 1419 | 1495 | 891 | 1272 | 952 | 778 | 1355 | 1572 | 1368 | 1559 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
118 | SS | 567 | 532 | 595 | 554 | 524 | 499 | 523 | 515 | 581 | 535 | 580 | 593 | 669 | 582 | 561 | 592 | 557 | 608 | 584 | 566 | 584 | 596 | 615 | 568 | 604 | 488 | 588 | 549 | 557 | 527 | 544 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
119 | CS | 1467 | 1275 | 1390 | 1475 | 1410 | 1424 | 1344 | 1298 | 1293 | 1367 | 1409 | 1459 | 1246 | 1494 | 1514 | 1402 | 1449 | 1173 | 1315 | 1735 | 2131 | 2096 | 1713 | 2011 | 2056 | 1506 | 1566 | 1960 | 2179 | 2016 | 2063 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
120 | SS | 838 | 785 | 885 | 673 | 870 | 817 | 825 | 787 | 872 | 838 | 837 | 939 | 958 | 895 | 861 | 912 | 901 | 860 | 771 | 904 | 866 | 838 | 835 | 836 | 832 | 820 | 769 | 798 | 800 | 866 | 898 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
121 | CS | 763 | 736 | 815 | 675 | 798 | 712 | 704 | 698 | 768 | 744 | 756 | 759 | 752 | 646 | 730 | 740 | 729 | 1148 | 680 | 886 | 1003 | 1109 | 648 | 874 | 1217 | 773 | 930 | 1106 | 1300 | 1153 | 1127 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
122 | SS | 461 | 460 | 497 | 481 | 445 | 475 | 441 | 394 | 373 | 455 | 442 | 468 | 483 | 497 | 471 | 441 | 479 | 462 | 433 | 451 | 496 | 433 | 496 | 533 | 488 | 456 | 514 | 415 | 396 | 457 | 473 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
123 | CS | 923 | 763 | 922 | 809 | 891 | 805 | 812 | 840 | 879 | 789 | 919 | 870 | 879 | 831 | 956 | 924 | 862 | 1260 | 1139 | 1344 | 1114 | 1294 | 1299 | 1400 | 1251 | 896 | 1172 | 1385 | 1360 | 1356 | 1098 | SEC$ tables and tag/attributes |
|
124 | SS | 530 | 526 | 617 | 756 | 502 | 508 | 461 | 505 | 481 | 644 | 454 | 788 | 692 | 516 | 649 | 718 | 689 | 535 | 541 | 523 | 501 | 515 | 582 | 534 | 493 | 552 | 506 | 544 | 522 | 474 | 554 | SEC$ tables and tag/attributes |
|
125 | CS | 766 | 734 | 886 | 774 | 788 | 722 | 719 | 715 | 758 | 714 | 687 | 792 | 726 | 677 | 722 | 817 | 684 | 1176 | 1176 | 1108 | 1144 | 1153 | 1220 | 1176 | 1175 | 747 | 1204 | 1188 | 678 | 684 | 626 | Window Function: named window |
|
126 | SS | 489 | 490 | 436 | 428 | 676 | 404 | 513 | 387 | 531 | 475 | 580 | 632 | 676 | 700 | 703 | 593 | 597 | 447 | 475 | 489 | 499 | 492 | 473 | 525 | 532 | 428 | 473 | 419 | 459 | 478 | 428 | Window Function: named window |
|
127 | CS | 9699 | 9138 | 9633 | 9235 | 9922 | 8846 | 9090 | 9038 | 8638 | 9035 | 9029 | 9915 | 9326 | 9230 | 9813 | 10286 | 9395 | 10588 | 10905 | 11313 | 10496 | 10800 | 11875 | 11294 | 9972 | 9006 | 9765 | 11191 | 10388 | 6400 | 5997 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
128 | SS | 6793 | 4988 | 5137 | 4699 | 8771 | 6765 | 7726 | 6146 | 8072 | 8679 | 8380 | 8588 | 4796 | 8606 | 8377 | 8560 | 8005 | 6597 | 6718 | 6811 | 7201 | 6759 | 6829 | 6790 | 6338 | 6039 | 7121 | 6797 | 6289 | 5688 | 5776 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
129 | CS | 1111 | 1165 | 859 | 928 | 1010 | 939 | 916 | 918 | 917 | 932 | 937 | 963 | 953 | 934 | 983 | 1069 | 912 | 1153 | 1868 | 1887 | 1989 | 2191 | 2020 | 2669 | 2043 | 1264 | 1832 | 1854 | 1988 | 1865 | 1893 | Unique constraint not working in encrypted database on first command |
|
130 | SS | 721 | 880 | 666 | 705 | 881 | 719 | 726 | 671 | 704 | 784 | 534 | 480 | 773 | 468 | 793 | 615 | 824 | 707 | 709 | 758 | 757 | 724 | 732 | 755 | 740 | 678 | 744 | 685 | 639 | 706 | 757 | Unique constraint not working in encrypted database on first command |
|
131 | CS | 703 | 655 | 659 | 635 | 673 | 645 | 635 | 600 | 600 | 718 | 705 | 702 | 642 | 684 | 679 | 664 | 678 | 668 | 968 | 1157 | 1009 | 1169 | 1111 | 990 | 1204 | 704 | 1048 | 1146 | 1078 | 1108 | 1005 | Allow unused Common Table Expressions |
|
132 | SS | 443 | 412 | 566 | 559 | 639 | 426 | 544 | 562 | 536 | 555 | 405 | 313 | 615 | 320 | 603 | 609 | 595 | 443 | 429 | 457 | 475 | 404 | 462 | 383 | 384 | 353 | 378 | 425 | 371 | 443 | 408 | Allow unused Common Table Expressions |
|
133 | CS | 780 | 704 | 709 | 631 | 751 | 743 | 659 | 696 | 784 | 743 | 749 | 799 | 655 | 777 | 688 | 766 | 775 | 637 | 1125 | 1026 | 1144 | 1354 | 1274 | 1135 | 1179 | 812 | 1028 | 1184 | 1194 | 1114 | 1317 | Consider equivalence classes for index navigation |
|
134 | SS | 492 | 621 | 627 | 642 | 615 | 594 | 480 | 452 | 642 | 505 | 333 | 357 | 657 | 361 | 599 | 641 | 667 | 436 | 519 | 520 | 519 | 422 | 467 | 478 | 416 | 422 | 527 | 378 | 446 | 422 | 445 | Consider equivalence classes for index navigation |
|
135 | CS | 4658 | 4621 | 4665 | 4628 | 4598 | 4549 | 4596 | 4647 | 4652 | 4568 | 4650 | 4665 | 4594 | 4572 | 4652 | 4650 | 4585 | 4938 | 5023 | 4972 | 5141 | 5111 | 5226 | 5075 | 5164 | 4647 | 4865 | 5125 | 5007 | 5005 | 4909 | Invalid parameters of gds transaction in ISQL |
|
136 | SS | 4380 | 4426 | 4548 | 4537 | 4501 | 4472 | 4507 | 4520 | 4365 | 4572 | 4289 | 4284 | 4510 | 4375 | 4503 | 4479 | 4487 | 4308 | 4377 | 4384 | 4353 | 4366 | 4367 | 4371 | 4355 | 4369 | 4376 | 4359 | 4352 | 4393 | 4404 | Invalid parameters of gds transaction in ISQL |
|
137 | CS | 728 | 702 | 673 | 698 | 708 | 667 | 668 | 586 | 674 | 648 | 665 | 672 | 740 | 699 | 717 | 759 | 683 | 1197 | 1143 | 1093 | 1256 | 1181 | 1126 | 1179 | 1151 | 694 | 1071 | 1191 | 1164 | 1240 | 1057 | Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals |
|
138 | SS | 443 | 549 | 557 | 574 | 676 | 523 | 547 | 574 | 476 | 414 | 371 | 339 | 598 | 450 | 445 | 664 | 610 | 429 | 431 | 430 | 442 | 403 | 418 | 430 | 415 | 414 | 428 | 434 | 389 | 457 | 504 | Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals |
|
139 | CS | 1169 | 1128 | 1264 | 1150 | 1151 | 1160 | 1029 | 1034 | 1031 | 1044 | 1156 | 1142 | 1046 | 1135 | 1154 | 1105 | 1037 | 1695 | 1771 | 1700 | 1876 | 2063 | 1831 | 1704 | 1939 | 1179 | 1650 | 1856 | 1919 | 1678 | 1613 | User can grant usage privilege by himself |
|
140 | SS | 689 | 834 | 754 | 903 | 719 | 825 | 878 | 821 | 814 | 810 | 467 | 540 | 963 | 621 | 908 | 804 | 823 | 636 | 613 | 699 | 649 | 632 | 677 | 679 | 693 | 652 | 665 | 583 | 552 | 686 | 635 | User can grant usage privilege by himself |
|
141 | CS | 761 | 682 | 758 | 615 | 751 | 695 | 656 | 674 | 653 | 700 | 724 | 777 | 711 | 744 | 712 | 777 | 710 | 1102 | 1071 | 1108 | 1226 | 1328 | 1217 | 1154 | 1099 | 765 | 1004 | 1173 | 635 | 1232 | 1256 | No error if the GRANT target object does not exist |
|
142 | SS | 495 | 624 | 627 | 666 | 541 | 575 | 608 | 461 | 576 | 568 | 340 | 620 | 645 | 603 | 501 | 623 | 626 | 460 | 437 | 428 | 457 | 489 | 504 | 443 | 475 | 404 | 434 | 488 | 351 | 405 | 450 | No error if the GRANT target object does not exist |
|
143 | CS | 768 | 714 | 783 | 669 | 731 | 650 | 640 | 715 | 610 | 673 | 688 | 673 | 651 | 769 | 768 | 691 | 703 | 1090 | 1135 | 1051 | 1156 | 1262 | 1291 | 1091 | 1091 | 737 | 993 | 1073 | 1118 | 1099 | 1118 | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) |
|
144 | SS | 476 | 609 | 552 | 608 | 639 | 599 | 580 | 503 | 765 | 631 | 368 | 376 | 590 | 511 | 581 | 575 | 616 | 446 | 437 | 470 | 454 | 368 | 470 | 396 | 483 | 374 | 398 | 382 | 424 | 386 | 421 | Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) |
|
145 | CS | 773 | 595 | 754 | 668 | 700 | 689 | 681 | 761 | 670 | 689 | 623 | 785 | 704 | 704 | 753 | 797 | 762 | 979 | 1039 | 1224 | 1232 | 1241 | 1123 | 1029 | 1166 | 749 | 1128 | 1216 | 1093 | 1060 | 1124 | Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete |
|
146 | SS | 461 | 410 | 649 | 673 | 332 | 596 | 533 | 601 | 570 | 622 | 361 | 337 | 623 | 581 | 777 | 322 | 602 | 458 | 456 | 463 | 494 | 443 | 470 | 469 | 458 | 398 | 424 | 460 | 353 | 376 | 452 | Wrong behavour FOR <select_stmt> [AS CURSOR cursorname] with next update and delete |
|
147 | CS | 1027 | 889 | 1104 | 1021 | 1035 | 923 | 954 | 898 | 927 | 1014 | 929 | 1052 | 995 | 959 | 1001 | 1034 | 924 | 1000 | 846 | 1579 | 1573 | 1657 | 1778 | 1706 | 1725 | 929 | 1429 | 1500 | 1620 | 1643 | 1698 | Ignor of reference privilege |
|
148 | SS | 627 | 660 | 564 | 817 | 882 | 712 | 777 | 757 | 821 | 845 | 867 | 813 | 627 | 831 | 747 | 786 | 424 | 584 | 616 | 623 | 564 | 609 | 609 | 606 | 628 | 558 | 610 | 585 | 585 | 645 | 548 | Ignor of reference privilege |
|
149 | CS | 936 | 901 | 907 | 957 | 980 | 910 | 927 | 885 | 847 | 920 | 874 | 880 | 867 | 886 | 891 | 956 | 946 | 823 | 791 | 1447 | 1467 | 1588 | 1726 | 1536 | 1402 | 856 | 1401 | 1433 | 1485 | 1313 | 1497 | Wrong handling of failures of TRANSACTION START trigger |
|
150 | SS | 639 | 732 | 528 | 864 | 671 | 730 | 744 | 676 | 636 | 707 | 621 | 831 | 659 | 734 | 756 | 875 | 790 | 626 | 627 | 642 | 608 | 592 | 581 | 625 | 638 | 640 | 612 | 630 | 633 | 541 | 592 | Wrong handling of failures of TRANSACTION START trigger |
|
151 | CS | 767 | 679 | 677 | 708 | 715 | 728 | 716 | 745 | 757 | 749 | 744 | 830 | 777 | 799 | 723 | 733 | 749 | 860 | 599 | 1287 | 1035 | 1375 | 1148 | 1313 | 1172 | 725 | 1269 | 1238 | 1242 | 1226 | 1137 | There is no check of existance generator and exception when privileges are granted |
|
152 | SS | 493 | 616 | 424 | 663 | 548 | 641 | 500 | 655 | 692 | 348 | 644 | 549 | 596 | 638 | 673 | 485 | 588 | 471 | 445 | 474 | 454 | 483 | 478 | 504 | 487 | 405 | 517 | 466 | 486 | 466 | 484 | There is no check of existance generator and exception when privileges are granted |
|
153 | CS | 4325 | 3991 | 4359 | 4211 | 4463 | 4168 | 3931 | 3859 | 4068 | 4026 | 4175 | 4242 | 4150 | 4066 | 4292 | 4543 | 4037 | 6923 | 3557 | 7469 | 6591 | 7245 | 7067 | 7080 | 6482 | 4011 | 6456 | 6540 | 6899 | 6724 | 7095 | GRANT OPTION is not checked for new object |
|
154 | SS | 2561 | 2563 | 2035 | 2695 | 3106 | 3075 | 2727 | 3083 | 3203 | 3268 | 3071 | 3128 | 2607 | 2912 | 1686 | 2396 | 2560 | 2420 | 2472 | 2541 | 2600 | 2393 | 2545 | 2346 | 2572 | 2439 | 2565 | 2238 | 2523 | 2528 | 2358 | GRANT OPTION is not checked for new object |
|
155 | CS | 699 | 704 | 666 | 639 | 740 | 640 | 652 | 778 | 682 | 689 | 695 | 636 | 661 | 731 | 695 | 676 | 609 | 684 | 1077 | 1161 | 1101 | 1169 | 1124 | 1091 | 1057 | 678 | 1037 | 1000 | 1224 | 688 | 1192 | Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx |
|
156 | SS | 455 | 594 | 447 | 527 | 593 | 657 | 588 | 574 | 609 | 638 | 592 | 612 | 456 | 515 | 355 | 433 | 625 | 407 | 434 | 466 | 403 | 417 | 378 | 440 | 455 | 472 | 403 | 396 | 429 | 391 | 359 | Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx |
|
157 | CS | 728 | 624 | 678 | 643 | 742 | 682 | 626 | 574 | 700 | 690 | 636 | 661 | 751 | 699 | 725 | 731 | 649 | 631 | 995 | 1220 | 1069 | 1166 | 1139 | 1049 | 1120 | 672 | 1088 | 1080 | 1113 | 800 | 1120 | Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation" |
|
158 | SS | 475 | 518 | 527 | 495 | 617 | 511 | 614 | 547 | 519 | 608 | 557 | 513 | 588 | 533 | 349 | 360 | 436 | 483 | 462 | 513 | 396 | 347 | 458 | 467 | 377 | 431 | 405 | 411 | 466 | 379 | 397 | Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation" |
|
159 | CS | 758 | 675 | 754 | 756 | 758 | 738 | 673 | 671 | 663 | 709 | 669 | 730 | 729 | 759 | 757 | 822 | 775 | 600 | 1182 | 1100 | 1092 | 1163 | 1108 | 1098 | 1216 | 738 | 1053 | 1103 | 1248 | 1251 | 1172 | Inconsistencies with PSQL FUNCTION vs UDF |
|
160 | SS | 505 | 560 | 546 | 584 | 601 | 319 | 636 | 453 | 628 | 524 | 631 | 920 | 612 | 573 | 676 | 387 | 635 | 464 | 499 | 486 | 421 | 477 | 513 | 468 | 511 | 452 | 422 | 469 | 452 | 375 | 496 | Inconsistencies with PSQL FUNCTION vs UDF |
|
161 | CS | 2199 | 2024 | 2209 | 1932 | 2061 | 2010 | 1865 | 1867 | 1920 | 2121 | 2080 | 2134 | 1908 | 1988 | 2189 | 2212 | 2078 | 2333 | 3105 | 3767 | 2135 | 3832 | 4093 | 4556 | 3569 | 2414 | 3385 | 3720 | 3655 | 3901 | 3687 | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
162 | SS | 2077 | 2237 | 2200 | 2703 | 3080 | 2649 | 2405 | 2399 | 2755 | 2612 | 2657 | 2520 | 2276 | 2439 | 2459 | 2326 | 1635 | 1859 | 1710 | 1941 | 1887 | 1837 | 1781 | 1955 | 1894 | 1862 | 1675 | 1676 | 1839 | 1760 | 1918 | FB3 Optimiser chooses less efficient plan than FB2.5 optimiser |
|
163 | CS | 1167 | 1122 | 1177 | 1086 | 1161 | 1012 | 1041 | 1138 | 1159 | 1173 | 1115 | 1138 | 1123 | 1152 | 1255 | 1143 | 1178 | 863 | 1393 | 1776 | 883 | 1419 | 1681 | 1720 | 1691 | 1117 | 1671 | 1440 | 1526 | 1562 | 1483 | Built-in cryptographic functions |
|
164 | SS | 937 | 980 | 790 | 1240 | 782 | 1002 | 1134 | 1054 | 796 | 1120 | 1164 | 1092 | 716 | 1054 | 1225 | 985 | 620 | 874 | 909 | 863 | 932 | 1025 | 942 | 892 | 911 | 1008 | 966 | 841 | 896 | 847 | 882 | Built-in cryptographic functions |
|
165 | CS | 1950 | 1812 | 1796 | 1697 | 1969 | 1930 | 1749 | 1771 | 1698 | 1973 | 1966 | 1829 | 1751 | 1935 | 1917 | 1968 | 1853 | 1619 | 2759 | 2980 | 1545 | 2965 | 3153 | 3044 | 2831 | 1915 | 2842 | 2913 | 2789 | 2880 | 2855 | External engine trigger crashing server if table have computed field |
|
166 | SS | 1223 | 1492 | 1311 | 1344 | 1450 | 1508 | 1525 | 1470 | 1542 | 1597 | 1511 | 1419 | 1363 | 1214 | 1503 | 1223 | 865 | 1100 | 1190 | 1218 | 1223 | 1172 | 1237 | 1202 | 1186 | 1195 | 1215 | 1218 | 1157 | 1148 | 1193 | External engine trigger crashing server if table have computed field |
|
167 | CS | 865 | 748 | 834 | 843 | 824 | 782 | 922 | 912 | 798 | 887 | 778 | 791 | 833 | 893 | 915 | 797 | 797 | 804 | 1305 | 766 | 1229 | 1528 | 1369 | 725 | 1337 | 841 | 1245 | 1296 | 1245 | 1431 | 1437 | Segfault when using expression index with complex expression |
|
168 | SS | 569 | 687 | 576 | 516 | 739 | 693 | 732 | 738 | 737 | 592 | 421 | 750 | 462 | 737 | 662 | 566 | 384 | 499 | 539 | 510 | 581 | 523 | 507 | 494 | 572 | 514 | 573 | 497 | 578 | 496 | 468 | Segfault when using expression index with complex expression |
|
169 | CS | 716 | 685 | 693 | 685 | 679 | 686 | 667 | 701 | 715 | 775 | 675 | 765 | 669 | 717 | 706 | 750 | 684 | 634 | 968 | 662 | 1081 | 1137 | 1074 | 674 | 1111 | 740 | 1110 | 1103 | 1116 | 1051 | 1114 | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
170 | SS | 465 | 484 | 532 | 620 | 630 | 599 | 568 | 536 | 565 | 633 | 368 | 631 | 387 | 492 | 642 | 632 | 341 | 457 | 424 | 454 | 452 | 404 | 540 | 435 | 457 | 426 | 448 | 428 | 443 | 473 | 435 | FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan" |
|
171 | CS | 797 | 780 | 826 | 800 | 862 | 773 | 749 | 855 | 787 | 760 | 810 | 919 | 822 | 795 | 888 | 886 | 733 | 761 | 752 | 676 | 760 | 1166 | 1232 | 747 | 754 | 802 | 713 | 707 | 1048 | 1128 | 1223 | ISQL issues with increased identifier length |
|
172 | SS | 571 | 618 | 462 | 434 | 813 | 684 | 569 | 628 | 577 | 475 | 722 | 749 | 648 | 761 | 499 | 372 | 381 | 609 | 626 | 527 | 552 | 574 | 606 | 386 | 607 | 581 | 551 | 507 | 449 | 478 | 496 | ISQL issues with increased identifier length |
|
173 | CS | 695 | 701 | 700 | 654 | 740 | 621 | 659 | 622 | 721 | 640 | 667 | 770 | 678 | 694 | 729 | 682 | 696 | 1039 | 669 | 677 | 737 | 1166 | 912 | 645 | 709 | 682 | 620 | 636 | 1102 | 1151 | 1185 | Builtin functions converting binary string to hexadecimal representation and vice versa |
|
174 | SS | 446 | 503 | 619 | 321 | 628 | 595 | 382 | 566 | 567 | 381 | 578 | 470 | 460 | 507 | 363 | 361 | 340 | 470 | 433 | 397 | 447 | 401 | 456 | 438 | 398 | 458 | 446 | 402 | 372 | 434 | 454 | Builtin functions converting binary string to hexadecimal representation and vice versa |
|
175 | CS | 699 | 632 | 687 | 667 | 703 | 628 | 645 | 749 | 740 | 684 | 701 | 698 | 747 | 652 | 744 | 726 | 713 | 1004 | 738 | 618 | 662 | 1157 | 654 | 595 | 712 | 696 | 583 | 659 | 1064 | 1030 | 1131 | Random crash 64bit fb_inet_server. Possible collation issue |
|
176 | SS | 438 | 577 | 588 | 309 | 561 | 508 | 549 | 589 | 556 | 388 | 535 | 508 | 460 | 604 | 374 | 352 | 326 | 422 | 438 | 438 | 441 | 461 | 427 | 429 | 428 | 456 | 361 | 397 | 405 | 407 | 391 | Random crash 64bit fb_inet_server. Possible collation issue |
|
177 | CS | 3086 | 2938 | 3325 | 3166 | 3392 | 2772 | 3028 | 2865 | 2942 | 3127 | 3044 | 3369 | 3183 | 3213 | 3142 | 3307 | 3046 | 4582 | 2723 | 2595 | 2820 | 5542 | 2984 | 2677 | 2889 | 3044 | 2530 | 4699 | 4928 | 4915 | 4967 | Permissions for create or alter statements are not checked |
|
178 | SS | 1875 | 2315 | 2301 | 1280 | 1488 | 2331 | 2188 | 2160 | 2245 | 1762 | 2419 | 2480 | 2047 | 2224 | 1568 | 2646 | 1233 | 1811 | 2024 | 1981 | 1814 | 1783 | 1862 | 1825 | 1882 | 1741 | 1837 | 1767 | 1897 | 1689 | 1868 | Permissions for create or alter statements are not checked |
|
179 | CS | 694 | 759 | 714 | 692 | 677 | 615 | 656 | 684 | 699 | 698 | 666 | 723 | 636 | 697 | 714 | 743 | 662 | 619 | 641 | 572 | 843 | 1063 | 1128 | 584 | 646 | 683 | 612 | 1079 | 1202 | 1172 | 1132 | SUBSTRING of non-text/-blob is described to return NONE character set in DSQL |
|
180 | SS | 420 | 530 | 407 | 544 | 611 | 484 | 592 | 543 | 584 | 420 | 337 | 618 | 420 | 520 | 328 | 539 | 323 | 457 | 434 | 413 | 426 | 381 | 387 | 448 | 410 | 413 | 420 | 393 | 394 | 348 | 366 | SUBSTRING of non-text/-blob is described to return NONE character set in DSQL |
|
181 | CS | 1272 | 1912 | 804 | 767 | 693 | 767 | 720 | 749 | 707 | 747 | 751 | 724 | 811 | 812 | 871 | 708 | 797 | 1772 | 1780 | 1683 | 1719 | 1871 | 2937 | 1823 | 1840 | 1946 | 1673 | 2686 | 2952 | 2788 | 2805 | Problems with long object names (> 255 bytes) |
|
182 | SS | 912 | 1737 | 572 | 484 | 349 | 575 | 546 | 596 | 437 | 594 | 340 | 478 | 499 | 605 | 377 | 551 | 352 | 1433 | 1297 | 1356 | 1421 | 1361 | 1290 | 1388 | 1220 | 1252 | 1355 | 1305 | 1261 | 1230 | 1288 | Problems with long object names (> 255 bytes) |
|
183 | CS | 709 | 664 | 752 | 682 | 717 | 678 | 744 | 760 | 693 | 761 | 690 | 762 | 749 | 770 | 748 | 736 | 701 | 634 | 680 | 593 | 616 | 666 | 1244 | 608 | 689 | 656 | 621 | 1045 | 1080 | 1008 | 1104 | "No current record for fetch operation" with queries with aggregated subselect |
|
184 | CS | 686 | 669 | 695 | 665 | 710 | 745 | 689 | 590 | 714 | 683 | 618 | 745 | 739 | 692 | 738 | 704 | 693 | 627 | 667 | 632 | 649 | 626 | 643 | 628 | 653 | 713 | 594 | 655 | 1088 | 1024 | 1085 | COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field |
|
185 | CS | 766 | 749 | 917 | 784 | 873 | 746 | 795 | 778 | 747 | 726 | 813 | 826 | 768 | 761 | 752 | 861 | 764 | 709 | 718 | 741 | 686 | 728 | 641 | 763 | 739 | 862 | 856 | 782 | 1464 | 1168 | 1312 | Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND |
|
186 | CS | 696 | 671 | 797 | 704 | 702 | 678 | 685 | 721 | 672 | 756 | 657 | 750 | 732 | 691 | 730 | 741 | 744 | 584 | 605 | 656 | 612 | 677 | 763 | 670 | 650 | 729 | 634 | 629 | 1240 | 1104 | 1112 | UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML |
|
187 | CS | 773 | 884 | 918 | 860 | 776 | 764 | 787 | 808 | 879 | 736 | 739 | 792 | 765 | 816 | 822 | 877 | 734 | 693 | 770 | 699 | 719 | 760 | 733 | 711 | 750 | 802 | 693 | 761 | 1150 | 1241 | 1265 | Efficient table scans for DBKEY-based range conditions |
|
188 | CS | 706 | 685 | 686 | 710 | 728 | 746 | 667 | 717 | 756 | 666 | 687 | 812 | 714 | 753 | 703 | 810 | 680 | 1073 | 959 | 647 | 612 | 677 | 610 | 598 | 649 | 733 | 574 | 644 | 1420 | 1184 | 1060 | SQL-level replication management |
|
189 | CS | 684 | 654 | 729 | 673 | 686 | 636 | 729 | 718 | 668 | 618 | 678 | 770 | 683 | 636 | 696 | 721 | 688 | 639 | 995 | 1040 | 1111 | 666 | 665 | 655 | 630 | 710 | 1159 | 627 | 1223 | 1181 | 565 | Incorrect query result when using named window |
|
190 | SS | 449 | 422 | 566 | 336 | 514 | 361 | 524 | 559 | 593 | 578 | 599 | 545 | 585 | 575 | 597 | 609 | 636 | 456 | 417 | 444 | 441 | 403 | 447 | 450 | 444 | 412 | 448 | 423 | 410 | 412 | 410 | Incorrect query result when using named window |
|
191 | CS | 700 | 710 | 651 | 738 | 758 | 632 | 762 | 683 | 635 | 681 | 660 | 595 | 715 | 705 | 687 | 590 | 704 | 1123 | 622 | 757 | 619 | 1251 | 730 | 628 | 603 | 696 | 1113 | 707 | 1193 | 1321 | 686 | Unexpected results after creating partial index |
|
192 | SS | 556 | 591 | 351 | 596 | 572 | 443 | 581 | 512 | 389 | 621 | 631 | 597 | 348 | 483 | 651 | 512 | 402 | 454 | 581 | 634 | 556 | 1029 | 471 | 557 | 657 | 513 | 541 | 353 | 380 | 664 | 591 | Unexpected results after creating partial index |
|
193 | CS | 850 | 767 | 857 | 907 | 869 | 783 | 834 | 832 | 827 | 833 | 818 | 805 | 868 | 844 | 825 | 867 | 895 | 1342 | 709 | 818 | 1332 | 887 | 1371 | 1313 | 1439 | 831 | 1350 | 808 | 803 | 1163 | 1340 | Simple derived table |
|
194 | SS | 639 | 675 | 811 | 740 | 475 | 662 | 548 | 408 | 718 | 534 | 454 | 657 | 635 | 545 | 453 | 712 | 634 | 692 | 431 | 732 | 611 | 532 | 643 | 784 | 588 | 546 | 745 | 502 | 728 | 668 | 772 | Simple derived table |
|
195 | CS | 858 | 842 | 900 | 894 | 854 | 918 | 792 | 960 | 831 | 853 | 818 | 905 | 851 | 861 | 908 | 846 | 855 | 1293 | 712 | 797 | 1417 | 899 | 1421 | 1384 | 1363 | 950 | 791 | 772 | 848 | 780 | 1406 | Unnamed (no relation alias) derived table |
|
196 | SS | 614 | 686 | 597 | 700 | 516 | 673 | 685 | 427 | 565 | 494 | 426 | 554 | 552 | 539 | 424 | 790 | 654 | 584 | 419 | 843 | 687 | 632 | 864 | 545 | 636 | 584 | 555 | 679 | 641 | 786 | 684 | Unnamed (no relation alias) derived table |
|
197 | CS | 850 | 768 | 941 | 977 | 902 | 824 | 841 | 816 | 849 | 913 | 819 | 841 | 787 | 808 | 851 | 856 | 905 | 1297 | 772 | 780 | 1466 | 963 | 1317 | 1284 | 1383 | 874 | 808 | 847 | 721 | 805 | 1345 | Explicit column names for derived table |
|
198 | SS | 627 | 646 | 801 | 703 | 455 | 623 | 613 | 526 | 669 | 516 | 455 | 607 | 527 | 572 | 435 | 526 | 677 | 767 | 457 | 724 | 773 | 538 | 781 | 684 | 784 | 562 | 740 | 620 | 766 | 644 | 631 | Explicit column names for derived table |
|
199 | CS | 873 | 848 | 925 | 828 | 890 | 869 | 793 | 836 | 845 | 924 | 844 | 785 | 863 | 878 | 850 | 906 | 851 | 1345 | 728 | 751 | 1316 | 1433 | 1271 | 1389 | 1371 | 929 | 735 | 1605 | 1438 | 811 | 1280 | Outer reference to upper scope-level is allowed |
|
200 | SS | 654 | 541 | 449 | 784 | 450 | 528 | 695 | 745 | 396 | 494 | 418 | 435 | 733 | 713 | 531 | 837 | 629 | 593 | 589 | 753 | 741 | 575 | 857 | 533 | 751 | 573 | 731 | 776 | 679 | 684 | 687 | Outer reference to upper scope-level is allowed |
|
201 | CS | 846 | 833 | 921 | 818 | 873 | 801 | 842 | 768 | 810 | 851 | 813 | 830 | 837 | 858 | 895 | 827 | 820 | 736 | 796 | 853 | 1327 | 1371 | 1280 | 1442 | 1352 | 892 | 788 | 1321 | 1250 | 823 | 1304 | Outer reference to upper scope-level is allowed |
|
202 | SS | 647 | 528 | 454 | 900 | 478 | 726 | 709 | 664 | 419 | 517 | 448 | 451 | 543 | 740 | 483 | 726 | 513 | 720 | 524 | 695 | 767 | 722 | 675 | 748 | 729 | 549 | 631 | 698 | 543 | 780 | 625 | Outer reference to upper scope-level is allowed |
|
203 | CS | 887 | 876 | 923 | 814 | 920 | 840 | 834 | 877 | 867 | 897 | 781 | 821 | 859 | 856 | 824 | 924 | 819 | 756 | 753 | 899 | 1360 | 1420 | 1352 | 1374 | 1321 | 913 | 856 | 1345 | 1355 | 1400 | 1408 | Outer reference to upper scope-level is allowed |
|
204 | SS | 612 | 592 | 519 | 733 | 505 | 542 | 596 | 523 | 418 | 459 | 419 | 513 | 576 | 672 | 471 | 883 | 439 | 789 | 719 | 699 | 633 | 727 | 654 | 685 | 617 | 562 | 660 | 616 | 726 | 683 | 609 | Outer reference to upper scope-level is allowed |
|
205 | CS | 891 | 838 | 925 | 876 | 873 | 852 | 771 | 806 | 894 | 798 | 880 | 889 | 796 | 866 | 881 | 897 | 826 | 1332 | 727 | 799 | 982 | 1340 | 1356 | 1295 | 1304 | 945 | 1263 | 1480 | 1388 | 1327 | 1528 | FIRST / SKIP inside derived table |
|
206 | SS | 652 | 820 | 619 | 759 | 467 | 632 | 502 | 617 | 538 | 533 | 413 | 442 | 672 | 708 | 463 | 731 | 430 | 722 | 686 | 577 | 540 | 831 | 867 | 769 | 682 | 562 | 697 | 570 | 739 | 712 | 696 | FIRST / SKIP inside derived table |
|
207 | CS | 883 | 906 | 903 | 900 | 893 | 788 | 834 | 865 | 854 | 814 | 837 | 803 | 862 | 859 | 874 | 819 | 873 | 1213 | 741 | 737 | 774 | 1385 | 1412 | 1265 | 1451 | 924 | 1265 | 1399 | 1469 | 1380 | 1608 | UNION inside derived table |
|
208 | SS | 644 | 715 | 753 | 578 | 468 | 604 | 698 | 702 | 580 | 464 | 417 | 607 | 624 | 648 | 508 | 640 | 435 | 756 | 702 | 775 | 720 | 798 | 703 | 553 | 724 | 583 | 683 | 769 | 555 | 589 | 665 | UNION inside derived table |
|
209 | CS | 888 | 904 | 878 | 879 | 898 | 838 | 816 | 916 | 834 | 853 | 844 | 833 | 811 | 818 | 863 | 860 | 794 | 1084 | 711 | 923 | 807 | 1299 | 1282 | 1302 | 1421 | 944 | 1433 | 1417 | 1548 | 1167 | 1403 | Simple derived table with aggregate inside |
|
210 | SS | 657 | 725 | 779 | 760 | 660 | 704 | 689 | 584 | 543 | 486 | 434 | 453 | 712 | 737 | 457 | 636 | 436 | 587 | 756 | 788 | 580 | 739 | 574 | 654 | 769 | 568 | 680 | 528 | 702 | 551 | 700 | Simple derived table with aggregate inside |
|
211 | CS | 861 | 799 | 855 | 842 | 867 | 780 | 835 | 804 | 851 | 816 | 811 | 887 | 900 | 908 | 846 | 872 | 853 | 1300 | 770 | 844 | 726 | 1364 | 1518 | 1326 | 1416 | 869 | 1498 | 1344 | 1408 | 814 | 1356 | Aggregate inside derived table |
|
212 | SS | 652 | 539 | 686 | 724 | 497 | 638 | 711 | 678 | 432 | 458 | 444 | 645 | 501 | 706 | 453 | 777 | 484 | 546 | 689 | 627 | 712 | 551 | 787 | 801 | 759 | 580 | 862 | 651 | 733 | 720 | 653 | Aggregate inside derived table |
|
213 | CS | 869 | 814 | 909 | 827 | 875 | 880 | 848 | 795 | 847 | 852 | 792 | 859 | 838 | 860 | 854 | 880 | 883 | 1279 | 850 | 760 | 791 | 1016 | 1448 | 1267 | 1310 | 946 | 1355 | 1316 | 1308 | 863 | 1559 | Aggregate inside derived table |
|
214 | SS | 660 | 693 | 740 | 591 | 473 | 706 | 669 | 606 | 440 | 488 | 449 | 450 | 612 | 473 | 477 | 779 | 562 | 690 | 723 | 759 | 840 | 773 | 560 | 832 | 679 | 652 | 617 | 728 | 726 | 692 | 515 | Aggregate inside derived table |
|
215 | CS | 879 | 823 | 844 | 871 | 880 | 898 | 823 | 851 | 825 | 851 | 834 | 973 | 878 | 854 | 808 | 819 | 813 | 1333 | 1044 | 784 | 797 | 1147 | 1455 | 1378 | 1434 | 1007 | 1471 | 1458 | 1257 | 1054 | 1357 | Sub-select inside derived table |
|
216 | SS | 628 | 605 | 560 | 625 | 438 | 660 | 763 | 680 | 413 | 525 | 432 | 470 | 517 | 437 | 441 | 723 | 450 | 767 | 645 | 663 | 732 | 632 | 762 | 740 | 765 | 577 | 688 | 661 | 653 | 569 | 544 | Sub-select inside derived table |
|
217 | CS | 872 | 788 | 854 | 892 | 873 | 773 | 869 | 717 | 854 | 789 | 829 | 822 | 832 | 871 | 882 | 844 | 792 | 1292 | 1216 | 834 | 781 | 1328 | 1369 | 1295 | 1432 | 956 | 1259 | 1222 | 1246 | 1271 | 1517 | Sub-select inside derived table |
|
218 | SS | 626 | 509 | 724 | 611 | 434 | 695 | 599 | 719 | 448 | 486 | 435 | 481 | 538 | 451 | 451 | 697 | 424 | 739 | 439 | 814 | 641 | 524 | 756 | 659 | 773 | 558 | 713 | 792 | 720 | 749 | 760 | Sub-select inside derived table |
|
219 | CS | 882 | 869 | 928 | 879 | 908 | 803 | 777 | 825 | 885 | 838 | 868 | 846 | 816 | 845 | 846 | 876 | 823 | 1069 | 1384 | 720 | 774 | 1373 | 1371 | 1332 | 1340 | 996 | 1355 | 1293 | 1032 | 1159 | 1282 | Implicit derived table by IN predicate |
|
220 | SS | 649 | 642 | 657 | 738 | 431 | 717 | 757 | 507 | 440 | 468 | 449 | 452 | 590 | 718 | 441 | 741 | 430 | 666 | 391 | 735 | 624 | 744 | 687 | 708 | 770 | 563 | 725 | 667 | 900 | 543 | 592 | Implicit derived table by IN predicate |
|
221 | CS | 882 | 899 | 876 | 892 | 858 | 829 | 854 | 833 | 902 | 846 | 883 | 915 | 882 | 839 | 841 | 855 | 845 | 764 | 1204 | 792 | 810 | 957 | 1419 | 1353 | 1372 | 926 | 1346 | 1387 | 1296 | 786 | 1357 | Derived table outer reference (triggers) |
|
222 | SS | 649 | 690 | 670 | 754 | 447 | 668 | 647 | 614 | 442 | 455 | 438 | 480 | 570 | 694 | 492 | 712 | 474 | 617 | 444 | 814 | 723 | 768 | 652 | 861 | 645 | 599 | 746 | 741 | 771 | 588 | 697 | Derived table outer reference (triggers) |
|
223 | CS | 860 | 867 | 865 | 824 | 869 | 835 | 854 | 792 | 890 | 885 | 829 | 865 | 829 | 911 | 870 | 850 | 903 | 749 | 869 | 763 | 771 | 842 | 847 | 821 | 782 | 961 | 1355 | 855 | 1348 | 1321 | 1081 | Non-Recursive CTEs |
|
224 | SS | 646 | 612 | 644 | 710 | 727 | 502 | 632 | 439 | 571 | 808 | 761 | 655 | 536 | 437 | 668 | 694 | 716 | 711 | 438 | 726 | 749 | 465 | 848 | 651 | 649 | 542 | 684 | 472 | 529 | 565 | 603 | Non-Recursive CTEs |
|
225 | CS | 868 | 884 | 899 | 860 | 850 | 990 | 876 | 874 | 848 | 867 | 865 | 738 | 906 | 807 | 845 | 910 | 883 | 690 | 874 | 816 | 788 | 870 | 982 | 773 | 733 | 967 | 1240 | 848 | 1479 | 1540 | 835 | Recursive CTEs |
|
226 | SS | 634 | 485 | 795 | 749 | 662 | 449 | 584 | 574 | 493 | 735 | 815 | 760 | 807 | 493 | 737 | 710 | 640 | 628 | 414 | 642 | 753 | 521 | 766 | 684 | 862 | 601 | 617 | 414 | 598 | 513 | 548 | Recursive CTEs |
|
227 | CS | 870 | 893 | 862 | 826 | 924 | 822 | 839 | 805 | 806 | 883 | 769 | 914 | 921 | 913 | 883 | 836 | 879 | 720 | 838 | 757 | 757 | 1363 | 879 | 780 | 835 | 890 | 1337 | 879 | 1377 | 1493 | 843 | MERGE statement |
|
228 | SS | 646 | 564 | 763 | 437 | 738 | 400 | 556 | 468 | 576 | 655 | 745 | 857 | 734 | 631 | 745 | 746 | 782 | 539 | 637 | 772 | 660 | 816 | 812 | 763 | 819 | 571 | 559 | 425 | 396 | 539 | 566 | MERGE statement |
|
229 | CS | 806 | 885 | 799 | 748 | 839 | 743 | 841 | 813 | 769 | 778 | 694 | 720 | 728 | 847 | 846 | 719 | 712 | 1240 | 836 | 657 | 1152 | 710 | 945 | 1394 | 1213 | 906 | 1185 | 689 | 757 | 753 | 1220 | Computed fields |
|
230 | SS | 662 | 712 | 878 | 678 | 456 | 656 | 616 | 697 | 724 | 688 | 656 | 717 | 890 | 614 | 789 | 745 | 669 | 432 | 700 | 772 | 472 | 555 | 753 | 550 | 449 | 581 | 717 | 454 | 591 | 397 | 415 | Computed fields |
|
231 | CS | 1288 | 1335 | 1305 | 1253 | 1412 | 1127 | 1181 | 1236 | 1272 | 1182 | 1172 | 1328 | 1239 | 1314 | 1255 | 1356 | 1377 | 1689 | 1187 | 1340 | 1191 | 1849 | 1889 | 1838 | 1747 | 1306 | 1692 | 1152 | 955 | 994 | 979 | gtcs-proc-isql-11 |
|
232 | SS | 945 | 920 | 895 | 554 | 760 | 671 | 703 | 795 | 987 | 993 | 939 | 967 | 1035 | 1030 | 1003 | 808 | 1085 | 800 | 951 | 928 | 952 | 1049 | 1098 | 841 | 1060 | 817 | 989 | 1004 | 1032 | 764 | 524 | gtcs-proc-isql-11 |
|
233 | CS | 1264 | 1195 | 1460 | 1264 | 1371 | 1250 | 1281 | 1429 | 1214 | 1280 | 1240 | 1342 | 1251 | 1220 | 1265 | 1245 | 1246 | 1596 | 1151 | 1323 | 1001 | 1464 | 2497 | 1832 | 1685 | 1430 | 1495 | 942 | 955 | 994 | 1013 | gtcs-proc-isql-15 |
|
234 | SS | 910 | 527 | 988 | 568 | 648 | 686 | 971 | 719 | 850 | 1076 | 817 | 1084 | 934 | 1076 | 960 | 1109 | 1061 | 887 | 945 | 1024 | 768 | 1018 | 1057 | 976 | 824 | 847 | 1132 | 793 | 522 | 716 | 562 | gtcs-proc-isql-15 |
|
235 | CS | 1242 | 1168 | 1204 | 1239 | 1391 | 1251 | 1214 | 1373 | 1199 | 1199 | 1164 | 1255 | 1282 | 1215 | 1450 | 1241 | 1198 | 1221 | 1240 | 1271 | 928 | 1691 | 1789 | 1608 | 1779 | 1266 | 1828 | 1488 | 1243 | 1196 | 1003 | gtcs-proc-isql-16 |
|
236 | SS | 951 | 546 | 1088 | 601 | 673 | 670 | 1037 | 903 | 902 | 1000 | 1084 | 986 | 987 | 777 | 978 | 965 | 1056 | 945 | 957 | 944 | 816 | 1084 | 929 | 1060 | 1106 | 792 | 1136 | 1074 | 554 | 724 | 602 | gtcs-proc-isql-16 |
|
237 | CS | 1255 | 1190 | 1287 | 1242 | 1286 | 1228 | 1218 | 1255 | 1301 | 1201 | 1255 | 1216 | 1283 | 1225 | 1308 | 1304 | 1340 | 926 | 1243 | 1339 | 1875 | 1182 | 1716 | 2033 | 1707 | 1389 | 1050 | 1145 | 1448 | 1079 | 1016 | Test for select from SP that deletes record after its output |
|
238 | SS | 965 | 916 | 970 | 660 | 856 | 792 | 964 | 1016 | 1067 | 976 | 612 | 966 | 927 | 972 | 882 | 988 | 847 | 945 | 977 | 779 | 1010 | 1035 | 992 | 1080 | 925 | 837 | 1049 | 1042 | 982 | 847 | 949 | Test for select from SP that deletes record after its output |
|
239 | CS | 698 | 684 | 729 | 738 | 698 | 601 | 772 | 697 | 655 | 683 | 734 | 713 | 698 | 671 | 674 | 670 | 760 | 1075 | 730 | 749 | 1146 | 673 | 1194 | 1094 | 608 | 749 | 628 | 621 | 633 | 763 | 555 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
240 | SS | 618 | 431 | 609 | 328 | 623 | 482 | 634 | 618 | 512 | 624 | 669 | 646 | 647 | 654 | 596 | 577 | 446 | 546 | 534 | 657 | 618 | 606 | 668 | 677 | 707 | 463 | 576 | 670 | 628 | 364 | 723 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
241 | CS | 840 | 812 | 842 | 794 | 892 | 968 | 833 | 870 | 906 | 844 | 838 | 838 | 848 | 796 | 922 | 804 | 930 | 774 | 917 | 858 | 865 | 938 | 809 | 816 | 741 | 929 | 909 | 829 | 777 | 776 | 762 | COUNT |
|
242 | SS | 668 | 551 | 756 | 444 | 633 | 680 | 692 | 756 | 568 | 532 | 551 | 774 | 541 | 567 | 740 | 724 | 737 | 744 | 645 | 601 | 710 | 751 | 760 | 657 | 803 | 540 | 653 | 751 | 624 | 681 | 425 | COUNT |
|
243 | CS | 672 | 642 | 704 | 659 | 1024 | 730 | 628 | 654 | 650 | 654 | 669 | 599 | 674 | 679 | 672 | 649 | 643 | 736 | 628 | 672 | 740 | 782 | 1064 | 689 | 616 | 701 | 683 | 1162 | 625 | 713 | 666 | EXTRACT(WEEK FROM DATE) |
|
244 | SS | 483 | 447 | 572 | 309 | 615 | 535 | 478 | 375 | 393 | 586 | 334 | 460 | 621 | 459 | 439 | 558 | 508 | 439 | 590 | 668 | 447 | 531 | 548 | 567 | 474 | 436 | 401 | 538 | 564 | 447 | 489 | EXTRACT(WEEK FROM DATE) |
|
245 | CS | 691 | 675 | 681 | 722 | 724 | 643 | 656 | 657 | 756 | 683 | 734 | 700 | 636 | 632 | 657 | 643 | 663 | 741 | 665 | 642 | 736 | 742 | 1091 | 1050 | 705 | 708 | 702 | 1109 | 631 | 1040 | 653 | TRUNC( <number> [, <number> ] ) |
|
246 | SS | 513 | 493 | 573 | 346 | 432 | 386 | 548 | 537 | 315 | 538 | 483 | 338 | 581 | 481 | 476 | 593 | 586 | 565 | 484 | 648 | 604 | 568 | 654 | 488 | 534 | 427 | 429 | 379 | 565 | 621 | 423 | TRUNC( <number> [, <number> ] ) |
|
247 | CS | 711 | 805 | 713 | 736 | 715 | 685 | 665 | 645 | 662 | 662 | 734 | 735 | 691 | 731 | 677 | 622 | 733 | 674 | 619 | 710 | 676 | 777 | 732 | 1192 | 682 | 709 | 627 | 1059 | 1062 | 1140 | 1075 | POSITION( <string> IN <string> ) |
|
248 | SS | 562 | 513 | 572 | 299 | 572 | 541 | 302 | 408 | 563 | 476 | 408 | 592 | 576 | 320 | 563 | 500 | 540 | 512 | 708 | 708 | 575 | 574 | 562 | 566 | 592 | 462 | 552 | 604 | 591 | 678 | 554 | POSITION( <string> IN <string> ) |
|
249 | CS | 696 | 664 | 715 | 617 | 711 | 655 | 619 | 650 | 605 | 696 | 669 | 639 | 624 | 622 | 711 | 696 | 676 | 707 | 680 | 715 | 696 | 710 | 1189 | 1164 | 716 | 688 | 795 | 1101 | 1007 | 1101 | 1076 | Test for TRUNC function |
|
250 | SS | 519 | 611 | 471 | 339 | 454 | 511 | 423 | 512 | 445 | 576 | 433 | 492 | 530 | 413 | 467 | 517 | 458 | 572 | 548 | 718 | 606 | 528 | 657 | 521 | 620 | 436 | 584 | 608 | 618 | 494 | 558 | Test for TRUNC function |
|
251 | CS | 2876 | 2876 | 3169 | 2806 | 3144 | 2844 | 2787 | 2817 | 2832 | 2899 | 2771 | 2816 | 2780 | 2876 | 2943 | 2678 | 2853 | 2930 | 2782 | 2942 | 2789 | 3054 | 3171 | 2873 | 3027 | 3116 | 3009 | 2998 | 4319 | 4600 | 2639 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
252 | SS | 1837 | 1837 | 2016 | 1003 | 1835 | 1823 | 1548 | 1743 | 1821 | 1867 | 1764 | 2017 | 1838 | 1883 | 1828 | 2008 | 1858 | 2008 | 2089 | 1774 | 2097 | 1879 | 2001 | 1948 | 1885 | 1551 | 1800 | 1735 | 2000 | 1812 | 1037 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
253 | CS | 29818 | 29684 | 30182 | 30046 | 30071 | 29694 | 29626 | 29699 | 29693 | 29613 | 29576 | 29702 | 29684 | 29459 | 29922 | 29816 | 29913 | 29962 | 29821 | 29714 | 29883 | 29950 | 29919 | 29870 | 29850 | 29992 | 30153 | 29870 | 29495 | 29409 | 29373 | External Connections Pool, functionality test 01 |
|
254 | SS | 27939 | 27989 | 28260 | 28049 | 28202 | 27914 | 27993 | 27851 | 28069 | 27855 | 27965 | 28201 | 28123 | 27897 | 28347 | 27238 | 28118 | 27764 | 27702 | 27856 | 27580 | 27866 | 27505 | 27735 | 27791 | 27808 | 28119 | 28066 | 27420 | 28013 | 27995 | External Connections Pool, functionality test 01 |
|
255 | CS | 1330 | 1326 | 1305 | 1228 | 1345 | 1386 | 1322 | 1284 | 1246 | 1406 | 1337 | 1273 | 1393 | 1283 | 1296 | 1378 | 1305 | 1297 | 1327 | 1370 | 1313 | 1383 | 1432 | 1374 | 1335 | 1334 | 1325 | 1452 | 1418 | 1298 | 1353 | Common SQL. Check correctness of the results |
|
256 | SS | 1091 | 1103 | 650 | 1228 | 1208 | 1108 | 1102 | 1151 | 1092 | 892 | 639 | 1028 | 636 | 1091 | 951 | 618 | 945 | 930 | 1080 | 1139 | 1130 | 1210 | 1090 | 1129 | 924 | 954 | 1255 | 1180 | 1099 | 1072 | 1128 | Common SQL. Check correctness of the results |
|
257 | CS | 1354 | 1266 | 1329 | 1354 | 1508 | 1329 | 1389 | 1338 | 1274 | 1339 | 1167 | 1246 | 1265 | 1402 | 1352 | 1210 | 1326 | 1398 | 1463 | 1472 | 1419 | 1464 | 1558 | 1522 | 1550 | 1390 | 1295 | 1354 | 1436 | 1314 | 1521 | Common SQL. Check correctness of the results |
|
258 | SS | 1025 | 992 | 623 | 912 | 1215 | 740 | 1004 | 810 | 642 | 1038 | 656 | 1099 | 597 | 929 | 1253 | 688 | 907 | 1217 | 872 | 1268 | 1009 | 1346 | 1233 | 1421 | 1095 | 1013 | 1217 | 1265 | 1198 | 1165 | 1109 | Common SQL. Check correctness of the results |
|
259 | CS | 925 | 873 | 964 | 941 | 999 | 942 | 951 | 831 | 863 | 958 | 842 | 919 | 888 | 932 | 965 | 863 | 840 | 823 | 915 | 943 | 959 | 892 | 888 | 991 | 912 | 915 | 864 | 932 | 995 | 993 | 973 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
260 | SS | 664 | 772 | 476 | 824 | 852 | 765 | 452 | 767 | 611 | 494 | 468 | 556 | 581 | 487 | 635 | 456 | 473 | 820 | 862 | 776 | 780 | 699 | 616 | 693 | 830 | 611 | 763 | 795 | 478 | 478 | 703 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
261 | CS | 7379 | 7999 | 3888 | 3873 | 7437 | 7144 | 7290 | 7258 | 7179 | 7293 | 7189 | 7277 | 7293 | 7290 | 7362 | 7122 | 8334 | 7372 | 7396 | 7552 | 7467 | 7622 | 7558 | 7401 | 7386 | 7504 | 7328 | 7453 | 7557 | 7434 | 7456 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
262 | SS | 6824 | 6458 | 3095 | 3653 | 6701 | 6836 | 6752 | 6604 | 6360 | 7433 | 6812 | 6771 | 5959 | 6965 | 6432 | 5951 | 6030 | 6720 | 6982 | 6959 | 6854 | 7277 | 7104 | 7163 | 6859 | 6650 | 6863 | 7040 | 7296 | 7351 | 7080 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
263 | CS | 7252 | 7266 | 3768 | 3908 | 7259 | 7037 | 7162 | 7269 | 7217 | 7291 | 7219 | 7209 | 7224 | 7173 | 7246 | 7071 | 7138 | 7224 | 7346 | 7358 | 7431 | 7275 | 7458 | 7418 | 7297 | 7434 | 7219 | 7504 | 7329 | 7419 | 7235 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
264 | SS | 6637 | 6670 | 3060 | 3460 | 6577 | 6645 | 6313 | 6572 | 6692 | 5965 | 6612 | 6629 | 5966 | 6623 | 5912 | 5912 | 5962 | 7033 | 6947 | 6866 | 6742 | 6892 | 6868 | 6814 | 6676 | 6451 | 6799 | 6911 | 7015 | 7296 | 6356 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
265 | CS | 7417 | 7309 | 3892 | 3875 | 7472 | 7171 | 7279 | 7306 | 7241 | 7247 | 7248 | 7354 | 7417 | 7480 | 7416 | 7393 | 7374 | 7495 | 7445 | 7451 | 7470 | 7471 | 7494 | 7554 | 7417 | 7464 | 7547 | 7500 | 7613 | 7403 | 7532 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
266 | SS | 6645 | 6921 | 3146 | 3468 | 6839 | 6639 | 6127 | 6823 | 6600 | 5968 | 6652 | 7368 | 5851 | 6501 | 6221 | 6074 | 6036 | 6543 | 6593 | 6991 | 6441 | 6791 | 6849 | 6806 | 6996 | 6299 | 7112 | 6957 | 6880 | 6665 | 6654 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
267 | CS | 53656 | 52745 | 4268 | 4145 | 53937 | 51640 | 53349 | 52336 | 52187 | 52296 | 52195 | 52582 | 52500 | 52336 | 52818 | 53504 | 52982 | 53808 | 54937 | 53809 | 54444 | 56098 | 55182 | 56316 | 53867 | 55407 | 54807 | 54190 | 54691 | 54449 | 54308 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
268 | SS | 51259 | 50903 | 3283 | 3779 | 52197 | 50178 | 48983 | 48341 | 48888 | 43103 | 48638 | 51616 | 44388 | 49773 | 50040 | 46143 | 43149 | 53231 | 54122 | 54958 | 53187 | 54660 | 53827 | 53847 | 53933 | 49198 | 52012 | 53684 | 54157 | 54107 | 51618 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
269 | CS | 7277 | 7190 | 3915 | 3822 | 7243 | 7297 | 7178 | 7153 | 7258 | 7215 | 7244 | 7154 | 7219 | 7165 | 7370 | 7193 | 7208 | 7218 | 7343 | 7314 | 7318 | 7343 | 7438 | 7375 | 7364 | 7494 | 11296 | 7350 | 7341 | 7350 | 7506 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
270 | SS | 6657 | 6540 | 3116 | 3363 | 6694 | 5922 | 6377 | 6355 | 6776 | 5988 | 6450 | 6248 | 6644 | 5966 | 6157 | 6626 | 5985 | 7256 | 6779 | 6709 | 6949 | 6762 | 6942 | 6809 | 7042 | 6548 | 6672 | 6679 | 6670 | 6867 | 6946 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
271 | CS | 7272 | 7173 | 3905 | 3812 | 7233 | 7134 | 7112 | 7087 | 7239 | 7171 | 7223 | 7205 | 7267 | 7316 | 7327 | 7151 | 7173 | 7294 | 7501 | 7429 | 7322 | 7316 | 7450 | 8260 | 7457 | 7533 | 7441 | 7360 | 7278 | 8255 | 7241 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
272 | SS | 6729 | 6661 | 3071 | 3560 | 6378 | 5978 | 6780 | 7122 | 6817 | 6028 | 6640 | 6665 | 6597 | 6309 | 5971 | 6563 | 6056 | 8225 | 6863 | 6936 | 6897 | 6740 | 6806 | 6985 | 6903 | 6280 | 6836 | 6837 | 6763 | 6911 | 6718 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
273 | CS | 7714 | 7573 | 4035 | 3990 | 7673 | 7628 | 7496 | 7732 | 7570 | 7582 | 7569 | 7715 | 7713 | 7598 | 7652 | 7624 | 7628 | 7828 | 7786 | 7827 | 7728 | 7747 | 7820 | 8727 | 7742 | 7995 | 8859 | 7864 | 7748 | 7766 | 7575 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
274 | SS | 7019 | 7031 | 3210 | 3295 | 6265 | 6970 | 7066 | 6150 | 6875 | 6124 | 6520 | 7054 | 6724 | 7055 | 6293 | 7234 | 6336 | 6908 | 7264 | 7529 | 7014 | 7206 | 7288 | 7147 | 7259 | 6745 | 7032 | 6837 | 7024 | 7122 | 7192 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
275 | CS | 7254 | 7109 | 3891 | 3770 | 7230 | 7179 | 7241 | 7274 | 7152 | 7256 | 7168 | 7277 | 7225 | 7189 | 7241 | 7169 | 7259 | 7231 | 7252 | 7534 | 7211 | 7418 | 7310 | 7367 | 7464 | 7536 | 7456 | 7309 | 7400 | 7409 | 7418 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
276 | SS | 6727 | 6587 | 3131 | 3038 | 7443 | 6472 | 6814 | 6028 | 6114 | 5939 | 6268 | 6772 | 5923 | 6740 | 5975 | 6876 | 5960 | 6047 | 6985 | 7215 | 7002 | 6848 | 7547 | 6808 | 6640 | 6584 | 6867 | 6715 | 6814 | 7077 | 6785 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
277 | CS | 7272 | 7271 | 3770 | 3807 | 7321 | 7153 | 7114 | 7143 | 7193 | 7272 | 7090 | 7189 | 7171 | 7304 | 7263 | 7076 | 7158 | 7272 | 8373 | 7384 | 7304 | 7367 | 7360 | 7187 | 7331 | 7436 | 7476 | 7352 | 7302 | 7317 | 7343 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
278 | SS | 6738 | 6664 | 3050 | 3089 | 6788 | 7481 | 6636 | 6922 | 6514 | 5920 | 6436 | 6565 | 5903 | 6458 | 5917 | 6696 | 5928 | 6872 | 7178 | 6908 | 6781 | 6841 | 6938 | 6943 | 6936 | 6440 | 6890 | 6591 | 6800 | 6911 | 6811 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
279 | CS | 7267 | 7276 | 3945 | 3794 | 7361 | 7190 | 7202 | 7250 | 7176 | 7072 | 7223 | 7088 | 7207 | 7114 | 7258 | 7250 | 7268 | 7267 | 7511 | 7388 | 7203 | 7478 | 7341 | 7366 | 7429 | 7337 | 7524 | 7322 | 7335 | 7330 | 7323 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
280 | SS | 6762 | 6682 | 3098 | 3056 | 6669 | 7418 | 6776 | 5971 | 5941 | 5917 | 5944 | 6760 | 5955 | 6814 | 6027 | 6525 | 5931 | 6481 | 7242 | 7284 | 6764 | 7129 | 7143 | 6917 | 6871 | 6417 | 6835 | 6870 | 6822 | 6924 | 7020 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
281 | CS | 7689 | 7649 | 4177 | 3987 | 7718 | 7622 | 7588 | 7419 | 7684 | 7625 | 7603 | 7745 | 7558 | 7575 | 7705 | 7558 | 7684 | 7579 | 8833 | 7694 | 7721 | 7756 | 7897 | 7883 | 7786 | 7966 | 7880 | 7914 | 7622 | 7807 | 7821 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
282 | SS | 7038 | 6880 | 3309 | 3163 | 6703 | 7045 | 7222 | 6184 | 6223 | 6172 | 6213 | 7032 | 6482 | 6652 | 6220 | 7243 | 6217 | 7209 | 7139 | 7280 | 7249 | 7239 | 7356 | 7221 | 7101 | 6792 | 7249 | 6987 | 7079 | 7121 | 7327 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
283 | CS | 7317 | 7270 | 3800 | 3730 | 7268 | 7165 | 7170 | 7098 | 7306 | 7345 | 7079 | 7173 | 7137 | 7169 | 7383 | 7124 | 7265 | 7369 | 7337 | 7348 | 7406 | 7260 | 7391 | 7360 | 7379 | 7405 | 8371 | 7399 | 7428 | 7329 | 7488 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
284 | SS | 6794 | 7166 | 3088 | 3133 | 7005 | 6635 | 6280 | 5939 | 5948 | 5916 | 6042 | 6096 | 5893 | 6456 | 5974 | 6879 | 7000 | 6989 | 6949 | 7165 | 6784 | 6795 | 7000 | 6899 | 6793 | 6496 | 6932 | 6850 | 7060 | 7084 | 6915 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
285 | CS | 7300 | 7182 | 3897 | 3815 | 7419 | 7028 | 7223 | 7240 | 7209 | 7374 | 7241 | 7212 | 7143 | 7285 | 8178 | 7201 | 7229 | 7350 | 7275 | 8309 | 7288 | 7312 | 7346 | 7441 | 7501 | 7427 | 7389 | 7345 | 7400 | 7381 | 7382 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
286 | SS | 6520 | 7003 | 3077 | 3126 | 6631 | 6390 | 5937 | 5924 | 5914 | 5945 | 5960 | 6489 | 5955 | 6484 | 5935 | 6485 | 5936 | 6849 | 6764 | 7111 | 6828 | 6988 | 7072 | 6972 | 7033 | 6494 | 6546 | 6853 | 7064 | 6663 | 6858 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
287 | CS | 7362 | 7137 | 3860 | 3945 | 7327 | 7244 | 7157 | 7292 | 7200 | 7377 | 7357 | 7270 | 7309 | 7217 | 7386 | 7216 | 7427 | 7419 | 7346 | 8327 | 7557 | 7368 | 7417 | 7467 | 7451 | 7515 | 8408 | 7477 | 8360 | 7357 | 7390 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
288 | SS | 6646 | 6779 | 3147 | 3094 | 6817 | 6643 | 5954 | 5944 | 5990 | 5959 | 6067 | 6083 | 6015 | 5944 | 6055 | 6812 | 5980 | 6649 | 6121 | 6928 | 6868 | 6776 | 7013 | 8048 | 6993 | 6698 | 7026 | 6639 | 6780 | 6924 | 6964 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
289 | CS | 7394 | 8114 | 3998 | 3861 | 8325 | 7297 | 7280 | 8290 | 7265 | 7254 | 7250 | 7231 | 8116 | 7291 | 7296 | 7222 | 7395 | 7359 | 7262 | 7512 | 7358 | 8347 | 7513 | 7556 | 7398 | 7676 | 7448 | 8321 | 7463 | 7394 | 7420 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
290 | SS | 6622 | 6659 | 3472 | 3092 | 6850 | 6735 | 5999 | 5966 | 5938 | 6028 | 6006 | 6003 | 6157 | 5967 | 5825 | 6808 | 5984 | 6415 | 6586 | 6805 | 6876 | 7317 | 7283 | 6728 | 7108 | 6474 | 7110 | 6954 | 6995 | 7140 | 7245 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
291 | CS | 7314 | 7141 | 3911 | 3834 | 7252 | 7185 | 7051 | 7116 | 7130 | 7378 | 7183 | 7238 | 8316 | 7160 | 7380 | 7234 | 7476 | 7354 | 7371 | 7462 | 7286 | 7312 | 7314 | 7339 | 7459 | 7644 | 7439 | 7357 | 7416 | 7315 | 7477 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
292 | SS | 6606 | 6620 | 3327 | 3084 | 6701 | 6701 | 5904 | 5968 | 5944 | 5927 | 5928 | 6047 | 6028 | 5966 | 6105 | 6881 | 5947 | 6556 | 6593 | 6995 | 6765 | 7108 | 6999 | 7016 | 6744 | 6555 | 7222 | 6963 | 6957 | 7111 | 6944 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
293 | CS | 879 | 854 | 938 | 813 | 910 | 867 | 808 | 807 | 774 | 818 | 861 | 848 | 902 | 916 | 974 | 848 | 860 | 849 | 899 | 902 | 882 | 904 | 928 | 876 | 910 | 929 | 942 | 914 | 886 | 829 | 854 | CREATE VIEW |
|
294 | SS | 588 | 420 | 429 | 547 | 749 | 768 | 403 | 445 | 495 | 533 | 437 | 476 | 764 | 590 | 487 | 506 | 430 | 501 | 697 | 460 | 753 | 628 | 792 | 620 | 670 | 586 | 699 | 703 | 675 | 730 | 859 | CREATE VIEW |