CUBRID 2008 R3.0 Beta brings a great number of new features and extensions for the user convenience, which make CUBRID even more easy-to-use and more optimized database for the Web.
New Features
25 New SQL Syntax Extensions
CREATE TABLE new_tbl LIKE a_tbl;
CREATE TABLE new_tbl1 AS SELECT * FROM a_tbl;
INSERT INTO insert_tbl DEFAULT VALUES;
REPLACE INTO insert_tbl VALUES (3, 5);
INSERT INTO insert_tbl VALUES (DEFAULT, 5) ON DUPLICATE KEY UPDATE A=2;
SELECT * FROM a_tbl ORDER BY a LIMIT 2,3;
ON UPDATE { RESTRICT | NO ACTION | SET NULL }
PREPARE stmt1 FROM 'SELECT POWER(?,2)*PI()';
...
93 New Operators and Functions
Extending logical operators: &&, ||, XOR, !
BITWISE OPERATORS: &, |, ^, ~, <<, >>
Trigonometric functions: COS, COT, SIN, TAN, ACOS, ASIN, ATAN, ATAN2, DEGRESS, RADIANS, PI
Date/Time functions: ADDDATE, SUBDATE, DATEDIFF
...
31 New Extensions and Enhancements
20 New PHP API functions
11 Code Enhancements
7 New Features in CUBRID Manager
Extended HA features
New keywords and UI menu support for added statements
Supporting user configuration in [Add Status Monitor]
Supporting configuration of remote broker host information when executing [New Query Editor]
Supporting user login function to [Query Automation]
Supporting equal sign to configure the parameter value of cm.conf
Supporting an option to restore databases into a specific path