Bug #43395 SQL Statements are logged in server query log
Submitted: 4 Mar 2009 23:10 Modified: 4 Mar 2009 23:14
Reporter: Omer Barnir (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version:5.1.30,6.0.5 OS:Any
Assigned to: CPU Architecture:Any

[4 Mar 2009 23:10] Omer Barnir
Description:
According to the MySQL manual - 5.2.3. The General Query Log
   "The general query log is a general record of what mysqld is doing. The server
    writes information to this log when clients connect or disconnect, and it logs
    each SQL statement received from clients."

See http://dev.mysql.com/doc/refman/5.1/en/query-log.html

However with 5.1 and 6.0 server, statements executed by a trigger are logged to the log as well:

Trigger statements are logged weather logging is done to tables or file.

Trigger statements are NOT logged in 5.0 server and the behavior in 5.0 matches the documentation

How to repeat:
Start the server
Log in using the mysql client and execute the following commands:
   create database show_bug;
   use show_bug; 
   create table t1 (i int);
   create table t2 (j int);
   create trigger trg before insert on t1 for each row 
      insert into t2 values (2*new.i);
   insert into t1 values (1);
   select * from t2;

At this point check the master.log file and you will see that the 
it includes:
                       :
                    1 Query     create table t1 (i int)
                    1 Query     create table t2 (j int)
                    1 Query     create trigger trg before insert on t1 for each row insert into t2 values (2*new.i)
                    1 Query     insert into t1 values (1)
                    1 Query     insert into t2 values (2*new.i)   <-- Should not be logged, did not originate from the client
                    1 Query     select * from t2
                        :   

mysql.general_log will include similar output

Suggested fix:
Trigger based statements should not be logged
[20 Mar 2009 1:37] Chuck Bell
See the patch for BUG#43166 for methods to turn on and off the general log.