Generated 12.05.2024 19:14
Tested: HQ30. Build: 3.0.12.33744; SS: 12.05.24 17:42:19 - 12.05.24 18:16:50; CS: 12.05.24 18:17:31 - 12.05.24 19:11:55;
OS and hardware info: Linux 6.5.0-5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.5.13-1 (2023-11-29) ; logical CPUs: 2 ; total memory: 7.6 Gb
QA-software: Python 3.11.7, virtual env; pytest: 7.4.4; firebird.driver: 1.10.4; Firebird.Qa: 0.19.3
Jump to LIST of unique test names from this report
NN | Test name | mode | 3.0.12.33744 2024-05-12 |
3.0.12.33740 2024-04-20 |
3.0.12.33726 2024-04-04 |
3.0.12.33725 2023-12-29 |
3.0.12.33722 2023-11-28 |
3.0.12.33712 2023-11-07 |
3.0.12.33706 2023-09-20 |
3.0.11.33689 2023-08-09 |
3.0.11.33687 2023-06-22 |
3.0.11.33685 2023-06-04 |
3.0.11.33683 2023-05-02 |
3.0.11.33666 2023-04-17 |
3.0.11.33664 2023-03-14 |
3.0.11.33657 2023-02-08 |
3.0.11.33648 2023-01-18 |
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | F | 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 | Tricky role defeats basic SQL security |
|
2 | CS | P | P | P | P | P | P | P | P | P | P | F | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Compress Data over the Network |
|
3 | SS | P | P | P | P | P | P | P | P | P | P | F | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Compress Data over the Network |
|
4 | CS | F | 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 | It is impossible to take away rights on update of a column |
|
5 | CS | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Can't create table using long username and UTF8 as attachment charset |
|
6 | SS | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Can't create table using long username and UTF8 as attachment charset |
|
7 | CS | F | 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 | Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well |
|
8 | CS | F | 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 | Trace output could contain garbage data left from filtered out statements |
|
9 | CS | F | 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 | Add attachment's CHARACTER SET name into corresponding trace records |
|
10 | CS | F | 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 | exclude_filter doesn't work for <services></section> section of the Trace facility |
|
11 | CS | F | 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 | Improve diagnostics of internal trace errors |
|
12 | CS | F | 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 | There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back |
|
13 | CS | F | 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 | TRACE: add statistics of actions that were after transaction finished |
|
14 | CS | F | 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 | Wrong parameters order in trace output |
|
15 | CS | F | 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 | fbsvcmgr doesn't recognise sts_record_versions and other sts switches |
|
16 | CS | F | 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 | Keyword SET should not be required in ALTER USER statement |
|
17 | CS | F | 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 | gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window) |
|
18 | SS | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window) |
|
19 | CS | F | 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 | non-priviledged user can insert and update rdb$database |
|
20 | CS | F | 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 | Allow output to trace explain plan form. |
|
21 | CS | F | 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 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
22 | CS | F | 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 | Make user names behave according to SQL identifiers rules |
|
23 | SS | F | F | F | P | F | F | P | P | P | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Better performance of creating packages containing many functions |
|
24 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ISQL does not show encryption status of database |
|
25 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ISQL does not show encryption status of database |
|
26 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Return nonzero result code when restore fails on activating and creating deferred user index |
|
27 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Return nonzero result code when restore fails on activating and creating deferred user index |
|
28 | SS | S | S | S | S | S | S | S | S | S | S | S | S | F | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting |
|
29 | CS | F | 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 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
30 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued |
|
31 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued |
|
32 | CS | F | 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 | Bad performance for NULLs filtering inside a navigational index scan |
|
33 | CS | F | F | 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 | X | X | Slow changes on domain |
|
34 | SS | F | F | 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 | X | X | Slow changes on domain |
|
35 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unique constraint not working in encrypted database on first command |
|
36 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Unique constraint not working in encrypted database on first command |
|
37 | CS | F | 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 | ALTER TRIGGER check privilege for alter database instead of table |
|
38 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Error returned from DbCryptPlugin::setKey() is not shown |
|
39 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Error returned from DbCryptPlugin::setKey() is not shown |
|
40 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | gstat may produce faulty report about presence of some none-encrypted pages in database |
|
41 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | gstat may produce faulty report about presence of some none-encrypted pages in database |
|
42 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Not user friendly output of gstat at encrypted database |
|
43 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Not user friendly output of gstat at encrypted database |
|
44 | CS | F | 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 | Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored) |
|
45 | CS | F | 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 | Creator user name is empty in user trace sessions |
|
46 | CS | F | 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 | Srp user manager sporadically creates users which can not attach Explanation of bug nature was provided by Alex, see letter 05-jun-19 13:51. Some iteration failed with probability equal to occurence of 0 (zero) in the highest BYTE of some number. Byte is 8 bit ==> this probability is 1/256. Given 'N_LIMIT' is number of iterations, probability of success for ALL of them is 7.5%, and when N_LIMIT is 1000 then p = 0.004%. Because of time (speed) it was decided to run only 256 iterations. If bug will be 'raised' somewhere then this number is enough to catch it after 2-3 times of test run. Reproduced on WI-V3.0.5.33118, date: 11-apr-19 (got fails not late than on 250th iteration). Works fine on WI-V3.0.5.33139, date: 04-apr-19. |
|
47 | CS | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters |
|
48 | SS | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters |
|
49 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Generator pages are not encrypted |
|
50 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Generator pages are not encrypted |
|
51 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wire compression causes freezes |
|
52 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wire compression causes freezes |
|
53 | CS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong or missing IS NULL optimization (regression) [CORE3449] |
|
54 | SS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong or missing IS NULL optimization (regression) [CORE3449] |
|
55 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||
56 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||
57 | CS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Firebird performance issue - non necessary index reads |
|
58 | SS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Firebird performance issue - non necessary index reads |
|
59 | CS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices. |
|
60 | SS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices. |
|
61 | CS | P | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Precision of standalone unit may differ from packaged one in SQL dialect 1 |
|
62 | SS | P | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Precision of standalone unit may differ from packaged one in SQL dialect 1 |
|
63 | CS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s) |
|
64 | SS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s) |
|
65 | CS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT() |
|
66 | SS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT() |
|
67 | CS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Server crash on some LockMemSize values |
|
68 | SS | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Server crash on some LockMemSize values |
|
69 | CS | X | X | X | X | X | X | X | X | X | X | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
70 | SS | X | X | X | X | X | X | X | X | X | X | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
71 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error |
|
72 | SS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error |
|
73 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong result ordering in LEFT JOIN query |
|
74 | SS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Wrong result ordering in LEFT JOIN query |
|
75 | CS | X | X | X | X | X | X | X | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Cursor name can duplicate parameter and variable names in procedures and functions |
|
76 | SS | X | X | X | X | X | X | X | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Cursor name can duplicate parameter and variable names in procedures and functions |
|
77 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
|
78 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
|
79 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | garbage collection in indexes and blobs is not performed in VIO_backout |
|
80 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | garbage collection in indexes and blobs is not performed in VIO_backout |
|
81 | CS | P | P | P | P | F | 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 | Potential bug in BETWEEN Operator |
|
82 | SS | P | P | P | P | F | 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 | Potential bug in BETWEEN Operator |
|
83 | CS | P | P | P | P | F | 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 | Removing first column with SET WIDTH crashes ISQL |
|
84 | SS | P | P | P | P | F | 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 | Removing first column with SET WIDTH crashes ISQL |
|
85 | CS | P | P | P | P | F | 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 | Crash potentially caused by BETWEEN Operator |
|
86 | CS | P | P | F | 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 | INNER JOIN join order |
|
87 | SS | P | P | F | 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 | INNER JOIN join order |
|
88 | CS | F | 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 | MIN() and DESC index (non-unique) |
|
89 | CS | F | 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 | gtcs-proc-isql-16 |
|
90 | SS | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it. |
|
91 | CS | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | crash on assert or memory corruption when too long username is used for authentication |
|
92 | CS | S | S | S | S | S | S | S | S | S | S | S | S | S | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Verify ability to make REMOTE connect to security.db |
|
93 | SS | S | S | S | S | S | S | S | S | S | S | S | S | S | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Verify ability to make REMOTE connect to security.db |
NN | Test name | mode | median_ms | 3.0.12.33744 2024-05-12 |
3.0.12.33740 2024-04-20 |
3.0.12.33726 2024-04-04 |
3.0.12.33725 2023-12-29 |
3.0.12.33722 2023-11-28 |
3.0.12.33712 2023-11-07 |
3.0.12.33706 2023-09-20 |
3.0.11.33689 2023-08-09 |
3.0.11.33687 2023-06-22 |
3.0.11.33685 2023-06-04 |
3.0.11.33683 2023-05-02 |
3.0.11.33666 2023-04-17 |
3.0.11.33664 2023-03-14 |
3.0.11.33657 2023-02-08 |
3.0.11.33648 2023-01-18 |
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 2329 | 3234 | 2958 | 2329 | 2820 | 2350 | 2201 | 2409 | 2227 | 2246 | 2108 | 2259 | 2375 | 2109 | 2464 | 1979 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Tricky role defeats basic SQL security |
|
2 | CS | 44007 | 48376 | 34893 | 37460 | 45798 | 40510 | 39825 | 48996 | 48222 | 48594 | 39929 | 44320 | 47343 | 44007 | 2150 | 1936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Compress Data over the Network |
|
3 | SS | 42945 | 45485 | 32201 | 36082 | 44686 | 39476 | 38616 | 46651 | 46572 | 45110 | 39318 | 43665 | 45925 | 42945 | 1831 | 1546 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Compress Data over the Network |
|
4 | CS | 2990 | 3952 | 3645 | 2994 | 3585 | 2972 | 2914 | 3010 | 2991 | 2876 | 2643 | 2946 | 2990 | 2678 | 3115 | 2451 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | It is impossible to take away rights on update of a column |
|
5 | CS | 850 | 1167 | 992 | 828 | 1126 | 861 | 878 | 850 | 844 | 808 | 738 | 822 | 875 | 727 | 999 | 839 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Can't create table using long username and UTF8 as attachment charset |
|
6 | SS | 432 | 464 | 432 | 395 | 470 | 398 | 436 | 453 | 408 | 406 | 377 | 360 | 441 | 437 | 536 | 405 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Can't create table using long username and UTF8 as attachment charset |
|
7 | CS | 3441 | 4313 | 4105 | 3494 | 4042 | 3441 | 3462 | 3667 | 3317 | 3461 | 3055 | 3302 | 3364 | 3069 | 3420 | 2847 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well |
|
8 | CS | 2955 | 3131 | 3077 | 2959 | 3113 | 2947 | 2912 | 2976 | 2955 | 2956 | 2890 | 2911 | 2922 | 2919 | 3109 | 2750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Trace output could contain garbage data left from filtered out statements |
|
9 | CS | 2959 | 3413 | 3097 | 2956 | 3292 | 2959 | 2968 | 2925 | 2967 | 2949 | 2903 | 2880 | 2936 | 2950 | 3099 | 3032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add attachment's CHARACTER SET name into corresponding trace records |
|
10 | CS | 2951 | 3136 | 3121 | 2983 | 3150 | 3037 | 2951 | 2976 | 2952 | 2730 | 2647 | 2687 | 2923 | 2613 | 2874 | 2757 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | exclude_filter doesn't work for <services></section> section of the Trace facility |
|
11 | CS | 2955 | 3098 | 3093 | 2960 | 3046 | 2915 | 2935 | 2973 | 2955 | 2905 | 2637 | 2895 | 2917 | 2905 | 3120 | 3049 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Improve diagnostics of internal trace errors |
|
12 | CS | 5149 | 5636 | 5444 | 5222 | 6065 | 5325 | 5325 | 5149 | 5121 | 5293 | 4837 | 4840 | 4908 | 4844 | 5025 | 4502 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back |
|
13 | CS | 3170 | 3429 | 3375 | 3208 | 3256 | 3168 | 3196 | 3157 | 3187 | 3163 | 3118 | 3149 | 3170 | 3133 | 3280 | 2968 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TRACE: add statistics of actions that were after transaction finished |
|
14 | CS | 3169 | 3393 | 3299 | 3175 | 3264 | 3165 | 3198 | 3169 | 3138 | 3198 | 3078 | 3123 | 3115 | 3153 | 3301 | 2952 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong parameters order in trace output |
|
15 | CS | 894 | 1260 | 1107 | 894 | 1017 | 926 | 931 | 904 | 862 | 875 | 750 | 799 | 820 | 743 | 1025 | 848 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | fbsvcmgr doesn't recognise sts_record_versions and other sts switches |
|
16 | CS | 1655 | 1893 | 1754 | 1655 | 1984 | 1619 | 1718 | 1718 | 1712 | 1534 | 1478 | 1565 | 1592 | 1461 | 1831 | 1538 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Keyword SET should not be required in ALTER USER statement |
|
17 | CS | 13529 | 14588 | 13386 | 13361 | 16151 | 14023 | 13997 | 13529 | 13436 | 13760 | 13593 | 13476 | 13736 | 13283 | 13403 | 12060 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window) |
|
18 | SS | 12209 | 12515 | 11905 | 12085 | 14190 | 12724 | 12710 | 12209 | 12372 | 12423 | 12309 | 12125 | 5845 | 11986 | 12029 | 10979 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window) |
|
19 | CS | 1381 | 1750 | 1710 | 1381 | 1711 | 1362 | 1410 | 1443 | 1382 | 1373 | 1244 | 1345 | 1338 | 1215 | 1544 | 1264 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | non-priviledged user can insert and update rdb$database |
|
20 | CS | 3187 | 3419 | 3290 | 3196 | 3334 | 3187 | 3193 | 3215 | 3164 | 3175 | 3068 | 3108 | 3116 | 3061 | 3240 | 2929 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Allow output to trace explain plan form. |
|
21 | CS | 1985 | 2814 | 2215 | 1914 | 2412 | 1914 | 1963 | 2032 | 1985 | 2111 | 1671 | 1925 | 2097 | 1840 | 2301 | 1854 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FB3: CREATE USER GRANT ADMIN ROLE does not work |
|
22 | CS | 3111 | 4101 | 4078 | 3376 | 3848 | 3012 | 3158 | 3263 | 3111 | 3070 | 2699 | 2944 | 3013 | 2773 | 3189 | 2491 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Make user names behave according to SQL identifiers rules |
|
23 | SS | 178724 | 155713 | 141009 | 155680 | 199542 | 176102 | 181437 | 193014 | 192599 | 187706 | 166446 | 178724 | 185588 | 179258 | 175770 | 114084 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Better performance of creating packages containing many functions |
|
24 | CS | 943 | 1144 | 1121 | 943 | 1107 | 955 | 916 | 967 | 948 | 967 | 835 | 892 | 914 | 814 | 650 | 530 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ISQL does not show encryption status of database |
|
25 | SS | 421 | 449 | 433 | 326 | 461 | 421 | 431 | 402 | 425 | 427 | 372 | 405 | 446 | 350 | 300 | 237 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ISQL does not show encryption status of database |
|
26 | CS | 1132 | 1493 | 1424 | 1114 | 1241 | 1231 | 1103 | 1196 | 1132 | 1128 | 1006 | 1025 | 1161 | 1038 | 1240 | 1011 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Return nonzero result code when restore fails on activating and creating deferred user index |
|
27 | SS | 733 | 1052 | 883 | 808 | 827 | 699 | 741 | 659 | 755 | 709 | 707 | 642 | 733 | 714 | 787 | 658 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Return nonzero result code when restore fails on activating and creating deferred user index |
|
28 | SS | 400 | 434 | 428 | 358 | 2 | 400 | 5 | 389 | 4 | 1 | 392 | 415 | 411 | 16531 | 16743 | 16719 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting |
|
29 | CS | 4440 | 4547 | 4382 | 4591 | 4810 | 4418 | 4382 | 4668 | 4681 | 4754 | 4440 | 4294 | 4331 | 4313 | 4446 | 4121 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Badly selective index could be used for extra filtering even if selective index is used for sorting |
|
30 | CS | 1315 | 3 | 5 | 1 | 5 | 2 | 0 | 2947 | 2995 | 4 | 2626 | 4 | 2925 | 2635 | 2865 | 2771 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued |
|
31 | SS | 2414 | 4 | 4 | 2406 | 5 | 2477 | 1 | 2450 | 0 | 2448 | 2437 | 3 | 3 | 2422 | 2527 | 2508 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued |
|
32 | CS | 4472 | 4633 | 4376 | 4356 | 4691 | 4630 | 4472 | 4597 | 4622 | 4717 | 4301 | 4213 | 4294 | 4376 | 4541 | 3780 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bad performance for NULLs filtering inside a navigational index scan |
|
33 | CS | 11418 | 20231 | 18523 | 10874 | 12354 | 11079 | 10842 | 13294 | 12403 | 13403 | 10797 | 10076 | 11418 | 10927 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Slow changes on domain |
|
34 | SS | 9807 | 16905 | 16190 | 9418 | 11730 | 9700 | 9534 | 11309 | 11221 | 12011 | 9807 | 9138 | 9426 | 9778 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Slow changes on domain |
|
35 | CS | 1164 | 1345 | 1387 | 1170 | 1284 | 1204 | 1164 | 1202 | 1144 | 1141 | 1059 | 1127 | 1169 | 1026 | 832 | 681 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique constraint not working in encrypted database on first command |
|
36 | SS | 567 | 553 | 567 | 508 | 654 | 577 | 591 | 595 | 554 | 610 | 501 | 611 | 577 | 508 | 441 | 358 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Unique constraint not working in encrypted database on first command |
|
37 | CS | 859 | 859 | 1032 | 859 | 929 | 843 | 864 | 963 | 799 | 863 | 747 | 828 | 816 | 704 | 1024 | 828 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ALTER TRIGGER check privilege for alter database instead of table |
|
38 | CS | 465 | 574 | 672 | 531 | 523 | 465 | 460 | 479 | 440 | 451 | 388 | 433 | 419 | 407 | 608 | 533 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error returned from DbCryptPlugin::setKey() is not shown |
|
39 | SS | 202 | 243 | 228 | 165 | 256 | 199 | 187 | 202 | 160 | 198 | 160 | 202 | 218 | 169 | 364 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error returned from DbCryptPlugin::setKey() is not shown |
|
40 | CS | 9463 | 9878 | 8494 | 8408 | 10825 | 8235 | 8933 | 11111 | 11075 | 11446 | 9463 | 8619 | 10727 | 9575 | 8887 | 6298 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | gstat may produce faulty report about presence of some none-encrypted pages in database |
|
41 | SS | 9003 | 9134 | 7546 | 8953 | 10279 | 9450 | 8847 | 9579 | 11588 | 10756 | 8557 | 8618 | 9003 | 9460 | 7770 | 6035 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | gstat may produce faulty report about presence of some none-encrypted pages in database |
|
42 | CS | 653 | 868 | 781 | 669 | 680 | 708 | 675 | 693 | 653 | 644 | 575 | 621 | 636 | 584 | 631 | 495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Not user friendly output of gstat at encrypted database |
|
43 | SS | 298 | 318 | 313 | 269 | 355 | 298 | 285 | 286 | 312 | 289 | 271 | 301 | 320 | 270 | 335 | 265 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Not user friendly output of gstat at encrypted database |
|
44 | CS | 2349 | 3016 | 2795 | 2433 | 2909 | 2386 | 2312 | 2349 | 2484 | 2295 | 2040 | 2212 | 2267 | 2131 | 2512 | 1942 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored) |
|
45 | CS | 2728 | 2872 | 2803 | 2696 | 3052 | 2930 | 2762 | 2669 | 2963 | 2642 | 2647 | 2663 | 2671 | 2651 | 2912 | 2728 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Creator user name is empty in user trace sessions |
|
46 | CS | 169699 | 830 | 214958 | 174617 | 200810 | 171768 | 170264 | 178116 | 174672 | 169699 | 152160 | 164337 | 169250 | 156625 | 168600 | 130997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Srp user manager sporadically creates users which can not attach Explanation of bug nature was provided by Alex, see letter 05-jun-19 13:51. Some iteration failed with probability equal to occurence of 0 (zero) in the highest BYTE of some number. Byte is 8 bit ==> this probability is 1/256. Given 'N_LIMIT' is number of iterations, probability of success for ALL of them is 7.5%, and when N_LIMIT is 1000 then p = 0.004%. Because of time (speed) it was decided to run only 256 iterations. If bug will be 'raised' somewhere then this number is enough to catch it after 2-3 times of test run. Reproduced on WI-V3.0.5.33118, date: 11-apr-19 (got fails not late than on 250th iteration). Works fine on WI-V3.0.5.33139, date: 04-apr-19. |
|
47 | CS | 500 | 691 | 653 | 483 | 542 | 474 | 508 | 500 | 500 | 461 | 443 | 435 | 455 | 483 | 656 | 529 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters |
|
48 | SS | 222 | 259 | 222 | 203 | 292 | 199 | 236 | 213 | 222 | 255 | 175 | 227 | 219 | 217 | 299 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters |
|
49 | CS | 853 | 1094 | 988 | 847 | 937 | 909 | 906 | 865 | 844 | 853 | 765 | 780 | 878 | 752 | 816 | 727 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Generator pages are not encrypted |
|
50 | SS | 419 | 443 | 419 | 389 | 469 | 439 | 390 | 427 | 456 | 414 | 368 | 378 | 446 | 403 | 442 | 348 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Generator pages are not encrypted |
|
51 | CS | 71818 | 47423 | 46709 | 53185 | 72168 | 72053 | 80661 | 75000 | 74036 | 71818 | 63936 | 77673 | 77623 | 64789 | 908 | 773 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wire compression causes freezes |
|
52 | SS | 72742 | 45070 | 49055 | 54833 | 77401 | 73094 | 78179 | 77025 | 77277 | 72742 | 63416 | 75657 | 75401 | 65691 | 520 | 486 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wire compression causes freezes |
|
53 | CS | 653 | 925 | 698 | 636 | 725 | 604 | 599 | 758 | 663 | 634 | 607 | 643 | 694 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong or missing IS NULL optimization (regression) [CORE3449] |
|
54 | SS | 388 | 349 | 376 | 322 | 389 | 400 | 382 | 440 | 476 | 388 | 360 | 388 | 423 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong or missing IS NULL optimization (regression) [CORE3449] |
|
55 | CS | 568 | 692 | 733 | 553 | 652 | 504 | 590 | 570 | 581 | 528 | 482 | 546 | 567 | 523 | 681 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
56 | SS | 277 | 296 | 280 | 241 | 376 | 277 | 300 | 243 | 256 | 331 | 213 | 241 | 277 | 253 | 404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
57 | CS | 733 | 834 | 813 | 745 | 795 | 725 | 769 | 737 | 710 | 673 | 656 | 652 | 730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Firebird performance issue - non necessary index reads |
|
58 | SS | 448 | 453 | 421 | 455 | 506 | 444 | 495 | 443 | 427 | 490 | 392 | 443 | 483 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Firebird performance issue - non necessary index reads |
|
59 | CS | 674 | 1060 | 913 | 741 | 818 | 617 | 637 | 677 | 725 | 660 | 607 | 671 | 663 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices. |
|
60 | SS | 491 | 597 | 558 | 428 | 437 | 502 | 464 | 493 | 500 | 560 | 437 | 416 | 490 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices. |
|
61 | CS | 820 | 942 | 906 | 774 | 953 | 841 | 822 | 820 | 836 | 756 | 702 | 771 | 764 | 750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Precision of standalone unit may differ from packaged one in SQL dialect 1 |
|
62 | SS | 348 | 353 | 354 | 318 | 410 | 338 | 413 | 348 | 302 | 345 | 347 | 357 | 387 | 328 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Precision of standalone unit may differ from packaged one in SQL dialect 1 |
|
63 | CS | 551 | 737 | 721 | 559 | 623 | 544 | 572 | 492 | 544 | 561 | 532 | 527 | 536 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s) |
|
64 | SS | 315 | 336 | 314 | 241 | 281 | 318 | 354 | 267 | 316 | 283 | 230 | 324 | 318 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s) |
|
65 | CS | 575 | 756 | 652 | 551 | 671 | 605 | 597 | 607 | 554 | 537 | 484 | 482 | 495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT() |
|
66 | SS | 295 | 293 | 297 | 220 | 339 | 304 | 307 | 297 | 278 | 224 | 216 | 221 | 314 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT() |
|
67 | CS | 326 | 478 | 388 | 375 | 339 | 272 | 287 | 341 | 314 | 306 | 288 | 306 | 405 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Server crash on some LockMemSize values |
|
68 | SS | 226 | 363 | 257 | 175 | 228 | 214 | 204 | 248 | 248 | 221 | 181 | 224 | 371 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Server crash on some LockMemSize values |
|
69 | CS | 8765 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8765 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
70 | SS | 5412 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5412 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
71 | CS | 653 | 879 | 753 | 590 | 664 | 695 | 642 | 638 | 591 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error |
|
72 | SS | 340 | 345 | 321 | 276 | 359 | 354 | 402 | 326 | 336 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error |
|
73 | CS | 600 | 648 | 715 | 571 | 665 | 593 | 598 | 603 | 540 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong result ordering in LEFT JOIN query |
|
74 | SS | 328 | 295 | 331 | 273 | 325 | 364 | 373 | 334 | 304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong result ordering in LEFT JOIN query |
|
75 | CS | 583 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 583 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cursor name can duplicate parameter and variable names in procedures and functions |
|
76 | SS | 338 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 338 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cursor name can duplicate parameter and variable names in procedures and functions |
|
77 | CS | 599 | 649 | 712 | 590 | 758 | 597 | 553 | 599 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
|
78 | SS | 348 | 366 | 344 | 270 | 376 | 378 | 331 | 348 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field. |
|
79 | CS | 1046 | 1208 | 1267 | 1041 | 1176 | 1046 | 997 | 1013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | garbage collection in indexes and blobs is not performed in VIO_backout |
|
80 | SS | 489 | 516 | 535 | 424 | 489 | 470 | 523 | 402 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | garbage collection in indexes and blobs is not performed in VIO_backout |
|
81 | CS | 669 | 669 | 679 | 592 | 676 | 553 | 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 | Potential bug in BETWEEN Operator |
|
82 | SS | 266 | 266 | 255 | 243 | 320 | 332 | 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 | Potential bug in BETWEEN Operator |
|
83 | CS | 644 | 730 | 667 | 591 | 644 | 548 | 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 | Removing first column with SET WIDTH crashes ISQL |
|
84 | SS | 292 | 286 | 292 | 259 | 340 | 1277 | 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 | Removing first column with SET WIDTH crashes ISQL |
|
85 | CS | 673 | 727 | 673 | 581 | 668 | 826 | 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 | Crash potentially caused by BETWEEN Operator |
|
86 | CS | 1024 | 1136 | 1132 | 1024 | 1124 | 964 | 1093 | 1066 | 1037 | 1021 | 885 | 951 | 962 | 876 | 1121 | 916 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order |
|
87 | SS | 618 | 583 | 581 | 535 | 680 | 596 | 593 | 687 | 716 | 674 | 539 | 618 | 667 | 654 | 722 | 589 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INNER JOIN join order |
|
88 | CS | 781 | 870 | 906 | 807 | 927 | 786 | 852 | 739 | 766 | 767 | 643 | 689 | 781 | 690 | 878 | 765 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MIN() and DESC index (non-unique) |
|
89 | CS | 1338 | 1717 | 1620 | 1339 | 1545 | 1342 | 1419 | 1335 | 1352 | 1338 | 1161 | 1217 | 1181 | 1143 | 1164 | 992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | gtcs-proc-isql-16 |
|
90 | SS | 454 | 464 | 448 | 350 | 454 | 481 | 437 | 447 | 1439 | 460 | 378 | 483 | 499 | 390 | 570 | 446 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it. |
|
91 | CS | 400 | 602 | 435 | 378 | 387 | 388 | 405 | 413 | 396 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | crash on assert or memory corruption when too long username is used for authentication |
|
92 | CS | 306 | 1871 | 2 | 1542 | 7 | 1573 | 0 | -1 | 8 | 1598 | 0 | 8 | 2 | 1 | 751 | 605 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Verify ability to make REMOTE connect to security.db |
|
93 | SS | 325 | 3 | 6 | -1 | 1048 | 4 | 1000 | 1048 | 926 | 0 | 2 | 9 | 888 | 894 | 325 | 278 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Verify ability to make REMOTE connect to security.db |