MySQL Bugs: #26995: Recordset Does Not Select the Value from View in MySQL 5.0.16-nt

Bug #26995	Recordset Does Not Select the Value from View in MySQL 5.0.16-nt
Submitted:	9 Mar 2007 12:20	Modified:	10 May 2007 16:05
Reporter:	Muthu K	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S2 (Serious)
Version:	5.0.16-nt	OS:	Windows (Win XP)
Assigned to:		CPU Architecture:	Any

Description:
hi i am using asp mysql, and when i was opened the recordset using  from the following view:-

view-1:-
CREATE VIEW emp_performance AS
select
report_by AS Name,
report_date AS Date,
count(call_alot_id) AS Total
from service_call_reports 
group by report_by,report_date

view-2:-
REATE  VIEW view_emp_performance AS
select
Name,
count(Date) AS Days,
sum(Total) AS Total,
round((sum(Total) / count(Date)),2) AS Rank
from emp_performance
group by Name
order by rank desc limit 0,20;

when i was open the recordset the recodset will be returned empty.
but the same time the query will executed in query browser and return the
values clearly. plz help me for these task.

regards
muthu

How to repeat:
Recordset Does Not Select the Value from View in MySQL 5.0.16-

hi i am using asp mysql, and when i was opened the recordset using  from the
following view:-

view-1:-
CREATE VIEW emp_performance AS
select
report_by AS Name,
report_date AS Date,
count(call_alot_id) AS Total
from service_call_reports 
group by report_by,report_date

view-2:-
REATE  VIEW view_emp_performance AS
select
Name,
count(Date) AS Days,
sum(Total) AS Total,
round((sum(Total) / count(Date)),2) AS Rank
from emp_performance
group by Name
order by rank desc limit 0,20;

<%
dim cnConn
Set cnConn=server.CreateObject("ADODB.Connection")
set rsRec=server.CreateObject("ADODB.Recordset")

cnConn.Open(Application("cnStr"))
rsStr="Select * from view_emp_performance"

rsRec.Open(rsStr),cnConn,3,3

while not rsRec.EOF
  Response.Write(rsRec("Name"))
  rsRec.MoveNext()
wend
%>

when i was open the recordset the recodset will be returned empty.
but the same time the query will executed in query browser and return the
values clearly. plz help me for these task.

regards
muthu

Thank you for a problem report. Please, try to repeat with a newer version, 5.0.27, and inform about the results.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Feedback is still needed.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".