From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from [87.239.111.99] (localhost [127.0.0.1]) by dev.tarantool.org (Postfix) with ESMTP id 19E046EC55; Sat, 31 Jul 2021 09:30:42 +0300 (MSK) DKIM-Filter: OpenDKIM Filter v2.11.0 dev.tarantool.org 19E046EC55 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=tarantool.org; s=dev; t=1627713042; bh=Ru/Sl/ao7gKBtFLNe3VRLKGucvpeF0C8ay8+Vxli328=; h=To:Cc:References:Date:In-Reply-To:Subject:List-Id: List-Unsubscribe:List-Archive:List-Post:List-Help:List-Subscribe: From:Reply-To:From; b=HUP2gb4cUo2iGTJkRld4/Q/jct0F+PqJoLIa4m6d970VgzZX/TxVcsZd47DvBcFSQ 46AFk4tP+JKg0JSrb9b30wXH8rGKAvNYWUdaMghfmZJoH/B84iMCRnD4gtD4DJEqtc 3fYroFTh8WwLnjcUsel4reolkpirnJruVSoM4uoY= Received: from smtp43.i.mail.ru (smtp43.i.mail.ru [94.100.177.103]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by dev.tarantool.org (Postfix) with ESMTPS id 393A66EC55 for ; Sat, 31 Jul 2021 09:30:40 +0300 (MSK) DKIM-Filter: OpenDKIM Filter v2.11.0 dev.tarantool.org 393A66EC55 Received: by smtp43.i.mail.ru with esmtpa (envelope-from ) id 1m9iW7-0007NF-Gn; Sat, 31 Jul 2021 09:30:39 +0300 To: Timur Safin , v.shpilevoy@tarantool.org Cc: tarantool-patches@dev.tarantool.org References: <2939f293071df83ba612c431895adea49c9cb8de.1627468002.git.tsafin@tarantool.org> <1f485144-efa1-3b19-c283-380908f4975c@tarantool.org> <044f01d78590$dd7053b0$9850fb10$@tarantool.org> Message-ID: <4c5ec0cf-960e-1c30-5ed3-76925b7babf9@tarantool.org> Date: Sat, 31 Jul 2021 09:30:39 +0300 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.12.0 MIME-Version: 1.0 In-Reply-To: <044f01d78590$dd7053b0$9850fb10$@tarantool.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-GB X-7564579A: 646B95376F6C166E X-77F55803: 4F1203BC0FB41BD941C43E597735A9C33D83595CA30D6DC5179D1C9A908C47E5182A05F538085040DDBCA79F69CDFF1C211B5FD962D6B998BD71A2125BB7C06A79EC2B4F8C69574F X-7FA49CB5: FF5795518A3D127A4AD6D5ED66289B5278DA827A17800CE70D278D70F8433719EA1F7E6F0F101C67BD4B6F7A4D31EC0BCC500DACC3FED6E28638F802B75D45FF8AA50765F790063727599E9BE65898D58638F802B75D45FF36EB9D2243A4F8B5A6FCA7DBDB1FC311F39EFFDF887939037866D6147AF826D8A7D5EBC4AD09605BDA5DD105AB35D097117882F4460429724CE54428C33FAD305F5C1EE8F4F765FCF1175FABE1C0F9B6A471835C12D1D9774AD6D5ED66289B52BA9C0B312567BB23117882F446042972877693876707352033AC447995A7AD18CB629EEF1311BF91D2E47CDBA5A96583BA9C0B312567BB2376E601842F6C81A19E625A9149C048EE4B6963042765DA4B043FB282AF95FB6BD8FC6C240DEA7642DBF02ECDB25306B2B78CF848AE20165D0A6AB1C7CE11FEE3A7DFDF579AB090EF9735652A29929C6CC4224003CC836476EA7A3FFF5B025636E2021AF6380DFAD1A18204E546F3947CB11811A4A51E3B096D1867E19FE1407959CC434672EE6371089D37D7C0E48F6C8AA50765F7900637A8A59EE88DA1D479EFF80C71ABB335746BA297DBC24807EABDAD6C7F3747799A X-B7AD71C0: AC4F5C86D027EB782CDD5689AFBDA7A213B5FB47DCBC3458834459D11680B505C794FDD28044253BAD349FA82B1FA390 X-C1DE0DAB: 0D63561A33F958A5CC2B3D5D85EA08C68EBE8E4BCB915234576022F87A4284E0D59269BC5F550898D99A6476B3ADF6B47008B74DF8BB9EF7333BD3B22AA88B938A852937E12ACA751B940EDA0DFB0535410CA545F18667F91A7EA1CDA0B5A7A0 X-C8649E89: 4E36BF7865823D7055A7F0CF078B5EC49A30900B95165D348BE83DFD8AFB1CAC00605B4FC922178CE3D99893BF5A74701A26FB0C9AE829C25621BDDB4C55E0D11D7E09C32AA3244C984638E22D720824FA72B4D1139BB6AA4DBEAD0ED6C55A80FACE5A9C96DEB163 X-D57D3AED: 3ZO7eAau8CL7WIMRKs4sN3D3tLDjz0dLbV79QFUyzQ2Ujvy7cMT6pYYqY16iZVKkSc3dCLJ7zSJH7+u4VD18S7Vl4ZUrpaVfd2+vE6kuoey4m4VkSEu530nj6fImhcD4MUrOEAnl0W826KZ9Q+tr5ycPtXkTV4k65bRjmOUUP8cvGozZ33TWg5HZplvhhXbhDGzqmQDTd6OAevLeAnq3Ra9uf7zvY2zzsIhlcp/Y7m53TZgf2aB4JOg4gkr2biojNLQ8Cqcv1ivDN7GPNBWXnA== X-Mailru-Sender: 583F1D7ACE8F49BD1042885CEC987B6B84261129C2D5E81F211B5FD962D6B9985F9045B74F665CC87019711D9D5B048E1458020726E2BC9FD5ECBA0B92C0A936CDC7563AA7CEBD287402F9BA4338D657ED14614B50AE0675 X-Mras: Ok Subject: Re: [Tarantool-patches] [PATCH resend v2 06/11] box, datetime: datetime comparison for indices X-BeenThere: tarantool-patches@dev.tarantool.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: Tarantool development patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , From: Oleg Babin via Tarantool-patches Reply-To: Oleg Babin Errors-To: tarantool-patches-bounces@dev.tarantool.org Sender: "Tarantool-patches" Thanks for your reply. See my answer below. On 31.07.2021 01:18, Timur Safin wrote: > Hello Oleg, > > > : From: Oleg Babin > : Subject: Re: [Tarantool-patches] [PATCH resend v2 06/11] box, datetime: > : datetime comparison for indices > : > : Thanks for your patch. One question below. > : > : > : Also update with arithmetic operations doesn't work. > : > : > : ``` > : > : tarantool> box.space.dt:update({v}, {{'+', 2, 3}}) > : --- > : - error: 'Argument type in operation ''+'' on field 2 does not match > : field type: expected > : a number' > : ... > : > : tarantool> box.space.dt:update({v}, {{'+', 2, dt.week(1)}}) > : --- > : - error: unsupported Lua type 'cdata' > : ... > : > : ``` > > Oh, shit, I didn't take those operations into considerations. > Do they work similarly with decimal? Looks like so. Moreover it seems we should support intervals as separate type. Currently the single way to update is get + sum + put/update (with =). But I suppose native update will be needed anyway. At lest for SQL. Will be it able to perform some operations with intervals and timestamps?