Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Query
-
Labels:None
-
Environment:Ubuntu, oracle 11g, symfony 1.4.3
Description
Hi all,
We create a doctrine query with the Oracle SOUNDEX function.
The Dql generated work fine when we run it on Oracle
on the development envirenment an error is thrown (Unknown function soundex)
this is the Dql generated:
SELECT * FROM ACTOR A WHERE A.bocompanyid = 32 AND soundex(actor_fname || ' ' || actor_name) = soundex('EEEE')
related to :
$q = $this->createQuery('A')->select('*')
->where('A.bocompanyid = ?', $companyId)
->andWhere("soundex(actor_fname || ' ' || actor_name) = soundex ('" .$actorName."')");