Bug #10567 problem with procedures

• Submitted: 12 May 2005 6:05
• Modified: 9 Sep 2005 20:59
• Reporter: Sedat Onur Orakoglu
• Status: Can't repeat
• 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>