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 145180 - Bad script is shown for DELETE with custom query
Summary: Bad script is shown for DELETE with custom query
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: PC Linux
: P3 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-26 16:28 UTC by Roman Mostyka
Modified: 2008-08-28 17:54 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
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 Roman Mostyka 2008-08-26 16:28:00 UTC 
1. Connect to "travel" Java DB and open SQL Editor.
2. Execute following statement:
"select p.NAME, p.JOBTITLE from PERSON p;"
3. Rightclick some row and choose "Show SQL Script for DELETE".

Result: Script is shown:
DELETE FROM TRAVEL.PERSON WHERE ;
It will be better to disable this item in context menu for such cases.
Comment 1 _ ahimanikya 2008-08-28 10:47:04 UTC 
http://hg.netbeans.org/main/rev/3955eec072c0
Comment 2 Roman Mostyka 2008-08-28 14:00:51 UTC 
Verified with build 080828.
Comment 3 Quality Engineering 2008-08-28 17:54:41 UTC 
Integrated into 'main-golden', available in build *200808281401* on http://bits.netbeans.org/dev/nightly/
Changeset: http://hg.netbeans.org/main/rev/3955eec072c0
User: ahimanikya@netbeans.org
Log: #145180 Bad script is shown for DELETE with custom query