NN | Test name | mode |
4.0.6.3215
|
4.0.6.3214
|
4.0.6.3213
|
4.0.6.3212
|
4.0.6.3208
|
4.0.6.3207
|
4.0.6.3206
|
4.0.6.3205
|
4.0.6.3204
|
4.0.6.3203
|
4.0.6.3200
|
4.0.6.3199
|
4.0.6.3198
|
4.0.6.3195
|
4.0.6.3195
|
4.0.6.3194
|
4.0.6.3194
|
4.0.6.3193
|
4.0.6.3192
|
4.0.6.3191
|
4.0.6.3190
|
4.0.6.3189
|
4.0.6.3188
|
4.0.6.3186
|
4.0.6.3185
|
4.0.6.3183
|
4.0.6.3181
|
4.0.6.3180
|
4.0.6.3179
|
4.0.6.3178
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | E | X | X | X | Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x |
|
2 | SS | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | E | X | X | X | Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x |
|
3 | CS | P | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list |
|
4 | SS | P | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list |
|
5 | CS | P | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list |
|
6 | SS | P | P | P | P | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list |
|
7 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DDL-Changes in replication does not set the correct grantor |
|
8 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Permission error with replication |
|
9 | SS | E | P | P | P | P | P | 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 ROLE |
|
10 | SS | E | P | P | P | P | P | 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 ROLE - try create role with same name |
|
11 | SS | E | P | P | P | P | P | 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 that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
|
12 | SS | E | P | P | P | P | P | 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 ability to make connect to FB services and add/drop user |
|
13 | SS | E | P | P | P | P | P | 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 results of ALTER SESSION RESET |
|
14 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: do NOT raise error if prepared 2PC transactions present |
|
15 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: clear contents of all used GTT ON COMMIT PRESERVE ROWS |
|
16 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: reset session and statement timeouts to zero |
|
17 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: DECFLOAT parameters must be returned to default values |
|
18 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection |
|
19 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace |
|
20 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: restore ROLE which was passed with DPB and clear all cached security classes (if role was changed) |
|
21 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: ROLLBACK current user transaction (if present) and issue warning if that transaction changes any table before reset |
|
22 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER SESSION RESET: START new transaction with the same properties as transaction that was rolled back (if transaction was present before reset) |
|
23 | SS | E | P | P | P | P | P | 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 |
|
24 | SS | E | P | P | P | P | P | 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 SHADOW: check basic usage |
|
25 | SS | E | P | P | P | P | P | 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 SHADOW: check usage with presense of 'FILE <...>' clause. |
|
26 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bug in RIGHT JOIN |
|
27 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | predicate 0 = -0 to incorrectly evaluate to FALSE. |
|
28 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong result of UNION DISTINCT |
|
29 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong result of AVG evaluation as result of SUM / COUNT |
|
30 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Failed to fetch a row from a view. |
|
31 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | GROUP BY ignores COLLATE with case insensitive attribute |
|
32 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unnexpectedly optimized VARIANCE(0) to FALSE |
|
33 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Non-deterministic output when using MAX() function |
|
34 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Conversion of character string to boolean value |
|
35 | SS | E | P | P | P | F | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Comparison of string and numeric literals |
|
36 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Incorrect result of LIKE. |
|
37 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unexpected null value when index is used |
|
38 | SS | E | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bugs Found in StoneDB by SQLancer |
|
39 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | NATURAL RIGHT JOIN results in an unexpected "Unknown column" error |
|
40 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Incorrect result when comparing a FLOAT/DOUBLE UNSIGNED with a negative number |
|
41 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | incorrect unresolved column when using natural join |
|
42 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Incorrect result for LEFT JOIN and CASE operator |
|
43 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | UNIQUE constraint on DECIMAL/floating-point columns causes incorrect result for NULL in AND |
|
44 | SS | E | P | P | P | P | P | 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 ability to query, modify and deleting data plus add/drop constraints on any table |
|
45 | SS | E | P | P | P | P | P | 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 ability to access to database in shutdown single mode as non-sysdba |
|
46 | SS | E | P | P | P | P | P | 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 ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges |
|
47 | SS | E | P | P | P | P | P | 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 ability to manage auth mappings |
|
48 | SS | E | P | P | P | P | P | 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 ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges |
|
49 | SS | E | P | P | P | P | P | 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 ability to CREATE database by non-sysdba user who is granted with necessary system privilege |
|
50 | SS | E | P | P | P | P | P | 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 ability of non-sysdba user to CREATE privileged role (but NOT use it) |
|
51 | SS | E | P | P | P | P | P | 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 ability to update content of RDB$TYPES |
|
52 | SS | E | P | P | P | P | P | 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 ability to DROP database by non-sysdba user who is granted with necessary system privileges |
|
53 | SS | E | P | P | P | P | P | 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 ability to grant right for issuing CREATE/ALTER/DROP statements |
|
54 | SS | E | P | P | P | P | P | 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 ability to query, modify and deleting data plus add/drop constraints on any table |
|
55 | SS | E | P | P | P | P | P | 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 ability of non-sysdba and non-owner to ignore DB triggers |
|
56 | SS | E | P | P | P | P | P | 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 ability to manage external connections pool |
|
57 | SS | E | P | P | P | P | P | 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 ability to monitor any attachment |
|
58 | SS | E | P | P | P | P | P | 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 ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege |
|
59 | SS | E | P | P | P | P | P | 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 ability to trace any attachment by non-sysdba user who is granted with necessary system privileges |
|
60 | SS | E | P | P | P | P | P | 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 ability to to make database backup |
|
61 | SS | E | P | P | P | P | P | 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 ability to query, modify and deleting data plus add/drop constraints on any table |
|
62 | SS | E | P | P | P | P | P | 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 ability to obtain database statistics |
|
63 | SS | E | P | P | P | P | P | 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 ability to use nbackup |
|
64 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted. |
|
65 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - ADD column |
|
66 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE. Add column with DEFAULT expression, NOT NULL requirement and UNIQUE constraint that must be applied to its values. |
|
67 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - ADD CONSTRAINT - PRIMARY KEY |
|
68 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - ADD CONSTRAINT - UNIQUE |
|
69 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - ALTER - TO |
|
70 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE. Alter type of some column. |
|
71 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE. Alter position of columns. |
|
72 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - DROP |
|
73 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - DROP (with data) |
|
74 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY |
|
75 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TABLE - DROP CONSTRAINT - UNIQUE |
|
76 | SS | E | P | P | P | P | P | 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 ability to create exactly 254 changes of format (increasing it by 1) after initial creating table |
|
77 | SS | E | P | P | P | P | P | 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 TABLE - types |
|
78 | SS | E | P | P | P | P | P | 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 TABLE - constraints |
|
79 | SS | E | P | P | P | P | P | 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 TABLE - create table with same name |
|
80 | SS | E | P | P | P | P | P | 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 TABLE - two column with same name |
|
81 | SS | E | P | P | P | P | P | 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 TABLE - unknown datatype (domain) |
|
82 | SS | E | P | P | P | P | P | 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 while retrieving from CTEs (or derived tables) with same column names |
|
83 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Check ability to reuse internal connection by EXECUTE STATEMENT. |
|
84 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | RemoteAuxPort is per-database |
|
85 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Fixed bug with index names patterns in online validation service |
|
86 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Result of CAST for numbers is implementation defined |
|
87 | SS | E | P | P | P | P | P | 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 of integer division on dialect 1. |
|
88 | SS | E | P | P | P | P | P | 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 of integer division on dialect 3. |
|
89 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Query for test MAX()OVER(). |
|
90 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it. |
|
91 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | crash on assert or memory corruption when too long username is used for authentication |
|
92 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Query for test multiple CTEs |
|
93 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Query for test SUM()OVER() and COUNT()OVER(). |
|
94 | SS | E | P | P | P | P | P | 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 |
|
95 | SS | E | P | P | P | P | P | 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 |
|
96 | SS | E | P | P | P | P | P | 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 |
|
97 | SS | E | P | P | P | P | P | 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 |
|
98 | SS | E | P | P | P | P | P | 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 |
|
99 | SS | E | P | P | P | P | P | 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 |
|
100 | SS | E | P | P | P | P | P | 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 |
|
101 | SS | E | P | P | P | P | P | 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 |
|
102 | SS | E | P | P | P | P | P | 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 |
|
103 | SS | E | P | P | P | P | P | 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 |
|
104 | SS | E | P | P | P | P | P | 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 |
|
105 | SS | E | P | P | P | P | P | 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 |
|
106 | SS | E | P | P | P | P | P | 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 |
|
107 | SS | E | P | P | P | P | P | 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 |
|
108 | SS | E | P | P | P | P | P | 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 |
|
109 | SS | E | P | P | P | P | P | 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 |
|
110 | SS | E | P | P | P | P | P | 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 sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege. |
|
111 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP TABLE fails if executing in ES and DML at the same execute block is performed in autonomous transaction |
|
112 | SS | E | P | P | P | P | P | 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 ability for preparing and then run query with parameters. Query should use ORDER-BY clause. |
|
113 | SS | E | P | P | P | P | P | 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 correctness of LEFT JOIN result when right source has two FK and one of fields from FK present both in ON and WHERE clauses. |
|
114 | SS | E | P | P | P | P | P | 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 correctness of LEFT JOIN result when left source is table with several -vs- single rows and right source is SP. |
|
115 | SS | E | P | P | P | P | P | 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(es) should not become corrupted after two updates and raising exception in one Tx, doing inside SP |
|
116 | SS | E | P | P | P | P | P | 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 results of CONTAINING when search pattern can span on one or several blob segments |
|
117 | SS | E | P | P | P | P | P | 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 ability to run complex query |
|
118 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW |
|
119 | SS | E | P | P | P | P | P | 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 ability to run selectable SP with input parameter which inserts into GTT (on commit DELETE rows) and then does suspend |
|
120 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Let include file name into error message when creation of temp file failed. |
|
121 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | WHERE-filter must be applied after FULL JOIN result |
|
122 | SS | E | P | P | P | P | P | 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-14 |
|
123 | SS | E | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | WHERE CURRENT OF <C> within block that has savepoint: statement #2 must see changes produced by statement #1 |
|
124 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Records with NULLs could be lost from resultset. |
|
125 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
126 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
127 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
128 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
129 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
130 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
131 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
132 | SS | E | P | P | P | P | P | 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 ability of outer join simplification. |
|
133 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Uncomment of one part of OR'ed expression led to loose of record from resultset. |
|
134 | SS | E | P | P | P | P | P | 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) |
|
135 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
|
136 | SS | E | P | P | P | P | P | 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 that optimizer takes in account presense of index and does navigation instead of external sort. |
|
137 | SS | E | P | P | P | P | P | 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 (empty) result of query in Oracle 19 |
|
138 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
|
139 | SS | E | P | P | P | P | P | 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 ability to compile query with combination of full and right join. Taken from PG bug library. |
|
140 | SS | E | P | P | P | P | P | 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/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
|
141 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | request of expression index could run outside of main request's snapshot. |
|
142 | SS | E | P | P | P | P | P | 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 |
|
143 | SS | E | P | P | P | P | P | 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 |
|
144 | SS | E | P | P | P | P | P | 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 |
|
145 | SS | E | P | P | P | P | P | 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. |
|
146 | SS | E | P | P | P | P | P | 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. |
|
147 | SS | E | P | P | P | P | P | 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. |
|
148 | SS | E | P | P | P | P | P | 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. |
|
149 | SS | E | P | P | P | P | P | 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. |
|
150 | SS | E | P | P | P | P | P | 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. |
|
151 | SS | E | P | P | P | P | P | 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. |
|
152 | SS | E | P | P | P | P | P | 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. |
|
153 | SS | E | P | P | P | P | P | 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. |
|
154 | SS | E | P | P | P | P | P | 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. |
|
155 | SS | E | P | P | P | P | P | 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. |
|
156 | SS | E | P | P | P | P | P | 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. |
|
157 | SS | E | P | P | P | P | P | 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. |
|
158 | SS | E | P | P | P | P | P | 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. |
|
159 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - ACTIVE |
|
160 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - INACTIVE |
|
161 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - BEFORE DELETE |
|
162 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - BEFORE INSERT |
|
163 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - BEFORE UPDATE |
|
164 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AFTER DELETE |
|
165 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AFTER INSERT |
|
166 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - POSITION |
|
167 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - POSITION |
|
168 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
169 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
170 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
171 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
172 | SS | E | P | P | P | P | P | 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 TRIGGER |
|
173 | SS | E | P | P | P | P | P | 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 TRIGGER AFTER INSERT |
|
174 | SS | E | P | P | P | P | P | 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 TRIGGER BEFORE UPDATE |
|
175 | SS | E | P | P | P | P | P | 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 TRIGGER AFTER UPDATE |
|
176 | SS | E | P | P | P | P | P | 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 TRIGGER BEFORE DELETE |
|
177 | SS | E | P | P | P | P | P | 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 TRIGGER AFTER DELETE |
|
178 | SS | E | P | P | P | P | P | 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 TRIGGER INACTIVE AFTER DELETE |
|
179 | SS | E | P | P | P | P | P | 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 TRIGGER AFTER DELETE POSITION 12 |
|
180 | SS | E | P | P | P | P | P | 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 TRIGGER BEFORE INSERT DECLARE VARIABLE |
|
181 | SS | E | P | P | P | P | P | 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 TRIGGER BEFORE INSERT DECLARE VARIABLE, block stataments |
|
182 | SS | E | P | P | P | P | P | 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 TRIGGER SQL2003 |
|
183 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on database connect. See also CORE-745 |
|
184 | SS | E | P | P | P | P | P | 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 handling in trigger on database connect |
|
185 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Multiple triggers on database connect |
|
186 | SS | E | P | P | P | P | P | 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 handling when multiple triggers on database connect exist |
|
187 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
|
188 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Multiple triggers on start transaction |
|
189 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on commit transaction. See also CORE-645 |
|
190 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on rollback transaction |
|
191 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Trigger on start tansaction |
|
192 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - ACTIVE |
|
193 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - INACTIVE |
|
194 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - BEFORE DELETE |
|
195 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - BEFORE INSERT |
|
196 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - BEFORE UPDATE |
|
197 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AFTER DELETE |
|
198 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER: attempt to use "new" in AFTER INSERT |
|
199 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - POSITION |
|
200 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - POSITION |
|
201 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
202 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
203 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
204 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | ALTER TRIGGER - AS |
|
205 | SS | E | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | gbak utility: check ability to use -ZIP command switch when create backup |
|
206 | SS | E | P | P | P | P | P | 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 |
|
207 | SS | E | P | P | P | P | P | 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 |
|
208 | SS | E | P | P | P | P | P | 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 - bad number of columns |
|
209 | SS | E | P | P | P | P | P | 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 - bad number of columns |
|
210 | SS | E | P | P | P | P | P | 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 |
|
211 | SS | E | P | P | P | P | P | 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 - updateable |
|
212 | SS | E | P | P | P | P | P | 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 - updateable WITH CHECK OPTION |
|
213 | SS | E | P | P | P | P | P | 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 - updateable WITH CHECK OPTION |
NN | Test name | mode | median_ms |
4.0.6.3215
|
4.0.6.3214
|
4.0.6.3213
|
4.0.6.3212
|
4.0.6.3208
|
4.0.6.3207
|
4.0.6.3206
|
4.0.6.3205
|
4.0.6.3204
|
4.0.6.3203
|
4.0.6.3200
|
4.0.6.3199
|
4.0.6.3198
|
4.0.6.3195
|
4.0.6.3195
|
4.0.6.3194
|
4.0.6.3194
|
4.0.6.3193
|
4.0.6.3192
|
4.0.6.3191
|
4.0.6.3190
|
4.0.6.3189
|
4.0.6.3188
|
4.0.6.3186
|
4.0.6.3185
|
4.0.6.3183
|
4.0.6.3181
|
4.0.6.3180
|
4.0.6.3179
|
4.0.6.3178
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1539 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1539 | 0 | 0 | 0 | Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x |
|
2 | SS | 1278 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1278 | 0 | 0 | 0 | Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x |
|
3 | CS | 1166 | 1167 | 1135 | 1248 | 1194 | 868 | 1237 | 1140 | 1234 | 1133 | 1130 | 1186 | 1133 | 1136 | 1110 | 1190 | 1178 | 1244 | 1246 | 1133 | 1242 | 1225 | 1184 | 1149 | 1214 | 1141 | 1159 | 1166 | 1134 | 1198 | 1149 | Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list |
|
4 | SS | 805 | 801 | 818 | 813 | 815 | 726 | 820 | 797 | 766 | 803 | 795 | 832 | 788 | 788 | 766 | 801 | 849 | 847 | 881 | 845 | 795 | 839 | 809 | 823 | 808 | 799 | 806 | 798 | 818 | 797 | 805 | Ability to run query: ( A LEFT JOIN B ) INER JOIN C, plus ORDER BY with fields not from SELECT list |
|
5 | CS | 1155 | 1186 | 1141 | 1258 | 1150 | 548 | 1211 | 1179 | 1125 | 1131 | 1182 | 1217 | 1134 | 1143 | 1109 | 1160 | 1185 | 1242 | 1206 | 1141 | 1183 | 1179 | 1140 | 1170 | 1151 | 1139 | 1137 | 1203 | 1136 | 1179 | 1149 | Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list |
|
6 | SS | 805 | 805 | 817 | 829 | 790 | 424 | 821 | 779 | 781 | 796 | 806 | 817 | 792 | 803 | 781 | 787 | 827 | 840 | 960 | 846 | 805 | 838 | 803 | 812 | 815 | 786 | 833 | 791 | 834 | 801 | 802 | Ability to run query: ( A LEFT JOIN B ) , C. Then add ORDER BY with fields not from SELECT list |
|
7 | SS | 6358 | 39195 | 7424 | 7474 | 6208 | 8215 | 6373 | 6227 | 6309 | 6415 | 6363 | 6270 | 6698 | 6400 | 6121 | 6220 | 6585 | 6557 | 6627 | 7380 | 6353 | 6642 | 6410 | 6209 | 6188 | 6295 | 6176 | 6333 | 6196 | 6161 | 6221 | DDL-Changes in replication does not set the correct grantor |
|
8 | SS | 15290 | 2510 | 14529 | 15305 | 15304 | 14513 | 15399 | 14334 | 14273 | 15286 | 15289 | 14307 | 15267 | 15344 | 15257 | 15291 | 15376 | 15623 | 15394 | 15291 | 15342 | 15354 | 15286 | 15292 | 14285 | 15293 | 14325 | 15406 | 15289 | 15277 | 15329 | Permission error with replication |
|
9 | SS | 411 | 2271 | 425 | 416 | 404 | 431 | 444 | 412 | 375 | 407 | 415 | 414 | 405 | 416 | 375 | 402 | 430 | 428 | 442 | 404 | 416 | 441 | 415 | 402 | 403 | 401 | 401 | 410 | 403 | 393 | 403 | CREATE ROLE |
|
10 | SS | 610 | 2503 | 643 | 622 | 604 | 647 | 671 | 601 | 593 | 629 | 611 | 617 | 603 | 602 | 594 | 601 | 658 | 663 | 672 | 604 | 628 | 671 | 605 | 604 | 607 | 609 | 621 | 611 | 609 | 608 | 602 | CREATE ROLE - try create role with same name |
|
11 | SS | 2951 | 2471 | 3025 | 2954 | 2953 | 2998 | 3027 | 2949 | 2914 | 2947 | 2952 | 2993 | 2943 | 2956 | 2897 | 2935 | 3002 | 2969 | 3055 | 2936 | 3001 | 3016 | 2953 | 2932 | 2927 | 2926 | 2950 | 2941 | 2946 | 2953 | 2929 | Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE] |
|
12 | SS | 565 | 2483 | 603 | 580 | 592 | 607 | 612 | 566 | 547 | 561 | 551 | 557 | 549 | 576 | 548 | 544 | 576 | 576 | 608 | 560 | 568 | 594 | 573 | 542 | 570 | 557 | 563 | 559 | 565 | 550 | 559 | Check ability to make connect to FB services and add/drop user |
|
13 | SS | 547 | 2269 | 580 | 546 | 536 | 571 | 600 | 543 | 516 | 534 | 555 | 536 | 555 | 551 | 515 | 532 | 591 | 568 | 601 | 542 | 564 | 586 | 555 | 539 | 545 | 546 | 558 | 540 | 548 | 536 | 543 | Test results of ALTER SESSION RESET |
|
14 | SS | 916 | 2469 | 993 | 923 | 916 | 976 | 950 | 916 | 891 | 894 | 899 | 921 | 915 | 935 | 875 | 906 | 958 | 970 | 991 | 901 | 973 | 979 | 921 | 910 | 908 | 898 | 912 | 917 | 919 | 894 | 912 | ALTER SESSION RESET: do NOT raise error if prepared 2PC transactions present |
|
15 | SS | 410 | 16204 | 438 | 429 | 408 | 423 | 442 | 394 | 390 | 409 | 398 | 395 | 406 | 407 | 391 | 413 | 453 | 424 | 442 | 400 | 425 | 443 | 420 | 399 | 403 | 402 | 404 | 411 | 408 | 411 | 431 | ALTER SESSION RESET: clear contents of all used GTT ON COMMIT PRESERVE ROWS |
|
16 | SS | 407 | 3251 | 425 | 422 | 408 | 415 | 427 | 392 | 375 | 405 | 397 | 402 | 395 | 408 | 375 | 390 | 410 | 417 | 427 | 407 | 417 | 438 | 411 | 393 | 409 | 387 | 394 | 388 | 393 | 395 | 408 | ALTER SESSION RESET: reset session and statement timeouts to zero |
|
17 | SS | 410 | 2656 | 428 | 430 | 434 | 427 | 433 | 406 | 391 | 412 | 401 | 394 | 410 | 408 | 390 | 405 | 415 | 425 | 456 | 404 | 418 | 450 | 422 | 408 | 404 | 401 | 407 | 410 | 404 | 407 | 416 | ALTER SESSION RESET: DECFLOAT parameters must be returned to default values |
|
18 | SS | 299 | 2889 | 322 | 331 | 299 | 317 | 328 | 296 | 297 | 320 | 291 | 295 | 296 | 297 | 297 | 294 | 314 | 313 | 338 | 299 | 315 | 354 | 312 | 297 | 299 | 301 | 295 | 299 | 303 | 293 | 296 | ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection |
|
19 | SS | 409 | 2518 | 426 | 405 | 406 | 418 | 432 | 400 | 375 | 393 | 414 | 410 | 416 | 412 | 375 | 409 | 446 | 419 | 447 | 401 | 424 | 445 | 399 | 393 | 434 | 415 | 398 | 393 | 405 | 401 | 396 | ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace |
|
20 | SS | 468 | 4951 | 505 | 472 | 463 | 508 | 520 | 472 | 453 | 454 | 469 | 468 | 475 | 463 | 438 | 455 | 483 | 476 | 511 | 459 | 482 | 498 | 469 | 455 | 467 | 454 | 454 | 464 | 468 | 478 | 457 | ALTER SESSION RESET: restore ROLE which was passed with DPB and clear all cached security classes (if role was changed) |
|
21 | SS | 409 | 6886 | 437 | 408 | 411 | 432 | 439 | 409 | 390 | 411 | 410 | 403 | 407 | 408 | 390 | 407 | 420 | 414 | 437 | 394 | 424 | 434 | 412 | 398 | 407 | 393 | 409 | 404 | 410 | 402 | 396 | ALTER SESSION RESET: ROLLBACK current user transaction (if present) and issue warning if that transaction changes any table before reset |
|
22 | SS | 410 | 2637 | 441 | 418 | 399 | 423 | 442 | 405 | 391 | 412 | 406 | 407 | 410 | 405 | 391 | 406 | 426 | 423 | 446 | 409 | 432 | 442 | 407 | 410 | 420 | 408 | 407 | 408 | 410 | 404 | 421 | ALTER SESSION RESET: START new transaction with the same properties as transaction that was rolled back (if transaction was present before reset) |
|
23 | SS | 27338 | 7830 | 27452 | 27340 | 27352 | 27381 | 27433 | 27331 | 27304 | 27336 | 27331 | 27346 | 27314 | 27325 | 27299 | 27343 | 27366 | 27389 | 27427 | 27330 | 27796 | 27368 | 27335 | 27324 | 27326 | 27317 | 27322 | 27326 | 27340 | 27341 | 27344 | External Connections Pool, functionality test 01 |
|
24 | SS | 413 | 24832 | 440 | 415 | 404 | 449 | 460 | 412 | 375 | 411 | 399 | 401 | 421 | 408 | 375 | 399 | 433 | 448 | 441 | 395 | 429 | 441 | 424 | 406 | 417 | 399 | 400 | 399 | 434 | 418 | 402 | CREATE SHADOW: check basic usage |
|
25 | SS | 410 | 15931 | 440 | 424 | 404 | 415 | 442 | 428 | 391 | 407 | 409 | 410 | 424 | 409 | 406 | 393 | 434 | 442 | 439 | 395 | 423 | 433 | 409 | 410 | 426 | 393 | 411 | 405 | 411 | 395 | 407 | CREATE SHADOW: check usage with presense of 'FILE <...>' clause. |
|
26 | SS | 428 | 3284 | 421 | 428 | 408 | 436 | 450 | 398 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bug in RIGHT JOIN |
|
27 | SS | 423 | 31524 | 437 | 405 | 410 | 423 | 447 | 407 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | predicate 0 = -0 to incorrectly evaluate to FALSE. |
|
28 | SS | 424 | 7747 | 425 | 422 | 415 | 424 | 431 | 415 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong result of UNION DISTINCT |
|
29 | SS | 422 | 10795 | 419 | 422 | 407 | 445 | 436 | 414 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong result of AVG evaluation as result of SUM / COUNT |
|
30 | SS | 431 | 11159 | 429 | 427 | 402 | 431 | 447 | 450 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Failed to fetch a row from a view. |
|
31 | SS | 446 | 11485 | 447 | 462 | 410 | 441 | 446 | 411 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | GROUP BY ignores COLLATE with case insensitive attribute |
|
32 | SS | 429 | 3096 | 433 | 423 | 403 | 429 | 440 | 405 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unnexpectedly optimized VARIANCE(0) to FALSE |
|
33 | SS | 425 | 2415 | 424 | 425 | 405 | 441 | 446 | 424 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Non-deterministic output when using MAX() function |
|
34 | SS | 432 | 2471 | 426 | 423 | 409 | 438 | 432 | 450 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Conversion of character string to boolean value |
|
35 | SS | 433 | 2456 | 440 | 417 | 406 | 434 | 433 | 424 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Comparison of string and numeric literals |
|
36 | SS | 432 | 2308 | 432 | 427 | 419 | 440 | 444 | 432 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Incorrect result of LIKE. |
|
37 | SS | 443 | 2460 | 448 | 443 | 426 | 441 | 467 | 422 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unexpected null value when index is used |
|
38 | SS | 460 | 2449 | 476 | 445 | 434 | 440 | 481 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bugs Found in StoneDB by SQLancer |
|
39 | SS | 428 | 2548 | 428 | 407 | 396 | 440 | 435 | 405 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NATURAL RIGHT JOIN results in an unexpected "Unknown column" error |
|
40 | SS | 426 | 2293 | 426 | 426 | 408 | 442 | 431 | 405 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Incorrect result when comparing a FLOAT/DOUBLE UNSIGNED with a negative number |
|
41 | SS | 426 | 2458 | 434 | 421 | 417 | 431 | 426 | 409 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | incorrect unresolved column when using natural join |
|
42 | SS | 429 | 2599 | 431 | 422 | 409 | 429 | 438 | 413 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Incorrect result for LEFT JOIN and CASE operator |
|
43 | SS | 424 | 3733 | 446 | 424 | 423 | 420 | 445 | 406 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | UNIQUE constraint on DECIMAL/floating-point columns causes incorrect result for NULL in AND |
|
44 | SS | 676 | 2318 | 706 | 698 | 675 | 723 | 717 | 670 | 656 | 669 | 673 | 669 | 675 | 671 | 656 | 685 | 719 | 734 | 725 | 669 | 717 | 723 | 674 | 666 | 683 | 689 | 679 | 673 | 668 | 668 | 678 | Check ability to query, modify and deleting data plus add/drop constraints on any table |
|
45 | SS | 1345 | 2473 | 1482 | 1381 | 1461 | 1450 | 1441 | 1338 | 1297 | 1343 | 1347 | 1327 | 1336 | 1329 | 1282 | 1344 | 1432 | 1499 | 1450 | 1323 | 1423 | 1456 | 1339 | 1341 | 1341 | 1361 | 1349 | 1352 | 1332 | 1344 | 1344 | Check ability to access to database in shutdown single mode as non-sysdba |
|
46 | SS | 1241 | 2437 | 1349 | 1271 | 1254 | 1312 | 1324 | 1241 | 1188 | 1242 | 1252 | 1240 | 1215 | 1241 | 1203 | 1206 | 1308 | 1389 | 1325 | 1235 | 1321 | 1353 | 1261 | 1224 | 1212 | 1206 | 1239 | 1277 | 1239 | 1225 | 1235 | Check ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges |
|
47 | SS | 759 | 2703 | 792 | 1663 | 783 | 802 | 821 | 762 | 749 | 756 | 743 | 748 | 753 | 759 | 719 | 750 | 796 | 863 | 801 | 747 | 796 | 813 | 796 | 755 | 751 | 739 | 748 | 764 | 758 | 746 | 759 | Check ability to manage auth mappings |
|
48 | SS | 2410 | 8865 | 2653 | 2414 | 2447 | 2633 | 2649 | 2409 | 2345 | 2395 | 2404 | 2377 | 2365 | 2390 | 2328 | 2383 | 2639 | 2739 | 2722 | 2388 | 2666 | 2681 | 2423 | 2394 | 2426 | 2385 | 2412 | 2446 | 2406 | 2404 | 2392 | Check ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges |
|
49 | SS | 1057 | 12780 | 1116 | 1082 | 1060 | 1154 | 1103 | 1026 | 999 | 1025 | 1025 | 1046 | 1023 | 1059 | 984 | 1021 | 1113 | 1119 | 1269 | 1021 | 1103 | 1133 | 1065 | 1030 | 1105 | 1031 | 1024 | 1075 | 1056 | 1038 | 1052 | Check ability to CREATE database by non-sysdba user who is granted with necessary system privilege |
|
50 | SS | 861 | 7152 | 925 | 871 | 840 | 977 | 928 | 844 | 860 | 863 | 865 | 860 | 832 | 880 | 828 | 858 | 923 | 906 | 925 | 842 | 904 | 917 | 854 | 852 | 886 | 844 | 851 | 857 | 911 | 855 | 840 | Check ability of non-sysdba user to CREATE privileged role (but NOT use it) |
|
51 | SS | 752 | 2358 | 808 | 761 | 739 | 814 | 804 | 746 | 734 | 755 | 749 | 757 | 734 | 748 | 719 | 750 | 793 | 801 | 789 | 738 | 790 | 832 | 747 | 747 | 795 | 734 | 749 | 755 | 791 | 741 | 741 | Check ability to update content of RDB$TYPES |
|
52 | SS | 1073 | 7578 | 1105 | 1101 | 1067 | 1167 | 1145 | 1056 | 1016 | 1036 | 1100 | 1065 | 1043 | 1070 | 1016 | 1036 | 1115 | 1158 | 1150 | 1052 | 1141 | 1143 | 1076 | 1056 | 1088 | 1060 | 1067 | 1065 | 1081 | 1118 | 1070 | Check ability to DROP database by non-sysdba user who is granted with necessary system privileges |
|
53 | SS | 1158 | 2441 | 1226 | 1172 | 1149 | 1269 | 1263 | 1161 | 1125 | 1146 | 1181 | 1153 | 1140 | 1149 | 1109 | 1157 | 1204 | 1228 | 1223 | 1154 | 1206 | 1226 | 1159 | 1141 | 1153 | 1149 | 1152 | 1141 | 1182 | 1145 | 1164 | Check ability to grant right for issuing CREATE/ALTER/DROP statements |
|
54 | SS | 1092 | 2499 | 1172 | 1135 | 1079 | 1135 | 1157 | 1071 | 1062 | 1074 | 1132 | 1091 | 1056 | 1091 | 1047 | 1063 | 1180 | 1167 | 1154 | 1070 | 1135 | 1261 | 1079 | 1070 | 1086 | 1110 | 1096 | 1098 | 1093 | 1083 | 1057 | Check ability to query, modify and deleting data plus add/drop constraints on any table |
|
55 | SS | 1712 | 2281 | 1862 | 1763 | 1717 | 1824 | 1848 | 1683 | 1641 | 1691 | 1754 | 1722 | 1691 | 1711 | 1641 | 1703 | 1804 | 1816 | 1765 | 1701 | 1812 | 1712 | 1710 | 1706 | 1694 | 1744 | 1719 | 1713 | 1692 | 1707 | 1704 | Check ability of non-sysdba and non-owner to ignore DB triggers |
|
56 | SS | 736 | 2475 | 770 | 735 | 738 | 775 | 1420 | 734 | 719 | 735 | 742 | 730 | 726 | 732 | 703 | 723 | 758 | 782 | 772 | 740 | 758 | 729 | 742 | 731 | 731 | 750 | 735 | 726 | 738 | 776 | 719 | Check ability to manage external connections pool |
|
57 | SS | 792 | 2571 | 834 | 811 | 806 | 833 | 880 | 775 | 765 | 781 | 825 | 793 | 791 | 779 | 765 | 769 | 839 | 836 | 877 | 800 | 831 | 792 | 781 | 785 | 807 | 811 | 786 | 786 | 776 | 789 | 786 | Check ability to monitor any attachment |
|
58 | SS | 1420 | 2689 | 1545 | 1449 | 1442 | 1532 | 1560 | 1423 | 1391 | 1412 | 1410 | 1432 | 1401 | 1411 | 1375 | 1415 | 1523 | 1499 | 1542 | 1479 | 1515 | 1411 | 1440 | 1408 | 1417 | 1403 | 1419 | 1404 | 1422 | 1406 | 1391 | Check ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege |
|
59 | SS | 3573 | 2493 | 3643 | 3617 | 3572 | 3959 | 3669 | 3579 | 3503 | 3548 | 3574 | 3736 | 3550 | 3609 | 3505 | 3546 | 3643 | 3658 | 3653 | 3594 | 3656 | 3546 | 3575 | 3548 | 3549 | 3537 | 3562 | 3831 | 3549 | 3540 | 3558 | Check ability to trace any attachment by non-sysdba user who is granted with necessary system privileges |
|
60 | SS | 1339 | 2293 | 1415 | 1368 | 1357 | 1428 | 1416 | 1331 | 1266 | 1360 | 1327 | 1326 | 1328 | 1378 | 1312 | 1335 | 1419 | 1427 | 1407 | 1344 | 1393 | 1351 | 1331 | 1324 | 1332 | 1324 | 1329 | 1321 | 1330 | 1340 | 1338 | Check ability to to make database backup |
|
61 | SS | 648 | 2507 | 701 | 662 | 648 | 671 | 689 | 643 | 609 | 645 | 641 | 649 | 640 | 690 | 610 | 684 | 684 | 682 | 712 | 636 | 683 | 637 | 646 | 660 | 647 | 628 | 668 | 638 | 633 | 641 | 653 | Check ability to query, modify and deleting data plus add/drop constraints on any table |
|
62 | SS | 1200 | 2512 | 1278 | 1219 | 1187 | 1299 | 1326 | 1187 | 1157 | 1207 | 1185 | 1202 | 1183 | 1190 | 1156 | 1184 | 1274 | 1281 | 1304 | 1204 | 1279 | 1199 | 1213 | 1181 | 1199 | 1187 | 1224 | 1187 | 1194 | 1190 | 1227 | Check ability to obtain database statistics |
|
63 | SS | 808 | 2295 | 864 | 829 | 805 | 846 | 855 | 799 | 797 | 789 | 797 | 802 | 783 | 799 | 781 | 796 | 850 | 871 | 865 | 836 | 1315 | 812 | 819 | 795 | 801 | 791 | 813 | 805 | 808 | 809 | 840 | Check ability to use nbackup |
|
64 | SS | 1759 | 2460 | 1994 | 1787 | 1773 | 1761 | 2009 | 1729 | 1687 | 1740 | 1801 | 1933 | 1776 | 1768 | 1672 | 1717 | 1776 | 1774 | 1803 | 1735 | 1724 | 1730 | 1741 | 1729 | 1739 | 1769 | 2118 | 1711 | 1757 | 1703 | 1750 | Self-secutity DB: system privilege USER_MANAGEMENT must allow only to add/alter/drop user. No access to any user tables must be granted. |
|
65 | SS | 423 | 2534 | 440 | 430 | 417 | 434 | 447 | 588 | 391 | 424 | 415 | 425 | 416 | 448 | 422 | 404 | 430 | 437 | 445 | 408 | 429 | 418 | 417 | 414 | 421 | 487 | 414 | 417 | 419 | 418 | 433 | ALTER TABLE - ADD column |
|
66 | SS | 565 | 2519 | 587 | 564 | 561 | 589 | 607 | 548 | 547 | 580 | 563 | 566 | 565 | 568 | 531 | 545 | 582 | 613 | 640 | 547 | 578 | 567 | 573 | 555 | 555 | 567 | 552 | 563 | 564 | 567 | 554 | ALTER TABLE. Add column with DEFAULT expression, NOT NULL requirement and UNIQUE constraint that must be applied to its values. |
|
67 | SS | 564 | 2261 | 595 | 569 | 566 | 585 | 599 | 565 | 531 | 562 | 548 | 570 | 567 | 561 | 547 | 547 | 582 | 582 | 586 | 553 | 563 | 564 | 571 | 569 | 562 | 552 | 566 | 562 | 563 | 563 | 560 | ALTER TABLE - ADD CONSTRAINT - PRIMARY KEY |
|
68 | SS | 562 | 2490 | 607 | 561 | 556 | 591 | 601 | 561 | 547 | 605 | 549 | 585 | 560 | 566 | 515 | 547 | 592 | 599 | 611 | 544 | 567 | 557 | 570 | 572 | 562 | 545 | 546 | 562 | 551 | 560 | 562 | ALTER TABLE - ADD CONSTRAINT - UNIQUE |
|
69 | SS | 562 | 2463 | 578 | 564 | 553 | 583 | 590 | 564 | 515 | 579 | 560 | 584 | 552 | 561 | 532 | 554 | 584 | 601 | 593 | 551 | 566 | 558 | 591 | 560 | 562 | 553 | 551 | 563 | 546 | 563 | 562 | ALTER TABLE - ALTER - TO |
|
70 | SS | 423 | 2278 | 442 | 443 | 446 | 446 | 458 | 420 | 407 | 423 | 407 | 428 | 425 | 423 | 406 | 423 | 431 | 457 | 461 | 409 | 422 | 422 | 424 | 417 | 422 | 406 | 405 | 420 | 423 | 412 | 424 | ALTER TABLE. Alter type of some column. |
|
71 | SS | 421 | 2446 | 427 | 420 | 423 | 447 | 456 | 404 | 390 | 424 | 406 | 420 | 425 | 424 | 390 | 405 | 451 | 445 | 446 | 411 | 425 | 418 | 421 | 415 | 422 | 414 | 407 | 405 | 413 | 427 | 421 | ALTER TABLE. Alter position of columns. |
|
72 | SS | 563 | 2466 | 588 | 567 | 563 | 597 | 604 | 545 | 532 | 554 | 564 | 591 | 566 | 563 | 532 | 553 | 608 | 601 | 597 | 552 | 556 | 562 | 569 | 553 | 564 | 610 | 561 | 561 | 563 | 560 | 563 | ALTER TABLE - DROP |
|
73 | SS | 564 | 2486 | 591 | 570 | 551 | 579 | 612 | 548 | 547 | 556 | 555 | 575 | 572 | 561 | 531 | 563 | 575 | 608 | 602 | 545 | 564 | 567 | 564 | 568 | 565 | 547 | 564 | 566 | 547 | 552 | 545 | ALTER TABLE - DROP (with data) |
|
74 | SS | 411 | 2267 | 428 | 419 | 415 | 430 | 441 | 413 | 390 | 417 | 402 | 416 | 409 | 408 | 391 | 420 | 426 | 447 | 432 | 410 | 405 | 456 | 429 | 408 | 405 | 397 | 409 | 400 | 404 | 408 | 406 | ALTER TABLE - DROP CONSTRAINT - PRIMARY KEY |
|
75 | SS | 411 | 2455 | 446 | 471 | 404 | 422 | 447 | 417 | 391 | 410 | 411 | 403 | 426 | 405 | 390 | 412 | 443 | 434 | 430 | 409 | 406 | 418 | 421 | 409 | 411 | 394 | 412 | 409 | 407 | 415 | 408 | ALTER TABLE - DROP CONSTRAINT - UNIQUE |
|
76 | SS | 1804 | 2465 | 1873 | 1983 | 2038 | 1790 | 1876 | 1738 | 1765 | 1995 | 1740 | 1738 | 1792 | 1898 | 1750 | 1733 | 1794 | 1835 | 1855 | 1796 | 1820 | 1776 | 1818 | 1792 | 1826 | 1782 | 1804 | 1805 | 1839 | 1784 | 1817 | Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table |
|
77 | SS | 578 | 2501 | 604 | 596 | 562 | 611 | 617 | 575 | 531 | 568 | 559 | 577 | 579 | 586 | 563 | 571 | 587 | 613 | 644 | 578 | 589 | 580 | 573 | 564 | 572 | 565 | 596 | 563 | 578 | 578 | 565 | CREATE TABLE - types |
|
78 | SS | 580 | 2265 | 601 | 596 | 572 | 609 | 606 | 566 | 531 | 572 | 571 | 571 | 573 | 581 | 531 | 576 | 603 | 605 | 618 | 584 | 597 | 589 | 606 | 579 | 582 | 576 | 604 | 577 | 573 | 577 | 569 | CREATE TABLE - constraints |
|
79 | SS | 564 | 2446 | 609 | 562 | 568 | 561 | 602 | 563 | 547 | 562 | 564 | 563 | 566 | 563 | 531 | 577 | 579 | 594 | 596 | 566 | 562 | 560 | 584 | 564 | 561 | 566 | 580 | 559 | 562 | 564 | 561 | CREATE TABLE - create table with same name |
|
80 | SS | 405 | 2463 | 429 | 412 | 423 | 417 | 444 | 402 | 375 | 402 | 396 | 390 | 396 | 408 | 375 | 393 | 439 | 435 | 438 | 394 | 412 | 406 | 415 | 393 | 409 | 402 | 401 | 404 | 390 | 389 | 413 | CREATE TABLE - two column with same name |
|
81 | SS | 408 | 2535 | 413 | 409 | 395 | 420 | 469 | 407 | 391 | 392 | 396 | 408 | 410 | 405 | 375 | 406 | 431 | 436 | 437 | 395 | 433 | 412 | 409 | 397 | 408 | 411 | 408 | 396 | 400 | 400 | 398 | CREATE TABLE - unknown datatype (domain) |
|
82 | SS | 405 | 2270 | 424 | 425 | 393 | 426 | 434 | 401 | 375 | 390 | 400 | 389 | 407 | 404 | 391 | 391 | 419 | 422 | 430 | 396 | 419 | 406 | 410 | 403 | 405 | 395 | 394 | 409 | 403 | 409 | 423 | Wrong data while retrieving from CTEs (or derived tables) with same column names |
|
83 | SS | 411 | 2479 | 417 | 412 | 391 | 434 | 428 | 401 | 390 | 396 | 422 | 411 | 410 | 430 | 406 | 390 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Check ability to reuse internal connection by EXECUTE STATEMENT. |
|
84 | SS | 333 | 2480 | 358 | 338 | 333 | 360 | 367 | 330 | 329 | 333 | 329 | 333 | 335 | 341 | 328 | 330 | 347 | 367 | 382 | 328 | 363 | 331 | 338 | 332 | 336 | 325 | 327 | 331 | 333 | 356 | 334 | RemoteAuxPort is per-database |
|
85 | SS | 716 | 2457 | 806 | 725 | 705 | 765 | 769 | 707 | 703 | 705 | 711 | 701 | 707 | 706 | 672 | 722 | 754 | 794 | 775 | 718 | 746 | 717 | 717 | 708 | 725 | 702 | 708 | 720 | 708 | 716 | 714 | Fixed bug with index names patterns in online validation service |
|
86 | SS | 405 | 2266 | 410 | 435 | 400 | 421 | 436 | 391 | 359 | 395 | 405 | 401 | 405 | 392 | 375 | 386 | 432 | 434 | 442 | 392 | 406 | 404 | 403 | 386 | 406 | 397 | 401 | 405 | 405 | 407 | 411 | Result of CAST for numbers is implementation defined |
|
87 | SS | 402 | 2439 | 448 | 419 | 389 | 432 | 434 | 387 | 391 | 393 | 401 | 404 | 395 | 412 | 391 | 396 | 422 | 429 | 426 | 394 | 420 | 405 | 408 | 400 | 392 | 394 | 393 | 391 | 408 | 408 | 399 | Check result of integer division on dialect 1. |
|
88 | SS | 400 | 2493 | 454 | 435 | 406 | 421 | 440 | 389 | 406 | 400 | 389 | 391 | 393 | 410 | 375 | 391 | 448 | 431 | 439 | 395 | 409 | 395 | 410 | 395 | 400 | 390 | 388 | 392 | 401 | 392 | 390 | Check result of integer division on dialect 3. |
|
89 | SS | 687 | 4158 | 760 | 721 | 686 | 698 | 790 | 676 | 641 | 683 | 680 | 670 | 680 | 674 | 656 | 715 | 700 | 716 | 721 | 695 | 715 | 677 | 683 | 701 | 694 | 679 | 687 | 670 | 687 | 711 | 676 | Query for test MAX()OVER(). |
|
90 | SS | 472 | 2507 | 559 | 490 | 462 | 478 | 471 | 468 | 437 | 454 | 458 | 467 | 475 | 472 | 453 | 465 | 521 | 500 | 501 | 490 | 480 | 484 | 477 | 470 | 463 | 470 | 468 | 475 | 473 | 470 | 472 | All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it. |
|
91 | SS | 245 | 2255 | 268 | 286 | 245 | 259 | 242 | 232 | 234 | 235 | 233 | 237 | 245 | 244 | 234 | 252 | 280 | 259 | 262 | 236 | 255 | 245 | 250 | 253 | 245 | 232 | 243 | 240 | 238 | 263 | 240 | crash on assert or memory corruption when too long username is used for authentication |
|
92 | SS | 1398 | 4379 | 1459 | 1521 | 1409 | 1457 | 1421 | 1388 | 1376 | 1382 | 1384 | 1406 | 1388 | 1398 | 1360 | 1453 | 1509 | 1434 | 1449 | 1383 | 1412 | 1395 | 1385 | 1494 | 1397 | 1398 | 1386 | 1390 | 1399 | 1426 | 1378 | Query for test multiple CTEs |
|
93 | SS | 725 | 4166 | 759 | 749 | 719 | 749 | 879 | 725 | 703 | 718 | 720 | 721 | 712 | 736 | 688 | 753 | 754 | 752 | 756 | 715 | 751 | 717 | 720 | 764 | 726 | 869 | 718 | 719 | 720 | 735 | 710 | Query for test SUM()OVER() and COUNT()OVER(). |
|
94 | SS | 832 | 4150 | 866 | 835 | 831 | 850 | 843 | 813 | 797 | 812 | 828 | 809 | 808 | 832 | 797 | 879 | 848 | 875 | 898 | 832 | 864 | 819 | 836 | 912 | 833 | 822 | 820 | 812 | 836 | 829 | 843 | Common SQL. Check correctness of the results |
|
95 | SS | 831 | 4209 | 884 | 840 | 858 | 867 | 830 | 1246 | 781 | 824 | 817 | 842 | 821 | 818 | 781 | 819 | 855 | 875 | 995 | 844 | 836 | 837 | 832 | 851 | 818 | 824 | 826 | 825 | 830 | 819 | 818 | Common SQL. Check correctness of the results |
|
96 | SS | 836 | 4171 | 860 | 839 | 824 | 850 | 833 | 836 | 797 | 824 | 838 | 831 | 822 | 829 | 797 | 816 | 845 | 884 | 888 | 850 | 846 | 836 | 844 | 834 | 824 | 809 | 838 | 837 | 837 | 826 | 838 | Common SQL. Check correctness of the results |
|
97 | SS | 830 | 4218 | 876 | 846 | 818 | 848 | 832 | 813 | 797 | 811 | 812 | 823 | 820 | 845 | 797 | 805 | 856 | 866 | 867 | 862 | 858 | 828 | 820 | 836 | 828 | 815 | 841 | 815 | 850 | 835 | 827 | Common SQL. Check correctness of the results |
|
98 | SS | 830 | 4352 | 878 | 840 | 849 | 858 | 880 | 840 | 797 | 840 | 806 | 818 | 827 | 816 | 796 | 815 | 827 | 855 | 888 | 855 | 860 | 830 | 850 | 821 | 816 | 813 | 830 | 816 | 844 | 809 | 815 | Common SQL. Check correctness of the results |
|
99 | SS | 832 | 4132 | 882 | 842 | 832 | 878 | 830 | 833 | 797 | 829 | 820 | 825 | 820 | 834 | 797 | 827 | 852 | 858 | 886 | 830 | 854 | 839 | 827 | 836 | 832 | 822 | 814 | 832 | 834 | 818 | 819 | Common SQL. Check correctness of the results |
|
100 | SS | 832 | 4144 | 873 | 833 | 811 | 862 | 818 | 816 | 781 | 817 | 815 | 814 | 825 | 817 | 782 | 805 | 864 | 844 | 881 | 840 | 838 | 840 | 845 | 836 | 832 | 821 | 838 | 816 | 839 | 832 | 815 | Common SQL. Check correctness of the results |
|
101 | SS | 837 | 4149 | 882 | 1013 | 838 | 852 | 921 | 804 | 797 | 850 | 813 | 816 | 819 | 819 | 796 | 828 | 867 | 1162 | 881 | 841 | 850 | 830 | 838 | 838 | 835 | 813 | 1016 | 812 | 837 | 822 | 820 | Common SQL. Check correctness of the results |
|
102 | SS | 934 | 4147 | 986 | 1432 | 947 | 990 | 985 | 927 | 890 | 925 | 912 | 934 | 913 | 936 | 891 | 922 | 982 | 966 | 993 | 956 | 942 | 930 | 940 | 929 | 928 | 929 | 927 | 935 | 941 | 922 | 930 | Common SQL. Check correctness of the results |
|
103 | SS | 678 | 4150 | 707 | 674 | 665 | 707 | 696 | 967 | 641 | 662 | 684 | 668 | 672 | 686 | 640 | 671 | 699 | 925 | 713 | 680 | 710 | 670 | 703 | 669 | 689 | 675 | 672 | 679 | 677 | 671 | 676 | Common SQL. Check correctness of the results |
|
104 | SS | 724 | 4134 | 754 | 724 | 708 | 732 | 789 | 701 | 687 | 721 | 709 | 707 | 726 | 725 | 672 | 719 | 750 | 753 | 744 | 706 | 737 | 724 | 729 | 724 | 736 | 719 | 716 | 707 | 725 | 711 | 713 | Common SQL. Check correctness of the results |
|
105 | SS | 850 | 4346 | 893 | 871 | 879 | 883 | 946 | 841 | 797 | 850 | 833 | 833 | 850 | 842 | 797 | 828 | 861 | 899 | 907 | 870 | 855 | 839 | 845 | 853 | 866 | 837 | 837 | 838 | 844 | 849 | 850 | Common SQL. Check correctness of the results |
|
106 | SS | 803 | 4182 | 832 | 813 | 805 | 856 | 838 | 799 | 782 | 798 | 783 | 791 | 788 | 796 | 781 | 787 | 826 | 861 | 867 | 801 | 836 | 816 | 822 | 793 | 818 | 798 | 799 | 811 | 789 | 807 | 798 | Common SQL. Check correctness of the results |
|
107 | SS | 729 | 4149 | 772 | 743 | 724 | 747 | 729 | 709 | 703 | 726 | 729 | 721 | 713 | 731 | 688 | 722 | 741 | 778 | 771 | 736 | 772 | 733 | 716 | 736 | 728 | 722 | 738 | 727 | 736 | 719 | 727 | Common SQL. Check correctness of the results |
|
108 | SS | 1008 | 4146 | 1049 | 1033 | 1000 | 1038 | 1038 | 1013 | 953 | 1011 | 999 | 993 | 988 | 1004 | 953 | 988 | 1014 | 1036 | 1080 | 996 | 1079 | 1013 | 1072 | 1036 | 1011 | 1002 | 1005 | 1003 | 983 | 985 | 994 | Common SQL. Check correctness of the results |
|
109 | SS | 726 | 4171 | 752 | 729 | 730 | 736 | 717 | 721 | 703 | 704 | 720 | 731 | 722 | 716 | 703 | 714 | 744 | 758 | 757 | 723 | 789 | 735 | 723 | 730 | 759 | 723 | 716 | 731 | 731 | 723 | 708 | Common SQL. Check correctness of the results |
|
110 | SS | 927 | 2435 | 974 | 1059 | 922 | 994 | 930 | 924 | 906 | 915 | 934 | 917 | 916 | 935 | 891 | 919 | 986 | 984 | 996 | 927 | 993 | 927 | 927 | 922 | 924 | 915 | 929 | 937 | 923 | 914 | 924 | Verify sufficiency of privileges for performing DML actions. Verify that RETURNING clause can not be used without SELECT privilege. |
|
111 | SS | 409 | 2437 | 438 | 421 | 404 | 427 | 425 | 404 | 390 | 407 | 401 | 420 | 408 | 411 | 390 | 409 | 428 | 432 | 445 | 403 | 449 | 416 | 406 | 408 | 421 | 401 | 409 | 409 | 403 | 410 | 407 | DROP TABLE fails if executing in ES and DML at the same execute block is performed in autonomous transaction |
|
112 | SS | 899 | 2260 | 926 | 907 | 904 | 911 | 912 | 914 | 860 | 873 | 872 | 863 | 882 | 889 | 860 | 871 | 904 | 950 | 933 | 872 | 950 | 994 | 909 | 936 | 917 | 893 | 895 | 881 | 886 | 888 | 892 | Check ability for preparing and then run query with parameters. Query should use ORDER-BY clause. |
|
113 | SS | 422 | 2406 | 440 | 427 | 422 | 430 | 422 | 426 | 390 | 403 | 420 | 422 | 423 | 415 | 406 | 414 | 428 | 450 | 449 | 432 | 443 | 437 | 427 | 420 | 435 | 419 | 427 | 421 | 419 | 419 | 422 | Check correctness of LEFT JOIN result when right source has two FK and one of fields from FK present both in ON and WHERE clauses. |
|
114 | SS | 412 | 2412 | 427 | 420 | 404 | 421 | 407 | 415 | 391 | 404 | 406 | 407 | 409 | 405 | 375 | 409 | 416 | 441 | 432 | 410 | 417 | 426 | 434 | 404 | 421 | 414 | 412 | 409 | 411 | 412 | 415 | Check correctness of LEFT JOIN result when left source is table with several -vs- single rows and right source is SP. |
|
115 | SS | 422 | 2435 | 441 | 423 | 418 | 435 | 425 | 432 | 422 | 411 | 425 | 408 | 429 | 428 | 406 | 412 | 448 | 446 | 452 | 420 | 437 | 421 | 432 | 422 | 418 | 416 | 419 | 422 | 410 | 424 | 408 | Index(es) should not become corrupted after two updates and raising exception in one Tx, doing inside SP |
|
116 | SS | 419 | 2459 | 440 | 422 | 404 | 449 | 417 | 437 | 391 | 413 | 408 | 406 | 420 | 422 | 391 | 419 | 432 | 461 | 444 | 415 | 437 | 440 | 427 | 402 | 423 | 408 | 432 | 409 | 410 | 419 | 410 | Check results of CONTAINING when search pattern can span on one or several blob segments |
|
117 | SS | 1277 | 2255 | 1331 | 1279 | 1287 | 1291 | 1286 | 1356 | 1218 | 1247 | 1230 | 1254 | 1248 | 1261 | 1219 | 1265 | 1278 | 1305 | 1311 | 1247 | 1281 | 1324 | 1275 | 1258 | 1286 | 1277 | 1323 | 1249 | 1278 | 1264 | 1252 | Check ability to run complex query |
|
118 | SS | 932 | 4200 | 967 | 952 | 927 | 959 | 924 | 933 | 875 | 924 | 923 | 926 | 934 | 911 | 859 | 918 | 956 | 953 | 1007 | 936 | 958 | 959 | 935 | 940 | 922 | 913 | 933 | 932 | 924 | 923 | 931 | Checking PK index is used when table is joined as driven (right) source in LEFT OUTER join from VIEW |
|
119 | SS | 414 | 2443 | 434 | 421 | 407 | 443 | 432 | 439 | 391 | 409 | 415 | 413 | 412 | 404 | 391 | 398 | 432 | 462 | 461 | 404 | 429 | 404 | 857 | 403 | 425 | 418 | 896 | 409 | 410 | 410 | 408 | Check ability to run selectable SP with input parameter which inserts into GTT (on commit DELETE rows) and then does suspend |
|
120 | SS | 445 | 2469 | 465 | 473 | 439 | 467 | 483 | 442 | 438 | 444 | 425 | 445 | 468 | 447 | 437 | 432 | 463 | 488 | 480 | 430 | 482 | 445 | 452 | 443 | 444 | 521 | 446 | 438 | 445 | 446 | 445 | Let include file name into error message when creation of temp file failed. |
|
121 | SS | 408 | 2242 | 428 | 405 | 398 | 424 | 402 | 404 | 390 | 418 | 403 | 414 | 407 | 417 | 375 | 401 | 431 | 442 | 446 | 409 | 420 | 418 | 420 | 400 | 417 | 402 | 400 | 401 | 406 | 422 | 405 | WHERE-filter must be applied after FULL JOIN result |
|
122 | SS | 671 | 4330 | 696 | 662 | 682 | 679 | 676 | 669 | 625 | 679 | 663 | 680 | 674 | 658 | 625 | 665 | 675 | 736 | 705 | 663 | 685 | 670 | 658 | 674 | 661 | 660 | 659 | 658 | 679 | 673 | 656 | gtcs-proc-isql-14 |
|
123 | SS | 424 | 2243 | 438 | 424 | 416 | 425 | 413 | 404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | WHERE CURRENT OF <C> within block that has savepoint: statement #2 must see changes produced by statement #1 |
|
124 | SS | 411 | 2422 | 426 | 423 | 420 | 422 | 405 | 407 | 406 | 407 | 408 | 412 | 423 | 405 | 391 | 407 | 428 | 457 | 443 | 410 | 422 | 428 | 413 | 405 | 425 | 406 | 405 | 413 | 403 | 405 | 409 | Records with NULLs could be lost from resultset. |
|
125 | SS | 811 | 4154 | 852 | 819 | 848 | 858 | 833 | 788 | 766 | 786 | 800 | 798 | 851 | 800 | 781 | 790 | 816 | 868 | 842 | 812 | 823 | 806 | 817 | 818 | 810 | 816 | 800 | 797 | 808 | 800 | 799 | Check ability of outer join simplification. |
|
126 | SS | 816 | 4154 | 871 | 814 | 841 | 835 | 812 | 805 | 797 | 800 | 802 | 801 | 845 | 823 | 766 | 801 | 841 | 892 | 857 | 824 | 825 | 816 | 819 | 816 | 816 | 783 | 820 | 815 | 809 | 801 | 798 | Check ability of outer join simplification. |
|
127 | SS | 811 | 4332 | 847 | 799 | 926 | 832 | 816 | 822 | 766 | 817 | 801 | 802 | 791 | 802 | 781 | 789 | 834 | 927 | 863 | 801 | 829 | 805 | 817 | 809 | 816 | 791 | 822 | 801 | 814 | 800 | 803 | Check ability of outer join simplification. |
|
128 | SS | 804 | 4141 | 826 | 836 | 865 | 834 | 818 | 806 | 765 | 815 | 788 | 782 | 798 | 803 | 766 | 787 | 805 | 844 | 855 | 855 | 838 | 803 | 863 | 822 | 801 | 788 | 800 | 799 | 801 | 795 | 800 | Check ability of outer join simplification. |
|
129 | SS | 811 | 4156 | 850 | 816 | 824 | 837 | 842 | 808 | 781 | 798 | 799 | 816 | 799 | 803 | 765 | 797 | 822 | 828 | 867 | 823 | 833 | 812 | 851 | 815 | 809 | 787 | 803 | 806 | 804 | 807 | 810 | Check ability of outer join simplification. |
|
130 | SS | 805 | 4163 | 835 | 805 | 892 | 870 | 803 | 784 | 766 | 816 | 803 | 787 | 798 | 803 | 766 | 789 | 827 | 851 | 863 | 823 | 838 | 818 | 881 | 822 | 798 | 804 | 806 | 845 | 800 | 790 | 798 | Check ability of outer join simplification. |
|
131 | SS | 893 | 4138 | 898 | 931 | 928 | 1061 | 871 | 832 | 984 | 894 | 847 | 859 | 915 | 842 | 843 | 912 | 893 | 918 | 1140 | 867 | 914 | 902 | 921 | 856 | 881 | 873 | 831 | 913 | 866 | 868 | 847 | Check ability of outer join simplification. |
|
132 | SS | 884 | 4160 | 971 | 881 | 868 | 929 | 911 | 870 | 844 | 872 | 896 | 858 | 1008 | 852 | 891 | 863 | 971 | 958 | 1060 | 893 | 850 | 877 | 974 | 890 | 859 | 884 | 862 | 951 | 884 | 859 | 878 | Check ability of outer join simplification. |
|
133 | SS | 408 | 2431 | 417 | 411 | 411 | 438 | 403 | 403 | 391 | 390 | 396 | 406 | 399 | 393 | 375 | 409 | 414 | 430 | 436 | 394 | 428 | 409 | 429 | 408 | 424 | 392 | 392 | 409 | 405 | 399 | 410 | Uncomment of one part of OR'ed expression led to loose of record from resultset. |
|
134 | SS | 575 | 2423 | 602 | 582 | 574 | 626 | 568 | 559 | 531 | 568 | 564 | 560 | 565 | 579 | 531 | 560 | 602 | 603 | 637 | 565 | 588 | 577 | 588 | 576 | 606 | 581 | 559 | 592 | 575 | 561 | 567 | Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction) |
|
135 | SS | 1320 | 2458 | 1334 | 1305 | 1303 | 2142 | 1325 | 1289 | 1281 | 1298 | 1298 | 1304 | 1280 | 1301 | 1266 | 1520 | 1330 | 1370 | 1495 | 1335 | 1328 | 1315 | 1328 | 1313 | 1473 | 1357 | 1316 | 1378 | 1386 | 1305 | 1314 | Compiler check. Test ability to compile source code of OLTP-EMUL test. |
|
136 | SS | 947 | 2266 | 972 | 952 | 970 | 974 | 947 | 922 | 891 | 927 | 938 | 929 | 935 | 941 | 906 | 940 | 940 | 1159 | 1004 | 940 | 949 | 947 | 973 | 928 | 1030 | 1159 | 952 | 948 | 991 | 959 | 939 | Check that optimizer takes in account presense of index and does navigation instead of external sort. |
|
137 | SS | 411 | 2433 | 434 | 421 | 417 | 438 | 426 | 413 | 390 | 418 | 399 | 403 | 406 | 405 | 375 | 405 | 423 | 683 | 459 | 416 | 414 | 403 | 409 | 396 | 443 | 407 | 407 | 407 | 422 | 404 | 403 | Wrong (empty) result of query in Oracle 19 |
|
138 | SS | 404 | 2468 | 438 | 411 | 402 | 437 | 406 | 401 | 391 | 407 | 394 | 395 | 397 | 407 | 376 | 388 | 415 | 294 | 456 | 392 | 410 | 406 | 410 | 392 | 416 | 394 | 407 | 399 | 410 | 391 | 393 | Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!) |
|
139 | SS | 411 | 2245 | 432 | 411 | 409 | 426 | 404 | 408 | 391 | 393 | 409 | 410 | 412 | 412 | 390 | 413 | 415 | 425 | 437 | 405 | 412 | 424 | 411 | 410 | 410 | 397 | 411 | 430 | 411 | 407 | 411 | Check ability to compile query with combination of full and right join. Taken from PG bug library. |
|
140 | SS | 417 | 2408 | 431 | 418 | 407 | 449 | 423 | 404 | 406 | 404 | 429 | 417 | 424 | 423 | 390 | 403 | 431 | 429 | 447 | 408 | 439 | 408 | 417 | 421 | 421 | 406 | 405 | 403 | 407 | 403 | 420 | UPDATE/DETERE RETURNING should issue only one row when applying to table with self-referencing FK |
|
141 | SS | 419 | 2421 | 448 | 434 | 404 | 435 | 428 | 402 | 391 | 404 | 435 | 408 | 408 | 430 | 391 | 411 | 433 | 439 | 453 | 407 | 433 | 422 | 419 | 405 | 420 | 407 | 405 | 407 | 422 | 421 | 405 | request of expression index could run outside of main request's snapshot. |
|
142 | SS | 810 | 4165 | 836 | 809 | 814 | 855 | 813 | 799 | 750 | 802 | 841 | 792 | 792 | 800 | 766 | 799 | 833 | 825 | 843 | 793 | 828 | 795 | 826 | 804 | 817 | 801 | 814 | 797 | 819 | 812 | 801 | Common SQL. Check correctness of the results |
|
143 | SS | 5942 | 2434 | 6057 | 5924 | 5942 | 6430 | 5892 | 5874 | 5803 | 5903 | 5956 | 5921 | 5943 | 5917 | 5848 | 5955 | 6325 | 5966 | 6003 | 5942 | 5943 | 5941 | 5951 | 6573 | 5953 | 5974 | 5939 | 5905 | 5944 | 5922 | 5917 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
144 | SS | 5882 | 2447 | 6068 | 5874 | 5891 | 5893 | 5845 | 5889 | 5787 | 5854 | 5872 | 5882 | 5893 | 5967 | 5756 | 5854 | 5927 | 5904 | 6206 | 5991 | 5882 | 5862 | 5873 | 5895 | 5892 | 5868 | 5879 | 5872 | 5888 | 5852 | 5892 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02 |
|
145 | SS | 5956 | 2236 | 6066 | 5927 | 5875 | 5981 | 5915 | 5902 | 5811 | 5963 | 5925 | 5981 | 5957 | 5938 | 5856 | 5947 | 5984 | 5994 | 6018 | 5952 | 5992 | 5979 | 5963 | 5953 | 5953 | 5988 | 5986 | 5955 | 5982 | 5936 | 6028 | READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart. |
|
146 | SS | 41856 | 2421 | 42780 | 41396 | 41549 | 42917 | 41691 | 41645 | 40397 | 41229 | 41737 | 41738 | 41858 | 41713 | 41042 | 41986 | 42005 | 42861 | 42731 | 41933 | 43265 | 41854 | 41966 | 42007 | 41694 | 42004 | 41750 | 41996 | 41941 | 42192 | 41762 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
147 | SS | 5907 | 2433 | 5922 | 6906 | 5881 | 5937 | 5917 | 5839 | 5773 | 5858 | 5910 | 5890 | 5903 | 5907 | 5803 | 5890 | 5938 | 6120 | 6455 | 5921 | 6333 | 5902 | 5890 | 5901 | 5956 | 5891 | 5907 | 5917 | 5943 | 5891 | 5913 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01. |
|
148 | SS | 5914 | 2256 | 6425 | 6883 | 5881 | 5905 | 5882 | 5915 | 5772 | 6206 | 5946 | 5896 | 5908 | 5913 | 5802 | 5918 | 6275 | 5801 | 5950 | 5943 | 6431 | 5889 | 5920 | 5927 | 5928 | 5981 | 5914 | 5905 | 5914 | 5901 | 5934 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02. |
|
149 | SS | 6230 | 2434 | 6232 | 6235 | 6185 | 6511 | 6524 | 6219 | 6040 | 6104 | 6236 | 6210 | 6233 | 6243 | 6101 | 6211 | 6347 | 6668 | 6258 | 6245 | 6236 | 6238 | 6241 | 6224 | 6228 | 6541 | 6211 | 6229 | 6229 | 6209 | 6228 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03. |
|
150 | SS | 5902 | 2428 | 5871 | 5897 | 5865 | 5922 | 5879 | 5891 | 5776 | 5866 | 5898 | 5940 | 5896 | 5895 | 5800 | 6016 | 6033 | 5926 | 5942 | 5914 | 6085 | 5899 | 5914 | 5938 | 5923 | 5889 | 5905 | 5917 | 5923 | 5900 | 5965 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
151 | SS | 5886 | 2439 | 5919 | 5876 | 5873 | 5933 | 5877 | 5885 | 5756 | 5965 | 5854 | 5921 | 5894 | 5868 | 5785 | 5874 | 5902 | 5949 | 5967 | 5874 | 5945 | 5891 | 6188 | 5858 | 5866 | 6159 | 6891 | 5869 | 5935 | 5887 | 5883 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01. |
|
152 | SS | 5914 | 2257 | 6150 | 6285 | 5892 | 6248 | 5911 | 5908 | 5786 | 5866 | 5887 | 5872 | 5936 | 5943 | 5816 | 5936 | 5992 | 5990 | 6429 | 5932 | 6428 | 5924 | 5909 | 5970 | 5908 | 5895 | 5924 | 5910 | 5913 | 5916 | 5901 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02. |
|
153 | SS | 6231 | 2427 | 6251 | 6235 | 6180 | 6385 | 6283 | 6207 | 6071 | 6206 | 6186 | 6208 | 6244 | 6234 | 6099 | 6235 | 6235 | 6255 | 6345 | 6290 | 6246 | 6196 | 6231 | 6273 | 6228 | 6226 | 6231 | 6205 | 6214 | 6243 | 6190 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03. |
|
154 | SS | 5910 | 2434 | 5915 | 6272 | 5911 | 6031 | 5906 | 6148 | 5772 | 5868 | 5907 | 5899 | 5898 | 5919 | 5790 | 5893 | 5945 | 6132 | 6056 | 5905 | 5983 | 5896 | 5911 | 5920 | 5927 | 5890 | 5893 | 6295 | 5927 | 5910 | 5909 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
155 | SS | 5903 | 2228 | 5924 | 5894 | 5896 | 6284 | 5878 | 5891 | 5768 | 6898 | 5886 | 5898 | 5893 | 5881 | 5790 | 6158 | 5925 | 5943 | 5987 | 5882 | 5908 | 5943 | 6250 | 5895 | 5909 | 5906 | 6912 | 5900 | 5917 | 5886 | 5906 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01. |
|
156 | SS | 5917 | 2426 | 5909 | 5916 | 5896 | 5980 | 5895 | 5955 | 5802 | 5905 | 6016 | 5910 | 5937 | 5901 | 5831 | 5792 | 5947 | 6038 | 6491 | 5937 | 7109 | 5913 | 5932 | 5957 | 5918 | 5926 | 5954 | 5925 | 5917 | 5911 | 5903 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
157 | SS | 6889 | 2444 | 6251 | 7051 | 7032 | 5962 | 7202 | 5910 | 6801 | 7237 | 6932 | 6953 | 6996 | 6957 | 6846 | 5944 | 7007 | 7019 | 6250 | 6937 | 6999 | 6959 | 5986 | 6191 | 6209 | 6190 | 6982 | 5971 | 6966 | 6196 | 5926 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03. |
|
158 | SS | 5920 | 2239 | 6599 | 6907 | 5883 | 5946 | 5869 | 5872 | 5787 | 5883 | 5927 | 5937 | 5895 | 5933 | 5804 | 6031 | 5913 | 5955 | 5958 | 6201 | 5921 | 5887 | 5921 | 5917 | 5970 | 5891 | 5901 | 5919 | 5959 | 5905 | 5929 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
159 | SS | 571 | 2421 | 592 | 588 | 570 | 581 | 575 | 743 | 516 | 562 | 581 | 553 | 564 | 573 | 516 | 577 | 605 | 610 | 599 | 572 | 588 | 564 | 574 | 567 | 561 | 571 | 558 | 557 | 564 | 564 | 563 | ALTER TRIGGER - ACTIVE |
|
160 | SS | 566 | 2427 | 610 | 584 | 595 | 604 | 566 | 561 | 546 | 562 | 598 | 562 | 566 | 566 | 515 | 561 | 583 | 599 | 600 | 567 | 592 | 561 | 563 | 560 | 566 | 584 | 568 | 566 | 563 | 574 | 560 | ALTER TRIGGER - INACTIVE |
|
161 | SS | 570 | 2438 | 608 | 572 | 564 | 594 | 557 | 562 | 516 | 546 | 580 | 571 | 571 | 578 | 516 | 566 | 582 | 604 | 606 | 546 | 581 | 579 | 569 | 552 | 560 | 571 | 566 | 574 | 565 | 569 | 569 | ALTER TRIGGER - BEFORE DELETE |
|
162 | SS | 566 | 2241 | 601 | 566 | 560 | 571 | 567 | 562 | 531 | 567 | 587 | 554 | 566 | 559 | 531 | 567 | 607 | 597 | 606 | 593 | 578 | 564 | 584 | 566 | 565 | 575 | 563 | 566 | 568 | 563 | 564 | ALTER TRIGGER - BEFORE INSERT |
|
163 | SS | 567 | 2414 | 610 | 582 | 557 | 577 | 564 | 563 | 532 | 569 | 576 | 560 | 571 | 565 | 531 | 566 | 592 | 603 | 607 | 589 | 574 | 567 | 561 | 572 | 567 | 577 | 561 | 561 | 564 | 568 | 565 | ALTER TRIGGER - BEFORE UPDATE |
|
164 | SS | 565 | 2445 | 579 | 582 | 570 | 599 | 567 | 565 | 531 | 560 | 570 | 564 | 559 | 570 | 531 | 563 | 597 | 611 | 610 | 597 | 562 | 564 | 566 | 565 | 560 | 575 | 563 | 559 | 558 | 567 | 560 | ALTER TRIGGER - AFTER DELETE |
|
165 | SS | 562 | 2457 | 598 | 583 | 562 | 587 | 560 | 549 | 547 | 551 | 566 | 563 | 555 | 561 | 516 | 561 | 603 | 600 | 602 | 578 | 584 | 663 | 562 | 565 | 561 | 580 | 561 | 546 | 555 | 559 | 552 | ALTER TRIGGER - AFTER INSERT |
|
166 | SS | 568 | 2461 | 571 | 583 | 574 | 583 | 565 | 565 | 531 | 568 | 562 | 566 | 570 | 569 | 531 | 564 | 605 | 587 | 597 | 581 | 592 | 577 | 577 | 562 | 563 | 570 | 565 | 562 | 561 | 561 | 551 | ALTER TRIGGER - POSITION |
|
167 | SS | 569 | 2248 | 602 | 585 | 569 | 577 | 569 | 559 | 531 | 569 | 570 | 571 | 562 | 563 | 531 | 557 | 585 | 605 | 594 | 571 | 589 | 568 | 564 | 570 | 581 | 565 | 574 | 562 | 566 | 562 | 568 | ALTER TRIGGER - POSITION |
|
168 | SS | 566 | 2424 | 581 | 585 | 564 | 591 | 560 | 561 | 532 | 559 | 566 | 555 | 570 | 589 | 532 | 568 | 590 | 595 | 585 | 561 | 593 | 567 | 566 | 579 | 575 | 554 | 564 | 565 | 570 | 560 | 562 | ALTER TRIGGER - AS |
|
169 | SS | 567 | 2458 | 584 | 585 | 559 | 607 | 567 | 561 | 531 | 564 | 567 | 568 | 565 | 580 | 531 | 576 | 592 | 590 | 600 | 583 | 580 | 579 | 565 | 561 | 565 | 551 | 557 | 560 | 568 | 564 | 563 | ALTER TRIGGER - AS |
|
170 | SS | 566 | 2243 | 585 | 571 | 557 | 581 | 576 | 562 | 531 | 567 | 566 | 564 | 571 | 596 | 531 | 561 | 588 | 601 | 584 | 577 | 593 | 600 | 569 | 558 | 562 | 566 | 566 | 565 | 565 | 566 | 548 | ALTER TRIGGER - AS |
|
171 | SS | 565 | 2434 | 582 | 565 | 562 | 607 | 561 | 564 | 531 | 564 | 561 | 565 | 565 | 599 | 531 | 563 | 573 | 582 | 602 | 566 | 590 | 597 | 577 | 564 | 562 | 552 | 567 | 561 | 566 | 566 | 566 | ALTER TRIGGER - AS |
|
172 | SS | 564 | 2448 | 583 | 560 | 562 | 577 | 576 | 556 | 531 | 564 | 555 | 574 | 568 | 585 | 532 | 547 | 595 | 611 | 593 | 546 | 575 | 584 | 564 | 563 | 567 | 551 | 562 | 561 | 557 | 555 | 565 | CREATE TRIGGER |
|
173 | SS | 564 | 2242 | 582 | 587 | 557 | 585 | 549 | 571 | 516 | 547 | 559 | 561 | 556 | 577 | 531 | 560 | 570 | 586 | 582 | 564 | 572 | 581 | 564 | 563 | 563 | 582 | 565 | 579 | 558 | 564 | 551 | CREATE TRIGGER AFTER INSERT |
|
174 | SS | 562 | 2455 | 578 | 562 | 565 | 588 | 568 | 550 | 531 | 547 | 549 | 553 | 562 | 592 | 531 | 548 | 587 | 594 | 596 | 558 | 590 | 577 | 566 | 574 | 559 | 554 | 561 | 543 | 549 | 567 | 548 | CREATE TRIGGER BEFORE UPDATE |
|
175 | SS | 562 | 2456 | 586 | 561 | 562 | 579 | 558 | 558 | 532 | 554 | 551 | 560 | 568 | 574 | 516 | 561 | 586 | 597 | 604 | 564 | 568 | 595 | 565 | 549 | 563 | 566 | 558 | 562 | 566 | 562 | 557 | CREATE TRIGGER AFTER UPDATE |
|
176 | SS | 566 | 2254 | 572 | 575 | 559 | 570 | 564 | 546 | 531 | 566 | 565 | 557 | 567 | 575 | 531 | 551 | 584 | 590 | 603 | 547 | 573 | 573 | 569 | 567 | 566 | 558 | 549 | 570 | 548 | 564 | 568 | CREATE TRIGGER BEFORE DELETE |
|
177 | SS | 562 | 2421 | 595 | 568 | 546 | 588 | 574 | 549 | 515 | 560 | 548 | 564 | 553 | 563 | 531 | 553 | 573 | 604 | 600 | 548 | 593 | 576 | 561 | 552 | 572 | 552 | 572 | 558 | 564 | 552 | 559 | CREATE TRIGGER AFTER DELETE |
|
178 | SS | 564 | 2446 | 588 | 579 | 566 | 579 | 547 | 562 | 516 | 564 | 548 | 566 | 569 | 564 | 532 | 560 | 582 | 581 | 596 | 552 | 598 | 560 | 565 | 554 | 563 | 547 | 561 | 562 | 583 | 559 | 567 | CREATE TRIGGER INACTIVE AFTER DELETE |
|
179 | SS | 564 | 2240 | 592 | 576 | 561 | 594 | 566 | 553 | 531 | 550 | 549 | 556 | 555 | 568 | 531 | 545 | 590 | 582 | 593 | 565 | 586 | 563 | 571 | 562 | 565 | 552 | 561 | 565 | 558 | 568 | 563 | CREATE TRIGGER AFTER DELETE POSITION 12 |
|
180 | SS | 562 | 2421 | 582 | 572 | 562 | 583 | 562 | 548 | 532 | 570 | 547 | 557 | 566 | 561 | 515 | 548 | 591 | 603 | 600 | 557 | 568 | 588 | 574 | 563 | 562 | 555 | 548 | 563 | 561 | 560 | 572 | CREATE TRIGGER BEFORE INSERT DECLARE VARIABLE |
|
181 | SS | 564 | 2436 | 599 | 563 | 564 | 590 | 565 | 573 | 546 | 560 | 551 | 558 | 571 | 559 | 532 | 549 | 582 | 604 | 612 | 550 | 584 | 572 | 569 | 554 | 563 | 562 | 568 | 547 | 555 | 566 | 569 | CREATE TRIGGER BEFORE INSERT DECLARE VARIABLE, block stataments |
|
182 | SS | 565 | 2433 | 577 | 590 | 570 | 613 | 569 | 564 | 532 | 562 | 550 | 549 | 572 | 567 | 547 | 553 | 579 | 610 | 596 | 559 | 578 | 560 | 566 | 555 | 569 | 551 | 564 | 564 | 569 | 563 | 557 | CREATE TRIGGER SQL2003 |
|
183 | SS | 565 | 2239 | 588 | 569 | 563 | 589 | 559 | 558 | 531 | 563 | 564 | 571 | 570 | 565 | 515 | 566 | 590 | 587 | 597 | 562 | 568 | 560 | 563 | 570 | 560 | 554 | 573 | 565 | 561 | 554 | 571 | Trigger on database connect. See also CORE-745 |
|
184 | SS | 1215 | 2416 | 1289 | 1241 | 1213 | 1356 | 1216 | 1213 | 1203 | 1246 | 1205 | 1251 | 1194 | 1206 | 1172 | 1196 | 1320 | 1323 | 1304 | 1197 | 1269 | 1306 | 1214 | 1193 | 1200 | 1196 | 1216 | 1195 | 1195 | 1231 | 1232 | Error handling in trigger on database connect |
|
185 | SS | 571 | 2436 | 599 | 577 | 566 | 589 | 567 | 565 | 516 | 580 | 562 | 588 | 573 | 581 | 531 | 560 | 574 | 582 | 603 | 557 | 584 | 609 | 574 | 556 | 567 | 559 | 571 | 566 | 563 | 552 | 572 | Multiple triggers on database connect |
|
186 | SS | 1219 | 2235 | 1300 | 1238 | 1211 | 1287 | 1212 | 1203 | 1203 | 1227 | 1244 | 1247 | 1181 | 1208 | 1219 | 1211 | 1290 | 1307 | 1295 | 1221 | 1274 | 1306 | 1220 | 1200 | 1187 | 1187 | 1200 | 1210 | 1212 | 1232 | 1217 | Error handling when multiple triggers on database connect exist |
|
187 | SS | 1970 | 2422 | 1971 | 2104 | 2929 | 1966 | 2070 | 2103 | 1879 | 2844 | 2045 | 1952 | 2947 | 1917 | 2004 | 2081 | 1970 | 1970 | 1989 | 2084 | 1962 | 1963 | 1923 | 1897 | 1928 | 1932 | 1932 | 2046 | 1918 | 2070 | 1906 | Trigger on database disconnect: check that exception that raised when trigger fires is written to firebird.log |
|
188 | SS | 416 | 2424 | 454 | 427 | 412 | 454 | 418 | 412 | 406 | 419 | 404 | 402 | 421 | 419 | 391 | 408 | 436 | 449 | 439 | 405 | 429 | 447 | 411 | 404 | 420 | 403 | 407 | 415 | 407 | 411 | 417 | Multiple triggers on start transaction |
|
189 | SS | 565 | 2446 | 606 | 580 | 577 | 598 | 568 | 562 | 532 | 558 | 561 | 566 | 571 | 565 | 547 | 556 | 583 | 605 | 611 | 559 | 586 | 603 | 571 | 565 | 561 | 561 | 560 | 560 | 569 | 556 | 562 | Trigger on commit transaction. See also CORE-645 |
|
190 | SS | 420 | 2237 | 454 | 444 | 420 | 439 | 420 | 420 | 390 | 407 | 414 | 415 | 409 | 410 | 390 | 409 | 436 | 453 | 443 | 407 | 420 | 446 | 426 | 425 | 421 | 411 | 407 | 405 | 421 | 411 | 421 | Trigger on rollback transaction |
|
191 | SS | 410 | 2478 | 463 | 479 | 406 | 428 | 417 | 406 | 391 | 409 | 402 | 406 | 411 | 424 | 407 | 404 | 426 | 447 | 454 | 407 | 427 | 441 | 424 | 414 | 427 | 403 | 406 | 410 | 410 | 408 | 403 | Trigger on start tansaction |
|
192 | SS | 567 | 2461 | 593 | 586 | 568 | 596 | 568 | 567 | 531 | 562 | 566 | 560 | 568 | 565 | 515 | 553 | 593 | 598 | 599 | 566 | 595 | 595 | 562 | 565 | 575 | 562 | 559 | 565 | 563 | 568 | 569 | ALTER TRIGGER - ACTIVE |
|
193 | SS | 566 | 2231 | 600 | 606 | 559 | 590 | 563 | 568 | 531 | 564 | 568 | 565 | 570 | 566 | 532 | 559 | 583 | 605 | 594 | 559 | 573 | 598 | 566 | 570 | 564 | 546 | 566 | 559 | 565 | 563 | 565 | ALTER TRIGGER - INACTIVE |
|
194 | SS | 568 | 2406 | 624 | 604 | 563 | 599 | 569 | 559 | 532 | 569 | 566 | 561 | 569 | 582 | 531 | 564 | 604 | 605 | 595 | 564 | 585 | 591 | 569 | 572 | 560 | 564 | 560 | 566 | 567 | 567 | 561 | ALTER TRIGGER - BEFORE DELETE |
|
195 | SS | 565 | 2424 | 610 | 610 | 581 | 590 | 581 | 567 | 531 | 562 | 565 | 563 | 564 | 560 | 531 | 560 | 570 | 590 | 613 | 567 | 587 | 590 | 566 | 562 | 564 | 565 | 563 | 563 | 565 | 564 | 571 | ALTER TRIGGER - BEFORE INSERT |
|
196 | SS | 566 | 2445 | 592 | 610 | 562 | 588 | 567 | 559 | 531 | 560 | 564 | 560 | 563 | 567 | 531 | 548 | 592 | 602 | 607 | 576 | 587 | 598 | 566 | 568 | 559 | 565 | 568 | 577 | 565 | 563 | 562 | ALTER TRIGGER - BEFORE UPDATE |
|
197 | SS | 566 | 2246 | 595 | 576 | 566 | 685 | 565 | 561 | 531 | 566 | 562 | 563 | 575 | 564 | 532 | 584 | 584 | 586 | 590 | 554 | 589 | 590 | 567 | 579 | 566 | 563 | 590 | 567 | 555 | 561 | 564 | ALTER TRIGGER - AFTER DELETE |
|
198 | SS | 568 | 2456 | 588 | 579 | 569 | 551 | 568 | 564 | 532 | 564 | 575 | 560 | 565 | 589 | 531 | 561 | 623 | 615 | 594 | 567 | 572 | 586 | 570 | 557 | 562 | 593 | 564 | 575 | 568 | 568 | 568 | ALTER TRIGGER: attempt to use "new" in AFTER INSERT |
|
199 | SS | 567 | 2442 | 585 | 575 | 557 | 567 | 574 | 552 | 531 | 568 | 553 | 564 | 567 | 564 | 531 | 551 | 631 | 602 | 588 | 567 | 584 | 589 | 558 | 566 | 561 | 571 | 554 | 584 | 555 | 580 | 561 | ALTER TRIGGER - POSITION |
|
200 | SS | 565 | 2833 | 584 | 574 | 561 | 569 | 566 | 565 | 547 | 561 | 561 | 559 | 552 | 563 | 531 | 565 | 615 | 598 | 597 | 551 | 589 | 596 | 582 | 564 | 564 | 565 | 562 | 558 | 564 | 573 | 568 | ALTER TRIGGER - POSITION |
|
201 | SS | 568 | 2278 | 599 | 580 | 568 | 571 | 559 | 589 | 531 | 570 | 554 | 554 | 569 | 565 | 532 | 567 | 610 | 598 | 593 | 554 | 598 | 581 | 579 | 554 | 579 | 561 | 563 | 565 | 550 | 597 | 562 | ALTER TRIGGER - AS |
|
202 | SS | 566 | 2421 | 578 | 572 | 556 | 559 | 564 | 562 | 547 | 561 | 559 | 565 | 584 | 568 | 531 | 562 | 602 | 591 | 601 | 551 | 572 | 595 | 580 | 569 | 572 | 549 | 565 | 560 | 591 | 567 | 563 | ALTER TRIGGER - AS |
|
203 | SS | 566 | 2432 | 601 | 581 | 570 | 555 | 565 | 566 | 515 | 565 | 569 | 563 | 567 | 566 | 531 | 596 | 593 | 597 | 604 | 563 | 582 | 590 | 587 | 583 | 566 | 547 | 565 | 566 | 555 | 568 | 558 | ALTER TRIGGER - AS |
|
204 | SS | 568 | 2462 | 569 | 579 | 569 | 549 | 566 | 559 | 532 | 567 | 559 | 567 | 565 | 571 | 531 | 575 | 584 | 590 | 582 | 549 | 576 | 596 | 596 | 602 | 568 | 560 | 560 | 562 | 568 | 570 | 566 | ALTER TRIGGER - AS |
|
205 | SS | 4601 | 2243 | 5222 | 4649 | 4616 | 4642 | 4631 | 4566 | 4458 | 4601 | 4575 | 4583 | 4591 | 4569 | 4459 | 4732 | 4699 | 4731 | 4769 | 4571 | 4678 | 4955 | 4659 | 4670 | 4602 | 4576 | 4575 | 4566 | 4563 | 4616 | 4578 | gbak utility: check ability to use -ZIP command switch when create backup |
|
206 | SS | 561 | 2454 | 599 | 566 | 552 | 550 | 558 | 569 | 547 | 558 | 560 | 563 | 557 | 565 | 531 | 548 | 599 | 620 | 603 | 1070 | 586 | 613 | 571 | 546 | 572 | 560 | 1089 | 556 | 550 | 553 | 560 | CREATE VIEW |
|
207 | SS | 561 | 2464 | 589 | 603 | 566 | 547 | 562 | 561 | 547 | 569 | 557 | 566 | 552 | 551 | 532 | 549 | 582 | 602 | 606 | 550 | 593 | 591 | 561 | 551 | 567 | 545 | 552 | 566 | 550 | 566 | 561 | CREATE VIEW |
|
208 | SS | 565 | 2248 | 580 | 569 | 588 | 562 | 562 | 570 | 547 | 564 | 547 | 563 | 551 | 566 | 531 | 572 | 574 | 599 | 596 | 547 | 586 | 595 | 570 | 568 | 557 | 560 | 563 | 554 | 572 | 562 | 563 | CREATE VIEW - bad number of columns |
|
209 | SS | 562 | 2439 | 578 | 580 | 548 | 551 | 574 | 552 | 531 | 571 | 556 | 566 | 569 | 560 | 516 | 554 | 589 | 611 | 592 | 556 | 597 | 588 | 567 | 562 | 563 | 548 | 565 | 555 | 545 | 554 | 562 | CREATE VIEW - bad number of columns |
|
210 | SS | 563 | 2443 | 578 | 566 | 563 | 566 | 592 | 561 | 547 | 559 | 564 | 547 | 565 | 566 | 531 | 550 | 576 | 619 | 609 | 561 | 610 | 572 | 569 | 563 | 561 | 548 | 561 | 555 | 562 | 558 | 551 | CREATE VIEW |
|
211 | SS | 566 | 2246 | 586 | 564 | 566 | 546 | 590 | 564 | 547 | 551 | 562 | 568 | 568 | 566 | 531 | 552 | 590 | 588 | 605 | 546 | 606 | 626 | 568 | 554 | 561 | 623 | 564 | 548 | 545 | 567 | 568 | CREATE VIEW - updateable |
|
212 | SS | 563 | 2416 | 594 | 583 | 560 | 549 | 576 | 557 | 515 | 567 | 558 | 560 | 548 | 563 | 516 | 544 | 576 | 598 | 607 | 555 | 591 | 596 | 563 | 541 | 567 | 558 | 567 | 564 | 551 | 547 | 563 | CREATE VIEW - updateable WITH CHECK OPTION |
|
213 | SS | 568 | 2445 | 591 | 578 | 563 | 555 | 595 | 554 | 547 | 567 | 561 | 549 | 570 | 583 | 531 | 566 | 578 | 585 | 613 | 564 | 619 | 589 | 574 | 587 | 565 | 548 | 583 | 567 | 577 | 543 | 554 | CREATE VIEW - updateable WITH CHECK OPTION |