propelorm/Propel — Issue #162: Joins are not supporting Criteria::ISNULL anymore
Author: StasV
Created: 2011-10-25 08:06:24+00:00
State: open

Was using joins like this:
```php
$join->addCondition(Table1Peer::REMOVE_DATE), null, Criteria::ISNULL);
```

Which will result for propel 1.5 into something like this:
```sql
select.....table1 left join table2 ON(table1.REMOVE_DATE IS NULL ..... ) ...
```

Propel 1.6 however produces broken sql code for this

```sql
ON (table1.list.REMOVE_DATE IS NULL table2. .....)
```
where "table2." is a piece of talbe name for null table2 value.

Also, to support more complex queries like "ON(T1.A. = T2.B or T1.C = T2.D and T1.H is not NULL)" I was using a "hack" which is not working anymore. If you could add possibility to pass Criteria object into ON clauses it would solve most problems.

Thanks for reading!