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 1w2UxD-000LOb-14 for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 13:59:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2UxC-001pkY-0m for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 13:59:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w2UxB-001pkP-39 for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 13:59:25 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2Ux8-00000000C3e-3CjE for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 13:59:25 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-661cfb9f3aaso8325972a12.2 for ; Tue, 17 Mar 2026 06:59:24 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773755963; cv=none; d=google.com; s=arc-20240605; b=FwNLCs0HqMLjx+ghqOvz7F6wp6jKTNvUh6rRkcccCoxwDfM1Nc+TUjbetwqH4Hh+kf BKOXzaXs+n1HkszygBqcyP6FFF4OxQOBwxcXdb3BQER27vFmZ5eYEVzSIfwwHeDeOMP2 Rkkgh4jvjsxUGmWzdpQGb4BXkYqRh6NxiyNaxfW5yaWALMvt+JDu2ouBDlNDSpmwFB23 3YzrMkAs5NGzx2yDLZ5Ybfql1EY/oHzi/DEdDk8n2BABNJefXUe28/NhU6Cvtumvy74n PN4UHhvr0C0CwkENkh9zslm/9lxlSyTT1njehBmfZXJLcBvhziOm67T5XI/MWQpuPdVW kgUg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=UjqkvY6Ihq8P+64qD/vsCG9iIxC2pfI/+477zMKtkU0=; fh=Wc+q9WCg8mqrwh8v7nNgCdm3A0AmZzC0cAJsPcHjFqc=; b=AWxRjx4WUgLNiGZ9kevay/+CLa+OYRYkdc9PCJOkiJ8TNuunRZyzoCD/xwxPEKMYis gaP3EZhJu3hKY30WZL7R2Q+mQj0pgmYcqWEROr8FzAd7WFf7AcEUdhI8PbEHADCSV3Wj IIGjlAP2+/GnJjTpQo8JfKPqC+WXy5asKQItVQQ4kmAzMXJrK8vh0lL3oqjxtqc+h/bw OpIdm7sEqdj/XbzTvdD3wzZHGINvPUsJ33iVNYGeAfqy+bawJxi55B7TjzeI0Hknz2Js sDf5jrl47K6oKxTFdm7a1tIIBRJ2V9i66V/pSwQsf8vAXYVrzsCf/ebr7bc1QTsVOiBh 0PhA==; 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=20230601; t=1773755963; x=1774360763; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=UjqkvY6Ihq8P+64qD/vsCG9iIxC2pfI/+477zMKtkU0=; b=Z+W7FdbE8Jj36VSGBwBcpzuUYN/krgK+qKK/ezKrpQ3OhmMBFO8Ku2HXXOrS7KUqi6 1czHx0a0GPLe1hINDGVoxqatoApU/kQ1vzAM4A7moxe6Vw4/L2G7wWm5HTvgbEjd06F0 mO4wf8+Sl3qPAIO8Optqr7umwsOt2ibXSQBx379oqSjMjErH9IDfr/ZFvyITdnHeoDDX mqEk1SPx9Gz4Xs+NCuYQxsP3SNWoEsp747xQoGe+/kvjq0zKXvjVtRDtKNFD6klL83Vc yr+0nXRRBJNyvsmk/uqqm2rDCdWSuAdruoKr18olS2cb1yI+n2lTbMutv7gR8XKoyt22 37fg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773755963; x=1774360763; h=content-transfer-encoding:cc: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=UjqkvY6Ihq8P+64qD/vsCG9iIxC2pfI/+477zMKtkU0=; b=i1nZzy8ugb5JuRKGy2B6OK5UEmDcm0gVuaW63Jffc2UYVcuCkNnl/oq74nEIfBwSEB 8r7Z9i0TyakuxilVtO2AtALIevRa7GJykTafdDAKz1MJ3P3+Vupg+qBpyIs8NDNTKX7l kxogHdhUwspwtTi3bHh2P0JxanAaYBC+yCL5JMfIeQxMkqpWxfuJ7G/169T4yMZFaDIe uja/k6QKVihpCsH0PschLVW2nh4n7a9Zxx2D9HiuiDDb+AgXa3fwSk7NA6pf44dtVcux vGPcuTlfCBqWTkDPstDMAAdYshyMk2beXzl1BYImA6Et9Di19iebaYMqWPFardp8dCLa enNA== X-Gm-Message-State: AOJu0YzIveo2aM2x3CFUtNMyLj5PSoeocitNK8DdUNgxM7ZYNPH/qsNH LSBnvmG3ftXxUE4b3YYZ6FZCj6DNOk4wfaRe5fttHR7xyVnpmHeE9eTMV6uT9ao6l5EVHc6uVja hdQrIvpHhIl/Wuo2puwFbZ/kZyYybT18= X-Gm-Gg: ATEYQzzxL7aI3itTX3+UdnGF5ybHoqTLrzBE2B9x4he+9uffoZ1Boo6SHpMjicSFNIu 28jUv8GKo9p95s4Qzgu/6X4Ics3qKXY7dnnN4iSdB4wxofVh+3pjDUu5nQQb63qnRIIbr2oWP1q n1S6fdamXGMkTRh8LtccE0AaEqTMFZUOgf3bbAf6c/tSFSfzKRCuZu76QUBlZX+Q4AST5MM38C5 0pO3O7EkQUFZXbvImm1eycX4h/prwxbM6Acp2+kJrbsGJz+92IhxAASlFvQMiB/y5ZRQflC4SCy g4Uojfm+tNgFEut/lnRORHFFiw/PCj2dbBN9zeU= X-Received: by 2002:a17:907:68a3:b0:b96:ecc3:781b with SMTP id a640c23a62f3a-b9764f7e782mr602922066b.1.1773755962686; Tue, 17 Mar 2026 06:59:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Haas Date: Tue, 17 Mar 2026 09:59:10 -0400 X-Gm-Features: AaiRm50ZHutUG46-U5w6jFCa3jKObTMgRSfRnwXoY7kr587aClmvmFSGZjioCuI Message-ID: Subject: Re: pgsql: Add pg_plan_advice contrib module. To: David Rowley Cc: PostgreSQL Hackers 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, Mar 16, 2026 at 5:12=E2=80=AFPM David Rowley = wrote: > I was just building with VS2026 when I noticed the following warning: > > ../contrib/pg_plan_advice/pgpa_planner.c(1195): warning C4319: '~': > zero extending 'uint32' to 'uint64' of greater size > > I guess the compiler is concerned that you might not have meant to > unconditionally switch off all the upper 32-bits of the 64-bit > variable. Adding the following does get rid of the warning for me, > but not sure if that's what you had intended. I've not studied the > code enough to understand why there are two different integer widths > being used for the bits. > > - *pgs_mask_p &=3D ~(PGS_JOIN_ANY & ~join_mask); > + *pgs_mask_p &=3D (uint32) ~(PGS_JOIN_ANY & ~join_mask); Thanks for the report. This is an error on my part, pure and simple. At one point, pgs_mask was a 32-bit value, and although that changed months ago, this holdover escaped detection. I'll go fix that. --=20 Robert Haas EDB: http://www.enterprisedb.com