From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from smtp51.i.mail.ru (smtp51.i.mail.ru [94.100.177.111]) (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 0DC90469710 for ; Thu, 28 May 2020 17:17:26 +0300 (MSK) From: Mergen Imeev Date: Thu, 28 May 2020 17:17:25 +0300 Message-Id: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Subject: [Tarantool-patches] [PATCH 0/6] Remove implicit cast List-Id: Tarantool development patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , To: v.shpilevoy@tarantool.org, tsafin@tarantool.org, tarantool-patches@dev.tarantool.org This patch-set removes implicit cast between string and numbers for assignment and for comparison. https://github.com/tarantool/tarantool/issues/3809 https://github.com/tarantool/tarantool/issues/4230 https://github.com/tarantool/tarantool/tree/imeevma/gh-3809-disallow-imlicit-cast-from-string-to-nums Mergen Imeev (6): sql: remove implicit cast for assignment sql: remove mem_apply_type() from OP_MakeRecord sql: replace ApplyType by CheckType for IN operator sql: remove mem_apply_type() from OP_MustBeInt sql: remove implicit cast from string for comparison sql: remove OP_ApplyType src/box/sql/analyze.c | 7 +- src/box/sql/delete.c | 8 +- src/box/sql/expr.c | 40 +- src/box/sql/fk_constraint.c | 9 +- src/box/sql/insert.c | 2 +- src/box/sql/select.c | 25 +- src/box/sql/sqlInt.h | 13 - src/box/sql/update.c | 14 +- src/box/sql/vdbe.c | 222 ++++-- src/box/sql/wherecode.c | 205 +----- test/sql-tap/autoinc.test.lua | 4 +- test/sql-tap/default.test.lua | 6 +- test/sql-tap/e_select1.test.lua | 27 +- .../gh-3809-implicit-cast-assignment.test.lua | 633 ++++++++++++++++++ .../gh-4230-del-impl-cast-str-to-num.test.lua | 78 +++ test/sql-tap/identifier_case.test.lua | 6 +- test/sql-tap/in1.test.lua | 4 +- test/sql-tap/in3.test.lua | 18 +- test/sql-tap/in4.test.lua | 100 +-- test/sql-tap/index1.test.lua | 24 +- test/sql-tap/insert3.test.lua | 12 +- test/sql-tap/intpkey.test.lua | 37 +- test/sql-tap/join.test.lua | 8 +- test/sql-tap/limit.test.lua | 2 +- test/sql-tap/minmax2.test.lua | 6 +- test/sql-tap/misc1.test.lua | 66 +- test/sql-tap/numcast.test.lua | 4 +- test/sql-tap/select1.test.lua | 12 +- test/sql-tap/select4.test.lua | 12 +- test/sql-tap/select7.test.lua | 4 +- test/sql-tap/sort.test.lua | 8 +- test/sql-tap/subquery.test.lua | 73 +- test/sql-tap/tkt-3998683a16.test.lua | 36 +- test/sql-tap/tkt-54844eea3f.test.lua | 8 +- test/sql-tap/tkt-7bbfb7d442.test.lua | 4 +- test/sql-tap/tkt-80e031a00f.test.lua | 4 +- test/sql-tap/tkt-9a8b09f8e6.test.lua | 88 +-- test/sql-tap/tkt-f973c7ac31.test.lua | 32 +- test/sql-tap/tkt-fc7bd6358f.test.lua | 8 +- test/sql-tap/tkt1444.test.lua | 4 +- test/sql-tap/tkt3493.test.lua | 46 +- test/sql-tap/tkt3841.test.lua | 12 +- test/sql-tap/transitive1.test.lua | 16 +- test/sql-tap/triggerA.test.lua | 4 +- test/sql-tap/unique.test.lua | 8 +- test/sql-tap/view.test.lua | 2 +- test/sql-tap/where2.test.lua | 183 +---- test/sql-tap/where5.test.lua | 22 +- test/sql-tap/whereB.test.lua | 254 +++---- test/sql-tap/whereC.test.lua | 8 +- test/sql/boolean.result | 14 +- test/sql/persistency.result | 2 +- test/sql/types.result | 37 +- test/sql/types.test.lua | 1 - 54 files changed, 1316 insertions(+), 1166 deletions(-) create mode 100755 test/sql-tap/gh-3809-implicit-cast-assignment.test.lua create mode 100755 test/sql-tap/gh-4230-del-impl-cast-str-to-num.test.lua -- 2.25.1