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 1jYWu0-0000VQ-Dx for pgsql-bugs@arkaria.postgresql.org; Tue, 12 May 2020 15:33:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYWtz-0008Eb-9P for pgsql-bugs@arkaria.postgresql.org; Tue, 12 May 2020 15:33:03 +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 1jYWCW-0004J4-Kr for pgsql-bugs@lists.postgresql.org; Tue, 12 May 2020 14:48:08 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYWCT-0005t6-7T for pgsql-bugs@lists.postgresql.org; Tue, 12 May 2020 14:48:08 +0000 Content-Type: multipart/mixed; boundary="===============6575638655386528888==" MIME-Version: 1.0 Subject: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: val.janeiko@gmail.com Reply-To: val.janeiko@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 12 May 2020 14:47:04 +0000 Message-ID: <16430-f03b90a57994b00f@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6575638655386528888== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQzMApMb2dnZWQgYnk6ICAgICAgICAgIFZhbGVudGluYXMKRW1haWwg YWRkcmVzczogICAgICB2YWwuamFuZWlrb0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Mi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgQWxwaW5lIChjb250YWluZXIpCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpXaGVuIHVzaW5nIFNlcXVlbmNlIGluc2lkZSBhIHBscGdzcWwgZnVuY3Rpb24gY2Fs bGVkIHVzaW5nIFNFTEVDVCBmdW5jKCkKdXNpbmcgTnBnc3FsIGxpYnJhcnkgYSBzZXF1ZW5jZSBp cyBpbmNyZW1lbnRlZCBieSB0aGUgdmFsdWUgc3BlY2lmaWVkIGluCkNBQ0hFLg0KDQpDUkVBVEUg U0VRVUVOQ0UgcmVzb3VyY2Vfc3Vycm9nYXRlX2lkX3VuaXF1aWZpZXJfc2VxdWVuY2UNCiAgICAg ICAgQVMgaW50ZWdlcg0KICAgICAgICBTVEFSVCBXSVRIIDANCiAgICAgICAgSU5DUkVNRU5UIEJZ IDENCiAgICAgICAgTUlOVkFMVUUgMA0KICAgICAgICBNQVhWQUxVRSA3OTk5OQ0KICAgICAgICBD WUNMRQ0KICAgICAgICBDQUNIRSA1Ow0KDQpDUkVBVEUgRlVOQ1RJT04gdXBzZXJ0X3Jlc291cmNl KA0KICAgIF9iYXNlX3Jlc291cmNlX3N1cnJvZ2F0ZV9pZCBiaWdpbnQsDQogICAgX3Jlc291cmNl X3R5cGVfaWQgc21hbGxpbnQsDQogICAgX3Jlc291cmNlX2lkIHZhcmNoYXIoNjQpLA0KICAgIF9l dGFnIGludGVnZXIsDQogICAgX2FsbG93X2NyZWF0ZSBib29sZWFuLA0KICAgIF9pc19kZWxldGVk IGJvb2xlYW4sDQogICAgX2tlZXBfaGlzdG9yeSBib29sZWFuLA0KICAgIF9yZXF1ZXN0X21ldGhv ZCB2YXJjaGFyKDEwKSwNCiAgICBfcmF3X3Jlc291cmNlIGJ5dGVhLA0KICAgIF9yZXNvdXJjZV93 cml0ZV9jbGFpbXMgcmVzb3VyY2Vfd3JpdGVfY2xhaW1fdGFibGVfdHlwZV8xIEFSUkFZLA0KICAg IF9jb21wYXJ0bWVudF9hc3NpZ25tZW50cyBjb21wYXJ0bWVudF9hc3NpZ25tZW50X3RhYmxlX3R5 cGVfMSBBUlJBWSwNCiAgICBfcmVmZXJlbmNlX3NlYXJjaF9wYXJhbXMgcmVmZXJlbmNlX3NlYXJj aF9wYXJhbV90YWJsZV90eXBlXzEgQVJSQVksDQogICAgX3Rva2VuX3NlYXJjaF9wYXJhbXMgdG9r ZW5fc2VhcmNoX3BhcmFtX3RhYmxlX3R5cGVfMSBBUlJBWSwNCiAgICBfdG9rZW5fdGV4dF9zZWFy Y2hfcGFyYW1zIHRva2VuX3RleHRfdGFibGVfdHlwZV8xIEFSUkFZLA0KICAgIF9zdHJpbmdfc2Vh cmNoX3BhcmFtcyBzdHJpbmdfc2VhcmNoX3BhcmFtX3RhYmxlX3R5cGVfMSBBUlJBWSwNCiAgICBf bnVtYmVyX3NlYXJjaF9wYXJhbXMgbnVtYmVyX3NlYXJjaF9wYXJhbV90YWJsZV90eXBlXzEgQVJS QVksDQogICAgX3F1YW50aXR5X3NlYXJjaF9wYXJhbXMgcXVhbnRpdHlfc2VhcmNoX3BhcmFtX3Rh YmxlX3R5cGVfMSBBUlJBWSwNCiAgICBfdXJpX3NlYXJjaF9wYXJhbXMgdXJpX3NlYXJjaF9wYXJh bV90YWJsZV90eXBlXzEgQVJSQVksDQogICAgX2RhdGVfdGltZV9zZWFyY2hfcGFybXMgZGF0ZV90 aW1lX3NlYXJjaF9wYXJhbV90YWJsZV90eXBlXzEgQVJSQVksDQogICAgX3JlZmVyZW5jZV90b2tl bl9jb21wb3NpdGVfc2VhcmNoX3BhcmFtcwpyZWZlcmVuY2VfdG9rZW5fY29tcG9zaXRlX3NlYXJj aF9wYXJhbV90YWJsZV90eXBlXzEgQVJSQVksDQogICAgX3Rva2VuX3Rva2VuX2NvbXBvc2l0ZV9z ZWFyY2hfcGFyYW1zCnRva2VuX3Rva2VuX2NvbXBvc2l0ZV9zZWFyY2hfcGFyYW1fdGFibGVfdHlw ZV8xIEFSUkFZLA0KICAgIF90b2tlbl9kYXRlX3RpbWVfY29tcG9zaXRlX3NlYXJjaF9wYXJhbXMK dG9rZW5fZGF0ZV90aW1lX2NvbXBvc2l0ZV9zZWFyY2hfcGFyYW1fdGFibGVfdHlwZV8xIEFSUkFZ LA0KICAgIF90b2tlbl9xdWFudGl0eV9jb21wb3NpdGVfc2VhcmNoX3BhcmFtcwp0b2tlbl9xdWFu dGl0eV9jb21wb3NpdGVfc2VhcmNoX3BhcmFtX3RhYmxlX3R5cGVfMSBBUlJBWSwNCiAgICBfdG9r ZW5fc3RyaW5nX2NvbXBvc2l0ZV9zZWFyY2hfcGFyYW1zCnRva2VuX3N0cmluZ19jb21wb3NpdGVf c2VhcmNoX3BhcmFtX3RhYmxlX3R5cGVfMSBBUlJBWSwNCiAgICBfdG9rZW5fbnVtYmVyX251bWJl cl9jb21wb3NpdGVfc2VhcmNoX3BhcmFtcwp0b2tlbl9udW1iZXJfbnVtYmVyX2NvbXBvc2l0ZV9z ZWFyY2hfcGFyYW1fdGFibGVfdHlwZV8xIEFSUkFZKQ0KUkVUVVJOUyBpbnRlZ2VyDQpBUyAkJA0K PDxib2R5Pj4NCkRFQ0xBUkUNCiAgICBfdmVyc2lvbiBpbnRlZ2VyOyAtLSB0aGUgdmVyc2lvbiBv ZiB0aGUgcmVzb3VyY2UgYmVpbmcgd3JpdHRlbg0KQkVHSU4NCiAgICBfdmVyc2lvbiA9IG5leHR2 YWwoJ3Jlc291cmNlX3N1cnJvZ2F0ZV9pZF91bmlxdWlmaWVyX3NlcXVlbmNlJyk7DQogICAgUkVU VVJOIF92ZXJzaW9uOw0KRU5EOw0KJCQgTEFOR1VBR0UgcGxwZ3NxbDsNCg0KVGhlIGJlbGxvdyBx dWVyeSBtYWRlIHdpdGggTnBnc3FsIDMgdGltZXMgcmV0dXJucyAwLCA1LCAxMCBpbnN0ZWFkIG9m IDAsIDEsCjI6DQpTRUxFQ1QgdXBzZXJ0X3Jlc291cmNlKEBiYXNlUmVzb3VyY2VTdXJyb2dhdGVJ ZCwgQHJlc291cmNlVHlwZUlkLApAcmVzb3VyY2VJZCwgQGVUYWcsIEBhbGxvd0NyZWF0ZSwgQGlz RGVsZXRlZCwgQGtlZXBIaXN0b3J5LCBAcmVxdWVzdE1ldGhvZCwKQHJhd1Jlc291cmNlLCBAcmVz b3VyY2VXcml0ZUNsYWltcywgQGNvbXBhcnRtZW50QXNzaWdubWVudHMsCkByZWZlcmVuY2VTZWFy Y2hQYXJhbXMsIEB0b2tlblNlYXJjaFBhcmFtcywgQHRva2VuVGV4dFNlYXJjaFBhcmFtcywKQHN0 cmluZ1NlYXJjaFBhcmFtcywgQG51bWJlclNlYXJjaFBhcmFtcywgQHF1YW50aXR5U2VhcmNoUGFy YW1zLApAdXJpU2VhcmNoUGFyYW1zLCBAZGF0ZVRpbWVTZWFyY2hQYXJtcywKQHJlZmVyZW5jZVRv a2VuQ29tcG9zaXRlU2VhcmNoUGFyYW1zLCBAdG9rZW5Ub2tlbkNvbXBvc2l0ZVNlYXJjaFBhcmFt cywKQHRva2VuRGF0ZVRpbWVDb21wb3NpdGVTZWFyY2hQYXJhbXMsIEB0b2tlblF1YW50aXR5Q29t cG9zaXRlU2VhcmNoUGFyYW1zLApAdG9rZW5TdHJpbmdDb21wb3NpdGVTZWFyY2hQYXJhbXMsCkB0 b2tlbk51bWJlck51bWJlckNvbXBvc2l0ZVNlYXJjaFBhcmFtcykNCg0KQWRkaXRpb25hbGx5IGlm IENBQ0hFIGlzIHNldCB0byA+IDgwMDAwIChlLmcuIDEwMDAwMCkgdGhlIHF1ZXJ5IGFsd2F5cwpy ZXR1cm5zIDAuCgo= --===============6575638655386528888==--