MySQL Bugs: #16246: Does not return any value

Bug #16246	Does not return any value
Submitted:	6 Jan 2006 7:03	Modified:	28 May 2013 12:34
Reporter:	jayson pascual	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:		OS:	Windows (Windows XP SP2)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
I'm using Visual Basic 6 w/ SP6 for my front-end. when I request a query in MySQL(4.1.16) using MyODBC(3.51.12) it return a query result. 
However when I upgrade to MySql(5.0.15) it return no query result.
This is my code:

ssql = "SELECT  SUM(TLCA.Tamount) AS tl_amount, TLIL.class AS tl_class, " _
    & " SUM(TLCA.qty) AS tl_qty FROM tblitemlist AS TLIL, tblcustomerarticles AS TLCA " _
    & "WHERE TLCA.cashier = '" & P_CashierName & "' and TLCA.tdate = '" & strDate & "'" _
    & " and TLIL.itemcode = TLCA.itemcode " _
    & "GROUP BY TLIL.class " _
    & "ORDER BY TLIL.class "

I'm using reference for ADO

How to repeat:
I'm using Visual Basic 6 w/ SP6 for my front-end. when I request a query in MySQL(4.1.16) using MyODBC(3.51.12) it return a query result. 
However when I upgrade to MySql(5.0.15) it return no query result.
This is my code:

ssql = "SELECT  SUM(TLCA.Tamount) AS tl_amount, TLIL.class AS tl_class, " _
    & " SUM(TLCA.qty) AS tl_qty FROM tblitemlist AS TLIL, tblcustomerarticles AS TLCA " _
    & "WHERE TLCA.cashier = '" & P_CashierName & "' and TLCA.tdate = '" & strDate & "'" _
    & " and TLIL.itemcode = TLCA.itemcode " _
    & "GROUP BY TLIL.class " _
    & "ORDER BY TLIL.class "

I'm using reference for ADO

Could you please start the server using the key option log and run your
application, then stop the server and see in the log file the query which
was sent to the server. Also see the log error file for messages.

Thanks in advance.

I have exactly the sam problem using the same versions as you. 
The time it takes to executing the query from th VB app is the same as when i run it from the QueryBrowser so it seems that MySQL server is executing the query as it should. 
However it is not returning any data in then VB app, only when running in in the QueryBrowser.

I have MyODBC 3.51.12 and as I read in other thread, the fix should have been  implemented in this version. But the problem is still there.

/P

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".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.