MogDB 5.0.3

1. Version Description

MogDB 5.0.3 is a patch version of MogDB 5.0.0, which is released on October 27 of 2023. It mainly involves some bug fixes based on MogDB 5.0.2.

2. New Features

N/A

3. Fixed Defects

1. Fixed inconsistent result sets caused by subquery expansion when ROWNUM was used as a projection.

2. Fixed inconsistent results when the parent query contained ROWNUM and the REDUCE ORDER BY rewriting rule was available and the ORDER BY in the subquery was eliminated.

   Note: In MogDB 5.0.3, ROWNUM is no longer used as a condition in JOIN (ON/USING) Filter. It is supported in the following scenarios:

   • WHERE condition
   • SELECT projection
   • UPDATE/INSERT projection
   • UPDATE condition
   • HAVING condition
   • GROUP BY/ORDER BY attribute

3. Fixed an issue where views could not be created when the CONNECT BY condition has ROWNUM and column comparison expressions, such as rownum<col.

4. Fixed an issue where the CONNECT BY condition contained a ROWNUM and column comparison expression and it causes downtime when the statement was used as a subquery.

5. Fixed an issue where a rownum=col expression was included in a CONNECT BY condition, resulting in an error.