Tarantool development patches archive
 help / color / mirror / Atom feed
From: Nikita Pettik <korablev@tarantool.org>
To: tarantool-patches@dev.tarantool.org
Cc: v.shpilevoy@tarantool.org
Subject: [Tarantool-patches] [PATCH v2 0/6] sql: extended metadata
Date: Wed, 11 Dec 2019 16:44:52 +0300	[thread overview]
Message-ID: <cover.1576022424.git.korablev@tarantool.org> (raw)

Branch: https://github.com/tarantool/tarantool/commits/np/gh-4407-extend-sql-metadata
Issue: https://github.com/tarantool/tarantool/issues/4407
v1: https://lists.tarantool.org/pipermail/tarantool-patches/2019-November/012680.html

Changes in v2:
 - introduced pragma full_metadata which allows to turn
   extended metadata on/off. By default only basic
   metadata is send; it allows to avoid massive tests
   refactoring and avoid network overhead for users who don't
   need extended metadata.
 - now alias is always displayed in extended meta: if there's no
   AS clause, then alias is the same as name.
 - moved tests verifing presence of additional metadata to
   separate file.
 - provided test and explanation for second patch
   (sql: fix possible null dereference in sql_expr_coll()).
 - provided doc bot request.

Nikita Pettik (6):
  sql: refactor resulting set metadata
  sql: fix possible null dereference in sql_expr_coll()
  sql: extend result set with collation
  sql: extend result set with nullability
  sql: extend result set with autoincrement
  sql: extend result set with alias

 src/box/execute.c               |  65 +++++++++++++--
 src/box/iproto_constants.h      |   4 +
 src/box/lua/execute.c           |  24 +++++-
 src/box/lua/net_box.c           |  36 +++++++-
 src/box/sql/delete.c            |   7 +-
 src/box/sql/expr.c              |   3 +-
 src/box/sql/insert.c            |   6 +-
 src/box/sql/legacy.c            |   2 +-
 src/box/sql/pragma.c            |  17 ++--
 src/box/sql/pragma.h            |   8 ++
 src/box/sql/prepare.c           |  10 +--
 src/box/sql/select.c            | 131 +++++++++++++++++++++---------
 src/box/sql/sqlInt.h            |  16 ++++
 src/box/sql/update.c            |   7 +-
 src/box/sql/vdbe.h              |  41 +++++++---
 src/box/sql/vdbeInt.h           |  17 +++-
 src/box/sql/vdbeapi.c           | 103 +++++++++--------------
 src/box/sql/vdbeaux.c           | 126 +++++++++++++++++++---------
 test/sql/collation.result       |   9 ++
 test/sql/collation.test.lua     |   5 ++
 test/sql/engine.cfg             |   4 +
 test/sql/full_metadata.result   | 176 ++++++++++++++++++++++++++++++++++++++++
 test/sql/full_metadata.test.lua |  55 +++++++++++++
 test/sql/sql-debug.result       |   1 +
 24 files changed, 683 insertions(+), 190 deletions(-)
 create mode 100644 test/sql/full_metadata.result
 create mode 100644 test/sql/full_metadata.test.lua

-- 
2.15.1

             reply	other threads:[~2019-12-11 13:45 UTC|newest]

Thread overview: 25+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2019-12-11 13:44 Nikita Pettik [this message]
     [not found] ` <cover.1576071711.git.korablev@tarantool.org>
2019-12-11 13:44   ` [Tarantool-patches] [PATCH v2 1/6] sql: refactor resulting set metadata Nikita Pettik
2019-12-11 13:44   ` [Tarantool-patches] [PATCH v2 2/6] sql: fix possible null dereference in sql_expr_coll() Nikita Pettik
2019-12-11 13:44   ` [Tarantool-patches] [PATCH v2 3/6] sql: extend result set with collation Nikita Pettik
2019-12-18  0:29     ` Vladislav Shpilevoy
2019-12-24  0:26       ` Nikita Pettik
2019-12-24 15:30         ` Vladislav Shpilevoy
2019-12-11 13:44   ` [Tarantool-patches] [PATCH v2 4/6] sql: extend result set with nullability Nikita Pettik
2019-12-18  0:29     ` Vladislav Shpilevoy
2019-12-24  0:26       ` Nikita Pettik
2019-12-11 13:44   ` [Tarantool-patches] [PATCH v2 5/6] sql: extend result set with autoincrement Nikita Pettik
2019-12-18  0:29     ` Vladislav Shpilevoy
2019-12-24  0:26       ` Nikita Pettik
2019-12-24 15:30         ` Vladislav Shpilevoy
2019-12-25 12:17           ` Nikita Pettik
2019-12-25 15:40             ` Vladislav Shpilevoy
2019-12-25 23:18               ` Nikita Pettik
2019-12-11 13:44   ` [Tarantool-patches] [PATCH v2 6/6] sql: extend result set with alias Nikita Pettik
2019-12-18  0:29     ` Vladislav Shpilevoy
2019-12-24  0:26       ` Nikita Pettik
2019-12-24 15:34         ` Vladislav Shpilevoy
2019-12-26 11:24           ` Nikita Pettik
2019-12-27 11:53             ` Vladislav Shpilevoy
2019-12-27 23:44             ` Nikita Pettik
2019-12-28  9:29               ` Vladislav Shpilevoy

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=cover.1576022424.git.korablev@tarantool.org \
    --to=korablev@tarantool.org \
    --cc=tarantool-patches@dev.tarantool.org \
    --cc=v.shpilevoy@tarantool.org \
    --subject='Re: [Tarantool-patches] [PATCH v2 0/6] sql: extended metadata' \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox