[jira] Commented: (DERBY-720) Calling SYSCS_INPLACE_COMPRESS_TABLE on a synonym or a temp table results in a NullPointerException

["Daniel John Debrunner (JIRA)" <de...@db.apache.org>]

    [ http://issues.apache.org/jira/browse/DERBY-720?page=comments#action_12358032 ] 

Daniel John Debrunner commented on DERBY-720:
---------------------------------------------

For VTI tables I followed the mode for views and the compress code ignores them.
 I modified the code to use a switch statement and ignore views and vti tables.

Didn't want to fix this bug by ignoring synoymns and temp tables because maybe it's not the correct approach, maybe the table under the synoymns should be compressed and the temp table compressed.

Though maybe a good short term, easy, soution is to ignore synonyms and temp tables.

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

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