CUBRID 11.3 Patch 1 has been released.
In this release, issues found after 11.3.0 released have been fixed.
1. Improvement and Fix
- Changed the handling method of the --split-schema-files option of the unloaddb utility.
* Before changes: Created an empty unique file and added a unique file name to the _schema_info file.
* After changes: Does not create a unique file or add a unique file name to the _schema_info file.
- Fixed an issue where the current_value information in the auto_increment column was missing when using the unloaddb utility.
* Before changes: Created an empty unique file and added a unique file name to the _schema_info file.
* After changes: Does not create a unique file or add a unique file name to the _schema_info file.
- Fixed an issue where the current_value information in the auto_increment column was missing when using the unloaddb utility.
- Fixed a function registration error that occurred when there exists a space between the function name and () for parameter declaration when writing Java SP.
- Fixed a segmentation fault that occurred when passing the value of DATETIMELTZ to the datetime parameter of java SP.
- Added a status check method to prevent it from becoming a zombie process when performing broker/cas process through cubrid_manager.
- Changed the configuration of the JDBC folder in the product release file.
- Fixed an error where the removed user information was not updated in _db_auth table after removing a user.
- When using the --split-schema-files option in the unloaddb utility, the unique index must be separated from the dbname_schema_class file.
- Changed how the Java SP Server's classloader behaves (added the --jni option to the loadjava utility).
- Fixed an optimization error that occurred when the first table in the From clause is removed during inner join optimization.
- Fixed an error where the "SHOW CREATE VIEW" syntax would display views with the same name created by other users.
- Fixed an error that occurred when referring to a server name with the same name created by another user while using DBLINK.
- Fixed an error that occurred when executing a SELECT statement with a ‘WHERE 0 <> 0’ conditional clause in Java SP.
- Fixed a HA start failure error that occurred when the hostname contains uppercase letters.
- Improved the hostname to be case-insensitive when using a user host.
- Fixed an issue where an error occurred due to View Merging of outer join conditions.
- Improved CUBRID Manager Server to support TLS v1.2 client (Caution: Linux only)
- Fixed a segmentation fault that occurred when a table name exceeded 222 bytes.
- Fixed a segmentation fault that occurred when a function or scalar subquery exceeding 255 characters without an alias was used in the select list.
- Modified the location of the temporary file used internally by javaSP to refer to the CUBRID_TMP environment variable.
- Fixed an issue where the result of count(*) was incorrect after loaddb was performed using the --no-logging option.
- Fixed a segmentation fault that occurred when multiple tables and serial functions were used simultaneously in one query.
- Fixed an issue where the temporary volume increases when execute() is performed several times after prepare() a query.
- Fixed a segmentation fault that occurred when a CTE subquery is always a false (or NULL) query.
- Fixed an error caused by alignment sizes in a compression/decompression function used for enhancing the performance of Java SP communication.
- Fixed an issue where the results differed when an index containing a function was used as a covering index.
- Fixed a memory leak that occurred during the execution of the CAS batch processing function (ux_execute_array()).
- Fixed a replace() function result processing error that occurred when setting the oracle_style_empty_string environment variable.
- Changed the environment variable names used in CSQL. For compatibility, previous environment variables may also be used (EDITOR -> CUBRID_CSQL_EDITOR, SHELL -> CUBRID_CSQL_SHELL, FORMATTER -> CUBRID_CSQL_FORMATTER).
- Fixed a string concatenation error that occurred when setting the oracle_style_empty_string environment variable (difference between NULL and an empty string).
- Corrected misclassified size information among the output information of the spacedb utility.
- Fixed an issue where rownum was inappropriately changed to orderby_num() when view merging a subquery containing an ORDER BY clause.
- Made adjustments to automatically restart the cub_javasp process if a JNI crash occurs and terminates.
- Changed the format of error messages related to user hosts files for user convenience.
- Fixed an issue where exit code 0 is returned instead of an error code when an error occurs during loaddb.
- Made adjustments to display an error when inputting the result of an operation that uses a rownum value exceeding the value defined in the numeric type column.
- Fixed a segmentation fault that occurred when using a different charset when using DBLINK.
- Modified the error message output module in Java SP.
- Fixed an error where incorrect results were returned when a query using the javasp function in the order by clause was executed using a driver (JDBC, etc.).
Please refer to the 11.3.1 change logs(https://github.com/CUBRID/cubrid/releases/tag/v11.3.1) for details.
2. Precautions
- When using heterogeneous(Oracle/MySQL) DBLINK, you must use ODBC Drvier for Unicode of Oracle/MySQL.
3. 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
4. Download
- Product download : https://www.cubrid.org/downloads
- Product source code : https://github.com/CUBRID/cubrid/tree/v11.3.1
