NN | Test name | mode |
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.858
|
6.0.0.854
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 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 | P | P | Index bug |
|
2 | SS | 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 | P | P | Index bug |
|
3 | CS | 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 | P | P | Blob comparison with constant |
|
4 | SS | 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 | P | P | Blob comparison with constant |
|
5 | CS | F | P | P | P | P | P | P | P | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Tricky role defeats basic SQL security |
|
6 | SS | F | P | P | P | P | P | P | P | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Tricky role defeats basic SQL security |
|
7 | CS | 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 | P | P | ORDER BY on a VIEW turns values in fields into NULL |
|
8 | SS | 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 | P | P | ORDER BY on a VIEW turns values in fields into NULL |
|
9 | CS | 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 | P | P | Incorrect handling of null within view - returns 0 |
|
10 | SS | 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 | P | P | Incorrect handling of null within view - returns 0 |
|
11 | CS | 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 | P | P | New value of column is accessable before update |
|
12 | SS | 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 | P | P | New value of column is accessable before update |
|
13 | CS | 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 | P | P | Incorrect results when left join on subquery with constant column |
|
14 | SS | 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 | P | P | Incorrect results when left join on subquery with constant column |
|
15 | CS | 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 | P | P | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
16 | SS | 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 | P | P | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
17 | CS | 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 | P | P | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
18 | SS | 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 | P | P | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
19 | CS | 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 | P | P | Estonian collation in UTF8 charset |
|
20 | SS | 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 | P | P | Estonian collation in UTF8 charset |
|
21 | CS | 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 | P | P | LIKE doesn't work for computed values (at least in a view) |
|
22 | SS | 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 | P | P | LIKE doesn't work for computed values (at least in a view) |
|
23 | CS | 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 | P | P | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
24 | SS | 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 | P | P | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
25 | CS | 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 | P | P | Long SQL statements break TCP/IP connection |
|
26 | SS | 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 | P | P | Long SQL statements break TCP/IP connection |
|
27 | CS | 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 | P | P | LIST() function seems not work if used twice or more in a query |
|
28 | SS | 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 | P | P | LIST() function seems not work if used twice or more in a query |
|
29 | CS | 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 | P | P | Incorrect column values with outer joins and views |
|
30 | SS | 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 | P | P | Incorrect column values with outer joins and views |
|
31 | CS | 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 | P | P | Incorrect column values with outer joins and derived tables |
|
32 | SS | 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 | P | P | Incorrect column values with outer joins and derived tables |
|
33 | CS | 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 | P | P | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
34 | SS | 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 | P | P | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
35 | CS | 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 | P | P | Joins with NULL RDB$DB_KEY crash the server |
|
36 | SS | 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 | P | P | Joins with NULL RDB$DB_KEY crash the server |
|
37 | CS | 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 | P | P | French insensitive collation FR_FR_CI_AI |
|
38 | SS | 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 | P | P | French insensitive collation FR_FR_CI_AI |
|
39 | CS | 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 | P | P | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
40 | SS | 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 | P | P | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
41 | CS | 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 | P | P | Collation not propagated between record formats |
|
42 | SS | 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 | P | P | Collation not propagated between record formats |
|
43 | CS | 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 | P | P | DATEADD wrong work with NULL arguments |
|
44 | SS | 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 | P | P | DATEADD wrong work with NULL arguments |
|
45 | CS | 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 | P | P | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
46 | SS | 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 | P | P | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
47 | CS | 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 | P | P | POSITION(string_exp1, string_exp2 [, start]) |
|
48 | SS | 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 | P | P | POSITION(string_exp1, string_exp2 [, start]) |
|
49 | CS | 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 | P | P | JOIN on first record of ordered derived table returns wrong record |
|
50 | SS | 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 | P | P | JOIN on first record of ordered derived table returns wrong record |
|
51 | CS | 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 | P | P | ABS() rounds NUMERIC values |
|
52 | SS | 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 | P | P | ABS() rounds NUMERIC values |
|
53 | CS | 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 | P | P | MERGE not correctly worked with parameters in MATCHING clause |
|
54 | SS | 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 | P | P | MERGE not correctly worked with parameters in MATCHING clause |
|
55 | CS | 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 | P | P | AV when recursive query used MERGE JOIN in execution plan |
|
56 | SS | 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 | P | P | AV when recursive query used MERGE JOIN in execution plan |
|
57 | CS | 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 | P | P | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
58 | SS | 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 | P | P | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
59 | CS | 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 | P | P | Floor & ceiling functions give wrong results with exact numeric arguments |
|
60 | SS | 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 | P | P | Floor & ceiling functions give wrong results with exact numeric arguments |
|
61 | CS | 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 | P | P | Wrong variable initialization in recursive procedures |
|
62 | SS | 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 | P | P | Wrong variable initialization in recursive procedures |
|
63 | CS | 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 | P | P | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
64 | SS | 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 | P | P | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
65 | CS | 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 | P | P | Consistency check when subquery is ordered by aggregate function from other context |
|
66 | SS | 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 | P | P | Consistency check when subquery is ordered by aggregate function from other context |
|
67 | CS | 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 | P | P | DEFAULT values are unnecessary evaluated |
|
68 | SS | 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 | P | P | DEFAULT values are unnecessary evaluated |
|
69 | CS | 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 | P | P | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
70 | SS | 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 | P | P | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
71 | CS | 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 | P | P | Null in the first record in a condition on rdb$db_key |
|
72 | SS | 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 | P | P | Null in the first record in a condition on rdb$db_key |
|
73 | CS | 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 | P | P | update or insert with gen_id() with wrong generator value |
|
74 | SS | 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 | P | P | update or insert with gen_id() with wrong generator value |
|
75 | CS | 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 | P | P | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
76 | SS | 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 | P | P | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
77 | CS | 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 | P | P | GROUP by and RDB$DB_KEY problems |
|
78 | SS | 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 | P | P | GROUP by and RDB$DB_KEY problems |
|
79 | CS | 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 | P | P | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
80 | SS | 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 | P | P | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
81 | CS | 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 | P | P | Grouping by function doesn't work properly |
|
82 | SS | 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 | P | P | Grouping by function doesn't work properly |
|
83 | CS | 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 | P | P | Firebird float support does not conform to Interbase spec |
|
84 | SS | 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 | P | P | Firebird float support does not conform to Interbase spec |
|
85 | CS | 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 | P | P | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
86 | SS | 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 | P | P | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
87 | CS | 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 | P | P | Outer ORDER BY clause has no effect |
|
88 | SS | 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 | P | P | Outer ORDER BY clause has no effect |
|
89 | CS | 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 | P | P | Wrong field position after ALTER POSITION |
|
90 | SS | 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 | P | P | Wrong field position after ALTER POSITION |
|
91 | CS | 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 | P | P | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
92 | SS | 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 | P | P | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
93 | CS | 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 | P | P | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
94 | SS | 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 | P | P | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
95 | CS | 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 | P | P | Incorrect LEFT JOIN result using table and derived constant subquery |
|
96 | SS | 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 | P | P | Incorrect LEFT JOIN result using table and derived constant subquery |
|
97 | CS | 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 | P | P | Lateral derived tables |
|
98 | SS | 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 | P | P | Lateral derived tables |
|
99 | CS | 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 | P | P | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
100 | SS | 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 | P | P | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
101 | CS | 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 | P | P | Window Function: frame (rows / range) clause |
|
102 | SS | 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 | P | P | Window Function: frame (rows / range) clause |
|
103 | CS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
104 | SS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
105 | CS | 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 | P | P | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
106 | SS | 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 | P | P | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
107 | CS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Metadata export with isql (option -ex) does not export functions properly |
|
108 | SS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Metadata export with isql (option -ex) does not export functions properly |
|
109 | CS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
110 | SS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
111 | CS | 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 | P | P | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
112 | SS | 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 | P | P | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
113 | CS | 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 | P | P | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
114 | SS | 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 | P | P | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
115 | CS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | New permission types are not displayed by ISQL |
|
116 | SS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | New permission types are not displayed by ISQL |
|
117 | CS | 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 | P | P | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
118 | SS | 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 | P | P | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
119 | CS | 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 | P | P | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
120 | SS | 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 | P | P | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
121 | CS | 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 | P | P | Parametrized queries using RDB$DB_KEY do not work |
|
122 | SS | 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 | P | P | Parametrized queries using RDB$DB_KEY do not work |
|
123 | CS | 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 | P | P | Wrong result of join when joined fields are created via row_number() function |
|
124 | SS | 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 | P | P | Wrong result of join when joined fields are created via row_number() function |
|
125 | CS | 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 | P | P | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
126 | SS | 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 | P | P | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
127 | CS | 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 | P | P | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
128 | SS | 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 | P | P | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
129 | CS | 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 | P | P | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
130 | SS | 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 | P | P | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
131 | CS | 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 | P | P | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
132 | SS | 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 | P | P | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
133 | CS | 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 | P | P | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
134 | SS | 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 | P | P | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
135 | CS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
136 | SS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
137 | CS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | SHOW GRANTS does not display info about exceptions which were granted to user |
|
138 | SS | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | SHOW GRANTS does not display info about exceptions which were granted to user |
|
139 | CS | 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 | P | P | SEC$ tables and tag/attributes |
|
140 | SS | 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 | P | P | SEC$ tables and tag/attributes |
|
141 | CS | 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 | P | P | Window Function: named window |
|
142 | SS | 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 | P | P | Window Function: named window |
|
143 | CS | 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 | P | P | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
144 | SS | 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 | P | P | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
145 | CS | 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 | P | P | Incorrect query result when using named window |
|
146 | SS | 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 | P | P | Incorrect query result when using named window |
|
147 | CS | 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 | P | P | Unexpected results after creating partial index |
|
148 | SS | 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 | P | P | Unexpected results after creating partial index |
|
149 | CS | 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 | P | P | Simple derived table |
|
150 | SS | 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 | P | P | Simple derived table |
|
151 | CS | 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 | P | P | Unnamed (no relation alias) derived table |
|
152 | SS | 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 | P | P | Unnamed (no relation alias) derived table |
|
153 | CS | 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 | P | P | Explicit column names for derived table |
|
154 | SS | 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 | P | P | Explicit column names for derived table |
|
155 | CS | 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 | P | P | Outer reference to upper scope-level is allowed |
|
156 | SS | 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 | P | P | Outer reference to upper scope-level is allowed |
|
157 | CS | 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 | P | P | Outer reference to upper scope-level is allowed |
|
158 | SS | 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 | P | P | Outer reference to upper scope-level is allowed |
|
159 | CS | 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 | P | P | Outer reference to upper scope-level is allowed |
|
160 | SS | 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 | P | P | Outer reference to upper scope-level is allowed |
|
161 | CS | 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 | P | P | FIRST / SKIP inside derived table |
|
162 | SS | 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 | P | P | FIRST / SKIP inside derived table |
|
163 | CS | 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 | P | P | UNION inside derived table |
|
164 | SS | 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 | P | P | UNION inside derived table |
|
165 | CS | 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 | P | P | Simple derived table with aggregate inside |
|
166 | SS | 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 | P | P | Simple derived table with aggregate inside |
|
167 | CS | 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 | P | P | Aggregate inside derived table |
|
168 | SS | 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 | P | P | Aggregate inside derived table |
|
169 | CS | 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 | P | P | Aggregate inside derived table |
|
170 | SS | 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 | P | P | Aggregate inside derived table |
|
171 | CS | 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 | P | P | Sub-select inside derived table |
|
172 | SS | 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 | P | P | Sub-select inside derived table |
|
173 | CS | 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 | P | P | Sub-select inside derived table |
|
174 | SS | 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 | P | P | Sub-select inside derived table |
|
175 | CS | 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 | P | P | Implicit derived table by IN predicate |
|
176 | SS | 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 | P | P | Implicit derived table by IN predicate |
|
177 | CS | 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 | P | P | Derived table outer reference (triggers) |
|
178 | SS | 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 | P | P | Derived table outer reference (triggers) |
|
179 | CS | 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 | P | P | Non-Recursive CTEs |
|
180 | SS | 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 | P | P | Non-Recursive CTEs |
|
181 | CS | 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 | P | P | Recursive CTEs |
|
182 | SS | 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 | P | P | Recursive CTEs |
|
183 | CS | 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 | P | P | MERGE statement |
|
184 | SS | 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 | P | P | MERGE statement |
|
185 | CS | 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 | P | P | Computed fields |
|
186 | SS | 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 | P | P | Computed fields |
|
187 | CS | 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 | P | P | gtcs-proc-isql-11 |
|
188 | SS | 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 | P | P | gtcs-proc-isql-11 |
|
189 | CS | 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 | P | P | gtcs-proc-isql-15 |
|
190 | SS | 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 | P | P | gtcs-proc-isql-15 |
|
191 | CS | 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 | P | P | gtcs-proc-isql-16 |
|
192 | SS | 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 | P | P | gtcs-proc-isql-16 |
|
193 | CS | 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 | P | P | Test for select from SP that deletes record after its output |
|
194 | SS | 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 | P | P | Test for select from SP that deletes record after its output |
|
195 | CS | 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 | P | P | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
196 | SS | 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 | P | P | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
197 | CS | 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 | P | P | COUNT |
|
198 | SS | 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 | P | P | COUNT |
|
199 | CS | 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 | P | P | EXTRACT(WEEK FROM DATE) |
|
200 | SS | 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 | P | P | EXTRACT(WEEK FROM DATE) |
|
201 | CS | 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 | P | P | TRUNC( <number> [, <number> ] ) |
|
202 | SS | 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 | P | P | TRUNC( <number> [, <number> ] ) |
|
203 | CS | 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 | P | P | POSITION( <string> IN <string> ) |
|
204 | SS | 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 | P | P | POSITION( <string> IN <string> ) |
|
205 | CS | 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 | P | P | Test for TRUNC function |
|
206 | SS | 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 | P | P | Test for TRUNC function |
|
207 | CS | 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 | P | P | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
208 | SS | 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 | P | P | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
209 | CS | F | P | P | P | P | P | P | P | P | F | 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 |
|
210 | SS | 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 | P | P | External Connections Pool, functionality test 01 |
|
211 | CS | 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 | P | P | Common SQL. Check correctness of the results |
|
212 | SS | 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 | P | P | Common SQL. Check correctness of the results |
|
213 | CS | 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 | P | P | Common SQL. Check correctness of the results |
|
214 | SS | 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 | P | P | Common SQL. Check correctness of the results |
|
215 | CS | 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 | P | P | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
216 | SS | 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 | P | P | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
217 | CS | 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 | P | P | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
218 | SS | 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 | P | P | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
219 | CS | 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 | P | P | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
220 | SS | 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 | P | P | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
221 | CS | 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 | P | P | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
222 | SS | 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 | P | P | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
223 | CS | 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 | P | P | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
224 | SS | 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 | P | P | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
225 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
226 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
227 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
228 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
229 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
230 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
231 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
232 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
233 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
234 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
235 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
236 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
237 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
238 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
239 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
240 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
241 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
242 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
243 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
244 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
245 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
246 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
247 | CS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
248 | SS | 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 | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
249 | CS | 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 | P | P | CREATE VIEW |
|
250 | SS | 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 | P | P | CREATE VIEW |
NN | Test name | mode | median_ms |
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.858
|
6.0.0.854
|
6.0.0.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 972 | 1368 | 1030 | 1014 | 1014 | 1049 | 1074 | 1013 | 1003 | 969 | 975 | 996 | 1024 | 1115 | 977 | 1067 | 900 | 976 | 954 | 940 | 924 | 901 | 920 | 901 | 892 | 902 | 920 | 907 | 907 | 890 | 890 | Index bug |
|
2 | SS | 655 | 1004 | 698 | 676 | 668 | 671 | 674 | 673 | 669 | 685 | 672 | 725 | 1121 | 720 | 673 | 661 | 644 | 613 | 649 | 608 | 597 | 622 | 592 | 600 | 615 | 609 | 597 | 631 | 594 | 599 | 612 | Index bug |
|
3 | CS | 788 | 796 | 839 | 780 | 843 | 829 | 868 | 826 | 825 | 810 | 815 | 795 | 819 | 835 | 855 | 781 | 745 | 822 | 743 | 801 | 748 | 764 | 746 | 746 | 746 | 753 | 757 | 753 | 760 | 746 | 754 | Blob comparison with constant |
|
4 | SS | 534 | 535 | 563 | 569 | 2978 | 527 | 569 | 519 | 553 | 572 | 532 | 525 | 520 | 564 | 534 | 582 | 606 | 502 | 542 | 513 | 513 | 510 | 504 | 648 | 534 | 676 | 518 | 498 | 511 | 701 | 540 | Blob comparison with constant |
|
5 | CS | 1848 | 1948 | 1870 | 1849 | 1866 | 1952 | 1951 | 1886 | 1873 | 1902 | 2022 | 1895 | 1894 | 1952 | 1977 | 1946 | 1788 | 1807 | 1764 | 1779 | 1793 | 1778 | 1774 | 1848 | 1752 | 1800 | 1830 | 1764 | 1819 | 1779 | 1842 | Tricky role defeats basic SQL security |
|
6 | SS | 1099 | 866 | 897 | 1176 | 3219 | 864 | 847 | 859 | 912 | 1102 | 1106 | 1089 | 1074 | 1097 | 1114 | 1221 | 1471 | 1043 | 1549 | 1033 | 1053 | 1195 | 1482 | 1536 | 1038 | 1108 | 1022 | 1429 | 1209 | 1083 | 1119 | Tricky role defeats basic SQL security |
|
7 | CS | 595 | 632 | 593 | 598 | 650 | 611 | 656 | 639 | 626 | 601 | 631 | 604 | 606 | 631 | 634 | 611 | 576 | 581 | 560 | 582 | 569 | 560 | 564 | 561 | 551 | 556 | 583 | 557 | 616 | 589 | 565 | ORDER BY on a VIEW turns values in fields into NULL |
|
8 | SS | 401 | 912 | 426 | 411 | 1795 | 400 | 417 | 408 | 428 | 403 | 409 | 415 | 400 | 402 | 400 | 436 | 376 | 377 | 410 | 373 | 381 | 405 | 372 | 369 | 385 | 373 | 376 | 379 | 377 | 471 | 396 | ORDER BY on a VIEW turns values in fields into NULL |
|
9 | CS | 792 | 793 | 795 | 822 | 830 | 901 | 853 | 825 | 830 | 810 | 824 | 793 | 859 | 848 | 853 | 795 | 771 | 757 | 792 | 783 | 759 | 752 | 777 | 756 | 792 | 753 | 758 | 783 | 748 | 759 | 756 | Incorrect handling of null within view - returns 0 |
|
10 | SS | 533 | 548 | 563 | 577 | 549 | 534 | 545 | 541 | 601 | 541 | 539 | 554 | 536 | 556 | 525 | 577 | 516 | 505 | 504 | 494 | 506 | 533 | 501 | 500 | 504 | 504 | 504 | 506 | 500 | 543 | 530 | Incorrect handling of null within view - returns 0 |
|
11 | CS | 790 | 795 | 840 | 786 | 834 | 839 | 882 | 844 | 837 | 825 | 790 | 815 | 826 | 791 | 829 | 846 | 768 | 769 | 797 | 915 | 748 | 767 | 744 | 745 | 741 | 752 | 770 | 764 | 758 | 768 | 750 | New value of column is accessable before update |
|
12 | SS | 536 | 574 | 680 | 556 | 579 | 566 | 638 | 536 | 591 | 540 | 536 | 524 | 534 | 559 | 553 | 574 | 498 | 517 | 543 | 505 | 504 | 499 | 505 | 505 | 503 | 500 | 515 | 506 | 500 | 539 | 984 | New value of column is accessable before update |
|
13 | CS | 800 | 816 | 852 | 806 | 798 | 839 | 907 | 802 | 794 | 794 | 820 | 814 | 830 | 832 | 808 | 804 | 741 | 814 | 748 | 760 | 761 | 752 | 814 | 754 | 753 | 806 | 753 | 747 | 760 | 750 | 752 | Incorrect results when left join on subquery with constant column |
|
14 | SS | 531 | 563 | 581 | 561 | 798 | 561 | 540 | 543 | 571 | 529 | 556 | 534 | 528 | 550 | 554 | 589 | 501 | 521 | 496 | 516 | 526 | 494 | 517 | 501 | 502 | 491 | 518 | 499 | 502 | 551 | 542 | Incorrect results when left join on subquery with constant column |
|
15 | CS | 789 | 864 | 804 | 835 | 803 | 906 | 870 | 797 | 841 | 791 | 787 | 803 | 866 | 885 | 824 | 798 | 814 | 771 | 752 | 772 | 754 | 751 | 750 | 765 | 755 | 752 | 749 | 757 | 747 | 749 | 738 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
16 | SS | 532 | 619 | 567 | 556 | 795 | 539 | 556 | 547 | 560 | 533 | 530 | 532 | 525 | 550 | 545 | 561 | 508 | 515 | 518 | 503 | 506 | 498 | 500 | 512 | 504 | 521 | 527 | 504 | 598 | 536 | 533 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
17 | CS | 793 | 793 | 823 | 828 | 813 | 843 | 845 | 810 | 835 | 785 | 822 | 780 | 830 | 803 | 840 | 784 | 778 | 753 | 793 | 786 | 793 | 756 | 753 | 798 | 743 | 770 | 794 | 750 | 788 | 755 | 846 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
18 | SS | 533 | 574 | 570 | 558 | 603 | 550 | 531 | 600 | 591 | 535 | 550 | 554 | 547 | 551 | 540 | 566 | 500 | 505 | 504 | 517 | 513 | 504 | 504 | 515 | 503 | 526 | 503 | 502 | 500 | 540 | 531 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
19 | CS | 640 | 969 | 639 | 676 | 682 | 705 | 664 | 646 | 648 | 643 | 647 | 640 | 644 | 639 | 648 | 682 | 622 | 601 | 638 | 620 | 627 | 605 | 623 | 660 | 593 | 660 | 613 | 627 | 641 | 597 | 614 | Estonian collation in UTF8 charset |
|
20 | SS | 437 | 747 | 472 | 458 | 768 | 449 | 437 | 474 | 451 | 442 | 441 | 438 | 429 | 465 | 475 | 472 | 428 | 408 | 404 | 406 | 411 | 409 | 409 | 397 | 410 | 426 | 403 | 421 | 816 | 434 | 437 | Estonian collation in UTF8 charset |
|
21 | CS | 791 | 799 | 835 | 833 | 835 | 856 | 832 | 843 | 813 | 824 | 789 | 782 | 835 | 819 | 852 | 836 | 751 | 793 | 763 | 766 | 801 | 751 | 754 | 742 | 736 | 754 | 787 | 753 | 774 | 749 | 749 | LIKE doesn't work for computed values (at least in a view) |
|
22 | SS | 527 | 548 | 756 | 567 | 937 | 553 | 549 | 558 | 555 | 524 | 551 | 531 | 524 | 551 | 561 | 563 | 505 | 505 | 518 | 500 | 499 | 497 | 508 | 523 | 487 | 498 | 505 | 516 | 507 | 552 | 553 | LIKE doesn't work for computed values (at least in a view) |
|
23 | CS | 584 | 602 | 608 | 597 | 596 | 622 | 618 | 605 | 591 | 622 | 603 | 622 | 605 | 632 | 622 | 586 | 582 | 557 | 557 | 557 | 543 | 564 | 545 | 582 | 545 | 559 | 552 | 556 | 549 | 551 | 579 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
24 | SS | 390 | 644 | 433 | 400 | 415 | 439 | 396 | 396 | 421 | 401 | 429 | 393 | 389 | 399 | 394 | 417 | 365 | 375 | 365 | 360 | 383 | 353 | 381 | 361 | 363 | 361 | 371 | 369 | 376 | 384 | 391 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
25 | CS | 592 | 640 | 597 | 630 | 598 | 608 | 608 | 623 | 600 | 592 | 593 | 593 | 595 | 610 | 592 | 590 | 556 | 546 | 584 | 598 | 549 | 553 | 545 | 555 | 584 | 583 | 555 | 549 | 602 | 557 | 550 | Long SQL statements break TCP/IP connection |
|
26 | SS | 389 | 442 | 430 | 391 | 407 | 393 | 611 | 389 | 427 | 398 | 412 | 396 | 394 | 406 | 394 | 424 | 369 | 363 | 360 | 360 | 362 | 365 | 367 | 362 | 365 | 371 | 365 | 367 | 380 | 389 | 386 | Long SQL statements break TCP/IP connection |
|
27 | CS | 778 | 788 | 795 | 838 | 794 | 840 | 843 | 807 | 790 | 812 | 787 | 788 | 829 | 805 | 837 | 834 | 751 | 769 | 749 | 754 | 748 | 750 | 743 | 750 | 761 | 753 | 766 | 753 | 734 | 764 | 754 | LIST() function seems not work if used twice or more in a query |
|
28 | SS | 525 | 553 | 578 | 534 | 559 | 526 | 521 | 529 | 577 | 530 | 550 | 537 | 549 | 525 | 544 | 546 | 505 | 503 | 504 | 511 | 516 | 501 | 504 | 499 | 503 | 513 | 503 | 504 | 510 | 537 | 544 | LIST() function seems not work if used twice or more in a query |
|
29 | CS | 791 | 842 | 790 | 808 | 838 | 850 | 903 | 825 | 847 | 796 | 832 | 792 | 811 | 824 | 818 | 842 | 778 | 792 | 770 | 784 | 751 | 754 | 758 | 754 | 768 | 758 | 759 | 765 | 754 | 747 | 742 | Incorrect column values with outer joins and views |
|
30 | SS | 535 | 1001 | 575 | 535 | 561 | 533 | 548 | 538 | 590 | 527 | 521 | 536 | 553 | 549 | 540 | 565 | 511 | 500 | 501 | 497 | 520 | 500 | 502 | 532 | 500 | 504 | 540 | 518 | 576 | 550 | 537 | Incorrect column values with outer joins and views |
|
31 | CS | 785 | 788 | 795 | 791 | 823 | 886 | 854 | 809 | 796 | 782 | 821 | 800 | 778 | 791 | 854 | 842 | 763 | 802 | 753 | 751 | 759 | 761 | 748 | 738 | 769 | 756 | 747 | 805 | 752 | 745 | 753 | Incorrect column values with outer joins and derived tables |
|
32 | SS | 530 | 547 | 556 | 538 | 555 | 555 | 565 | 547 | 567 | 534 | 522 | 549 | 565 | 553 | 527 | 563 | 513 | 509 | 500 | 507 | 502 | 501 | 503 | 517 | 499 | 501 | 497 | 506 | 512 | 543 | 550 | Incorrect column values with outer joins and derived tables |
|
33 | CS | 783 | 817 | 843 | 780 | 837 | 787 | 827 | 790 | 798 | 848 | 796 | 864 | 811 | 839 | 813 | 787 | 817 | 755 | 748 | 778 | 776 | 754 | 769 | 744 | 746 | 757 | 752 | 761 | 763 | 768 | 749 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
34 | SS | 530 | 991 | 583 | 528 | 614 | 546 | 545 | 540 | 559 | 534 | 548 | 535 | 522 | 531 | 560 | 568 | 505 | 506 | 497 | 509 | 517 | 496 | 505 | 503 | 501 | 500 | 516 | 498 | 536 | 530 | 555 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
35 | CS | 777 | 796 | 886 | 803 | 827 | 827 | 874 | 813 | 833 | 822 | 840 | 790 | 830 | 850 | 830 | 839 | 751 | 752 | 763 | 748 | 755 | 756 | 765 | 751 | 754 | 762 | 749 | 747 | 757 | 749 | 738 | Joins with NULL RDB$DB_KEY crash the server |
|
36 | SS | 537 | 542 | 590 | 546 | 563 | 547 | 553 | 550 | 592 | 571 | 544 | 550 | 532 | 565 | 576 | 566 | 516 | 506 | 509 | 525 | 502 | 536 | 506 | 515 | 501 | 495 | 502 | 505 | 510 | 534 | 539 | Joins with NULL RDB$DB_KEY crash the server |
|
37 | CS | 594 | 661 | 629 | 599 | 603 | 599 | 683 | 636 | 597 | 613 | 633 | 606 | 604 | 695 | 629 | 661 | 592 | 561 | 563 | 565 | 560 | 564 | 581 | 552 | 550 | 592 | 556 | 587 | 587 | 554 | 583 | French insensitive collation FR_FR_CI_AI |
|
38 | SS | 403 | 424 | 422 | 395 | 408 | 421 | 408 | 409 | 434 | 508 | 414 | 405 | 409 | 406 | 429 | 440 | 394 | 374 | 373 | 375 | 396 | 373 | 375 | 380 | 359 | 373 | 376 | 374 | 375 | 412 | 401 | French insensitive collation FR_FR_CI_AI |
|
39 | CS | 786 | 809 | 787 | 786 | 800 | 791 | 893 | 799 | 837 | 831 | 841 | 791 | 812 | 826 | 800 | 819 | 765 | 755 | 745 | 761 | 757 | 794 | 763 | 755 | 746 | 786 | 768 | 752 | 753 | 747 | 751 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
40 | SS | 539 | 549 | 579 | 535 | 565 | 570 | 551 | 554 | 571 | 542 | 547 | 530 | 536 | 549 | 577 | 569 | 514 | 403 | 526 | 547 | 505 | 508 | 504 | 512 | 506 | 500 | 502 | 505 | 638 | 530 | 545 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
41 | CS | 806 | 833 | 817 | 800 | 816 | 817 | 861 | 843 | 814 | 795 | 832 | 787 | 836 | 839 | 814 | 826 | 806 | 811 | 749 | 932 | 803 | 750 | 750 | 797 | 743 | 758 | 807 | 748 | 786 | 767 | 793 | Collation not propagated between record formats |
|
42 | SS | 538 | 562 | 569 | 550 | 547 | 546 | 551 | 530 | 586 | 547 | 549 | 528 | 546 | 547 | 548 | 583 | 522 | 510 | 519 | 511 | 513 | 521 | 502 | 498 | 535 | 510 | 505 | 509 | 521 | 541 | 547 | Collation not propagated between record formats |
|
43 | CS | 576 | 633 | 583 | 587 | 585 | 580 | 606 | 582 | 575 | 611 | 576 | 588 | 606 | 578 | 613 | 576 | 546 | 572 | 547 | 718 | 581 | 536 | 543 | 543 | 535 | 542 | 544 | 562 | 538 | 568 | 532 | DATEADD wrong work with NULL arguments |
|
44 | SS | 383 | 397 | 409 | 383 | 388 | 394 | 380 | 380 | 398 | 395 | 384 | 385 | 389 | 387 | 385 | 425 | 423 | 381 | 356 | 345 | 363 | 358 | 363 | 879 | 362 | 361 | 359 | 357 | 350 | 410 | 380 | DATEADD wrong work with NULL arguments |
|
45 | CS | 576 | 582 | 596 | 619 | 581 | 573 | 613 | 608 | 577 | 614 | 578 | 579 | 616 | 588 | 578 | 636 | 561 | 546 | 576 | 706 | 566 | 527 | 546 | 535 | 563 | 567 | 572 | 533 | 547 | 530 | 558 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
46 | SS | 383 | 421 | 396 | 394 | 392 | 383 | 383 | 386 | 393 | 379 | 388 | 389 | 392 | 390 | 390 | 412 | 363 | 354 | 398 | 363 | 354 | 362 | 358 | 359 | 351 | 358 | 360 | 367 | 362 | 384 | 390 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
47 | CS | 577 | 585 | 582 | 612 | 606 | 627 | 618 | 589 | 580 | 582 | 579 | 576 | 602 | 611 | 591 | 581 | 563 | 539 | 543 | 657 | 549 | 543 | 546 | 534 | 535 | 571 | 549 | 539 | 565 | 534 | 533 | POSITION(string_exp1, string_exp2 [, start]) |
|
48 | SS | 382 | 502 | 410 | 386 | 395 | 380 | 386 | 377 | 422 | 388 | 387 | 389 | 389 | 386 | 387 | 430 | 340 | 359 | 358 | 345 | 364 | 360 | 362 | 362 | 357 | 379 | 371 | 358 | 361 | 384 | 401 | POSITION(string_exp1, string_exp2 [, start]) |
|
49 | CS | 803 | 803 | 832 | 819 | 820 | 841 | 837 | 808 | 805 | 797 | 823 | 849 | 833 | 844 | 856 | 808 | 758 | 785 | 757 | 955 | 746 | 804 | 752 | 752 | 751 | 781 | 749 | 747 | 760 | 764 | 756 | JOIN on first record of ordered derived table returns wrong record |
|
50 | SS | 536 | 567 | 582 | 603 | 537 | 552 | 554 | 530 | 572 | 518 | 544 | 533 | 535 | 542 | 570 | 569 | 683 | 502 | 500 | 514 | 513 | 507 | 507 | 500 | 510 | 514 | 551 | 500 | 526 | 551 | 569 | JOIN on first record of ordered derived table returns wrong record |
|
51 | CS | 573 | 574 | 585 | 579 | 612 | 581 | 664 | 587 | 611 | 623 | 586 | 578 | 577 | 608 | 575 | 597 | 548 | 570 | 549 | 560 | 572 | 568 | 541 | 544 | 528 | 570 | 543 | 536 | 534 | 538 | 571 | ABS() rounds NUMERIC values |
|
52 | SS | 381 | 402 | 376 | 378 | 400 | 415 | 422 | 427 | 411 | 390 | 393 | 400 | 376 | 454 | 383 | 398 | 360 | 362 | 361 | 373 | 380 | 350 | 361 | 383 | 359 | 397 | 362 | 362 | 381 | 377 | 382 | ABS() rounds NUMERIC values |
|
53 | CS | 586 | 599 | 585 | 597 | 590 | 620 | 603 | 593 | 593 | 591 | 586 | 589 | 610 | 638 | 623 | 641 | 580 | 555 | 555 | 594 | 558 | 551 | 577 | 545 | 545 | 586 | 548 | 544 | 547 | 577 | 577 | MERGE not correctly worked with parameters in MATCHING clause |
|
54 | SS | 393 | 404 | 392 | 393 | 419 | 411 | 419 | 393 | 423 | 396 | 393 | 392 | 385 | 472 | 395 | 424 | 361 | 366 | 387 | 388 | 362 | 370 | 367 | 396 | 368 | 393 | 364 | 359 | 383 | 407 | 396 | MERGE not correctly worked with parameters in MATCHING clause |
|
55 | CS | 795 | 811 | 814 | 794 | 837 | 797 | 854 | 825 | 798 | 805 | 811 | 837 | 808 | 796 | 847 | 795 | 806 | 761 | 758 | 832 | 761 | 757 | 763 | 761 | 756 | 757 | 760 | 781 | 747 | 754 | 757 | AV when recursive query used MERGE JOIN in execution plan |
|
56 | SS | 551 | 560 | 547 | 545 | 581 | 574 | 606 | 539 | 583 | 545 | 562 | 552 | 542 | 822 | 573 | 567 | 563 | 520 | 552 | 553 | 507 | 533 | 509 | 530 | 499 | 560 | 513 | 519 | 556 | 551 | 538 | AV when recursive query used MERGE JOIN in execution plan |
|
57 | CS | 781 | 819 | 775 | 829 | 794 | 781 | 822 | 832 | 789 | 800 | 824 | 808 | 796 | 815 | 839 | 786 | 805 | 766 | 731 | 771 | 740 | 753 | 737 | 751 | 744 | 749 | 740 | 761 | 781 | 747 | 740 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
58 | SS | 529 | 554 | 528 | 527 | 595 | 564 | 553 | 533 | 559 | 526 | 529 | 530 | 512 | 788 | 521 | 577 | 491 | 521 | 499 | 532 | 510 | 500 | 500 | 541 | 501 | 531 | 497 | 512 | 546 | 964 | 548 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
59 | CS | 576 | 581 | 588 | 577 | 583 | 586 | 593 | 613 | 586 | 575 | 579 | 612 | 595 | 606 | 576 | 585 | 556 | 554 | 548 | 580 | 588 | 543 | 532 | 543 | 565 | 545 | 572 | 538 | 542 | 543 | 538 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
60 | SS | 387 | 429 | 387 | 377 | 421 | 409 | 407 | 393 | 409 | 388 | 386 | 388 | 386 | 509 | 393 | 403 | 359 | 363 | 340 | 376 | 740 | 358 | 358 | 395 | 351 | 382 | 365 | 360 | 407 | 387 | 381 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
61 | CS | 585 | 595 | 585 | 603 | 587 | 597 | 606 | 603 | 585 | 591 | 592 | 592 | 586 | 593 | 583 | 598 | 592 | 572 | 551 | 575 | 541 | 543 | 547 | 557 | 542 | 587 | 607 | 543 | 546 | 573 | 545 | Wrong variable initialization in recursive procedures |
|
62 | SS | 390 | 406 | 380 | 404 | 501 | 411 | 411 | 394 | 421 | 392 | 389 | 395 | 400 | 485 | 405 | 406 | 360 | 374 | 376 | 386 | 364 | 358 | 378 | 383 | 359 | 382 | 362 | 374 | 402 | 383 | 403 | Wrong variable initialization in recursive procedures |
|
63 | CS | 787 | 801 | 785 | 830 | 783 | 834 | 812 | 793 | 841 | 795 | 790 | 793 | 852 | 845 | 829 | 803 | 772 | 754 | 746 | 817 | 754 | 756 | 748 | 757 | 744 | 766 | 747 | 797 | 754 | 736 | 737 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
64 | SS | 532 | 552 | 540 | 536 | 564 | 561 | 558 | 529 | 577 | 528 | 555 | 516 | 534 | 683 | 543 | 939 | 498 | 504 | 494 | 553 | 502 | 501 | 508 | 510 | 514 | 531 | 502 | 507 | 550 | 536 | 523 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
65 | CS | 795 | 804 | 831 | 810 | 801 | 826 | 798 | 841 | 788 | 800 | 851 | 818 | 795 | 826 | 798 | 805 | 758 | 773 | 747 | 798 | 761 | 749 | 747 | 754 | 796 | 761 | 775 | 743 | 745 | 749 | 756 | Consistency check when subquery is ordered by aggregate function from other context |
|
66 | SS | 542 | 565 | 535 | 531 | 702 | 573 | 574 | 549 | 565 | 546 | 562 | 535 | 535 | 658 | 546 | 581 | 502 | 713 | 504 | 548 | 521 | 498 | 564 | 500 | 507 | 541 | 517 | 503 | 543 | 537 | 542 | Consistency check when subquery is ordered by aggregate function from other context |
|
67 | CS | 785 | 843 | 839 | 801 | 790 | 819 | 847 | 794 | 837 | 831 | 799 | 827 | 786 | 819 | 832 | 827 | 769 | 755 | 754 | 785 | 762 | 756 | 758 | 777 | 750 | 759 | 766 | 756 | 777 | 754 | 756 | DEFAULT values are unnecessary evaluated |
|
68 | SS | 533 | 563 | 531 | 586 | 585 | 566 | 569 | 534 | 572 | 528 | 554 | 527 | 532 | 649 | 563 | 552 | 500 | 501 | 517 | 531 | 504 | 517 | 497 | 507 | 500 | 535 | 505 | 526 | 546 | 541 | 568 | DEFAULT values are unnecessary evaluated |
|
69 | CS | 588 | 604 | 604 | 594 | 587 | 597 | 628 | 606 | 626 | 588 | 600 | 603 | 596 | 624 | 606 | 599 | 582 | 575 | 560 | 569 | 560 | 596 | 564 | 543 | 585 | 589 | 571 | 546 | 576 | 551 | 543 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
70 | SS | 400 | 427 | 403 | 398 | 422 | 433 | 416 | 400 | 414 | 407 | 406 | 403 | 401 | 416 | 402 | 427 | 364 | 380 | 368 | 392 | 371 | 380 | 363 | 371 | 365 | 391 | 398 | 428 | 367 | 403 | 391 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
71 | CS | 785 | 837 | 784 | 787 | 830 | 787 | 812 | 825 | 807 | 827 | 794 | 787 | 796 | 831 | 839 | 797 | 758 | 779 | 751 | 797 | 752 | 746 | 746 | 748 | 753 | 770 | 750 | 759 | 761 | 747 | 747 | Null in the first record in a condition on rdb$db_key |
|
72 | SS | 541 | 622 | 558 | 534 | 571 | 581 | 566 | 546 | 583 | 549 | 546 | 535 | 550 | 562 | 540 | 583 | 498 | 521 | 498 | 543 | 499 | 495 | 514 | 512 | 504 | 559 | 501 | 505 | 504 | 555 | 526 | Null in the first record in a condition on rdb$db_key |
|
73 | CS | 794 | 835 | 788 | 831 | 842 | 824 | 823 | 860 | 819 | 844 | 849 | 832 | 801 | 816 | 805 | 786 | 775 | 809 | 752 | 831 | 750 | 757 | 753 | 757 | 756 | 761 | 757 | 752 | 757 | 752 | 788 | update or insert with gen_id() with wrong generator value |
|
74 | SS | 551 | 563 | 567 | 531 | 650 | 578 | 573 | 555 | 575 | 554 | 569 | 544 | 564 | 545 | 548 | 571 | 518 | 534 | 518 | 555 | 512 | 516 | 499 | 526 | 687 | 557 | 505 | 503 | 519 | 573 | 539 | update or insert with gen_id() with wrong generator value |
|
75 | CS | 788 | 809 | 805 | 831 | 797 | 845 | 793 | 793 | 811 | 829 | 832 | 845 | 784 | 867 | 831 | 849 | 779 | 754 | 746 | 824 | 747 | 752 | 753 | 752 | 745 | 754 | 763 | 750 | 752 | 757 | 753 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
76 | SS | 535 | 553 | 565 | 534 | 578 | 548 | 587 | 531 | 566 | 532 | 530 | 537 | 543 | 565 | 562 | 571 | 500 | 503 | 498 | 545 | 983 | 518 | 507 | 499 | 499 | 557 | 503 | 503 | 500 | 546 | 532 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
77 | CS | 790 | 833 | 818 | 811 | 789 | 784 | 848 | 844 | 840 | 826 | 813 | 792 | 802 | 840 | 825 | 793 | 800 | 777 | 764 | 792 | 751 | 747 | 742 | 748 | 760 | 789 | 755 | 773 | 741 | 756 | 781 | GROUP by and RDB$DB_KEY problems |
|
78 | SS | 528 | 541 | 536 | 522 | 542 | 546 | 584 | 528 | 568 | 533 | 549 | 526 | 528 | 529 | 550 | 576 | 504 | 512 | 499 | 537 | 500 | 503 | 525 | 500 | 503 | 505 | 505 | 515 | 499 | 541 | 716 | GROUP by and RDB$DB_KEY problems |
|
79 | CS | 795 | 848 | 797 | 799 | 814 | 813 | 809 | 796 | 852 | 791 | 816 | 833 | 830 | 837 | 851 | 789 | 821 | 756 | 751 | 824 | 744 | 752 | 759 | 756 | 794 | 754 | 768 | 774 | 748 | 756 | 764 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
80 | SS | 539 | 585 | 525 | 539 | 546 | 532 | 587 | 539 | 582 | 567 | 556 | 531 | 539 | 554 | 581 | 572 | 838 | 535 | 506 | 727 | 512 | 514 | 499 | 516 | 501 | 499 | 503 | 519 | 515 | 553 | 548 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
81 | CS | 788 | 795 | 833 | 821 | 792 | 779 | 843 | 873 | 841 | 793 | 828 | 785 | 793 | 801 | 825 | 823 | 747 | 763 | 770 | 753 | 815 | 745 | 738 | 750 | 773 | 758 | 791 | 738 | 770 | 749 | 786 | Grouping by function doesn't work properly |
|
82 | SS | 532 | 562 | 533 | 546 | 1015 | 533 | 534 | 531 | 578 | 534 | 548 | 549 | 550 | 545 | 534 | 574 | 505 | 506 | 512 | 500 | 506 | 501 | 503 | 507 | 504 | 500 | 503 | 503 | 507 | 497 | 534 | Grouping by function doesn't work properly |
|
83 | CS | 791 | 795 | 821 | 797 | 832 | 832 | 834 | 854 | 795 | 816 | 801 | 786 | 832 | 840 | 824 | 826 | 745 | 788 | 798 | 741 | 747 | 747 | 756 | 747 | 758 | 744 | 755 | 763 | 760 | 754 | 752 | Firebird float support does not conform to Interbase spec |
|
84 | SS | 523 | 794 | 548 | 538 | 525 | 518 | 555 | 550 | 581 | 547 | 540 | 544 | 530 | 550 | 559 | 576 | 498 | 515 | 502 | 518 | 499 | 494 | 504 | 503 | 521 | 503 | 508 | 503 | 504 | 503 | 574 | Firebird float support does not conform to Interbase spec |
|
85 | CS | 575 | 592 | 579 | 594 | 583 | 592 | 593 | 595 | 596 | 580 | 596 | 575 | 576 | 570 | 595 | 604 | 538 | 572 | 553 | 541 | 552 | 584 | 545 | 541 | 533 | 575 | 584 | 547 | 551 | 558 | 546 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
86 | SS | 379 | 403 | 387 | 394 | 385 | 391 | 392 | 385 | 381 | 385 | 389 | 393 | 392 | 399 | 423 | 384 | 364 | 378 | 360 | 361 | 359 | 365 | 357 | 357 | 364 | 358 | 346 | 356 | 365 | 360 | 363 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
87 | CS | 817 | 888 | 826 | 824 | 820 | 860 | 853 | 858 | 863 | 871 | 823 | 867 | 832 | 893 | 866 | 838 | 772 | 791 | 777 | 782 | 783 | 800 | 770 | 773 | 778 | 772 | 815 | 781 | 777 | 777 | 774 | Outer ORDER BY clause has no effect |
|
88 | SS | 548 | 639 | 576 | 579 | 1516 | 592 | 577 | 550 | 557 | 609 | 571 | 571 | 559 | 574 | 557 | 587 | 547 | 544 | 522 | 534 | 525 | 520 | 545 | 538 | 525 | 531 | 526 | 531 | 519 | 543 | 541 | Outer ORDER BY clause has no effect |
|
89 | CS | 815 | 828 | 819 | 813 | 866 | 870 | 868 | 856 | 829 | 807 | 874 | 871 | 852 | 854 | 830 | 818 | 787 | 840 | 778 | 765 | 762 | 770 | 765 | 764 | 822 | 768 | 774 | 765 | 797 | 779 | 766 | Wrong field position after ALTER POSITION |
|
90 | SS | 546 | 571 | 568 | 561 | 1912 | 553 | 576 | 559 | 549 | 563 | 580 | 577 | 567 | 576 | 544 | 585 | 512 | 520 | 527 | 520 | 510 | 522 | 516 | 514 | 513 | 520 | 529 | 533 | 1007 | 533 | 533 | Wrong field position after ALTER POSITION |
|
91 | CS | 616 | 171132 | 624 | 624 | 617 | 596 | 616 | 615 | 648 | 681 | 635 | 636 | 616 | 683 | 699 | 696 | 661 | 580 | 639 | 586 | 585 | 568 | 562 | 597 | 558 | 625 | 574 | 563 | 577 | 590 | 596 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
92 | SS | 397 | 169716 | 412 | 437 | 433 | 604 | 444 | 412 | 398 | 397 | 410 | 414 | 432 | 556 | 418 | 401 | 397 | 382 | 365 | 393 | 367 | 380 | 400 | 367 | 369 | 383 | 379 | 378 | 369 | 382 | 365 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
93 | CS | 806 | 841 | 803 | 832 | 817 | 834 | 811 | 818 | 830 | 825 | 812 | 792 | 817 | 839 | 837 | 840 | 810 | 753 | 778 | 860 | 745 | 770 | 746 | 746 | 739 | 793 | 752 | 762 | 748 | 769 | 769 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
94 | SS | 542 | 559 | 553 | 549 | 692 | 553 | 543 | 563 | 552 | 542 | 542 | 552 | 548 | 542 | 549 | 599 | 517 | 513 | 498 | 513 | 515 | 517 | 508 | 510 | 506 | 515 | 517 | 502 | 512 | 551 | 520 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
95 | CS | 789 | 793 | 791 | 802 | 848 | 798 | 851 | 795 | 805 | 821 | 784 | 811 | 806 | 834 | 836 | 783 | 774 | 762 | 787 | 797 | 753 | 752 | 751 | 759 | 765 | 815 | 762 | 736 | 755 | 757 | 770 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
96 | SS | 521 | 568 | 528 | 533 | 607 | 534 | 554 | 545 | 517 | 529 | 557 | 536 | 525 | 526 | 546 | 532 | 507 | 501 | 501 | 504 | 500 | 571 | 498 | 517 | 500 | 500 | 501 | 506 | 503 | 504 | 499 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
97 | CS | 1308 | 1456 | 1412 | 1459 | 1431 | 1468 | 1420 | 1454 | 1431 | 1425 | 1425 | 1480 | 1405 | 1530 | 1414 | 1445 | 1211 | 1189 | 1168 | 1150 | 1156 | 1179 | 1155 | 1196 | 1136 | 1179 | 1189 | 1136 | 1179 | 1170 | 1144 | Lateral derived tables |
|
98 | SS | 1013 | 1359 | 1150 | 1096 | 1183 | 1118 | 1167 | 1156 | 1079 | 1530 | 1108 | 1083 | 1107 | 1166 | 1627 | 1117 | 947 | 851 | 849 | 861 | 866 | 852 | 861 | 851 | 907 | 849 | 849 | 830 | 855 | 835 | 837 | Lateral derived tables |
|
99 | CS | 837 | 846 | 877 | 881 | 841 | 850 | 863 | 858 | 870 | 859 | 847 | 865 | 845 | 862 | 900 | 878 | 834 | 788 | 805 | 799 | 806 | 810 | 782 | 800 | 813 | 796 | 805 | 799 | 794 | 798 | 795 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
100 | SS | 578 | 615 | 595 | 588 | 595 | 604 | 582 | 600 | 587 | 612 | 591 | 575 | 590 | 691 | 608 | 604 | 574 | 573 | 546 | 557 | 670 | 533 | 550 | 530 | 557 | 533 | 564 | 537 | 548 | 562 | 545 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
101 | CS | 818 | 828 | 824 | 847 | 851 | 855 | 865 | 841 | 822 | 867 | 850 | 820 | 877 | 841 | 834 | 872 | 775 | 776 | 817 | 780 | 776 | 770 | 769 | 808 | 766 | 778 | 808 | 787 | 788 | 770 | 763 | Window Function: frame (rows / range) clause |
|
102 | SS | 558 | 575 | 750 | 577 | 592 | 588 | 563 | 553 | 585 | 573 | 564 | 561 | 573 | 953 | 1012 | 566 | 544 | 555 | 521 | 531 | 519 | 535 | 520 | 519 | 516 | 805 | 552 | 520 | 535 | 550 | 534 | Window Function: frame (rows / range) clause |
|
103 | CS | 1182 | 1139 | 1133 | 1231 | 1221 | 1264 | 1229 | 1218 | 1259 | 1297 | 1252 | 1221 | 1247 | 1254 | 1276 | 1235 | 1175 | 1130 | 1190 | 1125 | 1139 | 1144 | 1118 | 1192 | 1136 | 1139 | 1164 | 1159 | 1121 | 1124 | 1109 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
104 | SS | 736 | 727 | 696 | 760 | 931 | 782 | 1221 | 807 | 745 | 1140 | 771 | 748 | 770 | 760 | 759 | 784 | 863 | 693 | 667 | 689 | 666 | 667 | 666 | 670 | 684 | 671 | 695 | 686 | 685 | 706 | 871 | Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS |
|
105 | CS | 800 | 839 | 824 | 800 | 807 | 844 | 822 | 833 | 816 | 817 | 800 | 828 | 814 | 851 | 807 | 801 | 802 | 760 | 743 | 745 | 756 | 743 | 805 | 798 | 744 | 752 | 756 | 745 | 764 | 754 | 776 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
106 | SS | 541 | 560 | 547 | 554 | 548 | 548 | 546 | 548 | 546 | 552 | 543 | 550 | 544 | 547 | 562 | 551 | 512 | 539 | 517 | 503 | 527 | 512 | 522 | 517 | 516 | 522 | 528 | 500 | 514 | 523 | 517 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
107 | CS | 845 | 864 | 833 | 849 | 842 | 883 | 870 | 862 | 857 | 844 | 865 | 876 | 871 | 846 | 885 | 860 | 780 | 851 | 814 | 789 | 780 | 787 | 792 | 788 | 799 | 1478 | 783 | 788 | 797 | 777 | 847 | Metadata export with isql (option -ex) does not export functions properly |
|
108 | SS | 575 | 839 | 565 | 572 | 587 | 574 | 578 | 807 | 589 | 585 | 591 | 596 | 578 | 583 | 586 | 592 | 540 | 537 | 691 | 531 | 535 | 545 | 576 | 529 | 546 | 543 | 532 | 536 | 540 | 583 | 535 | Metadata export with isql (option -ex) does not export functions properly |
|
109 | CS | 784 | 843 | 833 | 849 | 847 | 877 | 862 | 592 | 598 | 622 | 620 | 625 | 620 | 595 | 607 | 592 | 841 | 786 | 778 | 837 | 778 | 787 | 786 | 783 | 780 | 1183 | 782 | 799 | 812 | 798 | 780 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
110 | SS | 532 | 590 | 561 | 617 | 588 | 580 | 581 | 398 | 407 | 404 | 409 | 471 | 397 | 424 | 439 | 418 | 530 | 534 | 522 | 543 | 531 | 530 | 531 | 531 | 539 | 538 | 538 | 533 | 541 | 550 | 535 | Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error |
|
111 | CS | 589 | 604 | 599 | 638 | 588 | 597 | 591 | 626 | 596 | 592 | 597 | 598 | 600 | 654 | 623 | 630 | 551 | 552 | 562 | 573 | 548 | 555 | 552 | 556 | 554 | 947 | 586 | 547 | 554 | 547 | 577 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
112 | SS | 390 | 414 | 394 | 394 | 404 | 398 | 403 | 404 | 413 | 390 | 395 | 436 | 391 | 400 | 405 | 395 | 364 | 403 | 389 | 359 | 359 | 389 | 358 | 362 | 360 | 370 | 360 | 364 | 357 | 380 | 361 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
113 | CS | 790 | 794 | 793 | 792 | 811 | 832 | 823 | 802 | 858 | 797 | 823 | 832 | 797 | 818 | 794 | 788 | 776 | 773 | 765 | 771 | 789 | 748 | 745 | 753 | 747 | 1167 | 764 | 769 | 752 | 752 | 749 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
114 | SS | 526 | 571 | 536 | 553 | 548 | 558 | 552 | 545 | 553 | 530 | 558 | 589 | 530 | 547 | 544 | 550 | 520 | 523 | 505 | 521 | 499 | 517 | 513 | 509 | 510 | 512 | 497 | 499 | 502 | 516 | 516 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
115 | CS | 602 | 628 | 650 | 629 | 624 | 652 | 628 | 627 | 657 | 611 | 652 | 619 | 616 | 633 | 617 | 646 | 575 | 577 | 562 | 593 | 579 | 563 | 567 | 569 | 563 | 585 | 581 | 564 | 564 | 563 | 573 | New permission types are not displayed by ISQL |
|
116 | SS | 400 | 432 | 408 | 429 | 428 | 422 | 433 | 428 | 434 | 439 | 445 | 463 | 441 | 419 | 424 | 425 | 381 | 393 | 371 | 377 | 390 | 374 | 369 | 373 | 370 | 378 | 376 | 376 | 374 | 377 | 379 | New permission types are not displayed by ISQL |
|
117 | CS | 786 | 841 | 803 | 792 | 832 | 819 | 867 | 798 | 790 | 815 | 832 | 797 | 830 | 810 | 827 | 799 | 782 | 761 | 749 | 754 | 753 | 749 | 737 | 761 | 774 | 741 | 761 | 751 | 742 | 740 | 736 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
118 | SS | 520 | 561 | 545 | 552 | 553 | 538 | 564 | 540 | 546 | 546 | 548 | 529 | 534 | 549 | 529 | 581 | 505 | 500 | 499 | 499 | 504 | 511 | 506 | 499 | 501 | 498 | 511 | 503 | 502 | 507 | 504 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
119 | CS | 575 | 594 | 583 | 617 | 581 | 602 | 580 | 594 | 590 | 614 | 589 | 617 | 581 | 603 | 597 | 575 | 564 | 573 | 548 | 533 | 538 | 565 | 548 | 543 | 543 | 576 | 558 | 565 | 553 | 538 | 567 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
120 | SS | 383 | 417 | 412 | 390 | 383 | 424 | 385 | 382 | 383 | 405 | 383 | 391 | 417 | 399 | 390 | 390 | 364 | 392 | 353 | 361 | 367 | 363 | 392 | 367 | 367 | 358 | 401 | 356 | 362 | 369 | 358 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
121 | CS | 581 | 606 | 591 | 629 | 624 | 640 | 595 | 591 | 590 | 582 | 600 | 586 | 621 | 612 | 581 | 589 | 581 | 548 | 562 | 584 | 545 | 578 | 546 | 572 | 548 | 568 | 575 | 546 | 546 | 550 | 547 | Parametrized queries using RDB$DB_KEY do not work |
|
122 | SS | 389 | 455 | 393 | 410 | 399 | 395 | 406 | 393 | 393 | 420 | 388 | 391 | 405 | 412 | 406 | 396 | 378 | 356 | 361 | 379 | 359 | 363 | 377 | 377 | 374 | 380 | 401 | 361 | 373 | 371 | 363 | Parametrized queries using RDB$DB_KEY do not work |
|
123 | CS | 847 | 882 | 849 | 880 | 855 | 868 | 863 | 849 | 876 | 862 | 886 | 858 | 845 | 876 | 867 | 887 | 792 | 867 | 806 | 788 | 784 | 789 | 794 | 789 | 786 | 824 | 788 | 787 | 834 | 784 | 780 | Wrong result of join when joined fields are created via row_number() function |
|
124 | SS | 568 | 618 | 600 | 596 | 593 | 589 | 564 | 599 | 571 | 585 | 576 | 579 | 626 | 645 | 589 | 596 | 553 | 538 | 552 | 545 | 566 | 533 | 543 | 534 | 555 | 533 | 576 | 552 | 533 | 534 | 534 | Wrong result of join when joined fields are created via row_number() function |
|
125 | CS | 1296 | 1328 | 1370 | 1318 | 1311 | 1349 | 1327 | 1330 | 1383 | 1309 | 1309 | 1320 | 1300 | 1318 | 1355 | 1327 | 1224 | 1258 | 1217 | 1220 | 1198 | 1293 | 1213 | 1243 | 1224 | 1255 | 1224 | 1248 | 1207 | 1211 | 1236 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
126 | SS | 797 | 826 | 814 | 938 | 807 | 808 | 889 | 809 | 802 | 814 | 806 | 809 | 827 | 809 | 804 | 881 | 743 | 728 | 749 | 738 | 737 | 743 | 731 | 729 | 724 | 760 | 792 | 735 | 749 | 746 | 736 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
127 | CS | 807 | 839 | 825 | 836 | 843 | 796 | 848 | 846 | 821 | 811 | 812 | 812 | 857 | 826 | 836 | 820 | 752 | 760 | 803 | 751 | 839 | 773 | 747 | 771 | 750 | 752 | 787 | 744 | 770 | 756 | 764 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
128 | SS | 545 | 574 | 541 | 614 | 550 | 562 | 553 | 553 | 563 | 546 | 545 | 553 | 548 | 561 | 547 | 566 | 530 | 523 | 555 | 528 | 524 | 523 | 521 | 516 | 517 | 519 | 552 | 518 | 517 | 537 | 519 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
129 | CS | 577 | 608 | 590 | 583 | 590 | 575 | 594 | 589 | 596 | 579 | 585 | 589 | 588 | 594 | 593 | 597 | 534 | 553 | 539 | 550 | 542 | 530 | 533 | 582 | 542 | 572 | 543 | 572 | 545 | 568 | 532 | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
130 | SS | 375 | 418 | 391 | 465 | 394 | 390 | 381 | 390 | 401 | 386 | 375 | 386 | 392 | 387 | 384 | 380 | 356 | 355 | 362 | 359 | 363 | 375 | 361 | 351 | 358 | 358 | 368 | 360 | 361 | 368 | 360 | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
131 | CS | 946 | 1001 | 986 | 972 | 1004 | 1011 | 990 | 972 | 1006 | 985 | 985 | 971 | 975 | 1004 | 969 | 967 | 901 | 892 | 891 | 885 | 915 | 889 | 889 | 900 | 880 | 924 | 926 | 888 | 898 | 887 | 876 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
132 | SS | 601 | 657 | 637 | 1296 | 639 | 633 | 629 | 670 | 630 | 625 | 634 | 651 | 630 | 626 | 670 | 621 | 568 | 566 | 572 | 577 | 580 | 577 | 566 | 557 | 567 | 576 | 564 | 568 | 576 | 579 | 581 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
133 | CS | 595 | 611 | 597 | 632 | 598 | 628 | 607 | 599 | 608 | 631 | 599 | 617 | 606 | 599 | 630 | 616 | 575 | 576 | 548 | 583 | 563 | 563 | 579 | 589 | 554 | 576 | 594 | 571 | 593 | 589 | 568 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
134 | SS | 400 | 470 | 400 | 408 | 405 | 402 | 399 | 441 | 402 | 400 | 420 | 421 | 406 | 442 | 404 | 402 | 380 | 363 | 442 | 368 | 378 | 372 | 383 | 373 | 377 | 384 | 401 | 375 | 366 | 378 | 368 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
135 | CS | 1561 | 1630 | 1565 | 1573 | 1579 | 1625 | 1616 | 1611 | 1626 | 1615 | 1590 | 1594 | 1573 | 1632 | 1608 | 1620 | 1488 | 1474 | 1479 | 1470 | 1471 | 1474 | 1466 | 1558 | 1443 | 1487 | 1471 | 1465 | 1546 | 1499 | 1464 | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
136 | SS | 948 | 997 | 950 | 1037 | 963 | 964 | 960 | 1038 | 971 | 956 | 964 | 1035 | 961 | 960 | 999 | 947 | 892 | 870 | 940 | 889 | 899 | 870 | 876 | 859 | 853 | 885 | 960 | 890 | 886 | 899 | 898 | Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke |
|
137 | CS | 1127 | 1133 | 1129 | 1133 | 1156 | 1151 | 1136 | 1140 | 1194 | 1127 | 1139 | 1127 | 1136 | 1142 | 1144 | 1148 | 1119 | 1114 | 1061 | 1053 | 1066 | 1075 | 1066 | 1128 | 1059 | 1044 | 1046 | 1081 | 1106 | 1065 | 1039 | SHOW GRANTS does not display info about exceptions which were granted to user |
|
138 | SS | 704 | 746 | 708 | 743 | 725 | 703 | 705 | 765 | 777 | 699 | 714 | 762 | 719 | 715 | 708 | 754 | 636 | 650 | 674 | 655 | 644 | 644 | 644 | 631 | 645 | 642 | 729 | 651 | 663 | 675 | 733 | SHOW GRANTS does not display info about exceptions which were granted to user |
|
139 | CS | 672 | 710 | 710 | 671 | 705 | 675 | 673 | 709 | 678 | 675 | 701 | 680 | 671 | 718 | 686 | 674 | 690 | 620 | 618 | 662 | 660 | 642 | 638 | 613 | 612 | 624 | 646 | 683 | 611 | 637 | 611 | SEC$ tables and tag/attributes |
|
140 | SS | 436 | 464 | 449 | 447 | 459 | 443 | 453 | 443 | 433 | 449 | 450 | 451 | 443 | 446 | 452 | 457 | 407 | 408 | 403 | 404 | 419 | 401 | 421 | 404 | 416 | 408 | 440 | 404 | 409 | 406 | 406 | SEC$ tables and tag/attributes |
|
141 | CS | 598 | 662 | 601 | 606 | 604 | 600 | 627 | 688 | 627 | 648 | 631 | 605 | 632 | 604 | 625 | 648 | 585 | 582 | 553 | 597 | 581 | 587 | 582 | 578 | 574 | 584 | 557 | 554 | 562 | 585 | 549 | Window Function: named window |
|
142 | SS | 390 | 457 | 408 | 411 | 404 | 395 | 409 | 401 | 408 | 406 | 409 | 402 | 385 | 405 | 403 | 416 | 374 | 363 | 370 | 371 | 362 | 366 | 375 | 362 | 498 | 381 | 381 | 374 | 372 | 375 | 375 | Window Function: named window |
|
143 | CS | 6776 | 7153 | 7264 | 7058 | 7065 | 7091 | 7420 | 7528 | 7129 | 7234 | 7165 | 7041 | 7033 | 7245 | 7195 | 7163 | 6390 | 6437 | 6274 | 6292 | 6253 | 6519 | 6200 | 6478 | 6202 | 6295 | 6310 | 6153 | 6221 | 6148 | 6166 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
144 | SS | 4864 | 5515 | 5096 | 5256 | 5113 | 5279 | 5243 | 5260 | 5108 | 5128 | 5226 | 5226 | 5239 | 5163 | 5173 | 5354 | 4527 | 4504 | 4414 | 4444 | 4401 | 4519 | 4500 | 4366 | 4633 | 4423 | 4444 | 4416 | 4374 | 4396 | 4502 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
145 | CS | 586 | 594 | 591 | 614 | 614 | 586 | 602 | 592 | 632 | 596 | 587 | 599 | 672 | 581 | 639 | 575 | 583 | 541 | 544 | 577 | 604 | 546 | 541 | 550 | 601 | 548 | 552 | 567 | 547 | 578 | 595 | Incorrect query result when using named window |
|
146 | SS | 393 | 416 | 394 | 428 | 431 | 412 | 392 | 398 | 421 | 390 | 394 | 407 | 394 | 397 | 412 | 391 | 397 | 374 | 357 | 378 | 374 | 361 | 387 | 363 | 382 | 374 | 376 | 376 | 396 | 360 | 404 | Incorrect query result when using named window |
|
147 | CS | 593 | 640 | 598 | 600 | 593 | 593 | 664 | 596 | 632 | 595 | 601 | 601 | 596 | 639 | 594 | 587 | 556 | 569 | 570 | 552 | 579 | 558 | 578 | 559 | 594 | 599 | 582 | 550 | 572 | 604 | 548 | Unexpected results after creating partial index |
|
148 | SS | 388 | 419 | 413 | 407 | 394 | 412 | 413 | 394 | 407 | 414 | 409 | 400 | 393 | 434 | 430 | 410 | 361 | 375 | 366 | 367 | 377 | 384 | 370 | 365 | 361 | 376 | 378 | 377 | 369 | 375 | 360 | Unexpected results after creating partial index |
|
149 | CS | 791 | 801 | 842 | 813 | 800 | 825 | 800 | 796 | 838 | 789 | 798 | 860 | 793 | 848 | 832 | 781 | 758 | 809 | 748 | 761 | 797 | 749 | 755 | 761 | 779 | 763 | 753 | 750 | 764 | 757 | 757 | Simple derived table |
|
150 | SS | 545 | 698 | 545 | 530 | 546 | 551 | 565 | 654 | 557 | 559 | 562 | 561 | 534 | 555 | 542 | 547 | 573 | 515 | 498 | 496 | 506 | 529 | 670 | 502 | 504 | 794 | 518 | 517 | 523 | 545 | 506 | Simple derived table |
|
151 | CS | 790 | 803 | 828 | 803 | 857 | 817 | 849 | 800 | 795 | 803 | 799 | 872 | 786 | 804 | 832 | 805 | 772 | 813 | 754 | 749 | 770 | 748 | 753 | 751 | 752 | 756 | 754 | 757 | 753 | 756 | 754 | Unnamed (no relation alias) derived table |
|
152 | SS | 534 | 561 | 799 | 530 | 543 | 548 | 532 | 534 | 544 | 539 | 815 | 532 | 538 | 900 | 560 | 533 | 452 | 674 | 500 | 516 | 502 | 534 | 548 | 501 | 537 | 519 | 505 | 499 | 517 | 536 | 505 | Unnamed (no relation alias) derived table |
|
153 | CS | 796 | 834 | 830 | 800 | 795 | 858 | 800 | 798 | 799 | 799 | 832 | 869 | 797 | 791 | 800 | 823 | 826 | 808 | 776 | 744 | 754 | 745 | 753 | 754 | 772 | 748 | 760 | 753 | 754 | 773 | 749 | Explicit column names for derived table |
|
154 | SS | 532 | 549 | 538 | 551 | 543 | 532 | 551 | 548 | 531 | 631 | 540 | 734 | 562 | 602 | 561 | 533 | 505 | 363 | 547 | 518 | 523 | 502 | 506 | 504 | 501 | 504 | 518 | 518 | 500 | 532 | 516 | Explicit column names for derived table |
|
155 | CS | 789 | 806 | 801 | 852 | 799 | 803 | 843 | 799 | 842 | 796 | 794 | 789 | 806 | 789 | 801 | 830 | 774 | 869 | 758 | 757 | 754 | 749 | 749 | 756 | 755 | 750 | 748 | 767 | 757 | 766 | 740 | Outer reference to upper scope-level is allowed |
|
156 | SS | 529 | 707 | 537 | 540 | 534 | 534 | 530 | 536 | 553 | 550 | 538 | 540 | 532 | 535 | 564 | 562 | 499 | 528 | 502 | 498 | 502 | 506 | 500 | 510 | 502 | 505 | 502 | 513 | 516 | 503 | 514 | Outer reference to upper scope-level is allowed |
|
157 | CS | 793 | 802 | 800 | 850 | 796 | 799 | 803 | 800 | 793 | 830 | 813 | 795 | 793 | 821 | 807 | 823 | 761 | 793 | 746 | 751 | 751 | 750 | 752 | 759 | 764 | 758 | 756 | 753 | 748 | 774 | 743 | Outer reference to upper scope-level is allowed |
|
158 | SS | 527 | 548 | 529 | 547 | 534 | 555 | 698 | 534 | 533 | 531 | 563 | 530 | 534 | 554 | 526 | 542 | 504 | 535 | 500 | 498 | 503 | 501 | 522 | 517 | 506 | 497 | 512 | 505 | 509 | 505 | 500 | Outer reference to upper scope-level is allowed |
|
159 | CS | 786 | 832 | 803 | 866 | 828 | 818 | 796 | 846 | 808 | 807 | 796 | 790 | 834 | 843 | 847 | 795 | 753 | 779 | 743 | 755 | 750 | 741 | 773 | 751 | 752 | 750 | 751 | 783 | 751 | 751 | 749 | Outer reference to upper scope-level is allowed |
|
160 | SS | 522 | 564 | 551 | 543 | 550 | 528 | 550 | 543 | 527 | 557 | 545 | 530 | 531 | 545 | 547 | 530 | 504 | 517 | 502 | 505 | 506 | 506 | 502 | 502 | 508 | 509 | 502 | 512 | 506 | 504 | 517 | Outer reference to upper scope-level is allowed |
|
161 | CS | 784 | 839 | 790 | 802 | 791 | 795 | 802 | 811 | 796 | 792 | 795 | 787 | 859 | 839 | 800 | 814 | 778 | 781 | 743 | 746 | 749 | 751 | 758 | 756 | 750 | 752 | 763 | 753 | 779 | 750 | 755 | FIRST / SKIP inside derived table |
|
162 | SS | 532 | 572 | 546 | 563 | 540 | 534 | 534 | 560 | 576 | 532 | 537 | 559 | 539 | 553 | 538 | 536 | 528 | 533 | 496 | 502 | 502 | 502 | 515 | 528 | 515 | 518 | 500 | 506 | 516 | 502 | 517 | FIRST / SKIP inside derived table |
|
163 | CS | 788 | 795 | 788 | 798 | 790 | 806 | 805 | 812 | 812 | 831 | 801 | 796 | 794 | 825 | 817 | 791 | 752 | 787 | 751 | 747 | 755 | 749 | 766 | 749 | 755 | 751 | 753 | 751 | 788 | 759 | 750 | UNION inside derived table |
|
164 | SS | 529 | 546 | 533 | 547 | 537 | 529 | 533 | 535 | 555 | 547 | 543 | 547 | 549 | 530 | 549 | 631 | 518 | 532 | 501 | 498 | 506 | 500 | 499 | 504 | 503 | 503 | 504 | 502 | 500 | 497 | 523 | UNION inside derived table |
|
165 | CS | 797 | 798 | 839 | 807 | 799 | 791 | 799 | 799 | 859 | 812 | 804 | 801 | 791 | 838 | 800 | 803 | 760 | 820 | 758 | 748 | 753 | 754 | 806 | 750 | 752 | 757 | 767 | 758 | 797 | 754 | 770 | Simple derived table with aggregate inside |
|
166 | SS | 530 | 549 | 536 | 543 | 530 | 551 | 539 | 537 | 602 | 658 | 535 | 548 | 530 | 547 | 534 | 533 | 507 | 512 | 531 | 516 | 502 | 515 | 521 | 512 | 503 | 514 | 503 | 504 | 514 | 505 | 506 | Simple derived table with aggregate inside |
|
167 | CS | 794 | 802 | 811 | 798 | 795 | 794 | 841 | 844 | 824 | 804 | 800 | 795 | 786 | 794 | 838 | 847 | 782 | 801 | 749 | 752 | 762 | 751 | 751 | 749 | 740 | 756 | 749 | 772 | 804 | 754 | 791 | Aggregate inside derived table |
|
168 | SS | 526 | 548 | 547 | 547 | 551 | 547 | 548 | 552 | 547 | 531 | 529 | 529 | 531 | 560 | 550 | 532 | 518 | 514 | 511 | 523 | 515 | 522 | 513 | 499 | 514 | 508 | 507 | 511 | 524 | 512 | 505 | Aggregate inside derived table |
|
169 | CS | 791 | 802 | 823 | 794 | 837 | 790 | 842 | 819 | 804 | 819 | 800 | 786 | 808 | 813 | 801 | 806 | 779 | 829 | 764 | 758 | 751 | 748 | 761 | 750 | 793 | 773 | 752 | 737 | 768 | 757 | 766 | Aggregate inside derived table |
|
170 | SS | 530 | 573 | 533 | 548 | 546 | 547 | 531 | 554 | 567 | 540 | 546 | 566 | 536 | 561 | 548 | 529 | 512 | 515 | 518 | 653 | 504 | 513 | 504 | 507 | 514 | 502 | 516 | 510 | 508 | 512 | 503 | Aggregate inside derived table |
|
171 | CS | 794 | 813 | 793 | 801 | 810 | 798 | 806 | 834 | 796 | 845 | 846 | 800 | 795 | 873 | 825 | 830 | 749 | 817 | 745 | 768 | 752 | 756 | 745 | 766 | 776 | 755 | 762 | 752 | 776 | 761 | 745 | Sub-select inside derived table |
|
172 | SS | 526 | 573 | 537 | 561 | 546 | 528 | 547 | 541 | 537 | 540 | 544 | 524 | 531 | 562 | 560 | 537 | 500 | 495 | 501 | 503 | 519 | 509 | 516 | 521 | 503 | 503 | 500 | 505 | 499 | 877 | 503 | Sub-select inside derived table |
|
173 | CS | 791 | 1269 | 814 | 803 | 794 | 802 | 831 | 891 | 849 | 791 | 792 | 826 | 798 | 846 | 791 | 855 | 762 | 821 | 773 | 752 | 752 | 741 | 747 | 762 | 753 | 752 | 771 | 750 | 779 | 764 | 751 | Sub-select inside derived table |
|
174 | SS | 531 | 552 | 544 | 552 | 545 | 534 | 531 | 533 | 555 | 532 | 549 | 542 | 529 | 562 | 558 | 567 | 521 | 523 | 513 | 500 | 501 | 515 | 514 | 543 | 501 | 519 | 505 | 500 | 560 | 503 | 516 | Sub-select inside derived table |
|
175 | CS | 794 | 809 | 799 | 800 | 799 | 827 | 834 | 831 | 804 | 801 | 812 | 802 | 801 | 787 | 804 | 823 | 805 | 789 | 750 | 756 | 749 | 757 | 753 | 750 | 746 | 757 | 763 | 768 | 758 | 771 | 753 | Implicit derived table by IN predicate |
|
176 | SS | 527 | 548 | 538 | 543 | 529 | 553 | 548 | 530 | 537 | 530 | 544 | 526 | 532 | 553 | 552 | 536 | 511 | 506 | 502 | 502 | 499 | 515 | 518 | 504 | 498 | 551 | 499 | 514 | 500 | 512 | 501 | Implicit derived table by IN predicate |
|
177 | CS | 800 | 850 | 817 | 830 | 841 | 803 | 856 | 848 | 799 | 821 | 821 | 835 | 830 | 857 | 876 | 843 | 771 | 802 | 758 | 762 | 763 | 754 | 762 | 753 | 750 | 773 | 757 | 761 | 773 | 767 | 792 | Derived table outer reference (triggers) |
|
178 | SS | 541 | 568 | 565 | 547 | 562 | 560 | 567 | 568 | 535 | 541 | 560 | 552 | 556 | 563 | 558 | 560 | 541 | 535 | 518 | 528 | 520 | 521 | 533 | 531 | 520 | 519 | 518 | 521 | 551 | 529 | 503 | Derived table outer reference (triggers) |
|
179 | CS | 795 | 838 | 797 | 801 | 843 | 846 | 816 | 849 | 848 | 836 | 815 | 793 | 839 | 811 | 818 | 835 | 773 | 799 | 750 | 759 | 764 | 759 | 758 | 750 | 752 | 753 | 793 | 761 | 749 | 759 | 791 | Non-Recursive CTEs |
|
180 | SS | 532 | 593 | 551 | 567 | 543 | 537 | 548 | 561 | 537 | 548 | 548 | 530 | 534 | 531 | 557 | 553 | 501 | 501 | 508 | 500 | 541 | 503 | 543 | 510 | 502 | 508 | 514 | 516 | 497 | 497 | 517 | Non-Recursive CTEs |
|
181 | CS | 799 | 811 | 818 | 799 | 802 | 862 | 825 | 825 | 800 | 842 | 843 | 839 | 834 | 855 | 827 | 812 | 784 | 796 | 767 | 758 | 752 | 757 | 749 | 767 | 771 | 750 | 762 | 805 | 766 | 751 | 774 | Recursive CTEs |
|
182 | SS | 528 | 550 | 555 | 543 | 562 | 546 | 565 | 529 | 560 | 536 | 528 | 576 | 527 | 560 | 562 | 592 | 503 | 504 | 524 | 502 | 520 | 528 | 520 | 509 | 502 | 514 | 529 | 518 | 509 | 499 | 516 | Recursive CTEs |
|
183 | CS | 799 | 839 | 832 | 852 | 817 | 800 | 809 | 819 | 853 | 800 | 850 | 812 | 798 | 837 | 812 | 798 | 819 | 811 | 757 | 747 | 765 | 777 | 749 | 756 | 747 | 773 | 756 | 796 | 756 | 759 | 763 | MERGE statement |
|
184 | SS | 533 | 545 | 724 | 540 | 559 | 545 | 555 | 533 | 529 | 533 | 764 | 561 | 531 | 717 | 547 | 569 | 879 | 503 | 610 | 747 | 534 | 503 | 521 | 501 | 503 | 511 | 519 | 516 | 503 | 519 | 505 | MERGE statement |
|
185 | CS | 624 | 627 | 624 | 628 | 653 | 628 | 633 | 630 | 631 | 629 | 624 | 634 | 636 | 687 | 649 | 648 | 597 | 630 | 572 | 574 | 605 | 581 | 577 | 579 | 571 | 587 | 576 | 589 | 581 | 605 | 577 | Computed fields |
|
186 | SS | 407 | 435 | 434 | 425 | 424 | 435 | 418 | 421 | 417 | 418 | 423 | 427 | 421 | 414 | 427 | 423 | 387 | 389 | 397 | 392 | 392 | 394 | 387 | 401 | 396 | 389 | 390 | 393 | 393 | 380 | 381 | Computed fields |
|
187 | CS | 977 | 993 | 1013 | 1055 | 982 | 994 | 1000 | 996 | 990 | 1046 | 1056 | 1031 | 1010 | 1023 | 1038 | 1073 | 953 | 906 | 972 | 909 | 955 | 893 | 956 | 895 | 958 | 944 | 909 | 941 | 896 | 910 | 950 | gtcs-proc-isql-11 |
|
188 | SS | 633 | 689 | 662 | 670 | 660 | 670 | 657 | 657 | 652 | 673 | 673 | 672 | 658 | 669 | 670 | 694 | 615 | 603 | 608 | 605 | 606 | 604 | 611 | 592 | 600 | 614 | 613 | 594 | 606 | 602 | 599 | gtcs-proc-isql-11 |
|
189 | CS | 985 | 998 | 1007 | 1090 | 1003 | 1011 | 1001 | 1021 | 991 | 985 | 986 | 1011 | 991 | 998 | 1015 | 1031 | 958 | 938 | 1024 | 903 | 922 | 899 | 935 | 903 | 893 | 925 | 919 | 886 | 915 | 894 | 948 | gtcs-proc-isql-15 |
|
190 | SS | 652 | 685 | 698 | 674 | 669 | 672 | 674 | 664 | 671 | 661 | 678 | 656 | 657 | 691 | 668 | 675 | 611 | 613 | 618 | 629 | 628 | 579 | 608 | 596 | 614 | 624 | 648 | 600 | 578 | 581 | 600 | gtcs-proc-isql-15 |
|
191 | CS | 985 | 1003 | 1007 | 1030 | 988 | 990 | 1077 | 999 | 1053 | 1016 | 1050 | 1012 | 1035 | 1028 | 1034 | 1017 | 898 | 969 | 972 | 903 | 939 | 895 | 921 | 913 | 899 | 982 | 900 | 900 | 890 | 891 | 930 | gtcs-proc-isql-16 |
|
192 | SS | 638 | 694 | 659 | 678 | 671 | 647 | 654 | 659 | 671 | 668 | 667 | 653 | 659 | 679 | 673 | 658 | 616 | 608 | 602 | 603 | 594 | 595 | 625 | 597 | 595 | 626 | 629 | 594 | 579 | 578 | 593 | gtcs-proc-isql-16 |
|
193 | CS | 981 | 1053 | 1011 | 990 | 1048 | 1012 | 997 | 1007 | 1012 | 1020 | 988 | 980 | 989 | 1018 | 1080 | 983 | 1033 | 907 | 928 | 942 | 945 | 893 | 942 | 899 | 905 | 941 | 912 | 898 | 911 | 951 | 900 | Test for select from SP that deletes record after its output |
|
194 | SS | 657 | 725 | 663 | 675 | 672 | 675 | 671 | 659 | 661 | 677 | 687 | 668 | 661 | 674 | 683 | 655 | 609 | 610 | 608 | 609 | 608 | 602 | 660 | 612 | 612 | 611 | 612 | 614 | 595 | 597 | 601 | Test for select from SP that deletes record after its output |
|
195 | CS | 592 | 610 | 642 | 595 | 627 | 630 | 634 | 608 | 607 | 593 | 629 | 598 | 596 | 626 | 636 | 635 | 563 | 549 | 548 | 591 | 563 | 544 | 558 | 541 | 550 | 564 | 544 | 575 | 582 | 584 | 547 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
196 | SS | 389 | 419 | 407 | 389 | 400 | 403 | 391 | 392 | 396 | 408 | 403 | 389 | 399 | 406 | 402 | 407 | 367 | 385 | 378 | 369 | 373 | 375 | 373 | 362 | 362 | 378 | 363 | 390 | 388 | 365 | 359 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
197 | CS | 781 | 849 | 803 | 823 | 807 | 781 | 814 | 804 | 801 | 850 | 797 | 835 | 831 | 845 | 801 | 808 | 781 | 754 | 750 | 753 | 743 | 754 | 768 | 750 | 762 | 770 | 756 | 766 | 760 | 750 | 763 | COUNT |
|
198 | SS | 530 | 778 | 537 | 554 | 530 | 532 | 530 | 547 | 1026 | 546 | 576 | 528 | 533 | 569 | 569 | 565 | 519 | 534 | 536 | 500 | 531 | 497 | 504 | 500 | 508 | 503 | 501 | 514 | 511 | 504 | 497 | COUNT |
|
199 | CS | 580 | 589 | 582 | 588 | 586 | 586 | 597 | 621 | 585 | 592 | 590 | 620 | 592 | 587 | 582 | 598 | 569 | 561 | 548 | 579 | 566 | 546 | 540 | 546 | 536 | 543 | 549 | 540 | 545 | 543 | 544 | EXTRACT(WEEK FROM DATE) |
|
200 | SS | 378 | 405 | 379 | 395 | 394 | 395 | 377 | 397 | 391 | 388 | 391 | 386 | 393 | 393 | 412 | 396 | 368 | 379 | 375 | 363 | 359 | 367 | 368 | 363 | 359 | 362 | 359 | 365 | 364 | 367 | 355 | EXTRACT(WEEK FROM DATE) |
|
201 | CS | 578 | 620 | 589 | 582 | 639 | 585 | 606 | 618 | 584 | 580 | 581 | 579 | 610 | 611 | 578 | 585 | 541 | 590 | 559 | 539 | 546 | 545 | 553 | 537 | 566 | 552 | 569 | 538 | 547 | 541 | 537 | TRUNC( <number> [, <number> ] ) |
|
202 | SS | 387 | 406 | 387 | 394 | 393 | 388 | 461 | 390 | 690 | 389 | 388 | 392 | 390 | 388 | 432 | 394 | 383 | 360 | 389 | 355 | 375 | 367 | 359 | 356 | 359 | 369 | 360 | 360 | 372 | 356 | 359 | TRUNC( <number> [, <number> ] ) |
|
203 | CS | 579 | 590 | 586 | 583 | 620 | 590 | 592 | 595 | 584 | 630 | 583 | 592 | 591 | 584 | 584 | 578 | 538 | 542 | 567 | 547 | 545 | 544 | 544 | 555 | 548 | 549 | 572 | 580 | 577 | 532 | 566 | POSITION( <string> IN <string> ) |
|
204 | SS | 376 | 412 | 376 | 378 | 394 | 398 | 387 | 391 | 377 | 390 | 393 | 396 | 388 | 387 | 389 | 381 | 374 | 369 | 361 | 367 | 372 | 374 | 360 | 364 | 356 | 363 | 380 | 357 | 364 | 360 | 361 | POSITION( <string> IN <string> ) |
|
205 | CS | 585 | 626 | 590 | 593 | 614 | 606 | 616 | 585 | 663 | 584 | 617 | 591 | 617 | 602 | 616 | 598 | 548 | 536 | 555 | 555 | 576 | 580 | 586 | 556 | 713 | 562 | 550 | 585 | 539 | 554 | 536 | Test for TRUNC function |
|
206 | SS | 376 | 403 | 398 | 382 | 389 | 388 | 401 | 393 | 386 | 410 | 396 | 383 | 379 | 394 | 391 | 401 | 361 | 360 | 373 | 368 | 363 | 360 | 369 | 359 | 364 | 361 | 368 | 368 | 365 | 368 | 351 | Test for TRUNC function |
|
207 | CS | 2264 | 2275 | 2316 | 2284 | 2285 | 2301 | 2286 | 2426 | 2275 | 2273 | 2326 | 2294 | 2244 | 2318 | 2323 | 2334 | 2156 | 2124 | 2217 | 2123 | 2197 | 2108 | 2146 | 2115 | 2256 | 2127 | 2154 | 3366 | 2129 | 2145 | 2135 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
208 | SS | 1238 | 1249 | 1259 | 1259 | 1242 | 1257 | 1255 | 1254 | 1243 | 1236 | 1258 | 1241 | 1303 | 1341 | 1421 | 1265 | 1159 | 1219 | 1177 | 1169 | 1164 | 1215 | 1462 | 1147 | 1220 | 1174 | 1164 | 1153 | 1164 | 1229 | 1137 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
209 | CS | 28965 | 29160 | 28994 | 29015 | 28967 | 29092 | 28972 | 29143 | 29056 | 28963 | 29483 | 28980 | 29278 | 29056 | 29190 | 29333 | 28939 | 28845 | 29019 | 28850 | 28830 | 28827 | 28841 | 28876 | 28912 | 28796 | 28838 | 28865 | 28780 | 28821 | 28805 | External Connections Pool, functionality test 01 |
|
210 | SS | 27247 | 27612 | 27280 | 27253 | 27237 | 27249 | 27252 | 27246 | 27242 | 27250 | 27245 | 27260 | 27282 | 27335 | 27581 | 27314 | 27191 | 27177 | 27168 | 27143 | 27145 | 27791 | 27168 | 27159 | 27143 | 27144 | 27354 | 27393 | 27180 | 27308 | 27154 | External Connections Pool, functionality test 01 |
|
211 | CS | 1008 | 1051 | 1114 | 1063 | 1015 | 1022 | 1064 | 1045 | 1034 | 1048 | 1024 | 1038 | 1119 | 1081 | 1094 | 1041 | 970 | 957 | 941 | 944 | 998 | 936 | 938 | 936 | 926 | 936 | 937 | 964 | 1002 | 927 | 937 | Common SQL. Check correctness of the results |
|
212 | SS | 686 | 727 | 691 | 1060 | 723 | 703 | 707 | 705 | 707 | 743 | 701 | 733 | 705 | 716 | 746 | 697 | 674 | 682 | 638 | 641 | 677 | 663 | 649 | 659 | 648 | 664 | 658 | 628 | 626 | 669 | 632 | Common SQL. Check correctness of the results |
|
213 | CS | 1009 | 1057 | 1009 | 1019 | 1017 | 1020 | 1020 | 1049 | 1045 | 1016 | 1008 | 1016 | 1080 | 1009 | 1066 | 1031 | 989 | 994 | 995 | 1019 | 956 | 953 | 1002 | 950 | 1025 | 1004 | 958 | 1002 | 987 | 950 | 945 | Common SQL. Check correctness of the results |
|
214 | SS | 693 | 723 | 699 | 1084 | 692 | 698 | 703 | 702 | 691 | 760 | 699 | 747 | 700 | 717 | 744 | 699 | 673 | 704 | 659 | 656 | 695 | 669 | 664 | 669 | 648 | 672 | 690 | 692 | 657 | 678 | 669 | Common SQL. Check correctness of the results |
|
215 | CS | 809 | 840 | 815 | 804 | 853 | 818 | 860 | 854 | 827 | 827 | 835 | 844 | 819 | 839 | 836 | 842 | 761 | 765 | 757 | 754 | 750 | 757 | 746 | 794 | 760 | 766 | 777 | 861 | 758 | 759 | 753 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
216 | SS | 558 | 580 | 570 | 895 | 557 | 564 | 565 | 565 | 565 | 559 | 565 | 547 | 573 | 558 | 607 | 577 | 537 | 537 | 572 | 521 | 532 | 530 | 531 | 532 | 534 | 523 | 537 | 891 | 510 | 568 | 524 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
217 | CS | 7246 | 4320 | 8286 | 7258 | 8247 | 8272 | 8343 | 7321 | 7465 | 7430 | 7240 | 7252 | 8635 | 8361 | 7324 | 8323 | 7189 | 7204 | 7166 | 8172 | 6210 | 6183 | 6167 | 6146 | 6198 | 6184 | 6177 | 7567 | 6173 | 7235 | 6536 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
218 | SS | 5899 | 3106 | 5897 | 6287 | 5920 | 5936 | 5973 | 5889 | 5901 | 5902 | 5979 | 5932 | 5904 | 5946 | 6802 | 5908 | 5850 | 5910 | 5879 | 5984 | 5868 | 5849 | 5844 | 5873 | 5876 | 5867 | 5844 | 5873 | 5858 | 5924 | 5842 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
219 | CS | 7274 | 3342 | 7292 | 8225 | 8199 | 7256 | 8260 | 8207 | 8314 | 8237 | 8675 | 8209 | 8213 | 8271 | 8247 | 8234 | 6196 | 6165 | 8130 | 6144 | 6163 | 6160 | 6174 | 6165 | 6142 | 6151 | 7164 | 7756 | 7143 | 7167 | 7147 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
220 | SS | 5861 | 3080 | 5857 | 6249 | 5882 | 5868 | 5869 | 5875 | 5913 | 5869 | 5888 | 5860 | 5862 | 5865 | 5945 | 5886 | 5837 | 5885 | 5816 | 5832 | 5821 | 5839 | 5815 | 5808 | 5825 | 5816 | 5919 | 5831 | 5818 | 5878 | 5824 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
221 | CS | 7238 | 3373 | 8274 | 8303 | 8320 | 8225 | 8272 | 8344 | 8368 | 7276 | 7262 | 8225 | 8277 | 8331 | 8291 | 8294 | 7243 | 7182 | 6157 | 7182 | 6202 | 7150 | 7197 | 6136 | 6184 | 7234 | 6183 | 6214 | 7201 | 6225 | 6562 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
222 | SS | 5903 | 3099 | 5907 | 6383 | 5934 | 5930 | 5936 | 5889 | 5907 | 5903 | 5918 | 5904 | 5928 | 5925 | 5978 | 5915 | 5896 | 5923 | 5844 | 5830 | 5873 | 5834 | 5856 | 5857 | 5861 | 5856 | 6066 | 5853 | 5885 | 6512 | 5842 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
223 | CS | 46166 | 4518 | 54133 | 53199 | 55272 | 54243 | 52417 | 56616 | 53772 | 53642 | 54160 | 55250 | 57005 | 52517 | 54629 | 52683 | 44877 | 46075 | 43859 | 44638 | 44871 | 45536 | 44708 | 44666 | 44788 | 46257 | 45806 | 44518 | 45816 | 43681 | 45109 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
224 | SS | 41269 | 3382 | 41495 | 43099 | 41252 | 41413 | 41462 | 41740 | 41345 | 41412 | 41231 | 41287 | 41398 | 41662 | 42042 | 41375 | 41354 | 41202 | 41022 | 41004 | 41120 | 41109 | 40992 | 41245 | 41082 | 41015 | 42400 | 41018 | 41118 | 42572 | 41249 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
225 | CS | 7147 | 4299 | 8295 | 8281 | 7228 | 8255 | 8231 | 8228 | 8252 | 8223 | 7548 | 7247 | 8201 | 8262 | 8236 | 8327 | 6141 | 7149 | 6132 | 6158 | 6154 | 6162 | 6127 | 6142 | 6453 | 7145 | 7139 | 6178 | 6289 | 6175 | 6148 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
226 | SS | 5861 | 3106 | 5889 | 6388 | 5861 | 5888 | 5879 | 5888 | 5876 | 5870 | 5881 | 5869 | 5873 | 5891 | 5904 | 5875 | 5841 | 5840 | 5802 | 5837 | 5838 | 5807 | 5827 | 5828 | 5847 | 5861 | 5836 | 5828 | 5844 | 6288 | 5835 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
227 | CS | 6738 | 4345 | 8216 | 8214 | 8276 | 8213 | 8262 | 6277 | 8626 | 8221 | 8248 | 8201 | 8345 | 7251 | 8316 | 8276 | 7249 | 6170 | 6151 | 7163 | 6182 | 6314 | 6184 | 6248 | 6185 | 6171 | 6162 | 6180 | 6144 | 6139 | 6159 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
228 | SS | 5871 | 3099 | 6881 | 6105 | 5874 | 5923 | 5909 | 5903 | 5884 | 5879 | 5896 | 5857 | 5878 | 5901 | 5933 | 5929 | 5819 | 5861 | 5799 | 5805 | 5832 | 5831 | 5827 | 5835 | 5840 | 5845 | 6866 | 5838 | 5837 | 5876 | 5868 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
229 | CS | 7662 | 4533 | 7702 | 8665 | 7684 | 8742 | 8690 | 8996 | 8736 | 8659 | 8655 | 8689 | 8659 | 7691 | 9017 | 8790 | 6566 | 7640 | 7583 | 7565 | 6590 | 7561 | 6563 | 6537 | 6592 | 7591 | 6568 | 8574 | 7601 | 6676 | 6652 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
230 | SS | 6195 | 3229 | 6206 | 6191 | 6192 | 6216 | 6224 | 6224 | 6193 | 6207 | 6227 | 6202 | 6226 | 6211 | 6516 | 6249 | 6161 | 6132 | 6140 | 6149 | 6164 | 6149 | 6203 | 6126 | 6165 | 6120 | 6290 | 6289 | 6138 | 6197 | 6133 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
231 | CS | 7318 | 4317 | 8231 | 8208 | 8274 | 8250 | 7269 | 8253 | 8257 | 8229 | 8192 | 8592 | 8270 | 8253 | 8258 | 8295 | 7168 | 6201 | 6384 | 6144 | 6154 | 7494 | 6178 | 6202 | 7157 | 6373 | 6256 | 7367 | 6123 | 7188 | 6160 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
232 | SS | 5851 | 3084 | 5893 | 5887 | 5895 | 5877 | 5917 | 5881 | 5911 | 5901 | 5850 | 5866 | 5896 | 5940 | 6138 | 5903 | 5852 | 5831 | 5835 | 5797 | 5834 | 5825 | 5809 | 5832 | 5831 | 5831 | 5825 | 5833 | 5826 | 5870 | 5837 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
233 | CS | 7217 | 4292 | 8206 | 8231 | 8216 | 8222 | 8238 | 8228 | 7228 | 8351 | 8211 | 8242 | 8208 | 7231 | 8667 | 8309 | 8401 | 6187 | 7173 | 6145 | 7181 | 6162 | 7160 | 7207 | 6155 | 7142 | 7120 | 6202 | 6226 | 7137 | 6162 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
234 | SS | 5850 | 3068 | 5907 | 5848 | 5896 | 5838 | 5946 | 6037 | 5855 | 5877 | 5882 | 5866 | 5910 | 5909 | 5921 | 5864 | 5869 | 5801 | 5812 | 5815 | 5832 | 5822 | 5810 | 5807 | 5816 | 5835 | 5830 | 6829 | 5806 | 5853 | 5814 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
235 | CS | 7234 | 4314 | 8277 | 8280 | 8262 | 7231 | 8256 | 7307 | 8706 | 8283 | 8358 | 7290 | 8473 | 7238 | 8276 | 7312 | 6139 | 7227 | 8165 | 6139 | 6217 | 6174 | 6224 | 6185 | 6187 | 6179 | 6153 | 6146 | 8180 | 6158 | 7173 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
236 | SS | 5871 | 3067 | 6222 | 5886 | 5865 | 5907 | 5897 | 6136 | 5885 | 5877 | 5872 | 5875 | 5872 | 5956 | 6467 | 5888 | 5886 | 5851 | 5828 | 5823 | 5812 | 5832 | 5839 | 5839 | 5830 | 5829 | 6201 | 5819 | 5851 | 5870 | 5837 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
237 | CS | 8578 | 4517 | 8684 | 8664 | 8661 | 8653 | 8659 | 8728 | 8677 | 8906 | 8655 | 8729 | 8699 | 8717 | 8739 | 8690 | 7611 | 6549 | 7586 | 7628 | 8576 | 6936 | 8581 | 6637 | 6620 | 7566 | 6638 | 8164 | 6565 | 7552 | 6564 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
238 | SS | 6163 | 3235 | 5870 | 6198 | 6195 | 6196 | 6222 | 6233 | 6203 | 6201 | 6175 | 6200 | 6211 | 6287 | 6311 | 6161 | 6154 | 6159 | 6127 | 6165 | 6120 | 6153 | 6149 | 6139 | 6143 | 6135 | 6134 | 6145 | 6123 | 6201 | 6179 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
239 | CS | 7167 | 4324 | 8246 | 8248 | 8231 | 8224 | 8267 | 8245 | 8207 | 8613 | 7335 | 7274 | 8218 | 7304 | 8262 | 8252 | 6172 | 6190 | 6225 | 7165 | 6192 | 7169 | 6168 | 6131 | 6138 | 6378 | 6260 | 6179 | 6186 | 6199 | 6164 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
240 | SS | 5863 | 3064 | 6890 | 5866 | 5929 | 6229 | 5892 | 5862 | 5885 | 5892 | 5877 | 5907 | 5859 | 5920 | 5926 | 6886 | 5867 | 5850 | 5805 | 5826 | 5830 | 5827 | 5843 | 5836 | 5834 | 5835 | 5838 | 5820 | 5874 | 5864 | 5818 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
241 | CS | 7258 | 4301 | 8242 | 8230 | 8237 | 8208 | 8253 | 8254 | 8216 | 7463 | 8289 | 8469 | 8191 | 7248 | 8252 | 8239 | 6212 | 7175 | 7363 | 6176 | 7154 | 6435 | 6132 | 6179 | 7155 | 7268 | 6144 | 6346 | 6525 | 6206 | 6166 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
242 | SS | 5865 | 3090 | 5860 | 5925 | 5882 | 5880 | 5952 | 5879 | 5896 | 5899 | 5864 | 5872 | 6016 | 5881 | 6913 | 5892 | 5831 | 5843 | 5817 | 5814 | 5870 | 5866 | 5830 | 5838 | 5823 | 5846 | 5827 | 6178 | 5831 | 5852 | 5823 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
243 | CS | 7263 | 4327 | 7271 | 8215 | 8289 | 7256 | 8233 | 8303 | 8261 | 8231 | 8237 | 8232 | 8291 | 7288 | 8270 | 7283 | 7484 | 6220 | 8510 | 6199 | 7151 | 6148 | 6186 | 6196 | 6187 | 6204 | 6226 | 6390 | 6533 | 7172 | 6187 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
244 | SS | 5877 | 3082 | 5902 | 5891 | 5909 | 5897 | 5888 | 5935 | 5890 | 5903 | 5905 | 5880 | 6064 | 5939 | 5924 | 5892 | 5843 | 5875 | 5884 | 5843 | 5844 | 5847 | 5844 | 5818 | 5836 | 5859 | 5858 | 5833 | 5833 | 5867 | 5835 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
245 | CS | 8289 | 4368 | 8387 | 8315 | 8356 | 7282 | 8353 | 8347 | 7679 | 8391 | 8370 | 8692 | 8311 | 8438 | 7623 | 8365 | 8301 | 8303 | 8272 | 7230 | 8248 | 8245 | 8262 | 8284 | 8209 | 8255 | 8237 | 8446 | 8257 | 8250 | 8295 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
246 | SS | 6640 | 3820 | 6923 | 6667 | 6659 | 6678 | 6734 | 6764 | 6991 | 6673 | 6914 | 6673 | 6682 | 5991 | 6769 | 6012 | 5638 | 6626 | 6613 | 6619 | 6637 | 5860 | 6623 | 6629 | 6602 | 6643 | 6889 | 6631 | 6628 | 6680 | 6620 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
247 | CS | 7207 | 4362 | 8222 | 8221 | 7273 | 8283 | 8266 | 8308 | 8230 | 8227 | 8422 | 8223 | 6243 | 8306 | 8310 | 8236 | 7204 | 8163 | 7211 | 6160 | 6160 | 6133 | 6171 | 6153 | 6146 | 6174 | 6136 | 6570 | 7153 | 6159 | 6150 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
248 | SS | 5863 | 3066 | 5886 | 5871 | 5869 | 5895 | 5889 | 5865 | 5911 | 5881 | 5862 | 5898 | 5875 | 5898 | 6334 | 5891 | 5859 | 5842 | 5829 | 5824 | 5834 | 5862 | 5838 | 5848 | 5829 | 5858 | 5965 | 5828 | 5830 | 5879 | 5822 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
249 | CS | 810 | 843 | 786 | 824 | 809 | 828 | 837 | 827 | 831 | 845 | 858 | 816 | 796 | 842 | 817 | 851 | 812 | 813 | 784 | 759 | 787 | 751 | 751 | 753 | 750 | 838 | 799 | 753 | 756 | 789 | 782 | CREATE VIEW |
|
250 | SS | 543 | 567 | 560 | 553 | 552 | 547 | 582 | 547 | 552 | 551 | 546 | 546 | 936 | 558 | 547 | 558 | 507 | 523 | 529 | 500 | 516 | 520 | 502 | 518 | 500 | 520 | 540 | 523 | 503 | 523 | 520 | CREATE VIEW |