Bug #11616 | A prepared query crashes libmysql.dll in mysql 5.0 | ||
---|---|---|---|
Submitted: | 28 Jun 2005 17:32 | Modified: | 28 Jun 2005 17:49 |
Reporter: | D SW | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | mysql 5.0 beta | OS: | Windows (Windows XP Professional SP2) |
Assigned to: | CPU Architecture: | Any |
[28 Jun 2005 17:32]
D SW
[28 Jun 2005 17:49]
MySQL Verification Team
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html Additional info: Prepare is not more allowed in stored procedures: c:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.9-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> delimiter // mysql> drop procedure if exists siscontrol.listado_clientes // Query OK, 0 rows affected, 1 warning (0.09 sec) mysql> create procedure listado_clientes -> ( -> out resultado tinyint -> ) -> begin -> -> set @qry = concat('select * from', ' clientes where dni=?'); -> -> prepare strQuery from @qry; -> set @a = '123456789' ; -> execute strQuery using @a; -> -> deallocate prepare strQuery; -> -> -- select found_rows() into resultado; -> -> end // ERROR 1314 (0A000): PREPARE is not allowed in stored procedures mysql> mysql> delimiter ; mysql>
[28 Jun 2005 19:29]
D SW
Thanks for your answer. Now.... I will have to look for another way to execute a "dynamic" queries. He he he :-D Bye's ;-)