MySQL Bugs: #9758: error in SP that retrives data from a view

Bug #9758	error in SP that retrives data from a view
Submitted:	8 Apr 2005 15:31	Modified:	18 May 2005 3:26
Reporter:	Vadim Tkachenko
Status:	Closed
Category:	Server	Severity:	S1 (Critical)
Version:	5.0.3-beta	OS:	Microsoft Windows (WinXP SP2)
Assigned to:	Bugs System	Target Version:

Description:
SP returns error from select * from view:
Error 1017 (HY000): Can't find file: '.\\C:\WINDOWS\TEMP\#sql_638_1.frm'(errno: 22)

I tried with dbpos.tar.gz from:
https://support.mysql.com/view.php?id=5016

then

create procedure vewproc()
begin
select * from vewbills;
end

The first time this runs, again I get the correct data set back.

The second time I run it I get the following message;

Error 1017 (HY000): Can't find file: '.\\C:\WINDOWS\TEMP\#sql_638_1.frm'(errno: 22)

How to repeat:
1. untar dbpos.tar.gz to data dir.
2. create proc 
create procedure vewproc()
begin
select * from vewbills;
end
3.
call dbpos.vewproc();
return 348 rows.

call dbpos.vewproc();
Error 1017 (HY000): Can't find file: '.\\C:\WINDOWS\TEMP\#sql_638_1.frm'(errno: 22)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24891

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24979

Noted in 5.0.6 changelog.