List:General Discussion« Previous MessageNext Message »
From:(Hal Date:December 9 2011 11:58pm
Subject:Re: SQL DATA
View as plain text  
;>>> 2011/12/08 10:21 -0500, Singer X.J. Wang >>>>
But again one of the flags are binding in any way. There's nothing preventing me from
declaring my procedure

    * READS SQL DATA indicates that the routine contains statements that read data (for
example, <http://dev.mysql.com/doc/refman/5.0/en/select.html>SELECT), but not
statements that write data. 
And then have it write data.. 
<<<<<<<<
Which is to say, it is not good for much, not for the optimizer, either? Someone else
suggested that the optimizer does not look inside procedures, at most at the flags. Well,
which is it? 

Thread
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