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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1j481K-0005T7-BO
	for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Feb 2020 18:54:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1j481I-0002VG-Nz
	for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Feb 2020 18:54:56 +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 <depesz@depesz.com>)
	id 1j481I-0002V9-Ct
	for pgsql-bugs@lists.postgresql.org; Tue, 18 Feb 2020 18:54:56 +0000
Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com)
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <depesz@depesz.com>)
	id 1j481G-000557-Bm
	for pgsql-bugs@postgresql.org; Tue, 18 Feb 2020 18:54:56 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com;
	 s=20170201; h=Content-Type:MIME-Version:Reply-To:Message-ID:Subject:To:
	Sender:From:Date:Cc:Content-Transfer-Encoding:Content-ID:Content-Description:
	Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:
	In-Reply-To:References:List-Id:List-Help:List-Unsubscribe:List-Subscribe:
	List-Post:List-Owner:List-Archive;
	bh=vkdi2X2NekdlTFSavz0qYHtAA25Jo1f99fLQ3g1tQBE=; b=ElfrLGiQJNR0U/hDsFpeObaAJz
	MJgHnuK/0DS703IhTUUHPt5n8PhJm5Zua57fxynjMbN9fG4Z/ezywOS0jLUacRKcjfLJ7YQJiTk88
	I+iorXjTGi4qNse0oeY+e2kwebhzOh646WH2QOSiqaIHzjQlUJEqTT6ez7sKZNC0SVoI=;
Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com)
	by depesz.com with esmtpa (Exim 4.92)
	(envelope-from <depesz@depesz.com>)
	id 1j481E-0002Al-UD
	for pgsql-bugs@postgresql.org; Tue, 18 Feb 2020 19:54:53 +0100
Date: Tue, 18 Feb 2020 19:54:52 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: gen_random_uuid() is immutable in Pg 13devel
Message-ID: <20200218185452.GA8710@depesz.com>
Reply-To: depesz@depesz.com
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Precedence: bulk

Hi,
I noticed that get_random_uuid() from pgcrypt is marked as immutable.

Up to 12.2 it was volatile, and in 13 it became immutable.

This leads to "interesting" change, that:

select gen_random_uuid() from generate_series(1,10);

returns 10 different uuids before 13, and 10 identical ones on 13devel.

It looks that commit 5925e5549890416bcf588334d9d0bc99f8ad6c7f forgot to
mark the function as volatile. Not sure if it was intentional.

Best regards,

depesz