Re: SQL DATA

2011-12-14 Thread Hal�sz S�ndor
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 form

Re: SQL DATA

2011-12-13 Thread Shawn Green (MySQL)
Hello All, On 12/5/2011 14:20, wrote: A procedure MODIFIES SQL DATA if all the modifying involves a temporary table, or only READS SQL DATA? Does it matter whether the temporary table is meant to outlast the procedure-call? Many of you are missing the big picture. This flag (along with m

Re: SQL DATA

2011-12-13 Thread Singer X.J. Wang
I didn't say anything about recursive optimizations. All I said was the following statement: "When the procedure is executed, each query in the procedure is obviously run through the query optimizer. " 2011/12/13 Arthur Fuller > I am not sure that the db engineers should look into supporting re

Re: SQL DATA

2011-12-13 Thread Arthur Fuller
I am not sure that the db engineers should look into supporting recursive optimizations. That sounds to me like a waste of their time, and conversely an investment in your (my) time. This kind of thing is far too app-specific to generalize into an all-encompassing algorithm, IMO, and even if it cou

Re: SQL DATA

2011-12-13 Thread Singer X.J. Wang
When the procedure is executed, each query in the procedure is obviously run through the query optimizer. But the flags are symbolic only for humans. 2011/12/9 Halász Sándor > ;>>> 2011/12/08 10:21 -0500, Singer X.J. Wang > But again one of the flags are binding in any way. There's nothi

Re: SQL DATA

2011-12-10 Thread Hal�sz S�ndor
2011/12/09 20:37 -0500, Singer X.J. Wang When the procedure is executed, each query in the procedure is obviously run through the query optimizer. But the flags are symbolic only for humans. "Obviously"? As I wrote, someone said that the optimizer does _not_ look into procedur

Re: SQL DATA

2011-12-09 Thread Hal�sz S�ndor
;>>> 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,

Re: SQL DATA

2011-12-08 Thread Hal�sz S�ndor
2011/12/05 14:26 -0500, Singer X.J. Wang Note that all the flags are non binding.. YMMV... Yes, but what does it _mean_? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql