Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Current Events
Join our developers event to win one of the valuable prizes!
posted 7 years ago
viewed 3757 times
Share this article

CUBRID 8.3.1 Beta: New Data Types. New Functions.

We are proud to announce the beta release for CUBRID 8.3.1! Even thought this is beta, it is very close to production level. Starting from CUBRID 3.x release we changed our Release Model. Now on for every release we will have one beta, then the production version. We decided so because the pace of new features introduction or performance enhancements in CUBRID is relatively high. So we want users to test out the new features during the beta releases, and report issues if found. However, each beta release will undergo the same quality assurance test environment as the next stable version will do. So, practically, beta is a stable release with a beta label. This is to ensure that once the stable version is out, the release is really stable. This is about the new CUBRID Release Model.

CUBRID 8.3.1 beta

CUBRID is growing really fast! The new CUBRID 8.3.1 beta has many nice features and enhancements. Download it from

New Features

  1. The new BLOB and CLOB data types.

    The BLOB and CLOB data types allow to save large objects such as images, videos, audio files, or long texts. The BLOB is a type used to save binary data and the CLOB is a type used to save string data. When BLOB or CLOB data is inserted, the data is saved as a separate file to the external storage instead of the database volume itself, and the location information (LOB locator) of the file will be saved in the CUBRID database. The top-level directory where the BLOB or CLOB data is to be saved, can be specified when a database is created. If it is not specified, the data is saved into the lob directory of a path where the database volume is created. For the convenient applications development, CUBRID provides the JDBC/CCI standard methods such as getBlob/setBlob and cci_blob_write/cci_blob_read respectively, and the SQL functions such as CLOB_FROM_FILE and BLOB_FROM_FILE. For the complete list of available functions see the Release Note. Prior to 8.3.1 release the binary storage functionality has been supported by GLO data type with corresponding functions, which will no longer be supported starting from this version.

  2. The HA (High-Availability) status monitoring feature.

    The HA status monitoring feature has been added to the CUBRID Manager to improve the convenience of database management. It allows DBAs to monitor the operating status of several components such as the database server, broker, HA, and system resources.

  3. Added a function that gets foreign key information from the JDBC/CCI APIs.

    New methods are added to JDBC such as getImportedKeys, getExportedKeys, getCrossReference. CCI has CCI_SCH_IMPORTED_KEYS, CCI_SCH_EXPORTED_KEYS, CCI_SCH_CROSS_REFERENCE.

  4. Added a function that gets schema information from ODBC.

    New ODBC functions: SQLForeignKeys, SQLPrimaryKeys, SQLProcedures, SQLProcedureColumns, SQLTablePrivileges.

Enhanced Features

  1. Improved to allow the dynamic change in ACCESS_MODE of a broker.
  2. Changing how to check network status between an application and a broker in CCI.
  3. Allowing Debian package build.
Error Fixes

  1. Fixed an error that caused NULL to always be returned when NULL was given as the parameter of the IF function.
  2. Fixed an error in which there is an invalid output when RIGHT OUTER JOIN is executed as MERGE join.
  3. Fixed an error in which there may occur an error during table retrieval when COMMIT is executed after creation of a primary key is failed.
  4. Fixed an error in which replication is stopped when executing TRUNCATE TABLE query in the HA environment.
  5. Fixed an error in which replication is stopped due to the synchronization error for an archive log after online backup in the HA environment.
  6. Fixed an error in which data mismatch occurs when the applylogdb process is terminated abnormally after its restart in the HA environment.
  7. Fixed an error in which connection is not disconnected in a specific condition when there are massive amount of simultaneous connections and INSERT and DELETE queries are executed.
  8. Fixed an error in which ArrayIndexOutOfBoundsExceptions exception is occurred in a JDBC method that gets metadata.
  9. Fixed an error in which the ODBC driver is not registered when installing 32-bit CUBRID in the 64-bit Windows system.
  10. Fixed an error in which the start/stop of a broker, server or manager is not properly working in the command prompt window on Windows.
  11. Fixed an error in which the error message related to CUBRID Service Tray is displayed in Korean on English version Windows.

CUBRID Manager 8.3.1

New Features

  1. Added HA monitoring dashboard feature.
  2. Added input/output features of BLOB, CLOB, and BIT type data of which the length is more than 100.
  3. Added the features of retrieving and entering data by using a prepared SQL statement.
  4. Supporting the copying of DDL/DML to a clipboard.
Enhanced Features

  1. Improved to enable users to setup and check CHARSET during data import/export.
  2. Improved to enable users to check the CHARSET used in the Query Editor.
  3. Improved to enable the user to configure the maximum value when configuring automatic volume addition.
  4. Being able to apply DELETE ALL or TRUNCATE TABLE, etc. to several tables at once.
  5. Improved to make SESSION and ACTIVE SESSION clearly distinguished in the broker status monitor chart.
Error Fixes

  1. Fixed an error to display areas including non-physical memory entity when displaying memory information from host status monitor.
  2. Fixed an error that can be occurred when CUBRID Manager starts database in the Windows XP Service Pack 3.
  3. Fixed an error in which a part of database status information is not identified in Windows 7.
  4. Fixed an error in which an error is not displayed for some queries whose syntax is not correct.

For complete information on CUBRID 8.3.1 changes, see the Release Note.

comments powered by Disqus