MySQL Bugs: #44512: Update/delete unreconized command

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:	Windows (XP SP3)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

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

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

Error

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

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.

Insert

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

edit

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

delete

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

parameters update

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

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]'

Update With net connector 5.2.6

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

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

What's the solution to this? I've tried it in all kinda of scenerios. 6.0.3 just breaks the Dataset Designer completely.

Well, it is rather new product and has it's problems... We'll see what Reggie has to say.

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

fixed in 6.0.4

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.