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 AED87253B7 for ; Thu, 7 Feb 2019 03:54:00 -0500 (EST) 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 xzbI5Z93zPO0 for ; Thu, 7 Feb 2019 03:54:00 -0500 (EST) Received: from smtp47.i.mail.ru (smtp47.i.mail.ru [94.100.177.107]) (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 EEF2325389 for ; Thu, 7 Feb 2019 03:53:59 -0500 (EST) Date: Thu, 7 Feb 2019 11:53:57 +0300 From: Kirill Yukhin Subject: [tarantool-patches] Re: [PATCH v2] sql: prohibit negative values under LIMIT clause Message-ID: <20190207085357.z33fbniyn5sk4bj5@tarantool.org> References: <20190205085636.19053-1-szudin@tarantool.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20190205085636.19053-1-szudin@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, Stanislav Zudin Hello, On 05 Feb 11:56, Stanislav Zudin wrote: > If LIMIT or OFFSET expressions can be casted to the > negative integer value VDBE returns an error. > If expression in the LIMIT clause can't be converted > into integer without data loss the VDBE instead of > SQLITE_MISMATCH returns SQL_TARANTOOL_ERROR with > message "Only positive numbers are allowed in the > LIMIT clause". The same for OFFSET clause. > > Closes #3467 > --- > Branch: https://github.com/tarantool/tarantool/tree/stanztt/gh-3467-prohibit-negative-limits > Issue: https://github.com/tarantool/tarantool/issues/3467 I've checked your patch into 2.1 branch. -- Regards, Kirill Yukhin