Bug #44512 Update/delete unreconized command
Submitted: 28 Apr 2009 12:22 Modified: 17 Jun 2009 9:46
Reporter: rabosa Cando Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.0.3 OS:Microsoft Windows (XP SP3)
Assigned to: Reggie Burnett CPU Architecture:Any
Triage: D2 (Serious)

[28 Apr 2009 12:22] rabosa Cando
Description:
When you try to edit the update and delete command provided by the dataset editor suddenly says an error unrecognized @ command

How to repeat:
create a table
Create a dataset from VS2008
Try to edit update/delete comand from the datatable
[28 Apr 2009 13:23] Tonci Grgin
Hi Rabosa and thanks for your report.

Please inspect, for example, under INSERT command "Parameters" array. Does it say @something or ?something? Also, do you allow user variables in your connection string? Thus far I see no evidence there is a bug here.

Please post at least your connection string...
[28 Apr 2009 13:29] Tonci Grgin
Error

Attachment: Bug44512.jpg (image/jpeg, text), 56.66 KiB.

[28 Apr 2009 13:30] Tonci Grgin
Using trunk sources and a specific table I am able to repeat this behavior:
mysql> show create table bug40529\G
*************************** 1. row ***************************
       Table: bug40529
Create Table: CREATE TABLE `bug40529` (
  `Col1` int(10) NOT NULL AUTO_INCREMENT,
  `Col2` int(10) NOT NULL,
  `Col3` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Col1`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

With some other tables it works, can't get better grasp of problem... Toggling user variables on/off makes no difference.
[28 Apr 2009 14:03] rabosa Cando
Insert

Attachment: insert.JPG (image/jpeg, text), 208.19 KiB.

[28 Apr 2009 14:05] rabosa Cando
edit

Attachment: edit.JPG (image/jpeg, text), 200.74 KiB.

[28 Apr 2009 14:05] rabosa Cando
delete

Attachment: delete.JPG (image/jpeg, text), 189.87 KiB.

[28 Apr 2009 14:06] rabosa Cando
parameters update

Attachment: parameter_update.jpg (image/jpeg, text), 213.17 KiB.

[28 Apr 2009 14:09] rabosa Cando
all the pictures above are with the 6.0.3 connector
This is the table i take for reporting the bug, but for me it's in all tables i tryed

create table `maquinaria` (
  `id_maquinaria` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `nom_maquina` varchar(35) NOT NULL DEFAULT '',
  `tipus_maq` smallint(4) NOT NULL DEFAULT '0',
  `matricula` varchar(15) DEFAULT NULL,
  `marca` varchar(30) DEFAULT NULL,
  `model` varchar(30) DEFAULT NULL,
  `tara` int(5) DEFAULT NULL,
  `pma` int(5) DEFAULT NULL,
  `cc` int(4) DEFAULT NULL,
  `cv` int(4) DEFAULT NULL,
  `capacitat` decimal(10,2) DEFAULT NULL,
  `turbo` tinyint(1) DEFAULT NULL,
  `data_compra` date DEFAULT NULL,
  `id_empresa` varchar(5) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_maquinaria`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='[Maquinaria]'
[28 Apr 2009 14:23] rabosa Cando
Update With net connector 5.2.6

Attachment: update_526.jpg (image/jpeg, text), 52.35 KiB.

[28 Apr 2009 14:26] rabosa Cando
check the pictures edit.jpg(6.0.3) and update_526.jpg(5.2.6) i can see a space between the @ and the name
(6.0.3) 
nom_maquina = @ nom_maquina
(5.2.6)
nom_maquina = @nom_maquina

Could be there the error¿?
I tryed to change manualy the commandtext on 6.0.3 but the error persists
[5 May 2009 19:43] C. Moya
What's the solution to this? I've tried it in all kinda of scenerios. 6.0.3 just breaks the Dataset Designer completely.
[6 May 2009 13:44] Tonci Grgin
Well, it is rather new product and has it's problems... We'll see what Reggie has to say.
[5 Jun 2009 20:49] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/75753
[5 Jun 2009 20:50] Reggie Burnett
fixed in 6.0.4
[17 Jun 2009 9:46] Tony Bedford
An entry has been added to the 6.0.4 changelog:

The Data Set editor generated an error when attempting to modify insert, update or delete commands:

Error in WHERE clause near '@'.
Unable to parse query text.