bug in mysqlcc

this is not a fatal bug, just a logic error in mysqlcc. i am using the
0.8.7-alpha version of mysqlcc.

if you make a change to a field in a table where the primary key is of
type 'double', ALL records in the table will be updated to the new field
value.

when i want to do this sort of update in the mysql console, i would send
an SQL command something like this:

UPDATE my_table SET my_string_field =3D 'new value' WHERE
ID_which_is_a_double LIKE '46235.2412583';

in other words, instead of using the equality operator, i do a string
comparison with LIKE. i dont know of a better way.

-Ian


-\________________________________________________
Ian Katz (xDSL) - ikatz@iol.unh.edu / 603-862-1697

"The one who says it cannot be done
should not interrupt the one who is doing it."
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ¯¯¯¯=AF=
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ¯¯=AF\-

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

Re: bug in mysqlcc

Hi!

This bug was fixed in 0.9.0. The current release is 0.9.1

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: "Ian Katz"
To:
Sent: Saturday, April 05, 2003 3:16 PM
Subject: bug in mysqlcc



this is not a fatal bug, just a logic error in mysqlcc. i am using the
0.8.7-alpha version of mysqlcc.

if you make a change to a field in a table where the primary key is of
type 'double', ALL records in the table will be updated to the new field
value.

when i want to do this sort of update in the mysql console, i would send
an SQL command something like this:

UPDATE my_table SET my_string_field = 'new value' WHERE
ID_which_is_a_double LIKE '46235.2412583';

in other words, instead of using the equality operator, i do a string
comparison with LIKE. i dont know of a better way.

-Ian


-\________________________________________________
Ian Katz (xDSL) - ikatz@iol.unh.edu / 603-862-1697

"The one who says it cannot be done
should not interrupt the one who is doing it."
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯\-

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=sinisa@cytanet.com.cy







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