Create composite index with non jsonb (like varchar) and jsonb

[akshath]

Hi Team,

I am trying to create a composite index with non-jsonb (like varchar) and jsonb and I am getting error.

I tried the following variations. Is this supported? I am using latest version of cockroach 2.0.2. Thank you.

CREATE INDEX ON table_a (a, b DESC, c->>'d');
CREATE INDEX ON table_a (a, b DESC, (c->>'d'));

[jordanlewis]

Hi @akshath,

We don't support indexes with computed expressions at the moment. To make this work, you'll need to make a computed column on c->>'d' and put the index on that.

[akshath]

Thanks, Jordan for the quick reply. Hope to see this supported in a future release.

[knz]

This is a duplicate of #9682. We'll support this eventually.