Details
Description
I've been working on a MaterializedPath implementation and hit a roadblock.
This condition:
// $pathInterval = array('00010001', '0001ZZZZ');
$andX->add($expr->between('e.' . $this->getPathFieldName(), $expr->literal($pathInterval[0]), $expr->literal($pathInterval[1])));
results in this SQL:
AND (l0_.path BETWEEN 00010000 AND '0001ZZZZ')
This is clearly not correct. Numeric strings should still be quoted if the field is of type string.