[FB-Tracker] Created: (CORE-5534) Trace and engine do not show some detalization in reply on 'DELETE FROM MON$STATEMENTS' (4.0 only affected)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[FB-Tracker] Created: (CORE-5534) Trace and engine do not show some detalization in reply on 'DELETE FROM MON$STATEMENTS' (4.0 only affected)

JIRA tracker@firebirdsql.org
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