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 121280 - Provide "show all occurrences of" for SQL Editor
Summary: Provide "show all occurrences of" for SQL Editor
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Linux
: P3 blocker (vote)
Assignee: Libor Fischmeistr
Depends on:
Reported: 2007-11-06 12:24 UTC by m1k0
Modified: 2013-09-04 08:22 UTC (History)
0 users

See Also:
Exception Reporter:

video capture (555.28 KB, video/mp4)
2007-11-07 20:04 UTC, m1k0
Highlight search toggled on (54.96 KB, image/jpeg)
2007-11-20 23:54 UTC, David Vancouvering
Customer search toggled off (53.65 KB, image/jpeg)
2007-11-20 23:55 UTC, David Vancouvering

Note You need to log in before you can comment on or make changes to this bug.
Description m1k0 2007-11-06 12:24:12 UTC
If I select some words in sql editor, "Toggle Highlight Search" don't work.
Under java file forks fine.
Comment 1 Andrei Badea 2007-11-07 13:44:55 UTC
Sorry, I can't reproduce this, searching works fine for me. Please post detailes steps to reproduce, containing e.g. the
contents of the editor and the actions which you invoked. Thanks.
Comment 2 m1k0 2007-11-07 20:04:40 UTC
Created attachment 52684 [details]
video capture
Comment 3 m1k0 2007-11-07 20:06:28 UTC
In attachment you can find video screen capture. I show in how highlight works on java code and in sql code.
Comment 4 David Vancouvering 2007-11-20 20:01:55 UTC
I tried to play the video and got a failure from QT on my Mac ("invalid sample description found in the movie").

perhaps post to YouTube?
Comment 5 m1k0 2007-11-20 21:26:14 UTC
This is a H264/AVC, no sound

MPlayer is a great player :)

mplayer out.mp4
MPlayer SVN-r24130 (C) 2000-2007 MPlayer Team
CPU: Intel(R) Core(TM)2 Duo CPU     T7300  @ 2.00GHz (Family: 6, Model: 15, Stepping: 10)
CPUflags:  MMX: 1 MMX2: 1 3DNow: 0 3DNow2: 0 SSE: 1 SSE2: 1
Skompilowano dla procesora x86 z rozszerzeniami: MMX MMX2 SSE SSE2

Odtwarzam out.mp4.
Wykryto format pliku Quicktime/MOV.
[mov] Video stream found, -vid 0
[mov] Audio stream found, -aid 1
VIDEO:  [avc1]  640x528  24bpp  10.000 fps    0.0 kbps ( 0.0 kbyte/s)
Otwieram dekoder video: [ffmpeg] FFmpeg's libavcodec codec family
Wybrany kodek video: [ffh264] vfm: ffmpeg (FFmpeg H.264)
Nie mogę odnaleźć kodeka audio 0x5000736D.
Zobacz DOCS/HTML/en/codecs.html!
Audio: brak dźwięku
VDec: wymagana konfiguracja vo - 640 x 528 (preferowana przestrzeń kolorów: Planar YV12)
VDec: using Planar YV12 as output csp (no 0)
Format filmu to 1.21:1 - zmieniam do poprawnego formatu filmu.
VO: [xv] 640x528 => 640x528 Planar YV12
V:   4.5  46/ 46  8%  1%  0.0% 0 0
Wychodzę... (Wyjście)

I uploaded video on, but we must wait because of processing
Comment 7 David Vancouvering 2007-11-20 23:53:46 UTC
It works for me *if* I first search for a string.  So if I search for "customer" then all instances of "customer" are
highlighted, and then I can toggle back and forth.  I'll attach screen shots to demonstrate.

I tested in Java, and it works there too.  However, I can *also* simply double-click on any Java identifier, and
automatically all instances of that string are highlighted. But in this case if I press "Toggle Highlight Search" it
doesn't have any effect.  I have to double-click on another identifier for the old highlight to go away.

So in Java there are *two* highlights: one for search, and one for "show all occurrences of X"

I am wondering if you expect "show all occurrences of X" to work in the SQL Editor.  Because it does not - only search
works.  The SQL editor is not currently intelligent enough to detect all occurrences of.
Comment 8 David Vancouvering 2007-11-20 23:54:38 UTC
Created attachment 53271 [details]
Highlight search toggled on
Comment 9 David Vancouvering 2007-11-20 23:55:14 UTC
Created attachment 53272 [details]
Customer search toggled off
Comment 10 m1k0 2007-11-21 06:34:22 UTC
ok, this is work for me too (select dark yellow or orange color).
But witout select "toggle highligt" work highligt automitically (select on light yellow color) in Java editor, but not 
in SQL Editor.
Please, look at attached  video file "Wed Nov 7 20:04:00 +0000 2007: out.mp4".
MPlayer is a goog video player.
Comment 11 David Vancouvering 2007-11-21 17:59:37 UTC
I did take a look at the video, and if I am seeing what I think I'm seeing, this is a feature that is not supported in
the SQL Editor.  You double-clicked on Java identifiers like "log", "ResourceBundle" and "bundle".  Try it with a
comment, for example. 

What you are seeing with Java is a feature where, without typing in a search term, you can double-click on any
identifier in the file, and all occurences of the identifier are shown.  It has to do with the structure of the Java
code, not the text in the file.  This kind of structural highlighting is not supported in the SQL editor.

If that's not what you are talking about, I apologize.  I had trouble understanding your words, I recognize English is
not your first language, but perhaps you can try again.  
Comment 12 m1k0 2007-11-21 18:39:20 UTC
Ok, I understand you.
In comments work like in SQL editor.
This issue should be closed.

But, this automatic highlighting will be very useful not only in Java editor.

Comment 13 David Vancouvering 2007-11-21 18:56:44 UTC
Yes, I agree it would be useful.  I'll leave this open as a feature request.
Comment 14 David Vancouvering 2007-11-21 18:57:40 UTC
This can probably be accomplished by migrating the SQL Editor over to one of the frameworks like Schliemann...
Comment 15 Jiri Rechtacek 2009-10-16 14:03:43 UTC
Reassigned to new owner.