Filtering on two fields in different content types and filtering on content type fails

I have two content types, "condo", and "house". In "condo" I have a field "condo_bedrooms", and in "house" I have the field "house_bedrooms". I display both fields in the view and filter both fields using check boxes from BEF. The fields are integer. I also filter for content type.

If I select only the house content type, and select "1" for house_bedrooms, the view works. But if I leave the checkbox for "1" in house_bedrooms checked, with no selection for condo_bedrooms and then change the content type to "condo", the view produces nothing. Ditto for the converse. If both bedroom filters are checked (any value) it also fails for either or both content types selected.

The view always fails when both bedroom filters have selected values, regardless of which (or both) content types are selected.

I tried "ORing" the two bedroom filters but got the same results.

I tried using the Dependent Filters" module but it only hides the filter - it doesn't disable it or even reset the selection when hidden.

I tried this is D6 and D7. Tried basic filter mode (no BEF) too.

When the view works (only one bedroom filter selected) it produces this SQL:

SELECT node.nid AS nid, node.created AS node_created, 'node' AS field_data_field_house_bedrooms_node_entity_type, 'node' AS field_data_field_condo_bedrooms_node_entity_type
FROM 
{node} node
INNER JOIN {field_data_field_condo_bedrooms} field_data_field_condo_bedrooms ON node.nid = field_data_field_condo_bedrooms.entity_id AND (field_data_field_condo_bedrooms.entity_type = 'node' AND field_data_field_condo_bedrooms.deleted = '0')
WHERE (( (node.type IN  ('condo_unit')) AND (field_data_field_condo_bedrooms.field_condo_bedrooms_value = '1') ))
ORDER BY node_created DESC
LIMIT 10 OFFSET 0

When it fails (both bedroom filters selected):

SELECT node.nid AS nid, node.created AS node_created, 'node' AS field_data_field_house_bedrooms_node_entity_type, 'node' AS field_data_field_condo_bedrooms_node_entity_type
FROM 
{node} node
INNER JOIN {field_data_field_condo_bedrooms} field_data_field_condo_bedrooms ON node.nid = field_data_field_condo_bedrooms.entity_id AND (field_data_field_condo_bedrooms.entity_type = 'node' AND field_data_field_condo_bedrooms.deleted = '0')
WHERE (( (node.type IN  ('standalone_house')) AND (field_data_field_condo_bedrooms.field_condo_bedrooms_value = '1') ))
ORDER BY node_created DESC
LIMIT 10 OFFSET 0

So basically, I cannot make a filter selection on a field in a deselected content type. I would have expected the query to ignore the filter for the deselected content type, or at least not show no results for the selected content type. As you can see, Views won't even run the query for the bedroom field in the selected content type, when the bedroom filter in the other content type has a value selected. Weird.

The quickie solution is to make the bedroom fields shared, but that's a little restrictive in this case for various reasons.