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.
1. Register MySQL server. 2. Create all samples databases. 3. Open SQL History and sort by statements. Result: Sort order is wrong.
Created attachment 69739 [details] Screenshot of wrong order in SQL History.
Sort sorts only by date not statement. It might be nice to sort by statement, but I didn't see a benefit. If you want to group by statement you can just type the first few characters that match some SQL in the match box. Note, issue 138081 suggests to sort by date and other discussions suggested the same, just sort by date. btw the attachment could not be opened (at least on Mac).
I made this screenshot on Mac, but there is no MIME type for tiff in issuezilla, I guess you can download it and then open. But not sure. Anyway you can reproduce this issue by yourself. About issue itself: it is possible to click on statements header and it is expectable that click will do the same as it does for dates. It can mislead customer. And there are benefits, it depends on what is more usual for different people, for some type in matchbox, for some order table. So I think it should be implemented.
I think this is easy to sort by SQL. I'll look at this later today
The sort order is working as designed. I'll try to implement sort by statement, but this should be an enhancement
9d49bc57ac82
Verified with build 080918.
Integrated into 'main-golden', will be available in build *200809181401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/9d49bc57ac82 User: John Baker <jbaker@netbeans.org> Log: #147067 SQL History: Sort only works by date, not SQL