Hello! How is your table defined? _key is just an implicit alias for all of your primary key columns. So you should be listing those.
Regards, -- Ilya Kasnacheev ср, 3 июн. 2020 г. в 13:14, Dmitry Lazurkin <[email protected]>: > 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. > >
