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 1gr1Rx-00071s-4j for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Feb 2019 14:11:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gr1Rv-0005Cl-E1 for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Feb 2019 14:11:43 +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 1gr1Ru-0005Ca-Dq; Tue, 05 Feb 2019 14:11:43 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gr1Rq-0005jn-9N; Tue, 05 Feb 2019 14:11:40 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id C306121B74; Tue, 5 Feb 2019 09:11:36 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Tue, 05 Feb 2019 09:11:36 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=XeJDXX 1WbaZVitBCm/gZj/JzwRFut/84SOKlv1TzZZ0=; b=MAd3U51x4w0mWARs0nO1Tg 2js9SOMJ30SghbWIcgK/H+KLnjaRNPDvBfFv9P+8WOPKbZl+BBDdJLowrMK7wJUo d3SseK/n0U/nrW5UmJLxWPl0kTYMm/JdL5390pXsu+Aeae8NQXIhTGYGfQY5/8UY THRujQDsHAaXFoMEKpG1Jz9A34dddLk7YVuF94+bSmYVmVj0DCHvWnw3Vg4BH90l FrQk/SOsGlGAq19P9xI9/1p7kSjF0ZuMnKSeccTd7x/aRZ1iUZC5iX8q6jgHfa22 WtRL682TtRS71gegtNDNpqFyDhDmD+1w4S11uSmd9eQFcnKJwE7zGfG2w8PROSbA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrkeeigdehjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepuffvfhfhohfkff gfgggjtgesmhdtreertdefjeenucfhrhhomheprfgvthgvrhcugfhishgvnhhtrhgruhht uceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqhhurggurhgrnhhtrdgtohhmqe enucffohhmrghinhepvdhnughquhgrughrrghnthdrtghomhenucfkphepleefrddvgeef rdekfedrvddvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnth hrrghuthesvdhnughquhgrughrrghnthdrtghomhenucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from april.pezone.net (p5df35316.dip0.t-ipconnect.de [93.243.83.22]) by mail.messagingengine.com (Postfix) with ESMTPA id BAA4FE412F; Tue, 5 Feb 2019 09:11:33 -0500 (EST) Subject: Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure To: Tom Lane , "Voillequin, Jean-Marc" References: <1EC8157EB499BF459A516ADCF135ADCE39FFAC54@LON-WGMSX712.ad.moodys.net> <12249.1542824360@sss.pgh.pa.us> Cc: pgsql-bugs@lists.postgresql.org, pgsql-sql@lists.postgresql.org From: Peter Eisentraut Openpgp: preference=signencrypt Autocrypt: addr=peter.eisentraut@2ndquadrant.com; prefer-encrypt=mutual; keydata= xsFNBFUUt6kBEADZd9NNTBJbHmAXXJgPGOdd6Q73l80oifIVgn2tRxP9dYkCfTlo/yLqbKTl JNqTcyM6XrJDnB2sMEUGYCewYZXl+9C4bBJWyNqcEI1ae9u71vEq/fknFLArJ+2wN+f7QuRx Q8d94ZJAiJQ5g3fNk2HVeedCQCKP5dCzU+ZLt2dbsx1PDZLjTO9gf+JswWuGFb5wY5PZVM5V hq66Xk7ZJzHuARacza2RT7J2fkMmQBY+kr7L98Perb0GhafnlhXB0PvUB+N3xpmggMfwuhTu BngS/G/r3GvemxJuFxouw8xsMqrsfdksJXA2gLXYtwRCssdPV3PO0rlD9twqDo8URfIJ5fb6 1g/MV8aTOKjg3Q8MpJPtkwJqN4o3PvbwYdedeFnOVkkYAJdu/aX1v1BeCBDu7Hy3sF52scD3 pQbyQSl9vUDpTLarASAxNbAV0NRJE8dp4vfW6AH1ccryGiFqw/czPK/iN0+MT8wsjAW6WW4w hvjm5UPA1KTwi3ZT8eT5uycuH7QpuNk7LnGGXQ6KaRALFywzkr0A0V0AvFNa+l4wstMaXaB6 dmMXyF0/hfryqyOeu1gAdq4q0/PNC2dPgb/6uoh4eMjN6A5GXcprilhz5DulmsilY21hfSoU S64ODed96pKhprsOxjZiDRsN1QM5MwB+uwVWUNfsX7fIxE0BrwARAQABzSdQZXRlciBFaXNl bnRyYXV0IDxwZXRlckBlaXNlbnRyYXV0Lm9yZz7CwXoEEwEIACQCGwMFCwkIBwMFFQoJCAsF FgIDAQACHgECF4AFAlUUuKQCGQEACgkQoZ8SQ+xBJp8llw//RbGoXnF72FZTlOFsnNyxnWbF vViPCfdAlZl1GGK9OYCvV1dp/956HuhB0wpaGQHiBmQfOPJf/jLOPjXFYm2iEChEycrBChuE j4TSYemMp5BSPILYk9Uwd16kVD/+U6fQfK6H5pOhfBvbM6asMnmpY2wQuvktxHvaGlytFw84 EzFWNZtAZfxkw28w3AhIQkKe9hJanfyDL750RcbyEr8AAHty5IErrvS7tM5vQwIeh5BF26ND CyKPRdZgOgMpcwFfROKBDpAt052CgWIpNdhBdfIKlkCs4/ILxmC3rT/Mb/qZiHcoMMwEu6k+ T7vRAFZZAk62Yrr/U8/vUGKlzRZQoo86fyojCfI0ibCIc0z8rwCVY9P40G9wD9BTCZS/z8Vh jjpBlNnIKw2hM6hbxavKndCJjFFJD08rXrTyrLF/of18xD37vNdYooP9VATB5QjOWFRrscSZ 4a89e+to3m7YVnd4xdXwGp47dYusoax84C8tg1gZrH38ol9dPmnKX6GZrXeS7tH9k8VeUpJ8 HQbRThQRWAT936QpYbLConBmOtmbLmjQOGtiXPo1oK57X/7U/WBja5vWmm2q+Yxtt+3uHGVg DdDU4CJpXo4lX0v2n3QV5EBSW9hjdF3bNfl6GFBb1pPEhqNcMDUc7zkx/2uENdAdk/BnqMgH umip7b0pVfvOwU0EVRS3qQEQAJf6p0P7D+hMYUgCPkvgrcz6OJYsAYdUMUmokfqmkKwK0oJM ew8TNGM53ocKAgQGma5f10rwbZNPlpVPNRX5hwUmwVlcwSut0oE+JfUBH7mpysWvpF05RKIy q9RCoJZrAbXS7Tig56A1QD8IcM00rERZMcCOlI1+q9m4u9AOI+0LyGGSH+VvoyDHD/Jew4R2 TmPEF8Pu7lYiNYK88Q6u0kBkc+Tz3BNlyc6fi3HxnFfp0b75HLXPSTu2SwA/0Q31wHZXwrEU BR9KgSn/qbgy8ydPc97i82fhiFE3cbGexfPrQSMYmDGi+dcQ0s+AMQwC3XyMC0JkHpYUuFkR QdlIvaIhgFUUN2Vr4xF2ADaNTNFc4DYaiPHFAgHZw+3pZWqS4uIiWgJynrEaHw4F3QWU8/JB iyEWDhNq4WBrRA0u914TCCAoFOOKMnRdl8eJrRQKM/5/lXbHFjjlI/LDKhLRFsuQsnJJ3331 RjCzpHPZG5/p5KR1RHiAXa0p/DW5lXyq21hS3kjDlleoHqOxCN/cy0Jgz7qLDq1vZoCl67Sy RAH60c2Xu4may9SVltmot0OzWVHdrfS+85FQGp9580DaeLio7YMFKy2bfEvwQJ/c9xD2QPB+ oSb3V8ueSznXBG5+dyfOsZFRPxceA0wA2rSWZSjxLdKxvyGTj9vsCjaDu13rABEBAAHCwV8E GAEIAAkFAlUUt6kCGwwACgkQoZ8SQ+xBJp+HJhAAxmSTsC5y7p9Zu+nnLpucv/h88oEx985e qWeXzQiwM3pfRZS+PdTH9TyzHK0KOgKoAiubk0vt+BrT91D9d0G5kVQaTctAErGBoMkTaZJT XVEcNphiPzysdSqvprjojMp1y7rG8AP+Xd6m0rE1LRnkRRm8HyI8vdXsuLQPITGWXDLMjaNq AOV3BUnzkgtjMuIYw7SCr+12ZOb5dEKvaG4kjC4kaJ/TLbuBhVANcXkC90yp0AOZLs/cB1Dj OAXno/RUUruJ3r27a+pFv768UAi9QWcdw58yPxreMNMLqAgsS9oTHwHfGNWcB2dJ4UW+GMLJ hTf9TjQ2f+N/sIx5XMQ9pYw6CAJMK29qPx6/ZayrPxf22EXf0D3zTwIEZgwfSkynFVwV25L7 awQq60fifdMYheSxq7GbhpsixmcD+e161cCmLIt75YDt5bQ0B1yf7EmxG8n7pGZAOM6LoNsU fkSldba5XVwh8LuN5mK0nQBELGW6Os4TDq4REggLpfcvFC215zpuo0iCGnmE/Bns4nowqUSP u4tkWL+nxW4qgv8wo8HJ52jd79EJ8iqfIBoidBfy9AIUiEUApGQzWPu6yWcI8fY0rN5D+tc+ Yw1Zt6Mm+huYJpgCRsTcfzEcahnBn521CWcWvhW1ff3KFileFMtNmnBBhMncmRKHphtTKEpN 3jI= Organization: 2ndQuadrant Message-ID: <66209b1a-db5b-d578-6674-1be789c581f5@2ndquadrant.com> Date: Tue, 5 Feb 2019 15:11:32 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <12249.1542824360@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="------------09882932EF42FEF4509D0D17" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------09882932EF42FEF4509D0D17 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit On 21/11/2018 19:19, Tom Lane wrote: > "Voillequin, Jean-Marc" writes: >> SIMPLE=> create or replace procedure same_values_proc(a text, b text) as $body$ >> SIMPLE$> begin >> SIMPLE$> assert a = b; >> SIMPLE$> end;$body$ language plpgsql; >> CREATE PROCEDURE >> SIMPLE=> >> SIMPLE=> call same_values_proc(least('a','b'),'a'); >> ERROR: could not determine which collation to use for string comparison >> HINT: Use the COLLATE clause to set the collation explicitly. > > Yeah, same here. I think somebody forgot to run assign_expr_collations() > on CALL arguments. This appears to fix it. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --------------09882932EF42FEF4509D0D17 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="0001-Add-collation-assignment-to-CALL-statement.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="0001-Add-collation-assignment-to-CALL-statement.patch" RnJvbSA1YzY4ZDRjMDU3ZjJlZDQxZDAzZmFmNDZlMjBlMzNkZjI0OTkwMzA1IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy YXV0Lm9yZz4KRGF0ZTogVHVlLCA1IEZlYiAyMDE5IDE1OjA4OjUzICswMTAwClN1YmplY3Q6 IFtQQVRDSF0gQWRkIGNvbGxhdGlvbiBhc3NpZ25tZW50IHRvIENBTEwgc3RhdGVtZW50CgpP dGhlcndpc2UgZnVuY3Rpb25zIHRoYXQgcmVxdWlyZSBjb2xsYXRpb24gaW5mb3JtYXRpb24g d2lsbCBub3QgaGF2ZQppdCBpZiB0aGV5IGFyZSBjYWxsZWQgaW4gYXJndW1lbnRzIHRvIGEg Q0FMTCBzdGF0ZW1lbnQuCgpSZXBvcnRlZC1ieTogSmVhbi1NYXJjIFZvaWxsZXF1aW4gPEpl YW4tTWFyYy5Wb2lsbGVxdWluQG1vb2R5cy5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vd3d3 LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZmxhdC8xRUM4MTU3RUI0OTlCRjQ1OUE1MTZB RENGMTM1QURDRTM5RkZBQzU0JTQwTE9OLVdHTVNYNzEyLmFkLm1vb2R5cy5uZXQKLS0tCiBz cmMvYmFja2VuZC9wYXJzZXIvYW5hbHl6ZS5jICAgICAgICAgICAgICAgICAgIHwgIDIgKysK IHNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX3Byb2NlZHVyZS5vdXQgfCAgNyAr KysrKysrCiBzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfcHJvY2VkdXJlLnNxbCAgICAg IHwgMTEgKysrKysrKysrKysKIDMgZmlsZXMgY2hhbmdlZCwgMjAgaW5zZXJ0aW9ucygrKQoK ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMgYi9zcmMvYmFja2Vu ZC9wYXJzZXIvYW5hbHl6ZS5jCmluZGV4IDdmNTc3MzU4MmIuLmUzNTQ0ZWZiNmYgMTAwNjQ0 Ci0tLSBhL3NyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMKKysrIGIvc3JjL2JhY2tlbmQv cGFyc2VyL2FuYWx5emUuYwpAQCAtMjYzNiw2ICsyNjM2LDggQEAgdHJhbnNmb3JtQ2FsbFN0 bXQoUGFyc2VTdGF0ZSAqcHN0YXRlLCBDYWxsU3RtdCAqc3RtdCkKIAkJCQkJCQkgdHJ1ZSwK IAkJCQkJCQkgc3RtdC0+ZnVuY2NhbGwtPmxvY2F0aW9uKTsKIAorCWFzc2lnbl9leHByX2Nv bGxhdGlvbnMocHN0YXRlLCBub2RlKTsKKwogCXN0bXQtPmZ1bmNleHByID0gY2FzdE5vZGUo RnVuY0V4cHIsIG5vZGUpOwogCiAJcmVzdWx0ID0gbWFrZU5vZGUoUXVlcnkpOwpkaWZmIC0t Z2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jcmVhdGVfcHJvY2VkdXJlLm91dCBi L3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX3Byb2NlZHVyZS5vdXQKaW5kZXgg NWI5YjgzODM5Yy4uMjExYTQyY2VmYSAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9jcmVhdGVfcHJvY2VkdXJlLm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL2NyZWF0ZV9wcm9jZWR1cmUub3V0CkBAIC0xMzksNiArMTM5LDEzIEBAIEFTICQk CiBTRUxFQ1QgTlVMTDo6aW50OwogJCQ7CiBDQUxMIHB0ZXN0NigxLCAyKTsKKy0tIGNvbGxh dGlvbiBhc3NpZ25tZW50CitDUkVBVEUgUFJPQ0VEVVJFIHB0ZXN0NyhhIHRleHQsIGIgdGV4 dCkKK0xBTkdVQUdFIFNRTAorQVMgJCQKK1NFTEVDVCBhID0gYjsKKyQkOworQ0FMTCBwdGVz dDcobGVhc3QoJ2EnLCAnYicpLCAnYScpOwogLS0gdmFyaW91cyBlcnJvciBjYXNlcwogQ0FM TCB2ZXJzaW9uKCk7ICAtLSBlcnJvcjogbm90IGEgcHJvY2VkdXJlCiBFUlJPUjogIHZlcnNp b24oKSBpcyBub3QgYSBwcm9jZWR1cmUKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2NyZWF0ZV9wcm9jZWR1cmUuc3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRl X3Byb2NlZHVyZS5zcWwKaW5kZXggYjY0MjkzZWQ2Ni4uODliOTZkNTgwZiAxMDA2NDQKLS0t IGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX3Byb2NlZHVyZS5zcWwKKysrIGIvc3Jj L3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX3Byb2NlZHVyZS5zcWwKQEAgLTEwMSw2ICsxMDEs MTcgQEAgQ1JFQVRFIFBST0NFRFVSRSBwdGVzdDYoYSBpbnQsIGIgYW55ZWxlbWVudCkKIENB TEwgcHRlc3Q2KDEsIDIpOwogCiAKKy0tIGNvbGxhdGlvbiBhc3NpZ25tZW50CisKK0NSRUFU RSBQUk9DRURVUkUgcHRlc3Q3KGEgdGV4dCwgYiB0ZXh0KQorTEFOR1VBR0UgU1FMCitBUyAk JAorU0VMRUNUIGEgPSBiOworJCQ7CisKK0NBTEwgcHRlc3Q3KGxlYXN0KCdhJywgJ2InKSwg J2EnKTsKKworCiAtLSB2YXJpb3VzIGVycm9yIGNhc2VzCiAKIENBTEwgdmVyc2lvbigpOyAg LS0gZXJyb3I6IG5vdCBhIHByb2NlZHVyZQotLSAKMi4yMC4xCgo= --------------09882932EF42FEF4509D0D17--