Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
[4.0n & 4.1EA] control-clicking tablename or alias leads to "too many objects" warning

when I control-click on a tablename or alias I am getting a small popup titled "too many objects" with the following text before the details tab opens
Only 2 records will be displayed.
Please refine your search criteria.
Answers
-
Actually it seems this is happening when the system has other objects by the same name,
and SqlDeveloper does not always open the correct one when Ctrl-clicking.
e.g. I reference table "TBL1" in a select, but when ctrl-clicking it from the worksheet,
it might be SOMEOTHERUSR.TBL1 that gets displayed (similar things may happen
with Shift-F4 but there I see no easy way of knowing the schema of the displayed object)
My limited testing suggests that Ctrl-clicking appears to end up displaying the details of the object
that lives in the schema that comes first alphabetically - picking the object from the connexion's
schema (if one exists) would seem like a better default...
-
What is your full sql developer version and platform?
Can you post a sample query and tell us which of the objects in it you are clicking on?
-
I am on win7 32bits, sqldeveloper Version 4.0.2.15
to avoid posting actual object names, I'll keep the description close to what I already explained:
Select * from TBL1 order by created_at desc;
I am connected as user 'Zxyz', the query above returns content from the table TBL1 in the current schema (as it should, the db sql engine picks the correct table), but ctrl-clicking "TBL1" opens Axyz.TBL1, as user Axyz also has a table by the same name, on which I have grants.
If I prefix TBL1 with its owner, the correct one is displayed, but it is cumbersome to have to do that for all table references, and one can easily get confused by the current behaviour where sqldeveloper actually shows the details of a table which may not be the one effectively used at runtime.
Note that there are several schemas with identically-named tables (more than 2), hence I suppose the original symptom mentioned in the subject, but some more investigation led me to notice the wrong object sometimes gets displayed
-
A have the same issue when CTRL + left clicking on a table name.
Is there no workaround? Is this getting fixed?
There was no problem with it in 3.0.04 I was using before...
-
I logged a bug for this - and we should have the same logic in place for doing the popup-desc (SHIFT+F4) and the ctrl-click stuff going forward, which should make this go away.
-
I definitely see this behaviour on 3.1 as well, FWIW. It does not even pick the same schema as under 4.x, so perhaps an "order by" was added or something. BTW the <Shift><F4> description does not actually show which schema it uses; this would be a welcome addition. And please do not make <Ctrl><Click> invoke the popup, as this does not allow viewing data nor pinning the table description tab. Thanks.
-
A new version (4.03.16) was released half a month ago, but the problem persists.
-
I am sorry to report that this bug is still present in Version 4.1.0.17. Hope the fix will be included in the release 4.1 version.
-
So ctrl+click gives you the warning, but DESC in 4.1 does not?
-
Yes, exact same behaviour as in original post.And DESC worked in 4.0x, already.