This topic describes the release notes for the minor versions, console, Ganos, and API of PolarDB for Oracle and provides links to the relevant references.

Note You can execute the following statement to view the minor version that is used by PolarDB for Oracle:
show polar_version;

July 2022

Minor version 1.1.24

Category Feature Description References
New feature plan_cache_mode The plan_cache_mode parameter is added to set the plan cache mode. Default value: auto. Valid values:
  • auto: automatically chooses between the custom and generic modes.
  • force_custom_plan: uses the custom plan generated by the optimizer.
  • force_generic_plan: uses the generic plan in the plan cache.
N/A

Ganos V4.7

Category Feature Description References
New feature ST_makeTrajectory function The ST_makeTrajectory function is added to convert rows in a table into trajectories. ST_makeTrajectory
ST_AsTable function The ST_AsTable function is added to convert trajectories into a table. ST_AsTable
Fixed issue The following issue is fixed: Anonymous temporary tables cannot be automatically deleted during raster data operations.

June 2022

Minor version 1.1.23

Category Feature Description References
New feature Support for DBMS_SQL.define_array The DEFINE_ARRAY stored procedure is added to the DBMS_SQL package. DBMS_SQL
Both %TYPE and := to specify default values You can specify default values in stored procedures by using both %TYPE and the := operator. Use %TYPE in variable declarations
Global Partitioned Index Global partitioned indexes can be created in partitioned tables. Create a global index
pg_hint_plan The pg_hint_plan plug-in allows you to add hints to change the execution plans of SQL statements. pg_hint_plan
Optimized feature Performance optimization for resource manager memory release
  • The mem_release_policy parameter is added to indicate the memory release policy. Default value: default. Valid values:
    • default: When the database thresholds are reached, resource manager starts the adaptive policy. This parameter cannot be combined with other parameters. The memory is released based on the default policy. Idle processes and active processes are divided. Idle processes are first released and then active processes.
    • cancel_query: cancels queries of active processes.
    • terminate_idle_backend: terminates idle processes.
    • terminate_any_backend: terminates any processes.
    • none: takes no actions.
  • The total_memcontext_dump_rate parameter is added to indicate the threshold for memory context output. Default value: 75. Valid values: 20 to 95. The parameter value takes effect after you restart the cluster or perform a reload operation.
  • The max_proc_mcxtdump_num parameter is added to indicate the number of processes for memory context output. Default value: 1. Valid values: 1 to 100. The parameter value takes effect after you restart the cluster or perform a reload operation.
  • The interval_max_num parameter is added to indicate the number of intervals for memory context output. Default value: 0. Valid values: 0 to INT32_MAX. The parameter value takes effect after you restart the cluster or perform a reload operation.
N/A

March 2022

Minor kernel version 1.1.22

Category Feature Description References
New feature Implicit type conversion The implicit type conversion feature is introduced to make PolarDB compatible with the matrix of Oracle implicit conversions. You can use this feature to convert high-precision numerical data to low-precision numerical data. N/A
Analyze operation in parallel execution
  • The polar_px_enable_explain_allstat parameter is added to display the execution result (such as the number of tuples processed by each worker and the execution duration) of each worker when the explain analyze command is run in parallel queries.
  • The polar_px_explain_memory_verbosity parameter is added to display the memory usage of each worker when the explain analyze command is run in parallel queries. Valid values:
    • summary: the collective information of the memory usage of each worker.
    • detail: the detailed memory usage information of each worker.
N/A
Support for modifying column types in global temporary tables (GTTs) GTTs support ALTER statements. N/A
Soppurt for Clang Clang is supported. N/A

Ganos 4.6

Category Feature Description References
New feature Object storage paths Raster data can be accessed by using self-managed Multi-Cloud Object Storage (MinIO) servers. Object storage paths
ST_PointValues function The ST_PointValues function is added. It can be used to return the pixel values of all bands. ST_PointValues
Fixed issue The issue that causes incorrect band order when the ST_Clip function is executed is fixed.
The issue that causes low performance due to lack of primary key indexes during raster updates is fixed.
If trajectory failed to read data from OSS, it can try again.

Ganos 4.5

Category Feature Description References
New feature Ganos is supported for ApsaraDB RDS for PostgreSQL 14. N/A
Optimized feature Cache for trajectory objects in external storage is increased to improve access performance. N/A
Fixed issue The issue that causes missing file suffixes when raster data is exported to OSS is fixed.
The issue that causes failed statistics on specific raster data is fixed.

January 2022

Minor kernel version 1.1.20

Category Feature Description References
New feature Drop flashback You can use the drop flashback feature to quickly restore deleted tables and view and clear the recycle bin. Drop flashback
Advancement of the OPT_PARAM hint You can use the OPT_PARAM hint to specify a specific parameter during the execution of a single SQL statement. OPT_PARAM Hints
Multi-level partitioned tables in parallel execution You can use the parallel execution feature to query data from multi-level partitions in parallel. Use the cross-node parallel execution feature to query data from partitioned tables
DML use GLOBAL INDEX You can use global index scan in data manipulation language (DML) operations of DELETE and UPDATE. Use global index scan in DML operations

Ganos 4.4

Category Feature Description References
New feature ST_LinearStretch function The ST_LinearStretch function is added to linearly stretch a raster and return a new raster. ST_LinearStretch
ST_BuildPercentiles function The ST_BuildPercentiles function is added to return the percentage of pixels for a set of raster bands. ST_BuildPercentiles
ST_ComputeStatistics function The ST_ComputeStatistics function is added to return the statistics of a raster object, including histograms and percentage. ST_ComputeStatistics
ST_Percentile function The ST_Percentile function is added to return the percentage of pixels for a raster band. ST_Percentile
Optimized feature Parallel computing The ST_SummaryStats and ST_BuildHistogram functions can be used to perform parallel computing. N/A
ST_ExportTo function The ST_ExportTo function returns false instead of an error message if the specified file already exists. N/A
ST_ImportFrom function If an import error occurs, the ST_ImportFrom function returns the details about the error. You can troubleshoot the error based on the error details. ST_ImportFrom
Fixed issue The issue where half a pixel is lost due to number rounding when a raster is cropped is fixed.
The issue due to which the data of a raster cannot be properly imported or collected if the data contains values such as NAN and INF is fixed.

December 2021

Minor version 1.1.19

Category Feature Description References
New feature sql mapping SQL statement mapping is supported for PolarDB for Oracle. Incorrect SQL statements can be mapped to correct SQL statements. This way, issues caused by incorrect SQL statements can be prevented. polar_sql_mapping
Support for parallel update in cross-node parallel execution Parallel update is supported in cross-node parallel execution, including UPDATE statements that contain subqueries.
You can set the polar_px_enable_update parameter to enable or disable this feature. Default value: false.
  • If the parameter is set to true, this feature is enabled.
  • If the parameter is set to false, this feature is disabled.

You can set the polar_px_update_dop_num parameter to control the concurrency level for the parallel update feature. The default concurrency level is 6. Valid values: 1 to 128.

You can set the polar_px_enable_remove_update_redundant_motion parameter to specify whether to remove excess motion operators when the number of read workers is the same as that of the write workers. Default value: false.
  • If this parameter is set to true, excess motion operators are removed.
  • If this parameter is set to false, excess motion operators are not removed.
Cross-node parallel execution
Support for parallel delete in cross-node parallel execution Parallel delete is supported in cross-node parallel execution, including DELETE statements that contain subqueries and parallel delete that does not contain subqueries.
You can set the polar_px_enable_delete parameter to enable or disable this feature. Default value: false.
  • If this parameter is set to true, this feature is enabled.
  • If this parameter is set to false, this feature is disabled.

You can set the polar_px_delete_dop_num parameter to control the concurrency level for the parallel delete feature. The default concurrency level is 6. Valid values: 1 to 128.

You can set the polar_px_enable_remove_delete_redundant_motion parameter to specify whether to remote excess motion operators when the number of read workers is the same as that of the write workers. Default value: false.
  • If this parameter is set to true, excess motion operators are removed.
  • If this parameter is set to false, excess motion operators are not removed.
Support for partition-wise join in cross-node parallel execution The advanced feature partition-wise join is supported in cross-node parallel execution. Use the cross-node parallel execution feature to query data from partitioned tables
Compatibility with Oracle views PolarDB for Oracle is compatible with the all_tab_columns view, the all_tab_comments view, and some columns of the all_objects view. ALL_TAB_COLUMNS and ALL_OBJECTS
Support for the encryption algorithms of the Chinese Cryptographic Standards PolarDB for Oracle supports the encryption algorithms of the Chinese Cryptographic Standards to enhance database security. N/A
Optimized feature Support of DBMS_SQL.TO_CURSOR_NUMBER and DBMS_SQL.TO_REFCURSOR The DBMS_SQL.TO_CURSOR stored procedure is supported.
Example:
   the conversion from local dynamic SQL to DBMS_SQL.
  curid := dbms_sql.to_cursor_number(cursrc);
N/A

Ganos V4.3

Category Feature Description References
New feature ST_PixelAsPolygon function The ST_PixelAsPolygon function is supported. This function is used to return the polygon geometry that bounds the pixel for a particular row and column. ST_PixelAsPolygon
ST_PixelAsPolygons function The ST_PixelAsPolygons function is supported. This function is used to return the polygon geometry that bounds every pixel of a raster band. ST_PixelAsPolygons
ST_PixelAsPoint function The ST_PixelAsPoint function is supported. This function is used to return a point geometry of the upper-left corner of the pixel. ST_PixelAsPoint
ST_PixelAsCentroid function The ST_PixelAsCentroid function is supported. This function is used to return the centroid (point geometry) of the area represented by a pixel. ST_PixelAsCentroid
ST_PixelAsPoints function The ST_PixelAsPoints function is supported. This function is used to return a point geometry for each pixel of a raster band. ST_PixelAsPoints
ST_PixelAsCentroids function The ST_PixelAsCentroids function is supported. This function is used to return the centroid (point geometry) for each pixel of a raster band. ST_PixelAsCentroids
Optimized feature Geometry model Geometry is compatible with PostGIS 3.1.4. N/A
ST_AsDatasetFile function The ST_AsDatasetFile function is supported. This function is used to return data in the GRIB2 format. N/A
Fixed issue The bug due to which an incorrect spatial reference identifier (SRID) is obtained when raster data is imported in the NetCDF format is fixed.
The bug due to which multiple bounding boxes cannot be properly updated if the results of the equals operations on these bounding boxes are incorrect is fixed.

October 2021

Minor version 1.1.17

Category Feature Description References
New feature Partition pruning supported on partitioned tables at runtime for DML operations You can execute the EXPLAIN statement when you update or delete a partitioned table to prune partitions at runtime. Partition pruning
ORDER BY clause supported in aggregate functions When you execute an aggregate function, you can use ORDER BY for simple queries. Aggregate functions
Support of schemas specified for triggers You can specify a schema that precedes the name of a trigger for the trigger. Trigger
Support for two-dimensional associative arrays Two-dimensional associative arrays are supported. Associative arrays
Support for multiple read and multiple write to accelerate queries with INSERT INTO SELECT in cross-node parallel execution In addition to multiple read and single write implemented by executing INSERT INTO SELECT, cross-node parallel execution also supports parallel write and parallel read to further improve the performance of INSERT INTO SELECT.
You can set the polar_px_insert_dop_num parameter to control the write concurrency level. Default value: 6.
  • If polar_px_insert_dop_num is set to 1, the multiple read and single write plan is executed.
  • If polar_px_insert_dop_num is set to a value greater than 1, the multiple read and multiple write plan is executed.
Cross-node parallel execution
Support for acceleration of tableless queries that use INSERT INTO SELECT in cross-node parallel execution Cross-node parallel execution supports acceleration of tableless queries that use INSERT INTO SELECT, which further improves the performance of INSERT INTO SELECT.
You can set the polar_px_enable_insert_from_tableless parameter to specify whether to enable the tableless query acceleration feature. Default value: 0.
  • If polar_px_enable_insert_from_tableless is set to 1, this feature is enabled.
  • If polar_px_enable_insert_from_tableless is set to 0, this feature is disabled.
Support for forced order in INSERT INTO SELECT for order-sensitive SQL queries in cross-node parallel execution Cross-node parallel execution allows you to set polar_px_enable_insert_order_sensitive to ensure that parallel write operations are performed in order. Default value: true.
  • If polar_px_enable_insert_order_sensitive is set to true and an SQL statement contains ORDER BY or the tableless query feature is used, parallel write operations are forced to perform in order.
  • If polar_px_enable_insert_order_sensitive is set to false, parallel write operations are not necessarily performed in order.
Support for ROWNUM in cross-node parallel execution You can set the ROWNUM expression that is compatible with Oracle for cross-node parallel execution.
Interruption support for automatic interruption of cross-node parallel queries after a timeout for the continuity of conflicted DDL operations To prevent DDL operations from undergoing sustained suspension due to lock conflicts with cross-node parallel queries, you can set the duration for which the operations have to wait. If the lockout duration ends, cross-node parallel queries are forced to interrupt and the operations continue.
Support for LEADING hints You can configure more than one table for LEADING hints to specify the join order of multiple tables. LEADING hints
DELETE FROM subquery Support of DELETE FROM for subqueries N/A
Support for SELECT UNIQUE The SELECT UNIQUE syntax is supported. It is equivalent to SELECT DISTINCT. N/A
UPDATING IN SPL TRIGGER In DML triggers, the UPDATING ('colname') conditional predicate is supported. N/A
Support of WHERE for UPDATE and DELETE in the MERGE statement In the MERGE statement, you can use WHERE with UPDATE or DELETE. N/A
Support of aliases for INSERT INTO SELECT You can set alias for INSERT INTO SELECT. N/A
Support of delimiters between characters for COPY You can use delimiters to separate multiple characters for COPY. N/A
Optimized feature Support for polar_row_id in cross-node parallel execution You can set the polar_row_id parameter for cross-node parallel execution. N/A
Parallel playback for read-only nodes Playback is accelerated for read-only nodes by using multithreading, which reduces the latency of synchronization between the primary node and read-only nodes. N/A

Ganos V4.0

Category Feature Description References
Optimized feature ST_ImportFrom function The ST_ImportFrom function is enhanced to allow Object Storage Service (OSS) objects to be mapped to files in memory and accelerate data import. ST_ImportFrom and ganos.raster.memory_oss_file_max_size
GiST and TrajGisT indexing The trajgist_ops_multi operator family is supported for Generalized Search Tree (GiST) and TrajGisT indexing. You can create a GiST or TrajGisT index on multiple bounding boxes. GiST indexing, TrajGiST indexing, and ganos.trajectory.index_split_config
Fixed issue Vector pyramids are optimized to support queries of metadata.
The bug that causes memory leaks when Ganos is used to check whether two specified trajectories intersect is fixed.

September 2021

Minor version 1.1.16

Category Feature Description References
New feature Support for using statement outlines to rewrite queries Statement outlines can be used to rewrite SQL queries when the query rewrite feature of PolarDB cannot meet your business requirements. Adjust execution plans
Support for the AssertOp operator in cross-node parallel execution The AssertOp operator is supported by the cross-node parallel execution feature to check runtime constraints on the executor. Cross-node parallel execution
Support for Oracle DECODE expressions in cross-node parallel execution Oracle DECODE expressions are supported by the cross-node parallel execution feature.
Dynamic partition pruning in cross-node parallel execution Dynamic partition pruning is supported by the cross-node parallel execution feature to improve the performance of hash joins for partitioned tables.
Support for holdable portals in Bind messages SQL statements can be accessed across transactions. To enable this feature, add polar_holdable_hint hints to SQL statements. The following SQL statement is an example: SELECT /*+ polar_holdable_hint */;. N/A
SELECT FOR UPDATE statement compatible with Oracle syntax The SELECT FOR UPDATE OF statement is fully compatible with Oracle syntax. N/A
Optimized feature Support for constant expressions in cross-node parallel execution Constant expressions are supported by the cross-node parallel execution feature. N/A
Operator-level memory limits Operator-level memory limits can be used to reduce out of memory (OOM) risks and improve PolarDB stability. N/A

Ganos V4.0

Category Feature Description References
Optimized feature Functions that are used to compute raster surfaces The functions that are used to compute raster surfaces are optimized. The optimized functions return raster objects instead of pixel matrices. ST_Aspect, ST_Slope, and ST_Hillshade
ST_Split function The ST_Split function is optimized. The optimized function splits a trajectory object based on a specified rule and returns an array of sub-trajectories. ST_Split
Fixed issue The bug due to which the ST_SrEqual function fails to check whether two spatial reference systems are the same in specific scenarios is fixed.

August 2021

Minor version 1.1.15

Category Feature Description References
New feature Support for using the Index Advisor to log execution costs before and after indexing Two columns are added to the index_advisor_log table to indicate the execution costs that are incurred before and after each index is created. This helps upper-layer applications such as Database Autonomy Service (DAS) evaluate the benefits of indexing. N/A
Accelerated creation of global indexes by cross-node parallel execution Cross-node parallel execution can be used to accelerate the process of creating global B-tree indexes. Cross-node parallel execution, Use cross-node parallel execution to accelerate index creation, and Create a global index

July 2021

Minor version 1.1.14

Category Feature Description References
New feature Compatibility with GNU Compiler Collection (GCC) 9 PolarDB for Oracle is compatible with GCC 9.2.1. This can optimize compilation and improve performance. N/A
Hints in statement outlines Hints can be specified in statement outlines to control how the optimizer generates execution plans based on the statement outlines. Adjust execution plans
Cross-node parallel execution on hash partitions Parallel execution across hash partitions is supported. This helps balance I/O loads and improve system performance. Use the cross-node parallel execution feature to query data from partitioned tables
DDL operations on partitioned tables that have global indexes defined Global indexes on a partitioned table can be managed when you perform DDL operations such as DROP, SPLIT, and MERGE on the partitioned table. Supported DDL operations on partitioned tables
Optimized feature Compatibility with the ORA_HASH function The ORA_HASH function is replaced with the DBMS_UTILITY.GET_HASH_VALUE function. The DBMS_UTILITY.GET_HASH_VALUE function is used to calculate the hash value of a specified string. N/A

Ganos V3.9

Category Feature Description References
New feature ST_RemoveDriftPoints function The ST_RemoveDriftPoints function is supported. This function is used to delete drift points from a trajectory based on specified rules. ST_removeDriftPoints
ST_Split function The ST_Split function is supported. This function is used to split a trajectory based on a specified geometry object. ST_Split
ST_ExportTo function The ST_ExportTo function is supported. This function is used to export a trajectory from a database to an external file for storage. Only metadata is retained in the database. ST_ExportTo
ST_IsExternal function The ST_IsExternal function is supported. This function is used to check whether a trajectory is stored in an external file. ST_IsExternal
ST_ImportFrom function The ST_ImportFrom function is supported. This function is used to import a trajectory from an external file back to a database. ST_importFrom
ST_StorageLocation function The ST_StorageLocation function is supported. This function is used to return the external location of a trajectory. ST_StorageLocation
ST_AKID function The ST_AKID function is supported. This function is used to return an AccessKey ID that is used to read a trajectory from OSS. ST_AKID
ST_SetAccessKey function The ST_SetAccessKey function is supported. This function is used to configure an AccessKey pair that is used to read a trajectory from OSS. An AccessKey pair consists of an AccessKey ID and an AccessKey secret. An AccessKey ID is similar to a logon username, and an AccessKey secret is similar to a password. ST_SetAccessKey
ST_SetAKID function The ST_SetAKID function is supported. This function is used to configure an AccessKey ID that is used to read a trajectory from OSS. ST_SetAkId
ST_SetAKSecret function The ST_SetAKSecret function is supported. This function is used to configure an AccessKey secret that is used to read a trajectory from OSS. ST_SetAkSecret
ST_SetStorageLocation function The ST_SetStorageLocation function is supported. This function is used to configure the external location from which a trajectory can be read. ST_SetStorageLocation
ST_DeleteGtf function The ST_DeleteGtf function is supported. This function is used to delete all exported trajectory files in a specified folder. ST_DeleteGTF
Fixed issue The bug due to which data cannot be filtered based on strings when a vector pyramid is being created is fixed.
The bug due to which layers cannot be displayed when QGIS is connected is fixed.

June 2021

Minor version 1.1.13

Category Feature Description References
New feature Display of I/O statistics in the polar_stat_sql and polar_stat_plan views
  • The relevant resource information can be obtained by querying different views. This can help identify performance issues.
  • Performance diagnostics is supported by PolarDB for Oracle. This allows you to analyze performance issues related to instances and SQL queries.
  • Relevant parameters are supported to display I/O statistics in the polar_stat_sql and polar_stat_plan views.
Performance views and Performance diagnostics
Cross-node parallel execution Cross-node parallel execution can be used to scan Block Range Indexes (BRIN indexes). This further improves query performance. Overview of cross-node parallel execution
The polar_bt_write_page_buffer_size parameter is supported. This parameter specifies the write I/O policy that is used while an index is being created. Use cross-node parallel execution to accelerate index creation
The following three granularities can be used to specify a query range when you use cross-node parallel execution:
  • System: specifies whether cross-node parallel execution is applied to all the queries that run in all sessions.
  • Session: specifies whether cross-node parallel execution is applied to the current session.
  • Query: specifies whether cross-node parallel execution is applied to specific queries.
Use the cross-node parallel execution feature to run analytical queries
Cross-node parallel execution can be used for partitioned tables to improve database performance. Use the cross-node parallel execution feature to query data from partitioned tables
Optimized feature polar_crash_recovery_rto parameter The polar_crash_recovery_rto parameter is supported. This parameter specifies an expected recovery time objective (RTO) for an instance. This ensures that databases on an instance can restart for recovery and become available within the expected RTO if the instance fails. N/A

Ganos V3.8

Category Feature Description References
New feature ST_AsDatasetFile function The ST_AsDatasetFile function is supported. This function is used to return a specified range of raster objects as a binary stream in the specified file format. ST_AsDatasetFile
ST_RasterDrivers function The ST_RasterDrivers function is supported. This function is used to query the status of all raster data drivers. ST_RasterDrivers
Fixed issue The following issue is fixed: A reprojection fails when you use the ST_Clip function to specify a spatial reference system for the reprojection.

May 2021

Minor version 1.1.12

Category Feature Description References
New feature Cross-node parallel execution Cross-node parallel execution is supported.
  • SQL queries can be run across multiple read-only nodes in a distributed manner. This improves the query performance of PolarDB for Oracle.
  • Cross-node parallel execution can be used to accelerate the process of creating indexes in scenarios where large tables are used.
Cross-node parallel execution
Support of partitioned tables for global indexes Global indexes can be created on partitioned tables. Indexes can be created in parallel. This means that DML operations on a partitioned table are not blocked while an index is being created on the table. Create a global index
Optimized feature Performance monitoring The max_slot_wal_keep_size parameter is supported. This parameter is used to limit the size of files that use replication slots. This can prevent Write-Ahead Logging (WAL) files from accumulating. N/A
DBLink By default, functions that do not meet collation requirements and ANY() and ALL() expressions can be pushed down. This improves query performance. You can use the polar_enable_pushable_unsafe_collate_remote and polar_enable_pushable_all_any_remote parameters to disable these settings. Use a database link to query data across databases
Rownum ROWNUM is optimized. As a result, ROWNUM values can be compared with the values of the VARCHAR2 or TEXT type. N/A
polar_resource_group plug-in Multiple parameters including total_mem_limit_remain_size, idle_mem_limit_rate, enable_terminate_active, policy_mem_release, and enable_log can be used to configure the polar_resource_group plug-in. This avoids excessive usage of memory and ensures the normal running of database processes. N/A
Improved startup speed of read-only nodes The startup of read-only nodes is sped up. This improves performance. N/A
Failover The parallel playback feature can be used to accelerate the recovery of database services after a failover. In most cases, the database services can be recovered within 15 seconds after a primary database fails. N/A

Ganos V3.7

Category Feature Description References
New feature Spatio-temporal parallel query Spatial indexes can be queried in parallel. This improves query efficiency. Enable spatio-temporal parallel query
Optimized feature Raster image processing The ST_SubRaster function can be used to convert the pixel types of raster objects and stretch the pixel values. This function can also be used to convert multi-band remote sensing images into three-band images that can be recognized by AI technologies. ST_SubRaster
Fixed issue The bug due to which Ganos unexpectedly exits when Ganos parses invalid histograms is fixed.
The bug due to which Ganos unexpectedly exits after projection settings are modified is fixed.
The bug due to which Ganos unexpectedly exits when raster data is imported into Ganos is fixed.

April 2021

Minor version 1.1.11

Category Feature Description References
New feature idle_session_timeout parameter

The idle_session_timeout parameter is supported. This parameter specifies the period during which sessions can remain idle before the sessions time out. Sessions are terminated after they time out.

  • Valid values: 0 to 2147483647

    The default value of 0 specifies that the timeout feature is disabled for idle sessions.

  • Unit
    • 'ms': millisecond. This is the default unit.
    • 's': second.
    • 'min': minute.
    • 'h': hour.
    • 'd': day.
Specify parameters
DDL operations related to constraints The ALTER TABLE ... ENABLE/DISABLE CONSTRAINT SQL statement is supported. This statement can be used to enable or disable constraints. ALTER TABLE ... ENABLE/DISABLE CONSTRAINT
DDL operations related to tablespaces DDL operations related to tablespaces are supported. For example, CREATE TABLESPACE can be executed to create tablespaces. N/A
Numeric data types This minor version is compatible with the numeric data types of Oracle. You can enable this feature by specifying the polar_enable_comp_numeric_format parameter. By default, this feature is disabled. To enable this feature, execute the following statement:
SET polar_enable_comp_numeric_format=on;
N/A
Fixed issue The following issue is fixed: The built-in DBMS_JOB package cannot be used across databases.
The following issue is fixed: The CONNECT BY clause and the ROWNUM function cannot be used together.
The following issue is fixed: The CONNECT BY clause cannot find parent objects.

Ganos V3.6

Category Feature Description References
New feature Raster data type The ST_RPCGeoreference function is supported. This function is used to retrieve the information about rational polynomial coefficients (RPCs) of a raster object. ST_RPCGeoreference
The ST_SetRPCGeoreference function is supported. This function is used to specify RPC parameters for a raster object. ST_SetRPCGeoreference
The ST_RPCRectify function is supported. This function is used to rectify a raster object based on the RPC parameters and return the rectified raster object. ST_RPCRectify
GiST indexing A parallel mechanism is added. This mechanism is used to create GiST indexes in parallel. Create spatial indexes in parallel
Fixed issue The following issue is fixed: When you use the pg_dump utility, custom spatial references cannot be exported.

March 2021

Minor version 1.1.10

Category Feature Description References
New feature Partitioned tables BEFORE row-level triggers can be used in partitioned tables. BEFORE row-level trigger
polar_outline plug-in The polar_outline plug-in can be used to adjust execution plans. This optimizes SQL statements. Adjust execution plans
Optimized feature Partitioned tables Subpartition templates can be used for interval range partitioning. Subpartition templates
Performance improvements: The I/O performance of reading data files can be improved by caching information about table sizes into shared memory. N/A
Compatibility The following operators are supported by INTERVAL and FLOAT8 data types:
  • +
  • -
  • *
  • /
N/A
Compatibility The OPT_PARAM hint is added. You can use this hint to specify the values of specific parameters in a single SQL statement. OPT_PARAM Hints

Ganos V3.5

Category Feature Description References
New feature Storage optimization for large spatio-temporal objects The Simple storage policy is supported. This policy optimizes storage for large spatio-temporal objects. Use the Simple storage policy
Optimized feature Raster object The chunked data in a raster object can be automatically deleted when the raster object is updated by using a new raster object. N/A
Fixed issue The bug due to which trajectory-related plug-ins cannot be upgraded is fixed.
The bug that causes resampling errors when the Average resampling method is used to resample rasters is fixed.
The bug due to which inaccurate results are returned for queries on a trajectory object is fixed. This bug is triggered when multiple timestamps show the same trajectory point along the trajectory.
The bug due to which Ganos exits when the conversion of geo-spatial objects fails is fixed. Ganos is optimized to report the causes of the failures.

Minor version 1.1.9

Category Feature Description References
New feature Partitioned tables Interval range partitioning is supported. Interval range partitioning is an extension to range partitioning. Interval range partitioning allows a database to automatically create a partition if data to be inserted exceeds the range of an existing partition. Interval range partitioning
Range-partitioned tables can be converted into interval-range partitioned tables. Interval-range partitioned tables can be converted into range-partitioned tables. Switch between range partitioning and interval range partitioning
Subpartition templates are supported. You can use subpartition templates to define subpartitions and simplify the specifications of subpartitions. You need to define subpartition descriptors in a subpartition template only once and then apply the subpartition template to each partition in a table. This way, you can define the subpartition descriptors for multiple partitions in the table at a time. Subpartition templates
Automatic Workload Repository (AWR) for performance monitoring AWR is supported. AWR collects and analyzes performance statistics. You can use AWR to generate an analytical report for a specified period based on statistics such as dynamic views of a database. This allows you to analyze the database performance within the specified period. N/A
Optimized feature Partitioned tables Partition pruning is enabled in the execution plan for a partitioned table. This improves query performance. N/A
Type PolarDB for Oracle uses TIMESTAMP as the DATE data type. A TIMESTAMP value is accurate to microseconds. In Oracle, a DATE value is accurate to seconds. To ensure compatibility between PolarDB for Oracle and Oracle, the system automatically converts a DATE value into a TIMESTAMP(0) value. N/A
WAL The pipeline technology is supported. This technology is used to reduce the proportion of WAL overhead. This can improve overall system performance. N/A
TO_CHAR TO_CHAR(text1, text2) is supported. This function automatically identifies the data type of text1 and text2 on the server side. If text1 and text2 are valid DATE values, the function automatically converts text1 into a TIMESTAMP value. N/A
Fixed issue Invalid SIGHUP signals are deleted.
The following issue is fixed: The system stops responding when you execute the MERGE INTO statement for a partitioned table.
The following issue is fixed: An "illegal memory access" error occurs when you use pg_icu_collate_names.
The following issue is fixed: An "illegal memory access" error occurs when you execute the ALTER QUEUE ADD CALL statement.
The following issue is fixed: An "illegal memory access" error occurs when you enter a string of a variable length in the rdname field of a POLICY system table. This error is returned because the data type of the rdname field is set to a fixed-length data type.
The following issue is fixed: The return values of functions are truncated because the functions are not declared in the Transparent Data Encryption (TDE) feature.
The following issue is fixed: The roaringbitmap plug-in encounters an "illegal memory access" error when invalid parameters are specified.
The following issue is fixed: If the synchronization latency is high when logs are synchronized from a primary node to read-only nodes, the read-only nodes may not immediately provide feedback on streaming replication to the primary node. As a result, the streaming replication is interrupted.

Ganos V3.4

Category Feature Description References
New feature Storage optimization for large spatio-temporal objects The feature signatures of large spatio-temporal objects are used. This accelerates the process of creating indexes on spatio-temporal data, makes spatial queries more efficient, and optimizes the storage modes of spatio-temporal objects. The polar_enable_storage_partial parameter is also supported. You can specify this parameter to enable the metadata of spatio-temporal objects to be stored in-row and the entity data of spatio-temporal objects to be stored off-row. Feature signature-based storage optimization for large spatio-temporal objects
Parallel execution of functions supported by the raster module The ST_ImportFrom function is supported. This function is used to import raster data in parallel. ST_ImportFrom
The ST_BuildPyramid function is supported. This function is used to create pyramids in parallel based on raster data. ST_BuildPyramid
Trajectory Empty Empty trajectory objects are supported, and null trajectory objects can be returned if the specified requirements are not met. N/A
Fixed issue The bug due to which the ST_AddZ function returns inaccurate results is fixed. This bug is triggered when the values of input parameters are 16-bit signed integers.
The bug due to which the trajectory module cannot be upgraded is fixed.
The bug due to which specific functions of the trajectory module cannot use indexes is fixed.
The bug due to which specific ND functions cannot run as expected is fixed. If this bug is triggered, these ND functions cannot identify two periods of time that do not intersect and consequently return the value error rather than the value false.

January 2021

Minor version 1.1.8

Category Feature Description References
New feature DBMS_STATS plug-in The DBMS_STATS plug-in is supported. You can use this plug-in to collect relevant statistics while the database is running, back up statistics, and restore statistics from backups. DBMS_STATS
Transaction splitting after a write request Transaction splitting is supported for transactions that contain statements for read requests that are sent after a write request at the READ COMMITTED isolation level. All read requests that are generated from the start time to the end time of a transaction can be sent to read-only nodes. This ensures read/write consistency in the transaction. Transaction splitting
Optimized feature Support for expressions that contain the OR operator In earlier versions, an expression that contains the OR operator cannot be converted into an expression that contains the UNION ALL operator. This makes queries inefficient because full table scans are performed. In the latest version, an expression that contains the OR operator is automatically converted into an expression that contains the UNION ALL operator. This optimizes the logic and improves query performance. N/A
Compatibility with ECPG
  • ECPGPlus is compatible with the partial syntax of Pro*C.
  • ECPGPlus is compatible with the connection methods that are supported by native Oracle.
N/A
Compatibility with Oracle The GROUP BY CONST/EMPTY clause is compatible with Oracle syntax. N/A
PBP By default, the persistent buffer pool for a primary node is enabled. N/A
Synchronization of partitioned tables to Kafka The process of synchronizing the configurations of a partitioned table from PolarDB for Oracle to Kafka is optimized. Data is synchronized to Kafka based on parent tables. After data is synchronized, parent tables that use the same names as the source tables are created on Kafka. N/A
Users The following syntax is adjusted: CREATE USER ... IDENTIFIED BY .... This syntax is used to create only standard users. Create a user
Fixed issue The following issue is fixed: When logical replication is used to synchronize DBMS_JOB tables that do not have primary keys, tasks fail to be deleted.
The following issue is fixed: A memory leak occurs in the processes of resource groups if the memory usage exceeds the upper limit.
The following issue is fixed: Standby Promote requires a long period of time.
The following issue is fixed: The temporary table parameter in the temporary field of the ***_all_tables view is abnormally displayed.
The following issue is fixed: A "memory access out of bounds" error is recorded in audit logs.
The following issue is fixed: When you use a database link that connects a PolarDB for Oracle database to a PostgreSQL database to query data, the query result is truncated.
The issues that occur during subpartition pruning based on multi-partition key columns for partitioned tables are fixed.

Ganos V3.3

Category Feature Description References
New feature ST_JaccardSimilarity function The ST_JaccardSimilarity function is supported. This function is used to calculate the similarity between trajectory objects. ST_JaccardSimilarity
ST_Transform function The ST_Transform function is supported. This function is used to transform the coordinate of a trajectory between spatial reference systems. ST_Transform
Optimized feature Vector pyramid A new parameter is provided. This parameter is used to specify the spatial extent of a vector pyramid when Ganos cannot automatically calculate the spatial extent of the vector pyramid that users want to build. N/A
Fixed issue The bug that causes invalid data catalogs is fixed.

December 2020

Minor version 1.1.7

Category Feature Description References
New feature Partitioned tables The Merge Partitions feature is added to merge two partitioned tables.
Compatibility with decoding in Oracle Base64 decoding used in Oracle is supported. The BASE64_DECODE function can automatically identify an invalid encoded string and decode the first valid part of the string. polar_enable_base64_decode
Date format Dates in the YYYYMMDDHH24MISS format can be inserted or updated. N/A
SYS.***_TAB_COLS view The SYS.***_TAB_COLS view is supported. This view can be used to query columns of tables and views.
polar_utility plug-in The polar_utility plug-in is added. polar_utility
Stored procedure Holdable refcursors can be returned by stored procedures. N/A
DBMS_JOB package The DBMS_JOB package is added. You can invoke the package or schedule it across databases by using a privileged account. DBMS_JOB
Optimized feature UTL_ENCODE The UTL_ENCODE plug-in can be used by newly created standard users. UTL_ENCODE
polar_agg plug-in By default, the polar_agg plug-in is enabled. N/A
fdw plug-in The stability of the fdw plug-in is improved. N/A
Fixed issue The following issue is fixed: An error occurs when you execute SELECT INTO to query null values in a stored procedure.
The following issue is fixed: The constraints become invalid when an index scan is performed after you execute ALTER TABLE… EXCHANGE PARTITION.

Upload media files by using the ApsaraVideo VOD console

Category Feature Description References
New feature DBLink

A database link can be established from a PolarDB for Oracle database to a self-managed PostgreSQL database hosted on an Elastic Compute Service (ECS) instance. This way, you can connect a PolarDB for Oracle database to a PostgreSQL database. You can also connect a PostgreSQL database to a PolarDB for Oracle database by using a database link in PostgreSQL. This way, the PolarDB for Oracle database and the PostgreSQL database can communicate with each other.

To create a database link in the console, choose Settings and Management > Databases on the cluster details page.

dblink
Create a database link from PolarDB for Oracle to PostgreSQL

Ganos V3.2

Category Feature Description References
New feature ST_AsPNG BYTEA-type images can be returned for vector pyramids. This feature can be used to visualize vector data. ST_AsPNG
Raster data The JPEG 2000 compression algorithm is added. This algorithm is used to compress 16-bit raster data before the data is stored. N/A
Optimized feature st_dwithin The ST_DWithin function is optimized to query distances at higher performance. N/A
Fixed issue The bug that causes an improper intersection of trajectory objects on the t axis is fixed.
The issues related to the memory topology indexes that are supported by Ganos are fixed.

API

Category Feature Description
Optimized feature CreateDBLink Database links can be created to connect PolarDB for Oracle databases to self-managed PostgreSQL databases that are hosted on ECS instances.

November 2020

Minor version 1.1.6

Category Feature Description References
New feature Compatibility This minor version is compatible with PostgreSQL 11.9. What is ?
Primary/secondary switchover By default, the OnlinePromote feature is enabled. This feature reduces the amount of time that is consumed by a failover and improves cluster availability. Automatic failover and manual failover
DBLink Database links can be used to connect databases across PolarDB for Oracle clusters. Database link overview
Fixed issue The following issue is fixed: A node does not restart smoothly in some scenarios.
The following issue is fixed: In some scenarios, clusters do not respond due to OOM errors.
The following issue is fixed: In some scenarios, read-only nodes do not respond.
The following issue is fixed: An error occurs when the UTF-8 encoding format is converted into GBK after you run the client_encoding=gbk command.
The following issue is fixed: An error occurs when the first parameter of the NVL function is left empty.

Upload media files by using the ApsaraVideo VOD console

Category Feature Description References
New feature DBLink

A database link can be created to connect a PolarDB for Oracle database to another PolarDB for Oracle database. This allows you to access data across PolarDB for Oracle databases.

To create a database link in the console, choose Settings and Management > Databases on the cluster details page.

dblink
Database link overview

API

Category Feature Description
New feature CreateDBLink This operation can be called to create a database link for a PolarDB for Oracle cluster.
DescribeDBLinks This operation can be called to query database links for a PolarDB for Oracle cluster.
DeleteDBLink This operation can be called to delete a database link for a PolarDB for Oracle cluster.

October 2020

Minor version 1.1.5

Category Feature Description References
New feature audit log Precompiled SQL statements in audit logs can be displayed as executable SQL statements. N/A
Hash partitioning The syntax that is used to create a specified number of hash partitioned tables is added. CREATE TABLE ... PARTITION BY HASH
Partitioned tables The name of a partition or a subpartition can be specified when you query data of a specific partition. Query a specified partition
HOST parameter The HOST parameter is supported. This parameter is used to obtain the HOST value of a client. N/A
Optimized feature Views The query_id field is added to optimize the polar_stat_activity view. N/A
Compatibility The minor version is updated to 11.8. Several stability issues are fixed. N/A
Fixed issue The following issue is fixed: A semi-synchronization cannot time out.
The following issue is fixed: The CONNECT BY clause cannot be used together with the WITH clause.

Ganos V3.1

Category Feature Description References
New feature Trajectory data type GiST indexes are supported for trajectory objects, and six operator families are provided for users to create GiST indexes in six dimensions. N/A
The BOXND data type is added. This data type is used to describe the spatio-temporal extents of trajectory objects and store trajectory objects. N/A
The following operators are supported: the && operator, the @> operator, and the <@ operator. These operators are used to compare the spatio-temporal relationships between two specified objects from various dimensions. The && operator is used to check whether the two specified objects intersect. The @> operator is used to check whether the left operand-specified object includes the right operand-specified object. The <@ operator is used to check whether the left operand-specified object is included in the right operand-specified object. N/A
The ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin functions are supported to process trajectories.
New features are added. These features are used to collect statistics about trajectory objects and estimate scan costs based on the statistics. N/A
TrajGiST indexes are supported. TrajGiST indexing is an improved indexing method. N/A
ganos_update function The ganos_update function is added. Users can run the select ganos_update() ; command to upgrade all plug-ins of Ganos to the latest versions. N/A
Optimized feature Spatio-temporal range query Spatio-temporal range queries are optimized. The query performance is improved by using optimized GiST index-based two-phase queries. N/A
Vector pyramid Source data from all the coordinate systems that provide spatial reference identifiers (SRIDs) is supported. The source data can be tiles that are based on the EPSG:3857 or EPSG:4326 coordinate reference system. N/A
The pixelSize parameter is supported. This parameter is used to aggregate point data and reduce the number of tiles. N/A
Fixed issue The bug that causes failures in updating rasters is fixed.
The following issue is fixed: An unexpected exit may occur after the binary files of Ganos are upgraded to later versions.
The bug that causes an abnormally large number of tiles at the top layer of a vector pyramid when the default parameter settings are used to build point data for the vector pyramid is fixed.

September 2020

Minor version 1.1.4

Category Feature Description References
New feature GROUP_ID function The GROUP_ID() function is supported. GROUP_ID
Partitioned tables The CREATE INDEX CONCURRENTLY statement is supported. This way, you can concurrently create indexes on partitioned tables. N/A
Support for making indexes of standard tables invisible The ALTER INDEX [NAME] INVISIBLE statement is supported. You can execute this statement to make an index of a standard table invisible. N/A
ali_decoding plug-in The ali_decoding plug-in is supported. This plug-in is used to synchronize incremental DML statements between databases. N/A
pg_cron plug-in The pg_cron plug-in is supported. This plug-in is used to query the records of scheduled tasks. PG_CRON
to_char() Strings can be specified in the TO_CHAR() function. N/A
Type The following operators are added to compare the prid_ data type of the ROWID column with a string data type such as TEXT. These operators are also used to compare a string data type such as TEXT with the prid_ data type of the ROWID column.
  • <
  • <=
  • >
  • >=
  • =
  • <>
N/A
Views The views that display process status statistics are added. N/A
The views that display time consumption statistics for SQL statements are added. N/A
Audit logging SQL errors are recorded in audit logs. N/A
Fixed issue The following issue is fixed: In specific scenarios, page prefetching may cause deadlocks.
The following issue is fixed: A JOIN query fails to retrieve the accurate partition during partition pruning.

Ganos V3.0

Category Feature Description References
New feature Support for the subset raster in a NetCDF raster file that has multiple subsets Network Common Data Form (NetCDF) files that contain subsets are supported. These files can be imported into specified layers based on the layer names that users specify. N/A
Custom metadata and time series information of rasters The ST_MetaItems function is supported. This function is used to obtain the names of all custom metadata items. ST_MetaItems
The ST_MetaData function is supported. This function is used to obtain custom metadata items of a raster and return custom metadata items in the JSON format. ST_MetaData
The ST_SetMetaData function is supported. This function is used to specify a metadata item. ST_SetMetaData
The ST_BeginDateTime function is supported. This function is used to obtain the start time of a raster. ST_BeginDateTime
The ST_EndDateTime function is supported. This function is used to obtain the end time of a raster. ST_EndDateTime
The ST_SetBeginDateTime function is supported. This function is used to configure the start time of a raster. ST_SetBeginDateTime
The ST_SetEndDateTime function is supported. This function is used to configure the end time of a raster. ST_SetEndDateTime
The ST_SetDateTime function is supported. This function is used to configure the start time and end time of a raster and the time when a band is obtained. ST_SetDateTime
Support for converting a raster into a BYTEA-type image The ST_AsImage function is supported. This function is used to convert a raster into a BYTEA-type image. ST_AsImage
The ST_AsPng function is supported. This function is used to convert a raster into a BYTEA-type PNG image. ST_AsPNG
The ST_AsJPEG function is supported. This function is used to convert a raster into a BYTEA-type JPEG image. ST_AsJPEG
Support for the GeomGrid data type and operations The GeomGrid data type is supported. GeomGrid SQL reference
The ST_AsText function is supported. This function is used to convert a grid into a text representation. ST_AsText
The ST_AsGeometry function is supported. This function is used to obtain the geometric representation of a grid. ST_AsGeometry
The ST_AsBinary function is supported. This function is used to convert a grid into a binary representation. ST_AsBinary
The ST_AsBox function is supported. This function is used to obtain the box representation of a grid. ST_AsBox
The ST_AsGrid function is supported. This function is used to query the grids that intersect with a geometric object. ST_AsGrid
The ST_GridFromText function is supported. This function is used to convert a grid from a text representation into a GeomGrid representation. ST_GridFromText
The ST_GridFromBinary function is supported. This function is used to convert a grid from a binary representation into a GeomGrid representation. ST_GridFromBinary
The ST_Intersects function is supported. This function is used to identify the spatial relationship between two raster objects or between a raster object and a geometric object. This function allows you to check whether the first specified object intersects with the second specified object. ST_Intersects
The ST_Contains function is supported. This function is used to identify the spatial relationship between two raster objects or between a raster object and a geometric object. This function allows you to check whether the first specified object contains the second specified object. ST_Contains
The ST_Within function is supported. This function is used to identify the spatial relationship between two grid objects or between a grid object and a geometric object. This function allows you to check whether the first specified object is within the second specified object. ST_Within
Rapid display and storage of vector data The ST_BuildPyramid function is supported. This function is used to create a vector pyramid. ST_BuildPyramid
The ST_DeletePyramid function is supported. This function is used to delete a vector pyramid. ST_DeletePyramid
The ST_Tile function is supported. This function is used to obtain vector data in the MVT format. ST_Tile
Fixed issue The following issue is fixed: In some cases, OOM errors occur when you create pyramids.
The following issue is fixed: Trajectory objects on January 1, 2000 cannot be created.
The bug due to which the ST_Intersection function returns inaccurate sub-trajectories for a moving object is fixed.
The following issue is fixed: The system stops responding during a Ganos upgrade.
This minor version is compatible with PostGIS 2.5.4.

August 2020

Minor version 1.1.3

Category Feature Description References
New feature Views The views that display SQL execution statistics are added. N/A
The views that display queries per second (QPS) statistics are added. N/A
The views that display CGroup status statistics are added. N/A
Privileged account The SELECT permissions on dba_* views are granted to the accounts that have the polar_superuser permissions. N/A
Fixed issue The following issue is fixed: A display error is returned for the polar_stat_io_info view.
The following issue is fixed: The AWR system wait information is missing.
The following issue is fixed: An error occurs during partition pruning for a partitioned table.
The following issue is fixed: An error occurs when the Segmented Least Recently Used (SLRU) algorithm is used to calculate the memory size.
The following issue is fixed: Read-only nodes are recreated due to a playback latency.

Ganos V2.9

Category Feature Description References
New feature Support for Cloud Optimized GeoTIFF (COG) files The COG files are supported. The pyramid information that is stored in COG files can be read. N/A
ST_AddZ function The ST_AddZ function is supported. This function is used to specify the Z coordinate of a geometry object based on the pixel value of the raster that is converted from the geometry object. ST_AddZ
Enhanced capabilities for obtaining the spatial extent information about raster objects The ST_Extent function is supported. This function is used to retrieve the spatial extent of a raster object and return the box representation of the raster object. ST_Extent
The ST_Envelope function is supported. This function is used to retrieve the spatial extent of a raster object and return the spatial extent in the format of a geometry object. ST_Envelope
The ST_ConvexHull function is supported. This function is used to retrieve the spatial extent of a raster object and return the spatial extent in the format of a geometry object. ST_ConvexHull
The ST_Height function is supported. This function is used to retrieve the pixel height of a raster object. ST_Height
The ST_Width function is supported. This function is used to retrieve the pixel width of a raster object. ST_Width
Fixed issue The following issue is fixed: Performance bottlenecks occur when raster objects that are stored in external storage locations use a chunking dimension of 1 × n. You can configure storage parameters to customize the size of the chunking dimension.
The bug due to which the ST_Values function returns linear objects whose coordinates on specific axes do not follow the sorting rules is fixed.
The bug due to which the ST_BestPyramidLevel function returns negative values is fixed
The bug due to which the ST_BuildPyramid function repeatedly builds pyramids is fixed.
The bug due to which chunk tables cannot be cleared in a timely manner when users truncate raster tables is fixed.
The bug due to which the ST_ExportTo function is invalid on the CreateOption parameter is fixed.
The bug that causes errors when the ST_ClearChunks function is invoked is fixed. This bug is triggered when the name of the table on which the function is invoked contains both uppercase letters and lowercase letters.
The bug that causes failures in creating an overview for an external pyramid is fixed.
The bug that causes failures in creating an internal pyramid for a raster that has an external pyramid is fixed.
The bug due to which inaccurate statistics are returned for queries on rasters is fixed. This bug is triggered when the rasters contain NaN values.

July 2020

Minor version 1.1.2

Category Feature Description References
New feature Pivot syntax An alias can be specified for a table or a subquery in the Pivot syntax. N/A
ROWID pseudocolumn The ROWID pseudocolumn and the ROWIDTOCHAR and CHARTOROWID functions are supported. N/A
Built-in functions The LNNVL, DUMP, SYS_CONTEXT, USERENV, TZ_OFFSET, and VSIZE functions are supported. N/A
DBMS_JOB and DBMS_SCHEDULER DBMS_JOB and DBMS_SCHEDULER are supported. They are used to maintain and manage jobs. N/A
Temporary table Temporary tables can be written to local storage. This improves the read and write performance of temporary tables. N/A
Event trigger Logical replication can be performed on events captured by the event trigger. Accounts that have the polar_superuser permissions can perform logical replication. N/A
Custom resource group Requests can be initiated by custom resource groups. N/A
Optimized feature Process of recovery from a failure The process to recover from a failure is optimized. This reduces the amount of time that is required to recover from a failure in extreme cases. N/A
Fixed issue The following issue is fixed: Accounts that have the polar_superuser permissions cannot use the Index Advisor.

Ganos V2.8

Category Feature Description References
New feature Enhanced interfaces that are used to access raster metadata The ST_XMin function is supported. This function is used to obtain the minimum value in a set of rasters on the X-axis. ST_XMin
The ST_YMin function is supported. This function is used to obtain the minimum value in a set of rasters on the Y-axis. ST_YMin
The ST_XMax function is supported. This function is used to obtain the maximum value in a set of rasters on the X-axis. ST_XMax
The ST_YMax function is supported. This function is used to obtain the maximum value in a set of rasters on the Y-axis. ST_YMax
The ST_ChunkHeight function is supported. This function is used to obtain the height of a raster tile. ST_ChunkHeight
The ST_ChunkWidth function is supported. This function is used to obtain the width of a raster tile. ST_ChunkWidth
The ST_ChunkBands function is supported. This function is used to obtain the number of bands of a raster tile. ST_ChunkBands
ST_SrFromEsriWkt function The ST_SrFromEsriWkt function is supported. This function is used to convert the format of a spatial reference string from Esri into Open Geospatial Consortium (OGC). ST_SrFromEsriWkt
Raster data type The Zstandard (Zstd) compression algorithm and the Snappy compression algorithm are added. These algorithms are used to compress raster data. N/A
Point cloud data type Point cloud files can be copied in binary format. N/A
Environment variables The PROJ_LIB and GDAL_DATA environment variables can be configured, and the relevant data can be deployed. N/A
Fixed issue The bug due to which Ganos unexpectedly exits when an invalid OSS path is specified is fixed.
The bug that causes inconsistencies between the imported SRIDs and original SRIDs of specific rasters is fixed.

June 2020

Minor version 1.1.1

Category Feature Description References
New feature NVL2 function The NVL2 function is supported. This function is used to return the value of the second or third parameter based on whether the value of the first parameter is NULL or an empty string. N/A
polar_proxy_utils plug-in The polar_proxy_utils plug-in is supported. This plug-in is used to manage proxy-related features. This plug-in allows you to configure read-only Universal Disk Format (UDF) files and read-only tables. This plug-in also allows you to use a cluster endpoint to route requests for accessing read-only UDF files and read-only tables to the read-only nodes in the cluster. N/A
polar_resource_group plug-in The polar_resource_group plug-in is supported. This plug-in is used to customize resource groups. You can use the custom resource groups to isolate resources such as CPUs and memory on a per-user, per-database, or per-session basis. N/A
Optimized feature Reliability and availability The compute nodes of databases are decoupled from file systems. This allows you to perform O&M operations on the file systems. This improves the reliability and availability of databases. N/A
Transaction processing The snapshot of the active transaction list is replaced with a commit sequence number (CSN). Each CSN is a monotonically increasing identifier. This improves the transaction processing performance of databases. N/A
Execution plan Execution plans are optimized to prevent obsolete statistics from being used. N/A
Fixed issue The following issue is fixed: A database process failure occurs when the timescaledb plug-in fails to request memory resources.
The following issue is fixed: The I/O monitoring feature does not provide data statistics after a process exits.
The following issue is fixed: A null pointer exception may occur after lock_debug is enabled.
The following issue is fixed: In specific cases, the pg_cron plug-in becomes unavailable.
Known issues of distributed shared memory (DSM) deadlocks in the community edition are fixed.
The following issue is fixed: The number of connections exceeds the upper limit.

May 2020

Minor version 1.1.0

Category Feature Description References
New feature TO_SINGLE_BYTE function The TO_SINGLE_BYTE function is supported. This function is used to convert multi-byte characters in a string into single-byte characters. TO_SINGLE_BYTE and TO_MULTI_BYTE functions
TO_MULTI_BYTE function The TO_MULTI_BYTE function is supported. This function is used to convert single-byte characters in a string into multi-byte characters. TO_SINGLE_BYTE and TO_MULTI_BYTE functions
REGEXP_LIKE function The REGEXP_LIKE function is supported. You can use this function in a way similar to how the LIKE conditional expression is used. The REGEXP_LIKE function complies with the POSIX regular expression standard. N/A
RATIO_TO_REPORT function The RATIO_TO_REPORT function is supported. This function is used to calculate the ratio of a value to the sum of a set of values. N/A
DBMS_UTILITY.FORMAT_ERROR_STACK function The DBMS_UTILITY.FORMAT_ERROR_STACK function (macro) is supported. This function is used to return stack information and error messages layer by layer. N/A
UTL_I18N.ESCAPE_REFERENCE and UTL_I18N.UNESCAPE_REFERENCE functions The UTL_I18N.ESCAPE_REFERENCE and UTL_I18N.UNESCAPE_REFERENCE functions are supported. These functions provide escape and unescape mechanisms for HTML or XML characters. N/A
INSERT ALL statement The INSERT ALL statement is supported. You can execute the INSERT ALL statement to insert data into multiple tables at a time. N/A
polar_concurrency_control plug-in The polar_concurrency_control plug-in is supported. This plug-in is used to configure a concurrency limit on transaction executions, SQL queries, stored procedures, and DML operations. You can customize large queries and configure a concurrency limit on large queries to improve the execution efficiency in high concurrency scenarios. N/A
pldebugger plug-in The pldebugger plug-in is supported. This plug-in is used to debug local stored procedures. You can use the client pgAdmin4 V4.19 or later. Use the pldebugger plug-in
oss_fdw plug-in The oss_fdw plug-in is supported. This plug-in is used to support external tables of Alibaba Cloud OSS. You can use OSS external tables to write data of databases to OSS or load data from OSS to databases. You can use multiple external tables in parallel or compress data during imports and exports. This improves the performance of data imports and exports. You can also use this feature to separate hot data and cold data that are stored in a wide range of storage media. Read and write foreign data files by using oss_fdw
Optimized feature ROUND function The ROUND function is optimized to support the Interval data type. The returned values are measured in days. ROUND
polar_stat_activity view The polar_stat_activity view is optimized. The wait_info and wait_time columns are added. The wait_info column displays the object for which the current process is waiting. The wait_time column displays the amount of time for which the process needs to wait. If the object is a process, the process identifier (PID) is displayed. If the object is a file, the file descriptor (FD) is displayed. N/A
Indexing The pre-extension feature is supported. This feature automatically adds additional index pages when index pages are insufficient for new indexes. This improves the execution performance when data is inserted into a table that has indexes. N/A

Ganos V2.7

Category Feature Description References
New feature MD5 functions The ST_MD5Sum function is supported. This function is used to obtain the MD5 hash value of a raster object. ST_MD5Sum
The ST_SetMD5Sum function is supported. This function is used to configure the MD5 hash value of a raster object. ST_SetMD5Sum
Authentication method of spatial raster objects that are stored in OSS The ST_AKId function is supported. This function is used to obtain the AccessKey ID that is used to access a raster object stored in OSS. ST_AKId
The ST_SetAccessKey function is supported. This function is used to configure the AccessKey ID and the AccessKey secret that are used to access a raster object stored in OSS. ST_SetAccessKey
The ST_SetAKId function is supported. This function is used to configure the AccessKey ID that is used to access a raster object stored in OSS. ST_SetAKId
The ST_SetAKSecret function is supported. This function is used to configure the AccessKey secret that is used to access a raster object stored in OSS. ST_SetAKSecret
Functions that are used to manage spatial raster metadata The ST_ScaleX function is supported. This function is used to obtain the pixel width of a raster object on the X-axis of the spatial reference system. ST_ScaleX
The ST_ScaleY function is supported. This function is used to obtain the pixel width of a raster object on the Y-axis of the spatial reference system. ST_ScaleY
The ST_SetScale function is supported. This function is used to configure the pixel width of a raster object in the spatial reference system. ST_ScaleY
The ST_SkewX function is supported. This function is used to obtain the skew of a raster object on the X-axis of the spatial reference system. ST_SkewX
The ST_SkewY function is supported. This function is used to obtain the skew of a raster object on the Y-axis of the spatial reference system. ST_SkewY
The ST_SetSkew function is supported. This function is used to specify the skew of a raster object in the spatial reference system. ST_SetSkew
The ST_UpperLeftX function is supported. This function is used to obtain the upper-left X-coordinate of a raster object in the spatial reference system. ST_UpperLeftX
The ST_UpperLeftY function is supported. This function is used to obtain the upper-left Y-coordinate of a raster object in the spatial reference system. ST_UpperLeftY
The ST_SetUpperLeft function is supported. This function is used to configure the upper-left coordinates of a raster object in the spatial reference system. ST_SetUpperLeft
The ST_PixelWidth function is supported. This function is used to obtain the pixel width of a raster object in the spatial reference system. ST_PixelWidth
The ST_PixelHeight function is supported. This function is used to obtain the pixel height of a raster object in the spatial reference system. ST_PixelHeight
Fixed issue The following issue is fixed: Aggregate functions result in extension upgrade failures.