MySqlCC 0.8.10-beta, unwanted mass update/delete

Hi!

Bug Report
----------

Version: MySQL Control Center 0.8.10-beta
Summary: Unwanted mass update/delete via result grid if table primary key is double(32,0)
Comment: with int key problem won't occur.

(No need to discuss bad table structure with double type as key, nevertheless mysqlcc bug)

How-To-Repeat:

1. Copy and execute following sql-script in mysqlcc SQL window of some test db:

############################
DROP TABLE IF EXISTS suser;
CREATE TABLE suser (
uid double(32,0) NOT NULL auto_increment,
username varchar(100) NOT NULL default '',
password varchar(64) default NULL,
PRIMARY KEY (uid),
KEY username (username)
) TYPE=MyISAM;
INSERT INTO suser VALUES (155,'abc','abc');
INSERT INTO suser VALUES (156,'def','def');
INSERT INTO suser VALUES (157,'xyz','xyz');

SELECT * FROM suser WHERE username = 'abc';

# update password in grid from abc to 123 --> 3 rows affected! (in fact all rows are affected)

# select single entry and press delete record button in toolbar --> 3 rows deleted! (in fact all rows are deleted)
############################

2. update password in grid from abc to 123 --> 3 rows affected! (in fact all rows are affected)

3. select single entry and press delete record button in toolbar --> 3 rows deleted! (in fact all rows are deleted)

4. re-run script with primary key column uid of type int and problem does not occur.

Caused me quite some trouble when problem happened with more important table/db.

gr, Juergen.

------------------------------------------------------------ ---------
Sent through MailGateway - http://www.ssw.uni-linz.ac.at:2000/
Send AND read your emails EVERYwhere.
------------------------------------------------------------ ---------

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13912@lists.mysql.com
To unsubscribe, e-mail

Re: MySqlCC 0.8.10-beta, unwanted mass update/delete

Hi!

This is now fixed, thanks for the bug-report!

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:
To:
Sent: Thursday, March 06, 2003 4:49 AM
Subject: MySqlCC 0.8.10-beta, unwanted mass update/delete


> Hi!
>
> Bug Report
> ----------
>
> Version: MySQL Control Center 0.8.10-beta
> Summary: Unwanted mass update/delete via result grid if table primary key
is double(32,0)
> Comment: with int key problem won't occur.
>
> (No need to discuss bad table structure with double type as key,
nevertheless mysqlcc bug)
>
> How-To-Repeat:
>
> 1. Copy and execute following sql-script in mysqlcc SQL window of some
test db:
>
> ############################
> DROP TABLE IF EXISTS suser;
> CREATE TABLE suser (
> uid double(32,0) NOT NULL auto_increment,
> username varchar(100) NOT NULL default '',
> password varchar(64) default NULL,
> PRIMARY KEY (uid),
> KEY username (username)
> ) TYPE=MyISAM;
> INSERT INTO suser VALUES (155,'abc','abc');
> INSERT INTO suser VALUES (156,'def','def');
> INSERT INTO suser VALUES (157,'xyz','xyz');
>
> SELECT * FROM suser WHERE username = 'abc';
>
> # update password in grid from abc to 123 --> 3 rows affected! (in fact
all rows are affected)
>
> # select single entry and press delete record button in toolbar --> 3 rows
deleted! (in fact all rows are deleted)
> ############################
>
> 2. update password in grid from abc to 123 --> 3 rows affected! (in fact
all rows are affected)
>
> 3. select single entry and press delete record button in toolbar --> 3
rows deleted! (in fact all rows are deleted)
>
> 4. re-run script with primary key column uid of type int and problem does
not occur.
>
> Caused me quite some trouble when problem happened with more important
table/db.
>
> gr, Juergen.
>
> ------------------------------------------------------------ ---------
> Sent through MailGateway - http://www.ssw.uni-linz.ac.at:2000/
> Send AND read your emails EVERYwhere.
> ------------------------------------------------------------ ---------
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread13912@lists.mysql.com
> To unsubscribe, e-mail
>



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13916@lists.mysql.com
To unsubscribe, e-mail

Re: MySqlCC 0.8.10-beta, unwanted mass update/delete

Hi,

This bug was fixed in MySQLCC 0.9.0!

Thanks for the bug-report.

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:
To:
Sent: Thursday, March 06, 2003 4:49 AM
Subject: MySqlCC 0.8.10-beta, unwanted mass update/delete


> Hi!
>
> Bug Report
> ----------
>
> Version: MySQL Control Center 0.8.10-beta
> Summary: Unwanted mass update/delete via result grid if table primary key
is double(32,0)
> Comment: with int key problem won't occur.
>
> (No need to discuss bad table structure with double type as key,
nevertheless mysqlcc bug)
>
> How-To-Repeat:
>
> 1. Copy and execute following sql-script in mysqlcc SQL window of some
test db:
>
> ############################
> DROP TABLE IF EXISTS suser;
> CREATE TABLE suser (
> uid double(32,0) NOT NULL auto_increment,
> username varchar(100) NOT NULL default '',
> password varchar(64) default NULL,
> PRIMARY KEY (uid),
> KEY username (username)
> ) TYPE=MyISAM;
> INSERT INTO suser VALUES (155,'abc','abc');
> INSERT INTO suser VALUES (156,'def','def');
> INSERT INTO suser VALUES (157,'xyz','xyz');
>
> SELECT * FROM suser WHERE username = 'abc';
>
> # update password in grid from abc to 123 --> 3 rows affected! (in fact
all rows are affected)
>
> # select single entry and press delete record button in toolbar --> 3 rows
deleted! (in fact all rows are deleted)
> ############################
>
> 2. update password in grid from abc to 123 --> 3 rows affected! (in fact
all rows are affected)
>
> 3. select single entry and press delete record button in toolbar --> 3
rows deleted! (in fact all rows are deleted)
>
> 4. re-run script with primary key column uid of type int and problem does
not occur.
>
> Caused me quite some trouble when problem happened with more important
table/db.
>
> gr, Juergen.
>
> ------------------------------------------------------------ ---------
> Sent through MailGateway - http://www.ssw.uni-linz.ac.at:2000/
> Send AND read your emails EVERYwhere.
> ------------------------------------------------------------ ---------
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread13912@lists.mysql.com
> To unsubscribe, e-mail
>
>
>



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