I have the following query:
select vehicle0_.id as id
from (
select id, vin, owner, 3 as clazz_ from SUV
union all
select id, vin, owner, 4 as clazz_ from Pickup
union all
select id, vin, owner, 1 as clazz_ from Car
union all
select id, vin, owner, 2 as clazz_ from Truck
) vehicle0_
where owner is null
Which returns no hits, even though each table has 1 row each with a
null owner. Querying the individual tables for a null owner returns
correct counts; and querying the UNION returns 4 rows each with a NULL
value for owner.
Does anybody have any idea what is going on there?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
