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:
Bucket as b1
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,