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 Email Updates:
Status: Closed Impact on me:
None 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.