[Firebird-devel] [FB-Tracker] Created: (CORE-4370) Trace does NOT display output if its config contains EXCLUDE_FILTER=%(SELECT)% and execute block with COMMENTED 'select' is running

[Pavel Zotov (JIRA)]

Trace does NOT display output if its config contains EXCLUDE_FILTER=%(SELECT)% 
and execute block with COMMENTED 'select' is running
-----------------------------------------------------------------------------------------------------------------------------------

                 Key: CORE-4370
                 URL: http://tracker.firebirdsql.org/browse/CORE-4370
             Project: Firebird Core
          Issue Type: Bug
          Components: TRACEMGR
    Affects Versions: 3.0 Alpha 2
            Reporter: Pavel Zotov


My trace config:

database = # (%[\\/](sqlex30|oltp30|%test%).fdb)|(sqlex30%|oltp30|%test%)
{
  enabled = true
  log_sweep = true
  log_errors = true

  ####################   A C H T U N G  ##############
  time_threshold = 0
  #connection_id=308
  exclude_filter = %(SELECT)%
  ####################################################
  log_context = true
  log_connections = true
  log_transactions = true

#  log_statement_prepare = true
#  log_statement_start = true
#  log_statement_free = true
  log_trigger_start = true
#  log_procedure_start = true

  log_statement_finish = true
#  log_procedure_finish = true
  log_trigger_finish = true

  print_plan = true
  print_perf = true
  max_sql_length = 16384
  max_log_size = 9999999999
  #log_filename = /opt/fb30cs/ztrace.log
}


#database = %[\\/](test|azk2|rulez).fdb
#{
#  enabled = true
#  log_filename = \1.log
#}

// please note on:  exclude_filter = %(SELECT)%

Then I run the following execute blocks:

== var 1 == ( this is OK, trace *WILL* show output for this EB):
execute block
as
begin
  insert into t values( 1 );
end


== var 2 == (this one contains COMMENTED 'select' statement):
execute block
as
begin
  insert into t values( 1 );
  -- for select id from t group by id into id do suspend;
end

- NOT OUTPUT in trace console.

-- 
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

        

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel