Releases: CUBRID/cubrid
CUBRID 11.3 Patch 1
CUBRID 11.3 Patch 1 includes a number of fixes of legacy issues.
CUBRID 11.3 Patch 1
CUBRID 11.3 patch 1 includes several critical fixes of 11.3. All users of CUBRID 11.3 are kindly requested to upgrade to 11.3 patch 1.
Change logs:
Enhancements
4ea1c76 [CBRD-25086] Add words for the user convenience in user hosts. (#4839)
d12a208 [CBRD-25087] Restart cub_javasp via signal if JNI crashes the process (#4797, #4913, #4968, #4970)
63ad34f [CBRD-25129] Change CSQL environment variable name (#4846, #5058)
1fd1edb [CBRD-25208] Set java.io.tmpdir according to the CUBRID_TMP in Java SP server (#4917, #4937, #5003, #5005)
681e94f [CBRD-25232] Exclude Win for TLS_v1.2 (#5023)
d4439d0 [CBRD-25285] Add a new ClassLoader to avoid reloading classes that load JNI in a Java SP Server (#5076, #5090)
6ddcb81 [CBRD-25289] When using the --split-schema-files option in unloaddb, the unique index must be separated from the dbname_schema_class file. (#5085)
7d2636b [CBRD-25295] set ppid of broker/cas proc created by cub_manager to 1 (#5106, #5113, #5120)
Bug Fixes
318a064 [CUBD-24687] query result is strange, when there is hidden columns in the select list (#4941)
bd8cd2f [CBRD-25046] typo error in jsp_sr.c (#4743, #4748)
ec06cff [CBRD-25053] Core dumped in tp_is_domain_cached at src/object/object_domain.c:2276 (#4765, #5138)
25733b3 [CBRD-25054] Numeric type column inserted by using rownum does not show error even it's outranged. (#4766, #5086)
d6b3e48 [CBRD-25064] change to return success when performing execute standalone's loaddb with zero-sized object files. (#4964, #4991)
fec8e00 [CBRD-25098] Problem where inst_num() is inappropriately changed to order_by_num() when a subquery containing an ORDER BY is view merged. (#4981)
fcbc69f [CBRD-25108] Correct misclassifications in the file tracker. (#4829, #4899)
32ae3a0 [CBRD-25128] In STRING_CAT '||' operation, incorrect handling of null when setting oracle_style_empty_string (#4842, #5065)
9af5dc4 [CBRD-25139] When using oracle style empty string, the result of replace is null. (#4848, #5067)
46225e9 [CBRD-25148] Fix ux_execute_arrary mem leak (#4879)
08700a5 [CBRD-25164] Fix error in covered index query results using function indexes (#4881, #5092)
344d8b0 [CBRD-25169] Consider alignment size for ensureSpace() in Java SP's CUBRIDPacker (#4887, #4929)
539e916 [CBRD-25179] A core dump occurs when the CTE query is a false query (null query) (#4890, #5087)
34f34e0 [CBRD-25180] Occur temp volume growth, when performing prepare() -> multiple execute(). (#4922)
4f67b29 [CBRD-25195] A core dump occurs when multiple tables and serial functions are used simultaneously in one query. (#4897, #5089)
4481538 [CBRD-25207] count(*) value is incorrect after no-logging option loaddb (#4908, #5091)
8116483 [CBRD-25216] Check if there is enough buffer to store the user-specified name (#4946, #4955)
4afd5d3 [CBRD-25229] Check the maximum length of the name in sm_check_system_class_by_name (#4953)
df9eda4 [CBRD-25232] change CMS SSL profile to support up to TLS_v1.2 (#4985)
bf2d6f0 [CBRD-25238] Problem with outer joined views being merged. (#4998, #5000)
52f0edc [CBRD-25243] case-insensitive hostname for CUBRID userhosts (#5016)
98de5da [CBRD-25245] case insensitive are_hostnames_equal () (#5013)
6b8dbdb [CBRD-25248] Server crash for Java SPs running a SELECT statement with 'WHERE 0 <> 0' clause (#5017, #5036)
bdf39b4 [CBRD-25260] Change the the behavior of finding server when omitting user schema (#5040, #5093)
8681ae7 [CBRD-25262] Problem with some show statements not filtering the owner correctly (#5042, #5070)
3e9311c [CBRD-25277] 'Outer join query optimization failed.' error occurs in Eliminate INNER JOIN (#5053, #5069)
11ca3f9 [CBRD-25290] _db_auth's rows are not deleted when dropping an user (#5079, #5116)
6836ee3 [CBRD-25291] The release files is include an empty directory in the JDBC folder. (#5078, #5082)
77e9286 [CBRD-25296] Assertion fail on a DATETIMELTZ value to a SP's parameter of DATETIME type (#5099, #5129)
b9b4401 [CBRD-25298] trim class and method names of the target method (#5108)
fd9f751 [CBRD-25300] When unloaddb, the comment of reverse unique index is missing (#5123)
b8fd6e7 [CBRD-25319] fix FQDN stytle hostname error in use_user_hosts (#5145)
CUBRID 10.2 Patch 15
CUBRID 10.2 Patch 15 includes a number of fixes of legacy issues.
CUBRID 10.2 Patch 15
CUBRID 10.2 patch 15 includes several critical fixes of 10.2 Patch 14. All users of CUBRID 10.2 and 10.2 patches are kindly requested to upgrade to 10.2 patch 14.
Change logs:
Enhancements
64798df [CBRD-24067] Print the recovery progress (#5064)
8505354 [CBRD-25232] change CMS SSL profile to support up to TLS_v1.2 (#4987, #5022)
19e25f7 [CBRD-25295] set ppid of broker/cas proc created by cub_manager to 1 (#5102, #5128)
Bug Fixes
b0b3f83 [CBRD-24687] query result is strange, when there is hidden columns in the select list (#4944)
004ddda [CBRD-25054] Numeric type column inserted by using rownum does not show error even it's outranged. (#4766, #5096)
a25901c [CBRD-25064] change to return success when performing execute standalone's loaddb with zero-sized object files. (#4967, #4995)
19cb33f [CBRD-25108] Correct misclassifications in the file tracker. (#4829, #4902)
2352d92 [CBRD-25128] In STRING_CAT '||' operation, incorrect handling of null when setting oracle_style_empty_string (#4842, #5066)
0ae29da [CBRD-25139] When using oracle style empty string, the result of replace is null. (#4848, #5068)
80ddb77 [CBRD-25148] fix ux_execute_arrary mem leak (#4876)
c6fbb46 [CBRD-25164] Fix error in covered index query results using function indexes (#4881, #5088)
4ec9da4 [CBRD-25179] A core dump occurs when the CTE query is a false query (null query) (#4890, #5095)
945416c [CBRD-25180] Occur temp volume growth, when performing prepare() -> multiple execute(). (#4925)
4cfdcf2 [CBRD-25195] A core dump occurs when multiple tables and serial functions are used simultaneously in one query. (#4897, #5094)
225e884 [CBRD-25245] case insensitive are_hostnames_equal () (#5014)
39867b4 [CBRD-25271] Core occurs when applying nvl function index to char type column (#5047)
5500c73 [CBRD-25290] _db_auth's rows are not deleted when dropping an user (#5079, #5117)
48d23bd [CBRD-25298] trim class and method names of the target method (#5111)
3894e4e [CBRD-25300] When unloaddb, the comment of reverse unique index is missing. (#5127)
CUBRID 11.2 Patch 8
CUBRID 11.2 Patch 8 includes a number of fixes of legacy issues.
CUBRID 11.2 Patch 8
CUBRID 11.2 patch 8 includes several critical fixes of 11.2 Patch 7. All users of CUBRID 11.2 and 11.2 patches are kindly requested to upgrade to 11.2 Patch 8.
Change logs:
Enhancements
99d08f1 [CBRD-25087] Restart cub_javasp via signal if JNI crashes the process (#4968)
Bug Fixes
e22bcc6 [CBRD-24687] query result is strange, when there is hidden columns in the select list (#4942)
fa61b89 [CBRD-24982] An error occurs when loaddb after unloaddb of a view query using the server (#4664)
749b9a6 [CBRD-24996] er_clear() is slipped even if synonym is found succesfully (#4693)
08de268 [CBRD-25046] typo error in jsp_sr.c (#4743)
4b0b17d [CBRD-25054] Numeric type column inserted by using rownum does not show error even it's outranged. (#4766)
fcf8840 [CBRD-25064] loaddb terminates with exit code 0 even though an error occurred (#4965)
3037eb1 [CBRD-25098] Problem where inst_num() is inappropriately changed to order_by_num() when a subquery containing an ORDER BY is view merged. (#4980)
b153092 [CBRD-25108] Correct misclassifications in the file tracker. (#4829)
d005a54 [CBRD-25148] fix ux_execute_arrary mem leak (#4878)
1828116 [CBRD-25164] Fix error in covered index query results using function indexes (#4881)
ca5371e [CBRD-25169] Consider alignment size for ensureSpace() in Java SP's CUBRIDPacker (#4887)
45952d0 [CBRD-25179] A core dump occurs when the CTE query is a false query (null query) (#4890)
330e157 [CBRD-25180] Occur temp volume growth, when performing prepare() -> multiple execute(). (#4923)
b663e0b [CBRD-25195] A core dump occurs when multiple tables and serial functions are used simultaneously in one query. (#4897)
3215c7c [CBRD-25207] count(*) value is incorrect after no-logging option loaddb (#4908)
766f87e [CBRD-25208] Set java.io.tmpdir according to the CUBRID_TMP in Java SP server (#4917, #5003)
0eb4253 [CBRD-25216] Check if there is enough buffer to store the user-specified name (#4946)
654ecf1 [CBRD-25229] Check the maximum length of the name in sm_check_system_class_by_name (#4953)
686dbe7 [CBRD-25238] Problem with outer joined views being merged. (#4998)
426dcaf [CBRD-25245] case insensitive are_hostnames_equal () (#5011)
CUBRID 11.0 Patch 13
CUBRID 11.0 Patch 13 includes a number of fixes of legacy issues.
CUBRID 11.0 Patch 13
CUBRID 11.0 patch 13 includes several critical fixes of 11.0 patch 12. All users of CUBRID 11.0 and 11.0 patches are kindly requested to upgrade to 11.0 Patch 13.
Change logs:
Bug Fixes
d9f5000 [CBRD-24009] Plan cache is not updated when view changes including inline view. (#4688)
51956bb [CBRD-24905] The problem is that a core dump occurs when a value of an invalid index type (such as Collection Type) is bound to host variables (#4631)
CUBRID 11.3
CUBRID 11.3 is the latest stable version that includes new features, significant changes and enhancements.
CUBRID 11.3
- improves connectivity by enhancing database links.
- is more stable, faster, and more convenient for administrators.
- fixes a large number of critical bugs.
- includes code refactoring and modernization.
CUBRID 11.3 provided user convenience by providing a table extension style (object@server) for database links, and improved connectivity by providing the ability to insert, modify, and delete data as well as retrieve data for remote DB.
CUBRID 11.3 is faster. This version further improves performance through improve aggregation functions (min, max group_concat) and query optimization, such as predicate pushdown, view transformation, and removal of unnecessary join tables. Additionally, performance problems caused by skewed indexes were improved by providing a deduplication option when creating an index (or foreign key).
CUBRID 11.3 improved administrator convenience by improving the csql, unloaddb, and loaddb utilities.
The database volume of CUBRID 11.3 is compatible with the CUBRID 11.2 volume. (However, when a volume created in CUBRID 11.2 is used in CUBRID 11.3 due to a change in view query spec of db_index and db_vclass among catalog views, unexpected results may be obtained when executing a query related the catalog view.)
Change logs:
DataLink and Related Bugs Fixes
5cbc9eb [CBRD-24501] extending dblink dml (#4036, #4315, #4324, #4342, #4442,#4450, #4477, #4488, #4505, #4507, #4513, #4557, #4561, #4571, #4577, #4587, #4588, #4591, #4592, #4594, #4595, #4607, #4608, #4610, #4612, #4616, #4621, #4623, #4645, #4666, #4669, #4673, #4698, #4700, #4706, #4707, #4715)
4219a75 [CBRD-24551] CUBRID DBLink extension for mariadb (#3979, #4459)
b8e2f70 [CBRD-24893] Add DML function in Gateway (#4496, #4535, #4573, #4578, #4618, #4647)
e77de6d [CBRD-24420] dblink: correct oracle syntax error in rewritten query. (#3705)
0f338b9 [CBRD-24428] dblink: correct error message for repeated query execution (#3725)
6422914 [CBRD-24432] query rewrite to fit oracle (#3739)
9f6303a [CBRD-24433] Add ODBC Data type to not suppoerted type (#3742)
3b0cdcc [CBRD-24437] DBLink query parsing error (#3745)
29bcc66 [CBRD-24506] Changing the way characters are read from DBMS (#3880)
679eca4 [CBRD-24571] assert() occurs when using DELETE/UPDATE including DBLINK (#3978)
d2d59b8 [CBRD-24844] Garbage value when querying bit varying(n) column using DBLINK. (#4421)
Enhance Performance
1fd078d [CBRD-24248] Support NEED_COUNT_ONLY optimization for JOIN (#3780)
d93f4b1 [CBRD-24252] Removes the table of the primary key from the join with the table with the foreign key referencing it. (#3838)
8e5f2aa [CBRD-24258] Rewrite optimization for oracle style partial range scan (#3469)
9d59a09 [CBRD-24304] The problem that the optimal plan cannot be found because the first node is not properly selected (#3563)
f8dc9e9 [CBRD-24349] index scan enhancement for correlated subquery. (#3601)
7a5fdb8 [CBRD-24400] The problem of comparing plan fixed and variable cost respectively (#3665)
cbae603 [CBRD-24436] MAX / MIN performance enhancement (#3746, #3870)
8949033 [CBRD-24516] replace the information which is printed in "show trace" from aggregate function optimization (#3892, #4370, #4424, #4454, #4490)
e2391d3 [CBRD-24537] Improve the performance of MERGE query by using NOT EXISTS sub-query (#3919)
f49cb46 [CBRD-24584] Improved to minimize the impact of query execution speed when setting sql_trace_slow (#4002)
ffb8a38 [CBRD-24632] Change data put, get and support functions using OR_BUF in object_representation.c to inline functions (#4066)
5abd400 [CBRD-24660] Change small functions that are frequently called in index scans to INLINE. (#4109)
0a4a5ce [CBRD-24850] Enhancing group_concat() Performance by Optimizing String Size and Length Calculation Methods (#4432)
1aec308 [CBRD-24876] Improves MIN/MAX performance when a function index but the first key is not a function. (#4601)
1713a7d [CBRD-24467] Sort-limit optimization does not work when host variable is used in limit clause. (#3793)
7add535 [CBRD-24478] Make sure that the index is not skewed by duplicate keys (#3951, #4401, #4549, #4560, #4565, #4686)
e56ae97 [CBRD-24502] The problem of updating statistical information when performing DDL. (#4111)
SQL changing and Related Bugs Fixes
490f75a [CBRD-24425] Add overflow page information when showing the index capacity (#3738, #3781)
e351dd3 [CBRD-24371] In alter synonym, comments can be changed without a for clause, and empty string comments become NULL. (#3694)
b83cfe7 [CBRD-24396] Ignore hints if there is an invalid index name in the USING INDEX clause (#3674)
8bd7a3b [CBRD-24544] not allow to alter the column type to a type that does not support auto-increment. (#3925)
e466fc4 [CBRD-24563] Add RE2 for REGEXP functions (#3997, #4024, #4033)
beb0d5b [CBRD-24573] Among the SERVER information, dbname and user can be input as a string type (#3989)
1d0e25b [CBRD-24654] When getting a NUMERIC type value, if the value after the decimal point is 0, it should be improved so that the trailing 0's are not passed. (#4096, #4541, #4600, #4606, #4615, #4620)
63133ba [CBRD-24684] divide operation result into numeric type (#4150, #4451, #4465, #4484)
c2f33ca [CBRD-24796] Changed the position of the comment clause in the index creation statement (#4347)
8a6ec84 [CBRD-24638] The problem of the default value of column when altering the type of column. (#4074)
a428310 [CBRD-24780] An error occurs when casting an empty string to bigint. (#4320)
04f3b80 [CBRD-24285] Problem of sort limit optimization without checking not null of foreign key (#3509)
0998326 [CBRD-24384] The core occurs if the user drops a synonym for which the target object is dropped. (#3690)
d014897 [CBRD-24401] In case of using UNION in an IN clause in an inline view, a segment fault occurs (#3666)
9e862c1 [CBRD-24429] Not allowed multiple foreign keys on a column attribute (#3733)
2338860 [CBRD-24435] When renaming a view, even if there is a not null constraint, change it so that no error occurs. (#3744)
273eaa6 [CBRD-24473] Index scan cannot be used when a stored function is used in a where condition. (#3811)
e453929 [CBRD-24487] Core dump occurs when query execution is canceled in the middle of inserting dk bucket of FHS (#3827)
acdeae8 [CBRD-24482] Core dump occurs after function index scan (#3818)
34170af [CBRD-24536] Core occurs when referencing null in CTE (#3914)
b795c3b [CBRD-24538] Core dump occurs when a query containing cte is view merged (#3928)
14097f7 [CBRD-24541] Core dump occurs when 'EXISTS' operation or 'count stop' is used for index scan of partitioned table (#3923)
ce80794 [CBRD-24554] incorrect result of "NOT EXISTS" and "NOT IN" with sub-query returning null (#3937)
590885a [CBRD-24564] reflect reuse-oid option in error message printing at view updating query. (#3959)
5c35efd [CBRD-24581] Assert occurs when using indexes using IFNULL(), NULLIF() functions (#4005)
08f2464 [CBRD-24586] Members of the DBA group must be able to see all objects in the system view. (#4003)
aeea57a [CBRD-24587] Core dumped in do_alter_server (#4167)
57dd3c3 [CBRD-24588] to print out only the comment string without single quote escape in session command (#4008)
bc4f35e [[CBRD-24...
CUBRID 10.2 Patch 14
CUBRID 10.2 Patch 14 includes a number of fixes of legacy issues.
CUBRID 10.2 Patch 14
CUBRID 10.2 patch 14 includes several critical fixes of 10.2 patch 13. All users of CUBRID 10.2 and 10.2 patches are kindly requested to upgrade to 10.2 Patch 14.
Change logs:
Bug Fixes
4895822 [CBRD-24009] Plan cache is not updated when view changes including inline view. (#4689)
3a55de0 [CBRD-24905] The problem is that a core dump occurs when a value of an invalid index type (such as Collection Type) is bound to host variables (#4630)
CUBRID 11.2 Patch 7
CUBRID 11.2 Patch 7 includes a number of fixes of legacy issues.
CUBRID 11.2 Patch 7
CUBRID 11.2 patch 7 includes several critical fixes of 11.2 Patch 6. All users of CUBRID 11.2 and 11.2 patches are kindly requested to upgrade to 11.2 Patch 7.
Change logs:
Bug Fixes
b760a37 [CBRD-24905] The problem is that a core dump occurs when a value of an invalid index type (such as Collection Type) is bound to host variables (#4632)
b841dac [CBRD-24910] Fix the core dump caused by accessing a corrupted log record header (#4579)
06180fc [CBRD-24961] SP's out parameters takes wrong value (#4681)
576c27e [CBRD-24974] The problem is that error occurs when loading unloaded schema file if both DBA and user have tables and views with same name (#4635)
b3dcab9 [CBRD-24980] Fix wasNull () in ServerSideResultSet of server-side JDBC (#4677)
105c694 [CBRD-24985] A phenomenon in which the executed query is not executed properly due to Query rewrite. (#4674)
CUBRID 10.2.13.8953 hotfix
CUBRID 10.2.13.8953 hotfix
Change logs:
3a55de0 [CBRD-24905] The problem is that a core dump occurs when a value of an invalid index type (such as Collection Type) is bound to host variables (#4630)
CUBRID 11.2 Patch 6
CUBRID 11.2 Patch 6 includes a number of fixes of legacy issues.
CUBRID 11.2 Patch 6
CUBRID 11.2 patch 6 includes several critical fixes of 11.2 Patch 5. All users of CUBRID 11.2 and 11.2 patches are kindly requested to upgrade to 11.2 Patch 6.
Change logs:
Enhancements
96e73af [CBRD-24502] The problem of updating statistical information when performing DDL (#4410)
Bug Fixes
d9c37ea [CBRD-24517] Records -10006/-10007 errors to the cas log (#4564)
6561644 [CBRD-24698] Change table names to lowercase in pt_resolve_showstmt_args_unnamed (#4430)
594ecd3 [CBRD-24806] The use of synonyms is not allowed in the update statistics statement (#4431)
b8ce15c [CBRD-24844] Garbage value when querying bit varying(n) column using DBLINK. (#4543)
66f8248 [CBRD-24849] When using -i and --input-class-only in unloaddb, only sql statements related to tables should be recorded (#4437, #4574)
cad9ca3 [CBRD-24892] The restoredb with level 1 fails when some of the permanent volume header is not included (#4566)
2788723 [CBRD-24897] Query rewriter can lose parent paths of a name in qo_collect_name_spec() (#4547)
60b9f65 [CBRD-24906] The problem of performing a cross join by changing to the '0 <> 0' condition when the WHERE clause is always false (#4520)
CUBRID 11.0 Patch 12
CUBRID 11.0 Patch 12
CUBRID 11.0 patch 12 includes several critical fixes of 11.0 patch 11. All users of CUBRID 11.0 and 11.0 patches are kindly requested to upgrade to 11.0 Patch 12.
Change logs:
Enhancements
5678bfc [CBRD-24502] The problem of updating statistical information when performing DDL (#4411)
Bug Fixes
ddf2f0e [CBRD-24517] Records -10006/-10007 errors to the cas log (#4568)
1c24535 [CBRD-24541] Core dump occurs when 'EXISTS' operation or 'count stop' is used for index scan of partitioned table. (#4495)
9d1bd75 [CBRD-24800] Prevent missing INVISIBLE attribute in result of unloadb tool (#4357)
e47ab0a [CBRD-24828] Executor error when using udf() and bind variable in update query (#4544)
6b85dc4 [CBRD-24892] The restoredb with level 1 fails when some of the permanent volume header is not included (#4567)
8e455b7 [CBRD-24897] Query rewriter can lose parent paths of a name in qo_collect_name_spec() (#4546)
e1a627d [CBRD-24906] The problem of performing a cross join by changing to the '0 <> 0' condition when the WHERE clause is always false (#4519)