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 1miYRs-0000kW-Q4 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Nov 2021 08:50:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1miYRr-00022E-P7 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Nov 2021 08:50:15 +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 1miYOm-0004V8-Nm for pgsql-hackers@lists.postgresql.org; Thu, 04 Nov 2021 08:47:04 +0000 Received: from mail.credativ.com ([93.94.130.90]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1miYOg-0002qJ-5A for pgsql-hackers@postgresql.org; Thu, 04 Nov 2021 08:47:04 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.credativ.com (Postfix) with ESMTP id 0F94D20134; Thu, 4 Nov 2021 08:46:56 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=credativ.de; s=email; t=1636015616; bh=+O94c7zkkqKWBlsA/r+bJohJK5Ew8hzeJwMqY5NUAfo=; h=From:To:Subject:Date:From; b=Gd7eLcQrDvl4cNSzyLj82LgEek7RN7rLOwuwyrPMr/ssbWfQD5oS8WAV22zLuoIY6 dii5RA+vB5pL5u/gYfGpZ2GBq6fRU8w1Ia4vTFz1Fr1PwNl//5oIwxol5o3rLAr0zW +9fnryPv9b41wbE+RKy/LCf+qI/mBU+ePQoiVSoxOQ3jFGG/Y3rYKqnvEyNBpkbx/C rLg6uMpWGg4aO3D4n62FcZuRbbWhzAvht26XYsJzOa9u/v9vBcXZ7BIfuL1uSI1rn+ kvhfYZ+0wYkz2+mG9yCtSPP3fcMb/tL0bIZONk/aXAkkf0srCAloA9t9WOKSvGlzV7 0OXSQSjKBqRKg== Received: from mail.credativ.com ([127.0.0.1]) by localhost (mail.credativ.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VkfWdcsFsM50; Thu, 4 Nov 2021 08:46:50 +0000 (UTC) Received: from nag (nag.land.credativ.lan [172.26.32.104]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: ase) by mail.credativ.com (Postfix) with ESMTPSA id ECBE820028 for ; Thu, 4 Nov 2021 08:46:49 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=credativ.de; s=email; t=1636015610; bh=+O94c7zkkqKWBlsA/r+bJohJK5Ew8hzeJwMqY5NUAfo=; h=From:To:Subject:Date:From; b=I3tioxtA9mABVk/B69hvSiWZ7gD91+oOJfMty+UaVdruEDuUVB2qYY5+n/oeWyonr c0j7T2I3hFHvxMfS4G3RTc3O1Y0DB7C7vDQzl/L9gDgukR47MZGEUUiQeNBHuZdwLT Wxi8dGJlKKjUJ6FOwQxoYXmNrWvT43wUkZw4BbXSmWae5Juu2LftC/3YkzxzHF1zpo aczYZ99DTnEyeQu7CA/xiiNr4CdvDQD5kIjQZnVqIB+fByOoDUies5y/NAK34PUVIB JUaO1sqY4xS0z0AaR5PbHpw5fvjkl1Do6JmGw9MN1LUPvgQSfxMARNXewrKq7WoHt5 VEGo7kLxDAEfA== From: Andreas Seltenreich To: pgsql-hackers@postgresql.org Subject: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE X-PGP-Key: 4096R/803D1FFF 2015-02-04 Key fingerprint = 4758 81DC 8539 494D 29B4 692D F587 0601 803D 1FFF X-Now-Playing: Showdown / In Silico / Pendulum (d&b) Date: Thu, 04 Nov 2021 09:46:49 +0100 Message-ID: <87r1bw9ukm.fsf@credativ.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, sqlsmith triggers the following assertion when testing REL_14_STABLE: TRAP: FailedAssertion("a1 <= a2", File: "brin_minmax_multi.c", Line: 1879, PID: 631814) I can reproduce it with the following query on a fresh regression database: insert into public.brintest_multi (float4col) values (real 'nan'); The branch was at f6162c020c while testing, backtrace below. regards, Andreas (gdb) bt #0 0x00007f703cc46ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x00007f703cc30537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 #2 0x000055b17517c521 in ExceptionalCondition at assert.c:69 #3 0x000055b174d25871 in brin_minmax_multi_distance_float4 (fcinfo=) at brin_minmax_multi.c:1879 #4 0x000055b1751853ba in FunctionCall2Coll (flinfo=flinfo@entry=0x55b176913d10, collation=collation@entry=0, arg1=, arg2=) at fmgr.c:1160 #5 0x000055b174d23a41 in build_distances (distanceFn=distanceFn@entry=0x55b176913d10, colloid=0, eranges=eranges@entry=0x55b17693fad0, neranges=neranges@entry=5) at brin_minmax_multi.c:1352 #6 0x000055b174d256be in compactify_ranges (max_values=32, ranges=0x55b176945708, bdesc=) at brin_minmax_multi.c:1822 #7 brin_minmax_multi_serialize (bdesc=, src=94220687005448, dst=0x55b17693ae10) at brin_minmax_multi.c:2386 #8 0x000055b174d2ae0d in brin_form_tuple (brdesc=brdesc@entry=0x55b176914988, blkno=blkno@entry=15, tuple=tuple@entry=0x55b17693aaa0, size=size@entry=0x7ffffcc6d4f8) at brin_tuple.c:165 #9 0x000055b174d20a5f in brininsert (idxRel=0x7f703b2ae170, values=0x7ffffcc6d610, nulls=0x7ffffcc6d5f0, heaptid=0x55b17690da78,