>>>> 2011/12/13 16:10 -0500, Shawn Green (MySQL) >>>> Many of you are missing the big picture. This flag (along with most of the others you can use to describe a stored procedure) are meant to indicate to the replication system whether it needs to log the CALL to this procedure and in which format.
Statements that only collect data (and don't even write to temporary tables) do not need to be written into the binary log. Any stored procedures that change a table, even if it's a temporary table, need to be marked as MODIFIES_SQL_DATA. <<<<<<<< This answers my question! that the flags are for the replicator. I had the idea that they were for the optimizer. In spite of my sharp comments, I know that in general it is impossible to determine whether any program does anything, a reason for the compiler not to enforce the flags on any procedure. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql