db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-363) Address incorrect temporary table check for synonyms that may prevent creating a synonym to a permanent table in SESSION schema.
Date Tue, 14 Jun 2005 23:40:00 GMT
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


Mime
View raw message