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 - Query Editor: SQL-clause "ORDER BY" is lost after deselecting-selecting DB table columns in Table Panel
Summary: Query Editor: SQL-clause "ORDER BY" is lost after deselecting-selecting DB ta...
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P4 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks: 152776
  Show dependency tree
 
Reported: 2007-11-22 16:34 UTC by _ alexpetrov
Modified: 2008-11-18 13:20 UTC (History)
1 user (show)

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 _ 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