Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHKx5-0074pd-0p for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Apr 2026 12:20:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHKx4-00Dw1C-1F for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Apr 2026 12:20:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHKx4-00Dw14-0P for pgsql-bugs@lists.postgresql.org; Mon, 27 Apr 2026 12:20:38 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wHKx1-00000003KdV-3XzZ for pgsql-bugs@lists.postgresql.org; Mon, 27 Apr 2026 12:20:37 +0000 Received: by mail-qt1-x843.google.com with SMTP id d75a77b69052e-50e5eb0fabaso85488331cf.0 for ; Mon, 27 Apr 2026 05:20:34 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777292433; cv=none; d=google.com; s=arc-20240605; b=ZWq3vjmyaLGzmNetFpplhbpLWqVHWVBTC654pqb6coOR69UR7UWEKAx8CvNIBojMMM BVqfq568B576XgCehluDVFKc02qj9uRp0jj7g176yfmRBL7NZmpd/SasQ48yQ8OABTdz hAJkL9CbWvfyMoSTYTKlqsFSJbIEdcElxxXoGTVurmfKAu1h4RvPSUGVBvHx1QveTXwV AMoVI+LRhBG6WELgAFWjZ3aI9T7GcxWwgAqvJYIRIBhNJ33sP1/gNN0gwsin2aONfAf2 2hd0vaIvm1+/pP7AGUJsFwK/g7VV+KJ1jwjK7naP6gUdJ6wW+LXxIDjXaNUZnXJW8kZf KERw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=9+pfViWM2HTKzvmz0bKZF++Mz3nrYf9CysHYF0Ttu6U=; fh=FEknMU5Gf+/WeU253owtMCIB6sIiLSabzycPuyFMYbM=; b=OK1hHzxoZa+KKxqmpmXL+tx1BeV3/tBxgSa6sBfRIkD4Yd4CMPdjPXVjVAk8VIWB3W 4aDDRtrRmEqb4O5+6QvItM2R52h8cqiW0FVXTETdlCG5de/huyn2yJUEogKUGxHK4aqF CteqqPFsX6VErTpB13Kz9NaZOlDwfTQSV6xbbdEf7wAO/K5Qq9yw2ldgUkFuEPsOStUT 7e9lpsVTj4aCso/3OM0tdsXKkAkr6Y5lVtP15qMi3j6MqQL6W5gQ5ycKMp42ojj66aVC 8rkmCbHupizuM8FyVlLMRADr0pQaW8igI0FCsf9VAdTGRF0cyL0tXYL+96tStJqh3/jq USig==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777292433; x=1777897233; darn=lists.postgresql.org; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=9+pfViWM2HTKzvmz0bKZF++Mz3nrYf9CysHYF0Ttu6U=; b=Tf2KKrGy29RMDAtVa9o9T4RbfEySFVnRjUj6l/7VABpTEHrGJEve/yl0vDRvKM7woA i2MT/mmbgqt4z5TaNiGJketQzykvjYIm6h8fMBvqumB05vMlxvF4WzITQliv0a1xzbxs 1TkcNScT0ZkiJ/d6sePOZwtN04XwRz8Xme9Jjshlqx7H4l8fRPh5oJt+YUcdzoJRsygQ svAzjI7DRolSYg35G3KMPN0R8YVo8whBStV+FJ9XX4tD/DESGDbmJeg3GcGcLi2DS/th SY+Jwe3qtB76l7wHCVXrltyhtCSYg5q8TojkQnbldASVcTGXoK2c+1h58FMa5y0qTCuI 0ILg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777292433; x=1777897233; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=9+pfViWM2HTKzvmz0bKZF++Mz3nrYf9CysHYF0Ttu6U=; b=Qec4/AJ4Ik66xrEnEp5sX6fJl9aR4KxgVbg0XPw0HtaedpqNnq64FTpIoGqL+LP6FE 1T70ilg9ShLTlUoH2tPMAXAySEKwULK/Uuc4MSDJUszWYyfEKcu6BUGHG9maIxW579NW 1yg+c4dMMKshcg9AAFZzr5cExH+Z667Czd3MxMl+/kLEEj98LhZ202pu1nsQpf3cfPui yOcg+nLV/RhXkUJd7ST61yT/mM22He0GdIfmCB5gM+9BPQ0dPgnJC0qMdLAw5OhJi1OH fWXiuZDondQA4NL/47tdeYbsihVI5uH9XoD4GbDXnZJt/NHQ1sbBcUAzXzwnmyrARydM d3LQ== X-Forwarded-Encrypted: i=1; AFNElJ/R9JneBz4eW+eF70CjQvGMR4vP4huwjpRaMTdaPzHoHNegZOlvWcpAqYydrhRdaQw7KvUqK4CabxYR@lists.postgresql.org X-Gm-Message-State: AOJu0YxuGlFJWCfxhJD2HiFlGbzrq6Paccm2ZAjnhn6hNjgq9HB56C0w icJpVjbeEEQuGslupqgWjqL5hwVKntcUb6tnO94eC0Yd2M1J5MKOHBdtYtGljUYU+4SD7HBEHT6 1FB/qWaGIOSVC1g+OayRstXCFDpGenOQ= X-Gm-Gg: AeBDieuhyF/ACbhUAuyHt8+iGxyDK6yvbmCN12qrN79/W1hIyRF2uoCUSvBvTuAwJwE RyYeUTkzw5MOLQdtzBwK3KjOigGFLRUzhai99mwodCuyRRaN92DIWzfnT8PfGad4GLtvs9CVT6R D7VdTqzcveiAM1oYw6tPbOIu+yEd0N4YsXEz7jIU7e1Mu53/cH6Dh5s3DjvMshqQCqi37Q1K6/v fb8fXeB2pYbygW5YQJFVxyGvShz5SFJwarb2CdhhgtaVoT5xIY343zdW2n1Z49cACAhnfQdyZf+ tvqC4hTapVdyKBd5pxdJ6O9RUyGare1kjOFoIq2tJ0BinbWy0elXwXDN9ik2U/mJ7QnWK+/HgFh OjV+BxWHW90zSov8laegjuUX9IZMy9/IsVIHNCQ== X-Received: by 2002:a05:622a:1a91:b0:50f:b61c:ec65 with SMTP id d75a77b69052e-50fb61cf107mr394257791cf.23.1777292433031; Mon, 27 Apr 2026 05:20:33 -0700 (PDT) MIME-Version: 1.0 References: <19467-b75f37ccc0b69261@postgresql.org> In-Reply-To: <19467-b75f37ccc0b69261@postgresql.org> From: John Naylor Date: Mon, 27 Apr 2026 19:20:21 +0700 X-Gm-Features: AVHnY4IZ6zvBK42IHegnMFRScBCB2uUIrDhMAcW-bIkRCXoWKXeOSidnOk58U6A Message-ID: Subject: Re: BUG #19467: Inconsistency in MOD() result involving POWER() and floating-point precision in PostgreSQL To: fmusqlgen@163.com, pgsql-bugs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 27, 2026 at 6:33=E2=80=AFPM PG Bug reporting form wrote: > Mathematically, this corresponds to the fractional part of 3^70.31, whic= h > should be deterministic for a given evaluation strategy. > > However, different systems produce significantly different results: These two statements don't contradict eachother. Trying the expression on WolframAlpha shows 0.41 is close to the expected value, so I don't see a bug here. -- John Naylor Amazon Web Services