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 1iFulZ-0005FC-Cq for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Oct 2019 06:39:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFulY-0001yV-8n for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Oct 2019 06:39:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFulY-0001yO-1I for pgsql-bugs@lists.postgresql.org; Thu, 03 Oct 2019 06:39:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFulV-0001cP-Ev for pgsql-bugs@lists.postgresql.org; Thu, 03 Oct 2019 06:39:07 +0000 Content-Type: multipart/mixed; boundary="===============7719778862661796474==" MIME-Version: 1.0 Subject: BUG #16035: STATEMENT_TIMEOUT not working when we have single quote usage inside CTE which is used in inner sql To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rmohite@xento.com Reply-To: rmohite@xento.com, pgsql-bugs@lists.postgresql.org Date: Thu, 03 Oct 2019 06:38:33 +0000 Message-ID: <16035-456e6e69ebfd4374@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7719778862661796474== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjAzNQpMb2dnZWQgYnk6ICAgICAgICAgIFJhaiBNb2hpdGUKRW1haWwg YWRkcmVzczogICAgICBybW9oaXRlQHhlbnRvLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEwLjgK T3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJIGhh dmUgY3JlYXRlZCBhIHNpbXBsZcKgc3FsIHdoZXJlIEkgaGF2ZSBhZGRlZCBTVEFURU1FTlRfVElN RU9VVCA9IDEgc2Vjb25kcwphbmQgYWRkZWQgZXhwbGljaXQgZGVsYXkocGdfc2xlZXAoNSkgKSBv ZiA1IHNlY29uZHMgaW5zaWRlIENURS7CoA0KDQpCZWxvdyBzcWwgc2hvdWxkIGdldCBraWxsZWQg YWZ0ZXIgMSBzZWNvbmQgYnV0IGxvb2tzIGxpa2UgaXQgaXMgcnVubmluZyBmb3IKNSBzZWNvbmRz Lg0KDQpTRVQgU1RBVEVNRU5UX1RJTUVPVVQgPSAnMXMnO1NFTEVDVCAqIEZST00gKCBXSVRIIHRl c3QgQVMgKCBTRUxFQ1QKcGdfc2xlZXAoNSksICdCaWxseScgYXMgZW1wX25hbWUgKSBTRUxFQ1Qg MSBGUk9NIHRlc3QgKSBBUyBzdWI7DQoNCk5vdGU6IElmIHdlIHJlbW92ZSB0aGUgcXVvdGVkIHN0 cmluZ8KgJ0JpbGx5JyBBUyBlbXBfbmFtZcKgIGZyb20gYWJvdmUgc3FsCnRoZW4gcHJvcGVyIHRp bWVvdXQgaXMgZ2V0dGluZyBhcHBsaWVkLiBJZiB3ZSBrZWVwIHF1b3RlZCBzdHJpbmfCoC0twqAn QmlsbHknCkFTIGVtcF9uYW1lwqBpbiB0aGUgY29tbWVudCB0aGVuIGFsc28gaXQgZG9lc24ndCB3 b3JrLg0KDQpTb2x1dGlvbjogV2UgYXJlIHN0aWxsIGZpbmRpbmcgdGhlIHJvb3QgY2F1c2UgZm9y IHRoZSBhYm92ZSBiZWhhdmlvciBidXQgSQpmb3VuZCB0aGF0IGlmIHdlIHdpbGwgcHV0IHRoZSBT RVQgU1RBVEVNRU5UX1RJTUVPVVQgYmVmb3JlIGFuZCBhZnRlciB0aGUgc3FsCnRoZW4gaXQgd29y a2luZyBmaW5lLg0KDQpFeGFtcGxlOg0KU0VUIFNUQVRFTUVOVF9USU1FT1VUID0gJzNzJztTRUxF Q1QgKiBGUk9NICggV0lUSCB0ZXN0IEFTICggU0VMRUNUCnBnX3NsZWVwKDUpLCAnQmlsbHknIGFz IGVtcF9uYW1lICkgU0VMRUNUIDEgRlJPTSB0ZXN0ICkgQVMgc3ViO1NFVApTVEFURU1FTlRfVElN RU9VVCA9ICcxcyc7wqDCoA0KDQpBYm92ZSBleGFtcGxlIHdpbGwgdGltZW91dCBhZnRlciAzIHNl Y29uZHMgaS5lLiBpdCB3aWxsIGNvbnNpZGVyIHRoZSAxc3QKdGltZW91dCB2YWx1ZS4NCg0KQ2Fu IHlvdSBwbGVhc2UgaGVscCB1cyB0byBrbm93IHdoeSBTVEFURU1FTlRfVElNRU9VVCBpcyBub3Qg d29ya2luZyBpbiBmaXJzdApleGFtcGxlPwoK --===============7719778862661796474==--