Details
Description
The documentation bug shows create meta().id is the only supported index type.
I can however create indexes on cas, flags and expiry - this should be blocked?
cbq> create index meta_3 on default(meta().cas);
|
{
|
"requestID": "47fb488f-6e9a-46a2-8448-e4d2608f21d3",
|
"signature": null,
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "4.099913145s",
|
"executionTime": "4.099753655s",
|
"resultCount": 0,
|
"resultSize": 0
|
}
|
}
|
|
output
cbq> explain select meta().cas from default where meta().cas is not null;
|
{
|
"requestID": "1b9cda96-a80e-4a55-a782-3a148f0534de",
|
"signature": "json",
|
"results": [
|
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "IndexScan",
|
"covers": [
|
"cover((meta(`default`).`id`))",
|
"cover((meta(`default`).`cas`))"
|
],
|
"index": "meta_3",
|
"keyspace": "default",
|
"namespace": "default",
|
"spans": [
|
{
|
"Range": {
|
"Inclusion": 0,
|
"Low": [
|
"null"
|
]
|
}
|
}
|
],
|
"using": "gsi"
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Filter",
|
"condition": "(cover((meta(`default`).`cas`)) is not null)"
|
},
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "cover((meta(`default`).`cas`))"
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
}
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "12.399836ms",
|
"executionTime": "12.331159ms",
|
"resultCount": 1,
|
"resultSize": 1785
|
}
|
}
|
|
The above select meta().cas shows {} empty results however, making this whole query non-functional?