Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1foW5Q-00006F-W7 for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Aug 2018 15:45:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1foW5O-00087s-Qg for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Aug 2018 15:45:50 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1foW5O-00087l-GO for pgsql-hackers@lists.postgresql.org; Sat, 11 Aug 2018 15:45:50 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1foW5L-0001h8-Hz for pgsql-hackers@postgresql.org; Sat, 11 Aug 2018 15:45:49 +0000 Received: from ex ([80.187.102.55]) by mail.gmx.com (mrgmx001 [212.227.17.184]) with ESMTPSA (Nemesis) id 0Mdafs-1fY6lQ1OfM-00PLhR for ; Sat, 11 Aug 2018 17:45:44 +0200 From: Andreas Seltenreich To: pgsql-hackers@postgresql.org Subject: [sqlsmith] ERROR: plan should not reference subplan's variable X-PGP-Key: 4096R/803D1FFF 2015-02-04 Key fingerprint = 4758 81DC 8539 494D 29B4 692D F587 0601 803D 1FFF Date: Sat, 11 Aug 2018 17:45:43 +0200 Message-ID: <87va8g7vq0.fsf@ansel.ydns.eu> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Provags-ID: V03:K1:a33QfOPZLZqHJsRpRExaB6CdDsj/I6VvcIqm6j9wjAH2mEDnQxv ilKelwtO1p+IKaLFw9WoTzEd15yWvxE8rUI8AW31/T7h+cGbydzdQoxyruIFQ2pn/SycRYZ 9vMeg8MQRn1Aas7AEv926GMYBNFEdcmVCogdzhqja8ZD0gFT6pibVumChcRicW5KmT+jAoZ 4wvq5Lq/AVB6/9ZpvnKTg== X-UI-Out-Filterresults: notjunk:1;V01:K0:R2WBMgoIO/Y=:LA9bnXtEJj/tflXAkcMrNS bsK3MNeOGJNE0nWgWS3b8APbdPz9mWNvE0hn8yvWeqHUV7xZ1qxqHT8dIcCqQlHqUIUzaUlIt VYNtE/x9x46T0Vh/lwsEHzzwC2zoK3F2N2+n6J+QaAAlslBZFaTivs4+3PWTXZd5z2+3ARMbC 8CZNCMGWcTIaThZwktUGy7eQ3J/47/No6OQWOAL2szQ/KCiCSdwkNGIli4lW+NmHe+0kY769T 0Y5hH3lErCezS6oJ2LRid1N1WquajUDjQMNCFNJgvzzq7EamdQMVBlZg7WuPF3DkXqma0s6/h jYGLCeBpaZXP+2AJwVezeOcit6g8gmVOKKUq86HZvlWdOdaZP9YrjRUrbevcH5owK6CwQP77b ks03avmeivDS4Pgdez3vRzUqhRQuRHDmdBfKsHdAB4tl3D3ThGIPslpDZrYZZJhcZwCOuRXDt t9Qeo/dzw5wjG6rSv17UsPtF+6ONjq6JbQV95cNDhwwJSOr+s1X/BH7CSQB29uimUQD+bI4Qe drm9TWOUDyPjdzkqI2zXKWVqBmtoK8D+Ge68ECpeXDnRwHa0m3z9x5Q4bTZFojmyKgeTRx0dm sl1kHHvQZUDx5kn7U8L0fzm0MPZ56MJd04DsOEgsYuFgQYNVRcUM15Is9zKQtzZqQUkBcen7a /Nl0Om+hkInD+6v9t/SaFg7F1Mt7Vmu5PDHYtgBNzrNTq1riFfXQUUGSvYX+Y9uPkCeA7rp5V ek1BTAB8d4MmbLP7Ra8i7eWfEtMSNsBKMX0OKEz+WMWMJx3SsEn4hMVfBgakSxzKztVF2K7Jp hKfGXBP List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, sqlsmith caused another internal error while testing REL_11_STABLE at 1b9d1b08fe. The query below on the regression DB yields "plan should not reference subplan's variable" for me. regards, Andreas delete from public.prt1_l where EXISTS ( select from public.xmltest as ref_10 , lateral (select ref_10.data as c0 from public.radix_text_tbl as ref_0, lateral (select ref_11.name as c0 from public.equipment_r as ref_11 limit 134) as subq_0 limit 110) as subq_1 where public.prt1_l.c is NULL) returning 42;