You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bernt M. Johnsen (JIRA)" <de...@db.apache.org> on 2005/11/10 14:56:03 UTC

[jira] Created: (DERBY-699) Allow schema and savepoint names starting with "SYS"

Allow schema and savepoint names starting with "SYS"
----------------------------------------------------

         Key: DERBY-699
         URL: http://issues.apache.org/jira/browse/DERBY-699
     Project: Derby
        Type: Improvement
  Components: SQL  
    Reporter: Bernt M. Johnsen
    Priority: Minor


Schema and savepoint (and possibly other) names can't start with "SYS". This is a minor nuisance when porting databases to Derby. Seems to be introduced to be DB2-compliant.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (DERBY-699) Allow schema and savepoint names starting with "SYS"

Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-699?page=comments#action_12357267 ] 

Satheesh Bandaram commented on DERBY-699:
-----------------------------------------

Derby needs to treat many schemas starting with SYS.. as system schemas... like SYSCAT, SYS, SYSFUN, SYSSTAT, SYSPROC, SYSIBM, SYSCS_DIAG, SYSCS_UTIL. It may be possible to add future system schemas too, like SYSFUN was added recently. Any change to allow user SYS schemas needs to be made very carefully.

> Allow schema and savepoint names starting with "SYS"
> ----------------------------------------------------
>
>          Key: DERBY-699
>          URL: http://issues.apache.org/jira/browse/DERBY-699
>      Project: Derby
>         Type: Improvement
>   Components: SQL
>     Reporter: Bernt M. Johnsen
>     Priority: Minor

>
> Schema and savepoint (and possibly other) names can't start with "SYS". This is a minor nuisance when porting databases to Derby. Seems to be introduced to be DB2-compliant.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira