Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of Chiradeep.Vittal@citrix.com
 designates 66.165.176.89 as permitted sender)
From: Chiradeep Vittal <Chiradeep.Vittal@citrix.com>
To: "cloudstack-dev@incubator.apache.org"
	<cloudstack-dev@incubator.apache.org>
Date: Fri, 15 Feb 2013 09:36:22 -0800
Subject: Re: Possible bug around IP release
Thread-Topic: Possible bug around IP release
Thread-Index: Ac4LovoobOoqjQPNT5y4N7c6g4EXvA==
Message-ID: <CD43B20A.822B%chiradeep.vittal@citrix.com>
In-Reply-To: 
 <97F4356AEA71904482CD192135C038F9011CC1390F25@BANPMAILBOX01.citrite.net>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.3.0.121105
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

What is the query trying to achieve?

On 2/15/13 8:07 AM, "Prashanth Reddy Mandadi"
<prashanthreddy.mandadi@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=3D'Allocated=
'
>and public_ip_address in (SELECT n1.ip4_address FROM nics n1 LEFT JOIN
>nics n2 ON (n1.ip4_address =3D n2.ip4_address AND n1.id < n2.id) WHERE
>n2.id IS NULL and n1.removed is not null);
>
>Regards,
>Prashanth