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 71BBF244D9 for ; Wed, 24 Jul 2019 09:01:16 -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 OEATQaSO_LhX for ; Wed, 24 Jul 2019 09:01:16 -0400 (EDT) Received: from smtp33.i.mail.ru (smtp33.i.mail.ru [94.100.177.93]) (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 B7E90244D5 for ; Wed, 24 Jul 2019 09:01:15 -0400 (EDT) Date: Wed, 24 Jul 2019 16:01:13 +0300 From: Kirill Yukhin Subject: [tarantool-patches] Re: [PATCH 0/6] Introduce UNSIGNED type in SQL Message-ID: <20190724130113.xwbf6q32hifusrvm@tarantool.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: 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: v.shpilevoy@tarantool.org, Nikita Pettik Hello, On 07 Jun 18:37, Nikita Pettik wrote: > Branch: https://github.com/tarantool/tarantool/tree/np/introduce-uint > Issues: > https://github.com/tarantool/tarantool/issues/3810 > https://github.com/tarantool/tarantool/issues/4015 > > Current patch-set allows using UNSIGNED as a column type and operating > on integer values in range up to [2^64 - 1]. This means that result of > all basic routines such as arithmetic operations and built-in functions > is extended to unsigned range. > The basic idea under the hood is separating storing positive and > negative integers into different memory cells. We've added new > type of VDBE memory - MEM_UInt. Now all positive values are stored with > featuring this flag; in turn, negative integers have MEM_Int type. > It's quite similar to MP_* format types. > > For more details see content of patches. > > Nikita Pettik (6): > sql: refactor sql_atoi64() > sql: separate VDBE memory holding positive and negative ints > sql: refactor arithmetic operations to support unsigned ints > sql: make built-in functions operate on unsigned values > sql: introduce extended range for INTEGER type > sql: allow to specify UNSIGNED column type I've checked the patchset into master. -- Regards, Kirill Yukhin