Description
This works fine in vulcan
create index ixd on default(DISTINCT PAIRS(self)); |
explain SELECT s.* FROM default c JOIN default s ON KEYS c.run_name WHERE s.chain = "BCRh" limit 1; |
"~children": [ |
{
|
"#operator": "DistinctScan", |
"scan": { |
"#operator": "IndexScan", |
"index": "ixd", |
"index_id": "a4a35b29583fa53c", |
"keyspace": "default", |
"namespace": "default", |
"spans": [ |
{
|
"Exact": true, |
"Range": { |
"High": [ |
"[\"chain\", \"BCRh\"]" |
],
|
"Inclusion": 3, |
"Low": [ |
"[\"chain\", \"BCRh\"]" |
]
|
}
|
}
|
],
|
"using": "gsi" |
}
|
}
|
|
The above query should not have selected index ixd and because no predicate on d.
This works fine in vulcan