Bug #12558 | SQL init script cannot run stored procedures & call statments | ||
---|---|---|---|
Submitted: | 12 Aug 2005 20:08 | Modified: | 22 Aug 2005 17:18 |
Reporter: | Ran Hartal | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.10a | OS: | NT |
Assigned to: | CPU Architecture: | Any |
[12 Aug 2005 20:08]
Ran Hartal
[13 Aug 2005 18:12]
Jorge del Conde
Thanks for your bug report. Verified w/5.0.11
[13 Aug 2005 18:13]
Jorge del Conde
Tested under WinXP SP2
[22 Aug 2005 17:18]
MySQL Verification Team
I was unable to repeat this issue with current Windows BK server: mysql> create table test1 (id int); Query OK, 0 rows affected (0.11 sec) mysql> delimiter // mysql> create procedure p () -> begin -> insert into test1 values (1); -> end // Query OK, 0 rows affected (0.09 sec) mysql> call p(); -> // Query OK, 1 row affected (0.05 sec) mysql> select * from test1; -> // +------+ | id | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> exit Bye c:\mysql\bin>mysqladmin shutdown -uroot c:\mysql\bin>type c:\my.ini [mysqld] init_file=c:/db.sql c:\mysql\bin>type c:\db.sql use db; call p(); c:\mysql\bin>mysql -uroot db Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.12-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from test1; +------+ | id | +------+ | 1 | | 1 | +------+ 2 rows in set (0.00 sec) mysql>