EscapeSyntaxCallModeCallTest failure with PG14

[jchampio]

Hello,

We're seeing a test failure when building against the REL_14_STABLE branch of Postgres:

FAILURE   0.1sec, org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest > testInvokeFunctionHavingReturnParameter
    java.lang.AssertionError
        at org.junit.Assert.fail(Assert.java:87)
        at org.junit.Assert.assertTrue(Assert.java:42)
        at org.junit.Assert.assertTrue(Assert.java:53)
        at org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunctionHavingReturnParameter(EscapeSyntaxCallModeCallTest.java:63)

From a quick skim of the other issues, it seems like this might be related to #2190? This is a cloud build, so my ability to hop on and debug is somewhat limited; I'm hoping it's a simple reproduction for others.

Driver Version?

42.2.24

Java Version?

openjdk version "1.8.0_302"
OpenJDK Runtime Environment (build 1.8.0_302-b08)
OpenJDK 64-Bit Server VM (build 25.302-b08, mixed mode)

OS Version?

CentOS 7

PostgreSQL Version?

REL_14_STABLE (as of September 24, 2021)

[davecramer]

Thx, have been able to reproduce this. PR#2190 should have been backpatched...

[jchampio]

Just in case it helps: switching to a different matcher gives more information (disregard line numbers since they have changed):

FAILURE   0.0sec, org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest > testInvokeFunctionHavingReturnParameter
    java.lang.AssertionError: 
    Expected: a string equal to "42809" ignoring case
         but: was "42883"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
        at org.junit.Assert.assertThat(Assert.java:964)
        at org.junit.Assert.assertThat(Assert.java:930)
        at org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunctionHavingReturnParameter(EscapeSyntaxCallModeCallTest.java:66)

[davecramer]

thx, ya that is it

[davecramer]

closed with 51c70a9