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 C98E9210E4 for ; Wed, 26 Dec 2018 13:17:58 -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 c3d-v9klclA2 for ; Wed, 26 Dec 2018 13:17:58 -0500 (EST) 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 3048B20FC7 for ; Wed, 26 Dec 2018 13:17:58 -0500 (EST) From: imeevma@tarantool.org Subject: [tarantool-patches] [PATCH v3 0/6] sql: set column types for EXPLAIN and PRAGMA Date: Wed, 26 Dec 2018 21:17:55 +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: tarantool-patches@freelists.org, korablev@tarantool.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 third version: - Fixed function/varible/constant names - Fixes commit-messages - Types of two pragmas were changed to FLAG. - Created new test and tests of two pathes were moved into it. v1: https://www.freelists.org/post/tarantool-patches/PATCH-v1-11-sql-set-column-types-for-EXPLAIN-and-PRAGMA v2: https://www.freelists.org/post/tarantool-patches/PATCH-v2-06-sql-set-column-types-for-EXPLAIN-and-PRAGMA Mergen Imeev (6): 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: 'PRAGMA' result in the appropriate format sql: set column types for EXPLAIN and PRAGMA src/box/execute.c | 5 +- src/box/sql/pragma.c | 222 ++++++++++++++---------------- src/box/sql/pragma.h | 258 ++++++++++++++++++++++------------- src/box/sql/prepare.c | 52 +++++-- src/box/sql/sqliteInt.h | 4 + test/sql-tap/gh-2367-pragma.test.lua | 35 +++-- test/sql/iproto.result | 69 ++++++++++ test/sql/iproto.test.lua | 18 ++- test/sql/misc.result | 20 +++ test/sql/misc.test.lua | 13 ++ test/sql/sql-debug.result | 72 ++++++++++ test/sql/sql-debug.test.lua | 25 ++++ test/sql/suite.ini | 2 +- 13 files changed, 557 insertions(+), 238 deletions(-) create mode 100644 test/sql/sql-debug.result create mode 100644 test/sql/sql-debug.test.lua -- 2.7.4