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.
