heidisql / Tickets / #2608 WHERE clause with broken decimals in grid updates

#2608 WHERE clause with broken decimals in grid updates

Status: Fixed

Owner: nobody

Labels: None

Priority:

Benefits:

Severity: Broken

Component:

Feasibility:

Type: Defect

Updated: 2012-02-12

Created: 2011-11-15

Creator: Anonymous

Private: No

Originally created by: igavi...@gmail.com

What exact steps will reproduce the problem?
1. Create table with field LINEA Decimal (5,1) collation utf8_general_ci
2. Update table with grid
3. The UPDATE SQL no format the field Decimal

What was the expected output?
UPDATE `rossplantilla` SET `documento`='CASHMONEDASSA' WHERE `linea`=63.0

What happened instead?
UPDATE `rossplantilla` SET `documento`='CASHMONEDASSA' WHERE `linea`=630

Suggested fix (optional)?
View fix issue 3962

Version used?
HeidiSQL revision: 6.0.0.3966
MySQL Server version: 5.1.53
Operating system: Windows XP

Related

Tickets: ~~#2608~~
Tickets: ~~#2867~~

Discussion

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2011-11-15

Originally posted by: a...@anse.de

What did you put into the field? I can't revert [r3962] to fix this problem while breaking again issue #2558.

Status: WontFix

Related

Commit: [r3962]
Tickets: ~~#2558~~

*Originally posted by:* [a...@anse.de](http://code.google.com/u/109183940118681839166/) What did you put into the field? I can't revert [r3962] to fix this problem while breaking again [issue #2558](#2558). **Status:** WontFix

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2011-11-16

Originally posted by: igavi...@gmail.com

With MYSQL and regional settings spanish (decimal point is ,), when update a field with decimals in grid, the UPDATE trim the ,. Sample:

Campo1 (Decimal (5,1)), value 2.4 when update the sentence is UPDATE `prueba` SET `campo1`=2.4 WHERE `campo1`=23 AND `texto`='prueba' LIMIT 1;

and generate error 0 rows update when that sould havee been 1, see error.jpg

*Originally posted by:* [igavi...@gmail.com](http://code.google.com/u/100671283695010832505/) With MYSQL and regional settings spanish \(decimal point is ,\), when update a field with decimals in grid, the UPDATE trim the ,. Sample: Campo1 \(Decimal \(5,1\)\), value 2.4 when update the sentence is UPDATE \`prueba\` SET \`campo1\`=2.4 WHERE  \`campo1\`=23 AND \`texto\`='prueba' LIMIT 1; and generate error 0 rows update when that sould havee been 1, see error.jpg

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

Error.jpg

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2011-11-16

Originally posted by: igavi...@gmail.com

Sorry, the previous value of Campo1 is 2.3 the new value is 2.4 (in Grid), the SQL generate by HeidiSQL is:

UPDATE `prueba` SET `campo1`=2.4 WHERE `campo1`=23 AND `texto`='prueba' LIMIT 1;

the correct SQL should be

UPDATE `prueba` SET `campo1`=2.4 WHERE `campo1`=2.3 AND `texto`='prueba' LIMIT 1;

Thanks

*Originally posted by:* [igavi...@gmail.com](http://code.google.com/u/100671283695010832505/) Sorry, the previous value of Campo1 is 2.3 the new value is 2.4 \(in Grid\), the SQL generate by HeidiSQL is: UPDATE \`prueba\` SET \`campo1\`=2.4 WHERE  \`campo1\`=23 AND \`texto\`='prueba' LIMIT 1; the correct SQL should be UPDATE \`prueba\` SET \`campo1\`=2.4 WHERE  \`campo1\`=2.3 AND \`texto\`='prueba' LIMIT 1; Thanks

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2011-11-16

Originally posted by: a...@anse.de

Ah, so the WHERE clause is now broken, not the SET clause. Will check that.

Summary: SET clause with broken decimals in grid updates
Labels: Severity-Broken
Status: Accepted

*Originally posted by:* [a...@anse.de](http://code.google.com/u/109183940118681839166/) Ah, so the WHERE clause is now broken, not the SET clause. Will check that. **Summary:** SET clause with broken decimals in grid updates **Labels:** Severity-Broken **Status:** Accepted

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2011-11-26

Originally posted by: a...@anse.de

(No comment was entered for this change.)

Summary: WHERE clause with broken decimals in grid updates

*Originally posted by:* [a...@anse.de](http://code.google.com/u/109183940118681839166/) *\(No comment was entered for this change.\)* **Summary:** WHERE clause with broken decimals in grid updates

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2012-02-07

Originally posted by: igavi...@gmail.com

Hello,

Is there any date to solve the bug 2608 (2011/11/16).
Thanks for your great work

Related

Tickets: ~~#2608~~

*Originally posted by:* [igavi...@gmail.com](http://code.google.com/u/100671283695010832505/) Hello,    Is there any date to solve the [bug 2608](#2608) \(2011/11/16\).    Thanks for your great work

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "tickets Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Tickets"

Anonymous - 2012-02-12

Originally posted by: a...@anse.de

This issue was closed by revision [r4047].

Status: Fixed

Related

Commit: [r4047]

*Originally posted by:* [a...@anse.de](http://code.google.com/u/109183940118681839166/) This issue was closed by revision [r4047]. **Status:** Fixed

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link: