- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; "wangxu" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent: Friday, January 20, 2006 2:20 AM
Subject: Re: question about "CONTAINS SQL"
SQL and see what happens at runtime. If it
> >fails, as I strongly expect, change CONTAINS SQL to MODIFIES SQL
> >DATA and your error will almost certainly go away.
>
> No, these characteristics are merely advisory. The server doesn't
> impose any restraints based on t
tics are merely advisory. The server doesn't
impose any restraints based on them.
Rhino
- Original Message - From: "wangxu" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Thursday, January 19, 2006 2:54 AM
Subject: Re: question about &qu
;.
>
> Of course the best way to be sure is to try this for yourself. Try the
> routine with CONTAINS SQL and see what happens at runtime. If it fails, as I
> strongly expect, change CONTAINS SQL to MODIFIES SQL DATA and your error
> will almost certainly go away.
&
uot; <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Thursday, January 19, 2006 2:54 AM
Subject: Re: question about "CONTAINS SQL"
If I create a routine with modification operation and not spectify
characteristic in CONTAINS SQL | NO SQL | READS SQL DATA
5 AM
Subject: Re: question about "CONTAINS SQL"
But what is INSERT OR UPDATE need?
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>;
Sent: Tuesday, January 17, 2006 9:49 PM
Re: question about "CON
But what is INSERT OR UPDATE need?
> - Original Message -
> From: "Rhino" <[EMAIL PROTECTED]>
> To: "wangxu" <[EMAIL PROTECTED]>;
> Sent: Tuesday, January 17, 2006 9:49 PM
> Re: question about "CONTAINS SQL"
>
>
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 17, 2006 12:35 AM
Subject: question about "CONTAINS SQL"
I notice there are one section in the manual:
CONTAINS SQL indicates that the routine does not contain statements that
read or write data.