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 1tvdgx-006dDT-Cf for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Mar 2025 14:49:47 +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 1tvdgv-008tEx-Ug for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Mar 2025 14:49:45 +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 1tvdgv-008tEU-LH for pgsql-bugs@lists.postgresql.org; Fri, 21 Mar 2025 14:49:45 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvdgt-000Kwo-28 for pgsql-bugs@lists.postgresql.org; Fri, 21 Mar 2025 14:49:45 +0000 Received: by mail-wr1-x433.google.com with SMTP id ffacd0b85a97d-39141ffa9fcso1858509f8f.0 for ; Fri, 21 Mar 2025 07:49:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742568582; x=1743173382; darn=lists.postgresql.org; h=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=FYz6I3y+QQw2TX8X6+IlU78kLB/Du/jA02BSQw79Ulg=; b=dl3GG9jLQ0NTdzX2A85iVfYYayjLMcx/PpN+SJhzgHcmkSmDVKcncxHl0sTBQXvc6z aolePVS0wbK096Zy076P2Mw+817sixnBpyqCsSmJs940zdh2Kj2G/Ukrcwm2ITaHSyy7 n21WcXkBpFRyOdjwHFPSQoyj1eAfuKIrxWVRecvKd12yppaWR+StNbZpKDpxNPCtSQ0z KpwgHW2LjyQCbQBfNcIH7i4r3qBpNlnL1ox/4AkagJ5icPka8lnlIhxgmZbvfuNaPN8k JwP16qMoxMxZlBpXa0bcWsbmqnNsYmXqaMJTheFWweeeivlcVxeEVXVxh5Z60WyXbjoK 6/Cw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742568582; x=1743173382; h=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=FYz6I3y+QQw2TX8X6+IlU78kLB/Du/jA02BSQw79Ulg=; b=PYDGAP51SiuYzzuDP4bWhlpHcXzyK8fSqQ37QAd8SBfyc1WuPfKHiBwmsAq+vKbFKt hiVzVX3jNGypbnrc0gY/qntz8p0Zl/CBxZ9ux15cMiEEDIIHwiAj9BuCEx3/rhZI+PZR nQDAbRYbNh8FNlOG1o2vpi4wwC3khrRZu68UDUsHDIveGfUYwzmBSmvWkKOBtf/syO93 DzJCVai/gvlMVf6KLdRaD7Eg0+l0JZvMUEqzr0bXs/+b14xYyOyFGQIzmR8Vy8B/Ja4y 8Crq5ODSG0E75lDrxBmTPAhoHWXbwLtmH9ZyO5rqJpArI0MsLZNTG8ElyWYyc7XNZHDk NRuQ== X-Forwarded-Encrypted: i=1; AJvYcCVCeWjVSOqZHIoeER+JZTNKWN+/2dw+CqYceOKygDB8NP57HoM6xCLncjclzTaC6qXfW06JmO4HuajK@lists.postgresql.org X-Gm-Message-State: AOJu0YwlbhavJIIkIzInG5P/qk/WjwjMaDhoCs0bQ5AQrHbjaTZCtIUa z4aSKtM0YHv8DmswOQJCUuyrHiTi9peNiKLo6Bm0M1yY1RmHLwfn X-Gm-Gg: ASbGncus2X/TAQLMG0jJMw2gJyRZ9JNDR5FChF0y3hV1lh0gDcoyj2DSoQTZzzS7v0y d3t3Y59HRds9a8/AOqRDoaZfFjyhYCKEk1JHH3DwpmAWvBMZ/YxrCG6YDxc0rgZmK3Nbgm7RLwN BS7rPcrvqJi0i0mN5Aw7A0NiHNNaTwnxxwQMB7po5Zu+GlbbgNxs+nWy76Js+DYaRcEnN5LnNQY BdQQRlY54GGEZLoJDZwqwL0316QsM7dwdWhOhBrrrubEcSJ/FfrLtKF2kQ/KVA4DOpusvl0WQmw 1Q7Z35WvK17N/AwCmaw4VzaWIOTS8HMJ9yeprMqLVh5637BF8JSJYO5GU0ycDKA= X-Google-Smtp-Source: AGHT+IGp/8gm+pD6bViSIwourpAEYMZpBvRzektbBmNmA32ZhixOIou/N7/uVYoTd70GASciLHuslQ== X-Received: by 2002:a5d:6485:0:b0:391:4231:414 with SMTP id ffacd0b85a97d-3997f9397e6mr3891177f8f.40.1742568581604; Fri, 21 Mar 2025 07:49:41 -0700 (PDT) Received: from [10.225.143.200] ([85.184.94.138]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3997f995766sm2538864f8f.1.2025.03.21.07.49.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 21 Mar 2025 07:49:41 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------0X11IKXXtH35ZGwH2bAu31Rq" Message-ID: Date: Fri, 21 Mar 2025 15:49:40 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #18859: ERROR: unexpected plan node type: 356 To: Tom Lane Cc: splarv@ya.ru, pgsql-bugs@lists.postgresql.org References: <18859-0d5f28ac99a37059@postgresql.org> <72c3c1f4-9ed1-4d1c-ae67-eb04b8e50cd1@gmail.com> <1243263.1742562053@sss.pgh.pa.us> Content-Language: en-US From: Andrei Lepikhov In-Reply-To: <1243263.1742562053@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0X11IKXXtH35ZGwH2bAu31Rq Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 21/3/2025 14:00, Tom Lane wrote: > Andrei Lepikhov writes: >> The problem here is in the scrollable cursors code which inserts >> Material node: > > Yeah, I'd just come to the same conclusion. I guess we can make > this code look through a Material node as well as Gather. Yes, as I see there are no additional corner cases. See the code in attachment. -- regards, Andrei Lepikhov --------------0X11IKXXtH35ZGwH2bAu31Rq Content-Type: text/plain; charset=UTF-8; name="scrollable-fix.diff" Content-Disposition: attachment; filename="scrollable-fix.diff" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9wbC9wbHBnc3FsL3NyYy9wbF9leGVjLmMgYi9zcmMvcGwvcGxw Z3NxbC9zcmMvcGxfZXhlYy5jCmluZGV4IGQ0Mzc3Y2VlY2JmLi5mMzY5MWViMmY1OCAxMDA2 NDQKLS0tIGEvc3JjL3BsL3BscGdzcWwvc3JjL3BsX2V4ZWMuYworKysgYi9zcmMvcGwvcGxw Z3NxbC9zcmMvcGxfZXhlYy5jCkBAIC04MzA2LDYgKzgzMDYsOCBAQCBleGVjX3NhdmVfc2lt cGxlX2V4cHIoUExwZ1NRTF9leHByICpleHByLCBDYWNoZWRQbGFuICpjcGxhbikKIAkgKiBH YXRoZXIgbm9kZS4gIFRoZSBHYXRoZXIgbm9kZSdzIHRsaXN0IHdvdWxkIG5vcm1hbGx5IGNv bnRhaW4gYSBWYXIKIAkgKiByZWZlcmVuY2luZyB0aGUgY2hpbGQgbm9kZSdzIG91dHB1dCwg YnV0IGl0IGNvdWxkIGFsc28gYmUgYSBQYXJhbSwgb3IKIAkgKiBpdCBjb3VsZCBiZSBhIENv bnN0IHRoYXQgc2V0cmVmcy5jIGNvcGllZCBhcy1pcy4KKwkgKiBBbHNvLCBpbiBjYXNlIG9m IHNjcm9sbGFibGUgY3Vyc29yIGl0IGNvbnRhaW5zIE1hdGVyaWFsIG5vZGUgYXQgdGhlIHRv cAorCSAqIG9mIHRoZSBwbGFuIHRyZWUuCiAJICovCiAJcGxhbiA9IHN0bXQtPnBsYW5UcmVl OwogCWZvciAoOzspCkBAIC04MzM4LDYgKzgzNDAsMTUgQEAgZXhlY19zYXZlX3NpbXBsZV9l eHByKFBMcGdTUUxfZXhwciAqZXhwciwgQ2FjaGVkUGxhbiAqY3BsYW4pCiAJCQkvKiBEZXNj ZW5kIHRvIHRoZSBjaGlsZCBub2RlICovCiAJCQlwbGFuID0gcGxhbi0+bGVmdHRyZWU7CiAJ CX0KKwkJZWxzZSBpZiAoSXNBKHBsYW4sIE1hdGVyaWFsKSkKKwkJeworCQkJQXNzZXJ0KHBs YW4tPmxlZnR0cmVlICE9IE5VTEwgJiYKKwkJCQlwbGFuLT5yaWdodHRyZWUgPT0gTlVMTCAm JgorCQkJCXBsYW4tPmluaXRQbGFuID09IE5VTEwgJiYKKwkJCQlwbGFuLT5xdWFsID09IE5V TEwpOworCQkJQXNzZXJ0KHBsYW4gPT0gc3RtdC0+cGxhblRyZWUpOworCQkJcGxhbiA9IHBs YW4tPmxlZnR0cmVlOworCQl9CiAJCWVsc2UKIAkJCWVsb2coRVJST1IsICJ1bmV4cGVjdGVk IHBsYW4gbm9kZSB0eXBlOiAlZCIsCiAJCQkJIChpbnQpIG5vZGVUYWcocGxhbikpOwpkaWZm IC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wbHBnc3FsLm91dCBiL3NyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcGxwZ3NxbC5vdXQKaW5kZXggZDhjZTM5ZGJhM2MuLjBl NTQzNWViZGZjIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3BscGdz cWwub3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcGxwZ3NxbC5vdXQKQEAg LTM2NTYsNiArMzY1NiwxMyBAQCAkJCBsYW5ndWFnZSBwbHBnc3FsOwogRVJST1I6ICBjdXJz b3IgRk9SIGxvb3AgbXVzdCB1c2UgYSBib3VuZCBjdXJzb3IgdmFyaWFibGUKIExJTkUgNTog ICBmb3IgciBpbiBjIGxvb3AKICAgICAgICAgICAgICAgICAgICBeCistLSBUZXN0IHNjcm9s bGFibGUgY3Vyc29yIGFuZCBzaW1wbGUgZXhwcmVzc2lvbiBvcHRpbWlzYXRpb24KK0RPICQk CitERUNMQVJFCisgcF9DdXJEYXRhIHJlZmN1cnNvcjsKK0JFR0lOCisgT1BFTiBwX0N1ckRh dGEgU0NST0xMIEZPUiBTRUxFQ1QgTlVMTDsKK0VORDsgJCQ7CiAtLSB0ZXN0IFJFVFVSTiBR VUVSWSBFWEVDVVRFCiBjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlvbiByZXR1cm5fZHF1ZXJ5 KCkKIHJldHVybnMgc2V0b2YgaW50IGFzICQkCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdy ZXNzL3NxbC9wbHBnc3FsLnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3BscGdzcWwuc3Fs CmluZGV4IGQ0MTNkOTk1ZDE3Li43Nzk3YmViNmUwMyAxMDA2NDQKLS0tIGEvc3JjL3Rlc3Qv cmVncmVzcy9zcWwvcGxwZ3NxbC5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvcGxw Z3NxbC5zcWwKQEAgLTMwMzQsNiArMzAzNCwxNCBAQCBiZWdpbgogZW5kOwogJCQgbGFuZ3Vh Z2UgcGxwZ3NxbDsKIAorLS0gVGVzdCBzY3JvbGxhYmxlIGN1cnNvciBhbmQgc2ltcGxlIGV4 cHJlc3Npb24gb3B0aW1pc2F0aW9uCitETyAkJAorREVDTEFSRQorIHBfQ3VyRGF0YSByZWZj dXJzb3I7CitCRUdJTgorIE9QRU4gcF9DdXJEYXRhIFNDUk9MTCBGT1IgU0VMRUNUIE5VTEw7 CitFTkQ7ICQkOworCiAtLSB0ZXN0IFJFVFVSTiBRVUVSWSBFWEVDVVRFCiAKIGNyZWF0ZSBv ciByZXBsYWNlIGZ1bmN0aW9uIHJldHVybl9kcXVlcnkoKQo= --------------0X11IKXXtH35ZGwH2bAu31Rq--