List:General Discussion« Previous MessageNext Message »
From:(Hal Date:December 14 2011 4:58am
Subject:Re: SQL DATA
View as plain text  
>>>> 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.

SQL DATAhsv5 Dec
  • Re: SQL DATAMySQL)13 Dec
    • Re: SQL DATAhsv14 Dec
Re: SQL DATAhsv8 Dec
Re: SQL DATAhsv10 Dec
  • Re: SQL DATASinger X.J. Wang13 Dec
Re: SQL DATAhsv10 Dec
  • Re: SQL DATAArthur Fuller13 Dec
    • Re: SQL DATASinger X.J. Wang13 Dec