No index available for ANSI join term error

SQL++
1

Hi all:
I’m trying to do a join on the same bucket. The response always is : “No index available for ANSI join term error”.
The query uses meta().id values:

select *
from Bucket as b1
join Bucket as b2
on meta(b1).id = substr (meta(b2).id, 0, 10)

Error: “No index available for ANSI join term b2” but the Bucket has an index defined on meta().id (obviously)

Thanks a lot in advance and regards,

2

Solved. Thanks a lot

3

The following blog has useful info https://blog.couchbase.com/ansi-join-support-n1ql/