A.59. Release 4.0.2

A.59.1. Bug fixes

• Fix to sort startup packet's parameters sent by client. (bug 444)(Takuma Hoshiai)

  If order of startup packet's parameters differ between cached connection pools and connection request, didn't use connection pool and created new connection pool.

• Fix broken authentication for Pgpool-II's internal connections. (Muhammad Usama)

  The issue is caused by a mistake in "SCRAM and Certificate authentication support" commit. The problem is while authenticating against backend in connection_do_auth(), it returns to caller as soon as backend returns auth ok response. So authentication itself established fine. However connection_do_auth() does not proceed until it receives "Ready for query". The fix is to keep processing the data after receiving auth_ok response until we get "Ready for query".

  Patch provided by Tatsuo Ishii and a tiny modification made by Muhammad Usama.

• Fix compiler warnings with gcc 8.x. (Takuma Hoshiai)

• Fix segmentation fault occurs when a certain Bind message is sent in native replication mode. (bug 443)(Bo Peng)

  If the number of parameter format codes is specified to one, but the number of the original query's parameter is zero, bind_rewrite_timestamp() will call memcpy with a negative value. This causes segmentation fault.

  Patch is provided by Yugo Nagata.

• Fix a query passed to relcache so that it uses schema qualified table name. (Tatsuo Ishii)

• Fix query cache invalidation bug. (Tatsuo Ishii)

• Fix segfault in extended query + query cache case. (Tatsuo Ishii)

• Fix memory leak in extended query + query cache enabled. (Tatsuo Ishii)