Trace and engine do not show some detalization in reply on 'DELETE FROM
MON$STATEMENTS' (4.0 only affected)
-----------------------------------------------------------------------------------------------------------
Key: CORE-5534
URL: http://tracker.firebirdsql.org/browse/CORE-5534
Project: Firebird Core
Issue Type: Bug
Components: Engine, SVCMGR, TRACEMGR
Affects Versions: 4.0 Initial
Reporter: 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
