Bug #44271 InnerException {"Parameter '@xxxxx' must be defined."}

• Submitted: 14 Apr 2009 17:36
• Modified: 17 Apr 2009 7:29
• Reporter: mark shen
• Status: Can't repeat
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: 6.0.2.0
• OS: Any
• CPU Architecture: Any
• Tags: bug, C#, connector, MySQL, Parameter

[14 Apr 2009 17:36] mark shen

Description:
this should be the same bug that affected Mysql Connector/NET 1.0 ( http://bugs.mysql.com/bug.php?id=7022 )

How to repeat:
Executing a SQL query with a '?' OR a '@' inside the text

[16 Apr 2009 6:11] Tonci Grgin

Hi Mark and thanks for your report.

It is expected for alpha version to have problems but what effectively prevented me from checking this one is bug reported by me Bug#44141.

[17 Apr 2009 7:29] Tonci Grgin

Mark, I am sorry but there is no way I can repeat this behavior unless you manage to put up correct test case showing this behavior...

I used modified test case for Bug#44318 with:
cmdCreateTable.CommandText = "UPDATE bug44318 SET Col1=1549,Col2='text -- pero ? lets see ' WHERE Col1=1";
cmdCreateTable.CommandText = "UPDATE bug44318 SET Col1=1549,Col2='text -- pero ?lets see ' WHERE Col1=1";
cmdCreateTable.CommandText = "UPDATE bug44318 SET Col1=1549,Col2='text -- pero ? ' WHERE Col1=1";
cmdCreateTable.CommandText = "UPDATE bug44318 SET Col1=1549,Col2='text -- pero ?' WHERE Col1=1";
cmdCreateTable.CommandText = "UPDATE bug44318 SET Col1=1549,Col2='text -- pero? ' WHERE Col1=1";
and so on, all passes.

I tried it with @ too:
[17.4.2009 9:26:06] - Executing command QUERY with text ='UPDATE bug44318 SET Col1=1549,Col2='text -- pero @ lets see ' WHERE Col1=1'
The thread 0xf4 has exited with code 0 (0x0).

So please, next time, attach full test case demonstrating unwanted behavior as this is not fair to others for me to spend time varying spaces and question marks trying to guess what you did.

Environment:
  W2K8SE x64, .NET FW 3.5, VS2008Pro, remote MySQL server 5.1.31 on OpenSolaris 2008.11 x64 host. c/NET 6.0.2, Rev 1559 of trunk.