Hi Rick, I have installed binary alpha 5.0 for Linux x86. And I am able to create stored procs. But I found couple problems with stored procs: 1. I have stored proc sp_GetData(param char(31)). When I call stored proc first time (with any parameter) it works just fine, but if I change parameter to param2 and rerun it then it returns me empty resultset. I have tried to call sp with param2 after reconnection to MySQL, and it works perfect. 2. Sometimes MySQL server crashed when I call sp_GetData.
Sorry for bad description of the problems. I am still working on getting repeatable case. Mikhail. ----- Original Message ----- From: "Rick Robinson" <[EMAIL PROTECTED]> To: "'Mikhail Entaltsev'" <[EMAIL PROTECTED]>; "'Mysql'" <[EMAIL PROTECTED]> Sent: Tuesday, December 30, 2003 2:27 AM Subject: RE: 5.0 binary question Hi Mikhail- Thanks for responding; the presentation is very helpful; However, I think I may not have been clear enough - I was asking whether the binary alpha 5.0 that is now available from the web site had stored procedure support. I don't think it does as I don't see a catalog table mysql.proc defined and I cannot create any procedures. It's a little odd that 5.0 would be made available as a binary without the primary feature to exercise built into it. Oh well. I still feel like I'm missing something because that just doesn't make sense. Regards, R -----Original Message----- From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED] Sent: Monday, December 29, 2003 7:18 PM To: [EMAIL PROTECTED]; Mysql Subject: Re: 5.0 binary question Hi, I have found slides show http://mysql.progen.com.tr/events/uc2003/slides/stored-procedures.pdf and examples in mysql-5.0/mysql-test/t/ - sp.test - sp-error.test Best regards, Mikhail. ----- Original Message ----- From: "Rick Robinson" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Tuesday, December 30, 2003 12:14 AM Subject: 5.0 binary question > I downloaded the 5.0 preview alpha binary for Win32 and installed it - > so far, so good. But I don't see anything in the doc on the stored > procedure capability (how-to/syntax) and I can't create one within 5.0 > (using SQL99 syntax - at least I think/hope so). Is stored procedure > capability not available in the provided binaries (maybe it's only in > the source tree?)? Just want to make sure I'm not missing something. > > Thanks, > Rick > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
