select statement returns incorrect result for array fields

PUT someindex/_doc/doc1
{
"name":"person1",
"roles":["engineer","consultant"]
}

The below returns both engineer and consultant while it is supposed to return only "engineer”.

select distinct roles from someindex where roles like 'eng%'

This bug is also linked to this post https://discuss.opendistrocommunity.dev/t/apply-match-like-query-on-the-result-of-aggregations/7267/5 