Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuXUx-0005KK-K8 for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Jan 2020 08:05:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iuXUv-0004gE-VH for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Jan 2020 08:05:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuX0u-0002nz-36 for pgsql-bugs@lists.postgresql.org; Thu, 23 Jan 2020 07:34:52 +0000 Received: from mail-oln040092254029.outbound.protection.outlook.com ([40.92.254.29] helo=APC01-PU1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iuX0m-0000Bf-Cr for pgsql-bugs@lists.postgresql.org; Thu, 23 Jan 2020 07:34:50 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=THMfy4SM2pm40QcnVAlv+My0RbynwYe4BaUvxC39JXtfjhFrM+/3SZvZ8Er/wN5EfQdLvY43AvRrL6f/SN0it6H0L0ZGxi5pKc/7Zi2C19TXPozPJ/fNJU2JuqHT9qkIEx4zyc+99WOHHWBBpeijGxy5segkzuIYq6mKrpuyuHMUXed9T4jfrK/pVrSI/TfqOO2OTiqAcBjD/VJib9Q3YNNPNgY9d/zBlw9wz0+5sPkvbZuFKWAVSpbBn76cZG80E+44bLRh31UALpg++tkYetsoD84J2KkoEjLAdHICcFjR0ojY6lv+sIxzrfKzN+p6uQ/j/vYIap0/nODQisHqRg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=A3WpRLYYaDhpa5FbQ6U0VpOYFvwTcaDwSnYVmeI0OQo=; b=eo0/PdIw8CDsXOpDzWThM6Mkcpsh+hKN9qXWiHf5HocaQ7UUXMDkjhq1HpV3PAeWLy+7X8LFt13unD1Ko6c5D7NYTdyVXc0i6hIr9SoDxKUI17hidnnRJXnCboUB17YsysQ8GIxbjrj1elf1wWV2g2PIHDn7HMQPPJNl+Vj7ccaHdfn16vzQxHpCsLxiJWMXYywGMtydF+R7psNoFJVag5ns3BpDwZyi9XPgJDJ/h29OZMQMe3/RwX7wgJAkZCsTP0EaxQraVlTdmmjnxEf2Z2v+ZkUaXng+QKDEx+1Y2DDh8J3RRsyciU7gHBwWzxsmqESek+3tJuaWiY9dFkAvWA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=A3WpRLYYaDhpa5FbQ6U0VpOYFvwTcaDwSnYVmeI0OQo=; b=VSoOPTTINpm70b6O+BWjH90+ikSgYo8ULydHKZO+rDsOfLtte0jrHGT+XKX04l1KH/VcEkVVGrsEBoR8HFWMeqQjscdYS/84MqeF+WM6eegd/w8EkVQV+Bti6kFm3QQLcTg47wguZHBrkGyX/bOVE8ML0jAFXM4VLKtgkA+b3lG1WClsXOkL85n7+jfX9qwdcfkyRseV85cVEsLMUX8hGOxjX8kybmkxvWbGJfAkVZPrhQTzK6AXe33aOPKsCAhGTIIsrHn5L7p1GLN+EacknVzhjlR1yUiE6BsCSLgqsrA6bi46jpQsjXFJcSiHIXodJglrVVZD9iI/At4K7IFdkg== Received: from SG2APC01FT003.eop-APC01.prod.protection.outlook.com (10.152.250.58) by SG2APC01HT060.eop-APC01.prod.protection.outlook.com (10.152.250.251) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2665.18; Thu, 23 Jan 2020 07:34:40 +0000 Received: from MAXPR01MB2157.INDPRD01.PROD.OUTLOOK.COM (10.152.250.54) by SG2APC01FT003.mail.protection.outlook.com (10.152.250.130) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2665.18 via Frontend Transport; Thu, 23 Jan 2020 07:34:40 +0000 Received: from MAXPR01MB2157.INDPRD01.PROD.OUTLOOK.COM ([fe80::6109:8ab6:d9a0:2a27]) by MAXPR01MB2157.INDPRD01.PROD.OUTLOOK.COM ([fe80::6109:8ab6:d9a0:2a27%6]) with mapi id 15.20.2644.028; Thu, 23 Jan 2020 07:34:40 +0000 From: selva kumar To: "pgsql-bugs@lists.postgresql.org" Subject: Query will execute when inner query have issue Thread-Topic: Query will execute when inner query have issue Thread-Index: AQHV0b8t5z/HQhEw4k+SOsI98Pg3hQ== Date: Thu, 23 Jan 2020 07:34:40 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:F04DD0ECB6FF03F6DBE77D48080ACCEF02BCB9A63957E6346A3CEAD33CF52DAF;UpperCasedChecksum:5E79159ED66D086942930F63F5E8C93B522D49C283127DE2B73BACF9B1225212;SizeAsReceived:6705;Count:42 x-tmn: [55xuy2GUooaZbJXk3x3zleHfVqAbdey6] x-ms-publictraffictype: Email x-incomingheadercount: 42 x-eopattributedmessage: 0 x-ms-office365-filtering-correlation-id: 631fdf95-c2c5-4023-aad6-08d79fd6b52b x-ms-traffictypediagnostic: SG2APC01HT060: x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: SXcjKK61d6v+K8/mAgvTNM24bCxg5zWdvA5AAlE7Qn/D1I3QQ5lWJdqmBkI2UAjhamwNnH5YbibS3Cn3As1MI0GhSDvsGK6Fcp64o6LT9YVnvDzG7zYncO6q4dfq8/jGQniZMQnwjkPU0lt0GhKhQGQmx3gdn8hp9cuIl+KkYU7MMmNV6a1+E8riOttxYuaREdv4qZBB0btjLuM/Ik30477Pv79RqYTkBwCUnGV2dXQ= x-ms-exchange-antispam-messagedata: FBs90mbtbqpy+gOIpxh5I+qG0+yxp6RVzHLU2kYCVY7zKIvISPkMvWIp1FQ/mCkbtX8/aQkgU96Hr2UKhfNb5XMBvtqI1QAZnNh9KwkOEeybP0Mx4Uw+aPHdtjR/f4h+mq7248TKuW16QYuUiubgpg== x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_MAXPR01MB21574B7FDC100157148384EEE20F0MAXPR01MB2157INDP_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 631fdf95-c2c5-4023-aad6-08d79fd6b52b X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Jan 2020 07:34:40.6890 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: SG2APC01HT060 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_MAXPR01MB21574B7FDC100157148384EEE20F0MAXPR01MB2157INDP_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Greetings, We tried query in a following manner. SELECT * FROM A where A.id IN (SELECT B.id from B); In the above query Table B does not have id. But this query return all A ta= ble records Note : If we run inner query alone, It throws error like =93Field is not fo= und=94 Sent from Mail for Window= s 10 --_000_MAXPR01MB21574B7FDC100157148384EEE20F0MAXPR01MB2157INDP_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Greetings,

 

We tried query in a following manner.

 

SELECT * FROM A where A.id IN (SELECT B.id from B);<= /p>

 

In the above query Table B does not have id. But thi= s query return all A table records

 

Note : If we run inner query alone, It throws error = like =93Field is not found=94   

 

Sent from Mail for Windows 10

 

--_000_MAXPR01MB21574B7FDC100157148384EEE20F0MAXPR01MB2157INDP_--