MogDB 3.0.6

1. Version Description

MogDB 3.0.6 is a patch version of MogDB 3.0.0, which is released on Sep 15 of 2023. It mainly involves some bug fixes based on MogDB 3.0.5.

2. Fixed Defects

1. Fixed the occasional memory leak issue that occurred when calling autonomous transactions within stored procedures.
2. Fixed the problem where incorrect cost calculations led to the selection of nestloop in query plans, causing slow query performance.
3. Fixed the issue where querying a view after deleting its columns would occasionally crash the database.
4. Fixed the problem where incorrect primary node status during primary-standby switch led to cluster degradation.
5. Fixed the rare occurrence of the standby server hanging during the redo process.
6. Fixed the issue where using the -C option in the gsql client to log in and execute specific stored procedure code would occasionally crash the database.
7. Fixed the problem where the optimizer generated slow query plans when the number of elements in the "IN" condition of a query was excessive.
8. Fixed the issue of version conflicts between MogDB dynamic libraries and the operating system's dynamic libraries.
9. Fixed the problem where idle connections were not automatically disconnected.
10. Fixed the memory leak issue caused by enabling the enable_opfusion parameter.
11. Fixed the inconsistency in precision when returning numeric types via "out" and "return" with custom types.
12. Fixed the issue where the Workload Diagnosis Report link did not redirect correctly.
13. Fixed the problem of database initialization failure when using the GBK encoding format.
14. Fixed the issue where sessions would hang and could not be terminated simultaneously.
15. Fixed the problem where writing illegal characters in GBK format did not result in an error.
16. Fixed the issue where the "current_date" in prepare statements did not automatically update during the execute phase, leading to incorrect results.
17. Fixed the problem of lingering filenode files during the cleanup process of partitioned tables.

3. Behavior Change

Change Item	Before Upgrade	After Upgrade
Default Value Change for GUC Parameter enable_opfusion	Default Value: true	Default Value: false
Default Value Change for GUC Parameter enable_global_syscache	Default Value: true	Default Value: false