Category: oracle12c

Using multiple parameters as arguments for Doctrine’s SUBSTRING() function

I think I’ve encountered a Doctrine bug, but I’m wondering if anyone else has encountered this, or if maybe I’m missing something silly: // in controller $qb = $this->getDoctrine()->getRepository(Project::class)->createQueryBuilder(‘p’) ->select(‘p.id’) ->addSelect(‘SUBSTRING(:foo, 1, :pos) AS substrField’) ->setParameter(‘foo’, ‘foobar’) ->setParameter(‘pos’, 3) ;…