incubator-cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prashanth Reddy Mandadi <prashanthreddy.mand...@citrix.com>
Subject Possible bug around IP release
Date Fri, 15 Feb 2013 16:07:58 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message