2 messages in com.mysql.lists.bugsRe: MySqlCC Bug: Strange auto where c...
FromSent OnAttachments
Jon Sander17 Apr 2003 10:00 
Jorge del Conde17 Apr 2003 11:57 
Subject:Re: MySqlCC Bug: Strange auto where clause - WHERE ABS(`id` - `id`) < 1e-031
From:Jorge del Conde (jor@mysql.com)
Date:04/17/2003 11:57:34 AM
List:com.mysql.lists.bugs

Hi!

This is an old mysqlcc bug ... it was fixed in the 0.8.X series. The current version has this problem fixed.

Regards, Jorge

-- For technical support contracts, visit https://order.mysql.com/?ref=mjdc __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <jor@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico <___/ www.mysql.com

MySQL Users Conference and Expo http://www.mysql.com/events/uc2003/

----- Original Message ----- From: "Jon Sander" <jsan@noguska.com> To: <bu@lists.mysql.com> Sent: Thursday, April 17, 2003 11:00 AM Subject: MySqlCC Bug: Strange auto where clause - WHERE ABS(`id` - `id`) < 1e-031

I have a pretty irritating bug going on in a couple of my databases. When I try to edit a value in a particular cell for a record, it copies that value for the entire column (all records). The tables are INNODB. On the SQL History tab I look for the query that updated the particular cell and it has put: UPDATE `glbudgets` SET `mar`=-20.00 WHERE ABS(`id` - `id`) < 1e-031

I have no clue how the where statement was created. Everything is fine except for the where statement. Let me know if you have seen this problem before and how to fix it if possible. Thank you.

Jon Sander