[tarantool-patches] [PATCH v1 2/2] sql: unset pragma in transitive-transactions test

[Kirill Shcherbatov <kshcherbatov@tarantool.org>]

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