Bug #44271 InnerException {"Parameter '@xxxxx' must be defined."}
Submitted: 14 Apr 19:36 Modified: 17 Apr 9:29
Reporter: mark shen
Status: Can't repeat
Category:Connector/Net Severity:S1 (Critical)
Version:6.0.2.0 OS:Any
Assigned to: Target Version:
Tags: Parameter, bug, C#, connector, MySQL

[14 Apr 19: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 8: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 9: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.