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 [at] lists.mysql.com
To unsubscribe, e-mail <bugs-unsubscribe [at] lists.mysql.com>
