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.94.2) (envelope-from ) id 1teeGc-00EpP2-B9 for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Feb 2025 18:00:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1teeGb-007vyX-05 for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Feb 2025 18:00:21 +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.94.2) (envelope-from ) id 1teeGa-007vyP-N6 for pgsql-hackers@lists.postgresql.org; Sun, 02 Feb 2025 18:00:20 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1teeGX-002u4e-32 for pgsql-hackers@postgresql.org; Sun, 02 Feb 2025 18:00:20 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-5d3f28a4fccso5466736a12.2 for ; Sun, 02 Feb 2025 10:00:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738519217; x=1739124017; darn=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=PdKk9lCW/Gxh+LoO4BJdayXQcEwZUpBXG8GB6oZde3Q=; b=I6roSLdo/KXIsNyCOVhbbO458p7TDb54eRvtcfbFRICGkbh9lEqJZY20IO4eNmEUg1 CvMCcx5eyh/ZrCObW/Dq4+ilXF8XNbNirAJxG1kpB6dgFpTxNBLIGBouQxLxI+zopqOx /acE17eZIdMGGR+lrJtrTbsZkMc1MOjaKfqFIbZvf6C3F1u6o3lYAt8x1agz4mki6ySh s1w9nM+F4IiZjZm1CTmdfh5fBVrJy9HLvmFGEE+wnj7Ajh2hp+Mr+g4hGsxOQLPM8ECc 2wpPXZ1AVGtCA5vmdlD5iA67dah4wyD3wPA8E7CMTuqPNttpuXbLzb6Hi8M8IBu6T58L WYJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738519217; x=1739124017; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=PdKk9lCW/Gxh+LoO4BJdayXQcEwZUpBXG8GB6oZde3Q=; b=Sm3fdt1dygZwo4xtbQOYySFp0Ow6JBaQtkUtVzpEGJr66r4jHRy5O75o8QIyM483b2 alj8AKoWOatGktCX2vnHxfHjM05HZaVGcArXKY6bcZOx4nv2ZU9IiyZJzH3YQe5ZvOLn 0LhQQYzdmBtgGHFoyYK4Z8PIb6wBjcFZjr77DjFf+DMWVFvhVsdihRJdfBMGCqNyUteJ wDsEAab9tt4rdsNmVNEEaDqkl1mPYYMcdX5TatOZJcpDrD3FJu/6oR/e70a5IxDynmIL QKsX3rNvd2N96p0cdVQ18r+RTWlFjQPkJWRFmJGXDXUUxY+6LPcz6XP/Hlce7zYy859e 2NJw== X-Forwarded-Encrypted: i=1; AJvYcCXDZPnCzyKCYUKmGgpGfLaI5TT0wwWii3P4qYddeEdgoVHZyuHNbE4t6b96eGs35/mvcU7NsSftyjq7WkUj@postgresql.org X-Gm-Message-State: AOJu0YzYQ7djULre1/7CTwewQVEyAji4bCsSKTLUg1TZvp5kjhd/ZSrq nqZidjp5VKkTucHWdUqz0lKFGEvT6/HuqHYlQIdwa1249jK7k2As1BHcARWMGtSdtuUIxBawj0/ HvfxUeZ7EU1zMhrNgTCfcrusT0Us= X-Gm-Gg: ASbGnctbl9QC4rFpif4WfmNQ4c235XltJNB2YYtiaB82GQ9tuf7O9Y/XhCIDgXJzGiM US6Iv5GhNuLf3tL+DlXX0uTJONKrBNWiMQ7vakI3c0UbVqqdRmts9DTi5gj6vBRFlwNdIr6xI X-Google-Smtp-Source: AGHT+IGz3wizJmIqNY62NeqZzqQ3KNJEV/1dBIIMe09siBULxoPAvIm/IesfHolw7fe3grXTityOrjwXHUAKCEMHN/M= X-Received: by 2002:a05:6402:248a:b0:5dc:796f:fc89 with SMTP id 4fb4d7f45d1cf-5dc7970050bmr13665498a12.2.1738519217506; Sun, 02 Feb 2025 10:00:17 -0800 (PST) MIME-Version: 1.0 References: <567ED6CA.2040504@sigaev.ru> <37bf870a-22e0-4aba-b845-549482118f8d@gmail.com> <8174de69-9e1a-0827-0e81-ef97f56a5939@gmail.com> <3b717020-14d9-425f-8c60-ce336b5a23b3@postgrespro.ru> <43db6a40-5c5f-4909-ad62-3060b297e686@postgrespro.ru> <41ba3d47-2a48-476c-88d4-6ebd889a7af2@gmail.com> In-Reply-To: From: Alexander Korotkov Date: Sun, 2 Feb 2025 20:00:06 +0200 X-Gm-Features: AWEUYZnb4FxjLIWiYAsVh8bDH3KVHP2N9b7H0HpgFBOmqqz6ajQORqVUutV4yAk Message-ID: Subject: Re: POC, WIP: OR-clause support for indexes To: Alena Rybakina Cc: Ranier Vilela , Alexander Lakhin , jian he , Robert Haas , Nikolay Shaplov , pgsql-hackers@lists.postgresql.org, pgsql-hackers@postgresql.org, Peter Geoghegan , Marcos Pegoraro , teodor@sigaev.ru, Peter Eisentraut , Andrei Lepikhov 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 Fri, Jan 31, 2025 at 4:31=E2=80=AFPM Alena Rybakina wrote: > I started reviewing at the patch and saw some output "ERROR" in the outpu= t of the test and is it okay here? > > SELECT * FROM tenk1 t1 > WHERE t1.thousand =3D 42 OR t1.thousand =3D (SELECT t2.tenthous FROM tenk= 1 t2 WHERE t2.thousand =3D t1.tenthous); > ERROR: more than one row returned by a subquery used as an expression The output is correct for this query. But the query is very unfortunate for the regression test. I've revised query in the v47 revision [1]. Links. 1. https://www.postgresql.org/message-id/CAPpHfdsBZmNt9qUoJBqsQFiVDX1%3DyCK= puVAt1YnR7JCpP%3Dk8%2BA%40mail.gmail.com ------ Regards, Alexander Korotkov Supabase