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 98D6C27207 for ; Thu, 21 Feb 2019 08:00:41 -0500 (EST) 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 lIFyCR4KeEad for ; Thu, 21 Feb 2019 08:00:41 -0500 (EST) Received: from smtp48.i.mail.ru (smtp48.i.mail.ru [94.100.177.108]) (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 535A927200 for ; Thu, 21 Feb 2019 08:00:41 -0500 (EST) From: imeevma@tarantool.org Subject: [tarantool-patches] [PATCH v6 0/7] sql: set column types for EXPLAIN and PRAGMA Date: Thu, 21 Feb 2019 16:00:39 +0300 Message-Id: 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: v.shpilevoy@tarantool.org Cc: tarantool-patches@freelists.org This patch-set defines the types for the result columns of EXPLAIN and PRAGMA commands. In addition, it fixes some problems of the PRAGMA commands that have something to do with their result. https://github.com/tarantool/tarantool/issues/3832 https://github.com/tarantool/tarantool/tree/imeevma/gh-3832-no-column-types Changes in sixth version: - Rebase to current 2.1 - New patch that removes gh-3733-pragma.test.lua - Other small fixes. https://www.freelists.org/post/tarantool-patches/PATCH-v1-11-sql-set-column-types-for-EXPLAIN-and-PRAGMA https://www.freelists.org/post/tarantool-patches/PATCH-v2-06-sql-set-column-types-for-EXPLAIN-and-PRAGMA https://www.freelists.org/post/tarantool-patches/PATCH-v3-06-sql-set-column-types-for-EXPLAIN-and-PRAGMA https://www.freelists.org/post/tarantool-patches/PATCH-v4-06-sql-set-column-types-for-EXPLAIN-and-PRAGMA https://www.freelists.org/post/tarantool-patches/PATCH-v5-06-sql-set-column-types-for-EXPLAIN-and-PRAGMA Mergen Imeev (7): sql: remove unused macros from pragma.c and pragma.h sql: fix "PRAGMA parser_trace" result sql: Show currently set sql_default_engine sql: fix "PRAGMA case_sensitive_like" result sql: get results of PRAGMA statement as result set sql: set column types for EXPLAIN and PRAGMA sql: remove test gh-3733-pragma.test.lua src/box/execute.c | 5 +- src/box/sql/CMakeLists.txt | 2 - src/box/sql/parse.y | 6 +- src/box/sql/pragma.c | 193 +++++++++--------------- src/box/sql/pragma.h | 238 ++++++++++++++++++------------ src/box/sql/prepare.c | 53 +++++-- src/box/sql/printf.c | 2 +- src/box/sql/select.c | 22 +-- src/box/sql/sqlInt.h | 22 +-- src/box/sql/where.c | 46 +++--- src/box/sql/whereInt.h | 4 +- test/sql-tap/gh-2367-pragma.test.lua | 65 -------- test/sql-tap/gh-3733-pragma.test.lua | 177 ---------------------- test/sql-tap/pragma.test.lua | 278 +++++++++++++++++++++++++++++++++++ test/sql/engine.cfg | 3 + test/sql/iproto.result | 69 +++++++++ test/sql/iproto.test.lua | 18 ++- test/sql/sql-debug.result | 45 ++++++ test/sql/sql-debug.test.lua | 17 +++ test/sql/suite.ini | 2 +- 20 files changed, 731 insertions(+), 536 deletions(-) delete mode 100755 test/sql-tap/gh-2367-pragma.test.lua delete mode 100755 test/sql-tap/gh-3733-pragma.test.lua create mode 100755 test/sql-tap/pragma.test.lua create mode 100644 test/sql/sql-debug.result create mode 100644 test/sql/sql-debug.test.lua -- 2.7.4