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 148255 - SQL CC: Default APP schema isn't shown
Summary: SQL CC: Default APP schema isn't shown
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-24 15:52 UTC by Roman Mostyka
Modified: 2008-09-25 07:54 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-09-24 15:52:36 UTC 
1. Connect to Java DB "sample".
2. Open SQL Editor.
3. Type "select * from " and press Ctrl+Space.
4. Choose APP, type "." and press Ctrl+Space.

Result: List of fields from "sample" is shown. In the issue #140277 I was told that "APP" is default schema. Why in case
of "sample" it works as schema for "sample", but in case of "travel" it works as default schema?
If there are 2 "APP" schemas (1 for "sample", 1 default) then they both should be shown in CC list.
Comment 1 Andrei Badea 2008-09-24 17:30:56 UTC 
Roman, if you have questions about how Derby works, please do not file them as an issue. Please ask on dev@db instead.
Thanks!

Moreover, I will note that the summary of the issue doesn't match the description. The APP schema is shown, and so are
the tables underneath.
Comment 2 Roman Mostyka 2008-09-25 07:54:51 UTC 
APP schema for "sample" DB is shown, not default (as written in summary). If you type "." after APP and press Ctrl +
Space then tables from "sample" DB will be shown. So there is no dismatch.