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 1jZeSU-0006d3-8u for pgsql-bugs@arkaria.postgresql.org; Fri, 15 May 2020 17:49: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 1jZeSS-0000Gq-F4 for pgsql-bugs@arkaria.postgresql.org; Fri, 15 May 2020 17:49:16 +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 1jZZtL-0003nM-MU for pgsql-bugs@lists.postgresql.org; Fri, 15 May 2020 12:56:43 +0000 Received: from sonic310-23.consmr.mail.ne1.yahoo.com ([66.163.186.204]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jZZtH-0004CR-44 for pgsql-bugs@lists.postgresql.org; Fri, 15 May 2020 12:56:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1589547395; bh=pK5kvlHsrSFwsh8d6YbFIP1RVMyxOpe5XGa4pSstTJQ=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=dk4klCi9iLxm9zz8Snn3OcoERywQyw2IjzjVODP+qC4clwPkBrp6adchV8Z3grlJaM9OsfCQoE1ADDCdNELjp/bZBy5AeFh6FUtjmwnc+GTRjgLQPB5e8PefV6ePxzU8CTxZM/ciVVTbBEvRdqRvfuQ3dO+9HUItF0ctduf/YKMyeOWgsckT3JWC9/sYoHWuqIB1Gd+ysiNmQtzpHV9TWGVrWs/nfYDtYhMlkwlfrxTqH2mcEauA+IUyrtQ8bggysOWy2oZCilY5tBgrCTWI3DtssJ1+T9at183vVwvSSsMDp/WD/ujllPww/UBvVncXuRF0KeLU3CTDTy5c0bw/5g== X-YMail-OSG: ihs1AMMVM1lyzhqDxISPiPTYGRPjI7T9tpK6P13j_Rmvi2DCJC_d2ZT50mXugZn v5MdsPId3PktEQDs6u1Byrop834b_Ra2OnBg063Hxvczb4BFynJCdx5Eqt6810hrDzpzapQAHSX. NcJ82Hrt5oNqmWQyg7SXcM.WgZ67BDRCGKJNNnQB.wQ6vJU_UA9UyVXiiu5y.tKaL88B6tGBjnLp QagVrdFWwnSLQs3VBn_fLgQKT_ixPzgltCniVNQoHLNpc7ZJtflJV6VKgZSJAH6RNZ47s426IanE yjW4v8PgLkdacnFyBV9CUkPdAYFV7IzyyWho7cRwoOK0wCxdkgtbC7H_sSLZzqpk3MCDp.tNRvhx uR_XS1mgAkbLt4eCcnmPSCVcJ.XffZpcQ1fDOWGq4JC_iTN4e4YSwC2csnqXKkr8FtTefpEITlvf L8ThGO7L2piHe5EqQr3HxZTzshlJYxx8KlFIg1LKZh1cF775X.IN72dS4eo4lqz0ddQAOa5sX7JO ZPGCNOqX.vJFXm4XCcve.WCxpdKmP0O6Te8MMsqXA7keI9IAjJa9LwuqfM5SGXlmG38pm58ky5dW 0LZ7FPKtb.P7pXtd6baa3GpIvd98e2YvNJ4hTdpJ1G9DiHvpI7juY8yHOorBTAQc7.ZGLY.lzYe4 TaDGiug10u4ZSV0N.CkJX2lmy7NdITJeA.gbHT7t75DUFRp0E7mMV2Bb1tmLiOTjEOF8MQzJl3gA gX7EJRv96Ugw7xCoZTQZWJFtDz2MBKl6HX8OIMxYbVwTv1sUZt3NZ8ARyKAgA15lc9DAMp6XhF6W nsWsllEgyMShFXgr8oW0BUJy8R9zQoJ9fSmT5cEEDB5OQXKBPk_gyDuTxtYZ85wBEmr7YFY5xcEe j_Ri07hPkC5UTnBZq5vQuI5UtXNrpKWHbCKkc2rCQfh2AK55kxGxoYEPjnYP4PYg7z7oTXj_Dfuu SiyzEKRpzbNtST8pTJsuvcF8SmM9r1Kc_QqO8.OM2tvwYF0jMXcGVFBzPDi4vDLhOU0JtVp3IIx6 qeZ.M_XNiJLU67_FS5jRTptVSK5cxW9HGl6Rn6J5TXwna19opUC3ZKebM.yXsN5uKo7dhrT49ice W.ugcUj1ZQMTVDKuOuKxaW7tutMHAp3pduUgffkJ.P7CmzGUT9kQtYFHq2mg95HW7lGsGCWrzpnJ c62Ddy2GDos1BCWdyjPhrmJpVZAE25xxknbVg6B.47ogbNBU7pLL_qQ4l3ChW3gapzgWvlNMcEqn TKCFEkryDblz8pdh3i9s.K.JIZUM4LJ8cxEtO8FSAu5xBx162COIiBMwDcp36FQxfiINPyUfORsY fUD37eXlHxZ62Hayo.u3Znxjlq0MoxdtPt46x0ISjuh.NUGdd9o.kKfT2xijiJHLSkRq1BNCMxPU v3C_yU4PRofb2nQDY Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.ne1.yahoo.com with HTTP; Fri, 15 May 2020 12:56:35 +0000 Date: Fri, 15 May 2020 12:56:29 +0000 (UTC) From: prashant rokad Reply-To: "prashant_rokad@yahoo.com" To: "david.g.johnston@gmail.com" , PostgreSQL mailing lists Message-ID: <133391319.742712.1589547389739@mail.yahoo.com> In-Reply-To: References: <16435-7b4424691f9ba3dc@postgresql.org> Subject: Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_742711_1337172257.1589547389738" X-Mailer: WebService/1.1.15941 YahooMailAndroidMobile YMobile/1.0 (com.yahoo.mobile.client.android.mail/6.2.2; Android/9; PKQ1.180904.001; whyred; Xiaomi; Redmi Note 5 Pro; 5.7; 2030x1080;) Content-Length: 4158 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_742711_1337172257.1589547389738 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you so much for your reply. I will follow the same. Regards,Prashant Sent from Yahoo Mail on Android=20 =20 On Thu, 14 May 2020 at 2:47 am, David G. Johnston wrote: On Wed, May 13, 2020 at 12:14 PM PG Bug reporting form wrote: The following bug has been logged on the website: Bug reference:=C2=A0 =C2=A0 =C2=A0 16435 Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 prashant Email address:=C2=A0 =C2=A0 =C2=A0 prashant_rokad@yahoo.com PostgreSQL version: 12.2 Operating system:=C2=A0 =C2=A0Windows Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0=20 Hi, we are upgrading postgresql from 9.2 to 12.2 and observed that "regexp_split_to_table" functions is giving different output in 12.2 than 9.2. This was intentional.=C2=A0 You will need to rewrite your query - probably = by moving the call to regexp_split_to_table to the FROM clause and leveragi= ng the LATERAL feature.=C2=A0 David J. =20 ------=_Part_742711_1337172257.1589547389738 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you so much for your reply. I will follow the same.

Regards,
Prashant


On Thu, 14 May 2020 at 2:47 am, David G. John= ston
<david.g.johnston@gmail.com> wrote:
O= n Wed, May 13, 2020 at 12:14 PM PG Bug reporting form <noreply@postgresql.org> wrote:
=
The following bug has been logged = on the website:

Bug reference:      16435
Logged by:          prashant
Email address:      prashant_rokad@yahoo.com
PostgreSQL version: 12.2
Operating system:   Windows
Description:       

Hi,

we are upgrading postgresql from 9.2 to 12.2 and observed that
"regexp_split_to_table" functions is giving different output in 12.2 than 9.2.

This was intent= ional.  You will need to rewrite your query - probably by moving the c= all to regexp_split_to_table to the FROM clause and leveraging the LATERAL = feature. 

David J.
------=_Part_742711_1337172257.1589547389738--