You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: