Release 4.0.2

A.3.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, did'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)