Meta(bucket).id like bug

SQL++
1

so this is my query

select meta(bucket) as meta from bucket where
meta(bucket).id like ‘%digital_signature_%’;

this query is supposed to get documents that start with prefix digital_signature_####.

however, it outputs

digital_signature_56 and digital_signatures_counter

where the 2nd document should not be included since there is an ‘s’ after digital_signature and before the underscore.

2

‘_’ is pattern matching character. Try escaping like below.

select meta(bucket) as meta from bucket where 
meta(bucket).id like '%digital\\_signature\\_%';

If you are looking get documents that start with prefix digital_signature_####. The following is right query (remove leading %) and it will perform well.
select meta(bucket) as meta from bucket where meta(bucket).id like 'digital\\_signature\\_%';