Problems when Escaping LIKE-Statements in Oracle

[fleckiboy]

I'm currently facing the following Error.

When running the following code, i get an Error 'ORA-01008: Not all Variables bound'.
The problem are the 2 Escape-Statements in my LIKE-Clauses. If i have just one of these, or none, the statement works perfectly. But everytime i'm using more than one LIKE-ESCAPE clauses, i'm getting the error.

$sql = "SELECT * FROM table WHERE col1 LIKE :p1 ESCAPE '\' OR col2 LIKE :p2 ESCAPE '\'";
$params = array('p1' => '%\_%', 'p2' => 'test');
/** EntityManager $em */
$em->getConnection()->fetchAssoc($sql, $params);

I'm currently running Doctrine\DBAL in version 2.5.4.

[Ocramius]

Please verify on latest DBAL first.

[morozov]

This should be a duplicate of #3371.

[morozov]

This must have been fixed by #4397, no longer reproducible on 3.1.x. In the ANSI mode, the query in question is parsed as:

SELECT * FROM table WHERE col1 LIKE {:p1} ESCAPE '\' OR col2 LIKE {:p2} ESCAPE '\'

The curly braces identify what has been recognized as a parameter (see Doctrine\DBAL\Tests\SQL\ParserTest#testAnsiEscaping()).

[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.