CUBRID 10.2 Patch 10 released

posted Jan 06, 2023
CUBRID 10.2 Patch 10 has been released.

In this release, issues found after 10.2.9 released have been fixed.

1. Improvement and Fix
  - Improved to use index scan even when there is a value predicate like '1=1' in the where clause in a hierarchical query.
  - Improved to use index scan when a column name is included in the LIKE conditional expression.
  - Improved to exclude temporary pages from the flush target when executing CHECKPOINT.
  - Fixed an error that occurred when using a CTE with a ROUND function in a DELETE query.
  - Fixed an error where an incorrect message was displayed when an 'Invalid format' error occurred in a MERGE query.
  - Fixed an error where an OUTER JOIN was treated as an INNER JOIN in a query that included an OR operation.
  - Fixed an error where some collections-related (has VARCHAR elements) query returns incorrect result.
  - Fixed an error that returned incorrect results when using the IFNULL function with a numeric type host-variables.
  - Fixed an error that occurred when using PREPARE/EXECUTE statement that includes DECODE.
  - Fixed a segment fault that occurred when SELECT clause had more than 33 analytic functions.
  - Fixed an error that occurred when using function based index with IN clause.
  - Fixed an error that occurred when there is no SELECT result when performing an INSERT + SELECT query.
  - Fixed an error that occurred when CONNECT BY query is executed with the INLINE VIEW that creates temporary records larger than one page.
  - Fixed an error that occurred when PLAN CACHE removed while executing executeBatch().
  - Fixed an errors that fail intermittently when replicating large size records in an HA environment.

  Please refer to the 10.2.10 change logs(https://github.com/CUBRID/cubrid/releases/tag/v10.2.10) for details.

2. Environmental Requirements
  - Linux: 64bit, kernel 2.4 or higher, Windows: Windows7 or higher (Windows 7 requires the latest security updates)
  - JRE 1.8 or higher is required when using JSP or CUBRID Admin/CUBRID Manager

3. Download
  - Product download : https://www.cubrid.org/downloads