Skip to content
Snippets Groups Projects
user avatar
Mary Feofanova authored
New option "exclude_null=true/false" was introduced.
"is_nullable=true" option will be set automatically.
When it is on, index skips tuples with "null" value of this part.
E.g. index `s:create_index('sk', {parts={{2, 'number', exclude_null=true}}})`
will ignore `{1, null}, {2, null}`, but will not ignore `{null, 1}, {1, 1}`.

Part of #4480

@TarantoolBot document
Title: new option "exclude_null=true/false"
Added new option for index part definition,
that allows index to skip tuples with null at this part.
By default the option is turned off.
When turned on, "is_nullable=true" option will be set automatically.
It can't be turned on for the primary key.
Option can be changed dynamically (in this case index is rebuilt).
Such index does not store filtered tuples at all,
so indexing can be done faster.
SQL: such index is skipped in select statements
unless explicitly specified.

`exclude_null` and `is_nullable` are connected, so
this table describes the result of combining them.

| Exclude NULL/Nullable | False | True |
| ----------------------- | ---------- | -------------- |
| False     |  +     | +      |
| True       | - *   |  + **     |

* is not allowed
** Partial index
17c9c034
History

Tarantool

Build Status Build Status Code Coverage Telegram Slack Gitter Google Groups

https://tarantool.io/en/

Patch submissions and discussion of particular patches https://lists.tarantool.org/mailman/listinfo/tarantool-patches/

General development discussions https://lists.tarantool.org/mailman/listinfo/tarantool-discussions/

Tarantool is an in-memory database and application server.

Key features of the application server:

  • 100% compatible drop-in replacement for Lua 5.1, based on LuaJIT 2.1. Simply use #!/usr/bin/tarantool instead of #!/usr/bin/lua in your script.
  • full support for Lua modules and a rich set of own modules, including cooperative multitasking, non-blocking I/O, access to external databases, etc

Key features of the database:

  • ANSI SQL, including views, joins, referential and check constraints
  • MsgPack data format and MsgPack based client-server protocol
  • two data engines: 100% in-memory with optional persistence and an own implementation of LSM-tree, to use with large data sets
  • multiple index types: HASH, TREE, RTREE, BITSET
  • asynchronous master-master replication
  • authentication and access control
  • the database is just a C extension to the application server and can be turned off

Supported platforms are Linux/x86, FreeBSD/x86 and OpenBSD/x86, Mac OS X.

Tarantool is ideal for data-enriched components of scalable Web architecture: queue servers, caches, stateful Web applications.

To download and install Tarantool as a binary package for your OS, please visit https://tarantool.io/en/download/.

To build Tarantool from source, see detailed instructions in the Tarantool documentation at https://tarantool.io/en/doc/2.1/dev_guide/building_from_source/.

Please report bugs at https://github.com/tarantool/tarantool/issues We also warmly welcome your feedback in the discussion mailing list, tarantool@googlegroups.com.

Thank you for your interest in Tarantool!