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 151281 - SQL History: Order is not retained after connection changing
Summary: SQL History: Order is not retained after connection changing
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P4 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks: 152828
  Show dependency tree
 
Reported: 2008-10-24 13:56 UTC by Roman Mostyka
Modified: 2012-02-18 20:38 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-10-24 13:56:26 UTC
1. Execute bunch of statements against different connections.
2. Open "SQL History" dialog and order by statements.
3. Change connection in "Connections" drop down list.

Result: Statements aren't ordered.
Comment 1 John Baker 2008-10-27 17:35:56 UTC
Slightly nice to have but this is not really inconvenient for the user - just click the table header to reset the order
Comment 2 Roman Mostyka 2008-10-27 17:44:20 UTC
Yes, workaround exists, but feature works improperly and it can make bad impression of IDE.
And actually it isn't very convenient to change order every time after changing connection. If user tries to find
something with 10 connections it can be very annoying.
And main reason why this is P3: the feature should work properly.
John, can you ask somebody else about their opinion?
Comment 3 John Baker 2008-10-27 18:14:08 UTC
I think you're missing something here.

Selecting a connection will only show those statements executed for that connection (statements that are not executed by
this connection will not be listed.)

By changing the connection again to another connection then again only corresponding statements are listed.

Here's one scenario:

1) Select a connection
Result - statements removed

2) Set the ordering (by statement)

3) Select a different connection
Result - different statements removed and new statements listed

You expect the order to be retained by statement even after changing the connection and new statements appear ?

Comment 4 Roman Mostyka 2008-10-27 18:40:59 UTC
Yes, I expected exactly this. Is it wrong behavior or was it planned different?
Comment 5 John Baker 2008-10-27 18:50:51 UTC
By design, the connection dropdown resets the statements back to the default order setting
Comment 6 John Baker 2008-10-27 19:34:35 UTC
Please vote if you want to see this behavior enhanced.  I'll send a message to the db alias also.
Comment 7 David Vancouvering 2008-10-28 05:14:18 UTC
First of all, I don't think it is common for a user to have say 10 connections open.  Most users are working with only
one connection, and are not hopping about between connections.  I can see this being a common QE scenario, but not a
common user scenario :)

I also see John's point that when you change connections, you get a new set of statements, so going to default ordering
sounds acceptable to me.

According to http://wiki.netbeans.org/BugPriorityGuidelines, a P3 means it is a "highly visible usability problem."  A
P4 is a "minor usability problem."  I believe this is a minor problem, and I am re-prioritizing this to a P4.

Thanks,

David
Comment 8 John Baker 2008-11-21 23:50:22 UTC
No plans to fix in 7.0
Comment 9 Jiri Rechtacek 2009-10-16 14:02:49 UTC
Reassigned to new owner.
Comment 10 matthias42 2012-02-18 20:38:39 UTC
Current behaviour (main-golden) shows the behaviour the orginal reporter asked for. The sort order is constant even if connection is changed.