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 1wEq3S-004T2r-16 for pgsql-bugs@arkaria.postgresql.org; Mon, 20 Apr 2026 14:56:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEq3R-003WZz-1t for pgsql-bugs@arkaria.postgresql.org; Mon, 20 Apr 2026 14:56:53 +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 1wEq3R-003WZq-11 for pgsql-bugs@lists.postgresql.org; Mon, 20 Apr 2026 14:56:53 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wEq3P-00000001wJ6-1TYN for pgsql-bugs@lists.postgresql.org; Mon, 20 Apr 2026 14:56:52 +0000 Received: by mail-wm1-x331.google.com with SMTP id 5b1f17b1804b1-488a14c31eeso24135915e9.0 for ; Mon, 20 Apr 2026 07:56:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1776697010; x=1777301810; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Np1vp/HzybWmgqzREF4B+pQiRgX8sZUT9dUNQm1hGHw=; b=hrjqu+h78Nu+ETTnVetqdl3v1qitf12d03DdlARWucWKLOSI8EsOtJrdLvZOMj9k/u 8eLi6VtSz7mbWLDyYUCk/Cf54cWfE/mMeJHjeKeCD+S8kgYk48WO0TU5BgAUJmh5FVrS ocJ2vTlwGbTx2fw7wcAvh85woLTMjEFuROE48ISdDA4GjOvDzi9y/MJG2+uHumSbBMnJ G/eYd6G0iGJjGbN1AUcu7qCwzIwzmvvy/bV4xECOQol41DVGsRi/NLsOjQKPWQn0dOb/ bzcfcQYyGY71vAs65h77X6Cr2EnlKi7POBNeZ1feX6OPA93mPSeGWkASmsmvBDZT+lM1 xoew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776697010; x=1777301810; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Np1vp/HzybWmgqzREF4B+pQiRgX8sZUT9dUNQm1hGHw=; b=na/IwmMt3/ybuJRgdsq/Ru2S3813jFPn8d9VL/+PPQLoJI6SyFlchPy1hC/jg6NGcw 2/VkmB9nm0ZObYA4ZLL+e/i5rwPeL3EiMOn2CuBNjWYcBRV/guOHON9dgUASYmthMYfa nvUwVgKplDVKbe4BQLHMtIoxO9UOueH+vI2d2z6jaGDg5kKRwg0KS454yJmugHShgT75 opRse9oqGTB9uxzA9LOLd9rFS+1Cm0TBF9LfK+0abzt6Xuum4vuOvBuDIus+yAKzkOBY K/1fBzzwS71R5dw3622+psfQXmUdxk6MbP4PssIrJlmAuL0gi/MO/uH18z/ISqTV6oKt jlog== X-Forwarded-Encrypted: i=1; AFNElJ96V7JTz5gYMbF4xXZTZe2ZT47juYS+Q8+oUI1HcM6Eci61CnpHe5r6yYk3Zc/38+W+tmy8C/7dx9rH@lists.postgresql.org X-Gm-Message-State: AOJu0YzTgazS9IJewu57o392DfMmisWNDYJoUvvi8/IrcJteykooBQIb k9i+xNaBj4LZExTGI8F8W7mlbjTXrMRKP2mwA/aTyA8UQ297oaEGXuuLGT9ctc4XZoM= X-Gm-Gg: AeBDies5nlWr5HtgpsAeii3rVj+YfVmA5wekvQg4+kpUtYCXoJakdnfsOgaWj1Bz5yz aEkY5kQyUXKIozSp+P2kJNKPd15tISvvBjphiuKdlAU0Vbhek99lZteKOxbE9NSEkV0gW4RJsQ2 idxX21A5ICnOZx+fRD0JIzNdga44kbimds6hpAVtUdYVOLWhp/BasLl8Nf8STsuhF4N7iHK7qS3 gjbC1jrY6MvIuKKL4HsTpJpsG0Z25XKcjYs+Bn8pNaIGRn/Clx/akLU6ECEppXDuqpyrsM4H0fF 4FfjirSVI3qQ/fhOyuXtpYDjC3Zp2DXAGUzoH/BegUsO91iXthOFegWJFuyV9APgHoKhjiqAzHh 4MGLG13CkeSPmquRGyy2+zbvze3xkGp9qPcq88s1Cvc/WBvJZ8tv9EZFDAvvC9M3HQp4npEaSrX uFbs8y38fZQt/0EkL6FCNJy6+9bCQnFyyHST09X1tz+nk0HBOMRIg7P2DFBssh8w== X-Received: by 2002:a05:600c:6085:b0:488:936a:6220 with SMTP id 5b1f17b1804b1-488fb782618mr196309635e9.21.1776697010163; Mon, 20 Apr 2026 07:56:50 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([87.130.122.26]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-488fc18bccfsm264178725e9.8.2026.04.20.07.56.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 20 Apr 2026 07:56:49 -0700 (PDT) Message-ID: <7822b08d294bc18fce24fdfba76d9a7e08128f9b.camel@cybertec.at> Subject: Re: BUG #19461: MERGE with EXISTS subquery referencing USING clause alias fails with "variable not found in subplan From: Laurenz Albe To: 303677365@qq.com, pgsql-bugs@lists.postgresql.org Date: Mon, 20 Apr 2026 16:56:49 +0200 In-Reply-To: <19461-8d03395b71f86664@postgresql.org> References: <19461-8d03395b71f86664@postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2026-04-20 at 09:29 +0000, PG Bug reporting form wrote: > PostgreSQL version: 15.0 Don't report bugs against old, outdated minor releases. Test against 15.latest first. Yours, Laurenz Albe