Nope that doesn’t invoke the indexes either
{
“plan”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “IndexScan2”,
“index”: “csrt_primary_index”,
“index_id”: “4918a04554d5b517”,
“keyspace”: “csrt”,
“namespace”: “default”,
“spans”: [
{
“exact”: true,
“range”: [
{
“high”: ““CY””,
“inclusion”: 1,
“low”: ““CX””
}
]
}
],
“using”: “gsi”
},
{
“#operator”: “Fetch”,
“keyspace”: “csrt”,
“namespace”: “default”
},
{
“#operator”: “Parallel”,
“~child”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “Filter”,
“condition”: “(((meta(csrt).id) like “CX%”) and any v in array_range(0, (length((csrt.lst_nm)) - 3), 1) satisfies (substr0(lower((csrt.lst_nm)), (csrt.i), 4) = “dill”) end)”
},
{
“#operator”: “InitialProject”,
“result_terms”: [
{
“expr”: “self”,
“star”: true
}
]
},
{
“#operator”: “FinalProject”
}
]
}
}
]
},
“text”: “SELECT *\r\nFROM csrt\r\nWHERE META().id LIKE “CX%”\r\n AND ANY v IN ARRAY_RANGE(0,LENGTH(lst_nm)-3,1) SATISFIES SUBSTR(LOWER(lst_nm),i,4) = “dill” END;”
}