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 "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2005/06/15 01:40:00 UTC

[jira] Created: (DERBY-363) Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.

Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.
--------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-363
         URL: http://issues.apache.org/jira/browse/DERBY-363
     Project: Derby
        Type: Sub-task
  Components: SQL  
    Versions: 10.1.0.0    
 Environment: generic
    Reporter: Satheesh Bandaram


Same problem as the parent task, for synonyms. I would like to address this problem for synonyms for 10.1, if possible. The parent task is created to address this problem for all other types of DDLs.

ij> create table session.permTable ( i int);
0 rows inserted/updated/deleted
ij> create synonym syn1 for session.permTable;
ERROR XCL51: The requested function can not reference tables in SESSION schema.
ij> create index indSession on session.permTable (i);   <============ Works correctly.
0 rows inserted/updated/deleted

-- 
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] Resolved: (DERBY-363) Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.

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

    Resolution: Won't Fix

There was some discussion about whether creating synonyms for permanent tables in SESSION schema should be allowed or not. Decision was to not allow this.

> Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.
> --------------------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-363
>          URL: http://issues.apache.org/jira/browse/DERBY-363
>      Project: Derby
>         Type: Sub-task
>   Components: SQL
>     Versions: 10.1.1.0
>  Environment: generic
>     Reporter: Satheesh Bandaram

>
> Same problem as the parent task, for synonyms. I would like to address this problem for synonyms for 10.1, if possible. The parent task is created to address this problem for all other types of DDLs.
> ij> create table session.permTable ( i int);
> 0 rows inserted/updated/deleted
> ij> create synonym syn1 for session.permTable;
> ERROR XCL51: The requested function can not reference tables in SESSION schema.
> ij> create index indSession on session.permTable (i);   <============ Works correctly.
> 0 rows inserted/updated/deleted

-- 
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] Closed: (DERBY-363) Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.

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


> Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.
> --------------------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-363
>          URL: http://issues.apache.org/jira/browse/DERBY-363
>      Project: Derby
>         Type: Sub-task
>   Components: SQL
>     Versions: 10.1.1.0
>  Environment: generic
>     Reporter: Satheesh Bandaram

>
> Same problem as the parent task, for synonyms. I would like to address this problem for synonyms for 10.1, if possible. The parent task is created to address this problem for all other types of DDLs.
> ij> create table session.permTable ( i int);
> 0 rows inserted/updated/deleted
> ij> create synonym syn1 for session.permTable;
> ERROR XCL51: The requested function can not reference tables in SESSION schema.
> ij> create index indSession on session.permTable (i);   <============ Works correctly.
> 0 rows inserted/updated/deleted

-- 
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