[DDC-610] Numeric strings are not quoted Created: 25/May/10  Updated: 25/May/10  Resolved: 25/May/10

Status: Closed
Project: Doctrine 2 - ORM
Component/s: ORM
Affects Version/s: 2.0-BETA1
Fix Version/s: 2.0-BETA2
Security Level: All

Type: Bug Priority: Critical
Reporter: David Abdemoulaie Assignee: David Abdemoulaie
Resolution: Fixed Votes: 0
Labels: None


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.

Comment by David Abdemoulaie [ 25/May/10 ]

Fixed in http://github.com/doctrine/doctrine2/commit/b6a5402bcb014e78eb6c0b841609e6f0bba71ef6

Generated at Sun Oct 04 07:19:30 EDT 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.