HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

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.

Copyright © 2011-2024 www.enmotech.com All rights reserved.