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 1th2Eb-00FuEh-Ir for pgsql-hackers@arkaria.postgresql.org; Sun, 09 Feb 2025 08:00:09 +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 1th2EZ-00C6Dp-Px for pgsql-hackers@arkaria.postgresql.org; Sun, 09 Feb 2025 08:00:07 +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 1th2EZ-00C6Dh-Gq for pgsql-hackers@lists.postgresql.org; Sun, 09 Feb 2025 08:00:07 +0000 Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1th2EW-004gD5-1f for pgsql-hackers@postgresql.org; Sun, 09 Feb 2025 08:00:07 +0000 Received: by mail-lf1-x130.google.com with SMTP id 2adb3069b0e04-54504a6955aso927922e87.2 for ; Sun, 09 Feb 2025 00:00:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739088003; x=1739692803; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=bXUYa2luMHcPd0dNU9aNnYHHdLf3MU6vTpEnOJd3tMI=; b=DyJMiLt0TZIXhe1gsQ4P1UVLh88fu0S+Nhld18lq94tgW8h/MRzAHUc59vPaUKTP2Y ZpkOGJ9fTXfjQiLBeqoQdhBc6MrWg+IWrzAmm/uRr5xDLI4kYtufV6W+mxoNw76z7xkv qVypYAWprPAMcO8mCokhJNSgR5aImzdlQ4JLwbM4q4HJpHTe+BM1EY24jWysTYH/WJNN iXME3vmb22iN45iVtV0op2nEdrmyDRTNUXx1PxZnoFoE3ajmQn33D2mfnLGwc/p5hfUZ pKOwaHla7WIcFOywvVPiZp5MQ2JKp2dzN87NjFOM/kvHrDR/5IUSNRgV2NPyqJq84sL0 9GCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739088003; x=1739692803; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=bXUYa2luMHcPd0dNU9aNnYHHdLf3MU6vTpEnOJd3tMI=; b=NbqYpR0TJV5eT07U/fCb/afpAceDFzsedDRl+odHTuhKAfz76P5e4xel4uScaF4X8w Q4E8gpL74oMtcRoorpDnRHEV8EfNcKrhqotLVC1R8Eby6cF75XaHrtTeT743r0e5FLyN kYbDt1lB1durCvJSVoT59b7RWxyx4eRGrhtTRrwyRwf2xoOQypoWaiUkdZUjM04mwvbY Ru1MmN1ykP/Pt0Is92JishwznVJRpIkyj1U4PTWdxjjt7u96+9tVY9WmZ+4nEExOmvWH 1thAvjSv50kdX53wgzhWLHcPv13AwEu/3pg1Vb0vjuF0bXlv4kG0bNZkmDy4EC6MWB4Y fkKg== X-Gm-Message-State: AOJu0YxyEXqzCt9C77UR4YpcQhxBOdsIphJKI22eNEEhytgUnk3xKsFy 7Uojui5midwDIWmMC4HxzGV1K381HwrhiYTkiECtnTk0nrxw57GF X-Gm-Gg: ASbGncursYmSS3L1jjk3K6xeb6MHByhhoNgd/C3LMVf6lzxb9JijvShCOVc7uU+2lXW ndtAc4KIOFcwyUI/E5ejHKMsxzy4f1pM0kbjsrzG1FNEHuoE9xiBcRWUcXlPFVI+E8V6x2HzhtI egsWZZHNkdKtKI/NkZ6XKUkiuk5VsB42XwsG3tvhf6Z7El9hhlfG8U9aaGohACMzXcukZvx8PIJ BU9K+LpBQ1tj5z1Zp6sErK5bmq9tI85DTEcDxBxK+aMOkDL/zeGvzopysG/eIM6Jvdq8il4I7Ha 6fPLW/HuIoKvwgO8+A== X-Google-Smtp-Source: AGHT+IGHwiPgoam+TnF7+a9ZY/LGHkC3GJXcLszv+Q5adNIzvT1DbpxIwydZ+blz8hWq84YS2TjG2g== X-Received: by 2002:a05:6512:239e:b0:545:944:aaf5 with SMTP id 2adb3069b0e04-5450944ac8dmr264330e87.9.1739088003239; Sun, 09 Feb 2025 00:00:03 -0800 (PST) Received: from [192.168.0.50] ([89.149.68.176]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-544105f2fdesm916279e87.182.2025.02.09.00.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 09 Feb 2025 00:00:02 -0800 (PST) Message-ID: <75eb1a6f-d59f-42e6-8a78-124ee808cda7@gmail.com> Date: Sun, 9 Feb 2025 10:00:00 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Virtual generated columns To: Peter Eisentraut , Dean Rasheed Cc: pgsql-hackers , jian he References: <09800cb1-43aa-4239-8918-46b71ede4900@eisentraut.org> <536b281b-2cb3-4477-971f-c64838bc6263@eisentraut.org> <51875199-d5f5-41ed-92dc-3e7b1b996991@eisentraut.org> <84adfb1b-826c-42b2-a907-b327d3760c7e@eisentraut.org> <831d7f99-0618-48e5-8557-f3d57137f339@eisentraut.org> <64c2468c-3b69-44d7-863a-165931a70c1d@eisentraut.org> <8be3512a-a23f-4088-a9ec-bf68650a2997@eisentraut.org> Content-Language: en-US From: Alexander Lakhin In-Reply-To: <8be3512a-a23f-4088-a9ec-bf68650a2997@eisentraut.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Peter, 07.02.2025 14:34, Peter Eisentraut wrote: > I've committed it.  Thanks. Please look at a planner error with a virtual generated column triggered by the following script: CREATE TABLE t(a int, b int GENERATED ALWAYS AS (a * 1)); SELECT SUM(CASE WHEN t.b = 1 THEN 1 ELSE 1 END) OVER (PARTITION BY t.a) FROM t AS t1 LEFT JOIN T ON true; ERROR:  XX000: wrong varnullingrels (b) (expected (b 3)) for Var 2/1 LOCATION:  search_indexed_tlist_for_var, setrefs.c:2901 (I discovered this anomaly with SQLsmith.) Best regards, Alexander Lakhin Neon (https://neon.tech)