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 122595

Summary: Query Editor: SQL-clause "ORDER BY" is lost after deselecting-selecting DB table columns in Table Panel
Product: obsolete Reporter: _ alexpetrov <alexpetrov>
Component: visualwebAssignee: David Vancouvering <davidvc>
Status: NEW ---    
Severity: blocker CC: romanmostyka
Priority: P4    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:
Bug Depends on:    
Bug Blocks: 152776    

Description _ alexpetrov 2007-11-22 16:34:57 UTC 
Product Version: NetBeans IDE Dev (Build 200711210000)
Java: 1.6.0_03; Java HotSpot(TM) Client VM 1.6.0_03-b02
System: Windows XP version 5.1 running on x86

1. Connect to DB Derby Travel.
2. Right click on DB table PERSON and use popup menu item "Design Query..."
3. In the Table Panel click on a cell [column "Sort Type" * row "PERSONID"]
   and select an item "Ascending" from a drop-down list.
4. In the Table Panel click on a cell [column "Sort Type" * row "NAME"]
   and select an item "Ascending" from a drop-down list.

Result:
- the SQL-clause "ORDER BY TRAVEL.PERSON.PERSONID ASC, TRAVEL.PERSON.NAME ASC"
  appeared in SQL Query Panel

5. In the Table Panel unmark a checkbox [column "Output" * row "PERSONID"]
   and then mark it again.
6. In the Table Panel unmark a checkbox [column "Output" * row "NAME"]
   and then mark it again.

Result:
- the SQL-clause "ORDER BY TRAVEL.PERSON.PERSONID ASC, TRAVEL.PERSON.NAME ASC"
  disappeared in SQL Query Panel and wasn't restored - now SQL Query Panel and Table Panel
  are not synchronized
Comment 1 David Vancouvering 2007-11-26 19:48:05 UTC 
I can duplicate.  The workaround is reasonable - toggle off and on the "Sort Type" Column and things are back in synch.
Comment 2 John Baker 2008-01-11 09:25:59 UTC 
This is not a common use case and there's a workaround.  Downgrading to P4
Comment 3 Petr Blaha 2008-11-18 13:20:38 UTC 
Move visualsqleditor subcomponents below visualweb