[5.x]: Order by custom fields groups entries by section

[olivierbon]

What happened?

Description

When querying multiple sections at once, (.section(['galaxies','planets'])), ordering by custom field returns a list of entries grouped by section.

Ordering by postDate, title works fine, problem only occurs with custom fields.

This works fine in Craft 4.

Craft CMS version

5+

PHP version

No response

Operating system and version

No response

Database type and version

No response

Image driver and version

No response

Installed plugins and versions

[timohinze]

thanks for reporting @olivierbon
btw: the same happens when you use two element types in one section

[i-just]

Thanks for all the info, Oli! It looks to be affecting MySQL and not PgSQL. Looking into it!

[brandonkelly]

Fixed for 5.1 via 798b9d7

[brandonkelly]

Craft 5.1 is out with that fix.