Can not add multiple selections as condition on the same column

[michal-kusy]

Example code:

    $q = $db->table('users');
    foreach(array('admin','user') as $role) {
       $q->where('id',
                         $db->table('user_role')
                               ->select('user_id')
                               ->where('role_id',$role));
    }

Example code adds only first selection, because of hash check in SqlBuilder.php line 200. It's because Selection does not have any unique public property and so it's always translated as empty object {} in JSON.

[matej21]

There is syntax for filtering by another table value:

$db->table('users')->where(':user_role.role_id', array('admin', 'user'))

[michal-kusy]

I know the example is simple. But it proves the issue.
I hit this issue when sub selects were more complicated - like multiple AND conditions on multiple columns etc.

This syntax just didn't suit my needs.

The real issue is that json_encode(array('condition',$selection)) always ends up as "['condition',{}]". Because of the md5 check it's possible to assign only 1 selection to 1 condition.

I guess this restriction is not necessary.

[norbe]

This issue should be fixed..