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.
Summary: | Allow code completion for more than one schema without needing to reference schema name. | ||
---|---|---|---|
Product: | db | Reporter: | rptmaestro <rptmaestro> |
Component: | SQL Editor | Assignee: | Libor Fischmeistr <lfischmeistr> |
Status: | REOPENED --- | ||
Severity: | normal | ||
Priority: | P3 | ||
Version: | 7.0 | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Exception Reporter: |
Description
rptmaestro
2010-11-02 16:18:27 UTC
Please, describe in detail (a script creating both schemas and other configuration to make it as similar as possible to your configuration will the best). I haven't understood the problem yet. Thank you Say I have 2 schemas in my database, "SHARED_SCHEMA" and "MY_SCHEMA" Suppose "SHARED_SCHEMA" has three tables "EMPLOYEES" "ORGANIZATIONS" "POSITIONS" And suppose "MY_SCHEMA" has two tables: "EMPLOYEE_BILLING" "PROJECTS" If I've selected "MY_SCHEMA" as the default schema when I create the IDE's database connection, the SQL editor's code completion requires that I reference tables in the "SHARED_SCHEMA" by the schema name, even though the database doesn't require me to do so. (I think the database administrator created some synonyms to those tables, which NetBeans does not recognize.) My request is that I be able to identify on the connection which schemas I can get code completion on without having to fully write out the schema name. This has a practical application, because the "SHARED_SCHEMA" will often have a different name on the production system than it does on the development or test systems. |