Bug #10567 problem with procedures
Submitted: 12 May 2005 6:05 Modified: 9 Sep 2005 20:59
Reporter: Sedat Onur Orakoglu Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.04 OS:Windows (win 2003)
Assigned to: Konstantin Osipov CPU Architecture:Any

[12 May 2005 6:05] Sedat Onur Orakoglu
Description:
i wrote it before 2 times and they were wrong .
here is a real sample ..

mysql> delimiter //
mysql> create procedure aa()
    -> begin
    -> create view view1 as select * from bu_butceler;
    -> end //
Query OK, 0 rows affected (0.01 sec)

mysql> delimiter ;
mysql> call aa();
ERROR 1146 (42S02): Table 'eskom.view1' doesn't exist
mysql>

How to repeat:
allways
[12 May 2005 11:15] MySQL Verification Team
Verified on Linux and Windows BK source. However I suspect it is duplicate
of bug already reported.

Thank you for the bug report.
[9 Sep 2005 20:59] Konstantin Osipov
I can't repeat the bug against the latest server.
If the problem was in an erroneous error message, it has been solved.

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> delimiter //
mysql> create procedure aa()
    -> begin
    -> create view view1 as select * from bu_butceler;
    -> end // 
Query OK, 0 rows affected (0.04 sec)

mysql> delimiter ; 
mysql> call aa();
ERROR 1146 (42S02): Table 'test.bu_butceler' doesn't exist
mysql> select @@version;
+--------------------------------+
| @@version                      |
+--------------------------------+
| 5.0.13-beta-valgrind-max-debug |
+--------------------------------+
1 row in set (0.00 sec)

mysql>