[DC-1016] Set method in update query ignores 'false' if passed as boolean Created: 05/Jul/11 Updated: 05/Jul/11 |
|
| Status: | Open |
| Project: | Doctrine 1 |
| Component/s: | Query |
| Affects Version/s: | 1.2.4 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Minor |
| Reporter: | Paweł Barański | Assignee: | Guilherme Blanco |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Symfony 1.4.11 , Ubuntu 11, PHP 5.3 |
||
| Description |
|
I had to define this function: public function deactivate($segment_id) { $query = $this->createQuery() ->update('Segment s') ->set('s.is_active ', false) //not working // ->set('s.is_active ', (int)false) //works ok // ->set('s.is_active ', true) //works ok ->where('s.id = ?', $segment_id); // var_dump($query->getSqlQuery());die; return $query->execute(); }Problem is that when setting a column using boolean false you get invalid SQL query like this: Workaround is to do it like this: set('s.is_active ', (int)false) , but since setting the same column with boolean true works, false should work too. |