#983 Shows me unusefull Entries

Squirrel SQL


I hope I can describe what I mean :-)
Okay: This is i bigger Issue, so here my statement:

1. If I have a bigger Database and many Schematas which change very often, I don't use session Properties for Default schema -> I use set current schema.
But if I enter a Statement like
"select * from cu[STRG-Space]" I will get

This is not usefull. My only way to avoid this is to use by default "select * from schema1.cu[STRG-Space] -> therefore I get what I want.
Is it possible and usefull for others to first show only Tables in my "currentschema" ?
Mabye as an Option STRG-Space used twice shows me all?

2. Next point:
If I enter a statement like
"select * from sysibm.sysdummy1 where [STRG-Space]"
at this point I get all available Tables again although at this Point columns should be shown.
Only way to avoid ist always to use Aliases like
"select * from sysibm.sysdummy1 d where d.[STRG-Space]"

(Same like select * from dual in Oracle)
So it is not context sensitive -> Is this changeable :-) ?

3. SQuirreL does have a problem if you try to enter a "exists-Querry" like:
"select * from sysibm.sysdummy1 d
where exists (select 1 from sysibm.sysdummy1 dd where dd.[STRG-Space]"
At this point you won't ever get a Code-Completion entry!

Only way to get this working:
"select * from sysibm.sysdummy1 d
where exists (
select 1 from sysibm.sysdummy1 dd where dd.[STRG-Space]"
Ahhh... I found at this moment: it seems to be a Problem not having a Space between ( and select !!


  • Claus

    Claus - 2011-11-01
    • priority: 5 --> 8
  • Claus

    Claus - 2011-11-01

    Still not worked on?
    Especially Point 1 should be solved!


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks