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

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