Hi, Should the following query return any results and if it does would it be a bug? (assuming it's for a shared network and no manual DB modifications are performed)
select id,public_ip_address from user_ip_address where state='Allocated' and public_ip_address in (SELECT n1.ip4_address FROM nics n1 LEFT JOIN nics n2 ON (n1.ip4_address = n2.ip4_address AND n1.id < n2.id) WHERE n2.id IS NULL and n1.removed is not null); Regards, Prashanth
