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 111248

Summary: QueryEditor: if all columns are deselected, SQL statement won't be updated by using Diagram pane
Product: obsolete Reporter: _ alexpetrov <alexpetrov>
Component: visualwebAssignee: David Vancouvering <davidvc>
Status: NEW ---    
Severity: blocker CC: romanmostyka
Priority: P4    
Version: 6.x   
Hardware: PC   
OS: All   
Issue Type: DEFECT Exception Reporter:
Bug Depends on:    
Bug Blocks: 152776    

Description _ alexpetrov 2007-07-27 16:49:39 UTC
Mac OS X, j2sdk 1.5.06, build 0707241200
&
Product Version: NetBeans IDE Dev (Build 200707270000) 
Java: 1.6.0_02; Java HotSpot(TM) Client VM 1.6.0_02-b06 System: 
Windows XP version 5.1 running on x86;

1. Connect to DB Derby Travel
2. Use poup menu item "Design Query..." on DB table "Person"
3. In the opened Query Editor deselect all DB table columns either in Diagram pane or in Columns pane.
Result:
- SQL pane still contains the clause FROM "TRAVEL"."PERSON"

4. In the SQL pane use popup menu item "Parse Query".
Result:
- Diagram pane and Columns pane will be empty.

5. In the Diagram pane use popup menu item "Add table", select TRAVEL.PERSON, click "OK".

Result:
- SQL pane won't be updated
- it's impossible to deselect/select any DB table columns in Diagram pane/Columns pane
Comment 1 John Baker 2008-01-12 05:54:09 UTC
If a query is incorrect then add table shouldn't be enabled.  This issue is covered by 113494

Even though "FROM TRAVEL.PERSON" isn't removed from the text pane, the query is still usable after enabling some columns
in the graph pane.

Lowering priority as this is minor issue
Comment 2 Petr Blaha 2008-11-18 13:04:36 UTC
Move visualsqleditor subcomponents below visualweb