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 1pXeX0-0003dW-Pm for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Mar 2023 08:43:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXeWz-0004D0-At for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Mar 2023 08:43:17 +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 1pXeO9-00064S-NN for pgsql-bugs@lists.postgresql.org; Thu, 02 Mar 2023 08:34:09 +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 1pXeO6-0003zp-DV for pgsql-bugs@lists.postgresql.org; Thu, 02 Mar 2023 08:34:09 +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=ks7kcqQaa211KPw/XO62T+O7b5IV7SNz8LSKuKlbQH0=; b=KvFep/JQKCGQWjCShuwEhYwlEM UkXNGtIW0KzfEjg6PM3roxAIUDZLRvLbG0LX0sgh056JkeXf4W/RcsgeWK17zDXPmlq/e9x4iTzQW tKoyFDZbRzk5F8kFWn+C2zssYLw5Q289doxQorQU3X49UOkkwN9igJSIJUT0tZFAEKO33Zb8SsnBK AXrRLk+d6XClwAXXUP+wxuFikxE0/cGHw0S5ppYdrBnuelkF9+D39qkbl7gY5om3fdx32SjFJce+4 7fi4sb64eWTsXgPZpjxUOB6drBVK/woC4dsyqHsAed0P3SyY5WZJQrpKOo77j1CgGux8AKwkmnA1Z drAxsONA==; 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 1pXeO4-00032a-W5 for pgsql-bugs@lists.postgresql.org; Thu, 02 Mar 2023 08:34:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pXeO1-004wyl-4f for pgsql-bugs@lists.postgresql.org; Thu, 02 Mar 2023 08:34:02 +0000 Content-Type: multipart/mixed; boundary="===============5505261869774446423==" MIME-Version: 1.0 Subject: BUG #17818: CTE is not returning the right data. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cute_hoay88@hotmail.com Reply-To: cute_hoay88@hotmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 02 Mar 2023 08:33:51 +0000 Message-ID: <17818-2ef0f7567df79f09@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5505261869774446423== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgxOApMb2dnZWQgYnk6ICAgICAgICAgIFNoaWF1IEhvYXkgT25nCkVt YWlsIGFkZHJlc3M6ICAgICAgY3V0ZV9ob2F5ODhAaG90bWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi4xCk9wZXJhdGluZyBzeXN0ZW06ICAgd2luZG93CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIaSBQb3N0Z3Jlc3FsIFN1cHBvcnQgVGVhbSwgdG9kYXkgaSBlbmNvdW50ZXIgYSBteXN0ZXJ5 IGNhc2UuIFRoZSBTdG9yZWQKUHJvY2VkdXJlIGlzIGFscmVhZHkgdXNlZCBmb3Igc29tZXRpbWUs IGJ1dCB0b2RheSB0aGVyZSBhcmUgc29tZSBpc3N1ZSBpbgp0aGlzIFN0b3JlZCBQcm9jZWR1cmUg d2hpY2ggY2F1c2luZyB0aGUgZGF0YSBnb3QgZGVsZXRlZC4gVGhlIHNjZW5hcmlvIGlzCmxpa2Ug c2FtcGxlIGJlbG93IDoNCg0KCVdJVEggY3RlX3ByaW1hcnlfZGF0YSBBUw0KCQkoDQoJCQlTRUxF Q1QgbXIuaWQsIGYuZmVhdHVyZSwgbXIuaXRlbSwgbXIuZGF0YV90eXBlX2lkDQoJCQlGUk9NIHB1 YmxpYy5wcmltYXJ5X3RhYmxlcyBtcg0KCQkJSU5ORVIgSk9JTiBwdWJsaWMuZmVhdHVyZV90YWJs ZXMgZg0KCQkJCU9OIGYuZmVhdHVyZV9pZCA9IG1yLmZlYXR1cmVfaWQNCgkJCVdIRVJFIG1yLmlk ID0gMzE2Mw0KCQkJCUFORCBtci50ZWFtX2lkID0gMjMNCgkJCQlBTkQgbXIuc3RhZ2VfaWQgPSAy DQoJCSkNCgkJU0VMRUNUICogRlJPTSBjdGVfcHJpbWFyeV9kYXRhIGwNCgkJSU5ORVIgSk9JTiB0 ZW1wX2ZsYXRfZGF0YSBmDQoJCQlPTiBsLmZlYXR1cmUgPSBmLmZlYXR1cmUNCgkJCUFORCBsLml0 ZW0gPSBmLml0ZW0NCg0KU2NlbmFyaW86IFdoZW4gaSBleGVjdXRlIHRoaXMgYWJvdmUgcXVlcnks IGkgYW0gbm90IGFibGUgdG8gZmluZCB0aGUgZmVhdHVyZQpBQSBhbmQgSXRlbSBBQSBFWFQgIElu bmVyLUxhbmUtIDEuMUcuIA0KDQpCdXQgd2VpcmQgaXMgaSB0cmllZCBvdXQgd2l0aCB0aGlzIChi ZWxvdyBleGFtcGxlOiBBZGQgV0hFUkUgaW5zaWRlIHRoZQpjdGUpLCB0aGVuIGkgYW0gYWJsZSB0 byBnZXQgdGhlIGl0ZW06DQoNCldJVEggY3RlX3ByaW1hcnlfZGF0YSBBUw0KCQkoDQoJCQlTRUxF Q1QgbXIuaWQsIGYuZmVhdHVyZSwgbXIuaXRlbSwgbXIuZGF0YV90eXBlX2lkDQoJCQlGUk9NIHB1 YmxpYy5wcmltYXJ5X3RhYmxlcyBtcg0KCQkJSU5ORVIgSk9JTiBwdWJsaWMuZmVhdHVyZV90YWJs ZXMgZg0KCQkJCU9OIGYuZmVhdHVyZV9pZCA9IG1yLmZlYXR1cmVfaWQNCgkJCVdIRVJFIG1yLmlk ID0gMzE2Mw0KCQkJCUFORCBtci50ZWFtX2lkID0gMjMNCgkJCQlBTkQgbXIuc3RhZ2VfaWQgPSAy DQoJCQkJQU5EIG1yLml0ZW0gPSAnQUEgRVhUICBJbm5lci1MYW5lLSAxLjFHJw0KCQkJCUFORCBm LmZlYXR1cmUgPSAnQUEnDQoJCSkNCgkJU0VMRUNUICogRlJPTSBjdGVfcHJpbWFyeV9kYXRhIGwN CgkJSU5ORVIgSk9JTiB0ZW1wX2ZsYXRfZGF0YSBmDQoJCQlPTiBsLmZlYXR1cmUgPSBmLmZlYXR1 cmUNCgkJCUFORCBsLml0ZW0gPSBmLml0ZW0NCg0KSSBkbyB0cnkgb3V0IHdpdGggQ3JlYXRlIFRl bXAgVGFibGUgYWxzbyB3b3JrIGZpbmUgd2l0aCB0aGUgc2FtcGxlIHdpdGhvdXQKbmVlZCBmaWx0 ZXJpbmcgKGFzIGZpbHRlcmluZyB3aWxsIG9ubHkgcmVkdWNlIGRhdGEgcmVjb3JkIHNldCkuIA0K Q2FuIHlvdSBwbGVhc2UgaGVscCB0byBpbnZlc3RpZ2F0ZSBhbmQgZXhwbGFpbiB3aGF0IGlzIHRo ZSBwb3NzaWJsZSByb290CmNhdXNlIGZvciB0aGlzPyANClRoYW5rcyEKCg== --===============5505261869774446423==--