onsumption View 927 Viewing and Logging Per-Process Memory Usage Information 928 About the pg_backend_memory_contexts View 928 About the Memory Context Admin Functions 928 Sample Log Messages 929 Functions 1588 Table 8. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost silent bool]]) boolean Returns the result of JSON path predicate check for the specified JSON value. Only the first item of the result is taken into account. If the result is not Boolean, then null is returned

Prerequisites 964 Configure the Remote Host 965 Load the Docker Image to the Remote Host 965 Configure a Backend Node 965 Verify the Configuration 966 PL/Java Language 966 About PL/Java 967 About Greenplum Guide 1979 About the Greenplum Database Utilities 1979 Referencing IP Addresses 1979 Running Backend Server Programs 1979 Utility Reference 1980 analyzedb 1983 Synopsis 1983 Description 1983 Notes plcontainer. The pg_config utility option --version now displays the version of the PostgreSQL backend server, and the new option --gp_version prints the version of Greenplum. VMware Greenplum 6.27

Functions 796 Table 7. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost to identical column names in the target row type. JSON type coercion for these functions might not result in desired values for some types. JSON fields that do not appear in the target row type will be omitted Functions 1703 Table 8. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost

Guide 1869 About the Greenplum Database Utilities 1870 Referencing IP Addresses 1870 Running Backend Server Programs 1870 Utility Reference 1871 analyzedb 1873 Synopsis 1874 VMware Tanzu Greenplum append-only auxiliary tables. 13739 Resolves an issue where Greenplum Database returned a wrong result or silently errored out when a subplan contained a SharedScan and the subplan's parent Plan included number of append-optimized tables. Greenplum Database now includes a view -- gp_suboverflowed_backend -- created by the new extension gp_subtransaction_overflow-- to help users query for suboverflowed

Guide 1942 About the Greenplum Database Utilities 1942 Referencing IP Addresses 1942 Running Backend Server Programs 1943 Utility Reference 1944 analyzedb 1946 Synopsis 1946 Description 1947 Notes retained after reorganizing. Query Processing 14303 Resolved an issue where GPORCA generated a wrong result for a query on a partitioned table when the query evaluated different types of predicates at the record-type parameters. 32567 Resolved an issue where a query could not be terminated with pg_terminate_backend() because Greenplum Database polled an invalid (-1) file descriptor. Greenplum now removes invalid

Guide 1937 About the Greenplum Database Utilities 1937 Referencing IP Addresses 1937 Running Backend Server Programs 1938 Utility Reference 1939 analyzedb 1941 Synopsis 1941 Description 1942 Notes specified to provide the directory. 16356 The gpcheckperf utility was changed to ensure that the result set for the list of hosts displayed for network tests matches the results from earliear versions 12818 Resolved an issue where GPORCA generated a Nested Look Join (NLJ) plan with an incorrect result. 15311 Resolved an issue where GPORCA generated incorrect results when using Left Outer Join (LOJ)

generate_series functions, and Index Only Scan plans. 12228 : Resolves generation of faulty plans that could result in segfault on indexed tables. The issue occurred when path nodes with bottleneck locus types (Entry caused data corruption during scan on bitmap index when there was an INSERT operation running in the backend. 10955 : Improved the logging and adjusted log level from INFO to DEBUG for the message We thought results. Specifically, for operations involving a SEQUENCE function on the replicated table, the result was not guaranteed to be identical across different segments. This issue was resolved by identifying

Resolves an issue where a Command Center request to cancel a long running query – via pg_cancel_backend – failed to disconnect the session, because an underlying interrupt-detection flag failed to interpret the server backend process detects the client has disconnected, it terminates itself as well, thus avoiding consuming resources on the system and avoiding the need to use pg_cancel_backend. 32136, 13292 aggregate function (special aggs) would cause a PANIC. 32123, 13265 : Resolves an issue where the result of an UPDATE query that included a NOT IN operator identified that one row was updated, when in

Functions 689 Table 7. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost to identical column names in the target row type. JSON type coercion for these functions might not result in desired values for some types. JSON fields that do not appear in the target row type will be omitted Functions 1501 Table 8. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost

results. Specifically, for operations involving a SEQUENCE function on the replicated table, the result was not guaranteed to be identical across different segments. This issue was resolved by identifying flow control process causes a busy receiver to cache or duplicate packets while waiting for the backend to consume them. Greenplum Database now uses a more active flow control mechanism to control packet plan for a subquery that has GROUPING SETS. 10794 - Resource Groups : Resolves an issue where the result of a query on pg_resgroup_get_status(NULL:oid) could not be saved to a table. 10376 - Query Execution