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 1nR7az-0007r2-Vd for pgsql-bugs@arkaria.postgresql.org; Mon, 07 Mar 2022 07:15:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nR7ax-0006zI-NZ for pgsql-bugs@arkaria.postgresql.org; Mon, 07 Mar 2022 07:15:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nR1IJ-0003LI-Om for pgsql-bugs@lists.postgresql.org; Mon, 07 Mar 2022 00:32:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nR1ID-0007mB-9k for pgsql-bugs@lists.postgresql.org; Mon, 07 Mar 2022 00:32:10 +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=edFtcbxwDNdxQgHkZrFna0QJ4Nuezy+BmHsVUIoEZVM=; b=bCKOnFH20ekQ/j1pB4UENfXzg5 bprAtwUVd6SxTpbPBFmPKoEBIeBIBqvuApOpZ1VflX//ynOZ6LZRJZaLsU6FhFeycrgjd7tPCk4NN KqH9wwYmuxaHm+aqNZxdhQhBtfN1hyyiEhzbQwYt/QEjWDUVj634qv9UQpT7b4ugS6qxUBU/6xoTp F74EoZ5LDeUfmuiE+Yf3af3kV5aKf5d2RrqTRv40w/icUNVGjKkEr3IMw7xskZD4BGjXdhhsdd9vX JvQEWH61q3eEfvaRNMSTTQ78eJBbDuqM6uGDhZtlvhUN4wbaDqqf5zr+c0MP9RAQIjfKDc+rQTkrV 30pX8ILw==; 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 1nR1IC-0003K4-Rp for pgsql-bugs@lists.postgresql.org; Mon, 07 Mar 2022 00:32: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 1nR1IA-005ALs-DN for pgsql-bugs@lists.postgresql.org; Mon, 07 Mar 2022 00:32:02 +0000 Content-Type: multipart/mixed; boundary="===============5130734474692212607==" MIME-Version: 1.0 Subject: BUG #17428: last_value incorrect for uninitialized sequence To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: glen.edmonds@gmail.com Reply-To: glen.edmonds@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 07 Mar 2022 00:31:33 +0000 Message-ID: <17428-848dee31a3b899ab@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 --===============5130734474692212607== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQyOApMb2dnZWQgYnk6ICAgICAgICAgIEdsZW4gRWRtb25kcwpFbWFp bCBhZGRyZXNzOiAgICAgIGdsZW4uZWRtb25kc0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNC4yCk9wZXJhdGluZyBzeXN0ZW06ICAgTWFjT1MgTW9udGVyZXkgMTIuMi4xCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpGb3IgYSBmcmVzaGx5IGRlZmluZWQgc2VxdWVuY2UsIHRoZSBmb2xsb3dp bmc6DQoNCnNlbGVjdCBsYXN0X3ZhbHVlIGZyb20gbXl0YWJsZV9pZF9zZXENCg0Kc2hvdWxkIHJl dHVybiAwLCBidXQgcmV0dXJucyAxLg0KDQpSZWFzb25pbmc6IEluIGV2ZXJ5IGNhc2UgZXhjZXB0 IHRoZSB1bmluaXRpYWxpc2VkIGNhc2UsIGxhc3RfdmFsdWUgaXMgdGhlCnNhbWUgYXMgdGhlIGN1 cnJlbnQgdmFsdWUgb2YgdGhlIHNlcXVlbmNlLCB3aGljaCBpcyB0aGUgc2FtZSBhcyB0aGUgbnVt YmVyCm9mIHJvd3MgaW4gdGhlIHRhYmxlIChhc3N1bWluZyBubyBkZWxldGlvbnMpLiBMb2dpY2Fs bHksIGlmIHRoZXJlIGFyZSBubwpyb3dzIGluIHRoZSB0YWJsZSwgbGFzdF92YWx1ZSBzaG91bGQg cmV0dXJuIDAgdG8gYmUgY29uc2lzdGVudC4NCg0KVG8gcmVwcm9kdWNlOg0KDQpjcmVhdGUgdGFi bGUgbXl0YWJsZSAoDQogICAgaWQgc2VyaWFsLA0KICAgIG90aGVyIGludA0KKTsNCnNlbGVjdCAo c2VsZWN0IGNvdW50KCopIGZyb20gbXl0YWJsZSksIGxhc3RfdmFsdWUgZnJvbSBteXRhYmxlX2lk X3NlcTsgLS0gMCwKMQ0KaW5zZXJ0IGludG8gbXl0YWJsZSAob3RoZXIpIHZhbHVlcyAoMCk7DQpz ZWxlY3QgKHNlbGVjdCBjb3VudCgqKSBmcm9tIG15dGFibGUpLCBsYXN0X3ZhbHVlIGZyb20gbXl0 YWJsZV9pZF9zZXE7IC0tIDEsCjENCmluc2VydCBpbnRvIG15dGFibGUgKG90aGVyKSB2YWx1ZXMg KDApOw0Kc2VsZWN0IChzZWxlY3QgY291bnQoKikgZnJvbSBteXRhYmxlKSwgbGFzdF92YWx1ZSBm cm9tIG15dGFibGVfaWRfc2VxOyAtLSAyLAoyDQppbnNlcnQgaW50byBteXRhYmxlIChvdGhlcikg dmFsdWVzICgwKTsNCnNlbGVjdCAoc2VsZWN0IGNvdW50KCopIGZyb20gbXl0YWJsZSksIGxhc3Rf dmFsdWUgZnJvbSBteXRhYmxlX2lkX3NlcTsgLS0gMywKMw0KLS0gZXRjDQoNCkFzIHlvdSBjYW4g c2VlLCBvbmx5IHRoZSBmaXJzdCByb3cgcmV0dXJucyBkaWZmZXJlbnQgcmVzdWx0cyBmb3IgdGhl IHNhbWUKZXhwcmVzc2lvbi4NCg0KVGhpcyBpc24ndCBqdXN0IHRoZW9yZXRpY2FsLiBJIHdhcyB3 cml0aW5nIHNvbWUgREIgdW5pdHMgdGVzdHMgYW5kIHRoaXMKY2F1c2VkIG15IGNvZGUgdG8gYnJl YWssIGJ1dCB3YXMgYWxzbyBhIHN1cnByaXNlLg0KSU1ITyB0aGlzIGlzIGEgYnVnLgoK --===============5130734474692212607==--