Skip to content

CUBRID 11.0
Compare
Choose a tag to compare
@ssihil ssihil released this 21 Jan 02:34
· 131 commits to release/11.0 since this release
v11.0
b53ae4a
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

CUBRID 11.0 is the latest stable version that includes new features, significant changes and enhancements.

CUBRID 11.0

  • is a version with improved security.
  • is more stable, faster, and more convenient for administrators.
  • fixes a large number of critical bugs..
  • includes useful SQL extensions: Supporting RVC (Row Value Constructor) and various REGEXP functions.
  • includes code refactoring and modernization.

CUBRID 11.0 improves security by providing data encryption and packet encryption. This version prevents abnormal data loss by supporting table-based TDE (Transparent Data Encryption) and packet encryption between the driver and server.

CUBRID 11.0 is faster. This version supports hash scan and improves the performances by up to 10 times in join query that could not perform index scans. By supporting the cache of search query results through hints, data change is minimal, and the performance of the workload with complex queries is maximized.

CUBRID 11.0 improves administrator convenience by providing new functions for administrators. This version supports statement-based replication through hints on the HA environment, improving the replication time when deleting and updating a large amount of data. By separating the Java SP server from the DB server, the influence of the DB server is minimized from the start/stop of the Java SP server. In addition, the DDL audit function is provided so that DDL change can be tracked.

The database volume of CUBRID 11.0 is not compatible with that of CUBRID 10.2 and earlier versions. Therefore, if you use CUBRID 10.2 or earlier, you must migrate your databases.

Change logs:

Enhancements

Security

0cf60dd [CBRD-23608] Implement "Transparent Data Encryption" (#2497, #2511, #2514, #2516, #2519, #2526, #2546, #2551)
9123b9b [CBRD-23637] Implementation of secure CUBRID jdbc driver (#2346, #2360, #2393)
9c93886 [CBRD-23687] Apply SSL Broker/CAS to damson (#2348, #2350, #2387, #2474)
35c5e35 [CBRD-23688] Implementation of secure CUBRID CCI driver (#2362, #2472, #2480)
f9abbb1 [CBRD-23726] Add DDL Audit log (#2481, #2527)

SQL extension

6d597de [CBRD-22856] Support Row Value Constructor (#1564)
3df36a1 [CBRD-22783] Add support for REGEXP_REPLACE function (#1509, #1647, #1671, #2181, #2186, #2189, #2194, #2198, #2210, #2212)
7d24258 [CBRD-23071] REGEXP_SUBSTR function (#1709)
34e53ff [CBRD-23073] REGEXP_INSTR function (#1722)
20c0159 [CBRD-23084] REGEXP_COUNT function (#1741)
0583db9 [CBRD-23085] REGEXP_LIKE function (#2203)

HA

55771f1 [CBRD-22135] Improve performance when using serial in HA environment. (#2206)
fc5e8f8 [CBRD-23678] implementation of /*+ USE_SBR / hint for DML in HA environment (#2388, #2467, #2540)
92f6810 [CBRD-23682] Support to /+ NO_LOGGING */ hint (#2422)
3c2be62 [CBRD-23692] The heartbeat starts fail on the master node if master and slave node exist on the different network and can't communicate each other. (#2457)
6496506 [CBRD-23737] Leaves a log to trace the cause when a failover is occurred due to a server hang. (#2432)
5f07862 [CBRD-23690] Improvement of 'Rebuilding Replication Script' (#2452)
59d2efa [CBRD-23609] Before failure-over due to disk failure, syslog was used to record information and the disk failure detection algorithm was improved in HA environment. (#2195, #2211, #2342)

Java SP

f378a23 [CBRD-21565] Add system parameter for Java SP server to apply JVM options (#2242)
4beed13 [CBRD-23629] Create utility for Java SP server (#2461, #2486, #2490, #2498, #2501, #2508, #2517, #2518, #2529)
73f52a5 [CBRD-23647] Add system parameter for debugging Java SP and Server-side JDBC (#2294)
2ccf9aa [CBRD-23648] Separate server-side routine in JDBC (#2278)
74df676 [CBRD-23770] Get explicitly specified libjvm path from JVM_PATH env variable (#2487)
217f5ef [CBRD-23671] Implement Statement Handler Cache in Server-side JDBC (#2335)

CMS

f266129 [CBRD-23669] Provide FULL SQL_Text, if tranlist executed with -f option (#2358)

Others

7a4b39a [CBRD-21828] Process '.5' style number in loaddb_object as well as '0.5 (#2366)
e69bf4c [CBRD-22637] Excessive domain cache degrades search performance using index scan (#2352)
7f6b6b7 [CBRD-22803] show statement for page buffer status (#2437, #2543)
ace183f [CBRD-23602] Statement/Result cache to improve performance for frequently repeated queries (#2443, #2489)
4803a87 [CBRD-23803] The parameters related to 'query_cache_mode' reconfigured to change the mode. (#2515)
77a2fd2 [CBRD-23810] Improvement of DML and transaction processing for result-cache (#2525, #2530)
ec268a5 [CBRD-23827] Policy changing to disable result-cache in default. (#2536)
b551219 [CBRD-23633] Prevent endless busy waiting for query execution in abnormal network circumstance (#2219, #2243, #2252)
f739bed [CBRD-23649] make dummy table instead of db_root (#2365, #2433, #2544)
a12ad21 [CBRD-23653] subquery in 'EXISTS' operation retrieves the entire data and degrades the performance. (#2287)
e9e0948 [CBRD-23665] Support Hash List Scan (#2389, #2454)
7224cd1 [CBRD-23749] Support HASH LIST SCAN for Hierarchical Queries (#2520)
5902591 [CBRD-23668] Change pop-up guide text for JRE when installing windows engine (#2311)
03ab962 [CBRD-23679] Adding a configuration parameter and control for strict type translation (#2340, #2379, #2392, #2397, #2419, #2451, #2460)
bfcfdb5 [CBRD-23702] Modernize Heap Layers (#2384)
ecaa132 [CBRD-23703] Improve compression with faster library (#2391, #2436)
7b314f4 [CBRD-23704] Replace gcrypt usage with openssl (#2406, #2439)
4871d33 [CBRD-23708] change table option's default value to reuse_oid (#2385, #2405, #2408, #2441)
9a12ef8 [CBRD-23712] support --skip-vacuum option at csql command on SA mode (#2386)
4ff12aa [CBRD-23714] change an limit value of max_client (#2390, #2394, #2413)
694368a [CBRD-23718] Add a way to change comments without writing column definitions (#2440)
98d17cc [CBRD-23722] Prevent endless busy waiting for query execution in abnormal network circumstanec (#2407)
6c40bb4 [CBRD-23723] Include table name in loaddb error message for not null error (#2420)
024660b [CBRD-23729] Enhance compactdb utility (#2415)
6c8d1d9 [CBRD-23730] remove -u and -p option at tranlist and -p option only work with -i or --kill option on killtran utility (#2409, #2444)
43277f3 [CBRD-23731] In data comparing, no ignoring to trailing spaces at the end of the data. (#2421, #2468, #2476, #2483, #2488, #2513, #2524)
eb2a6ec [CBRD-23732] Optional Statistics Estimation (#2416)
89ade4f [CBRD-23736] add query-output and loaddb-output option to csql utility (#2434, #2510)
8c1dc05 [CBRD-23747] Enhance error message etc if cubrid user doesn't have permission about /etc/hosts
bddc587 [CBRD-23767] Index scan cannot be used in hierarchical queries when there is a value predicate like '1=1'
df4c594 [CBRD-23833] Changing default character set to utf8 for demodb in Windows. (#2550)

Bug Fixes

da93224 [CBRD-20577] Use of alias with function inside ‘Order By’ Clause (#2312)
7f0dbe4 [CBRD-21022] executeBatch returns Cannot communicate with the broker or received invalid packet & CAS down with core dump (#2323)
979a6a2 [CBRD-21452] In set (Union, Intersection, Difference) query, recompile cannot be repeatedly applied for explicit 'recompile clause'. (#2214)
0e14578 [CBRD-21560] Syntax errors can occur when a view containing TRUNC() or ROUND() function is fetched (#2435)
547284d [CBRD-21879] MAX value of system parameter 'backup_volume_max_size_bytes' is wrong (#2234)
8a10569 [CBRD-21886] No query results if DECODE, CASE, or IF is used in a nested left outer join query (#2315)
48806a2 [CBRD-22862] fix cubridtray actions for Windows (#2271)
07cfa73 [CBRD-22925] An error occurs when there are two 'IN' operators and rewriting predicate to reduce the equality term. (#2185)
b236881 [CBRD-22970] Constant variable is set to null when reusing cached XASL which is executed without data
75f2053 [CBRD-22975] Broker CAS hangs in CLIENT_WAIT status when log file size is greater than 2G on Windows 64 (#2188)
152582d [CBRD-22979] Segmentation fault occurs when query has derived table with 3 or more unions (#2196)
e7ef544 [CBRD-23243] Modify the way to caculate available disk space(#2218, #2330)
c47e53f [CBRD-23587] Add sym link of libncurses.so.6 to libncurses.so.5 for CentOS 8 (#2545, #2552)
ef16697 [CBRD-23598] Even with LIMIT 1 in a scalar subquery that uses union all, "Query result contains more than a single tuple." Error occurred (#2178)
e446928 [CBRD-23599] Error occurs if select list has in the order of an scalar subquery and expression which include an analytic function (#2179)
781302c [CBRD-23600] Unexpected rounding up a numeric value when the case expressions are used recursively (#2180)
8f1415d [CBRD-23603] When the ha_make_slavedb.sh script runs, it should delete intended database exactly in copy_backup_db_from_target () function. (#2187)
6aa6c1f [CBRD-23604] The restart of copylogdb and applylogdb fail if the length of copied log file path is over 64. (#2193)
9aad5ab [CBRD-23605] Wrong results returning in some select queries which has aggregate function as select list by groupby clause. (#2208)
e7e0569 [CBRD-23606] An error occurs when the binding value is larger than 256 chars in merge query (#2411, #2438, #2458)
fde018b [CBRD-23607] When updating a column itself using Java SP and there is a WHERE clause condition, if you do not use an index scan, an 'Accessing deleted object' error occurs (#2463)
b314991 [CBRD-23611] multi bytes blank is padded in char data of the table setted to euckr (#2273)
0b784a4 [CBRD-23617] modify max string size of query specification to 1073741823 (#2201)
dbf9db9 [CBRD-23618] Error occur when rewriting subquery into derived table in delete or update statement (#2200)
bb7b308 [CBRD-23623] Unexpected data overflow error occurs by order of select list when the numeric type and ROUND are used together
eada80d [CBRD-23626] Add system parameter to specify port number for Java SP server (#2207, #2215)
d01cc9d [CBRD-23631] Change the maximum value of the 'ha_apply_max_mem_size' property from 500MB to INT_MAX. (#2217)
50c3511 [CBRD-23638] Remove getpeername () calls, replace it with ip_addr in cci handle (#2250)
a6965ad [CBRD-23642] Change the way to handle the wrong backup time when executing restoredb (#2251)
0149661 [CBRD-23650] When a query specifying an OVER function in an aggregate function using rownum has a plan, the result is null. (#2343)
cc1cc24 [CBRD-23658] counting Error occurred when argument of COUNT function is constant 'NULL'.
4d9232b [CBRD-23677] The heartbeat fails to start when 'cubrid service start' command is executed successfully even though the settings are normal. (#2341, #2425)
65d2799 [CBRD-23680] temporary temp volume file is not cleared when server restarted with temp_volume_path option (#2345)
8892266 [CBRD-23685] coredump while insert something into column of type 'char (1073741823)' (#2412)
9f55348 [CBRD-23686] If the number of index columns is large, the optimizer cannot select a more appropriate index. (#2347)
f71f3a5 [CBRD-23689] If both outer join and inner join are present, the optimizer cannot find the optimal join order. (#2351)
5393b02 [CBRD-23696] Core dump occurs when correlated subquery is used as in-line view.
071283e [CBRD-23697] occurred error "Cannot coerce value of domain character to domain integer" when executing update. (#2361, #2403)
71aff02 [CBRD-23701] The 'cubrid hb start' command operates incorrectly if a database with ha_mode=off is registered in ha_node_list. (#2431)
e074345 [CBRD-23709] error message is displayed incorrectly in 'MERGE' clause (#2381)
397fa2a [CBRD-23715] Display SSL parameter in broker info (#2470)
3a73b47 [CBRD-23724] loaddb: Fix record number error greater than 2^32 (#2446)
cc86aef [CBRD-23725] Fixed errors in the number of records processed by unloaddb in large db (#2462, #2532)
51acec1 [CBRD-23733] add windows security patch update notification popup when cubrid install (#2417, #2548)
a66a907 [CBRD-23746] Error occurs when joining using nvl() function based index. (#2445)
f8df2df [CBRD-23752] Case-insensitive handling of %class keyword in loaddb object (#2469, #2477)
699f76b [CBRD-23753] Fix destroying Internal JDBC resources is not working and unexpected behavior (#2471)
54271ad [CBRD-23754] Outer join is incorrectly changed to inner join in queries that contain OR operation. (#2475)
d30bd87 [CBRD-23783] Fix incorrect domain definition is printed for SET of arbitrarily type (#2491)
4511faf [CBRD-23786] Always loading system parameter in process_heartbeat_util() (#2503)
9a47185 [CBRD-23787] Memory leak in csession_create_prepared_statement() (#2500)
b93eaae [CBRD-23788] Change declaration position of a character array - inputpath_local (#2499)
78fb907 [CBRD-23796] some rewrite query was not found the character size
41959b4 [CBRD-23831] Some collection-related (has VARCHAR elements) query returns incorrect result (#2549)
b53ae4a [CBRD-23834] Change the way to find bash as login shell (#2556)

Drivers

483fb30 [APIS-782] JDBC isValid() in CUBRIDConnection throws UnsupportedOperationException (#2337, #2256)
e9101f1 [APIS-822] In JDBC Driver, translating empty string to null when the option oracleStyleEmptyString is set. (#2227)
12f5ece [APIS-825] Supports ResultSet.getBlob() or ResultSet.getClob() method to read BIT VARYING type or VARCHAR type. (#2303)
4fbaa08 [APIS-833] Add isolation level of CUBRID Engine version 9 or earlier for backward compatibility (#2395)
c83e33c [CBRD-21023] JDBC Clob's length() returns -1 when empty string (#1565, #2209)

Assets 2
Loading