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 1nWPJX-0007oH-7N for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Mar 2022 21:11:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWPJW-0003s9-5L for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Mar 2022 21:11:42 +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 1nWOn2-00021e-Fj for pgsql-bugs@lists.postgresql.org; Mon, 21 Mar 2022 20:38:08 +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 1nWOmz-0002nR-I1 for pgsql-bugs@lists.postgresql.org; Mon, 21 Mar 2022 20:38:08 +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=s4lz3nyX9nK6omJgMxaZtRQStNuBdNnxyF2NV75d4mI=; b=TYMIVDD8GWYWemcTCB2xoYJljr 5AYmXJiyjiBcGyj6qIUKqLaGGFMH8OKzNZDczADHZ4ENXsAYuYUEdjvPCrVCY+hHFjRtufQAxXvY0 QHMfTxrNHXD6jCLR/pPXtAyXvVocJsZqVK+u9zCCFjWceV8bHpL7eJ63QKu3CO+tXd75Dm0ip4BzS GT5O3v+kSSmgSNI66ey/ESliFofhxR4n4b8Ht3I51bzkEhG42dEAVxsfXeoOqDQXxgWelY9+fGcw6 UemvI/TWOJR+1DiT4vkNNxKydUFKUp06Vsv2DWlmi3Gl8aY9rtgvh/jhau+0P98kGesnbY+UJDBKj zOT4Xfsw==; 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 1nWOmy-0003tu-5q for pgsql-bugs@lists.postgresql.org; Mon, 21 Mar 2022 20:38:04 +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 1nWOmw-0036IC-0S for pgsql-bugs@lists.postgresql.org; Mon, 21 Mar 2022 20:38:02 +0000 Content-Type: multipart/mixed; boundary="===============6386813823809887725==" MIME-Version: 1.0 Subject: BUG #17445: "ON CONFLICT" has different behaviors when its param is passed with prepared stmt or hard coded To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yaser.amiri95@gmail.com Reply-To: yaser.amiri95@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 21 Mar 2022 20:37:15 +0000 Message-ID: <17445-fb74db6348391e85@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 --===============6386813823809887725== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ0NQpMb2dnZWQgYnk6ICAgICAgICAgIFlhc2VyIEFtaXJpCkVtYWls IGFkZHJlc3M6ICAgICAgeWFzZXIuYW1pcmk5NUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNC4yCk9wZXJhdGluZyBzeXN0ZW06ICAgb3BlblNVU0UgTGVhcCAxNS4zIC8gS2VybmVsOiA1 LjMuMTgtMTUwMzAwLjU5LjQ5LWQKRGVzY3JpcHRpb246ICAgICAgICAKCkhpLA0KSSB0aGluayBJ IGZvdW5kIGEgYnVnIG9yIGF0IGxlYXN0IGEgY29uZnVzaW5nIGJlaGF2aW9yIHRoYXQgSSBjYW4n dCBmaW5kIGFueQpkb2N1bWVudGF0aW9uIGFib3V0Lg0KDQpTdW1tYXJ5Og0KSSBoYXZlIGFuIElO U0VSVCBxdWVyeSB0aGF0IGhhcyBhbiAiT04gQ09ORkxJQ1QiIGFuZCBhICJXSEVSRSIgY2xhdXNl IHdoaWNoCnN1cHBvc2UgdG8gaGl0IGEgcGFydGlhbCBtdWx0aWNvbHVtbiB1bmlxdWUgaW5kZXgu DQpXaGVuIEkgdHJ5IHRvIGluc2VydCBzb21lIHJlY29yZHMgaW4gYSB0cmFuc2FjdGlvbiAob25l IGluc2VydCBwZXIgcmVjb3JkKQpXaGVuIEkgcGFzcyB0aGUgcGFyYW1ldGVyIHdoaWNoIGlzIHVz ZWQgaW4gdGhlICJXSEVSRSIgY29uZGl0aW9uIGluIHByZXBhcmVkCnN0YXRlbWVudCBwYXJhbXMs IHRoZSB0cmFuc2FjdGlvbiBmYWlscywgYnV0IGlmIEkgaGFyZCBjb2RlIGl0LCBldmVyeXRoaW5n CndpbGwgYmUgT0sgKG5vIHJvbGxiYWNrIG9yIGVycm9ycykuDQpFcnJvcjogYEVSUk9SOiAgdGhl cmUgaXMgbm8gdW5pcXVlIG9yIGV4Y2x1c2lvbiBjb25zdHJhaW50IG1hdGNoaW5nIHRoZSBPTgpD T05GTElDVCBzcGVjaWZpY2F0aW9uYA0KDQpIZXJlJ3MgYW5vdGhlciB3ZWlyZCB0aGluZywgaW4g dGhlIHNpdHVhdGlvbiBpbiB3aGljaCB0cmFuc2FjdGlvbiBmYWlscywgSWYKSSByZWR1Y2UgdGhl IGluc2VydHMgdG8gbGVzcyB0aGFuIDYsIGl0IGRvZXNuJ3QgZmFpbCEgKEl0IGZhaWxzIG9uIDZ0 aApleGVjdXRpb24pDQoNCkhvdyB0byByZXByb2R1Y2U6DQpJIHRlc3RlZCB0aGlzIG9uIHBvc3Rn cmVzOjE0LjIgZG9ja2VyIGltYWdlIGFuZCBhIGNvdXBsZSBvZiBvdGhlciB2ZXJzaW9ucy4KKFRo aXMgaXMgbXkgZmlyc3QgcmVwb3J0IGFuZCBJJ20gZG9pbmcgdGhpcyB3aXRoIHRoZSBzdWJtaXQg Zm9ybSBvZiB0aGUKd2Vic2l0ZS4gSSBkb24ndCBrbm93IGlmIGl0IGVzY2FwZXMgY2hhcmFjdGVy cyBvciBub3QsIHNvIEkganVzdCB3cml0ZSBzb21lCnJhdyB0aGluZ3MsIHNvcnJ5ISkNCg0KSSBz dGFydCBQb3N0Z3JlczoNCmRvY2tlciBydW4gLS1ybSAtcCA1NDMyOjU0MzIgLS1uYW1lIHBnIC1l ICdQT1NHUkVTX1VTRVI9cG9zdGdyZXMnIC1lCidQT1NUR1JFU19EQj1wb3N0Z3JlcycgLWUgJ1BP U1RHUkVTX1BBU1NXT1JEPXBvc3RncmVzJyAtZCBwb3N0Z3JlczoxNC4yDQoNClRoaXMgaXMgdGhl IHNjaGVtYSBmaWxlICh3aGljaCBjb250YWlucyBhIHRhYmxlIG5hbWVkIGJhbGFuY2UgYW5kIGEg cGFydGlhbAppbmRleCBhbmQgc29tZSBjb25maWdzKQ0KaHR0cHM6Ly9wYXN0ZS5vcGVuc3VzZS5v cmcvMTkwNTgxODMNCg0KSSBpbXBvcnQgIGl0Og0KY2F0IHNjaGVtYS5zcWwgfCBkb2NrZXIgZXhl YyAtaSBwZyBwc3FsIC1VIHBvc3RncmVzIC1kIHBvc3RncmVzDQoNClRoaXMgaXMgdGhlIHF1ZXJ5 IHRoYXQgaXMgT0ssIEl0IGNvbW1pdHMgc3VjY2Vzc2Z1bGx5IGFuZCB3ZSdsbCBoYXZlIG9uZQpy ZWNvcmQgaW4gdGhlIHRhYmxlLCBJIHJ1biBpdDoNCmh0dHBzOi8vcGFzdGUub3BlbnN1c2Uub3Jn LzYxNTU5NjI1DQpjYXQgd29ya3Muc3FsIHwgZG9ja2VyIGV4ZWMgLWkgcGcgcHNxbCAtVSBwb3N0 Z3JlcyAtZCBwb3N0Z3Jlcw0KTm90ZTogSW4gbGluZSA4IHlvdSBjYW4gc2VlIEkgZG9uJ3QgcGFz cyAnMjAyNS0wMS0wMScgYXMgcHJlcGFyZWQgc3RhdGVtZW50CnBhcmFtZXRlci4NCg0KQW5kIEkg bWFrZSBpdCBhIHBhcmFtZXRlciBhbmQgaXQgZmFpbHM6DQpodHRwczovL3Bhc3RlLm9wZW5zdXNl Lm9yZy80NDg1Nzc0NQ0KRVJST1I6ICB0aGVyZSBpcyBubyB1bmlxdWUgb3IgZXhjbHVzaW9uIGNv bnN0cmFpbnQgbWF0Y2hpbmcgdGhlIE9OIENPTkZMSUNUCnNwZWNpZmljYXRpb24NCklmIHlvdSBk ZWxldGUgb25lIG9mIHRoZSBleGVjdXRpb25zIChvbmUgb2YgdGhlIGxpbmVzIGJldHdlZW4gMTQg YW5kIDE5KSBhbmQKcmVkdWNlIHRoZW0gdG8gNSBjYWxscywgSXQgd29uJ3QgcmFpc2UgYW4gZXJy b3IgYW5kIHdvcmtzIGFzIGl0IHNob3VsZCENCg0KRXh0cmEgaW5mbzoNCkRvY2tlciBJbWFnZSBO YW1lOiBwb3N0Z3JlczoxNC4yDQpIb3N0IEtlcm5lbDogTGludXggNS4zLjE4LTE1MDMwMC41OS40 OS1kZWZhdWx0DQoNCkxldCBtZSBrbm93IGlmIHlvdSBuZWVkIGFueXRoaW5nIGVsc2UuDQpUaGFu ayB5b3UuCgo= --===============6386813823809887725==--