Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gSR40-0001ur-OF for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Nov 2018 18:29:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gSR3z-0007Es-0X for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Nov 2018 18:29:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gSR3y-00077g-Ek for pgsql-hackers@lists.postgresql.org; Thu, 29 Nov 2018 18:29:22 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gSR3u-0000Zp-Ky for pgsql-hackers@lists.postgresql.org; Thu, 29 Nov 2018 18:29:21 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 6D69921CC4D8; Thu, 29 Nov 2018 21:29:16 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=x tagged_above=-99 required=4 WHITELISTED tests=[] autolearn=unavailable Received: from [192.168.27.182] (gw.postgrespro.ru [93.174.131.141]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 2B56221C8F05; Thu, 29 Nov 2018 21:29:16 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1543516156; bh=oVH2JBlXTH02/XLexzGTHbffhD7E+UsL42JmlBS3l9c=; h=Subject:From:To:Cc:References:Date:In-Reply-To; b=UZY1RcpVPpV65ySaU68jhw66BHEb8+0YomdJKq3ewUgO60+AL+U4/mYHkYGx8/s4j cjDWV+iSbyMbJvBJd9GDOr0Fywojs+yVDBxZTYYJziFVn28PKFeO4T3ZuHSOtSBvUO pUfvQWn/+/7RBtakQdNzTyaAilHKzeQl9lVz3sTk= Subject: Re: "SELECT ... FROM DUAL" is not quite as silly as it appears From: Alexander Kuzmenkov To: pgsql-hackers@lists.postgresql.org, Tom Lane Cc: Mark Dilger References: <15944.1521127664@sss.pgh.pa.us> <154342395130.2093.8013327151440360209.pgcf@coridan.postgresql.org> <154342412161.2094.14859341952034622342.pgcf@coridan.postgresql.org> <6d51c9bb-ccc6-92fd-b6ac-05f0d5546d70@postgrespro.ru> Message-ID: <338a18ad-344a-8e79-a950-45a41b4b2a33@postgrespro.ru> Date: Thu, 29 Nov 2018 21:29:15 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: <6d51c9bb-ccc6-92fd-b6ac-05f0d5546d70@postgrespro.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Oh, one more thing: I see a warning without --enable-cassert in create_resultscan_plan, because rte is only used in an Assert. src/backend/optimizer/plan/createplan.c:3457:17: warning: variable ‘rte’ set but not used [-Wunused-but-set-variable]   RangeTblEntry *rte; -- Alexander Kuzmenkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company