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-362) Some of the DDL checks to prevent incorrect temporary table use is incorrect. These may incorrectly stop access to valid permanant tables in SESSION schema.
Date Tue, 14 Jun 2005 23:39:54 GMT
Some of the DDL checks to prevent incorrect temporary table use is incorrect. These may incorrectly
stop access to valid permanant tables in SESSION schema.
------------------------------------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-362
         URL: http://issues.apache.org/jira/browse/DERBY-362
     Project: Derby
        Type: Bug
  Components: SQL  
    Versions: 10.0.2.1    
 Environment: Generic
    Reporter: Satheesh Bandaram


Use of temporary tables in some DDLs is incorrect. For example, it should not be possible
to create a view on a temporary table or create a trigger. But the current code checks prevent
valid uses of permanent tables in SESSION schema, mistaking them for temporary tables. Need
to check all DDL statements and temporary table usage errors.

ij> create table session.permTable ( i int);
0 rows inserted/updated/deleted
ij> create view view1 as select * from session.permTable;
ERROR XCL51: The requested function can not reference tables in SESSION schema.
ij> create trigger trig1 after insert on session.permTable for each row mode db2
sql insert into t1 values (1);
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