MySqlCC Bug: Strange auto where clause - WHERE ABS(`id` - `id`) < 1e-031

------=_NextPart_000_000F_01C304E1.5E41D030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a pretty irritating bug going on in a couple of my databases. =20
When I try to edit a value in a particular cell for a record, it copies=20
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=20
cell and it has put:
UPDATE `glbudgets`
SET `mar`=3D-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

------=_NextPart_000_000F_01C304E1.5E41D030--

Re: MySqlCC Bug: Strange auto where clause - WHERE ABS(`id` - `id`) < 1e-031

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
/ /|_/ / // /\ \/ /_/ / /__ 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"
To:
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



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org