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
 - CUBRID Admin/CUBRID Manager compatible with CUBRID 11.2 will be released in July. If you must use the CUBRID Admin/CUBRID Manager before July, you must use CUBRID 11.0 or lower version.

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
 - 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


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

  1. CUBRID 11.0 Patch 7 Released

    Date2022.06.09 CategoryEngine
    Read More
  2. CUBRID 10.2 Patch 8 Released

    Date2022.06.09 CategoryEngine
    Read More
  3. CUBRID 11.2 Released

    Date2022.05.23 CategoryEngine
    Read More
  4. CUBRID 11.0 Patch 6 Released

    Date2022.02.17 CategoryEngine
    Read More
  5. CUBRID 10.2 Patch 7 Released

    Date2022.01.19 CategoryEngine
    Read More
  6. CUBRID 10.2 Patch 6 Released

    Date2021.12.17 CategoryEngine
    Read More
  7. CUBRID 11.0 Patch 5 Released

    Date2021.12.02 CategoryEngine
    Read More
  8. CUBRID Migration Toolkit 11.0.0.0002 Released

    Date2021.11.10 CategoryTool
    Read More
  9. CUBRID 11.0 Patch 4 Released

    Date2021.10.29 CategoryEngine
    Read More
  10. CUBRID 11.0 Patch 3 Released

    Date2021.10.14 CategoryEngine
    Read More
Board Pagination Prev 1 2 3 4 5 Next
/ 5

Join the CUBRID Project on