Bug #62063 Using MySQL connector for DOT.NET selecting row numbers fatal error

Submitted: 2 Aug 2011 21:54 Modified: 11 Aug 2011 13:41
Reporter: Josip Zovko Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.4.3.0 OS:Windows
Assigned to: Fernando Gonzalez.Sanchez CPU Architecture:Any

[2 Aug 2011 21:54] Josip Zovko
Description:
I'm trying via Visual Studio run any query that returns row number but all I get is fatal error. Any query  use via MySQL maestro which uses libmysql.dll producing good results on the same table. It seems to me there is a problem with the .net connector.

Example:

SET @rank=0;
SELECT @rank:=@rank+1 AS rank, itemID, COUNT(*) as ordercount
  FROM orders
  GROUP BY itemID
  ORDER BY ordercount DESC;

How to repeat:
By running any query that selects row number.

Example:

SET @rank=0;
SELECT @rank:=@rank+1 AS rank, itemID, COUNT(*) as ordercount
  FROM orders
  GROUP BY itemID
  ORDER BY ordercount DESC;
[4 Aug 2011 16:02] Fernando Gonzalez.Sanchez
Hi Josip,

Can you provide more info on how to reproduce this?
Like stack trace?
[9 Aug 2011 16:38] Fernando Gonzalez.Sanchez
Hi Josip, 

Thanks for the feedback, I was able to reproduce it.

However, this is not a bug, you can make the query work using the parameter AllowUserVariables in the connection string, for example:

new MySqlConnection("server=localhost;User Id=root;database=rowtest;AllowUserVariables=true")

(that flag works as a tip for the parameter binder).
[11 Aug 2011 13:41] Josip Zovko
This connection string flag works :))
Thanks a lot.

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

Page generated in 0.052 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.