Sorting products by cheapest or most expensive price is broken

[qlerebours]

Sylius version affected: 1.4.0

Description

When sorting products in the shop by cheapest or most expensive price, Sylius catches an SQL error.

Steps to reproduce

To reproduce it, you can simply go to the Sylius demo with this link : https://master.demo.sylius.com/en_US/taxons/t-shirts/men and sort items by cheapest price or most expansive price. You got a 500 error.

Possible Solution

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'sylius_dev.s5_.price' which is not in SELECT list; this is incompatible with DISTINCT
The error says that it should add ORDER BY parameters in the SELECT clause.

[vvasiloi]

It is working on 1.4.0, but not on 1.4.1 and master.
I don't see in the diff any potential causes of this issue, so I think it's related to database configuration.
Maybe somethig related to sql_mode.

[vvasiloi]

I was on the right path.
Tested 1.4.0 again after adding ONLY_FULL_GROUP_BY to sql_mode and it thrown the same exception.
I'm running MYSQL 5.7.23 which didn't have that mode added by default.