Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjpbb-00041t-5D for pgsql-bugs@arkaria.postgresql.org; Mon, 30 Nov 2020 20:17:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kjpbZ-0007rJ-Qx for pgsql-bugs@arkaria.postgresql.org; Mon, 30 Nov 2020 20:17:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjnkU-0005xD-UQ for pgsql-bugs@lists.postgresql.org; Mon, 30 Nov 2020 18:18:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjnkT-0005Vm-5Q for pgsql-bugs@lists.postgresql.org; Mon, 30 Nov 2020 18:18:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=TfsrejUKLkE3H+AF+ON8m51KMNHEiT2RdmN0FgQ8fEU=; b=Ti6aA0BKqFTttKEwkPYfNUTfvy +YFq37gMzGP57Xsj4J7cUMlWZRi1IjtZPY3bqOVpC3u/Sw5w4W0KqciF8t8xPThSWqXQz2b0mvpgZ uk1j+esp3YHiq236nR+cUkHuulDi/pwtj6mSTnkg/frteMhkAq93VnrwdpMMZEG+Il5Y4qBI/4+Nj aAm4WVC5UI6+xIF7ssWCoIux/gEN/5DfBOJ5tRdsr6x8TQxfWCzkjmmlR/GnZjanxh5EZxqXkvUFW M0l4YL3Wd4UHe93utre6ns+dw2fVQ9F/gT34Cve5onGWvMtCwOXDs2mmWMsGncUqNC1JSnXgJKxyZ P6VmUowg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjnkR-00036p-O4 for pgsql-bugs@lists.postgresql.org; Mon, 30 Nov 2020 18:18:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kjnkQ-0001vt-JR for pgsql-bugs@lists.postgresql.org; Mon, 30 Nov 2020 18:18:02 +0000 Content-Type: multipart/mixed; boundary="===============6607395612330758027==" MIME-Version: 1.0 Subject: BUG #16753: 'expected 2-element int8 array' error while getting data using query with subquery To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: anjithapaul@gmail.com Reply-To: anjithapaul@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 30 Nov 2020 18:17:59 +0000 Message-ID: <16753-0e156a5fd6cee2d3@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6607395612330758027== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc1MwpMb2dnZWQgYnk6ICAgICAgICAgIEFuaml0aGEgUGF1bG9zZQpF bWFpbCBhZGRyZXNzOiAgICAgIGFuaml0aGFwYXVsQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDEyLjUKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzLCBMaW51eApEZXNjcmlwdGlvbjog ICAgICAgIAoKSSBhbSB1c2luZyB0aW1lc2NhbGUgZGIgb24gdG9wIG9mIHBvc3RncmVzIGRiLiAN CkkgYW0gaGF2aW5nIHRhYmxlIHdpdGggbWFjX2FkZHJlc3MgYW5kIHVwdGltZS4gTWFjIGFkZHJl c3Mgd2lsbCBiZSBnaXZlbgp3aXRoIGNvbG9uIG9yIHdpdGhvdXQgY29sb24uIEkgYW0gaGF2aW5n IHRoZSBmb2xsb3dpbmcgZGF0YQ0KDQogICBtYWNfYWRkcmVzcyAgIHwgICAgICB0aW1lc3RhbXAg ICAgICB8IHVwdGltZQ0KLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tDQogQUE6QkI6NDU6VFQ6Q0M6MzQgfCAyMDIwLTExLTMwIDAwOjAw OjA0IHwgICAgMA0KIDExMjIzMzQ0NTU2NiAgICAgICAgIHwgMjAyMC0xMS0zMCAwMDowMDowNiB8 ICAgIDANCiBOTjpDQzozMzozMzoyMjoyMiB8IDIwMjAtMTEtMzAgMDA6MDA6MDUgfCAgICAwDQog QUE6QkI6NDU6VFQ6Q0M6MzQgfCAyMDIwLTExLTMwIDAwOjMwOjA0IHwgICAgMQ0KIDExMjIzMzQ0 NTU2NiAgICAgICAgIHwgMjAyMC0xMS0zMCAwMDozMDowNiB8ICAgIDENCiBOTjpDQzozMzozMzoy MjoyMiB8IDIwMjAtMTEtMzAgMDA6MzA6MDUgfCAgICAxIA0KDQpJIGhhdmUgY3JlYXRlZCBhbiBo b3VybHkgY29udGlub3VzIGFnZ2dyZWdhdGUgdmlldyB0byBnZXQgYXZlcmFnZSB1cHRpbWUgaW4K ZWFjaCBob3VyIHVzaW5nIGJlbG93IHF1ZXJ5DQoNCkNSRUFURSBWSUVXIGFnZ3JlZ2F0ZWRfZGF0 YQ0KV0lUSCAodGltZXNjYWxlZGIuY29udGludW91cykgQVMNClNFTEVDVA0KdGltZV9idWNrZXQo SU5URVJWQUwgJzEgaG91cicsIHRpbWVzdGFtcCkgQVMgdGltZV9idWNrZXQsDQptYWNfYWRkcmVz cywNCkFWRyh1cHRpbWUpIEFTIGF2Z191cHRpbWUNCkZST00gZGF0YV90YWJsZQ0KR1JPVVAgQlkg dGltZV9idWNrZXQsIG1hY19hZGRyZXNzDQpXaGVuIEkgYW0gdHJ5aW5nIHRvIGdldCBkYXRhIGZy b20gYWdncmVnYXRlZF9kYXRhIHRhYmxlIHVzaW5nIGJlbG93IHF1ZXJ5LCBJCmFtIGdldHRpbmcg ZXJyb3IgJ2V4cGVjdGVkIDItZWxlbWVudCBpbnQ4IGFycmF5Jw0KDQpTRUxFQ1QgbWFjX2FkZHJl c3MsIHRpbWVfYnVja2V0LA0KYXZnX3VwdGltZSwgY291bnQoKikgb3ZlcigpIGFzIGNvdW50DQpG Uk9NIGFnZ3JlZ2F0ZWRfZGF0YQ0KV0hFUkUgdGltZV9idWNrZXQgPj0gJzIwMjAtMTAtMjggMTg6 MDA6MDAnIGFuZCB0aW1lX2J1Y2tldCA8ICcyMDIwLTExLTMwCjA4OjMxOjUyJw0KQU5EIG1hY19h ZGRyZXNzIElOICgNCiAgICAgICAgICBTRUxFQ1QgbWFjX2FkZHJlc3MNCiAgICAgICAgICBGUk9N IGFnZ3JlZ2F0ZWRfZGF0YQ0KICAgICAgICAgIFdIRVJFIHRpbWVfYnVja2V0ID49ICcyMDIwLTEx LTI4IDE4OjAwOjAwJyBhbmQgdGltZV9idWNrZXQgPAonMjAyMC0xMS0zMCAwODozMTo1MicNCiAg ICAgICAgICBHUk9VUCBCWSBtYWNfYWRkcmVzcw0KICAgICAgICAgIEhBVklORyBBVkcoYXZnX3Vw dGltZSkgPiAwIEFORCBBVkcoYXZnX3VwdGltZSkgPD0xMA0KICApDQpPUkRFUiBCWSB0aW1lX2J1 Y2tldCBMSU1JVCAxMCBPRkZTRVQgMAoK --===============6607395612330758027==--