db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6725) Add a system function which returns the name of the database.
Date Fri, 14 Nov 2014 15:56:34 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14212410#comment-14212410

Bryan Pendleton commented on DERBY-6725:

Hi Mamta,

I agree that, for Derby, a database name and a schema name are two different things.

I was reacting to Rick's earlier comment that, in other database systems, the object that
they refer to as a "database name" corresponds to the object that we refer to as a "schema

So I think it would be worthwhile for us to have a utility function that returns the database
name, as you propose.

But I also think Rick was saying that, for many users, they don't actually want to get the
database name; they want to get the current schema name.

And I believe we already have a way to do that.

So it would also be useful to figure out how to clearly describe these concepts so that Derby
users are able to find the particular name that they want, even if they are coming from a
different database which uses different terminology.

> Add a system function which returns the name of the database.
> -------------------------------------------------------------
>                 Key: DERBY-6725
>                 URL: https://issues.apache.org/jira/browse/DERBY-6725
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Mamta A. Satoor
> Got this request in private conversation with a user. Other databases provide this functionality.
Seems straightforward to add.

This message was sent by Atlassian JIRA

View raw message