Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
firebird-automations opened this issue May 9, 2017 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Attachments:
delete-from-mon_statements_302_vs-400_-_trace-and-console.7z

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: delete-from-mon_statements_302_vs-400_-_trace-and-console.7z [ 13113 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant