Issue Details (XML | Word | Printable)

Key: CORE-5534
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Trace and engine do not show some detalization in reply on 'DELETE FROM MON$STATEMENTS' (4.0 only affected)

Created: 08/May/17 11:19 PM   Updated: 08/May/17 11:19 PM
Component/s: Engine, SVCMGR, TRACEMGR
Affects Version/s: 4.0 Initial
Fix Version/s: None

File Attachments: 1. File delete-from-mon_statements_302_vs-400_-_trace-and-console.7z (1 kB)


QA Status: No test


 Description  « Hide
Create two databases, one in 3.0.2 and second in 4.0.
Run following scenario on each of them:

1) launch ISQL and give it to execute script:
===
recreate view v_mons as
select
    mon$statement_id as sttm_id,
    mon$state as state_id,
    mon$stat_id as stat_id,
    mon$sql_text as sql_txt
from mon$statements
where mon$attachment_id != current_connection
;

recreate table test(id int primary key);
commit;
insert into test(id) values(1);

set term ^;
execute block as
begin
    execute statement ('insert into test(id) values(?)') (1)
    on external
        rdb$get_context('SYSTEM','DB_NAME')
        as user current_user
           password 'masterkey'
           role right(uuid_to_char(gen_uuid()),12)
    ;
end
^
set term ;^
===
(ISQL will fall into infinite pause thus we can do another thisng - see below)

2) launch in 2nd window trace with following config:
===
database = %[\\/]security4.fdb
{
  enabled = false
}

database = #((%[\\/](e40).fdb)|(e40))
{
  enabled = true
  time_threshold = 0
  log_initfini = false

  log_statement_finish = true

  log_errors = true
  max_sql_length = 16300

}
===

3) run in 3rd window following:

echo set count on; delete from v_mons;|C:\MIX\firebird\fb40\isql /:e40

Console output and trace content in 4.0 is valuable shorter (and contains less info) comparing to 3.0.2 -- see attached .7z
Checked on WI-V3.0.2.32708 & WI-T4.0.0.633, mode = Classic & Super.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.