Apparently HypersonicSQL had some difficulty processing the following query
against the PetStore dB:
SELECT itemid, listprice, unitcost, attr1, a.productid, name, descn
from item a, product b
WHERE a.productid = b.productid
and b.productid in (SELECT productid from product WHERE lower(name)
like '%dogs%')
union
select itemid, listprice, unitcost, attr1, a.productid, name, descn
from item a, product b
where a.productid = b.productid
and b.productid in
(select productid from product c, category d where c.category =
d.catid and (lower(d.name)like '%dogs%'))
order by name
I ran the same query through Cloudscape and received the desired results.
Kirk S. Kalvar, Software Engineer
DRS Electronic Systems Group
