Bug #9758 error in SP that retrives data from a view

• Submitted: 8 Apr 2005 13:31
• Modified: 18 May 2005 1:26
• Reporter: Vadim Tkachenko
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.3-beta
• OS: Windows (WinXP SP2)
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[8 Apr 2005 13:31] Vadim Tkachenko

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)

[14 May 2005 8:50] Bugs System

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

[17 May 2005 15:08] Bugs System

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

[18 May 2005 1:26] Paul DuBois

Noted in 5.0.6 changelog.