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.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
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 | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ORDER BY on a VIEW turns values in fields into NULL |
|
6 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ORDER BY on a VIEW turns values in fields into NULL |
|
7 | CS | F | P | P | P | P | P | 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 on derived fields processing NULL data kills IB |
|
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 | Grouping on derived fields processing NULL data kills IB |
|
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 | P | P | P | P | 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 |
|
104 | 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 |
|
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 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
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 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
107 | 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 |
|
108 | 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 |
|
109 | 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 |
|
110 | 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 |
|
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 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
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 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
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 | Parametrized queries using RDB$DB_KEY do not work |
|
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 | Parametrized queries using RDB$DB_KEY do not work |
|
115 | 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 |
|
116 | 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 |
|
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 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
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 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
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 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
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 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
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 | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
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 | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
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 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
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 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
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 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
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 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
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 | SEC$ tables and tag/attributes |
|
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 | SEC$ tables and tag/attributes |
|
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 | Window Function: named window |
|
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 | Window Function: named window |
|
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 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
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 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
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 | Reject non-constant date/time/timestamp literals |
|
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 | Reject non-constant date/time/timestamp literals |
|
135 | 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 | Date-time parsing is very weak |
|
136 | 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 | Date-time parsing is very weak |
|
137 | 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 |
|
138 | 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 |
|
139 | SS | F | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | F | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
|
140 | 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 |
|
141 | 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 |
|
142 | 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 |
|
143 | 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 |
|
144 | 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 |
|
145 | 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 |
|
146 | 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 |
|
147 | 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 |
|
148 | 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 |
|
149 | 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 |
|
150 | 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 |
|
151 | 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 |
|
152 | 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 |
|
153 | 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 |
|
154 | 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 |
|
155 | 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 |
|
156 | 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 |
|
157 | 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 |
|
158 | 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 |
|
159 | 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 |
|
160 | 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 |
|
161 | 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 |
|
162 | 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 |
|
163 | 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 |
|
164 | 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 |
|
165 | 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 |
|
166 | 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 |
|
167 | 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 |
|
168 | 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 |
|
169 | 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 |
|
170 | 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) |
|
171 | 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) |
|
172 | 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 ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
173 | 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 ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
174 | 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 ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
175 | 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 ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
176 | 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 |
|
177 | 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 |
|
178 | 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 |
|
179 | 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 |
|
180 | 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 |
|
181 | 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 |
|
182 | 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 | Check result or CAST() for misc agruments // from GTCS. |
|
183 | 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 | Check result or CAST() for misc agruments // from GTCS. |
|
184 | 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 |
|
185 | 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 |
|
186 | 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 | Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value. |
|
187 | 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 | Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value. |
|
188 | 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 | Verify result of INSERT DEFAULT for domain-based fields which have their own default values |
|
189 | 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 | Verify result of INSERT DEFAULT for domain-based fields which have their own default values |
|
190 | 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 | Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values |
|
191 | 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 | Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values |
|
192 | 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 | Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain |
|
193 | 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 | Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain |
|
194 | 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 |
|
195 | 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 |
|
196 | 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 |
|
197 | 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 |
|
198 | 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 |
|
199 | 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 |
|
200 | 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 |
|
201 | 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 |
|
202 | 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> |
|
203 | 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> |
|
204 | 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 | CAST CHAR -> TIME |
|
205 | 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 | CAST CHAR -> TIME |
|
206 | 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 | CAST CHAR -> TIME |
|
207 | 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 | CAST CHAR -> TIME |
|
208 | 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 | CAST TIMESTAMP -> TIME |
|
209 | 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 | CAST TIMESTAMP -> TIME |
|
210 | 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 |
|
211 | 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 |
|
212 | 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 |
|
213 | 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 |
|
214 | 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 |
|
215 | 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 |
|
216 | 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 milliseconds |
|
217 | 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 milliseconds |
|
218 | 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) |
|
219 | 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) |
|
220 | 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> ] ) |
|
221 | 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> ] ) |
|
222 | 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> ) |
|
223 | 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> ) |
|
224 | 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 |
|
225 | 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 |
|
226 | 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 | UNLIST function. Check output for different returning types |
|
227 | 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 | UNLIST function. Check output for different returning types |
|
228 | 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. |
|
229 | 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. |
|
230 | 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 | F | P | External Connections Pool, functionality test 01 |
|
231 | 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 |
|
232 | 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 |
|
233 | 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 |
|
234 | 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 |
|
235 | 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 |
|
236 | 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) |
|
237 | 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) |
|
238 | 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 |
|
239 | 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 |
|
240 | 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 |
|
241 | 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 |
|
242 | 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. |
|
243 | 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. |
|
244 | 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. |
|
245 | 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. |
|
246 | 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. |
|
247 | 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. |
|
248 | 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. |
|
249 | 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. |
|
250 | 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. |
|
251 | 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. |
|
252 | 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. |
|
253 | 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. |
|
254 | 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. |
|
255 | 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. |
|
256 | 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. |
|
257 | 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. |
|
258 | 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. |
|
259 | 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. |
|
260 | 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. |
|
261 | 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. |
|
262 | 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. |
|
263 | 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. |
|
264 | 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. |
|
265 | 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. |
|
266 | 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. |
|
267 | 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. |
|
268 | 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. |
|
269 | 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. |
|
270 | 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 |
|
271 | 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.849
|
6.0.0.848
|
6.0.0.845
|
6.0.0.843
|
6.0.0.840
|
6.0.0.838
|
6.0.0.835
|
6.0.0.834
|
6.0.0.800
|
6.0.0.799
|
6.0.0.797
|
6.0.0.795
|
6.0.0.792
|
6.0.0.791
|
6.0.0.789
|
6.0.0.787
|
6.0.0.783
|
6.0.0.779
|
6.0.0.778
|
6.0.0.776
|
6.0.0.770
|
6.0.0.767
|
6.0.0.762
|
6.0.0.755
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1664 | 2089 | 1853 | 1823 | 946 | 1618 | 1699 | 1542 | 1030 | 1318 | 1030 | 1028 | 1144 | 1020 | 998 | 1633 | 1875 | 1867 | 1887 | 1799 | 1824 | 1085 | 1752 | 1169 | 1670 | 1371 | 1711 | 1659 | 1828 | 1683 | 1896 | Index bug |
|
2 | SS | 766 | 936 | 676 | 724 | 811 | 783 | 851 | 699 | 809 | 748 | 861 | 762 | 725 | 860 | 861 | 724 | 770 | 800 | 751 | 848 | 747 | 754 | 654 | 798 | 714 | 806 | 637 | 683 | 781 | 748 | 786 | Index bug |
|
3 | CS | 1281 | 1237 | 902 | 811 | 1198 | 745 | 765 | 763 | 1303 | 787 | 779 | 1316 | 1298 | 752 | 746 | 1243 | 1293 | 1456 | 1442 | 1444 | 1529 | 1345 | 1253 | 908 | 1456 | 1344 | 1382 | 1475 | 1481 | 1269 | 1500 | Blob comparison with constant |
|
4 | SS | 521 | 503 | 521 | 537 | 531 | 472 | 544 | 496 | 598 | 529 | 630 | 472 | 540 | 503 | 514 | 498 | 468 | 521 | 530 | 601 | 513 | 505 | 540 | 530 | 552 | 579 | 518 | 560 | 502 | 457 | 484 | Blob comparison with constant |
|
5 | CS | 1066 | 609 | 795 | 608 | 1055 | 689 | 643 | 747 | 1158 | 636 | 571 | 1123 | 1159 | 597 | 1100 | 1178 | 1094 | 1171 | 1243 | 1204 | 1118 | 1142 | 1104 | 725 | 1057 | 1075 | 676 | 623 | 1180 | 1013 | 1193 | ORDER BY on a VIEW turns values in fields into NULL |
|
6 | SS | 450 | 484 | 469 | 425 | 485 | 413 | 464 | 432 | 408 | 478 | 475 | 410 | 443 | 386 | 472 | 472 | 457 | 459 | 403 | 490 | 499 | 409 | 412 | 429 | 496 | 436 | 474 | 372 | 442 | 418 | 457 | ORDER BY on a VIEW turns values in fields into NULL |
|
7 | CS | 1169 | 719 | 769 | 652 | 1133 | 681 | 733 | 808 | 1157 | 637 | 790 | 1198 | 1191 | 632 | 1216 | 1245 | 1219 | 1314 | 1170 | 1392 | 1278 | 1217 | 1199 | 744 | 1213 | 1168 | 1325 | 812 | 1241 | 681 | 1338 | Grouping on derived fields processing NULL data kills IB |
|
8 | SS | 516 | 410 | 524 | 509 | 516 | 531 | 517 | 498 | 501 | 568 | 518 | 478 | 457 | 442 | 514 | 442 | 561 | 478 | 546 | 539 | 512 | 527 | 537 | 533 | 572 | 503 | 528 | 574 | 560 | 476 | 510 | Grouping on derived fields processing NULL data kills IB |
|
9 | CS | 1295 | 812 | 1332 | 707 | 1289 | 1395 | 690 | 1308 | 726 | 708 | 839 | 779 | 760 | 1355 | 1352 | 1321 | 1388 | 1396 | 1428 | 1433 | 1460 | 1277 | 1301 | 843 | 1332 | 1325 | 794 | 755 | 1357 | 1285 | 903 | Incorrect handling of null within view - returns 0 |
|
10 | SS | 532 | 555 | 500 | 482 | 512 | 513 | 568 | 551 | 509 | 534 | 536 | 450 | 601 | 515 | 563 | 486 | 515 | 529 | 494 | 537 | 585 | 553 | 500 | 566 | 484 | 562 | 562 | 544 | 522 | 530 | 574 | Incorrect handling of null within view - returns 0 |
|
11 | CS | 1068 | 829 | 777 | 768 | 1207 | 1269 | 742 | 1366 | 765 | 757 | 741 | 841 | 779 | 776 | 1343 | 1333 | 1293 | 1374 | 1362 | 1334 | 1391 | 1445 | 1483 | 894 | 1329 | 1224 | 916 | 851 | 866 | 1189 | 947 | New value of column is accessable before update |
|
12 | SS | 544 | 536 | 515 | 528 | 672 | 544 | 560 | 566 | 562 | 591 | 610 | 506 | 565 | 537 | 595 | 576 | 490 | 545 | 560 | 572 | 525 | 548 | 508 | 542 | 540 | 573 | 531 | 523 | 505 | 543 | 554 | New value of column is accessable before update |
|
13 | CS | 1270 | 1353 | 1427 | 693 | 706 | 1305 | 729 | 1396 | 736 | 736 | 1264 | 783 | 754 | 1231 | 1277 | 1301 | 1154 | 1410 | 1341 | 1530 | 1308 | 1345 | 1532 | 867 | 1349 | 1377 | 1199 | 780 | 782 | 745 | 1502 | Incorrect results when left join on subquery with constant column |
|
14 | SS | 542 | 526 | 569 | 482 | 499 | 511 | 542 | 520 | 566 | 553 | 583 | 486 | 573 | 533 | 548 | 539 | 549 | 526 | 542 | 542 | 548 | 498 | 521 | 525 | 558 | 547 | 550 | 525 | 553 | 562 | 604 | Incorrect results when left join on subquery with constant column |
|
15 | CS | 1227 | 832 | 1285 | 731 | 812 | 1192 | 765 | 1189 | 736 | 811 | 1265 | 1044 | 1199 | 1255 | 1259 | 1297 | 1269 | 1285 | 1350 | 1382 | 1408 | 1383 | 1353 | 848 | 1361 | 1287 | 1173 | 851 | 903 | 767 | 1387 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
16 | SS | 539 | 500 | 546 | 455 | 477 | 547 | 544 | 550 | 532 | 548 | 582 | 556 | 539 | 515 | 550 | 487 | 509 | 523 | 525 | 531 | 550 | 539 | 548 | 538 | 575 | 561 | 568 | 534 | 554 | 522 | 496 | DISTINCT vs NULLS LAST clause: wrong order of NULLs |
|
17 | CS | 1240 | 850 | 1290 | 753 | 727 | 1330 | 989 | 1303 | 754 | 792 | 1301 | 776 | 744 | 1425 | 1302 | 1267 | 1211 | 1225 | 1315 | 1451 | 1897 | 1255 | 1280 | 833 | 1389 | 1408 | 1297 | 879 | 767 | 696 | 774 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
18 | SS | 529 | 483 | 513 | 517 | 571 | 527 | 592 | 575 | 511 | 544 | 558 | 480 | 530 | 522 | 528 | 513 | 536 | 503 | 555 | 565 | 562 | 550 | 536 | 542 | 544 | 516 | 524 | 510 | 508 | 545 | 471 | Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones |
|
19 | CS | 1139 | 1490 | 1389 | 703 | 698 | 1211 | 1249 | 1227 | 789 | 724 | 1009 | 934 | 659 | 1255 | 881 | 1376 | 1130 | 1318 | 1371 | 1269 | 2040 | 1148 | 1272 | 907 | 1366 | 1253 | 1098 | 958 | 764 | 736 | 676 | Estonian collation in UTF8 charset |
|
20 | SS | 541 | 877 | 545 | 496 | 492 | 495 | 564 | 534 | 540 | 521 | 555 | 553 | 542 | 519 | 476 | 538 | 519 | 539 | 518 | 638 | 546 | 579 | 552 | 576 | 523 | 553 | 558 | 491 | 446 | 563 | 603 | Estonian collation in UTF8 charset |
|
21 | CS | 1207 | 777 | 1350 | 765 | 813 | 1199 | 1098 | 1189 | 713 | 915 | 1215 | 1005 | 744 | 1230 | 1273 | 1307 | 1356 | 1223 | 1391 | 1321 | 1480 | 1420 | 1427 | 851 | 1392 | 1283 | 1323 | 915 | 778 | 773 | 813 | LIKE doesn't work for computed values (at least in a view) |
|
22 | SS | 538 | 501 | 516 | 520 | 498 | 518 | 557 | 608 | 542 | 525 | 582 | 516 | 552 | 549 | 514 | 544 | 537 | 529 | 532 | 528 | 599 | 492 | 522 | 538 | 570 | 577 | 562 | 549 | 552 | 585 | 538 | LIKE doesn't work for computed values (at least in a view) |
|
23 | CS | 1070 | 635 | 1047 | 1099 | 1054 | 1013 | 609 | 1000 | 564 | 1172 | 1093 | 711 | 1208 | 1102 | 1129 | 1185 | 1094 | 1132 | 1086 | 995 | 1178 | 1413 | 1133 | 788 | 1201 | 1199 | 664 | 952 | 1023 | 750 | 607 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
24 | SS | 436 | 404 | 408 | 457 | 474 | 436 | 436 | 448 | 395 | 455 | 436 | 425 | 456 | 433 | 476 | 457 | 446 | 382 | 401 | 470 | 445 | 433 | 385 | 473 | 421 | 405 | 413 | 445 | 457 | 414 | 453 | "CH" and "LL" are not separate spanish alphabet letters since 1994 |
|
25 | CS | 1143 | 716 | 1114 | 1167 | 1127 | 973 | 618 | 1189 | 1169 | 1232 | 1197 | 743 | 1199 | 1132 | 757 | 1130 | 1189 | 1252 | 1151 | 1249 | 1193 | 1164 | 1192 | 757 | 1160 | 1135 | 671 | 1133 | 1252 | 705 | 783 | Long SQL statements break TCP/IP connection |
|
26 | SS | 482 | 509 | 457 | 509 | 391 | 466 | 517 | 428 | 505 | 529 | 511 | 452 | 500 | 450 | 455 | 494 | 552 | 488 | 455 | 433 | 508 | 520 | 474 | 480 | 472 | 462 | 485 | 492 | 518 | 480 | 469 | Long SQL statements break TCP/IP connection |
|
27 | CS | 1269 | 783 | 1052 | 1291 | 1236 | 735 | 813 | 1357 | 1465 | 1479 | 1241 | 1024 | 744 | 1387 | 722 | 1334 | 1282 | 1516 | 1323 | 1376 | 1410 | 1321 | 1241 | 872 | 1338 | 1274 | 954 | 1292 | 1265 | 849 | 904 | LIST() function seems not work if used twice or more in a query |
|
28 | SS | 534 | 518 | 509 | 451 | 479 | 540 | 508 | 531 | 510 | 548 | 593 | 569 | 517 | 496 | 560 | 501 | 556 | 553 | 503 | 550 | 553 | 492 | 556 | 542 | 551 | 571 | 556 | 537 | 524 | 522 | 513 | LIST() function seems not work if used twice or more in a query |
|
29 | CS | 1308 | 812 | 856 | 1231 | 1283 | 733 | 1323 | 777 | 1420 | 1235 | 1334 | 1420 | 785 | 1223 | 729 | 1400 | 1351 | 1375 | 1388 | 1468 | 1352 | 1444 | 1407 | 940 | 1293 | 1343 | 784 | 1350 | 1333 | 801 | 866 | Incorrect column values with outer joins and views |
|
30 | SS | 544 | 476 | 590 | 477 | 542 | 523 | 580 | 528 | 560 | 553 | 572 | 530 | 540 | 578 | 603 | 534 | 545 | 553 | 494 | 575 | 544 | 574 | 501 | 497 | 539 | 559 | 587 | 542 | 566 | 539 | 562 | Incorrect column values with outer joins and views |
|
31 | CS | 1263 | 840 | 805 | 1287 | 1287 | 936 | 1214 | 764 | 1401 | 1262 | 1240 | 1295 | 776 | 1264 | 763 | 1413 | 1350 | 1451 | 1281 | 1420 | 1429 | 1381 | 1321 | 951 | 1195 | 1316 | 747 | 1477 | 1204 | 1156 | 826 | Incorrect column values with outer joins and derived tables |
|
32 | SS | 521 | 510 | 601 | 512 | 587 | 476 | 551 | 559 | 517 | 569 | 520 | 501 | 484 | 529 | 525 | 523 | 530 | 514 | 594 | 500 | 572 | 520 | 514 | 485 | 514 | 534 | 547 | 496 | 510 | 564 | 528 | Incorrect column values with outer joins and derived tables |
|
33 | CS | 1236 | 756 | 893 | 1147 | 1241 | 1318 | 731 | 691 | 1227 | 1331 | 1370 | 754 | 1497 | 787 | 741 | 1231 | 1361 | 1396 | 1412 | 1473 | 1350 | 1456 | 1312 | 854 | 1308 | 1254 | 825 | 750 | 1307 | 1200 | 872 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
34 | SS | 541 | 605 | 466 | 566 | 527 | 551 | 599 | 580 | 484 | 540 | 576 | 492 | 621 | 542 | 579 | 498 | 546 | 513 | 481 | 509 | 578 | 560 | 608 | 516 | 510 | 547 | 523 | 540 | 539 | 530 | 558 | Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different |
|
35 | CS | 1253 | 809 | 872 | 1304 | 1240 | 758 | 1223 | 1291 | 900 | 940 | 1234 | 1487 | 1367 | 783 | 798 | 1257 | 1506 | 1414 | 1372 | 1449 | 1396 | 1274 | 1249 | 943 | 1311 | 1344 | 995 | 776 | 905 | 1374 | 1291 | Joins with NULL RDB$DB_KEY crash the server |
|
36 | SS | 541 | 582 | 553 | 469 | 473 | 530 | 541 | 612 | 584 | 603 | 554 | 524 | 542 | 552 | 565 | 529 | 552 | 604 | 558 | 537 | 503 | 562 | 559 | 503 | 502 | 536 | 573 | 523 | 468 | 509 | 489 | Joins with NULL RDB$DB_KEY crash the server |
|
37 | CS | 1041 | 641 | 635 | 1038 | 990 | 690 | 1092 | 1146 | 669 | 601 | 1133 | 1351 | 1105 | 678 | 616 | 1152 | 1041 | 1343 | 1088 | 1191 | 1274 | 1251 | 1155 | 789 | 1042 | 1043 | 679 | 610 | 596 | 974 | 1065 | French insensitive collation FR_FR_CI_AI |
|
38 | SS | 453 | 399 | 394 | 468 | 448 | 429 | 445 | 510 | 460 | 511 | 474 | 442 | 465 | 438 | 437 | 482 | 477 | 478 | 386 | 455 | 407 | 427 | 482 | 451 | 489 | 449 | 414 | 470 | 430 | 474 | 482 | French insensitive collation FR_FR_CI_AI |
|
39 | CS | 1192 | 768 | 770 | 1310 | 1298 | 687 | 1322 | 1017 | 780 | 751 | 1183 | 1314 | 1202 | 778 | 757 | 1288 | 1359 | 1724 | 1486 | 1473 | 1346 | 1397 | 1384 | 980 | 1296 | 1250 | 868 | 863 | 816 | 1133 | 1143 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
40 | SS | 537 | 596 | 520 | 491 | 515 | 491 | 496 | 518 | 518 | 568 | 583 | 511 | 567 | 520 | 548 | 561 | 527 | 508 | 592 | 552 | 498 | 563 | 559 | 525 | 566 | 527 | 597 | 568 | 566 | 553 | 507 | Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields |
|
41 | CS | 1260 | 773 | 793 | 1245 | 1222 | 792 | 1344 | 1280 | 803 | 842 | 718 | 1375 | 1354 | 759 | 708 | 1336 | 1325 | 1392 | 1198 | 1598 | 1425 | 1377 | 1582 | 838 | 1461 | 1304 | 1361 | 801 | 828 | 847 | 1276 | Collation not propagated between record formats |
|
42 | SS | 553 | 574 | 527 | 461 | 553 | 485 | 509 | 600 | 512 | 608 | 553 | 553 | 609 | 496 | 530 | 508 | 553 | 552 | 577 | 560 | 575 | 595 | 566 | 530 | 524 | 522 | 562 | 498 | 580 | 573 | 557 | Collation not propagated between record formats |
|
43 | CS | 988 | 584 | 587 | 1037 | 1039 | 981 | 889 | 896 | 566 | 600 | 749 | 1070 | 1040 | 572 | 567 | 1105 | 1136 | 1149 | 1116 | 1114 | 1076 | 1076 | 1057 | 667 | 995 | 1117 | 1021 | 671 | 639 | 616 | 627 | DATEADD wrong work with NULL arguments |
|
44 | SS | 405 | 348 | 411 | 382 | 406 | 436 | 456 | 411 | 368 | 451 | 375 | 382 | 445 | 395 | 412 | 430 | 378 | 404 | 407 | 438 | 440 | 414 | 355 | 383 | 417 | 382 | 354 | 398 | 413 | 342 | 395 | DATEADD wrong work with NULL arguments |
|
45 | CS | 1009 | 543 | 619 | 938 | 980 | 977 | 1043 | 1116 | 592 | 606 | 695 | 1133 | 1111 | 574 | 593 | 1097 | 1132 | 1170 | 1134 | 1186 | 1099 | 1133 | 1050 | 697 | 1102 | 1039 | 1092 | 611 | 676 | 605 | 558 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
46 | SS | 398 | 363 | 407 | 389 | 435 | 413 | 410 | 399 | 362 | 426 | 407 | 438 | 438 | 462 | 436 | 394 | 376 | 380 | 392 | 404 | 426 | 398 | 361 | 393 | 433 | 330 | 383 | 383 | 371 | 392 | 418 | New builtin function DATEADD() implements wrong choice of keywords for expanded syntax |
|
47 | CS | 1023 | 601 | 654 | 543 | 1055 | 1000 | 1042 | 1038 | 575 | 648 | 588 | 1021 | 1035 | 567 | 652 | 1108 | 1035 | 1108 | 1134 | 1176 | 1141 | 1065 | 1063 | 691 | 1025 | 1240 | 1142 | 594 | 607 | 638 | 596 | POSITION(string_exp1, string_exp2 [, start]) |
|
48 | SS | 395 | 390 | 376 | 331 | 426 | 402 | 392 | 370 | 398 | 403 | 439 | 400 | 372 | 382 | 410 | 378 | 392 | 369 | 388 | 407 | 428 | 417 | 389 | 341 | 396 | 400 | 427 | 401 | 417 | 395 | 373 | POSITION(string_exp1, string_exp2 [, start]) |
|
49 | CS | 1102 | 739 | 764 | 708 | 1345 | 671 | 1246 | 1291 | 777 | 845 | 873 | 1326 | 1274 | 748 | 700 | 843 | 1283 | 1477 | 1319 | 1392 | 1349 | 1436 | 1326 | 884 | 1256 | 1291 | 1357 | 812 | 959 | 884 | 786 | JOIN on first record of ordered derived table returns wrong record |
|
50 | SS | 547 | 544 | 568 | 503 | 513 | 496 | 507 | 552 | 515 | 567 | 595 | 493 | 577 | 504 | 553 | 542 | 521 | 538 | 574 | 600 | 576 | 642 | 557 | 564 | 561 | 538 | 543 | 551 | 555 | 514 | 498 | JOIN on first record of ordered derived table returns wrong record |
|
51 | CS | 785 | 685 | 1091 | 1020 | 652 | 1129 | 561 | 635 | 1053 | 617 | 1092 | 570 | 582 | 1068 | 568 | 598 | 627 | 679 | 1014 | 600 | 1138 | 878 | 1063 | 670 | 553 | 1231 | 693 | 1111 | 1094 | 964 | 1111 | ABS() rounds NUMERIC values |
|
52 | SS | 402 | 387 | 421 | 385 | 352 | 383 | 382 | 405 | 439 | 384 | 417 | 384 | 410 | 385 | 455 | 461 | 377 | 376 | 494 | 404 | 433 | 401 | 388 | 392 | 404 | 399 | 427 | 392 | 434 | 425 | 436 | ABS() rounds NUMERIC values |
|
53 | CS | 1020 | 823 | 1104 | 1073 | 569 | 991 | 580 | 577 | 1049 | 757 | 1059 | 564 | 672 | 1053 | 561 | 702 | 614 | 1129 | 1079 | 654 | 699 | 641 | 1064 | 729 | 1111 | 1367 | 1168 | 1077 | 1056 | 1120 | 1129 | MERGE not correctly worked with parameters in MATCHING clause |
|
54 | SS | 430 | 411 | 493 | 394 | 414 | 393 | 359 | 443 | 449 | 472 | 525 | 415 | 409 | 551 | 432 | 429 | 462 | 410 | 431 | 485 | 425 | 456 | 435 | 353 | 461 | 404 | 408 | 455 | 419 | 394 | 460 | MERGE not correctly worked with parameters in MATCHING clause |
|
55 | CS | 1280 | 978 | 1377 | 1375 | 891 | 1268 | 806 | 785 | 1289 | 787 | 1394 | 804 | 779 | 1633 | 813 | 796 | 808 | 1396 | 1298 | 1553 | 1497 | 1004 | 1351 | 881 | 1460 | 1499 | 1272 | 1456 | 1522 | 1330 | 1120 | AV when recursive query used MERGE JOIN in execution plan |
|
56 | SS | 572 | 523 | 581 | 551 | 543 | 545 | 547 | 572 | 560 | 631 | 640 | 606 | 597 | 709 | 464 | 568 | 559 | 572 | 625 | 587 | 586 | 570 | 597 | 585 | 627 | 531 | 548 | 590 | 570 | 602 | 568 | AV when recursive query used MERGE JOIN in execution plan |
|
57 | CS | 1233 | 893 | 1379 | 1243 | 904 | 1248 | 799 | 744 | 1173 | 749 | 1267 | 916 | 735 | 1218 | 732 | 799 | 752 | 1223 | 1288 | 1348 | 1571 | 761 | 1299 | 841 | 1281 | 1339 | 1321 | 1479 | 1392 | 1282 | 1343 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
58 | SS | 526 | 486 | 574 | 483 | 524 | 475 | 545 | 520 | 491 | 537 | 562 | 527 | 493 | 586 | 565 | 511 | 532 | 485 | 534 | 479 | 538 | 567 | 565 | 553 | 502 | 471 | 503 | 503 | 555 | 525 | 544 | Infinite row generation in "select gen_id(..) from rdb$database" with "group by" |
|
59 | CS | 997 | 728 | 1131 | 948 | 569 | 940 | 548 | 576 | 561 | 634 | 995 | 827 | 565 | 1036 | 577 | 601 | 747 | 1100 | 1000 | 1207 | 1135 | 1054 | 1176 | 761 | 1078 | 1277 | 1048 | 1110 | 1136 | 1047 | 1101 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
60 | SS | 397 | 339 | 396 | 348 | 412 | 375 | 357 | 395 | 437 | 406 | 400 | 331 | 412 | 413 | 376 | 346 | 357 | 426 | 423 | 454 | 425 | 423 | 356 | 427 | 317 | 391 | 436 | 399 | 386 | 386 | 406 | Floor & ceiling functions give wrong results with exact numeric arguments |
|
61 | CS | 1000 | 729 | 1048 | 1051 | 601 | 552 | 608 | 639 | 568 | 632 | 983 | 728 | 590 | 1104 | 611 | 638 | 613 | 647 | 1017 | 1332 | 1223 | 1042 | 1088 | 637 | 1111 | 1343 | 1078 | 1075 | 1260 | 1054 | 1144 | Wrong variable initialization in recursive procedures |
|
62 | SS | 433 | 388 | 435 | 392 | 433 | 396 | 417 | 397 | 369 | 433 | 468 | 361 | 508 | 476 | 435 | 433 | 449 | 446 | 422 | 451 | 479 | 476 | 422 | 440 | 420 | 393 | 445 | 430 | 393 | 458 | 454 | Wrong variable initialization in recursive procedures |
|
63 | CS | 1053 | 910 | 1272 | 774 | 704 | 814 | 700 | 811 | 783 | 785 | 1272 | 701 | 1139 | 1392 | 1129 | 786 | 795 | 1261 | 1426 | 881 | 1432 | 1352 | 830 | 873 | 1404 | 1381 | 1436 | 1423 | 1324 | 1336 | 978 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
64 | SS | 529 | 581 | 576 | 470 | 498 | 491 | 477 | 555 | 514 | 546 | 568 | 558 | 555 | 530 | 544 | 526 | 552 | 521 | 584 | 475 | 553 | 533 | 500 | 563 | 515 | 516 | 528 | 499 | 509 | 543 | 499 | Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT |
|
65 | CS | 857 | 970 | 1236 | 747 | 789 | 844 | 808 | 842 | 804 | 845 | 1297 | 748 | 746 | 1057 | 1261 | 801 | 784 | 795 | 1315 | 845 | 1393 | 1347 | 849 | 866 | 1388 | 1398 | 1402 | 1383 | 1307 | 1330 | 842 | Consistency check when subquery is ordered by aggregate function from other context |
|
66 | SS | 525 | 605 | 532 | 501 | 460 | 522 | 514 | 559 | 523 | 576 | 523 | 509 | 592 | 564 | 552 | 510 | 473 | 527 | 561 | 520 | 557 | 547 | 520 | 567 | 521 | 521 | 556 | 519 | 546 | 580 | 513 | Consistency check when subquery is ordered by aggregate function from other context |
|
67 | CS | 818 | 870 | 732 | 785 | 759 | 787 | 672 | 784 | 791 | 744 | 1272 | 710 | 1383 | 757 | 1275 | 752 | 727 | 1312 | 808 | 1447 | 798 | 774 | 1290 | 857 | 1293 | 1101 | 1270 | 1490 | 829 | 1180 | 1397 | DEFAULT values are unnecessary evaluated |
|
68 | SS | 527 | 489 | 567 | 529 | 512 | 489 | 559 | 488 | 557 | 574 | 568 | 517 | 595 | 501 | 534 | 501 | 527 | 546 | 518 | 522 | 527 | 580 | 487 | 572 | 520 | 506 | 501 | 545 | 570 | 513 | 544 | DEFAULT values are unnecessary evaluated |
|
69 | CS | 723 | 667 | 659 | 608 | 693 | 679 | 1076 | 596 | 634 | 618 | 568 | 1064 | 1184 | 608 | 640 | 722 | 651 | 635 | 1098 | 725 | 913 | 689 | 1067 | 755 | 1163 | 1036 | 1147 | 1214 | 1221 | 1054 | 1200 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
70 | SS | 453 | 401 | 526 | 481 | 399 | 483 | 400 | 434 | 462 | 465 | 398 | 477 | 492 | 451 | 474 | 466 | 471 | 432 | 470 | 484 | 422 | 476 | 433 | 455 | 473 | 442 | 449 | 405 | 441 | 416 | 429 | Support SQL 2008 syntax for MERGE statement with DELETE extension |
|
71 | CS | 979 | 897 | 1515 | 767 | 696 | 1082 | 1332 | 811 | 720 | 790 | 905 | 1355 | 1313 | 818 | 772 | 1322 | 798 | 752 | 798 | 802 | 1377 | 727 | 1459 | 873 | 1054 | 1466 | 1337 | 1332 | 1270 | 1298 | 1332 | Null in the first record in a condition on rdb$db_key |
|
72 | SS | 539 | 522 | 550 | 502 | 562 | 537 | 458 | 555 | 469 | 540 | 512 | 578 | 563 | 521 | 532 | 563 | 539 | 522 | 549 | 527 | 572 | 557 | 560 | 492 | 534 | 541 | 514 | 495 | 556 | 570 | 550 | Null in the first record in a condition on rdb$db_key |
|
73 | CS | 956 | 904 | 789 | 731 | 773 | 1209 | 1232 | 733 | 772 | 743 | 906 | 1346 | 1421 | 788 | 801 | 1418 | 738 | 922 | 966 | 789 | 1507 | 914 | 1353 | 948 | 965 | 1338 | 1555 | 1450 | 1449 | 1313 | 1362 | update or insert with gen_id() with wrong generator value |
|
74 | SS | 557 | 608 | 606 | 538 | 638 | 536 | 579 | 613 | 563 | 524 | 598 | 546 | 546 | 647 | 596 | 568 | 546 | 553 | 568 | 574 | 559 | 548 | 535 | 569 | 546 | 505 | 556 | 548 | 525 | 535 | 601 | update or insert with gen_id() with wrong generator value |
|
75 | CS | 904 | 853 | 753 | 783 | 787 | 931 | 1261 | 779 | 763 | 742 | 794 | 1294 | 1251 | 877 | 776 | 1265 | 933 | 821 | 784 | 832 | 1479 | 802 | 1315 | 868 | 1021 | 1288 | 1247 | 1414 | 1297 | 1295 | 1339 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
76 | SS | 537 | 468 | 589 | 478 | 517 | 505 | 500 | 544 | 573 | 516 | 522 | 491 | 559 | 563 | 499 | 538 | 554 | 545 | 558 | 486 | 538 | 503 | 520 | 559 | 565 | 527 | 554 | 512 | 536 | 595 | 583 | Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns |
|
77 | CS | 914 | 908 | 779 | 715 | 709 | 1315 | 1288 | 750 | 694 | 809 | 735 | 1338 | 1350 | 980 | 733 | 1227 | 782 | 764 | 817 | 829 | 1439 | 852 | 865 | 921 | 1493 | 1228 | 1330 | 1371 | 1404 | 1243 | 1290 | GROUP by and RDB$DB_KEY problems |
|
78 | SS | 528 | 540 | 529 | 489 | 504 | 527 | 517 | 544 | 537 | 534 | 524 | 540 | 576 | 522 | 535 | 563 | 547 | 498 | 515 | 528 | 519 | 539 | 531 | 545 | 549 | 529 | 510 | 488 | 476 | 470 | 528 | GROUP by and RDB$DB_KEY problems |
|
79 | CS | 1151 | 1009 | 1432 | 780 | 1324 | 1324 | 876 | 792 | 753 | 1304 | 744 | 1364 | 1351 | 825 | 847 | 1393 | 722 | 752 | 842 | 847 | 1380 | 803 | 970 | 886 | 1517 | 1311 | 1294 | 1381 | 1312 | 1446 | 1403 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
80 | SS | 550 | 548 | 615 | 532 | 506 | 535 | 570 | 549 | 570 | 550 | 590 | 561 | 502 | 514 | 538 | 495 | 555 | 599 | 568 | 516 | 575 | 590 | 568 | 502 | 561 | 529 | 555 | 510 | 550 | 489 | 585 | Parts of RDB$DB_KEY of views may be inverted when using outer joins |
|
81 | CS | 832 | 890 | 834 | 755 | 1220 | 712 | 802 | 788 | 781 | 1362 | 736 | 1324 | 798 | 1344 | 831 | 1181 | 1280 | 782 | 763 | 888 | 827 | 816 | 752 | 846 | 820 | 746 | 1378 | 1364 | 1290 | 1303 | 1251 | Grouping by function doesn't work properly |
|
82 | SS | 529 | 544 | 533 | 522 | 504 | 487 | 509 | 518 | 490 | 566 | 526 | 557 | 618 | 565 | 618 | 543 | 482 | 550 | 512 | 544 | 498 | 580 | 547 | 524 | 574 | 563 | 526 | 493 | 542 | 500 | 522 | Grouping by function doesn't work properly |
|
83 | CS | 877 | 856 | 747 | 718 | 1248 | 666 | 890 | 753 | 1260 | 1290 | 777 | 1265 | 1370 | 739 | 711 | 1031 | 1251 | 804 | 768 | 1143 | 741 | 766 | 865 | 788 | 734 | 1048 | 1367 | 1393 | 1491 | 1361 | 1476 | Firebird float support does not conform to Interbase spec |
|
84 | SS | 514 | 493 | 571 | 455 | 500 | 478 | 471 | 525 | 529 | 553 | 490 | 465 | 560 | 531 | 485 | 513 | 522 | 575 | 560 | 518 | 515 | 540 | 514 | 491 | 530 | 552 | 470 | 513 | 474 | 498 | 533 | Firebird float support does not conform to Interbase spec |
|
85 | CS | 899 | 618 | 1115 | 565 | 982 | 949 | 616 | 585 | 1092 | 601 | 1008 | 701 | 587 | 624 | 583 | 1009 | 1090 | 680 | 1337 | 1121 | 672 | 849 | 1160 | 700 | 549 | 689 | 1035 | 1144 | 1102 | 974 | 976 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
86 | SS | 409 | 443 | 440 | 372 | 333 | 359 | 362 | 434 | 369 | 430 | 452 | 431 | 413 | 375 | 349 | 424 | 424 | 411 | 367 | 438 | 435 | 410 | 388 | 398 | 377 | 399 | 447 | 409 | 401 | 402 | 423 | AV using recursive query as subquery in SELECT list and ORDER'ing by them |
|
87 | CS | 1262 | 1028 | 859 | 760 | 1475 | 1412 | 778 | 800 | 1474 | 938 | 1371 | 840 | 822 | 902 | 864 | 1508 | 1547 | 1675 | 1167 | 1216 | 1564 | 1204 | 1308 | 919 | 1440 | 872 | 1596 | 1440 | 1668 | 1392 | 1487 | Outer ORDER BY clause has no effect |
|
88 | SS | 676 | 699 | 697 | 577 | 579 | 592 | 603 | 698 | 536 | 750 | 723 | 690 | 676 | 703 | 649 | 651 | 710 | 676 | 633 | 698 | 664 | 717 | 677 | 670 | 677 | 723 | 626 | 625 | 683 | 628 | 622 | Outer ORDER BY clause has no effect |
|
89 | CS | 1259 | 851 | 1250 | 1236 | 755 | 1446 | 1469 | 850 | 1233 | 1583 | 1315 | 808 | 797 | 828 | 776 | 1520 | 1349 | 1384 | 1057 | 1268 | 1491 | 890 | 1188 | 883 | 1403 | 888 | 1425 | 1524 | 1420 | 1441 | 1519 | Wrong field position after ALTER POSITION |
|
90 | SS | 590 | 607 | 575 | 583 | 550 | 572 | 582 | 612 | 557 | 612 | 606 | 596 | 566 | 672 | 549 | 537 | 640 | 615 | 625 | 606 | 598 | 609 | 644 | 542 | 584 | 563 | 577 | 561 | 620 | 646 | 541 | Wrong field position after ALTER POSITION |
|
91 | CS | 1081 | 229984 | 624 | 982 | 639 | 672 | 580 | 1095 | 633 | 646 | 1205 | 667 | 1142 | 653 | 880 | 1136 | 1102 | 1074 | 1205 | 1212 | 801 | 1170 | 1206 | 705 | 948 | 1088 | 1204 | 1153 | 1204 | 1059 | 1101 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
92 | SS | 463 | 232930 | 427 | 413 | 397 | 347 | 372 | 459 | 495 | 470 | 463 | 463 | 526 | 528 | 448 | 417 | 426 | 505 | 432 | 497 | 492 | 508 | 472 | 448 | 498 | 428 | 458 | 394 | 501 | 463 | 473 | rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them |
|
93 | CS | 1248 | 932 | 824 | 780 | 735 | 768 | 697 | 1312 | 728 | 928 | 860 | 744 | 1377 | 768 | 766 | 1344 | 1283 | 1417 | 1315 | 1504 | 1383 | 763 | 1329 | 926 | 1292 | 1213 | 1373 | 1353 | 1346 | 1553 | 1350 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
94 | SS | 542 | 477 | 591 | 512 | 566 | 484 | 550 | 607 | 544 | 506 | 537 | 524 | 554 | 571 | 586 | 532 | 508 | 550 | 518 | 575 | 600 | 540 | 571 | 537 | 485 | 504 | 538 | 588 | 536 | 569 | 564 | "conversion error from string" after change of field type from BIGINT to VARCHAR(21) |
|
95 | CS | 1266 | 856 | 1361 | 736 | 1238 | 747 | 1206 | 745 | 1310 | 843 | 839 | 749 | 810 | 805 | 793 | 1272 | 1384 | 1368 | 1333 | 1378 | 1369 | 1349 | 1536 | 938 | 1308 | 1553 | 1260 | 1336 | 1310 | 1312 | 1248 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
96 | SS | 544 | 473 | 544 | 436 | 513 | 533 | 474 | 563 | 537 | 560 | 572 | 533 | 542 | 536 | 600 | 555 | 496 | 504 | 550 | 537 | 545 | 581 | 557 | 557 | 598 | 512 | 546 | 507 | 566 | 566 | 549 | Incorrect LEFT JOIN result using table and derived constant subquery |
|
97 | CS | 2455 | 2422 | 1852 | 1686 | 1748 | 3102 | 1813 | 2507 | 1752 | 2377 | 2343 | 1625 | 3648 | 2376 | 2955 | 3199 | 2657 | 2884 | 3123 | 2773 | 2416 | 2972 | 2643 | 1892 | 2647 | 2488 | 1661 | 2999 | 1644 | 2248 | 2600 | Lateral derived tables |
|
98 | SS | 1748 | 2015 | 2085 | 1808 | 1536 | 1755 | 1628 | 1874 | 1934 | 1950 | 1914 | 1682 | 1932 | 2203 | 2041 | 1741 | 1698 | 1695 | 1864 | 1741 | 1682 | 1769 | 1644 | 1808 | 1665 | 1714 | 1738 | 1706 | 1779 | 1714 | 1498 | Lateral derived tables |
|
99 | CS | 1468 | 1061 | 924 | 1482 | 811 | 1277 | 831 | 1478 | 1012 | 875 | 1054 | 849 | 1699 | 1021 | 1127 | 1535 | 1501 | 1654 | 1537 | 1726 | 1733 | 1638 | 1531 | 1078 | 1624 | 1693 | 995 | 1570 | 1680 | 1458 | 919 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
100 | SS | 730 | 801 | 756 | 660 | 688 | 641 | 708 | 726 | 689 | 752 | 758 | 708 | 713 | 775 | 668 | 729 | 714 | 795 | 727 | 713 | 761 | 806 | 734 | 782 | 793 | 738 | 654 | 782 | 734 | 712 | 731 | Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification |
|
101 | CS | 1323 | 1041 | 870 | 1318 | 784 | 1094 | 808 | 1343 | 1254 | 872 | 991 | 764 | 1450 | 979 | 1397 | 1457 | 1536 | 1449 | 1412 | 1616 | 1431 | 1435 | 1341 | 1071 | 1424 | 1433 | 957 | 1328 | 1406 | 834 | 828 | Window Function: frame (rows / range) clause |
|
102 | SS | 632 | 633 | 692 | 629 | 584 | 564 | 602 | 656 | 656 | 616 | 606 | 568 | 614 | 674 | 691 | 676 | 659 | 702 | 632 | 576 | 667 | 703 | 670 | 626 | 673 | 685 | 629 | 710 | 625 | 625 | 604 | Window Function: frame (rows / range) clause |
|
103 | CS | 1221 | 816 | 894 | 1251 | 1355 | 925 | 1239 | 1213 | 1229 | 756 | 912 | 697 | 788 | 872 | 759 | 1648 | 1477 | 1378 | 1260 | 1439 | 1455 | 1276 | 1396 | 954 | 1305 | 1345 | 863 | 732 | 767 | 829 | 1408 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
104 | SS | 561 | 524 | 563 | 499 | 520 | 491 | 517 | 594 | 560 | 564 | 582 | 576 | 564 | 601 | 511 | 539 | 553 | 596 | 598 | 642 | 595 | 598 | 584 | 538 | 563 | 549 | 521 | 523 | 571 | 536 | 506 | Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause |
|
105 | CS | 947 | 742 | 633 | 587 | 634 | 760 | 1042 | 789 | 1089 | 1112 | 816 | 655 | 694 | 746 | 771 | 1088 | 1056 | 1037 | 1064 | 1203 | 1221 | 1358 | 1092 | 779 | 1091 | 1043 | 858 | 1086 | 1046 | 813 | 744 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
106 | SS | 424 | 430 | 439 | 440 | 377 | 404 | 425 | 468 | 443 | 487 | 450 | 400 | 422 | 464 | 421 | 434 | 423 | 394 | 401 | 422 | 472 | 498 | 445 | 400 | 384 | 419 | 356 | 483 | 387 | 424 | 436 | EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset |
|
107 | CS | 1097 | 938 | 743 | 727 | 729 | 940 | 1292 | 898 | 990 | 1384 | 916 | 785 | 861 | 878 | 871 | 1352 | 1279 | 1340 | 1301 | 1496 | 1452 | 1564 | 1278 | 969 | 1244 | 1288 | 1187 | 1416 | 1348 | 787 | 1007 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
108 | SS | 540 | 503 | 607 | 469 | 498 | 541 | 526 | 568 | 562 | 605 | 526 | 568 | 521 | 568 | 637 | 551 | 522 | 539 | 530 | 546 | 542 | 551 | 486 | 512 | 550 | 568 | 464 | 502 | 513 | 523 | 566 | Regression: Server crashes while preparing a query with DISTINCT and ORDER BY |
|
109 | CS | 1019 | 876 | 1107 | 764 | 726 | 850 | 757 | 883 | 751 | 1368 | 828 | 730 | 873 | 932 | 835 | 861 | 1269 | 1294 | 1215 | 1372 | 1375 | 1249 | 1353 | 919 | 1230 | 1315 | 859 | 1278 | 1335 | 1387 | 1363 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
110 | SS | 539 | 549 | 582 | 580 | 493 | 448 | 538 | 570 | 514 | 555 | 522 | 488 | 548 | 546 | 572 | 541 | 504 | 558 | 525 | 535 | 545 | 612 | 525 | 511 | 534 | 563 | 525 | 509 | 523 | 542 | 556 | In PSQL modules with declared cursors engine could assign value to the wrong variable |
|
111 | CS | 984 | 710 | 983 | 1060 | 564 | 779 | 698 | 834 | 685 | 949 | 705 | 568 | 717 | 646 | 631 | 985 | 1118 | 1090 | 1186 | 1125 | 1136 | 1158 | 1049 | 700 | 1097 | 1096 | 1174 | 939 | 1048 | 1146 | 1036 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
112 | SS | 410 | 379 | 432 | 346 | 379 | 356 | 404 | 413 | 398 | 485 | 461 | 417 | 469 | 381 | 402 | 416 | 409 | 389 | 405 | 411 | 487 | 435 | 412 | 421 | 431 | 395 | 438 | 386 | 406 | 418 | 403 | Regression: recursive query in SQL query returns incorrect results if more than one branch bypass |
|
113 | CS | 1063 | 676 | 1073 | 1072 | 594 | 662 | 745 | 752 | 687 | 1100 | 666 | 564 | 752 | 770 | 728 | 1032 | 1088 | 1289 | 1116 | 1068 | 1180 | 1165 | 1059 | 675 | 1136 | 1207 | 701 | 1112 | 1072 | 1098 | 1185 | Parametrized queries using RDB$DB_KEY do not work |
|
114 | SS | 442 | 451 | 443 | 433 | 388 | 351 | 393 | 476 | 439 | 481 | 481 | 421 | 421 | 463 | 480 | 394 | 460 | 450 | 417 | 410 | 465 | 493 | 441 | 428 | 483 | 449 | 425 | 511 | 431 | 445 | 403 | Parametrized queries using RDB$DB_KEY do not work |
|
115 | CS | 1428 | 1080 | 1344 | 1338 | 942 | 976 | 962 | 1021 | 1130 | 1385 | 1022 | 864 | 1108 | 1052 | 1042 | 1477 | 1473 | 1723 | 1596 | 1676 | 1608 | 1508 | 1671 | 1076 | 1471 | 1527 | 1748 | 1631 | 1611 | 1590 | 1585 | Wrong result of join when joined fields are created via row_number() function |
|
116 | SS | 731 | 762 | 739 | 631 | 606 | 648 | 575 | 686 | 749 | 766 | 685 | 711 | 711 | 723 | 723 | 806 | 744 | 714 | 759 | 773 | 791 | 756 | 718 | 792 | 657 | 751 | 692 | 777 | 784 | 762 | 712 | Wrong result of join when joined fields are created via row_number() function |
|
117 | CS | 1858 | 1797 | 1866 | 2470 | 1665 | 1542 | 1971 | 1760 | 1883 | 1851 | 1744 | 1774 | 1720 | 1755 | 1803 | 1399 | 1910 | 1662 | 2625 | 1571 | 2813 | 2511 | 1539 | 1768 | 2487 | 2769 | 2675 | 3061 | 2787 | 2684 | 2399 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
118 | SS | 1042 | 988 | 1071 | 959 | 977 | 907 | 1026 | 1093 | 1079 | 1046 | 1046 | 1002 | 1146 | 1104 | 1032 | 1100 | 978 | 1041 | 1056 | 1047 | 1044 | 1043 | 984 | 908 | 1105 | 945 | 1007 | 1016 | 1041 | 1051 | 1137 | Duplicate tags for CREATE/ALTER USER not handled correctly |
|
119 | CS | 945 | 886 | 945 | 789 | 867 | 914 | 951 | 945 | 897 | 889 | 879 | 939 | 926 | 928 | 847 | 1007 | 1255 | 1308 | 1200 | 1419 | 1495 | 891 | 1272 | 952 | 778 | 1355 | 1572 | 1368 | 1559 | 728 | 1337 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
120 | SS | 574 | 554 | 524 | 499 | 523 | 515 | 581 | 535 | 580 | 593 | 669 | 582 | 561 | 592 | 557 | 608 | 584 | 566 | 584 | 596 | 615 | 568 | 604 | 488 | 588 | 549 | 557 | 527 | 544 | 584 | 619 | Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block |
|
121 | CS | 717 | 637 | 626 | 583 | 746 | 632 | 640 | 639 | 659 | 661 | 701 | 660 | 748 | 701 | 671 | 616 | 572 | 1172 | 1190 | 1192 | 789 | 1052 | 1117 | 734 | 1064 | 668 | 968 | 1209 | 1115 | 1033 | 868 | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
122 | SS | 405 | 393 | 400 | 376 | 419 | 390 | 398 | 400 | 476 | 407 | 421 | 438 | 434 | 441 | 416 | 409 | 375 | 401 | 453 | 456 | 400 | 411 | 403 | 415 | 383 | 392 | 392 | 396 | 424 | 372 | 437 | ISQL pads blob columns wrongly when the column alias has more than 17 characters |
|
123 | CS | 1500 | 1475 | 1410 | 1424 | 1344 | 1298 | 1293 | 1367 | 1409 | 1459 | 1246 | 1494 | 1514 | 1402 | 1449 | 1173 | 1315 | 1735 | 2131 | 2096 | 1713 | 2011 | 2056 | 1506 | 1566 | 1960 | 2179 | 2016 | 2063 | 1850 | 2052 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
124 | SS | 838 | 673 | 870 | 817 | 825 | 787 | 872 | 838 | 837 | 939 | 958 | 895 | 861 | 912 | 901 | 860 | 771 | 904 | 866 | 838 | 835 | 836 | 832 | 820 | 769 | 798 | 800 | 866 | 898 | 841 | 812 | Provide ability to do: REcreate user <user_name> password <user_pwd> |
|
125 | CS | 770 | 675 | 798 | 712 | 704 | 698 | 768 | 744 | 756 | 759 | 752 | 646 | 730 | 740 | 729 | 1148 | 680 | 886 | 1003 | 1109 | 648 | 874 | 1217 | 773 | 930 | 1106 | 1300 | 1153 | 1127 | 1136 | 1164 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
126 | SS | 456 | 481 | 445 | 475 | 441 | 394 | 373 | 455 | 442 | 468 | 483 | 497 | 471 | 441 | 479 | 462 | 433 | 451 | 496 | 433 | 496 | 533 | 488 | 456 | 514 | 415 | 396 | 457 | 473 | 412 | 444 | Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions |
|
127 | CS | 1027 | 809 | 891 | 805 | 812 | 840 | 879 | 789 | 919 | 870 | 879 | 831 | 956 | 924 | 862 | 1260 | 1139 | 1344 | 1114 | 1294 | 1299 | 1400 | 1251 | 896 | 1172 | 1385 | 1360 | 1356 | 1098 | 1372 | 1220 | SEC$ tables and tag/attributes |
|
128 | SS | 528 | 756 | 502 | 508 | 461 | 505 | 481 | 644 | 454 | 788 | 692 | 516 | 649 | 718 | 689 | 535 | 541 | 523 | 501 | 515 | 582 | 534 | 493 | 552 | 506 | 544 | 522 | 474 | 554 | 461 | 585 | SEC$ tables and tag/attributes |
|
129 | CS | 752 | 774 | 788 | 722 | 719 | 715 | 758 | 714 | 687 | 792 | 726 | 677 | 722 | 817 | 684 | 1176 | 1176 | 1108 | 1144 | 1153 | 1220 | 1176 | 1175 | 747 | 1204 | 1188 | 678 | 684 | 626 | 628 | 547 | Window Function: named window |
|
130 | SS | 490 | 428 | 676 | 404 | 513 | 387 | 531 | 475 | 580 | 632 | 676 | 700 | 703 | 593 | 597 | 447 | 475 | 489 | 499 | 492 | 473 | 525 | 532 | 428 | 473 | 419 | 459 | 478 | 428 | 469 | 500 | Window Function: named window |
|
131 | CS | 9580 | 9235 | 9922 | 8846 | 9090 | 9038 | 8638 | 9035 | 9029 | 9915 | 9326 | 9230 | 9813 | 10286 | 9395 | 10588 | 10905 | 11313 | 10496 | 10800 | 11875 | 11294 | 9972 | 9006 | 9765 | 11191 | 10388 | 6400 | 5997 | 6259 | 6205 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
132 | SS | 6793 | 4699 | 8771 | 6765 | 7726 | 6146 | 8072 | 8679 | 8380 | 8588 | 4796 | 8606 | 8377 | 8560 | 8005 | 6597 | 6718 | 6811 | 7201 | 6759 | 6829 | 6790 | 6338 | 6039 | 7121 | 6797 | 6289 | 5688 | 5776 | 6217 | 6255 | Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) |
|
133 | CS | 827 | 706 | 670 | 627 | 741 | 606 | 640 | 636 | 651 | 723 | 651 | 615 | 659 | 713 | 676 | 1070 | 1100 | 913 | 1053 | 1209 | 1115 | 1018 | 1088 | 737 | 1027 | 1188 | 1096 | 1173 | 1149 | 1150 | 1092 | Reject non-constant date/time/timestamp literals |
|
134 | SS | 430 | 639 | 311 | 472 | 358 | 497 | 506 | 552 | 336 | 351 | 536 | 492 | 416 | 597 | 467 | 392 | 404 | 414 | 434 | 418 | 477 | 427 | 402 | 400 | 418 | 381 | 445 | 436 | 443 | 434 | 406 | Reject non-constant date/time/timestamp literals |
|
135 | CS | 718 | 685 | 676 | 653 | 634 | 664 | 655 | 659 | 662 | 716 | 668 | 710 | 721 | 702 | 654 | 1127 | 1117 | 1124 | 1159 | 1310 | 1113 | 1098 | 1172 | 712 | 1124 | 1008 | 686 | 1162 | 1036 | 1030 | 1032 | Date-time parsing is very weak |
|
136 | SS | 444 | 675 | 519 | 416 | 554 | 565 | 543 | 577 | 344 | 457 | 552 | 419 | 599 | 520 | 490 | 453 | 438 | 440 | 408 | 418 | 452 | 425 | 416 | 417 | 426 | 449 | 394 | 379 | 452 | 417 | 402 | Date-time parsing is very weak |
|
137 | CS | 684 | 673 | 686 | 636 | 729 | 718 | 668 | 618 | 678 | 770 | 683 | 636 | 696 | 721 | 688 | 639 | 995 | 1040 | 1111 | 666 | 665 | 655 | 630 | 710 | 1159 | 627 | 1223 | 1181 | 565 | 763 | 593 | Incorrect query result when using named window |
|
138 | SS | 449 | 336 | 514 | 361 | 524 | 559 | 593 | 578 | 599 | 545 | 585 | 575 | 597 | 609 | 636 | 456 | 417 | 444 | 441 | 403 | 447 | 450 | 444 | 412 | 448 | 423 | 410 | 412 | 410 | 410 | 459 | Incorrect query result when using named window |
|
139 | SS | 2820 | 2656 | 2917 | 2639 | 2805 | 2744 | 2704 | 2854 | 2734 | 2861 | 2862 | 2732 | 2904 | 2818 | 2771 | 2550 | 2591 | 2790 | 2799 | 2867 | 2761 | 3048 | 2886 | 2714 | 2843 | 2909 | 2822 | 2824 | 2870 | 2827 | 2936 | Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query() |
|
140 | CS | 700 | 738 | 758 | 632 | 762 | 683 | 635 | 681 | 660 | 595 | 715 | 705 | 687 | 590 | 704 | 1123 | 622 | 757 | 619 | 1251 | 730 | 628 | 603 | 696 | 1113 | 707 | 1193 | 1321 | 686 | 636 | 722 | Unexpected results after creating partial index |
|
141 | SS | 548 | 596 | 572 | 443 | 581 | 512 | 389 | 621 | 631 | 597 | 348 | 483 | 651 | 512 | 402 | 454 | 581 | 634 | 556 | 1029 | 471 | 557 | 657 | 513 | 541 | 353 | 380 | 664 | 591 | 509 | 408 | Unexpected results after creating partial index |
|
142 | CS | 839 | 907 | 869 | 783 | 834 | 832 | 827 | 833 | 818 | 805 | 868 | 844 | 825 | 867 | 895 | 1342 | 709 | 818 | 1332 | 887 | 1371 | 1313 | 1439 | 831 | 1350 | 808 | 803 | 1163 | 1340 | 766 | 811 | Simple derived table |
|
143 | SS | 639 | 740 | 475 | 662 | 548 | 408 | 718 | 534 | 454 | 657 | 635 | 545 | 453 | 712 | 634 | 692 | 431 | 732 | 611 | 532 | 643 | 784 | 588 | 546 | 745 | 502 | 728 | 668 | 772 | 678 | 742 | Simple derived table |
|
144 | CS | 854 | 894 | 854 | 918 | 792 | 960 | 831 | 853 | 818 | 905 | 851 | 861 | 908 | 846 | 855 | 1293 | 712 | 797 | 1417 | 899 | 1421 | 1384 | 1363 | 950 | 791 | 772 | 848 | 780 | 1406 | 792 | 768 | Unnamed (no relation alias) derived table |
|
145 | SS | 584 | 700 | 516 | 673 | 685 | 427 | 565 | 494 | 426 | 554 | 552 | 539 | 424 | 790 | 654 | 584 | 419 | 843 | 687 | 632 | 864 | 545 | 636 | 584 | 555 | 679 | 641 | 786 | 684 | 584 | 571 | Unnamed (no relation alias) derived table |
|
146 | CS | 848 | 977 | 902 | 824 | 841 | 816 | 849 | 913 | 819 | 841 | 787 | 808 | 851 | 856 | 905 | 1297 | 772 | 780 | 1466 | 963 | 1317 | 1284 | 1383 | 874 | 808 | 847 | 721 | 805 | 1345 | 819 | 770 | Explicit column names for derived table |
|
147 | SS | 627 | 703 | 455 | 623 | 613 | 526 | 669 | 516 | 455 | 607 | 527 | 572 | 435 | 526 | 677 | 767 | 457 | 724 | 773 | 538 | 781 | 684 | 784 | 562 | 740 | 620 | 766 | 644 | 631 | 740 | 713 | Explicit column names for derived table |
|
148 | CS | 866 | 828 | 890 | 869 | 793 | 836 | 845 | 924 | 844 | 785 | 863 | 878 | 850 | 906 | 851 | 1345 | 728 | 751 | 1316 | 1433 | 1271 | 1389 | 1371 | 929 | 735 | 1605 | 1438 | 811 | 1280 | 845 | 737 | Outer reference to upper scope-level is allowed |
|
149 | SS | 681 | 784 | 450 | 528 | 695 | 745 | 396 | 494 | 418 | 435 | 733 | 713 | 531 | 837 | 629 | 593 | 589 | 753 | 741 | 575 | 857 | 533 | 751 | 573 | 731 | 776 | 679 | 684 | 687 | 724 | 674 | Outer reference to upper scope-level is allowed |
|
150 | CS | 846 | 818 | 873 | 801 | 842 | 768 | 810 | 851 | 813 | 830 | 837 | 858 | 895 | 827 | 820 | 736 | 796 | 853 | 1327 | 1371 | 1280 | 1442 | 1352 | 892 | 788 | 1321 | 1250 | 823 | 1304 | 859 | 768 | Outer reference to upper scope-level is allowed |
|
151 | SS | 669 | 900 | 478 | 726 | 709 | 664 | 419 | 517 | 448 | 451 | 543 | 740 | 483 | 726 | 513 | 720 | 524 | 695 | 767 | 722 | 675 | 748 | 729 | 549 | 631 | 698 | 543 | 780 | 625 | 656 | 779 | Outer reference to upper scope-level is allowed |
|
152 | CS | 872 | 814 | 920 | 840 | 834 | 877 | 867 | 897 | 781 | 821 | 859 | 856 | 824 | 924 | 819 | 756 | 753 | 899 | 1360 | 1420 | 1352 | 1374 | 1321 | 913 | 856 | 1345 | 1355 | 1400 | 1408 | 735 | 700 | Outer reference to upper scope-level is allowed |
|
153 | SS | 616 | 733 | 505 | 542 | 596 | 523 | 418 | 459 | 419 | 513 | 576 | 672 | 471 | 883 | 439 | 789 | 719 | 699 | 633 | 727 | 654 | 685 | 617 | 562 | 660 | 616 | 726 | 683 | 609 | 705 | 581 | Outer reference to upper scope-level is allowed |
|
154 | CS | 885 | 876 | 873 | 852 | 771 | 806 | 894 | 798 | 880 | 889 | 796 | 866 | 881 | 897 | 826 | 1332 | 727 | 799 | 982 | 1340 | 1356 | 1295 | 1304 | 945 | 1263 | 1480 | 1388 | 1327 | 1528 | 841 | 770 | FIRST / SKIP inside derived table |
|
155 | SS | 652 | 759 | 467 | 632 | 502 | 617 | 538 | 533 | 413 | 442 | 672 | 708 | 463 | 731 | 430 | 722 | 686 | 577 | 540 | 831 | 867 | 769 | 682 | 562 | 697 | 570 | 739 | 712 | 696 | 633 | 685 | FIRST / SKIP inside derived table |
|
156 | CS | 869 | 900 | 893 | 788 | 834 | 865 | 854 | 814 | 837 | 803 | 862 | 859 | 874 | 819 | 873 | 1213 | 741 | 737 | 774 | 1385 | 1412 | 1265 | 1451 | 924 | 1265 | 1399 | 1469 | 1380 | 1608 | 809 | 786 | UNION inside derived table |
|
157 | SS | 644 | 578 | 468 | 604 | 698 | 702 | 580 | 464 | 417 | 607 | 624 | 648 | 508 | 640 | 435 | 756 | 702 | 775 | 720 | 798 | 703 | 553 | 724 | 583 | 683 | 769 | 555 | 589 | 665 | 716 | 678 | UNION inside derived table |
|
158 | CS | 871 | 879 | 898 | 838 | 816 | 916 | 834 | 853 | 844 | 833 | 811 | 818 | 863 | 860 | 794 | 1084 | 711 | 923 | 807 | 1299 | 1282 | 1302 | 1421 | 944 | 1433 | 1417 | 1548 | 1167 | 1403 | 786 | 807 | Simple derived table with aggregate inside |
|
159 | SS | 657 | 760 | 660 | 704 | 689 | 584 | 543 | 486 | 434 | 453 | 712 | 737 | 457 | 636 | 436 | 587 | 756 | 788 | 580 | 739 | 574 | 654 | 769 | 568 | 680 | 528 | 702 | 551 | 700 | 740 | 754 | Simple derived table with aggregate inside |
|
160 | CS | 868 | 842 | 867 | 780 | 835 | 804 | 851 | 816 | 811 | 887 | 900 | 908 | 846 | 872 | 853 | 1300 | 770 | 844 | 726 | 1364 | 1518 | 1326 | 1416 | 869 | 1498 | 1344 | 1408 | 814 | 1356 | 976 | 770 | Aggregate inside derived table |
|
161 | SS | 665 | 724 | 497 | 638 | 711 | 678 | 432 | 458 | 444 | 645 | 501 | 706 | 453 | 777 | 484 | 546 | 689 | 627 | 712 | 551 | 787 | 801 | 759 | 580 | 862 | 651 | 733 | 720 | 653 | 732 | 703 | Aggregate inside derived table |
|
162 | CS | 861 | 827 | 875 | 880 | 848 | 795 | 847 | 852 | 792 | 859 | 838 | 860 | 854 | 880 | 883 | 1279 | 850 | 760 | 791 | 1016 | 1448 | 1267 | 1310 | 946 | 1355 | 1316 | 1308 | 863 | 1559 | 812 | 836 | Aggregate inside derived table |
|
163 | SS | 634 | 591 | 473 | 706 | 669 | 606 | 440 | 488 | 449 | 450 | 612 | 473 | 477 | 779 | 562 | 690 | 723 | 759 | 840 | 773 | 560 | 832 | 679 | 652 | 617 | 728 | 726 | 692 | 515 | 567 | 688 | Aggregate inside derived table |
|
164 | CS | 879 | 871 | 880 | 898 | 823 | 851 | 825 | 851 | 834 | 973 | 878 | 854 | 808 | 819 | 813 | 1333 | 1044 | 784 | 797 | 1147 | 1455 | 1378 | 1434 | 1007 | 1471 | 1458 | 1257 | 1054 | 1357 | 815 | 847 | Sub-select inside derived table |
|
165 | SS | 638 | 625 | 438 | 660 | 763 | 680 | 413 | 525 | 432 | 470 | 517 | 437 | 441 | 723 | 450 | 767 | 645 | 663 | 732 | 632 | 762 | 740 | 765 | 577 | 688 | 661 | 653 | 569 | 544 | 559 | 721 | Sub-select inside derived table |
|
166 | CS | 872 | 892 | 873 | 773 | 869 | 717 | 854 | 789 | 829 | 822 | 832 | 871 | 882 | 844 | 792 | 1292 | 1216 | 834 | 781 | 1328 | 1369 | 1295 | 1432 | 956 | 1259 | 1222 | 1246 | 1271 | 1517 | 791 | 783 | Sub-select inside derived table |
|
167 | SS | 650 | 611 | 434 | 695 | 599 | 719 | 448 | 486 | 435 | 481 | 538 | 451 | 451 | 697 | 424 | 739 | 439 | 814 | 641 | 524 | 756 | 659 | 773 | 558 | 713 | 792 | 720 | 749 | 760 | 678 | 712 | Sub-select inside derived table |
|
168 | CS | 877 | 879 | 908 | 803 | 777 | 825 | 885 | 838 | 868 | 846 | 816 | 845 | 846 | 876 | 823 | 1069 | 1384 | 720 | 774 | 1373 | 1371 | 1332 | 1340 | 996 | 1355 | 1293 | 1032 | 1159 | 1282 | 803 | 767 | Implicit derived table by IN predicate |
|
169 | SS | 631 | 738 | 431 | 717 | 757 | 507 | 440 | 468 | 449 | 452 | 590 | 718 | 441 | 741 | 430 | 666 | 391 | 735 | 624 | 744 | 687 | 708 | 770 | 563 | 725 | 667 | 900 | 543 | 592 | 588 | 639 | Implicit derived table by IN predicate |
|
170 | CS | 870 | 892 | 858 | 829 | 854 | 833 | 902 | 846 | 883 | 915 | 882 | 839 | 841 | 855 | 845 | 764 | 1204 | 792 | 810 | 957 | 1419 | 1353 | 1372 | 926 | 1346 | 1387 | 1296 | 786 | 1357 | 773 | 847 | Derived table outer reference (triggers) |
|
171 | SS | 646 | 754 | 447 | 668 | 647 | 614 | 442 | 455 | 438 | 480 | 570 | 694 | 492 | 712 | 474 | 617 | 444 | 814 | 723 | 768 | 652 | 861 | 645 | 599 | 746 | 741 | 771 | 588 | 697 | 559 | 732 | Derived table outer reference (triggers) |
|
172 | CS | 727 | 737 | 835 | 729 | 687 | 711 | 653 | 736 | 560 | 682 | 708 | 649 | 743 | 761 | 712 | 729 | 762 | 1022 | 604 | 1141 | 726 | 742 | 635 | 767 | 1043 | 728 | 644 | 1187 | 714 | 725 | 675 | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
173 | SS | 563 | 571 | 335 | 343 | 584 | 427 | 475 | 652 | 606 | 555 | 695 | 388 | 665 | 554 | 571 | 574 | 621 | 653 | 711 | 734 | 663 | 700 | 356 | 447 | 552 | 318 | 498 | 577 | 326 | 534 | 306 | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
174 | CS | 693 | 709 | 751 | 637 | 638 | 705 | 730 | 683 | 648 | 703 | 761 | 676 | 663 | 728 | 672 | 643 | 619 | 576 | 570 | 853 | 672 | 613 | 599 | 800 | 1037 | 711 | 1160 | 1127 | 1148 | 588 | 1036 | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
175 | SS | 474 | 616 | 527 | 307 | 492 | 491 | 478 | 639 | 422 | 601 | 470 | 341 | 580 | 416 | 480 | 550 | 320 | 578 | 585 | 334 | 694 | 482 | 358 | 466 | 532 | 311 | 334 | 362 | 449 | 308 | 427 | Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword. |
|
176 | CS | 854 | 824 | 869 | 835 | 854 | 792 | 890 | 885 | 829 | 865 | 829 | 911 | 870 | 850 | 903 | 749 | 869 | 763 | 771 | 842 | 847 | 821 | 782 | 961 | 1355 | 855 | 1348 | 1321 | 1081 | 824 | 1428 | Non-Recursive CTEs |
|
177 | SS | 640 | 710 | 727 | 502 | 632 | 439 | 571 | 808 | 761 | 655 | 536 | 437 | 668 | 694 | 716 | 711 | 438 | 726 | 749 | 465 | 848 | 651 | 649 | 542 | 684 | 472 | 529 | 565 | 603 | 437 | 561 | Non-Recursive CTEs |
|
178 | CS | 868 | 860 | 850 | 990 | 876 | 874 | 848 | 867 | 865 | 738 | 906 | 807 | 845 | 910 | 883 | 690 | 874 | 816 | 788 | 870 | 982 | 773 | 733 | 967 | 1240 | 848 | 1479 | 1540 | 835 | 1419 | 1472 | Recursive CTEs |
|
179 | SS | 622 | 749 | 662 | 449 | 584 | 574 | 493 | 735 | 815 | 760 | 807 | 493 | 737 | 710 | 640 | 628 | 414 | 642 | 753 | 521 | 766 | 684 | 862 | 601 | 617 | 414 | 598 | 513 | 548 | 424 | 524 | Recursive CTEs |
|
180 | CS | 861 | 826 | 924 | 822 | 839 | 805 | 806 | 883 | 769 | 914 | 921 | 913 | 883 | 836 | 879 | 720 | 838 | 757 | 757 | 1363 | 879 | 780 | 835 | 890 | 1337 | 879 | 1377 | 1493 | 843 | 783 | 1388 | MERGE statement |
|
181 | SS | 634 | 437 | 738 | 400 | 556 | 468 | 576 | 655 | 745 | 857 | 734 | 631 | 745 | 746 | 782 | 539 | 637 | 772 | 660 | 816 | 812 | 763 | 819 | 571 | 559 | 425 | 396 | 539 | 566 | 443 | 539 | MERGE statement |
|
182 | CS | 6101 | 5579 | 6132 | 5134 | 5599 | 5688 | 5121 | 5728 | 5749 | 5412 | 5686 | 5747 | 6106 | 5593 | 5456 | 7948 | 6074 | 6096 | 8423 | 9547 | 6996 | 5684 | 10128 | 6758 | 7141 | 6725 | 8374 | 7787 | 8660 | 9436 | 6694 | Check result or CAST() for misc agruments // from GTCS. |
|
183 | SS | 7604 | 7655 | 6776 | 5890 | 7328 | 6720 | 8728 | 5721 | 6955 | 7529 | 7779 | 6140 | 7288 | 7671 | 8788 | 8715 | 8316 | 7364 | 8683 | 7809 | 8272 | 8344 | 9228 | 5917 | 8881 | 8140 | 8904 | 7554 | 6436 | 7064 | 6051 | Check result or CAST() for misc agruments // from GTCS. |
|
184 | CS | 795 | 748 | 839 | 743 | 841 | 813 | 769 | 778 | 694 | 720 | 728 | 847 | 846 | 719 | 712 | 1240 | 836 | 657 | 1152 | 710 | 945 | 1394 | 1213 | 906 | 1185 | 689 | 757 | 753 | 1220 | 1302 | 628 | Computed fields |
|
185 | SS | 636 | 678 | 456 | 656 | 616 | 697 | 724 | 688 | 656 | 717 | 890 | 614 | 789 | 745 | 669 | 432 | 700 | 772 | 472 | 555 | 753 | 550 | 449 | 581 | 717 | 454 | 591 | 397 | 415 | 471 | 358 | Computed fields |
|
186 | CS | 886 | 803 | 847 | 859 | 815 | 730 | 774 | 775 | 901 | 892 | 885 | 769 | 854 | 786 | 710 | 1279 | 835 | 888 | 1302 | 1033 | 1252 | 1392 | 1264 | 924 | 1241 | 784 | 1246 | 1439 | 1341 | 1257 | 660 | Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value. |
|
187 | SS | 699 | 778 | 458 | 666 | 729 | 731 | 592 | 519 | 501 | 736 | 769 | 771 | 831 | 741 | 669 | 509 | 747 | 787 | 393 | 791 | 831 | 797 | 809 | 565 | 393 | 754 | 391 | 651 | 464 | 483 | 410 | Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value. |
|
188 | CS | 785 | 704 | 736 | 773 | 676 | 756 | 682 | 742 | 727 | 715 | 847 | 788 | 779 | 760 | 739 | 1189 | 783 | 850 | 1266 | 1068 | 1129 | 1255 | 1124 | 873 | 1130 | 782 | 1353 | 1304 | 1305 | 1103 | 618 | Verify result of INSERT DEFAULT for domain-based fields which have their own default values |
|
189 | SS | 619 | 652 | 384 | 477 | 754 | 455 | 690 | 738 | 659 | 661 | 435 | 709 | 763 | 517 | 575 | 802 | 744 | 648 | 388 | 830 | 441 | 709 | 860 | 511 | 382 | 656 | 402 | 590 | 331 | 451 | 369 | Verify result of INSERT DEFAULT for domain-based fields which have their own default values |
|
190 | CS | 842 | 766 | 907 | 782 | 725 | 645 | 802 | 725 | 741 | 827 | 718 | 864 | 796 | 835 | 741 | 1158 | 842 | 843 | 1144 | 1179 | 1307 | 1288 | 1283 | 863 | 918 | 746 | 1156 | 957 | 1182 | 1293 | 661 | Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values |
|
191 | SS | 560 | 644 | 405 | 550 | 700 | 486 | 632 | 523 | 509 | 532 | 526 | 769 | 693 | 499 | 468 | 772 | 505 | 769 | 377 | 794 | 632 | 707 | 851 | 570 | 516 | 737 | 404 | 685 | 389 | 667 | 388 | Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values |
|
192 | CS | 914 | 841 | 895 | 834 | 854 | 868 | 951 | 819 | 852 | 830 | 849 | 856 | 914 | 860 | 863 | 1289 | 915 | 933 | 1255 | 1517 | 1317 | 1320 | 1360 | 1024 | 1120 | 785 | 1338 | 1413 | 1217 | 1407 | 700 | Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain |
|
193 | SS | 734 | 816 | 462 | 576 | 833 | 641 | 592 | 428 | 858 | 542 | 864 | 798 | 812 | 847 | 545 | 782 | 552 | 793 | 488 | 687 | 919 | 573 | 896 | 668 | 784 | 802 | 461 | 910 | 388 | 783 | 385 | Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain |
|
194 | CS | 1289 | 1253 | 1412 | 1127 | 1181 | 1236 | 1272 | 1182 | 1172 | 1328 | 1239 | 1314 | 1255 | 1356 | 1377 | 1689 | 1187 | 1340 | 1191 | 1849 | 1889 | 1838 | 1747 | 1306 | 1692 | 1152 | 955 | 994 | 979 | 1796 | 1561 | gtcs-proc-isql-11 |
|
195 | SS | 945 | 554 | 760 | 671 | 703 | 795 | 987 | 993 | 939 | 967 | 1035 | 1030 | 1003 | 808 | 1085 | 800 | 951 | 928 | 952 | 1049 | 1098 | 841 | 1060 | 817 | 989 | 1004 | 1032 | 764 | 524 | 567 | 519 | gtcs-proc-isql-11 |
|
196 | CS | 1272 | 1264 | 1371 | 1250 | 1281 | 1429 | 1214 | 1280 | 1240 | 1342 | 1251 | 1220 | 1265 | 1245 | 1246 | 1596 | 1151 | 1323 | 1001 | 1464 | 2497 | 1832 | 1685 | 1430 | 1495 | 942 | 955 | 994 | 1013 | 1692 | 1505 | gtcs-proc-isql-15 |
|
197 | SS | 868 | 568 | 648 | 686 | 971 | 719 | 850 | 1076 | 817 | 1084 | 934 | 1076 | 960 | 1109 | 1061 | 887 | 945 | 1024 | 768 | 1018 | 1057 | 976 | 824 | 847 | 1132 | 793 | 522 | 716 | 562 | 577 | 510 | gtcs-proc-isql-15 |
|
198 | CS | 1253 | 1239 | 1391 | 1251 | 1214 | 1373 | 1199 | 1199 | 1164 | 1255 | 1282 | 1215 | 1450 | 1241 | 1198 | 1221 | 1240 | 1271 | 928 | 1691 | 1789 | 1608 | 1779 | 1266 | 1828 | 1488 | 1243 | 1196 | 1003 | 1816 | 1517 | gtcs-proc-isql-16 |
|
199 | SS | 944 | 601 | 673 | 670 | 1037 | 903 | 902 | 1000 | 1084 | 986 | 987 | 777 | 978 | 965 | 1056 | 945 | 957 | 944 | 816 | 1084 | 929 | 1060 | 1106 | 792 | 1136 | 1074 | 554 | 724 | 602 | 764 | 496 | gtcs-proc-isql-16 |
|
200 | CS | 1269 | 1242 | 1286 | 1228 | 1218 | 1255 | 1301 | 1201 | 1255 | 1216 | 1283 | 1225 | 1308 | 1304 | 1340 | 926 | 1243 | 1339 | 1875 | 1182 | 1716 | 2033 | 1707 | 1389 | 1050 | 1145 | 1448 | 1079 | 1016 | 1815 | 1693 | Test for select from SP that deletes record after its output |
|
201 | SS | 956 | 660 | 856 | 792 | 964 | 1016 | 1067 | 976 | 612 | 966 | 927 | 972 | 882 | 988 | 847 | 945 | 977 | 779 | 1010 | 1035 | 992 | 1080 | 925 | 837 | 1049 | 1042 | 982 | 847 | 949 | 562 | 522 | Test for select from SP that deletes record after its output |
|
202 | CS | 705 | 738 | 698 | 601 | 772 | 697 | 655 | 683 | 734 | 713 | 698 | 671 | 674 | 670 | 760 | 1075 | 730 | 749 | 1146 | 673 | 1194 | 1094 | 608 | 749 | 628 | 621 | 633 | 763 | 555 | 1080 | 1052 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
203 | SS | 618 | 328 | 623 | 482 | 634 | 618 | 512 | 624 | 669 | 646 | 647 | 654 | 596 | 577 | 446 | 546 | 534 | 657 | 618 | 606 | 668 | 677 | 707 | 463 | 576 | 670 | 628 | 364 | 723 | 323 | 436 | SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern> |
|
204 | CS | 670 | 661 | 682 | 695 | 673 | 638 | 703 | 696 | 671 | 664 | 647 | 648 | 640 | 644 | 665 | 574 | 670 | 654 | 576 | 823 | 1035 | 593 | 938 | 684 | 774 | 1246 | 671 | 599 | 650 | 1208 | 1100 | CAST CHAR -> TIME |
|
205 | SS | 509 | 342 | 530 | 528 | 560 | 528 | 495 | 488 | 460 | 578 | 381 | 403 | 502 | 581 | 520 | 430 | 546 | 635 | 447 | 505 | 476 | 620 | 573 | 435 | 536 | 535 | 514 | 643 | 382 | 316 | 384 | CAST CHAR -> TIME |
|
206 | CS | 678 | 715 | 716 | 657 | 708 | 663 | 667 | 678 | 680 | 663 | 623 | 622 | 679 | 690 | 580 | 669 | 671 | 684 | 587 | 759 | 1045 | 625 | 1165 | 752 | 638 | 999 | 713 | 643 | 571 | 1031 | 1028 | CAST CHAR -> TIME |
|
207 | SS | 527 | 300 | 613 | 570 | 452 | 495 | 548 | 440 | 612 | 451 | 544 | 566 | 571 | 607 | 584 | 557 | 527 | 424 | 460 | 528 | 509 | 569 | 583 | 400 | 477 | 665 | 499 | 597 | 322 | 340 | 335 | CAST CHAR -> TIME |
|
208 | CS | 657 | 682 | 726 | 643 | 636 | 723 | 600 | 680 | 650 | 708 | 659 | 684 | 686 | 714 | 656 | 575 | 701 | 684 | 594 | 639 | 599 | 618 | 640 | 754 | 746 | 617 | 642 | 645 | 614 | 819 | 1060 | CAST TIMESTAMP -> TIME |
|
209 | SS | 524 | 328 | 640 | 564 | 554 | 530 | 594 | 504 | 561 | 524 | 525 | 573 | 461 | 499 | 568 | 559 | 524 | 611 | 491 | 427 | 510 | 502 | 696 | 395 | 544 | 488 | 588 | 463 | 340 | 313 | 318 | CAST TIMESTAMP -> TIME |
|
210 | CS | 846 | 794 | 892 | 968 | 833 | 870 | 906 | 844 | 838 | 838 | 848 | 796 | 922 | 804 | 930 | 774 | 917 | 858 | 865 | 938 | 809 | 816 | 741 | 929 | 909 | 829 | 777 | 776 | 762 | 1329 | 1375 | COUNT |
|
211 | SS | 655 | 444 | 633 | 680 | 692 | 756 | 568 | 532 | 551 | 774 | 541 | 567 | 740 | 724 | 737 | 744 | 645 | 601 | 710 | 751 | 760 | 657 | 803 | 540 | 653 | 751 | 624 | 681 | 425 | 421 | 425 | COUNT |
|
212 | CS | 648 | 695 | 779 | 665 | 614 | 636 | 677 | 659 | 614 | 635 | 630 | 709 | 691 | 637 | 610 | 608 | 701 | 701 | 592 | 717 | 691 | 621 | 1163 | 725 | 692 | 604 | 599 | 609 | 635 | 580 | 1037 | DATEADD |
|
213 | SS | 546 | 317 | 584 | 542 | 542 | 539 | 568 | 488 | 472 | 570 | 588 | 429 | 609 | 596 | 550 | 591 | 469 | 578 | 543 | 605 | 514 | 637 | 588 | 415 | 596 | 605 | 366 | 446 | 303 | 562 | 313 | DATEADD |
|
214 | CS | 674 | 663 | 701 | 662 | 741 | 653 | 761 | 725 | 697 | 609 | 709 | 663 | 670 | 692 | 676 | 612 | 673 | 688 | 724 | 694 | 601 | 662 | 1084 | 698 | 751 | 602 | 573 | 593 | 629 | 588 | 1095 | DATEADD |
|
215 | SS | 542 | 297 | 603 | 514 | 463 | 486 | 540 | 578 | 568 | 528 | 466 | 566 | 575 | 553 | 497 | 628 | 453 | 634 | 544 | 633 | 570 | 531 | 590 | 443 | 611 | 683 | 472 | 622 | 360 | 501 | 316 | DATEADD |
|
216 | CS | 667 | 666 | 720 | 616 | 690 | 714 | 663 | 700 | 660 | 669 | 671 | 623 | 656 | 701 | 665 | 571 | 672 | 704 | 659 | 710 | 1073 | 628 | 995 | 755 | 672 | 572 | 655 | 637 | 607 | 657 | 1060 | Dateadd milliseconds |
|
217 | SS | 529 | 327 | 557 | 496 | 571 | 390 | 507 | 532 | 560 | 606 | 544 | 574 | 516 | 499 | 508 | 453 | 538 | 554 | 573 | 552 | 523 | 551 | 448 | 483 | 527 | 553 | 483 | 680 | 365 | 547 | 323 | Dateadd milliseconds |
|
218 | CS | 673 | 659 | 1024 | 730 | 628 | 654 | 650 | 654 | 669 | 599 | 674 | 679 | 672 | 649 | 643 | 736 | 628 | 672 | 740 | 782 | 1064 | 689 | 616 | 701 | 683 | 1162 | 625 | 713 | 666 | 1117 | 927 | EXTRACT(WEEK FROM DATE) |
|
219 | SS | 483 | 309 | 615 | 535 | 478 | 375 | 393 | 586 | 334 | 460 | 621 | 459 | 439 | 558 | 508 | 439 | 590 | 668 | 447 | 531 | 548 | 567 | 474 | 436 | 401 | 538 | 564 | 447 | 489 | 524 | 311 | EXTRACT(WEEK FROM DATE) |
|
220 | CS | 691 | 722 | 724 | 643 | 656 | 657 | 756 | 683 | 734 | 700 | 636 | 632 | 657 | 643 | 663 | 741 | 665 | 642 | 736 | 742 | 1091 | 1050 | 705 | 708 | 702 | 1109 | 631 | 1040 | 653 | 552 | 623 | TRUNC( <number> [, <number> ] ) |
|
221 | SS | 486 | 346 | 432 | 386 | 548 | 537 | 315 | 538 | 483 | 338 | 581 | 481 | 476 | 593 | 586 | 565 | 484 | 648 | 604 | 568 | 654 | 488 | 534 | 427 | 429 | 379 | 565 | 621 | 423 | 408 | 468 | TRUNC( <number> [, <number> ] ) |
|
222 | CS | 700 | 736 | 715 | 685 | 665 | 645 | 662 | 662 | 734 | 735 | 691 | 731 | 677 | 622 | 733 | 674 | 619 | 710 | 676 | 777 | 732 | 1192 | 682 | 709 | 627 | 1059 | 1062 | 1140 | 1075 | 635 | 625 | POSITION( <string> IN <string> ) |
|
223 | SS | 558 | 299 | 572 | 541 | 302 | 408 | 563 | 476 | 408 | 592 | 576 | 320 | 563 | 500 | 540 | 512 | 708 | 708 | 575 | 574 | 562 | 566 | 592 | 462 | 552 | 604 | 591 | 678 | 554 | 296 | 547 | POSITION( <string> IN <string> ) |
|
224 | CS | 696 | 617 | 711 | 655 | 619 | 650 | 605 | 696 | 669 | 639 | 624 | 622 | 711 | 696 | 676 | 707 | 680 | 715 | 696 | 710 | 1189 | 1164 | 716 | 688 | 795 | 1101 | 1007 | 1101 | 1076 | 704 | 561 | Test for TRUNC function |
|
225 | SS | 519 | 339 | 454 | 511 | 423 | 512 | 445 | 576 | 433 | 492 | 530 | 413 | 467 | 517 | 458 | 572 | 548 | 718 | 606 | 528 | 657 | 521 | 620 | 436 | 584 | 608 | 618 | 494 | 558 | 307 | 544 | Test for TRUNC function |
|
226 | CS | 812 | 714 | 798 | 743 | 768 | 749 | 886 | 642 | 775 | 737 | 777 | 755 | 813 | 903 | 735 | 844 | 799 | 811 | 878 | 901 | 1305 | 1211 | 847 | 916 | 875 | 1394 | 1312 | 1340 | 1245 | 741 | 670 | UNLIST function. Check output for different returning types |
|
227 | SS | 676 | 460 | 519 | 672 | 708 | 513 | 707 | 514 | 680 | 719 | 574 | 576 | 730 | 743 | 685 | 587 | 767 | 572 | 730 | 622 | 880 | 584 | 772 | 596 | 714 | 831 | 516 | 588 | 751 | 607 | 764 | UNLIST function. Check output for different returning types |
|
228 | CS | 2863 | 2806 | 3144 | 2844 | 2787 | 2817 | 2832 | 2899 | 2771 | 2816 | 2780 | 2876 | 2943 | 2678 | 2853 | 2930 | 2782 | 2942 | 2789 | 3054 | 3171 | 2873 | 3027 | 3116 | 3009 | 2998 | 4319 | 4600 | 2639 | 2612 | 2363 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
229 | SS | 1848 | 1003 | 1835 | 1823 | 1548 | 1743 | 1821 | 1867 | 1764 | 2017 | 1838 | 1883 | 1828 | 2008 | 1858 | 2008 | 2089 | 1774 | 2097 | 1879 | 2001 | 1948 | 1885 | 1551 | 1800 | 1735 | 2000 | 1812 | 1037 | 1929 | 2039 | SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login. |
|
230 | CS | 29835 | 30046 | 30071 | 29694 | 29626 | 29699 | 29693 | 29613 | 29576 | 29702 | 29684 | 29459 | 29922 | 29816 | 29913 | 29962 | 29821 | 29714 | 29883 | 29950 | 29919 | 29870 | 29850 | 29992 | 30153 | 29870 | 29495 | 29409 | 29373 | 31984 | 29891 | External Connections Pool, functionality test 01 |
|
231 | SS | 27939 | 28049 | 28202 | 27914 | 27993 | 27851 | 28069 | 27855 | 27965 | 28201 | 28123 | 27897 | 28347 | 27238 | 28118 | 27764 | 27702 | 27856 | 27580 | 27866 | 27505 | 27735 | 27791 | 27808 | 28119 | 28066 | 27420 | 28013 | 27995 | 28176 | 28183 | External Connections Pool, functionality test 01 |
|
232 | CS | 1331 | 1228 | 1345 | 1386 | 1322 | 1284 | 1246 | 1406 | 1337 | 1273 | 1393 | 1283 | 1296 | 1378 | 1305 | 1297 | 1327 | 1370 | 1313 | 1383 | 1432 | 1374 | 1335 | 1334 | 1325 | 1452 | 1418 | 1298 | 1353 | 1328 | 1229 | Common SQL. Check correctness of the results |
|
233 | SS | 1090 | 1228 | 1208 | 1108 | 1102 | 1151 | 1092 | 892 | 639 | 1028 | 636 | 1091 | 951 | 618 | 945 | 930 | 1080 | 1139 | 1130 | 1210 | 1090 | 1129 | 924 | 954 | 1255 | 1180 | 1099 | 1072 | 1128 | 993 | 595 | Common SQL. Check correctness of the results |
|
234 | CS | 1357 | 1354 | 1508 | 1329 | 1389 | 1338 | 1274 | 1339 | 1167 | 1246 | 1265 | 1402 | 1352 | 1210 | 1326 | 1398 | 1463 | 1472 | 1419 | 1464 | 1558 | 1522 | 1550 | 1390 | 1295 | 1354 | 1436 | 1314 | 1521 | 1360 | 1275 | Common SQL. Check correctness of the results |
|
235 | SS | 1029 | 912 | 1215 | 740 | 1004 | 810 | 642 | 1038 | 656 | 1099 | 597 | 929 | 1253 | 688 | 907 | 1217 | 872 | 1268 | 1009 | 1346 | 1233 | 1421 | 1095 | 1013 | 1217 | 1265 | 1198 | 1165 | 1109 | 1020 | 733 | Common SQL. Check correctness of the results |
|
236 | CS | 932 | 941 | 999 | 942 | 951 | 831 | 863 | 958 | 842 | 919 | 888 | 932 | 965 | 863 | 840 | 823 | 915 | 943 | 959 | 892 | 888 | 991 | 912 | 915 | 864 | 932 | 995 | 993 | 973 | 938 | 975 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
237 | SS | 664 | 824 | 852 | 765 | 452 | 767 | 611 | 494 | 468 | 556 | 581 | 487 | 635 | 456 | 473 | 820 | 862 | 776 | 780 | 699 | 616 | 693 | 830 | 611 | 763 | 795 | 478 | 478 | 703 | 395 | 757 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
238 | CS | 7391 | 3873 | 7437 | 7144 | 7290 | 7258 | 7179 | 7293 | 7189 | 7277 | 7293 | 7290 | 7362 | 7122 | 8334 | 7372 | 7396 | 7552 | 7467 | 7622 | 7558 | 7401 | 7386 | 7504 | 7328 | 7453 | 7557 | 7434 | 7456 | 7407 | 7432 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
239 | SS | 6856 | 3653 | 6701 | 6836 | 6752 | 6604 | 6360 | 7433 | 6812 | 6771 | 5959 | 6965 | 6432 | 5951 | 6030 | 6720 | 6982 | 6959 | 6854 | 7277 | 7104 | 7163 | 6859 | 6650 | 6863 | 7040 | 7296 | 7351 | 7080 | 7169 | 6940 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
240 | CS | 7252 | 3908 | 7259 | 7037 | 7162 | 7269 | 7217 | 7291 | 7219 | 7209 | 7224 | 7173 | 7246 | 7071 | 7138 | 7224 | 7346 | 7358 | 7431 | 7275 | 7458 | 7418 | 7297 | 7434 | 7219 | 7504 | 7329 | 7419 | 7235 | 7455 | 7212 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
241 | SS | 6660 | 3460 | 6577 | 6645 | 6313 | 6572 | 6692 | 5965 | 6612 | 6629 | 5966 | 6623 | 5912 | 5912 | 5962 | 7033 | 6947 | 6866 | 6742 | 6892 | 6868 | 6814 | 6676 | 6451 | 6799 | 6911 | 7015 | 7296 | 6356 | 6782 | 7002 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
242 | CS | 7431 | 3875 | 7472 | 7171 | 7279 | 7306 | 7241 | 7247 | 7248 | 7354 | 7417 | 7480 | 7416 | 7393 | 7374 | 7495 | 7445 | 7451 | 7470 | 7471 | 7494 | 7554 | 7417 | 7464 | 7547 | 7500 | 7613 | 7403 | 7532 | 7355 | 7515 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
243 | SS | 6653 | 3468 | 6839 | 6639 | 6127 | 6823 | 6600 | 5968 | 6652 | 7368 | 5851 | 6501 | 6221 | 6074 | 6036 | 6543 | 6593 | 6991 | 6441 | 6791 | 6849 | 6806 | 6996 | 6299 | 7112 | 6957 | 6880 | 6665 | 6654 | 6771 | 6901 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
244 | CS | 53838 | 4145 | 53937 | 51640 | 53349 | 52336 | 52187 | 52296 | 52195 | 52582 | 52500 | 52336 | 52818 | 53504 | 52982 | 53808 | 54937 | 53809 | 54444 | 56098 | 55182 | 56316 | 53867 | 55407 | 54807 | 54190 | 54691 | 54449 | 54308 | 55420 | 56074 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
245 | SS | 51815 | 3779 | 52197 | 50178 | 48983 | 48341 | 48888 | 43103 | 48638 | 51616 | 44388 | 49773 | 50040 | 46143 | 43149 | 53231 | 54122 | 54958 | 53187 | 54660 | 53827 | 53847 | 53933 | 49198 | 52012 | 53684 | 54157 | 54107 | 51618 | 53853 | 53300 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
246 | CS | 7316 | 3822 | 7243 | 7297 | 7178 | 7153 | 7258 | 7215 | 7244 | 7154 | 7219 | 7165 | 7370 | 7193 | 7208 | 7218 | 7343 | 7314 | 7318 | 7343 | 7438 | 7375 | 7364 | 7494 | 11296 | 7350 | 7341 | 7350 | 7506 | 7338 | 7423 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
247 | SS | 6675 | 3363 | 6694 | 5922 | 6377 | 6355 | 6776 | 5988 | 6450 | 6248 | 6644 | 5966 | 6157 | 6626 | 5985 | 7256 | 6779 | 6709 | 6949 | 6762 | 6942 | 6809 | 7042 | 6548 | 6672 | 6679 | 6670 | 6867 | 6946 | 7698 | 6832 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
248 | CS | 7286 | 3812 | 7233 | 7134 | 7112 | 7087 | 7239 | 7171 | 7223 | 7205 | 7267 | 7316 | 7327 | 7151 | 7173 | 7294 | 7501 | 7429 | 7322 | 7316 | 7450 | 8260 | 7457 | 7533 | 7441 | 7360 | 7278 | 8255 | 7241 | 7259 | 7337 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
249 | SS | 6771 | 3560 | 6378 | 5978 | 6780 | 7122 | 6817 | 6028 | 6640 | 6665 | 6597 | 6309 | 5971 | 6563 | 6056 | 8225 | 6863 | 6936 | 6897 | 6740 | 6806 | 6985 | 6903 | 6280 | 6836 | 6837 | 6763 | 6911 | 6718 | 6802 | 7072 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
250 | CS | 7721 | 3990 | 7673 | 7628 | 7496 | 7732 | 7570 | 7582 | 7569 | 7715 | 7713 | 7598 | 7652 | 7624 | 7628 | 7828 | 7786 | 7827 | 7728 | 7747 | 7820 | 8727 | 7742 | 7995 | 8859 | 7864 | 7748 | 7766 | 7575 | 7784 | 7660 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
251 | SS | 7028 | 3295 | 6265 | 6970 | 7066 | 6150 | 6875 | 6124 | 6520 | 7054 | 6724 | 7055 | 6293 | 7234 | 6336 | 6908 | 7264 | 7529 | 7014 | 7206 | 7288 | 7147 | 7259 | 6745 | 7032 | 6837 | 7024 | 7122 | 7192 | 7170 | 7279 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
252 | CS | 7266 | 3770 | 7230 | 7179 | 7241 | 7274 | 7152 | 7256 | 7168 | 7277 | 7225 | 7189 | 7241 | 7169 | 7259 | 7231 | 7252 | 7534 | 7211 | 7418 | 7310 | 7367 | 7464 | 7536 | 7456 | 7309 | 7400 | 7409 | 7418 | 7348 | 8348 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
253 | SS | 6778 | 3038 | 7443 | 6472 | 6814 | 6028 | 6114 | 5939 | 6268 | 6772 | 5923 | 6740 | 5975 | 6876 | 5960 | 6047 | 6985 | 7215 | 7002 | 6848 | 7547 | 6808 | 6640 | 6584 | 6867 | 6715 | 6814 | 7077 | 6785 | 6862 | 7021 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
254 | CS | 7303 | 3807 | 7321 | 7153 | 7114 | 7143 | 7193 | 7272 | 7090 | 7189 | 7171 | 7304 | 7263 | 7076 | 7158 | 7272 | 8373 | 7384 | 7304 | 7367 | 7360 | 7187 | 7331 | 7436 | 7476 | 7352 | 7302 | 7317 | 7343 | 7361 | 7305 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
255 | SS | 6784 | 3089 | 6788 | 7481 | 6636 | 6922 | 6514 | 5920 | 6436 | 6565 | 5903 | 6458 | 5917 | 6696 | 5928 | 6872 | 7178 | 6908 | 6781 | 6841 | 6938 | 6943 | 6936 | 6440 | 6890 | 6591 | 6800 | 6911 | 6811 | 6836 | 6662 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
256 | CS | 7295 | 3794 | 7361 | 7190 | 7202 | 7250 | 7176 | 7072 | 7223 | 7088 | 7207 | 7114 | 7258 | 7250 | 7268 | 7267 | 7511 | 7388 | 7203 | 7478 | 7341 | 7366 | 7429 | 7337 | 7524 | 7322 | 7335 | 7330 | 7323 | 7426 | 7396 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
257 | SS | 6770 | 3056 | 6669 | 7418 | 6776 | 5971 | 5941 | 5917 | 5944 | 6760 | 5955 | 6814 | 6027 | 6525 | 5931 | 6481 | 7242 | 7284 | 6764 | 7129 | 7143 | 6917 | 6871 | 6417 | 6835 | 6870 | 6822 | 6924 | 7020 | 6823 | 6750 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
258 | CS | 7711 | 3987 | 7718 | 7622 | 7588 | 7419 | 7684 | 7625 | 7603 | 7745 | 7558 | 7575 | 7705 | 7558 | 7684 | 7579 | 8833 | 7694 | 7721 | 7756 | 7897 | 7883 | 7786 | 7966 | 7880 | 7914 | 7622 | 7807 | 7821 | 7751 | 7726 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
259 | SS | 7062 | 3163 | 6703 | 7045 | 7222 | 6184 | 6223 | 6172 | 6213 | 7032 | 6482 | 6652 | 6220 | 7243 | 6217 | 7209 | 7139 | 7280 | 7249 | 7239 | 7356 | 7221 | 7101 | 6792 | 7249 | 6987 | 7079 | 7121 | 7327 | 7040 | 7324 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
260 | CS | 7341 | 3730 | 7268 | 7165 | 7170 | 7098 | 7306 | 7345 | 7079 | 7173 | 7137 | 7169 | 7383 | 7124 | 7265 | 7369 | 7337 | 7348 | 7406 | 7260 | 7391 | 7360 | 7379 | 7405 | 8371 | 7399 | 7428 | 7329 | 7488 | 7524 | 8327 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
261 | SS | 6794 | 3133 | 7005 | 6635 | 6280 | 5939 | 5948 | 5916 | 6042 | 6096 | 5893 | 6456 | 5974 | 6879 | 7000 | 6989 | 6949 | 7165 | 6784 | 6795 | 7000 | 6899 | 6793 | 6496 | 6932 | 6850 | 7060 | 7084 | 6915 | 6897 | 6667 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
262 | CS | 7338 | 3815 | 7419 | 7028 | 7223 | 7240 | 7209 | 7374 | 7241 | 7212 | 7143 | 7285 | 8178 | 7201 | 7229 | 7350 | 7275 | 8309 | 7288 | 7312 | 7346 | 7441 | 7501 | 7427 | 7389 | 7345 | 7400 | 7381 | 7382 | 7535 | 7331 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
263 | SS | 6588 | 3126 | 6631 | 6390 | 5937 | 5924 | 5914 | 5945 | 5960 | 6489 | 5955 | 6484 | 5935 | 6485 | 5936 | 6849 | 6764 | 7111 | 6828 | 6988 | 7072 | 6972 | 7033 | 6494 | 6546 | 6853 | 7064 | 6663 | 6858 | 6769 | 7033 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
264 | CS | 7380 | 3945 | 7327 | 7244 | 7157 | 7292 | 7200 | 7377 | 7357 | 7270 | 7309 | 7217 | 7386 | 7216 | 7427 | 7419 | 7346 | 8327 | 7557 | 7368 | 7417 | 7467 | 7451 | 7515 | 8408 | 7477 | 8360 | 7357 | 7390 | 7460 | 7384 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
265 | SS | 6673 | 3094 | 6817 | 6643 | 5954 | 5944 | 5990 | 5959 | 6067 | 6083 | 6015 | 5944 | 6055 | 6812 | 5980 | 6649 | 6121 | 6928 | 6868 | 6776 | 7013 | 8048 | 6993 | 6698 | 7026 | 6639 | 6780 | 6924 | 6964 | 7047 | 6972 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
266 | CS | 7396 | 3861 | 8325 | 7297 | 7280 | 8290 | 7265 | 7254 | 7250 | 7231 | 8116 | 7291 | 7296 | 7222 | 7395 | 7359 | 7262 | 7512 | 7358 | 8347 | 7513 | 7556 | 7398 | 7676 | 7448 | 8321 | 7463 | 7394 | 7420 | 8562 | 7493 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
267 | SS | 6731 | 3092 | 6850 | 6735 | 5999 | 5966 | 5938 | 6028 | 6006 | 6003 | 6157 | 5967 | 5825 | 6808 | 5984 | 6415 | 6586 | 6805 | 6876 | 7317 | 7283 | 6728 | 7108 | 6474 | 7110 | 6954 | 6995 | 7140 | 7245 | 7180 | 7136 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
268 | CS | 7327 | 3834 | 7252 | 7185 | 7051 | 7116 | 7130 | 7378 | 7183 | 7238 | 8316 | 7160 | 7380 | 7234 | 7476 | 7354 | 7371 | 7462 | 7286 | 7312 | 7314 | 7339 | 7459 | 7644 | 7439 | 7357 | 7416 | 7315 | 7477 | 7456 | 7272 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
269 | SS | 6701 | 3084 | 6701 | 6701 | 5904 | 5968 | 5944 | 5927 | 5928 | 6047 | 6028 | 5966 | 6105 | 6881 | 5947 | 6556 | 6593 | 6995 | 6765 | 7108 | 6999 | 7016 | 6744 | 6555 | 7222 | 6963 | 6957 | 7111 | 6944 | 6898 | 6737 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
270 | CS | 879 | 813 | 910 | 867 | 808 | 807 | 774 | 818 | 861 | 848 | 902 | 916 | 974 | 848 | 860 | 849 | 899 | 902 | 882 | 904 | 928 | 876 | 910 | 929 | 942 | 914 | 886 | 829 | 854 | 821 | 895 | CREATE VIEW |
|
271 | SS | 624 | 547 | 749 | 768 | 403 | 445 | 495 | 533 | 437 | 476 | 764 | 590 | 487 | 506 | 430 | 501 | 697 | 460 | 753 | 628 | 792 | 620 | 670 | 586 | 699 | 703 | 675 | 730 | 859 | 784 | 707 | CREATE VIEW |