We're updating the issue view to help you get more done. 

Upgrade MySQL and MariaDB Dialects as they support UNION ALL

Description

After reviewing this issue, I noticed that MySQL and MariaDB are taking advantage of UNION ALL in TABLE_PER_CLASS, falling back to using UNION which does an extra sort and duplicate removal that are not necessary.

Environment

None

Status

Assignee

Vlad Mihalcea

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.4.0

Priority

Minor