pljava-examples-1.6.10.jar: ERROR: 42P01: relation "oldrows" does not exist

[df7cb]

Hi,

I just tried to update the pljava Debian package to 1.6.10 to finally get PG 18 support (had missed that so far), but our regression tests fail now. They try to run the included pljava-examples-1.6.10.jar file:

+ psql -c 'ALTER USER myon SET pljava.vmoptions = '\''-Djava.security.manager=allow'\'''
ALTER ROLE
Time: 0.510 ms
+ psql -c 'ALTER USER myon SET check_function_bodies = off'
ALTER ROLE
Time: 0.530 ms
+ psql -c 'CREATE EXTENSION pljava'
WARNING:  01000: [JEP 411] migration advisory: Java version 24 and later cannot run PL/Java 1.6.10 with policy enforcement
DETAIL:  This PL/Java version enforces security policy using important Java features that upstream Java has disabled as of Java 24, as described in JEP 486. In Java 18 through 23, enforcement is still available, but requires "-Djava.security.manager=allow" in "pljava.vmoptions". 
HINT:  For migration planning, this version of PL/Java can still enforce policy in Java versions up to and including 23, and Java 17 and 21 are positioned as long-term support releases. Java 24 and later can be used, if wanted, WITH ABSOLUTELY NO EXPECTATIONS OF SECURITY POLICY ENFORCEMENT, by adding "-Djava.security.manager=disallow" in "pljava.vmoptions". This mode should be considered only if all Java code to be used is considered well vetted and trusted. For details on how PL/Java will adapt, please bookmark https://github.com/tada/pljava/wiki/JEP-411
LOCATION:  Backend_warnJEP411, Backend.c:2091
CREATE EXTENSION
Time: 466.292 ms
+ psql -c 'SELECT sqlj.install_jar('\''file:/home/myon/projects/postgresql/postgresql-pljava/postgresql-pljava/debian/postgresql-18-pljava/usr/share/postgresql/18/pljava/pljava-examples-1.6.10.jar'\'', '\''examples'\'', true)'
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest java.time.LocalDate passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest java.time.LocalTime passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest java.time.OffsetTime passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest java.time.LocalDateTime passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest java.time.OffsetDateTime passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest OffsetTime as stmt param passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:58 org.postgresql.pljava.example.LoggerTest SetOfRecordTest ok
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest variadic calls ok
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest composite return passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest set of composite return passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest ConditionalDDR looking good!
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.ComplexTuple javatest.complextuple from SQLInput
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.ComplexTuple javatest.complextuple to SQLOutput
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.ComplexTuple javatest.complextuple from SQLInput
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.SPIActions issue 228 tests ok
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest Holdability OK
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest timestamp roundtrip passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest timestamptz roundtrip passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.Point pg_catalog.point from SQLInput
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest issue192 test passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest boolean[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest "char"[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest bytea passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest int2[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest int4[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest int8[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest float4[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest float8[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest text[] passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.Point pg_catalog.point from SQLInput
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.annotation.PreJSR310 issue 199 test ok
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest aggregate examples ok
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest get resource passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
INFO:  00000: 27 Jan 26 19:31:59 org.postgresql.pljava.example.LoggerTest get ResourceBundle passes
LOCATION:  Java_org_postgresql_pljava_internal_Backend__1log, Backend.c:2195
ERROR:  42P01: relation "oldrows" does not exist
LINE 1: SELECT o.value, n.value FROM oldrows o FULL JOIN newrows n U...
                                     ^
QUERY:  SELECT o.value, n.value FROM oldrows o FULL JOIN newrows n USING (username)
CONTEXT:  SQL statement "UPDATE javatest.foobar_2 SET value = 43 WHERE value = 42"
LOCATION:  parserOpenTable, parse_relation.c:1466
Time: 871.324 ms

This was on the upcoming Ubuntu resolute 26.04, but the failure is also visible in this build log from Debian unstable: https://jengus.postgresql.org/job/postgresql-pljava-binaries/160/architecture=amd64,distribution=sid/console

All PG versions are affected.