MySQL Bugs: #10552: problem with procedures

Bug #10552	problem with procedures
Submitted:	11 May 2005 12:36	Modified:	11 May 2005 14:29
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
create procedure prc1()
begin
  create view1 view as  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:
allways

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

Syntax error:

create view .....