List:General Discussion« Previous MessageNext Message »
From:Alex Katebi Date:May 20 2009 7:28pm
Subject:Re: SOS mysql signal syntax error
View as plain text  
OK I tried this exact syntax and I get the same error. I tried it on mysql
client for 6.0.10

On Wed, May 20, 2009 at 2:22 PM, Gavin Towey <gtowey@stripped> wrote:

> Interesting.  This syntax is only supposed to be available as of 5.4, but
> it doesn't even work there.  The reference I found was at :
> http://dev.mysql.com/tech-resources/articles/mysql-54.html
>
> But I couldn't find other references to the new signal support.
>
> This is listed as the example on that page, but it doesn't work in
> 5.4.0-beta
>
> CREATE PROCEDURE p (divisor INT)
> BEGIN
>  DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012';
>  IF divisor = 0 THEN
>  SIGNAL divide_by_zero;
> END IF;
> END
>
> Methinks someone forgot to include this feature in the release!
>
>
> -----Original Message-----
> From: Alex Katebi [mailto:alex.katebi@stripped]
> Sent: Wednesday, May 20, 2009 10:58 AM
> To: mysql
> Subject: SOS mysql signal syntax error
>
> Hi Folks,
>
>  I am getting syntax error with the mysql signal. I have a trigger
> that needs a signal for raising an error condition if a row with
> specific value  is removed.
>
>  CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl
>  FOR EACH ROW BEGIN
>  DECLARE mysig CONDITION FOR SQLSTATE '45000';
>  IF OLD.name = 'base' THEN
>     SIGNAL mysig SET MESSAGE_TEXT='base row removal is not allowed';
>  END IF;
>  END
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s)
> named above. If you are not the intended recipient, you are hereby notified
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipient,
> please contact the sender by reply email and destroy all copies of the
> original message.
>

Thread
SOS mysql signal syntax errorAlex Katebi20 May
  • RE: SOS mysql signal syntax errorGavin Towey20 May
    • Re: SOS mysql signal syntax errorAlex Katebi20 May