From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from smtp37.i.mail.ru (smtp37.i.mail.ru [94.100.177.97]) (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 64BDF4696C3 for ; Sun, 12 Apr 2020 19:29:56 +0300 (MSK) From: imeevma@tarantool.org Date: Sun, 12 Apr 2020 19:29:54 +0300 Message-Id: Subject: [Tarantool-patches] [PATCH v2 0/2] sql: fix order of inserted rows List-Id: Tarantool development patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , To: korablev@tarantool.org, v.shpilevoy@tarantool.org, tsafin@tarantool.org, tarantool-patches@dev.tarantool.org This patch-set fixes order of inserted rows in case ephemeral space is used. The order now is the same in which these values were inserted originally. Wrong order could lead to an error in case AUTOINCREMENT feature was used. https://github.com/tarantool/tarantool/issues/4256 https://github.com/tarantool/tarantool/tree/imeevma/gh-4256-fix-order-during-insertion #ChangeLog - The inserted values will now always be inserted in the order in which they were given (gh-4256). Mergen Imeev (2): sql: specify field types in ephemeral space format sql: do not change order of inserted values src/box/space_def.c | 5 +- src/box/space_def.h | 3 +- src/box/sql.c | 68 ++++++++++++++++------ src/box/sql/insert.c | 19 +++++- src/box/sql/select.c | 2 + src/box/sql/sqlInt.h | 2 + src/box/sql/vdbe.c | 19 +----- src/box/tuple_format.c | 22 ++++--- ...256-do-not-change-order-during-insertion.result | 50 ++++++++++++++++ ...6-do-not-change-order-during-insertion.test.lua | 15 +++++ 10 files changed, 153 insertions(+), 52 deletions(-) create mode 100644 test/sql/gh-4256-do-not-change-order-during-insertion.result create mode 100644 test/sql/gh-4256-do-not-change-order-during-insertion.test.lua -- 2.7.4