Hello, I try to define compound index with some field and _key: create index idx_desc on mytable (somecolumn asc, _key desc); create index idx_asc on mytable (somecolumn asc, _key asc);
Error: Column doesn't exist: _KEY (state=42000,code=3008) Is this bug? Because I see _key column in sqlline by using !primarykeys. I know that I can add new field to value object which contains _key value. But this is duplication of _key. Is that the only way for achieve what I would like? Thank you.