| NN | Test name | mode |
4.0.6.3227
|
4.0.6.3223
|
4.0.6.3222
|
4.0.6.3221
|
4.0.6.3220
|
4.0.6.3219
|
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
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$TRIGGERS content |
|
| 2 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$USER_PRIVILEGES content |
|
| 3 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$VIEW_RELATIONS content |
|
| 4 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Check list of files in the current Firebird snapshot |
|
| 5 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Create database: with PAGE_SIZE=1024: check actual size of page in the created database. |
|
| 6 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Create database: with PAGE_SIZE=2048: check actual size of page in the created database. |
|
| 7 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$TYPES content |
|
| 8 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$DATABASE content |
|
| 9 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$RELATIONS content |
|
| 10 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$RELATION_FIELDS content |
|
| 11 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$ROLES content |
|
| 12 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$SECURITY_CLASSES content |
|
| 13 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$TRANSACTIONS content |
|
| 14 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$TRIGGER_MESSAGES content |
|
| 15 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$INDEX_SEGMENTS content |
|
| 16 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$INDICES content |
|
| 17 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$LOG_FILES content |
|
| 18 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$DATABASE content |
|
| 19 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$PROCEDURE_PARAMETERS content |
|
| 20 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$PROCEDURES content |
|
| 21 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$REF_CONSTRAINTS content |
|
| 22 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FILES |
|
| 23 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FILTERS |
|
| 24 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FORMATS |
|
| 25 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FUNCTION_ARGUMENTS |
|
| 26 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FUNCTIONS content |
|
| 27 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$GENERATORS |
|
| 28 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$CHECK_CONSTRAINTS |
|
| 29 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$DATABASE content |
|
| 30 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$CHARACTER_SETS |
|
| 31 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$COLLATIONS |
|
| 32 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$EXCEPTIONS |
|
| 33 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$DEPENDENCIES |
|
| 34 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FIELD_DIMENSIONS |
|
| 35 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | New DB - RDB$FIELDS |
|
| 36 | CS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Database creation in 3.0.12, 4.0.5 and 5.0.1 slower than in previous releases |
|
| 37 | CS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Report unique usernames for isc_info_user_names |
|
| 38 | CS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | gbak: Incorrect total statistics for restore |
|
| 39 | CS | S | 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 | X | X | X | X | X | X | X | X | Problem with restore time when DB has many indices (possible regression in 6.x) |
|
| 40 | SS | S | S | S | E | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Hang when database with disconnect trigger using MON$ tables is shutting down |
|
| 41 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path) |
|
| 42 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ISQL will truncate lines longer than 255 when pasting |
|
| 43 | CS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change |
|
| 44 | CS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Hang when database with disconnect trigger using MON$ tables is shutting down |
|
| 45 | SS | S | S | S | E | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Some default values is set incorrectly for SC/CS architectures |
|
| 46 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | isc_vax_integer() and isc_portable_integer() work wrongly with short negative numbers |
|
| 47 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state |
|
| 48 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | fbsvcmgr can not decode information buffer returned by gfix list limbo service |
|
| 49 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | READ COMMITTED READ CONSISTENCY mode is broken in Classic / SuperClassic on Linux (the newly created users are not visible to execute statement) |
|
| 50 | SS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level) |
|
| 51 | SS | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Minor performance optimization - avoid additional database attachment from security objects mapping code |
|
| 52 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Non-SYSDBA user can change FW mode of database |
|
| 53 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Can't select from table with ICU column when database (.FDB) is created on LINUX with icu 4.2.1 and then copied to WINDOWS |
|
| 54 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization |
|
| 55 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | ISQL plan output is unexpectedly truncated after a query is simplified to become shorter |
|
| 56 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Inconsistent output when retrieving the server log via Services API |
|
| 57 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 DESC INDEX |
|
| 58 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 DESCENDING INDEX |
|
| 59 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 INDEX - Multi column |
|
| 60 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 INDEX - Table with data |
|
| 61 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 UNIQUE INDEX - Table with data |
|
| 62 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 INDEX - try create index with same name |
|
| 63 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 UNIQUE INDEX - Non unique data in table |
|
| 64 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | CREATE DOMAIN - COLLATE |
|
| 65 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - all options |
|
| 66 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | P | P | P | P | P | P | P | P | P | P | PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script |
|
| 67 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 INDEX |
|
| 68 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 UNIQUE INDEX |
|
| 69 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 ASC INDEX |
|
| 70 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 ASCENDING INDEX |
|
| 71 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DEFAULT literal |
|
| 72 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DEFAULT NULL |
|
| 73 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DEFAULT USER |
|
| 74 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | CREATE DOMAIN - DEFAULT CURRENT_USER |
|
| 75 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DEFAULT CURRENT_ROLE |
|
| 76 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NOT NULL |
|
| 77 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - CHECK |
|
| 78 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NATIONAL CHAR VARYING ARRAY |
|
| 79 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - BLOB |
|
| 80 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN. Specifying BLOB SUB_TYPE <N>, where N = 0 or 1. |
|
| 81 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN. Specifying BLOB SUB_TYPE <A>, where A = 'binary' or 'text'. |
|
| 82 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - BLOB SEGMENT SIZE |
|
| 83 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | CREATE DOMAIN - BLOB SUB_TYPE CHARACTER SET |
|
| 84 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN. Check ability to declare using syntax BLOB(seglen, num_subtype) |
|
| 85 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN using 'VARCHAR' keyword |
|
| 86 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - VARCHAR ARRAY |
|
| 87 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - VARCHAR CHARACTER SET |
|
| 88 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NCHAR |
|
| 89 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NATIONAL CHARACTER |
|
| 90 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NATIONAL CHAR |
|
| 91 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NATIONAL CHAR VARYING |
|
| 92 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DECIMAL |
|
| 93 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DECIMAL ARRAY |
|
| 94 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NUMERIC |
|
| 95 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - NUMERIC ARRAY |
|
| 96 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - CHAR |
|
| 97 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN using 'CHARACTER' keyword |
|
| 98 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN using 'CHARACTER VARYING' keyword |
|
| 99 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - FLOAT |
|
| 100 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DOUBLE PRECISION |
|
| 101 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DOUBLE PRECISION - ARRAY |
|
| 102 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - DATE |
|
| 103 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - TIME |
|
| 104 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - TIMESTAMP |
|
| 105 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - TIMESTAMP ARRAY |
|
| 106 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Create database: with PAGE_SIZE=4096: check actual size of page in the created database. |
|
| 107 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Create database: with PAGE_SIZE=8192: check actual size of page in the created database. |
|
| 108 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Create database: with PAGE_SIZE=16384: check actual size of page in the created database. |
|
| 109 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Create database: with PAGE_SIZE=32768: check actual size of page in the created database. |
|
| 110 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - SMALLINT |
|
| 111 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - INTEGER |
|
| 112 | ALL | S | S | S | S | S | S | P | P | P | P | P | 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 DOMAIN - INT |
|
| 113 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 UNIQUE INDEX - Null value in table |
|
| 114 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 PROCEDURE - PSQL Stataments - SUSPEND |
|
| 115 | ALL | S | S | S | S | S | P | P | P | P | P | P | 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 PROCEDURE - try create SP with same name |
|
| 116 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | COLLATE IN STORED PROCEDURE |
|
| 117 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | CREATE TABLE - column properties |
|
| 118 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | CREATE TABLE - charset + colations + domain |
|
| 119 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | 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 DISTINCT. |
|
| 120 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Check ability to create database with total length of path and file name about maximal allowed limit in Windows |
|
| 121 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | Verify ability to make REMOTE connect to security.db |
|
| 122 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 123 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 124 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 125 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 126 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 127 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 128 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 129 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 130 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 131 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 132 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 133 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 134 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 135 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 136 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 137 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 138 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 139 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 140 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 141 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 142 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 143 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 144 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 145 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 146 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 147 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 148 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 149 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 150 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 151 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 152 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 153 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 154 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 155 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 156 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 157 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 158 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 159 | ALL | S | S | S | S | P | P | P | P | P | P | P | 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 |
|
| 160 | ALL | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | CREATE VIEW as SELECT .... |