orderBy fails on MYSQL 5.7.9 when using Paginator

[jakenoble]

Full details here http://stackoverflow.com/questions/33900219/doctrine2-symfony2-paginator-fails-with-orderby

Essentially this simple code fails

     $builder = $this->createQueryBuilder("s");
     $builder->addOrderBy("s.name", "ASC");
     $pagi = new Paginator($builder->getQuery(), true);
     $data = $pagi->getIterator()->getArrayCopy();

With the following error

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dctrn_result.name_5' which is not in SELECT list; this is incompatible with DISTINCT") in AppBundle:Schools/Search:results_list.html.twig at line 33.

The name column exists, and renaming the reference from s.name to name fails too.

Removing the addOrderBy results in a successful fetch too. So the issue is certainly related to using addOrderBy with a Doctrine2 Paginator.

[dbu]

this repository is about doctrine phpcr-odm, not about doctrine orm. please use the doctrine jira if you need further help with this - but looking at stack overflow it seems you got an answer within a few hours, so maybe not opening a second channel for the same question would have been a good idea...

[dbu]

sorry, did not want to be harsh on you @jakenoble but maintaining open source is a lot of work. we need users to be careful with using our resources. so please be careful before reporting something as an error.

[jakenoble]

Understood :-)

[rapaelector]

I think you must downgrade your mySql version to 5.6.
It's worked for me