ij> autocommit off;
ij> declare global temporary table t2(c21 int) not logged;
0 rows inserted/updated/deleted
ij> insert into t2 values 2,3,4,5;
ERROR 42X05: Table 'T2' does not exist.
ij> insert into session.t2 values 2,3,4,5;
4 rows inserted/updated/deleted
ij> select * from session.t2;
C21
-----------
2
3
4
5

4 rows selected
ij> call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('SESSION', 'T2', 1, 1, 1);
ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while eva
luating an expression.
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

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.

derby-365 might be a duplicate of this issue.

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.

By following the examples provided in this jira entry, I couldn't get the npe for synonym but still get it for global temp table. Even for synonym, I am not sure if we are just skipping the code as suggested by Satheesh(seems like that might be the right thing for synonyms based on Satheesh's comment above). If nothing else, the issue definitely needs further looking into for global temporary tables.

Attaching repro, w.sql.

Triaged for 10.5.3: assigned normal urgency and marked "repro attached".