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 036CA6EC40; Mon, 9 Aug 2021 10:18:55 +0300 (MSK) DKIM-Filter: OpenDKIM Filter v2.11.0 dev.tarantool.org 036CA6EC40 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=tarantool.org; s=dev; t=1628493535; bh=bq4ORW5wARpy5nPxtc3K65UUwnB0zjx8+SUJeN/8BO4=; h=To:Cc:Date:Subject:List-Id:List-Unsubscribe:List-Archive: List-Post:List-Help:List-Subscribe:From:Reply-To:From; b=dEOxEaM6fyi/RK0uc4Gtoxsu2GRJQkDWsOIqWfqIbezky3nuDdgnjyCBLk9wBJxz8 jOZmQXhodlAKeyDPvY4BLg+kMeB1WmVSmstjH+cCI5QmkN0r4+UEJdZfwc3sK/+l28 sKR8fD1r4lcq24VfrL5yfr/el00qRIq38hiFZVPc= Received: from smtp41.i.mail.ru (smtp41.i.mail.ru [94.100.177.101]) (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 DA2976EC40 for ; Mon, 9 Aug 2021 10:18:53 +0300 (MSK) DKIM-Filter: OpenDKIM Filter v2.11.0 dev.tarantool.org DA2976EC40 Received: by smtp41.i.mail.ru with esmtpa (envelope-from ) id 1mCzYi-0001yd-US; Mon, 09 Aug 2021 10:18:53 +0300 To: kyukhin@tarantool.org Cc: tarantool-patches@dev.tarantool.org Date: Mon, 9 Aug 2021 10:18:52 +0300 Message-Id: X-Mailer: git-send-email 2.25.1 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-7564579A: B8F34718100C35BD X-77F55803: 4F1203BC0FB41BD92087353F0EC44DD9ECFD080E047A606F6525B29142351271182A05F538085040F8DFA34415CDE0CC6E27C23C68629F411CE121D42B99DDC080E7B32E611A336A X-7FA49CB5: FF5795518A3D127A4AD6D5ED66289B5278DA827A17800CE788AD3E9728F968ABEA1F7E6F0F101C67BD4B6F7A4D31EC0BCC500DACC3FED6E28638F802B75D45FF8AA50765F790063770F3384661E7DC4D8638F802B75D45FF36EB9D2243A4F8B5A6FCA7DBDB1FC311F39EFFDF887939037866D6147AF826D8F46D6A3C61303489509FF125BEF4789E117882F4460429724CE54428C33FAD305F5C1EE8F4F765FCAA867293B0326636D2E47CDBA5A96583BD4B6F7A4D31EC0BC014FD901B82EE079FA2833FD35BB23D27C277FBC8AE2E8BAA867293B0326636D2E47CDBA5A96583BA9C0B312567BB2376E601842F6C81A19E625A9149C048EE902A1BE408319B290CB8D3112395442FD8FC6C240DEA7642DBF02ECDB25306B2B78CF848AE20165D0A6AB1C7CE11FEE31DAA61796BF5227BC0837EA9F3D19764C4224003CC836476EA7A3FFF5B025636E2021AF6380DFAD1A18204E546F3947CB11811A4A51E3B096D1867E19FE1407959CC434672EE6371089D37D7C0E48F6C8AA50765F7900637AF8E4F18C523FAA9EFF80C71ABB335746BA297DBC24807EABDAD6C7F3747799A X-B7AD71C0: AC4F5C86D027EB782CDD5689AFBDA7A213B5FB47DCBC3458834459D11680B505D8E9F0B02E82798D8C54A9C0FDD0FE9C X-C1DE0DAB: C20DE7B7AB408E4181F030C43753B8186998911F362727C414F749A5E30D975C72045CD04223AD1585B59D62FB60559F3FDEAF9A9C77A3E39C2B6934AE262D3EE7EAB7254005DCED556CBE7F905700A49510FB958DCE06DB6ED91DBE5ABE359A48600B0EAD68145BB129A6C9085D3B6193EDB24507CE13387DFF0A840B692CF8 X-C8649E89: 4E36BF7865823D7055A7F0CF078B5EC49A30900B95165D3419891600CCEF46079527AD11963AD35650C62BD870F74593A020E97072838DE016DAB6EA1057CAF11D7E09C32AA3244C7855BE0C3B680573C75BAD48C8E7FACFFE8DA44ABE2443F7729B2BEF169E0186 X-D57D3AED: 3ZO7eAau8CL7WIMRKs4sN3D3tLDjz0dLbV79QFUyzQ2Ujvy7cMT6pYYqY16iZVKkSc3dCLJ7zSJH7+u4VD18S7Vl4ZUrpaVfd2+vE6kuoey4m4VkSEu530nj6fImhcD4MUrOEAnl0W826KZ9Q+tr5ycPtXkTV4k65bRjmOUUP8cvGozZ33TWg5HZplvhhXbhDGzqmQDTd6OAevLeAnq3Ra9uf7zvY2zzsIhlcp/Y7m53TZgf2aB4JOg4gkr2biojMTMPlNJj3ShJUo/bPPLOiQ== X-Mailru-Sender: 5C3750E245F362008BC1685FEC6306ED9338F81FC19D05426E27C23C68629F41E5E949923882BAAD5105BD0848736F9966FEC6BF5C9C28D97E07721503EA2E00ED97202A5A4E92BF7402F9BA4338D657ED14614B50AE0675 X-Mras: Ok Subject: [Tarantool-patches] [PATCH v2 0/6] Remove SQL built-in functions from _func 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: Mergen Imeev via Tarantool-patches Reply-To: imeevma@tarantool.org Errors-To: tarantool-patches-bounces@dev.tarantool.org Sender: "Tarantool-patches" This patch-set removes SQL built-in functions from _func and prohibits functions with SQL_BUILTIN language to be decribed in _func system space. https://github.com/tarantool/tarantool/issues/6106 https://github.com/tarantool/tarantool/tree/imeevma/gh-6106-remove-sql-builtins-from-_func Changes in v2: - Added some functions that simplifies work with SQL built-in functions. - Removed some code that become unused due to removal of SQL built-in functions from _func. - Prohibited to insert tuples with "language" = 'SQL_BUILTIN' to _func. Mergen Imeev (5): sql: introduce sql_func_flags() sql: introduce sql_func_find() sql: remove SQL built-in functions from _func alter: disallow creation of SQL built-in function sql: remove unnecessary function initialization Vladislav Shpilevoy (1): alter: parse data dictionary version ...gh-6106-remove-sql-built-ins-from-_func.md | 7 + src/box/alter.cc | 63 +++++- src/box/bootstrap.snap | Bin 6016 -> 4891 bytes src/box/box.cc | 1 + src/box/func.c | 7 - src/box/func_def.c | 8 - src/box/lua/upgrade.lua | 16 +- src/box/schema.cc | 3 + src/box/schema.h | 1 + src/box/sql.c | 1 + src/box/sql.h | 9 + src/box/sql/analyze.c | 12 ++ src/box/sql/expr.c | 23 +-- src/box/sql/func.c | 189 +++++++++++++----- src/box/sql/resolve.c | 22 +- src/box/sql/sqlInt.h | 20 +- src/box/sql/vdbemem.c | 2 +- test/box-py/bootstrap.result | 66 ------ test/box/access_bin.result | 4 +- test/box/access_bin.test.lua | 4 +- test/box/access_sysview.result | 8 +- test/box/function1.result | 39 ++-- test/box/function1.test.lua | 16 +- test/sql-tap/func5.test.lua | 57 +++++- test/wal_off/func_max.result | 8 +- 25 files changed, 338 insertions(+), 248 deletions(-) create mode 100644 changelogs/unreleased/gh-6106-remove-sql-built-ins-from-_func.md -- 2.25.1