User Tools

Site Tools


Sidebar

indexes:nulls

Q. I have a tuple with fields containing strings and null's. How can I create an index for it?

I’m trying this:

box.space.tuple:create_index('idx_3', {id=3, type='tree', unique=false, parts={4,'string'}})
---
- error: 'Tuple field 4 type does not match one required by operation: expected string'

(2016)

A. Indexes support nulls. Also, as a workaround, you can replace nulls with empty strings in your tuples.

Comments

Enter your comment. Wiki syntax is allowed:
U L T C​ V
 
indexes/nulls.txt · Last modified: 2018/05/25 19:23 by eabates

Real Time Web Analytics