|
Replies:
1
-
Pages:
1
-
Last Post:
Mar 11, 2010 8:03 AM
by: Ernest
|
|
|
Posts:
1
Registered:
3/11/10
|
|
|
|
CREATE Stored Procedure BUG
Posted:
Mar 11, 2010 12:42 AM
|
|
|
Hi,
When you try to create stored procedure like this :
CREATE PROCEDURE test (IN id INT) BEGIN set @STATUS=0; END;
which consists @STATUS (variable), 5.0.0.157 fails with the following message : Category Timestamp Duration Message Line Position
Error 3/11/2010 10:19:48 AM 0:00:00.563 MySQL Database Error: Fatal error encountered during command execution. 1 0
P.S. : Release version works O.K with variables
Regards,
Igor.
|
|
|
|
|
|
|
Re: CREATE Stored Procedure BUG
Posted:
Mar 11, 2010 8:03 AM
in response to: igor.fld_890
|
|
|
Hi Igor,
I did test this sp in ver.4.6 and it runs without any problem in my PC. You set the system variable @status properly to 0.
Thanks
Ernest Bonat, Ph.D.
President | Visual WWW, Inc.
Cell:503.730.4556 | Fax:503.715.4888
ebonat@evisualwww.com | www.evisualwww.com
Visual WWW is an Open Source Application
Development and Training Shop
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
