db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: [jira] Commented: (DERBY-720) Calling SYSCS_INPLACE_COMPRESS_TABLE on a synonym or a temp table results in a NullPointerException
Date Sat, 19 Nov 2005 18:05:40 GMT
For now I think it would be best to ignore synonyms and temp tables.  If 
  you can do this that would be great, I just had not gotten around to it.

Satheesh Bandaram (JIRA) wrote:
>     [ http://issues.apache.org/jira/browse/DERBY-720?page=comments#action_12358063 ]

> 
> Satheesh Bandaram commented on DERBY-720:
> -----------------------------------------
> 
> I think Derby shouldn't allow compress on synonyms... Synonym usage is valid only in
DML operations. If no one objects, I can make compress ignore synonyms, like views. While
I am there, I can also make it ignore temp. tables... This may be a good (short term) solution.
> 
> I will also mark Derby-365 a duplicate of this bug.
> 
> 
>>Calling SYSCS_INPLACE_COMPRESS_TABLE on a synonym or a temp table results in a NullPointerException
>>---------------------------------------------------------------------------------------------------
>>
>>         Key: DERBY-720
>>         URL: http://issues.apache.org/jira/browse/DERBY-720
>>     Project: Derby
>>        Type: Bug
>> Environment: sane mode
>>    Reporter: Daniel John Debrunner
> 
> 
>>ij> create synonym fred for barney;
>>0 rows inserted/updated/deleted
>>WARNING 01522: The newly defined synonym 'FRED' resolved to the object 'APP.BARN
>>EY' which is currently undefined.
>>ij> call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP', 'FRED', 1, 1, 1);
>>ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while eva
>>luating an expression.
>>ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
>>Also seems to occur if the table behind the synonym does exist.
> 
> 


Mime
View raw message