This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 239301 - show sql script for update shows extra wrong queries
Summary: show sql script for update shows extra wrong queries
Status: RESOLVED DUPLICATE of bug 238487
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 7.4
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-10 09:29 UTC by inkognito26
Modified: 2014-01-18 12:43 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
before sorting (384.70 KB, image/jpeg)
2013-12-10 09:50 UTC, inkognito26 		Details
same table sorted by name (435.64 KB, image/jpeg)
2013-12-10 09:51 UTC, inkognito26 		Details
edited first row only and it writes on sescond also (386.50 KB, image/jpeg)
2013-12-10 09:54 UTC, inkognito26 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description inkognito26 2013-12-10 09:29:09 UTC 
i had found a similar bug post but cannot locate it anymore that was very similar about the "show sql script for insert"

What happens is this, while i am viewing a result after a select if i change the sorting to another column and start manually editing fields, the show sql script for update is showing the correct edits plus some wrong added ones.

If you change the sorting and edit just one row the show sql script for update brings back 2 rows.

First time i hurt my table cause i edited multiple rows and it wasnt obvious that there where more rows added.
Comment 1 Libor Fischmeistr 2013-12-10 09:32:01 UTC 
Hello, thank you for the report. The screenshot would be helpful.
Comment 2 inkognito26 2013-12-10 09:50:00 UTC 
Created attachment 143000 [details]
before sorting

a test table before sorting with name column
Comment 3 inkognito26 2013-12-10 09:51:10 UTC 
Created attachment 143001 [details]
same table sorted by name
Comment 4 inkognito26 2013-12-10 09:54:21 UTC 
Created attachment 143002 [details]
edited first row only and it writes on sescond also

in this case i dont have to press the show sql script for update cause its obvious that it also wrote on the second row..i did not edit the second row, as soon as i started typing inside the big car parts , big network systems was replaced with what i was typing in the first row
Comment 5 matthias42 2014-01-18 12:43:31 UTC 
Reproducible in 7.4, fixed in core-main build (upcoming 8.0). This looks like a duplicate of bug 238487, so closing as such.

*** This bug has been marked as a duplicate of bug 238487 ***