#1492 STRG-B (jump to tree entry) wont work if multiple names exists

[Claus]

• Current Snapshot Release 20211031_0013
• System i 7.3
• multiple schema with identical table setup for testing purpose

We use different methods to access our desired schema:

Change default schema

set schema abc;
select * from table1;
select * from table2;

set schema def;
select * from table1;
select * from table2;

Use schema with every Table

select * from abc.table1;
select * from abc.table2;

select * from def.table1;
select * from def.table2;

Use SQuirreL default schema option
(See CurrentSchemaDropDown.png), where you can change the default schema via dropdown.

None of this three options work with: "STRG-B" or "STRG-Click" on a table correctly.

If I use this on table1 of this select:

select * from def.table1;

it opens our object browser on "first table" found which may match - so in this example on abc.table1

Otherwise said: schema information is not included in search.

[Claus]

I should add - it should be called
CTRL-B or CTRL-click in english tickets :-)

[Gerd Wagner]

Fixed in our GIT repository. Will be available in future snapshots and versions.
Excerpt from change log:

'#1492 The SQL editors "Find in Object Tree" function (ctrl+B) and Object Tree search did not respect the current schema.
Some (not yet all) databases support the JDBC API function to read the current schema.
If so SQuirreL shows the current schema in its Session status bar.
Now SQuirreL also respects the current schema when searching the Object Tree.
I.e. if the same table name exists in two schemas SQuirreL preferably finds the one in the current schema.