Impossible to set list element to null using scylla_timeuuid_index

[haaawk]

Having the following table:

create table tb(
pk int,
ck int,
v list<int>,
primary key(pk, ck)
}

It is ok to run

update tb set v[1]=null where pk = 1 and ck = 1

but running

update tb set v[scylla_timeuuid_list_index(4bec89c0-c52b-11ea-92db-000000000000)] = null where pk = 1 and ck = 2

causes

ServerError: std::get: wrong index for variant

On the same time, running

update tb set v[scylla_timeuuid_list_index(4bec89c0-c52b-11ea-92db-000000000000)] = 3 where pk = 1 and ck = 2

works just fine.

[avikivity]

@haaawk what about DELETE v[scylla_timeuuid_list_index(...)] FROM tb?

[haaawk]

Haven't tried. Will check it out and let you know.

[haaawk]

> DELETE v[scylla_timeuuid_list_index(4bec89c0-c52b-11ea-92db-000000000000)] FROM tb ;
SyntaxException: line 1:9 no viable alternative at input 'scylla_timeuuid_list_index'

but that's sort of expected. I think the grammar was changed only for SET to support scylla_timeuuid_list_index.

[avikivity]

We could (should?) support it.

[elcallio]

It looks like a regression. Trying to do the same as above and run it though sstableloader hits the same error.

[avikivity]

Backported to 4.0, 4.1, 4.2.