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 3931326B77 for ; Wed, 20 Jun 2018 11:55:33 -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 B0rGQHMXRJGI for ; Wed, 20 Jun 2018 11:55:33 -0400 (EDT) Received: from smtpng3.m.smailru.net (smtpng3.m.smailru.net [94.100.177.149]) (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 E1C6B26AA8 for ; Wed, 20 Jun 2018 11:55:32 -0400 (EDT) From: Kirill Shcherbatov Subject: [tarantool-patches] [PATCH v1 2/2] sql: unset pragma in transitive-transactions test Date: Wed, 20 Jun 2018 18:55:27 +0300 Message-Id: <247508fef5484e49ff4be8181078533cac8e0cd3.1529510053.git.kshcherbatov@tarantool.org> In-Reply-To: References: In-Reply-To: References: 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: korablev@tarantool.org, Kirill Shcherbatov Part of #3472. --- test/sql/transitive-transactions.result | 4 ++++ test/sql/transitive-transactions.test.lua | 3 +++ 2 files changed, 7 insertions(+) diff --git a/test/sql/transitive-transactions.result b/test/sql/transitive-transactions.result index 37b563a..272a25a 100644 --- a/test/sql/transitive-transactions.result +++ b/test/sql/transitive-transactions.result @@ -117,6 +117,10 @@ box.space.PARENT:select(); - - [1, 1] - [2, 2] ... +box.sql.execute('PRAGMA defer_foreign_keys = 0;') +box.sql.execute('pragma foreign_keys = 0;'); +--- +... -- Cleanup box.sql.execute('DROP TABLE child;'); --- diff --git a/test/sql/transitive-transactions.test.lua b/test/sql/transitive-transactions.test.lua index 14a1e8c..303ecad 100644 --- a/test/sql/transitive-transactions.test.lua +++ b/test/sql/transitive-transactions.test.lua @@ -60,6 +60,9 @@ fk_defer(); box.space.CHILD:select(); box.space.PARENT:select(); +box.sql.execute('PRAGMA defer_foreign_keys = 0;') +box.sql.execute('pragma foreign_keys = 0;'); + -- Cleanup box.sql.execute('DROP TABLE child;'); box.sql.execute('DROP TABLE parent;'); -- 2.7.4