MySQL Bugs: #23845: Cannot update Decimal values in the Results Set tab

Bug #23845	Cannot update Decimal values in the Results Set tab
Submitted:	1 Nov 2006 17:04	Modified:	1 Nov 2006 17:15
Reporter:	marc castrovinci (Basic Quality Contributor)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.4	OS:	Windows (XP PRO SP2)
Assigned to:		CPU Architecture:	Any
Tags:	decimal, error, result, Result Set, tab, UPDATE

Description:
The error is caused when attempting to update a decimal value by clicking the edit button on the result tab.

It will usually bring up an error that is bogus to what is going on or will display nothing.

How to repeat:
 `test`.CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */;

DROP TABLE IF EXISTS `test`.`tab2`;
CREATE TABLE  `test`.`tab2` (
  `idid` int(10) unsigned NOT NULL auto_increment,
  `idid2` decimal(7,2) default NULL,
  PRIMARY KEY  (`idid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into tab2 values(1,44.40);

Select * from tab2.

Then click the idid2 column and the value 44.40.
Click EDIT at the bottom of the window.
Change the value to 44.46
Click APPLY

It will highlight the section red claiming and error, yet nothing is actually in the error description box.

I've had a decimal next to a date value, and when I tried to update would tell me that '2006-10-10' is not a valid decimal. It almost looks for any reason to display, and then if there is none it will just show nothing at the bottom.

Thank you for a problem report. Sorry, but I was not able to repeat the behaviour described with a newer version, 1.2.5 beta. Works as expected.