You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cloudstack.apache.org by Prashanth Reddy Mandadi <pr...@citrix.com> on 2013/02/15 17:07:58 UTC

Possible bug around IP release

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

Re: Possible bug around IP release

Posted by Chiradeep Vittal <Ch...@citrix.com>.

What is the query trying to achieve?

On 2/15/13 8:07 AM, "Prashanth Reddy Mandadi"
<pr...@citrix.com> wrote:

>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