MogDB 5.0.4

1. Version Description

MogDB 5.0.4 is a patch version of MogDB 5.0.0, which is released on November 30 of 2023. It mainly involves some bug fixes based on MogDB 5.0.3.

2. New Features

1. The pivot and unpivot syntaxes are supported.

2. A compatibility mode supports btree index scanning using like fuzzy match conditions

3. Fixed Defects

1. Fix memory leaks with autonomous transactions
2. Fix the problem that CBM parameter modifications do not take effect on the backup node
3. Fix the issue of high memory usage when bypass is enabled
4. Fix a problem in stored procedures where the in/out parameter is written in the procedure and the outer layer does not take effect
5. Fix the problem that subqueries do not support multilayer brackets when updating multiple fields in PG compatibility mode
6. Fix the problem that the HAVING clause in the CONNECT BY statement doesn't support PRIOR
7. Fix the problem of incorrect result of rownum expression included in start with clause in connect by statement
8. Fix the problem of inaccurate position of the syntax error reported in the connect by statement
9. Fixes an issue where all-lowercase aliases for column names are still converted to uppercase using double quotes
10. Fix the problem that having clauses without group by appearing in subqueries in B-compatible mode causes downtime
11. Fix a low-probability downtime issue during dynamic partition trimming