Bug #10547 problem with procedures
Submitted: 11 May 2005 12:00 Modified: 11 May 2005 12:06
Reporter: Sedat Onur Orakoglu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5,04 OS:Windows (win 2003)
Assigned to: CPU Architecture:Any

[11 May 2005 12:00] Sedat Onur Orakoglu 
Description:
create procedure prc1()
begin
  create view as view1 select * from table1;
end

/// when i call this procedure mysql gets me the
table 'database.view1' doesn't exist(Error on line (0))
error.

it also get me same error when creating a table instead of view.

How to repeat:
always
[11 May 2005 12:06] MySQL Verification Team 
In your sample you have a syntax error at line:

 create view as view1 select * from table1;

should be:

 create view  view1 as select * from table1;