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
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.10a
• OS: NT
• CPU Architecture: Any

[12 Aug 2005 20:08] Ran Hartal

Description:
Not exactly a bug , looks like a core small glitch , i was trying to run a procedure
directly at startup initial file and noticed that it doesnt excepts the call to procedures so eventually the stored procedure doesnt run at all .

How to repeat:
Simply include a call statment to a stored procedure in
init_file="C:/workshop/sql/sp/init.sql"
on my.ini

[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>