Background Image

DOCUMENTATION

Votes 0 Comment 0
?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print
CUBRID 11.2 has been released

Connectivity: Provides scalability between homogeneous and heterogeneous DBs through database link and supplementary logging
Performance Enhancement: Enhanced query performance through query optimizations and Java SP refactoring
Compatibility:  Enhanced compatibility through user schema concept and synonym function

1. Key Features and Improvements 

* Connectivity
  - Provide database link between homogeneous and heterogeneous DBMS
  - Provide CDC function by supporting supplemental logging function that can track changed data

* Performance Enhancement 
  - Improved query optimization such as predicate pushdown and view transformation
  - Improved performance for count(*) when the 'WHERE' is no predicate
  - Improved performance of truncate table 
  - Support Hash List Scan for all subqueries 
  - Support JDBC's statement cache

* SQL Extension Featuers   
  - Support CREATE/DROP server statements for database link
  - Support user schema concept 
  - Support synonym function 
  - Support multiple filtered index on the same column

* Enhancement of Convenience 
  - Provide flashback function that can extract the original query of changed data for each transaction

* Other features enhancements
 
* Other bug fixes

For more details, please refer to the CUBRID 11.2 change logs(https://github.com/CUBRID/cubrid/releases/tag/v11.2and online manuals (https://www.cubrid.org/manual/en/11.2/release_note/index.html

2. Precautions
 - It is not compatible with the volumes of previous versions (11.1 or less), so DB reconfiguration is required when upgrading to 11.2
 - By introducing the concept of user schema, the same object name can be used for each user. According to this support, "." (dot) is not allowed in object names, and --no-user-specified-name option is provided so that loaddb files before 11.2 can be performed in 11.2.
 - When another user accesses the table, it is necessary to include the user name in the table name after grant or use a synonym
 - When using “jdbc:default:connection:” or getDefaultConnection() of JavaSP, the behavior is changed, such as not supporting all functions of java.sql.DatabaseMetaData
 - The behavior of the TRUNCATE TABLE changed if there is set null or cascade of FK
 - Column properties not written during alter change/modify are changed to be maintained, and auto_increment and on update properties cannot be removed with the alter statement
 - Changed to handle an error if only the column name exists(UPDATE ... WHERE c1;) in the where clause
 - Multiple SQL must be separated by semicolons(;)
 - As the CCI Driver directory in the CUBRID package is changed, $CUBRID/cci/lib must be added to the environment variable LD_LIBRARY_PATH when using CCI.
 - Changed Compression (-z, --compress) option to default on backup
 - System catalog information changed or added due to the addition of new features
 - The driver version is managed separately from the CUBRID version. The driver version compatible with CUBRID 11.2 is 11.1

3. Environmental requirements 
 - Linux: 64bit, kernel 2.4 or higher, Windows: Windows7 or higher (Windows7 is needed the latest update patch) 
 - JRE 1.8 or higher is required when using JSP or CUBRID Admin/CUBRID Manager


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

List of Articles
No. Category Subject Date
70 Tool CUBRID Migration Toolkit 11.1.0.0061 Released. 2023.05.31
69 Tool CUBRID Manager 11.1.1.0185 Released 2023.05.26
68 Tool CUBRID Admin 11.1.2.0190 Released 2023.05.26
67 Engine CUBRID 11.0 Patch 11 released 2023.05.09
66 Engine CUBRID 10.2 Patch 11 released 2023.05.09
65 Interface CUBRID JDBC driver 11.1.1.0030 Released 2023.05.02
64 Engine CUBRID 11.2 Patch 4 released 2023.04.27
63 Tool CUBRID Migration Toolkit 11.0.2.0004 Released 2023.02.02
62 Engine CUBRID 11.2 Patch 3 released 2023.01.31
61 Engine CUBRID 11.0 Patch 10 released 2023.01.13
Board Pagination Prev 1 2 3 4 5 6 7 8 9 Next
/ 9

Join the CUBRID Project on