From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7328C2C7D4 for ; Thu, 25 Apr 2019 06:37:19 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id NCG1i5dD2k2J for ; Thu, 25 Apr 2019 06:37:19 -0400 (EDT) Received: from smtp56.i.mail.ru (smtp56.i.mail.ru [217.69.128.36]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 32BDA2C7D3 for ; Thu, 25 Apr 2019 06:37:19 -0400 (EDT) Date: Thu, 25 Apr 2019 13:37:16 +0300 From: Kirill Yukhin Subject: [tarantool-patches] Re: [PATCH v1 1/1] sql: invalid integer type in arithmetic operations Message-ID: <20190425103716.6rd5kd4hfd2gd4ry@tarantool.org> References: <72941eba60647c98f4559cbd0c862bade990d761.1556120090.git.kshcherbatov@tarantool.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <72941eba60647c98f4559cbd0c862bade990d761.1556120090.git.kshcherbatov@tarantool.org> Sender: tarantool-patches-bounce@freelists.org Errors-to: tarantool-patches-bounce@freelists.org Reply-To: tarantool-patches@freelists.org List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: tarantool-patches List-Subscribe: List-Owner: List-post: List-Archive: To: tarantool-patches@freelists.org Cc: korablev@tarantool.org, Kirill Shcherbatov Hello, On 24 Apr 18:36, Kirill Shcherbatov wrote: > Tarantool SQL used to return 'number' type in request metadata > for arithmetic operations even when only 'integer's were used. > > This also fixes query planner optimisation bug: > SELECT a FROM t1 WHERE a+0 IN (SELECT a FROM t1); > used to open a new ephemeral table with OpenTEphemeral when > it is not required (introduced by 2b22b913). > > Closes #4103 > --- > Branch: http://github.com/tarantool/tarantool/tree/kshch/gh-4103-invalid-type-in-operations > Issue: https://github.com/tarantool/tarantool/issues/4103 I've checked your patch into master. -- Regards, Kirill Yukhin