DBAL-1823: Doctrine2 + pdo_sqlsrv the createQueryBuilder() Order By with varchar field does not work

[doctrinebot]

Jira issue originally created by user leoFelipe:

I am creating a QueryBuilder receiving values to createQueryBuilder() coming by parameter. I created testing in my local database with pdo_mysql driver and it worked perfectly, both ordered by a field of type int (id) or by a field of type varchar (titulo).

However, after testing in other database in external server with pdo_sqlsrv driver (and also sqlsrv driver) works when the "order by" is by a field of type int (id), but when ordination by a field of type varchar (titulo) gives timeout in the connection.

The following code prints the return of the mySQL database and the SQLServer database:

public function getBy($fields, $orderBy, $where = null, $params = null)
{
    if (empty($where))
        $where = '1 = 1';

    $query = $this->getEntityManager()->createQueryBuilder()
        ->select($fields)
        ->from($this->entity, $this->alias)
        ->where($where)
        ->add('orderBy', $orderBy)
        ->setFirstResult(URIHelper::$arrayParams['offset'])
        ->setMaxResults(URIHelper::$arrayParams['limit'])
        ->getQuery();

    if (!empty($params))
        $query->setParameters($params);

    print_r($query->getSQL());
    //print_r($query->getParameters());
    //print_r($query->getArrayResult());
    //die();
    return $query->getArrayResult();
}

---

Return OK when I use MySQL database ordination titulo(varchar):
!img01.png|thumbnail!

---

Return OK when you use SQLServer database ordination id (int):
!img02.png|thumbnail!

---

Return ERROR when I use SQLServer database ordination titulo(varchar):
!img03.png|thumbnail!

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.